tods

Putting the output of 'Export Records' into a container field

Discussion created by tods on Jun 9, 2017
Latest reply on Jun 10, 2017 by siplus

I am trying to make it easier to import and export my tables as I create newer versions of my Filemaker solution.  Here is what I have for my export:

 

Go to Layout ["Service Record" (SRV)]

Show All Records

Export Records [With dialog:off "Service_Records.fmp12"; Unicode (UTF-16)]

Go to Layout [original layout]

Exit Script [Text Result:Get ( LastError)]

 

This ends up saving the 'Service_Records.fmp12' file in my documents folder.  How can I store this in a container field with global storage?  Basically when I'm done running the export, I'll have a temporary container I can grab the file from.

 

Going the other way, for import, I'l like to be able to open my solution of my Filemaker server and drag the 'Service_Records.fmp12' to a container then hit import.  My script will then automatically delete all records from the table, import the data without performing any autocomplete actions and then use 'Set Next Serial Value' to automatically set the serial number.  I've noticed Filemaker takes a long time to do the imports on my Filemaker server compared to when I do the import locally.  I'd like to be able to upload the imported data into my solution on the Filemaker server, then hit import to do it more quickly.

 

Is this even possible?

 

-Tod

Outcomes