Jump to content

Importing Entire File

Recommended Posts


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 post
Share on other sites

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 post
Share on other sites

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 post
Share on other sites
  • 3 years later...

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 post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.