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
Importing Issues into a Source Table
Combining Multiple Source Tables
Importing Issues from Projects