deninger

Import Records Script forgets field mapping

Discussion created by deninger on May 9, 2013
Latest reply on May 10, 2013 by mikebeargie

I have a script step that is set up to import records from a SQL Server DB into FM using calculated SQL Text. The step works fine only after I have unchecked the "Perform without Dialog" option and set up the mapping the first time.

Right Mapping.jpg

After the first time, I can uncheck the option and the script works flawlessly thereafter.The problem is, that the mapping appears to be forgotton again after I close the file and re-open it.

Wrong Mapping.jpg

 

Is there something I am missing in order to make this stick? Having the end-user navigate these screens would be unacceptible.

Outcomes