Using Filemaker Pro 11 Adv:

 

I'm trying to import three different XLS files, each having field names laid out in a different order.The file I'm importing to has all the fields contained in all three files. 

Importing the first file works fluidly, however when I go to import the second or third file, the source fileds and target fields do not match up auomatically and I must manually adjust for each import. 

 

Is there a solution that enables me to save and reuse different source field and target field arrangements for the 3 different file imports?   I'm looking to have it be as simple as a script for - Import File 1, Import File 2, Import File 3.

 

Or....is there some other way to accomplish the above through the import dropdown menu? The three files will be externally updated and each file will need to be imported on a weekly basis.

 

It's gotta be a fairly simple solution, but I'm just not seeing it. Help, Cecil, Help...

You would need to map the three imports separately although they could be in same script. :-)

LaRetta.........you're the best. Thank you for responding.

 

Happen to have a url on mapping imports separately or where I can learn the process?

You would just script all three in script similar to:

#first file

Set Error Capture [ on ]

Import [ map fields etc ]

#second file

Import [ map field to second file ]

... Etc

Thanks again LaRetta.......I looked here also but still not quite getting it. http://www.teamdf.com/weetbicks/tips-hints-scripting/139/

 

Should I find an example of a generic field mapping import script, I could then comprehend and create what I need.

 

Thank you again, you're simply the bestest!

Just create the script-step and open the map, select the file and begin mapping the fields. Have you tried it?

I'm trying it now........I'm just not understanding how to map the fields in the script...hmmmm.........

Double-click Import to insert into the script then select your file then below that is button which opens the map. Map source fields to target fields. :-)

LaRetta, I seriously thank you for your patience and guidance......I'm still plugging away at this............and I'll get it....I just haven't "seen the light" as yet.

If you can provide screen shot or description of specifically what is confusing, we could probably give specific suggestions. :-)

LaRetta, LaRetta, LaRetta......I have seen the light....and now have my 3 scripts working! Thank you so very, very much! It was so simple, I couldn't see it until now.

Sometimes it happens that way ... glad you worked it out!