The Import Data window is used by Virtual Ticket Administrators to import data contained in tab delimited text files into the database. Before attempting to import data, review the Data Import Rules, Requirements, and Restrictions section of this guide.
The Import Data window provides the ability for the Administrator toimport data into the database.
Window Objects
See a detailed description of the window
Folder Types
Selector for the various Folder Types corresponding to the data you want to import. Both default and user defined Folder Types are available for selection.
Available Fields
Non-required fields available for the selected Folder Type are listed here. Any fields defined for the selected Folder Type will appear in the Available Fields list, except for File Collector and Thumbnail fields.
Fields to Import
Displays both the required fields for the Folder Type and any available fields added to the list. Required fields appear in boldfacetype. Note that the order of fields in the Fields to Import list can be changed to correspond with the left to right order of your data import text file.
Add Fields
Adds the field selected in the Available Fields list to the Fields to Import list. Fields added to the Fields to Import list will be added beneath any field in the list that is currently highlighted. If no field is highlighted in the Fields to Import list, available fields will be added at the bottom of the Fields to Import list.
Remove Fields
Removes the field selected in the Fields to Import list. Fields that are removed will appear in the Available Fields list. Required fields appear in boldface type and cannot be removed from the Fields to Import list.
Order Fields
Move the selected field up and down in the Fields to Import list. The top to bottom order of the fields in this list should match the left to right order of the fields in each row of your data import file.
Import
Opens the Import File selector window for choosing your import data file.
Close
Closes the Import Data window.
Procedures
Importing data into the database
Warning: Before attempting to import data, it is important to familiarize yourself with the contents of this chapter, particularly the Preparing to Import Data and [VTDA:Data Import Rules, Requirements, and Restrictions] sections.
Open the Import Data window (if it not already) by selecting Import Data... in the Administration menu of the Virtual Ticket desktop client application.
Select the Folder Type corresponding to the data you want to import by clicking the Folder Type selector and selecting a Folder Type from the list. Available Folder Types are described in the Database Families and Folder Types Available for Import section of this guide.
Add any available fields you need to accommodate the data you want to import to the Fields to Import list. Information on adding additional fields to Folder Types is available in the Defining Database Fields for Folder and Document Types section of this guide.
Sort the order of the Fields to Import list. This top to bottom order of the Fields to Import List should correspond to the left to right order of fields in each line of your data import text file.
Click Import. A File Browser window will open, allowing you to browse to and select the data import text file you would like to use for importing data.
Select and Choose the data import text file containing the data you want to import to the database. The file will be imported to the database. If errors are encountered, an error message will displayed. If no errors are encountered, a success message will be displayed and your imported data will be in the database.
E-mail
