Import Console Log

Use this drop-down box to select the import transaction table that you wish to view. Only the import transaction tables that currently have errors display in the drop-down box. The potential options are:

All	UDT01	LINK12
Timesheet Rejections	UDT01 Supervisor	LINK17
Expense Report Rejections	UDT02	LINK19
Expense Report Payment	UDT02 Supervisor	LINK27
Employee	UDT03	LINK29
Employee History	UDT04	LINK93
Employee Leave	UDT05
Employee Group	UDT06
Timesheet Invoices	UDT07
Leave Type	UDT08
Costpoint Company	UDT09
Currency Schedules	UDT10
Per Diem Schedules
Tax Codes
Receipt Images

If you select a different import transaction table from the drop-down box, the Log table will be refreshed with the selected table information.

This non-editable column displays the name of the import file.

This non-editable column displays the date and time of the transaction in error.

This non-editable column displays the type of transaction in error. The options are "Add," "Change," "Delete," and "Batch."

This non-editable column displays the key value(s) of the transaction in error. For example, if an error displays for an employee import transaction, the key value will be the value of the employee ID in error.

This non-editable column displays the field that is in error on the import transaction. For example, if you try to perform an employee import with an Add transaction and the Last Name is not provided, this column will display "Last Name."

This non-editable column displays the actual error for the import transaction. Some of the possible errors are as follows.

Import file layout is invalid.
Import transaction type is invalid.
Add Transaction cannot be processed as a Change Transaction because of a configuration setting.
Change Transaction cannot be processed as an Add Transaction because of a configuration setting.
Record does not exist for this Delete Transaction.
Charge Tree does not exist.
Parent Charge Branch does not exist.
Charge Branch does not exist.
Employee Group does not exist.
Employee does not exist.
Charge does not exist.

See the Notes section at the end of each ASCII layout in Appendix A of the Technical Guide for information on required fields. An error will occur for required fields that are not supplied.

See the Notes section at the end of each Staging Table layout in Appendix B of the Technical Guide for information on required fields. An error will occur for required fields that are not supplied.

Use the Select All pushbutton to select all displayed import transactions. Once selected, the pushbutton will become Deselect All. To select a particular row, select the button to the left of the row to highlight it.

Select the Preview/Print pushbutton to preview the Import Error Log report in Adobe Acrobat format. The log will include all current errors found in the Java Message Service (JMS) queue. Select the printer icon in the .pdf file to print the report.

Select the More pushbutton to display the next set of errors. If you have selected errors before selecting the More pushbutton, the system will display the following message: "Current selection of records will be lost. Do you want to continue?"

If you select Yes, the next set of errors will display and the current selection will be cleared. If you select No, the current selection of errors will remain.

This non-editable field displays the current number of errors.

This non-editable field displays the selected import name from the Log tab.

This non-editable field displays the type of import file that was used for the selected row in the Log tab. For example, if the row originated from an ASCII file, "ASCII" will display.

This non-editable field displays the selected error message from the Log tab. The first 100 characters of the message are displayed. Hover your mouse over the message to display additional characters if they exist.

This non-editable field will display the location of the import file if you selected the ASCII or XML checkbox in the Criteria tab. The first 100 characters of the location are displayed. Hover your mouse over the location to display additional characters if they exist.

This drop-down box displays, as the default, the transaction type of the selected record from the Log tab. The available options are "Batch," "Add," "Change," and "Delete."

Select another type from the drop-down box if necessary. For example, if a "Change" record was in error because the record did not already exist, you could change the type to "Add," supply any required fields that are needed, then select the Update/Retry pushbutton to process the record as an Add transaction.

Note: Please review Appendix A (if importing from ASCII files) or Appendix B (if importing from staging tables) of the Technical guide for the list of required fields for each file and Transaction Type.

Select the Update/Retry pushbutton to close the dialog and to submit the record for processing. The pushbutton will be disabled until Import Data is changed.

Select the Cancel pushbutton to close the dialog without updating or retrying the import record.

Log

Log Table

When the tab is first displayed, all import transactions in error are shown, sorted by import table name, then date and time order.

If an unrecognized element name is found while importing XML files, the following error message will display: "Unrecognized element name encountered while parsing XML. The unrecognized element name is listed in the Field column."

The number of errors displayed is determined by the number supplied in the Max Table Rows field in the General Options tab of the General Configuration screen. If there are more errors to be displayed, a More pushbutton will display on the bottom of the screen.

Edit Transaction

Select an error transaction by clicking on the button to the left of the row, Then select the Edit Transaction function to correct errors in the import record and re-submit the import record for processing.

Import Header

Import Data

The fields that display in the Import Data section depend on the import record being edited. All fields for the particular import record are displayed. A vertical scroll bar is available, if needed.

Instead of field labels for this section, the actual element name as defined in the XML portion of the import process appears as the text for each field. Please see Appendix C of the Technical guide for the element names of all the imported files.

Review the error message received for this record and update the appropriate field so that the record can be submitted for processing.

Retry Transactions

Select an error transaction or transactions by clicking on the button to the left of the row. Then select the Retry Transactions function to resubmit the error transaction(s) for processing. The log table will be refreshed.

Delete Transactions

Select an error transaction or transactions by clicking on the button to the left of the row. Then select the Delete Transactions function to delete the row(s). The system will display the following confirmation: "Are you sure you want to delete this record(s)?"

If you answer Yes, the transactions will be deleted and the log table refreshed. If you answer No, the transactions will not be deleted.

Purge All Transactions

Select the Purge All Transactions function to delete all the error transactions in the system. The system will display the following confirmation: "Are you sure you want to delete this record(s)?"

If you answer Yes, all transactions will be deleted and the log table refreshed. If you answer No, the transactions will not be deleted.

Show Details

This option is available only for general errors. When selected, this option displays a dialog that contains further log details.