importTmPremappedTransactions

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

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