Import: CSV File

The procedure for importing computers and users via CSV file into the organization tree is as follows:

  1. Ensure that an appropriate CSV file exists.

      The header must have the following schema and the individual objects must be entered in the subsequent lines:

      Name;SchemaTag[;Group.Membership][;<PropertyGroup>.<Property>][;<PropertyGroup>.<Property>][;…]

      Lines that begin with the # sign are ignored. In case such a line must be imported, you must duplicate the # sign (##) for the system to recognize it.

  2. Enter the path to the CSV file.
  3. Select the objects you want to import.
  4. Start the import.

      Objects that already exist are updated when they are imported.

CSV File Format

Name and SchemaTag

Name and SchemaTag are mandatory.
SchemaTag must be either Computer or User.

If the Mobile Device Management Integration is used the value can also be Mobile Device.

Example
In this example cs01 and cs02 are imported as computers while karl.lagerfeld and heidi.klum are imported as users into the previously selected domain or OU:
Name;SchemaTag
cs01;Computer
cs02;Computer
karl.lagerfeld;User
heidi.klum;User
# Comment line
# See the following example to import a computer with the name '#test':
##test;Computer
...

Group.Membership

Group.Membership is optional and can be used to assign the imported objects to one or more groups automatically.

In the Group.Membership column for computers or users one of the following values must be entered:

  • the name of a group
  • the object ID of a group
  • a filter which represents a specific group

Example
In this example cs01 is assigned as computer to all groups named Group1, cs02 is assigned as computer to the group with the object ID 1234and cs03 is assigned as computer to all groups named beginning with A:
Name;SchemaTag;Group.Membership
cs01;Computer;Group1
cs02;Computer;1234
cs03;Computer;(Name=A*)
...

In order to enter a valid DSM filter, define the desired filter in the Object window, save the filter and then copy the filter from the Free LDAP field.

Property

<PropertyGroup>.<Property> is optional and can be used to add DSM properties to the imported objects. The number of properties is not restricted.

Example
In this example cs01 is imported as Virtual Machine with the MAC address 000C2975BF8D, cs02 and cs03 are imported as Desktop or Server respectively:
Name;SchemaTag;BasicInventory.InitialMACAddress;Computer.ComputerType
cs01;Computer;000C2975BF8D;Virtual Machine
cs02;Computer;001C6935D28F;Desktop
cs03;Computer;70CD60AB0CE4;Server
...

Make sure to enter valid property group names, property names and property values.