Importing Issues from Projects

In Vector HelpDesk projects, issue data may be split across two tables (tblDts and tblFixInformation) in the issue database.

You need to merge the two tables before you can map the fields.

To import issues from Microsoft Access .dat files:

1    Click Add tblDts and tblFixInformation to the list of source tables.

2    In the Source Table list, click qryMergeCensusTables.

This query adds the combined fields from tblDts and tblFixInformation to the Source Fields list.

3    Click Auto Map, and then click Start.

To import issues from a SQL Server issue database:

1    Add dbo.tblDts and dbo.tblFixInformation to the list of source tables.

The source tables are named dbo_tblDts and dbo_tblFixInformation.

2    Create a new query to merge dbo_tblDts and dbo_tblFixInformation.

3    In the Source Table list, click the new query.

This query adds the combined fields from dbo_tblDts and dbo_tblFixInformation to the Source Fields list.

4    Click Auto Map, and then click Start.

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

Creating Queries to Merge Source Tables

Mapping Fields