How to validate the Excel file data in service catalog before submitting the request?

[ginjupalli]

Need to validate the records from the Excel file before submitting the request. I have an Widget Excel file import, when ever an Excel file with the Asset data is attached it should check whether the Asset is there in alm_Asset table by using the asset_tag as a unique key?

It was working fine for the .CSV file but when I tried for the Excel file validation was not working.

Any help will be useful.

Regards,

Gowtham.

[surendarm]

Hi Gowtham,

Thank you for bringing up this topic for discussion.

We have a similar requirement, where we wanted to validate the data in the CSV file attached in the service catalog form before submitting for the request.

Could you please help us out how you were able to achieve this, so that it will aid us to build the solution.

Thanks in advance.

Surendar M

[ginjupalli]

Hello Surendarm,

When ever a file uploaded the widget reads the file and glide to alm_hardware table to check for the serial_number, asset_tag.

If the widget finds the serial_number, Asset_tag, it will give error message saying that asset with serial_number and asset_tag found.

In order to bring this functionality I wrote a script include and called this script include in to service side code.

The above screen shorts may be helpful.

Thanks, 

Gowtham.