Import Work Schedules From Deltek Time and Expense
Use the Import Work Schedules from Deltek Time and Expense screen to import work schedule data directly from Deltek Time & Expense or via a comma-separated value (.csv) input file.
You can add new work schedules, update work schedules, or both. If Costpoint has a direct link to Time & Expense, you can select from a range of work schedules and dates.
Important Notes:
- When importing, records are updated or added to the WORK_SCH table; no deletions are made. In the WORK_SCH_DATE table, only the years being imported are deleted and replaced.
- The import file must have at least one Specific Date record for the year being imported. If the input file contains only Day of Week records, the application cannot determine the date. For more information, see the documentation for the Type field in the Manage Work Schedules screen.
- This application can import only non-employee work schedules. It cannot import work schedules that were created for specific employees.
- You must add work schedules to Deltek Time & Expense before importing them here.
- This is a separately licensed product for the current release of Deltek Costpoint.
There are two ways to work with input files in Costpoint:
- You can access the input file from the network by using Alternate File Locations.
- You can upload the input file to the Costpoint database; in which case, no further access to network folders is necessary.
If you decide to use the first option, click in the File Location field to select an alternate file location. If you choose the second option, leave the File Location field blank and use the File Upload Manager to upload the input file to the Costpoint database.
- Related Topics:
- Display the Import Work Schedules From Deltek Time and Expense Screen
You access the Import Work Schedules from Deltek Time and Expense screen from the People domain. - Contents of the Import Work Schedules From Deltek Time and Expense Screen
Use the fields and options to configure the Import Work Schedules from Deltek Time and Expense screen. - Table Information for the Import Work Schedules From Deltek Time and Expense Screen
Changes to the Import Work Schedules from Deltek Time and Expense screen update the WORK_SCH table. - Warnings
The following warning messages can display on the screen. - Errors
The following error messages can display on the screen. - File Layout
You name the work schedules input file when you import work schedules from Deltek Time and Expense.
Parent Topic: Timesheet Interface