insight - import csv with mapping multiple attribute

Thomas AUVRAY January 2, 2018

Hello there, 

 

I can't manage to import multiple attribute with CSV import. 

 

There is my csv :

Type,Name,MAC,Materiel,Localisation
Localisation,601,,,
Localisation,602,,,
ARS-05,TS-GHC91-ARS05-0001,,,
ARS-05,TS-GHC91-ARS05-0002,,,
Mediascreen,TS-GHC91-MS-0001,,TS-GHC91-JAO18-0010f3640312||TS-GHC91-ARS05-0001,601
Mediascreen,TS-GHC91-MS-0002,,TS-GHC91-JAO18-0010f3640338||TS-GHC91-ARS05-0002,602

Capture du 2018-01-02 17-38-41.pngCapture du 2018-01-02 17-46-08.png

 

Import works proprely, but the field "Mon matériel" is not updated :

Capture du 2018-01-02 17-42-18.png

Even if the objets can be selected manually : 

Sans titre.png

Do you know where I'm wrong ? 

 

Thanks in advance, 

 

2 answers

1 accepted

1 vote
Answer accepted
Thomas AUVRAY January 2, 2018

That's OK . I'm just dumb. 

 

For the record, I'he juste change the parameter to "Label IN (${Materiel${0}})" in Object mapping IQL. 

 

Thanks all for your patience ! 

Alexander Sundström
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 3, 2018

Hi Thomas,

Glad that you found the solution, also it would work if you would have used Name instead of NAME and if Name is the Label. It's case sensitive.

Best Regards
Alexander

0 votes
JiraYo
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 10, 2018

OMGZ thanks so much. The documentation here does NOT mention using an array (or however you did this) AT ALL.

https://documentation.riada.se/display/ICV50/CSV+Import

 

I have a list of applications installed on a computer, and even after turning all the semi colon delimiter to || (double pipe) as recommended in the instructions, it failed spectacularly.

Changing the input to Name IN (${Applications${0}}) has solved the problem.

 

THANKS!

image.png

Suggest an answer

Log in or Sign up to answer