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

About Importing Issues

What Can You Import?

How New Records are Created

Before You Import

Importing Issues into a Source Table

Combining Multiple Source Tables

Importing Issues from Projects

Creating Queries to Merge Source Tables