updating filemaker pro database from older version

You're the developer! So presumably you know the names of each & every table, and also of at least one layout for each table whereby the layout is NATIVE to at least some table occurrence OF that table, yes? SoĮxit Script [with script result Get(FoundCount)Ĭall that script in oldversion of your file FROM newversion of your file, looping through all the necessary layouts in a script like so:

I'm really lost on this one and any help would be great! I understand that the script needs to go to each layout table to export its content but how can it be automated without the use of the user? So I have all tables double and one version for import. It's to advanced for me.Īt the moment I made specific import tables with only the necessary fields. I do wonder if there is a sample file or a little better explanation. Hi I just found this post and I have the same problem to import lots of fields and about 20 different tables.

Repeat for all tables, (and files if multiple files).įinally, create a script that will either use AppleScript to do shell script or Send Even to cmd, and issue appropriate command line instrux to rename each file in your solution that would be IN a folder NAMED 'Old MySolution', ON the user's Desktop, from FileName.fp7 to FileName OLD.fp7, and hook that script up to an Update button. Now write a routine in your live file that goes to a layout that is native to a table, for each table in the file, and from that layout call as a subscript the script in FileName OLD that goes to the layout of the same name and shows all and exits wtih foundcount store Get(ScriptResult) in a $variable and then import, matching names, from FileName OLD, same table of course, trap for Get(FoundCount) when done, sort by auto-enter serial and set next serial value to highest plus one, then go to a results screen and record that you just imported from ThatTable with sourcefile foundcount, destination foundcount, duration it took, etc. To each file in your solution, add it's respective FileName OLD to Manage -> External Data Sources. Create a script that goes to Layout named in Get(ScriptParameter), does a Show All Records there, and finishes up with Exit Script w/result Get(FoundCount)Ĭlone your db file(s) and give it/them names according to a rule, such as where FileName.fp7 is existing file's name, 'FileName OLD.fp7'

Updating filemaker pro database from older version