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. 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.

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.

Procedure

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