Use the Main tab to select the type of table that 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 that you are importing is a text file.
DPS 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.
DPS activates the fields associated with this option, as well as the ODBC DSN Fields Mapping tab.
-
DPS Table: Select this option if you are importing data from a
DPS table that stores the validated or corrected error records.
DPS activates the
DPS Table Name field.
|
| Input Table Name
|
Specify the name of the temporary
DPS table that stores the validated or error records before they are imported to the final destination in
DPS.
|
| 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 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 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
DPS Table Fields
|
Contact your Deltek representative for more information about this table.
|
| DPS Table Name
|
Select the
DPS table that stores validated or corrected error records.
|
| Allow Updates
|
If you check this box,
DPS treats any duplicate record as an update, rather than an error. If you do not check this box,
DPS 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.
|
