Templates define what data is imported and how it is imported to the Time & Attendance module application. You must use templates to import data. Your ADP Time & Attendance Representative has set up import templates for each type of data that can be imported to the Time & Attendance module. However, you may need to create new templates to customize the way data is imported. For example, you might create a new template to import department data using the ASCII fixed format instead of the ASCII delimited format.

The following procedure explains how to create an import template for employee data, but you can also use this procedure to create templates for other data types.

To create an import template:

  1. From the Time & Attendance menu, select Maintenance.

    Note: If the Maintenance option is not visible, make sure that you have selected Practitioner in the Role Selector.

  2. Under the Imports heading on the Maintenance page, click the Imports link.

  3. On the Recent Imports page, click the Import Templates menu item on the left side of the page.

  4. On the right side of the page, click the New Template button.

  5. From the Select a predefined import type drop-down menu on the New Import Template page, select Employee. To create a template for a different type of data, select a different import type.

  6. From the Select a predefined import format drop-down menu, select an import format. The available formats depend on the import type you selected in the previous step.

    Notes:
    The Time & Attendance module application supports three formats, but not all of these may be available for the import type you selected and/or your company’s configuration. The three supported formats are:

    ASCII Delimited
    - In this format, each field in the import is separated from the next by a comma. An example of this format is: Social Security Number, Payroll ID, Last Name.

    ASCII Fixed
    - In this format, data is imported using specific character positions in the file to represent specific items. An example of this format is: characters 1-9 = employee ID, characters 10-16 = Payroll ID, and so on.

    Delimited with Header
    - In this format, the import includes a header row followed by tabular data that is delimited with commas. This option allows greater flexibility for the ordering of data and accommodates the use of third party applications as data sources.

  7. In the Template ID field, enter an ID that will help you easily identify the template. The template ID can be a maximum of 25 characters and can be any combination of numbers, uppercase letters, and lowercase letters

  8. In the Enter a description for this data import field, enter a short phrase that clearly identifies the data you are importing. For example, if you are importing exempt employees, you might enter "Exempt Employee Import." You must enter a description for each culture supported by your company. This is a required field.

  9. In the User to Receive Inbox Message on Completion field, click the Select button. In the User Lookup window, select the Time & Attendance module user whom you want to receive Inbox message when the import is complete. The Inbox message will include the number of records added, the number of records updated, and the number of records skipped due to errors. This is an optional field.

  10. In the E-mail Address for Additional Notification of Completion field, enter the e-mail address to which you want an e-mail message sent when the import is complete. The e-mail message will include the number of records added, the number of records updated, and the number of records skipped due to errors. This is an optional field.

  11. In the Specify the default import file path field, enter the path to the file you want the template to import. If necessary, you can change this path when you create an import using this template. This is an optional field.

  12. Click the Select to override employee accruals with imported values check box to replace employees' existing accrual totals with accrual totals from the imported file. If this box is not checked, accrual totals from the imported file are added to existing accrual totals. This check box is only available if you are creating an employee import template.

  13. Click the Select to update permanent employee security groups check box to replace employees' existing security group assignments with security groups assignments from the imported file. If this box is not checked, security group assignments from the imported file are added to existing security group assignments. This check box is only available if you are creating an employee import template.

  14. If you are importing employees and you want to automatically create user accounts for the imported employees, leave the Select to create a new user for each new employee check box selected. This box is checked by default. If you do not want to automatically create a new user account for each employee that is imported, remove the check from the box. This check box is only available if you are creating an employee import template.

    Notes:
    If you choose to have user accounts created automatically, the Time & Attendance module creates a user ID and password identical to the employee ID for each new employee included in the import.

    This option is intended for companies that do not require user IDs to be different from the employee IDs, or who do not already have user information available. Companies that require distinct user IDs or already have user information available can clear this box and import existing user information with the user import template.

  15. Click the Submit button.