Restoring an Import or Export

Restoring for any of the script steps that have the restore option is essentially the same. Simply perform the command manually and then create the script. An important note about restoring imports and exports is knowing exactly what criteria they are able to restore.

Import remembers:

- the file name

- the fields imported

- the order of the fields

- the options like add new records or create records, perform auto-enter options or 
	split repeating fields

Export remembers:

- the file name

- the fields exported

- the order of the fields

Exercise: Create a script that exports your data to a tab-separated file and then imports it back into the same file. This script can be used to quickly duplicate all the records in the current found set.

Restore Import/Export script in RESTORE.fp5

Advanced exercise: Create a script that removes duplicates using the summarize by export feature.

1. Start by creating some duplicate records. In this exercise, the Text Entry field will
	be the field that determines whether the record is a duplicate or not

2. Sort the database by the Text Entry field

3. Export the records using the summarize by feature. When you click the summarize by 
	button in the Export dialog, make sure to check the text Entry field

Summarize by dialog within the Export dialog

4. Import the text file you just exported

5. Create the following script

Delete Duplicates script in RESTORE.fp5

NOTE: It is not advisable to run this script on a database that contains valuable data until you have made a backup. If you happen to have made an error in the script or a power outage occurs while the script is running, you could potentially lose all your data.