Hello everyone!
I'm bashing my head on a problem with data loaders, and Google didn't help me.
My situation is that I have a db table with no primary key and a data loader created with the wizard, no transformation rules applied, no table lookup. I need to skip the validation phase because I want to force the insert (I don't add keys to avoid updates instead of inserts). I'm in APEX 5.0, but I'm pretty sure this it's not a version problem nor a bug.
The "problem" is that while with validation enabled a data type mismatch (like inserting 10 chars in a 4 varchar column) get caught after mapping phase with a orange-ish pop-up, with validation disabled this doesn't happen, no error is raised to the user, simply the records don't get inserted. I understand this may be a wanted behaviour, but unfortunately I'd need to have the validation skipped and the data type checks performed, with pop-ups on error.
What I noticed is that these two different behaviors seems to depend on the same process, the "Prepare Uploaded Data", triggered by pressing the NEXT button in the data mapping page. So it's like the process works differently based on the skip validation flag. Is my guess correct?
I was wondering if it may be possible to have a custom hand-made error popup, or something similar to emulate this behaviour.
Has anyone a suggestion on how to resolve this problem?
Thanks in advance guys!
Filippo