Automatic Data Loader

The Automatic Data Loader can load Excel workbooks or .zip files into the system from an on-premises installation of APM Connect.

GE Digital APM provides a method to automatically load data into the system from correctly formatted Excel workbooks or a .zip file containing correctly formatted .csv files. 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 time stamp on each file. The order that the directories are processed is defined in the .csv file, AutomaticDataLoaderOrder.csv.

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.