Hi I created a new layout in filemaker 14. I need to upload old database into new layout. how do I do this everytime I do this it duplicates so if I have 803 records, I then have 1606. please help
Please clarify what you mean by "upload old database into new layout"..its not really clear what you are trying to do or do to produce the duplicates.
I'm guessing that you are using import functionality... if that is the case you just need to learn the options in the import dialog for matching based on fields..
Of course this is a guess.
You might want to post the file and explicit directions on how to reproduce the condition.
I created a new layout in a new icon on my desktop as not to disrupt are current layout while I was creating the new one. I am all set with the new layout and want import database which has is the most up to date information. I have done it before but have not touched in a few months and cant remember how I got new database in to the file.
Assistant to Bill Mann
This is still not quite clear. Creating a new layout doesn't necessitate "uploading" or importing.
icon for what? still not very clear to me.. sorry.
You should get and work through the FileMaker training series.
If nothing else it will help you to get the FileMaker "lingo" so we can help you better.
I need to bring old database into new database. do I export into an excel file and then import into new database?
I have an icon on my desktop called new filemaker 2013 with a database called 6-23-2007. I created a new icon called new filemaker 2016 when I got filemaker 14. I created a new database in it. I need the information from the database 6-23-2007 imported in new filemaker 2016.
reference this thread for continuation
bringing old table into new database
You said: "I created a new icon called new filemaker 2016 when I got filemaker 14."
If the "new icon" is just the old file renamed, all those records from the first file should still be in the new file. If you created the "new layout" from an existing table, the records should appear on the new layout. No import should be necessary. You have 1606 records because you imported the original 803 into the new file, so now you have 2 of each record.
As an addendum to my previous post, here's a good way to get rid of the 803 new records:
(First create a back up of your file in case something goes haywire.)
Hopefully, the table has a timestamp field for the creation of each record. Put this field on your new layout. Chances are the 803 new records were created on a date and time that will be different from the 803 original records. Since they were imported, the new records will have timestamp values within the same second or 2. Just do a find in the timestamp creation field for those newest records. You can just find by date (today, for example) if you are sure non of the existing records were created today also. When you have found the newest 803, just delete them and you will be back to the original 803.
thank you all for your help. I finally got it to work....I tried so many things that I don't remember which import worked. Thanks. Love this support.
Retrieving data ...