Smiley Posted June 6, 2016 Share Posted June 6, 2016 Hi My Solution Lately undergone a major design update (new colors and layouts ) , but fileds weren`t changed. The file with the new design was a cloned copy of the live file. I have several tables with hundreds of fields. How could i import the entire file without have to go through every table seperatly - and first go to that table in order to be able to match it. the name of the tables and field were left untouched just the layout and design changed and it would be major work to copy over to the livew file. I would appreciate if someone has a easy idea. Link to comment Share on other sites More sharing options...
webko Posted June 6, 2016 Share Posted June 6, 2016 You're going to have to bite that bullet - you will have to go to each table and import the data... "Several" tables shouldn't be too much effort - a number of our solutions have more than 20 tables, at which point we script in the import of data as part of the development. Or use a GUI file for the interface and data tables for the data (which have no presentation in them, that's all in the GUI file) aka Separation model. Link to comment Share on other sites More sharing options...
Smiley Posted June 7, 2016 Author Share Posted June 7, 2016 Have like several couples of tables ; circa 45. I have seen lots of discussions about using the separation method - it seems a great idea to me as i frequently update the design - according to my client , but have thousands of records already stored in the file therefore afraid to tamper with. However nowhere have a found a clear instructions how to implement it , would you know where i could read about that? Link to comment Share on other sites More sharing options...
webko Posted June 7, 2016 Share Posted June 7, 2016 Our main system has tables with over 20 million records, so 1000s shouldn't be a huge issue.. Anyway, a basic write up http://www.seedcode.com/pmwiki/pmwiki.php?n=SeedCodeComplete2.SeparationModel Link to comment Share on other sites More sharing options...
Dimitrios Fkiaras Posted March 4, 2020 Share Posted March 4, 2020 What is the basic structure of an import script, to import data from an old version of the app, to a new one? Is there a way to write a loop and import data from all the tables? I have created a set of layouts on my app just for importing and have named them with a prefix. But I can't get the import loop to work. Link to comment Share on other sites More sharing options...
bcooney Posted March 4, 2020 Share Posted March 4, 2020 This is an old thread. Now, we have available to us the data migration tool, which replaces the need for imports. https://fmhelp.filemaker.com/docs/edition/en/migration/index.html Link to comment Share on other sites More sharing options...
Dimitrios Posted March 4, 2020 Share Posted March 4, 2020 Thanks a lot for the response. I was hoping to cope with the matter with the FM huild in tools though. Link to comment Share on other sites More sharing options...
bcooney Posted March 4, 2020 Share Posted March 4, 2020 It's a product by FileMaker. Much better than scripted imports. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 1513 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now