Exporting and Importing Data.

[FmZerocool]

:( Hi I hope I can be very clear about our issue.

We are converting our FileMaker 6 system onto FileMaker 11. We have converted and troubleshoot all the code and most scripts and functionality seem to be functioning correctly. We have 100+ databases, and we are in the importing data stage.

We have decided that the most efficient way to avoid any data loss is to convert the files with all the data, do a consistency check and recovery to see if the is any corruption and then import these from the fp7 files to the already converted empty fp7 files.

I believe that the best way to import this data is by creating a script that looks at the fp7 file with all the data and imports this on a click of the button.

Now the question is: Can you call a filemaker file to be imported with all the matching fields automatically or does the user need to interact matching the fields during the import.

Anyone has any better ideas on how we can export and import the data avoiding any data loss?

Thanks

Alberto

[Matthew F]

Can you call a filemaker file to be imported with all the matching fields automatically or does the user need to interact matching the fields during the import.

Are you sure that 100% of the fields have matching names? If so you can do this 'automatically' by setting 'Perform without Dialog' in the Import script step. Also you would specify the import order to be arranged by matching names.

However, I would be hesitant to do this until you've verified it against every table. I'd rather have the opportunity to visually confirm the matching field names before allowing the import to proceed.

[FmZerocool]

Thank you mfero for your response. As I am sure all the fields are not going to be 100% matching due to the conversion I have created a script that at the point of import it shows you the dialog for me to manually match the fields, this may take a little longer but I will be sure that all the data is imported and it is correct.