Importing Consumables using the connector getting error

Karen_Bruster1

Good morning,

I created a CSV from the Excel Cireson add-in (as a template) and filled in the consumable name and Threshold as these are mandatory entries (see attached-change the extension back to csv). I then created the connector and mapped all the items (as the instructions show in the guide). But my consumables will not import. I keep getting the same error in the log (See attached).

"Did not find an existing Cireson.AssetManagement.Consumable - one or more keys are null, check input data around line or row 6"

Can someone let me know which key that is required that I am not filling in.

I can manually enter a consumable with just its name and threshold level and it works just fine. So I am not sure what it is I am Missing.

Karen

damon_mulligan

@Karen_Bruster1
If you use this spreadsheet to populate csv files for Asset Import, it will assist with showing required fields, and data types, and the properties and relationships that can be imported. In some cases, it will show example data.

Justin_Workman

Hey Karen,
I was able to make your Consumables CSV import if I added GUIDs for the Id column.  Here's the resulting sheet I used.  

Karen_Bruster1

@Justin_Workman
But shouldn't the system generate the GUIDs automatically? Will giving items ID GUID's screw up the system?

Justin_Workman

@Karen_Bruster1, Consumables is asking for a GUID as the key and it's required.  AFAIK there's no problem with introducing GUIDs created outside of SCSM.

damon_mulligan

@Karen_Bruster1
If you use this spreadsheet to populate csv files for Asset Import, it will assist with showing required fields, and data types, and the properties and relationships that can be imported. In some cases, it will show example data.

damon_mulligan

@Karen_Bruster1

It has been a while. Were you able to get everything working?

Karen_Bruster1

@damon_mulligan

Yes I was thank your for your assistance.