Loading data into an array field in SM

[tsdc]

Is there any way to load data into an array field in Service Manager?

How do you get a custom field to show in an Import Descriptor?

[Piku]

Yes you can import data in to array fields from the text file.

There are solved threads on forum, ty them and post in case of any challenge,

http://h30499.www3.hp.com/t5/HP-Service-Manager-Service/Import-data-to-array-fields/m-p/4487752/highlight/true#M29786 

http://h30499.www3.hp.com/t5/HP-Service-Manager-Service/Import-from-text-file-to-array-field/m-p/5417741/highlight/true#M82185

http://h30499.www3.hp.com/t5/HP-Service-Manager-Service/importing-the-array-data-in-device-table/m-p/4683833/highlight/true#M45983

[tsdc]

Thank you!  I did read some posts that described how to format the input file.  The problem that I am now having is that my array field does not show as a field available to me in the import descriptor file.  This is a custom field, is there anyway to get that to show in the import descriptor?

[tsdc]

I should also add that this is a structured array field, I don't know if that matters.

[jpmora]

Hello,

You should be able to import arrays and structure arrays, I think we can start by looking at the file you are trying to import and check if it's correct,  can you please attach it here?

Regards,

[Piku]

You should use the field name as per dbdict not caption.

Also check the datadict, if this field  is made ‘available’ to select at other place in SM.

OOB, custom fields do not have restriction to display in import descriptor.

[tsdc]

Here is the file

[tsdc]

I have also tried a csv file, attaching that also.

[tsdc]

The name of the array on the device dbdict is alert.support and the fields we are trying to update in this are alert.type,  alert.assignment, alert.area and alert.subarea

When creating the import descriptor these fields never show as avialable fields to select.

I'm attaching my device dbdict as well