Data Loaders V2

Download the Data Loader Workbooks

Procedure

  1. Access the Data Loaders V2 page.
    The Data Bundles Status page appears.
  2. Select Data Loaders.
    The Data Loaders window appears.
    Note: By default, the data loader type Unified Asset Ingestion is selected.
  3. In the DOWNLOAD TEMPLATE section, select one of the following options:
    • Default Template: Select to download the available template.
    • Generate Template: Select to create a customized template. Select to download one of the following type of templates,
      • Construct Hierarchy: You can construct a hierarchy by creating a relationship between the Enterprise/Site/Segment/Asset by appropriate selections.
      • Update/Add Asset only: You can update the existing template data by selecting the required the Asset type.
      and then enter information in the available fields.
  4. Select Download Template.

Results

The data loader template is downloaded. The downloaded template, can be populated with data to load into Predix Essentials.

Run a Data Import Job

Before You Begin

This topic assumes that you have migrated your data to the required format for the modules into which you want to import data. The format should match the Excel workbook templates.

Procedure

  1. Access the Data Loaders V2 page.
    The Data Bundles Status page appears.
  2. Select Data Loaders.
    The Data Loaders window appears.
  3. In the UPLOAD DATA section, select Select file, and then navigate to and select the file that you want to import. Alternatively, you can also select the file that you want to import and drag and drop the file in the UPLOAD DATA section.
  4. In the Description box, enter a short description of the job.
  5. Select Upload.
    The job is run, and the status of the job appears in the Data Bundles Status page.

Results

The selected file is uploaded into Predix Essentials.

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

  1. Access the Data Loaders V2 page.
    The Data Bundles Status page appears.
  2. In the Data Bundles Status page, select the job for which you want to access the details.
    The Data bundle execution details page appears, displaying the detailed information of the job.

Results

The Data Bundle Execution details of the job is displayed with the status and progress of the imported data. You can export the data of the rejected rows during the import job to view the details of the errors occurred, if any.

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

Important: In a cloud environment, before populating site reference data for the first time, you must run the Unified Asset Ingestion Data Loader to load the enterprise and site data.

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

  1. On the data worksheet, add a column that contains MI_SITE_NAME in the column name.
    For example if you are working with a relationship, where a distinction needs to be made regarding which family is associated with each column, then the column name will be prefaced with the Family ID. As shown in the following image, the column name might take the form MI_EQUIP000|MI_SITE_NAME, where MI_EQUIP000 is the Family ID.
  2. Enter the site name to designate the site by which the asset record, once loaded into Predix Essentials, will be filtered.
  3. Continue populating the source workbook, and then run the data loader.

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 FieldDescription
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 TimelineThe 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

  1. Access the Data Bundle Execution Details of an Import Job.
  2. In the Rejected Rows section, select and then select Export Current Page to download the details of the rejected data during the import job.

Results

The details of the rejected data in the Data Bundle Execution job is exported.

Sort Data in a Column in Data Bundle Status

Procedure

  1. Access the Data Loaders V2 page.
    The Data Bundles Status page appears.
  2. Select a column header, such as BUNDLE TYPE.
    The data in the column is sorted in a specific order (ascending or descending).
  3. Select the column header again to reverse the sort order.
    The data in the columns is sorted in the reverse order.

Results

You can sort the data in the columns in the Data Bundles Status page in an ascending or descending order.

Show Data in a Column in Data Bundle Status

Procedure

  1. Access the Data Loaders V2 page.
    The Data Bundles Status page appears.
  2. Select , and then select the check box next to the column name that you want to view.
    The selected column appears.

Hide Data in a Column in Data Bundle Status

Procedure

  1. Access the Data Loaders V2 page.
    The Data Bundles Status page appears.
  2. Select , and then clear the check box next to the column name that you want to hide.
    The selected column is hidden.