About the Root Cause Analysis (RCA) Data Loader General Loading Strategy
Best Practices
When importing data using the Root Cause Analysis (RCA) Data Loader, you must use the following best practices:
ID fields (row 2 of each worksheet) must not include special characters or spaces.
Columns in the worksheets should be formatted as either text or dates.
The first two rows of each worksheet should not be edited.
Only import a maximum of 500 analyses in each data load.
Limitations
This section documents a list of the limitations for the Root Cause Analysis (RCA) Data Loader:
The user must use the Root Cause Analysis (RCA) Data Loader workbook (Root Cause Analysis (RCA).xlsx). Any modifications made by the user to the values in column headings in any of the worksheets will not be imported.
Note: Any column values in a customized format will not be imported by the Root Cause Analysis (RCA) Data Loader.
If the user imports the same data multiple times, the most recently imported data is included in the database. If a record currently resides in the database and is then reimported, the newly imported file will replace the existing file in the database. The Root Cause Analysis (RCA) Data Loader does not append the existing record.
Load Sequence
Create an RCA Analysis.
Create an RCA Event.
Link the RCA Event to the RCA Analysis through the RCA Analysis Relationship.
Create and link one or more Failure Modes to the RCA Event through the RCA Analysis Relationship.
Create and link one or more Logic Gates to a specific Failure Mode through the Has Analysis Relationship, where the Failure Mode is the predecessor of the Logic Gate.
Create and link one or more Hypotheses to a specific Logic Gate, through the Has Analysis Relationship, where the Hypothesis is the successor of the Logic Gate.