From Dwayne Wright PMP
Certified FileMaker Developer
Please Note: If you are viewing this page in a news feeder, the images may get munged up a bit or other formatting of the posting may fail. For the best experience, please visit the journal directly by clicking (here).
A READER ASKS
If you would not mind, I have a question that is very critical to me regarding FMP database developing.
Here it is:
I am going to create a very basic database for my business so that my staff can get busy populating it with customer information. Once that is achieved, I want to then create a better database with improved graphics and fields and tables and relationships, etc. My only concern here (and this is where you come in) is how to get all the customers from the 1st, basic database, transferred over into my new one.
Is this possible, and is there a way to create my 1st database with this in mind so that the event of transferring in the future will be more seamless?
Thank you kindly for your time, and I sure do appreciate your Blog.
What I would recommend is get your first pass database complete (or close to it), duplicate it and then use it as the foundation for your 2.0 version. You can then use import routines to migrate data from one system to another.
In complex database systems, sometimes I create an “in between” file. I import data from my source into it and then massage the data until it is suitable to be loaded into my new release version. Then I import from my “in between” file into my final version and do what ever tweaks are necessary. I’ve written about this technique a number of times in different ways. You might want to search my web site for various import and export posts.
More info about the author and FileMaker in general, contact me at firstname.lastname@example.org.
© 2011 - Dwayne Wright - dwaynewright.com
The material on this document is offered AS IS. There is NO REPRESENTATION OR WARRANTY, expressed or implied, nor does any other contributor to this document. WARRANTIES OF MERCHANT ABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE EXPRESSLY DISCLAIMED. Consequential and incidental damages are expressly excluded. FileMaker Pro is the registered trademark of FileMaker Inc.