Export data
This function allows you to unload data from your database into text files. This is useful for checking your data, making backups and for transferring data to another database or a different computer system.
To run this function: Choose Survey > Survey database > Export data, or...
Database Name
The name of the current database is displayed and cannot be changed.
Format File Name
Enter the name of the format file, or choose it with the file browser. If this file does not currently exist, the CONFIRM CREATION OF NEW FORMAT FILE form will be displayed.
If the format file already exists the UNLOAD TABLES FROM TEXT FILES form will be displayed.
Table Name
This is a display only field in which list all the tables contained in the format file.
Text File Name
This is where you input the name of the text files which you wish to unload into. If a text file already exists you will be prompted for overwrite confirmation.
You can leave this field blank if you don't want to unload a particular table. This feature enables you to reuse format files where there are more tables included than you want to unload at a particular time.
After you specify the text files choose Apply to display the DEFINE QUERY CONSTRAINTS form. Choose Cancel to return to the SURVEYING menu.
You have the option of constraining the data that you will be unloading. If you do not wish to constrain the data leave the DEFINE QUERY CONSTRAINTS form blank. See DELETE TABLE ROW for further information about the inputs for the DEFINE QUERY CONSTRAINTS form.
Choose Apply to begin unloading the database or choose Cancel to return to the SURVEYING menu.
Messages
Unload progress messages will be displayed in the message window. An unload completion message will be displayed for each table being unloaded and a final completion message is displayed when the unload process has finished.
Result
All of the data from the tables you are unloading will be written out to specified text files. The data will still be present in the your database tables as well.