Is it possible to import 'Lists' as CSV file through the Asset Management Import Connector?

Anne-Claire_Hodgkins

I'd like to know if there is a way of populating the 'Lists' section in Library without having to individually add items? Is this something that can be done through the Cireson Asset Management Import Connector with a mapped CSV file?

Matt_Medley

Anne-Claire_Hodgkins said:

Unfortunately I have no knowledge of script or xml file writing/coding so I wouldn't be able to use and don't understand these solutions, enum or Powershell. As the 'Library' where the 'Lists' class as it were are kept is not a Cireson add on does this mean the Cireson Asset Management Import Connector can't be used for lists because it's not a Cireson data class add on? I know I looked at the mapping elements within the import connector and couldn't find Library or Lists as an option. I can understand and work with a CSV file, if its possible to use this with regards to Library and Lists.

Hey Anne, the easiest way we've seen this done is with the link David Morris provided earlier. There is a Q&A section on that page with some useful information that may help you work through it. You are correct regarding the Cireson Asset Management Import connector cannot be use for lists because it is not a Cireson data class add-on.

https://gallery.technet.microsoft.com/Service-Manager-Enum-43e30552

David_Morris1

Hi Anne,

you should update existing lists into a new MP most standard lists are in a sealed MP that cant be edited, if you has an existing Custom MP with list items (though not the cleanest) you should have no issues adding a new MP with additional items.

in the CSV template provided with the tools this shows existing lists that would be updated ie. Incidentclassificationenum (Incident Classification).

you need to put the existing list's enumeration name into the first column to find this if you don't know it run the below powershell on your management server

Import-module SMlets
get-scsmenumeration | where-object{$_.displayname -eq "Enter list Name"}

but most standard lists follow this trend 

"class"List"Enum"

Ie.

IncidentSourceEnum
ChangeRiskEnum
ServiceRequestPriorityEnum

damon_mulligan

I would be careful when using the https://gallery.technet.microsoft.com/Service-Manager-Enum-43e30552.
Please test in a non-production environment. When I used this tool, you were not able to edit the list in the Library > List section in the Console after populating it with this tool. 

There is no easy process to mass update lists currently. The Asset Import tool CANNOT update list values.

David_Morris1

try this
https://gallery.technet.microsoft.com/Service-Manager-Enum-43e30552

Roland_Kind

Hi,

maybe the following link will help you

https://community.cireson.com/discussion/921/import-and-manage-large-lists-in-scsm

Anne-Claire_Hodgkins

Unfortunately I have no knowledge of script or xml file writing/coding so I wouldn't be able to use and don't understand these solutions, enum or Powershell. As the 'Library' where the 'Lists' class as it were are kept is not a Cireson add on does this mean the Cireson Asset Management Import Connector can't be used for lists because it's not a Cireson data class add on? I know I looked at the mapping elements within the import connector and couldn't find Library or Lists as an option. I can understand and work with a CSV file, if its possible to use this with regards to Library and Lists.

Matt_Medley

Anne-Claire_Hodgkins said:

Unfortunately I have no knowledge of script or xml file writing/coding so I wouldn't be able to use and don't understand these solutions, enum or Powershell. As the 'Library' where the 'Lists' class as it were are kept is not a Cireson add on does this mean the Cireson Asset Management Import Connector can't be used for lists because it's not a Cireson data class add on? I know I looked at the mapping elements within the import connector and couldn't find Library or Lists as an option. I can understand and work with a CSV file, if its possible to use this with regards to Library and Lists.

Hey Anne, the easiest way we've seen this done is with the link David Morris provided earlier. There is a Q&A section on that page with some useful information that may help you work through it. You are correct regarding the Cireson Asset Management Import connector cannot be use for lists because it is not a Cireson data class add-on.

https://gallery.technet.microsoft.com/Service-Manager-Enum-43e30552

Anne-Claire_Hodgkins

Just looking at Enum Builder and I am not sure it does what I'd like to do. This talks about creating unsealed MP's but I wanted to update the existing 'Lists' in the Library section. Does using the Service Manager's inbuilt CSV import update these Library lists? Or will it only create more MPs?

David_Morris1

Hi Anne,

you should update existing lists into a new MP most standard lists are in a sealed MP that cant be edited, if you has an existing Custom MP with list items (though not the cleanest) you should have no issues adding a new MP with additional items.

in the CSV template provided with the tools this shows existing lists that would be updated ie. Incidentclassificationenum (Incident Classification).

you need to put the existing list's enumeration name into the first column to find this if you don't know it run the below powershell on your management server

Import-module SMlets
get-scsmenumeration | where-object{$_.displayname -eq "Enter list Name"}

but most standard lists follow this trend 

"class"List"Enum"

Ie.

IncidentSourceEnum
ChangeRiskEnum
ServiceRequestPriorityEnum

damon_mulligan

I would be careful when using the https://gallery.technet.microsoft.com/Service-Manager-Enum-43e30552.
Please test in a non-production environment. When I used this tool, you were not able to edit the list in the Library > List section in the Console after populating it with this tool. 

There is no easy process to mass update lists currently. The Asset Import tool CANNOT update list values.