Viewing import or export transactions

To view import or export transactions:

  1. Do one of the following:
    • To view import transactions, select Maintenance > System Administration > Interfaces > Import Transactions.
    • To view export transactions, select Maintenance > System Administration > Interfaces > Export Transactions

    This information is displayed:

    Create Date
    The date that the CSV file was scheduled to be imported into or exported from the staging table.
    Start Date
    The date that the transaction began importing records from the file into the staging table or began exporting records from the staging table into the file.
    End Date
    The date that the transaction finished importing records into the staging table or finished exporting records from the staging table.
    File Name
    The name of the CSV import file that is scheduled to be imported into the staging table or scheduled to be exported from the staging table.
    Interface Type
    The type of import or export being performed.
    Transaction Status
    Displays the status of a file import or export:
    • SUCCESS: The entire file was processed without errors.
    • FAILURE: At least one record in the file contains an error.
    • PENDING: The data is still in the staging table and has not been processed to be added to the application tables or has not been exported to the export file.
    Message
    Displays error message information to help you identify the general source of the problem.
    Type
    Indicates whether an import or export transaction was processed.
  2. Click Edit next to a transaction entry to view the details of the transaction.
    This information is displayed:
    Status
    The status of the record:
    • APPLIED: The transaction has been imported or exported without errors.
    • PENDING (for imports only): The record has been inserted into the import staging table and has not been processed into the application tables. The next interface task for this interface type processes this record and attempts to insert the record into the respective application table.
    • ERROR: There was an error during the import or export. The record was not imported or exported.
    • WARNING: There was an error with the import record, but the data was still imported into the application.
    Message
    Displays error message information to help you identify the general source of the problem.
    Proc Date
    The date on which the import or export file is processed.
    Columns A-CZ
    Correspond to the fields in the import or export CSV file.
For Payroll Exports, using the staging table is an optional feature. If you do not use the staging table, Payroll Export transactions are not displayed in the Export Transactions page.