Why not just import the records directly into the target table, rather than exporting to an intermediate file and importing that file?
how would script the hosted file to see the GO file on an Ipad
1 of 1 people found this helpful
FMGo can not host a file nor can you import from FMS from FMG. You would have to transfer the file to the server. You could send the file to dropbox from the ipad, place the file in a folder on the server then import from that file.
There is GoZync which will work with FMP http://www.seedcode.com/filemaker-sync-gozync/ or FMS,
MirrorSync requires FMS 360Works MirrorSync: FileMaker Sync for FileMaker Server, FileMaker Pro, and FileMaker Go on iPhone and iPad or FMEasySync requires FMS timdietrich (Tim Dietrich) · GitHub .
FMEasySync is free open-source, MirrorSync will let you sync 1 ipad with 1 database for free, GOZync will also has free version that let you sync 1 database.
I've tried moving a copy of the file to drop box, this will work, but is there a way to script this. I'm worried that there may be too many steps for my end users.
Dropbox does have a api but I have not figured out how to copy a file. Here is a sample from seedcode that show some of what can be done with the api. Dropbox to FileMaker Integration
You can also save-a-copy of the database and email.
There are some email services that use the Dropbox api and will transfer attachment to a folder.
FMGo can not host a file nor can you import from FMS from FMG.
Not sure what you mean. FM Go can transfer records from files hosted by FMS, and records from FM Go can be transferred back to FMS. The process may not use the "export" and "import" script steps, but the data transfers most certainly can be done.
If you can open hosted file with Go, you can import local records from hosted file. See fmgo14_development.pdf
The ipad can not host a databases, the ipad can only be a client.
You can connect to FMS from the ipad but FMS can not connect to the iPad.
I did not state that data could not be transfer, I guess you did not read my post. I gave the methods need to transfer data between the device and computer.
A filemaker server file can import data directly from a FileMaker Go file. There is no need to transfer the file to the server. This is fairly easy to do. In the FileMaker Go file create a file reference to the server file. The use a Perform Script that calls an import script on the server file. Use Get (filepath) as the script parameter. On the server the import script needs two steps:
Set Variable [$path; ; Value:Get(Scriptparameter)
Import Records[No Dialog; "$path"]
You will need to put the FileMaker Go file on your computer so that you can initially Specify the import order in the script step. Once this is done you can move the file to FileMaker Go.
rgordon is correct.
In some cases if there are many records to import, it may be better that run the syncing process individually on server after import with "add records". "Match records" on FMGo is slow.
(Sorry I tested it a bit old time, not on recent iPad/Go14.)
I find with Filemaker, a majority of the time it is not safe to say something can't be done. I've been able to get Filemaker Go to do things that "can't be done".