Variety of Disparate Databases

[rbaron123]

My Client works with a variety of different manufacturers, each with their own CSV file that I need to import into a master Filemaker Database. Because the fields are different from each manufacturer, I have to manually rename the fields of the manufacturers to match the Filemaker fields.

Is there a script to rename Filemaker field names?

[IdealData]

Make a script for each manufacturer. You can store the field order separately for each script.

[mr_vodka]

Well you can script each of your imports for each different manufacturer file which can store the import order as long as the files are consistent for each manufactuer.

**Edit: Sorry Ideal, typed the reply and walked away from my computer for about an hour and just hit the button to add the reply.

Edited January 29, 2009 by Guest