You would have to do this through scripting...
you could have a separate database that does the importing and upgrading for you... You can't do it within your current database because you have to overwrite it..
- Export all your current working database to your migration database..
- Then download a new copy of the database to your iPad... (overwrite the current one)
- import the data from your migration database to your new database.. and done..
FYI- Gozync does the upgrade process automatically for you... You would have to do the import/export yet though.. If it is a hosted solution you might want to look into using gozync... If it is hosted and you use gozync.. that's it.. no importing/exporting.. It's syncing instead.. (not sure if this is an option for you..)
Thanks for the reply. Am aware of hosting as a possibility but at the moment that's not the route am using.
Understand the idea you have outlined but can you give me some clues to the scripting in the sense of the file paths which is the bit I can't get my head around. I can do the scripting of import/export just don't know how to reference the files on the ipad.
To get the file path.. use this in your script: - Get(FilePath) - http://www.filemaker.com/help/html/func_ref2.32.28.html also here http://www.filemaker.com/help/11/fmp/html/create_db.8.32.html
Then set the variable.. with the path... so you can call it later..
On the iPad it is simply.. file:filename.fmp12
using this script
Import Records ["PsychTestOriginal.fmp12"; Add; Mac Roman]
and attaching to a button does nothing at all on the iPad with 2 files in FM GO, PyschTestOriginal and PsychTestNew
Take a look at page 8 here: https://fmhelp.filemaker.com/docs/13/en/fmgo13_development.pdf
You are missing some of the parameters...
Create an “Import to Remote” script in Target.fmp12. For example:
Set Variable[$FilePath;Value:Get(DocumentsPath) & “Source.fmp12”]
Import Records[No dialog; “$FilePath”; Add; Mac Roman] where the path to the source file on the device is file:$FilePath
That hasn't worked either I'm afraid.
What does the Get (DocumentsPath) part refer to? Is that the the file that is open (PsychTestNew)? Can I not refer to it by name?
Andy, See My post on your post named: FM Go: Local to Local file import