How Records are Created

When you click the Start button, Vector HelpDesk creates new records in tblDts and tblFixInformation, and copies the data from the source table into the new records.

In general, if there is no mapping for a field or the imported data is invalid, Vector HelpDesk leaves the field blank. However, there are exceptions. The following summarizes how Vector HelpDesk handles fields when it creates new issues.

Issue Number

You cannot import issue numbers. Vector HelpDesk automatically assigns issue numbers to issues.

Owner (nUserID)

You can import the full name of a user or the ID of the user in tblUsr.

If there is no mapping or the user name is not found in tblUsr, the field is left blank.

Submitter (nSubmitterID)

You can import the full name of a user or the ID of the user in tblUsr.

If there is no mapping or the user name is not found in tblUsr, the name of the current user is stored in the field.

Contact (nOriginatorID)

You can import the full name of a user or the ID of the user in tblUsr.

If there is no mapping or the user name is not found in tblUsr, the name of the current user is stored in the field.

Progress

You can import the ID of a choice value or the choice text. If there is no mapping for a choice list field, Vector HelpDesk sets the Progress field to the choice with ID = 0 (by default, New).

State

You cannot import State values. sets the State field based on the Progress field.

Time and Date fields

You can import time and date values. If you do not map a date or time field, Vector HelpDesk sets the field to the current date or time. See the tblSubstate choice table for the mapping of Progress values to State values.

The Closed Date field value is imported only if the State is Closed.

Imported date values should use the format yyyy/mm/dd.

Imported time values should use the time format specified in the Regional Options of Windows Control Panel.

Choice lists

You can import either the choice ID (the nID of the choice in the Vector HelpDesk choice table) or the choice text.

Related Topics

About Importing Issues

What Can You Import?

Before You Import

Importing Issues into a Source Table

Combining Multiple Source Tables

Importing Issues from Projects

Creating Queries to Merge Source Tables

Mapping Fields