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