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 Administrator

Usage

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, and data3-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 the downloadFile command.

Example

epmautomate importData dailydataload dailydata.zip errorFile=dataImport_error.zip