Skip to Main Content
Feature Request FR-4079
Product Area Application Builder
Status OPEN

2 Voters

Provide detailed error messages for data loader - including the reason and the row and field of data that is causing the issue.

stirling.butcher Public
· Oct 25 2024

Idea Summary
Using the built in data loader is great - until something goes wrong and it isn't.  When data fails to load it can be hard for me as a developer to find the reason and the offending data - it's almost impossible for a end user.
Please provide detailed error messages to users of the built in data loader - including the reason,  where possible the row (PK) and the field/column that is causing the issue.  Where possible display the offending data value on screen with the reason

Use Case
This would be useful for any app that loads data.

Preferred Solution (Optional)
I don't have a preferred solution - but a team I used to work in achieved something like this by loading into a giant table with large varchar2 columns and then row by row inserting into the desired table which allowed us to catch the row that failed and the reason the row failed - which usually identified the column so we could give users really helpful error messages.  I get it its slower - maybe give an option for detailed error messages or faster loading.  When a couple hundred rows is all thats going to be loaded  - which I am sure is often the case - extreme efficiency of speed isn't a priority

This idea is open.