Validation after Excel upload

Dipali_Pawar
Tera Contributor

3 weeks ago

Hi, I have requirement to populate data on MRVS via excel upload that is working. but validation part I need to do suppose i have fields x , y and in MRVS x has regex which accept 9 digits and y has regex 2 decimal places so same validation should take place after uploading excel. 

suppose user enters only 3 digits in x column in excel then after uploading it should show error like please enter up to 9 digits. 

please let me know if anyone worked on similar requirement. 

Thanks

0 Helpfuls
  • 960 Views
20 REPLIES 20

Shashank_Jain
Kilo Sage

3 weeks ago - last edited 3 weeks ago

@Dipali_Pawar , how you populating data on MRVS via excel upload ?

 

If this works, please mark it as helpful/accepted — it keeps me motivated and helps others find solutions.
Shashank Jain
0 Helpfuls

Dipali_Pawar
Tera Contributor
In response to Shashank_Jain

3 weeks ago

Hi @Shashank_Jain using glide ajax using glideExcelParser and GlideSysAttachment method

0 Helpfuls

Ankur Bawiskar
Tera Patron
Tera Patron

3 weeks ago

@Dipali_Pawar 

you are populating data on MRVS based on file on attachment variable.

Whichever rows you were able to validate add only those

Whichever you can't simply show in info message that the excel row failed validation and show correct message to user.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader
0 Helpfuls

Dipali_Pawar
Tera Contributor
In response to Ankur Bawiskar

3 weeks ago

Hi @Ankur Bawiskar , validation part only pending 

0 Helpfuls