CSV validation
Is there a way to validate the contents csv before upload and provide feedback to the user on why it failed.
I can create a rule with sometihng like this.
But it only returns bool not anyway of storing or displaying errors.
For example looping through the sheet and checking that record exists before it can be imported.
In my scenario I have a form that allows the upload of existing records that need to be replicated with slightly different values. So the user will upload a sheet with a record ids in and I want to make sure the record ID exists before I try and create the duplicates and give the user the feedback.
Alternatively the feedback could be given after the csv is submitted as results of success / failures in which case how would I do that?
0 Replies