AnsweredAssumed Answered

Import from one table to another fails in WebDirect

Question asked by JasonPierce on Jan 25, 2017
Latest reply on Jan 25, 2017 by mikebeargie

I have a table-to-table import to copy data from a temporary table to its final home. This works fine in FMP, but in WebDirect I am prompted for an import source file location. Is it supported behavior in WebDirect to use the Import Records script step to copy records from one table to another within the same file?


I have Project-Interface.fmp12 and Project-Data.fmp12 hosted on FMS 15. In the InterfaceFile I have a button that runs a script, and one of those script steps is Perform Script ["Move Processed Import" from file: "DataFile"; Parameter: $scheduleStart].


The "Move Processed Import" script is very simple, just an Import Records command to move data from TempTable to ScheduleItems (both are tables in the DataFile). In this script step I have the data source defined: file:Project-Data.fmp12


Thank you for your assistance,

Jason Pierce