Deploy the Automatic Data Loader Job

Set up the Automatic Data Loader Job

Before You Begin

APM Connect must be installed.

Procedure

  1. Access the APM Connect Administration Center.
  2. In the Menu pane, in the Conductor section, select Job Conductor.
  3. In the Job Conductor toolbar, select Add.

    The Execution task pane is enabled.

  4. In the Execution task pane, in the Label box, enter a label for the job.
  5. In the Description box, enter a description for the job.
  6. Select the Active check box.
  7. In the Job section, select .

    The Import generated code window appears.

  8. Select Browse..., and then navigate to the folder containing the updated jobs package.
  9. Select the job dinokeeper.zip, and then select Launch upload.

    The job is imported into the Job Conductor.

  10. Configure the context file to identify the location of the load directory, the archive directory, and the log file.
  11. Modify the <Context_File_PATH> value in the job conductor context parameters to point to the context file for the job.
  12. Optional: If needed, edit the file AutomaticDataLoaderOrder.csv to change the directory processing order.
  13. Run the job.

Results

The job conductor indicates that the job ran successfully, and the automatic data loader directories will be created if they do not already exist.

You can now place workbooks in the appropriate data loader directory.

Configure the Context File

Before You Begin

The context file provides the automatic data loader job with the information it needs to locate the directories and log the file it requires.

You should have imported the automatic data loader job.

Procedure

  1. Navigate to the following folder: C:\APMConnect\Config\<system>
  2. Modify the file ContextFile.xml to indicate the values for your system.
    ParameterDescriptionDefault or recommended value
    CONFIG_FILE_PATHThe path to the context file used for extraction.

    Enter your unique value (for example, C:\APMConnect\Config\ContextFile.xml).

    SCAN_DIRThe directory that contains the directories from which the job retrieves workbooks to load data.

    Enter your unique value (for example, C:\APMConnect\Dinokeeper).

    Important: Because this job runs with administrative authority, you must control user access to this directory.
    ARCHIVE_DIRThe directory that the facility uses to archive workbooks.

    Enter your unique value (for example, C:\APMConnect\Archives).

    LOG_BASE_DIRThe path that the facility uses to store the generated log files.

    Enter your unique value (for example, C:\APMConnect\Log).

    LOG4J_CONFIG_FILEThe path to the log4j configuration file.

    Enter your unique value (for example, C:\APMConnect\Config\log4j.properties).

    Note: This can be the same log4j configuration file that you use for your Adapters. If you want to use log4j settings that are different from the EAM job, then you must configure the context file with different log4j properties.

Change Automatic Data Loader Processing Order

The default Automatic Data Loader directory processing order may not meet your requirements. Use this procedure to change the processing order.

Before You Begin

You must deploy the Automatic Data Loader.

About This Task

Besides changing the order, you can keep the Automatic Data Loader from scanning any directories that you are not using. To achieve this goal, you can determine your optimal order before starting the job the first time.

Procedure

  1. Determine the directories you need and the order in which you need those directories processed.
  2. Navigate to the AutomaticDataLoaderOrder.csv file.
    During deployment, the file is created in the directory defined in the SCAN_DIR parameter in the Automatic Data Loader context file.
  3. Using a text editor, edit the file AutomaticDataLoaderOrder.csv to achieve one of the following outcomes:
    Desired outcomeHow to edit the file
    Remove directory from processing.
    1. Delete the directory row from the file.
    2. Update the order number of the remaining directories.
    Change the processing order of the directories.Change the order number in the file.
    Important: Do not remove the first row from the file.
    The default content of the file AutomaticDataLoaderOrder.csv is as follows.
    Order,LoaderID
    1,ManageTaxonomy
    2,ManageEquipmentAndFunctionalLocation
    3,AssetIngestionLoader
    4,Custom Asset Hierarchy Loader
    5,ACADataLoader
    6,ManageAPM
    7,ManageWorkHistory
    8,ManageTMLGroup
    9,ManageTMLGroupFL
    10,ManageInspectionsFL
    11,ManageInspections
    12,Load RBI Corrosion Loop
    13,ManageRBI580
    14,ManageRBI581
    15,Rounds Allowable Value
    16,Rounds Route
    17,Rounds MLTG
    18,Rounds Readings
    19,ManageFMEAAssetTemplate
    20,ManageFMEAAnalysisTemplate
    21,ManageAssetStrategyTemplate
    22,Manage RCA
    23,ManageRCM
    24,ManageRCMFMEA
    25,ManageASM
    26,ManageTagLinks
    27,Calibration Loader
    28,Hazards Loader
    29,RoleDataLoader
    30,GISDataLoader
    31,GAA GADS Amplification Code
    32,GAA GADS Cause Code
    33,Load PLA
    

Use the Automatic Data Loader

Use the Automatic Data Loader job to manually or programmatically load asset data to GE Digital APM.

About This Task

By default, the Automatic Data Loader job processes the files in the directories based on the alphanumeric directory name and then the time stamp of the files from oldest to most recent. However, you can change the order in which the Automatic Data Loader job processes the directories by editing the file AutomaticDataLoaderOrder.csv.

Procedure

  1. Identify the directory that corresponds to the data loader you are using.
  2. Move the data loader files (either a correctly formatted Excel workbook or a .zip file that contains correctly formatted .csv files) into the identified directory.