Import ODBC DSN Files

You can import ODBC DSN files from outside sources into GovWin Capture Management.

Prerequisites: To import ODBC DSN files, you must set up the ODBC driver as the System DSN on the GovWin Capture Management Application server. The database source must be in a folder that the server has access to, so that you can select it when you set up the System DSN. Your IT staff may be needed for initial setup. Common databases include SQL Server and Access.

To import ODBC DSN files, you may need to enter a valid user ID and password. Only some ODBC DSNs require a user ID and password, depending on the data source for that DSN.

Follow these guidelines:

• GovWin Capture Management only supports System DSN; it does not support File DSN.
• The names of the source fields cannot contain any spaces or punctuation.
• To import a default value for a standard area of GovWin Capture Management such as a check box, place the value in single quotation marks in the Expression field.

To import ODBC DSN files:

1. From the GovWin Capture Management Navigation menu, click Utilities > Advanced Utilities > Data Import.
2. In the Table Description field on the Import Utility form, select a table type.
   Note: The default data entry tables that display in the Table Description drop-down are not applicable to the GovWin Capture Management application. To access the GovWin Capture Management Info Center tables you must have a password. Please contact Deltek Customer Care to obtain a password.

   By default, this field lists only data entry type tables. However, if you have the proper security access, you can also access other types of tables. To do this, hold down CTRL + SHIFT and click on the screen. GovWin Capture Management displays a Password dialog box. Enter your valid password and click OK.

3. In the From field, select ODBC DSN.
4. In the Input Table Name field, specify the name of the temporary GovWin Capture Management table that stores the validated or error records before they are imported to the final destination in GovWin Capture Management. Ensure that the table name does not contain a period or other special characters.
5. Complete the fields on the Main tab.
6. Complete the fields on the ODBC Fields Mapping tab. This tab is available only if you set the From field to ODBC DSN. You can save the settings on this form, so that you can apply them the next time you load a file of the same data type. (You can change the saved settings.)
7. Click Validate. GovWin Capture Management verifies the source data and inserts both the valid and error records into the temporary table that you specified on the Main tab.
8. Correct any records that require correction and re-validate them.
9. Click Import. GovWin Capture Management verifies the source data and inserts the records into the final destination in GovWin Capture Management.