importTmPremappedTransactions

For a specific data source, imports pre-mapped transactions data from a file in Account Reconciliation repository into Transaction Matching.

A Service Administrator uses the uploadFile command to upload the transactions file to the service.

This command displays import status and an import log file name in the console. A Service Administrator uses the downloadFile command to download the log file to a local computer.

See Importing Data in Reconciling Accounts with Account Reconciliation for import file format requirements and information about importing data.

Note:

  • You can import transactions for only one match type at a time. However, parallel imports can be run into different match types.
  • Unlike from the Jobs screen, you can import pre-mapped transactions data only from one file at a time.
  • After importing pre-mapped transactions for all data sources, run the runautomatch command.

Applies to

Account Reconciliation

Required Roles

  • Service Administrator
  • Power User
  • User
  • Viewer
Users with Power User, User, and Viewer predefined roles may require additional application roles.

Usage

epmautomate importTmPremappedTransactions MATCH_TYPE DATA_SOURCE FILE_NAME [DATE_FORMAT] where:

  • MATCH_TYPE is a match type defined in Account Reconciliation.

  • DATA_SOURCE is the identifier of the data source associated with the reconciliation type that you specified.

  • FILE_NAME is the name of the CSV file containing the transactions to import. This file must be available in the service.

  • DATE_FORMAT is an optional parameter that indicates the format of the date fields included in the transactions import file. Default is dd-MMM-YYYY. Other supported date formats are: MM/dd/yyyy, dd/MM/yyyy, MM-dd-yyyy, d-M-yyyy, and MMM d.yyyy.

Example

epmautomate importTmPremappedTransactions "INTERCOMPANY" "AP" dailydata.csv d-M-yyyy