Forum GLPI-Project

itvnb

Member

Registered: 2024-02-16

Posts: 2

Plugin "data injection": field format for location field in CSV file

Hello GLPI experts,
we're evaluating importing locations from CSV files. Given we have multiple buildings (HQ, Building 1, Building 2, etc.) and some floors in these buildings, we manually created these location objects in GLPI (under "Setup -> Dropdown -> Common -> Locations"). So we have a list of locations and sub-locations like this:

HQ
HQ -> Ground Floor
HQ -> 1st Floor
HQ -> 2nd Floor
Building 1
Building 1 -> Ground Floor
Building 1 -> 1st Floor
Building 2
Building 2 -> Ground Floor
Building 2 -> 1st Floor
Building 2 -> 2nd Floor
Building 2 -> 3rd Floor

Now we have a long list of rooms in each of these buildings and floors, that we need to import, but we cannot determine how to enter the location "path" in our CSV, that the new locations are inserted as correct sub-locations, i.e.:

name;location;comment
Room 001;HQ -> Ground Floor;Meeting Room Ground Floor
Room 111;Building 1 -> 1st Floor;Storage 1st Floor

We couldn't find any example or documentation, what would be the correct fomat, can anybody give us a hint, how to import such a room list? And afterwards this question would occur on importing asset into the correct rooms as well...

Thanks and regards

itvnb

Member

Registered: 2024-02-16

Posts: 2

Re: Plugin "data injection": field format for location field in CSV file

anyone?