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
|
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.
Deltek 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.
Deltek activates the fields associated with this option, as well as the ODBC DSN Fields Mapping tab.
-
Deltek Table: Select this option if you are importing data from a
Deltek table that stores the validated or corrected error records.
Deltek activates the
Deltek Table Name field.
|
| Input Table Name
|
Specify the name of the temporary
Deltek table that stores the validated or error records before they are imported to the final destination in
Deltek.
|
| 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
Deltek 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
Deltek to use all four digits of the year (2015 rather than
15, for example).
|
ODBC DSN Fields
| Field | Description |
|---|
| ODBC DSN
|
Select the data source name.
|
| DSN Table Name
|
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
Deltek Table Fields
|
Contact your
Deltek representative for more information about this table.
|
| Deltek Table Name
|
Select the
Deltek table that stores validated or corrected error records.
|
| Allow Updates
|
If you check this box,
Deltek treats any duplicate record as an update, rather than an error. If you do not check this box,
Deltek performs an Insert and if there is any duplicate record, it is treated as an error.
In general, you can only update hub tables. If a table cannot be updated, this option is not available.
|
| Align time phased data to the plan's accordion calendar settings
|
This field is available for the following data imports:
-
Project Plan - Planned
Labor
-
Project Plan - Baseline
Labor
-
Project Plan - Planned Expense
-
Project Plan - Baseline Expense
-
Project Plan - Planned
Consultant
-
Project Plan - Baseline
Consultant
When you select this option, the newly imported Time Phased Data (TPD) numbers are aligned to the plan's accordion calendar settings.
|
