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
  • 625 Views
5 REPLIES 5

varaprasad123
Kilo Guru

‎09-04-2023 08:02 PM

Hi @msoriano, Can you pls try following steps?

 

  1. go to system import sets-->load data module
  2. enter table name..chose file(.xls file) make sure 1st row in excel match fields in your destination table.so it will automap.
  3. then click on create transform link
  4. give it a name,select destination table(table in which u want to upload data)
  5. click on auto map matching fields..if required fields do not match then click on mapping assist and match fields.
  6. set colesce true to any one field from related list. it will be your unique field
  7. click transform
0 Helpfuls