About the Hazards Data Loader General Loading Strategy
The imported data must load in a specific sequence in order to successfully populate fields, to create records, and to link them to the predecessor and/or successor records.
Best Practices
When importing data using the data loader workbook, you must use the following best practices:
ID fields (Row 2 of each worksheet) must not include special characters (other than underscores) or spaces.
Columns (including columns representing custom fields) in the worksheets should be formatted as Text.
You should not try to create and update a component in the same data loader workbook.
You must consider the rules described in the Workbook Layout and Use section of this document while using the Hazards Data Loader.
Load Sequence
When importing data using the data loader workbook, you must use the following workflow:
Download the data loader workbook provided by GE Digital
Identify the data requirements for exporting the data in to the data loader workbook.
Extract data from legacy applications to populate the data loader workbook.
Import data into GE Digital APM.
Monitor the status of the data load, and verify the results in the log.
Conduct tests in GE Digital APM to ensure that the imported data loaded accurately.
For each row in the data loader workbook, the Hazards Loader creates a new record in GE Digital APM. However, if records have already been created and you reimport the data, the existing records will be updated.