Importing transaction files

If you are using a standalone third-party legacy system, or if an occasion arises when you need to import transaction files directly to e-timecard, the transaction file import updates the following tables.

e-timecard transactions files

File name

Description

Action

ETTCH1

Time card header 1

Reloaded each import

ETTCH2

Time card header 2

Reloaded each import

ETTCED

Time card detail

Reloaded each import

You can load transaction data from a legacy system by using the Import from Third Party program, as shown below. See the online JAMIS e-timecard table definitions for the file layouts that the import program requires.

To import transaction files from a third-party product

  1. From the JAMIS Administration home page > Daily Processes tab, under Interfaces, click Import from Third Party. Or, from the top of any JAMIS Administration screen, click Interfaces > Import from Third Party. The Import from Third Party to e-timecard/e-xpense screen appears.

  2. Click the dropdown arrow for Table Name and select +JTTF=e-timecard Transaction Files.

  3. In the Location field, the path to the ASCII file that you created in your third-party software defaults from the Input Location of Interface File field on the e-timecard Initialization screen, Interface Options tab. You can change the path for this import if you wish.

  4. In the Delimiter field, enter the delimiter for your ASCII file. The default is a comma.

  5. Click OK to run the import.

  6. The Process Queue Setup screen appears. You can change the default options if necessary.

  7. Click OK.

  8. A dialog box appears with the process ID. Make a note of it and click OK. The program runs the import and places your process in the process queue.

  9. From the top of the screen, click Management > Process Queue. The Process Queue Management screen appears. Under Filters, your user ID and the status of Not Completed default, and the bottom section of the screen automatically lists processes that match these criteria.

    Hint:     If you do not see your process, select a different status from the dropdown list, then click Retrieve. For example, if you think that your process may be finished, select Completed. If you have trouble finding your process, you can select All to view all processes, though this may result in a large list.

  10. Look for your process ID to view the status of the import. The Status column shows that the process is pending, running, or failed.