Validation of bulk upload CSV files

When using the bulk CSV uploader it now includes validation and error reporting

  • Custom Regex validation rules can be applied to specific columns in the CSV

Regex can be applied in Catfish Admin under:

Catfish > Other > Approval Workflow Settings : BulkUploadRegEx

If the CSV uploader spots a record that fails on any of the applied regexs then it will reject that record. At the end of the upload a ‘rejected’ CSV file can be downloaded that will list all of the records that didn’t get included in the upload so you can modify them and re-upload.

 

Additional Notes:

Example email regex that can be pasted into the BulkUploadRegEx textbox

Email=[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])? 

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk