RE: How to perform custom validations data that is being imported thru CSV Imports

We have custom validations that trigger in UI on the Journal line level (using client Script).  I am trying to put those validations on the data that is getting imported thru CSV import file feature and populated the errors in the result CSV response.

Is this achievable? appreciate it if someone can shed some light on the solution.

 

raviv Rookie Asked on June 16, 2020 in SuiteScript.
Add Comment
2 Answers

Yes you could achieve similar validation with a User Event script on before submit.  However, if the user is doing a csv import and they check the box to not run server side scripts on import, you cannot stop them from doing that.

Intermediate Answered on June 16, 2020.

Thanks for the reply.

I have tried using user event script I can only get the error in the top row similar to standard error feature.  But if there are line level validations and I want to show respective errors next to that particular line in CSV. Is this possible?

Thank you!

on June 16, 2020.

The CSV Upload behavior of returning a single error message per record is a hard limitation. Your script could perform multiple evaluations and summarize all into a single error message.

on June 17, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.