I have the same challenge as you describe. The way I do it, is to create a (quite big) script that does among various other things, also (semi) automatic mapping. To do that youneed to make some plugins accessible via gscript.
If you know some programming, I guess you can figure out what parts to use from my script, see Michel Keijzers - Template Rackspace