Field Mapping Question/problem From Runtime To Runtime

[Rich S]

Greets, all, and happy holidays:

I'm stuck: I'm trying to import from one runtime to another (both v11.x) using identical field names. When I manually go through the motions of importing data from the Contacts table the Source fields appear and I can use Matching Names to import the data--works fine.

However...

When scripted (see attached), I get a blank Source field window pane so records aren't subsequently imported. What am I missing in setting up the script so all the fields/records will import?

Thanks tons,

Rich

Script.pdf

[bcooney]

You need to add a source file to the Import script step in order to specify the mappings. After they are mapped, you can delete the "hard-coded" source file and replace it with a $var. Define the $var in the script steps preceding the import step.

Have you seen this thread:

http://fmforums.com/forum/topic/67323-export-import-help-please/page__view__findpost__p__319590

[Rich S]

No, I haven't, so thank you very much! I'm checking it out as I type. (I may not be competent but at least I can multi-task.)

Quick question: When importing from the another runtime--which happens to require a username and password to open, and it has multiple tables--is there an easy way of getting around the user having to enter their login info before importing each table? As you mentioned in the other thread, opening the other file, first, can cause one to import only found records...which may be a moot point because if I remember correctly (or perhaps not) you can't have more than one runtime open at a given time, anyway.

[bcooney]

My runtimes always auto-opened. Perhaps you can use the admin credentials or an account specific to this purpose in the script? Just be sure that the priv set allows for export.

[Rich S]

My runtimes always auto-opened. Perhaps you can use the admin credentials or an account specific to this purpose in the script? Just be sure that the priv set allows for export.

I like the specific account suggestion--good thinking!

I'm still having the same problem with the import after tweaking the script so I'll keep plugging away. ("Never give up!, never surrender!") I did as you instructed and "hard-coded" the file location before using a variable but to no avail.)

Thanks again for your help and happy holidays!