GE Digital APM provides a method to automatically load data from correctly formatted Excel workbooks into the system. You must place your data loader workbook in the correct directory for a successful data load.
The job monitors a configured load directory for the presence of a file in a subdirectory and stages the contents of the file into the system. Multiple files moved into the directory are processed in descending order according to the last modified timestamp on each file.
The system logs the staging progress and archives files it has successfully staged in an archive directory. If data fails to stage, a message is written to the log indicating the reason for failure, and the source files remain in the scan directory.
A service then retrieves the staged workbooks, and using an administrative account, the service invokes the appropriate data loader to load the data contained in the workbooks.
Note: For cloud implementation, the archiving of files occurs before staging the data for uploading to the cloud server.
Copyright © 2018 General Electric Company. All rights reserved.