Log

Import

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:

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

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.

Import

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

Date/Time

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

Type

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

Key

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.

Field

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."

Error

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 the "Import ASCII Layouts" chapter of the Deltek Time & Expense with ESS 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 the "Import Staging Table Layouts" chapter of the Deltek Time & Expense with ESS Technical Guide for information on required fields.  An error will occur for required fields that are not supplied.

Select All

Click Select All 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.

Preview/Print

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.  

More

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.

Error Count

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

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 Unit

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

Import Type

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.

Error Message

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.

Source Location

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.

Transaction Type

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.

Please review the "Import ASCII Layouts" chapter of the Deltek Time & Expense with ESS Technical Guide (if importing from ASCII files) or the "Import ASCII Layouts" chapter (if importing from staging tables) for the list of required fields for each file and Transaction Type.

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 the "Import XML Schemas"chapter of the Time & Expense with ESS 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.

Update/Retry

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.

Cancel

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

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.