Use the Main tab to select the type of table you want import, how the table will be structured, and how the import will work.
Contents
| Field | Description |
|---|
| Table Description
|
From the drop-down list, select the table type that you want to import.
The drop-down list displays all data types to which you have security access. You define transaction security rights on the Accounting Tab of
. On this tab, you must select either the
Full Access to All Transaction Types option, or use the Transaction Type grid to select the
Post option for the company and type of transaction.
|
| From
|
Select the format of the input file:
-
Text — Select this option if the file you are importing is a text file.
GovWin Capture Management activates the fields associated with this option, as well as the Text File Fields Mapping tab.
-
ODBC DS — Select this option if the file you are importing is through an ODBC DSN connection.
GovWin Capture Management activates the fields associated with this option, as well as the ODBC DSN Fields Mapping tab.
-
GovWin Capture Management Table — Select this option of you are importing data from a
GovWin Capture Management table that stores the validated or corrected error records.
GovWin Capture Management activates the
GovWin Capture Management Table Name field.
|
| Input Table Name
|
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.
|
| Text File Fields
|
|
| Field Delimiter
|
If the file has delimiters, select the delimiter you used.
|
| Text Qualifier
|
If the file contains text qualifiers, select the qualifier you used.
|
| Decimal Symbol
|
Enter the character you used to represent the decimal point if other than a period.
|
| Date Handling
|
Specify how you want
GovWin Capture Management to format dates:
-
Order — Select the order in which you want the month, day, and year to appear in dates.
-
Delimiter — Enter the character that you want to use as the separator between month, day, and year.
-
Leading Zeros — Select this check box if you want leading zeros for 1-digit months or days (01 for January, rather than
1, for example).
-
Four Digit Years — Select this check box if you want
GovWin Capture Management to use all four digits of the year (2015 rather than
15, for example).
|
ODBC DSN Fields
| Field | Description |
|---|
| ODBC DSN
|
From the drop-down list, select the data source name.
|
| DSN Table Name
|
From the drop-down list, select a specific table in the database that the data source connects to.
|
| User ID
|
To import ODBC DSN files, you may need to enter a valid user ID and password. Only some of the ODBC DSNs require a user ID and password, depending on the data source for that DSN. For example, the ID and password are required if the data source is SQL Server.
|
| Password
|
To import ODBC DSN files, you may need to enter a valid user ID and password. Only some of the ODBC DSNs require a user ID and password, depending on the data source for that DSN. For example, the ID and password are required if the data source is SQL Server.
|
| Deltek
GovWin Capture Management Table Fields
|
Contact your
GovWin Capture Management representative for more information about this table.
|
| GovWin Capture Management Table Name
|
Select the
GovWin Capture Management table that stores validated or corrected error records.
|
| Allow Updates
|
If you check this box,
GovWin Capture Management treats any duplicate record as an update, rather than an error. If you do not check this box,
GovWin Capture Management performs an Insert and if there is any duplicate record, it is treated as an error.
In general, you can only update CRM Info Center tables. If a table cannot be updated, this option is not available.
|
