Export Collection to File dialog box

Use this dialog box to export the current collection to an external file that can be imported into another application. The exported file can be formatted as either comma-separated or tab-separated. Each record in the collection becomes a row in the exported file. Each field (property) becomes a column in the exported file.

This table lists the elements in this dialog box and explains their use.

Element Function/Comments
Source Collection If different from the one that is displayed, select from the drop-down list the name of the collection you want to export.

If you do not know the name of the collection, return to the form and click a section of the form that displays the collection. Then, to see the name of the current collection, click Help > About This Form.

Select whether to export the primary collection, secondary collections, or subcollections on the form.

Cap Option
  • From data currently in the collection: Exports only the records currently displayed in the collection.
  • Unlimited query: Retrieves from the database all records that match the current filter criteria and exports them.
Output File Type
  • Comma-separated: Places a set of double-quotes around each string item and then separates all items with commas, for example:
    
    "doejo",4,"",1,"john.doe@acmemfg.com","", 
  • Tab-separated: Separates record items with tabs, for example:
    
    doejo      4               1       john.doe@acmemfg.com             
    Note: Make sure that the external application in which you want to view the collection supports the format you select here.
Output File Name Specify the full path and file name of the external file being created.
Note: The file extension .csv is used regardless of the chosen output file type.

If you do not specify a file name, the name of the selected collection is used.

Note: If you do not specify a path, the system saves the file in the My Documents folder by default. If you have previously selected a folder, that folder is used as the default.
Browse

The text box for the path is set to the default path when this dialog appears. The default path is the last folder that was selected in a previous export operation.

If no path is specified when you attempt to save the file, this dialog prompts you to specify the destination folder. Click this button to locate the folder where the file is to be saved.

To access this dialog box, select Form > Export to File.