If an error occurs during the Data Loader upload, the system will generate an Error CSV file that contains details about the failed records.
To identify the issue:
Download the Error CSV file generated after the upload attempt.
Review the last column of the row, where the system displays the error message explaining why the record failed.
One common error is related to organizational hierarchy validation, such as:
Example Error:
Level2Code is not valid. Full Org Hierarchy is needed.
This error occurs when the organizational hierarchy is incomplete or uploaded in the wrong order.
The hierarchy must follow the correct structure:
- Level 1 Code and Level 1 Description must be included first.
- Level 2 cannot be added without Level 1.
- Level 3 cannot be added without Level 1 and Level 2.
The same rule applies to all succeeding levels.
Example Hierarchy Order:
1. Level1Code / Level1Desc
2. Level2Code / Level2Desc
3. Level3Code / Level3Desc
Ensure that the full organizational hierarchy is included and structured correctly in the Data Loader file before uploading.
Following the proper hierarchy order will allow the bulk account creation process to proceed successfully.