Overview

There is a functionality in PST Flight Deck to import CSV files (Manage -> Users: Import Attributes).

This gives us the possibility to update the properties for the batch of the users specified in the CSV files. (e.g. enable batch of the users for migration)

Steps

The CSV file must have a proper syntax:

  • Column header – the column names need to match with the names of the columns in the [UserEntry] table in the [PSTFlightdeckDirectory] database
  • DomainName and sAMAccountName are mandatory columns
  • After DomainName and sAMAccountName follow the columns you want to set
  • Strings need to be specified with “”, numbers without “”
  • New carriage character at the end of the last entry

Here is an example of the proper syntax:
DomainName;sAMAccountName;AdvancedClientMigrationPriority;ProfileID;UserCustomField1;UserCustomField2
“L2″;”PEPI2″;11;1;”LowBandwidth”;”Resort 1″
“L2″;”PEPI4″;13;1;”HighBandwidth”;”Resort 2″
“L2″;”PEPI6″;13;2;”HighBandwidth”;”Resort 3″
An example CSV file is attached to this KB article too.
ImportBatch
This table gives you a list of properties you can use:

 Column Name  Name in CSV file  Type
 Domain  DomainName  string
 Account  sAMAccountName  string
 Migration Priority  AdvancedClientMigrationPriority  number
 Profile ID  ProfileID  number
 Email Priority  RolloutCommunicationPriority  number
 User Custom Field 1  UserCustomField1  string
 User Custom Field 2  UserCustomField2  string

Note

CSV import functionality supports all columns within the [UserEntry] table. Please make sure you use the correct column name (from the database) and the right column type (to use “” properly).

Print Friendly, PDF & Email