Uploading data using catalog item

Ipsita4
Kilo Contributor

‎01-10-2019 05:20 AM

Hi All,

I need to create a catalog item to upload data into asset table. We require a download link in the catalog item with pre defined excel sheet attached for the user to  fill and upload back to the catalog item.Once user submits the catalog request,the filled excel sheet should be the data source for the  existing import script to asset table.

Currently, service desk is manually filling excel and running import to asset table.

This would be a great help guys! I am not sure where to start.

Regards,

Ipsita

0 Helpfuls
  • 1,749 Views
1 REPLY 1

ggiri1
ServiceNow Employee
ServiceNow Employee

‎01-12-2019 01:46 AM

Hi Ipsita,

 

The above requirement was discussed and achieved as follows:

https://community.servicenow.com/community?id=community_question&sys_id=56b747e9db1cdbc01dcaf3231f961984

https://community.servicenow.com/community?id=community_question&sys_id=ead94329db5cdbc01dcaf3231f961995

 

Same time, based on your requirement seems the users are entering the data into Excel manually on demand. If this is the case you can implement a Table using the UI Macro and create all fields same as in your Excel Template and then have the users to fill then you can use your scripting to create records as you wanted. (Just a thought)

 

Thanks,

Giri Guntoju

0 Helpfuls