importData
Imports data from a file into the application using the import data settings specified in a job of type import data
.
Use the uploadFile
command to upload the file containing application data to the default upload location.
Applies to
Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Enterprise Profitability and Cost Management, Sales Planning, and Strategic Workforce Planning.Required Roles
Service AdministratorUsage
epmautomate importData JOB_NAME [FILE_NAME] errorFile=ERROR_FILE.zip
where:
JOB_NAME
is the name of a job defined in the application.FILE_NAME
, optionally identifies the name of the ZIP, CSV or TXT (Essbase format data file) file from which data is to be imported. If you specify a file name, the import file name in the job is ignored.If the job is defined to import data in Essbase format, the ZIP file must contain an Essbase format TXT file. For other import jobs, the ZIP file may contain one or more CSV files that identifies the import sequence in the file names; for example,
data1-3.csv
,data2-3.csv
, anddata3-3.csv
.errorFile
, optionally, identifies the name of a ZIP file in which rejected records, if any, during the import operations will be recorded. Identically named ZIP file in the outbox, if any, will be overwritten. You can download this file using thedownloadFile
command.
Example
epmautomate importData dailydataload dailydata.zip errorFile=dataImport_error.zip