About Importing Issues
Vector HelpDesk stores most of its issue data in the tblDts table of the issue database (<project>01.dat for Microsoft Access, <project>01_DAT for SQL Server). To import issue data into this table, use the Import Issues command in the File menu of HelpDesk Admin. The Import Issues dialog shows the following information:
Source table
You import issues from a source table, which could be in Microsoft Access, SQL Server, a delimited text file, or a number of other formats.
Source fields
Source fields are the fields imported from the source table
Destination fields
Destination fields are the fields in the Vector HelpDesk database table tblDts.
Mapped fields
You map source fields to destination fields. When you click Start, the mapping determines how the source fields are copied to the destination fields.
To import issues:
1 Prepare your issue data and the Vector HelpDesk database.
2 Import issue data into a source table.
A source table is an intermediate table that holds the issue data you want to import into tblDts and tblFixInformation.
3 Map the fields in the source table to the fields in tblDts and tblFixInformation.
4 Click Start to create new records in tblDts and tblFixInformation and to copy the imported issues from the source table into these new records.
Related Topics
Importing Issues into a Source Table
Combining Multiple Source Tables
Importing Issues from Projects