Add Import Set Excel Template to add bulk import to the table

abhisheksat
Tera Contributor

I have a catalog already present, but now I want to add a excel Template of a table which I have build to import bulk data through excel file, how can i add a template to the catalog through which the user downloads the excel file and add the information and add to the catalog and then it automatically import the information to that table 

1 REPLY 1

Ankur Bawiskar
Tera Patron
Tera Patron

@abhisheksat 

there are 2 things to it

1) add file to catalog form

2) use my blog to load the data via transform map

Data load and transform via Catalog Item 

Approach for 1st point

you can use Rich Text variable and add button/link to it

1) File added to catalog item

AnkurBawiskar_0-1741593051781.png

 

2) Create Rich Text label variable and add source code below

HTML Source Code

<style>
a:link, a:visited {
  background-color: #f44336;
  color: white;
  padding: 14px 25px;
  text-align: center;
  text-decoration: none;
  display: inline-block;
}

a:hover, a:active {
  background-color: red;
}
</style>
<p>Please download the file here:&nbsp;<a title="Link" href="/sys_attachment.do?sys_id=29c39e75073f64102011ff208c1ed04f" target="_blank" rel="noopener noreferrer nofollow">Link</a></p>

AnkurBawiskar_1-1741593051312.png

 

Output:

Native

AnkurBawiskar_2-1741593051316.png

 

Portal

AnkurBawiskar_3-1741593051321.png

I believe I have answered your question with all the details and you can take it further from here

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