Data Loaders V2
Download the Data Loader Workbooks
Procedure
Results
Run a Data Import Job
Before You Begin
Procedure
Results
Access the Data Bundle Execution Details of an Import Job
Before You Begin
This topic assumes that you have successfully ingested the Data Bundle Execution.
Procedure
Results
About Populating Site Reference Data
The Unified Asset Ingestion Data Loader can be used to populate the Site Reference on Equipment and Functional Location records in Predix Essentials.
About This Task
The APM Family Data Loader populates the ENTY_KEY system field and the MI_SITE_KEY system field associated with the Site Reference value to be populated. On asset records, the Site Reference is stored in the MI_SITE_KEY field, a system field in Predix Essentials. The APM Data Loader uses the Site Name (MI_SITE_NAME) to translate the value to the corresponding Site Key and populate the MI_SITE_KEY field; therefore, you do not need to know the key to be able to populate the site reference. This functionality is important because this value can change from one database to another.
Procedure
Details of the Data Bundle Execution
When you select a job in the Data Bundles Status page, the data import details page appears displaying the detailed import status and the progress of the selected data import job.
The Data Bundle Execution Details page displays the following sections:
Worksheet Field | Description |
---|---|
Overall Job Status |
The section displays the overall details of the job such as Asset name, Status, File name, Start Time, End Time, Bundle ID, and Progress Bar that displays the Process Stage. |
Summary of the Records Processed |
The section displays the summary of the processed records (# of Insert, Delete, Update, Reject and Total Records) in a donut chart. It also displays the System Errors in the job processing, if any. |
System Errors |
The section displays the System errors occurred during processing of the job. |
Rejected Rows |
The section displays all the records that are rejected while processing the job. The details include Sheet Name, Row #, Primary Record Id, Slice ID, Error Code, Message, Timestamp, Data. Select a record to view the full data of the record. You can download the Rejected record data into an .xlsx file using the Export Current Page option available in the Rejected Rows section. |
Event Timeline | The section displays the process activity event timelines. The details include Timestamp, Process state of Step, Status, Message (displays system errors, if any). |
Refresh |
You can use the Refresh option for setting the frequency of refreshing the page (Off, 30 sec, 1 min, 5 min and 10 min). Also, you can manually refresh the page. |
Export the Rejected Data Details of an Import Job
Procedure
- Access the Data Bundle Execution Details of an Import Job.
- In the Rejected Rows section, select and then select Export Current Page to download the details of the rejected data during the import job.