Mapping Import Fields
After you create a source table, you must define a mapping between the fields in the source table and the fields in tblDts and tblFixInformation. Vector HelpDesk uses this mapping to copy the imported data into the new records it creates in tblDts and tblFixInformation.
To map a source field to a destination field:
1 Click a field in the Source Fields list.
2 Click a field in the Destination Fields list. The data in the source field is copied to this field when you click the Start button.
3 Click the right arrow button to map the fields.
To remove a mapping:
1 In the Mapped Fields list, click a mapping.
2 Click the left arrow button.
Mapping Text Fields
Text fields, such as tBriefDescription, have a limit of 255 characters. Memo fields store large numbers of characters (in Access, up to 64000 characters; in SQL Server, up to maximum length of 231-1 (2,147,483,647) characters).
Mapping Memo Fields
Import data into the mDetailedDescription and Activity$Log fields, not into the Description$Input and Activity fields.
Importing Choice Lists
Import either the choice text or the numeric ID of the choice in the choice table.
Importing Users, Submitters, and Contacts
Import either the full name of a user, or the numeric ID for that user in the tblUser table (users database).
Related Topics
Importing Issues into a Source Table
Combining Multiple Source Tables
Importing Issues from Projects
Creating Queries to Merge Source Tables