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 ReconciliationRequired Roles
- Service Administrator
- Power User
- User
- Viewer
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 isdd-MMM-YYYY
. Other supported date formats are:MM/dd/yyyy
,dd/MM/yyyy
,MM-dd-yyyy
,d-M-yyyy
, andMMM d.yyyy
.
Example
epmautomate importTmPremappedTransactions "INTERCOMPANY" "AP" dailydata.csv d-M-yyyy