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

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

Mapping Fields