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,
WebDirect has much different capabilities for the import records script step.
The guide on page 10 mentions why:
Have you tried wrapping it in "perform script on server" instead? If you get that working on the desktop then it should also work on WebDirect.