Import Excel file to update SAM Pro Software Discovery Model

msoriano
Giga Contributor

‎09-04-2023 09:44 AM

Hi guys!!

 

I am wondering if ever you know how to import an Excel file to easily update the Software Discovery Model of SAM Pro. I tried it but it always has an error requiring Sys ID to be present. We badly need this functionality since we are updating thousands of records. And it is very tiring to update one item at a time. 

 

Can you help me on this? 

 

Thanks a lot! 

 

By the way, I used Configure > Import functionality of the Software Discovery Model table. 

0 Helpfuls
  • 624 Views
5 REPLIES 5

Maik Skoddow
Tera Patron
Tera Patron

‎09-04-2023 10:06 AM

Hi @msoriano 

 

please use the so-called "Easy Import" feature and not a standard import. For this just follow the instructions from the following vide: https://www.youtube.com/watch?v=QwLUhNpv7H4

 

Maik

Easy Import - Learn Integrations on the Now Platform
Easy Import - Learn Integrations on the Now Platform
youtube.com/watch?v=QwLUhNpv7H4
In this video we demonstrate how to import a spreadsheet in to an existing table. We'll do two examples of both creating new records and updating existing records using the Easy Import feature from a standard list. Docs: Easy Import (Paris) ...
0 Helpfuls

msoriano
Giga Contributor

‎09-04-2023 07:04 PM - edited ‎09-04-2023 07:05 PM

Hi Maik,

 

Thank you for your answer! I tried that already, but it is encountered an error that I need to provide the Sys ID:

Import.gif

 

Preview file
820 KB
0 Helpfuls

msoriano
Giga Contributor

‎09-04-2023 07:16 PM - edited ‎09-04-2023 07:17 PM

I also tried uploading an excel with Sys ID column and values ( I generated my own Sys ID), but it still did not accept the import:

 

image.png

Preview file
53 KB
0 Helpfuls

msoriano
Giga Contributor

‎09-04-2023 07:24 PM

In the two previous comment, I tried to update the records. But I also tried "adding" records: 

 

msoriano_0-1693880629734.png

It is still not working as expected. 

0 Helpfuls