CSV file syntax

In the list below, you can find information about individual fields of the CSV file.

A single word or a plain number can be put in the CSV fields as they are, while more complex strings, such as full name or email address, have to be bounded by quotes.

• FULLNAME: Name of the user in double quotation marks, for example "Thomas Pineapple".

• USERNAME_ALIASES: Login of the user and eventually their aliases. The login should be the same as the user's domain login name, for example Tom. When you import multiple aliases, separate them with commas, for example "Tom,Tomy,Apple".

• EMAIL: Email of the user, for example "t.pinapple@domain.com".

• CARDS: Number of the user's authentication card/chip. It has to be inserted in the form in which it is read by the card/chip reader, for example 7E9700C9.

• GROUPS: Here you can add user groups. You can import a whole branch of the groups tree structure. The groups on the imported branch have to be separated by vertical bars. If you want to import multiple groups (or groups tree branches), separate them by commas. For example, if you add two branches separated by a comma: "Activities|Outdoor|Swimming,Activities|Outdoor|Birdwatching", MyQ
  imports a single parent group Activities with a single child group Outdoor, with two
  child groups Swimming and Birdwatching (Activities>Outdoor>Swimming,Birdwatching). Commas and vertical bars cannot be used in group names as they are used as group delimiters.

• CODE: The personal number of the user. The ID number must be unique for each user. This parameter is very useful when using multiple sync sources.

• SCANSTORAGE: The folder or email where the user wants their scans to be sent to, for example "\Users\Tomy".

• PIN: You can define one or more PINs to be assigned to users within the synchronization process. It is not absolutely necessary, as PINs may also be generated later within the setup of the user account. The PINs should be in the hashed MD5 format, for example 14BFA6BB14875E4.

• MANAGED_GROUPS: You can make the user the manager of a particular group by adding the group or path to the group here in the way in which you would import the group. If you want the user to be a manager of a child group, enter a whole branch ending with this group. For example, enter the branch "Activities|Outdoor|Swimming" to make the user a manager of the Swimming group. If there are no parents of the group in the group structure, enter just the group name, e.g. Activities. Commas and vertical bars cannot be used in group names as they are used as group delimiters.

• AUTHSERVER: In this field you may define the domain for user authentication, for example "testAD.local".

• PHONE: The user's phone number, for example 080008020.

• LANG: Default language of the user, for example en.

• PWD: If you want to use the MyQ password, insert the password in the hashed MD5 format, for example 18BFA6BB14875E8. If you are using a different authentication server (i.e. LDAP server), you can leave it empty.

• EXTID: EXTID is an internal MyQ parameter. This field has to be left empty.

• DELEGATES: For each user, you can import any number of delegates. If you import multiple delegates, separate them with commas, for example "Carol,Kohei,Eliot".