The import file must be in a CSV format and must have the field order on the FIRST line of the file. Valid fields are:
The fields must be spelled as listed above, however, case does not matter. They may be listed in any order and must be separated by commas. The fields with an * next to them are REQUIRED fields (do not include the * in the field name.
Individual fields may be left blank if there is no data for that particular attribute. Each line must end with a CR/LF.
Visibility must be one of the following: System, Domain, PostOffice, or None.
NetID is the user's distinguished name (DN) in eDirectory (full context, dotted notation).
FID should be used with CAUTION. Typically, the GroupWise system assigns the File ID (FID). However, there can be disaster recovery scenarios where importing the FID is useful. Use it with caution. The import will fail if there is a duplicate FID in the Post Office in which the import is taking place (FIDs are unique PO-wide, not system-wide).
PrefEmailID allows overriding of the user's system generated Internet Email Address. This is a newer feature in the API and is only available in GroupWise 7.0.1 and later.
LDAPAuthentication allows for setting of the LDAP credentials used for each user upon login. This is particularly useful when GroupWise Post Offices are set to do LDAP authentication against a different directory from the one in which the GroupWise system resides (such as doing authentication against Microsoft Active Directory). This is a newer feature in the API and is only available in GroupWise 7.0.1 and later.
When setting the LDAPAuthentication field, two different formats for the data can be used for Active Directory based authentication, either:
Either of those formats should work. When using the later format, be sure to enclose the value in quotes in the import file.
The password field is the GroupWise password. GWIU currently does NOT set the NDS/eDirectory password (see section below on passwords).
Mailbox expiration date must be in the format YYYYMMDDhhmm and is set in local time. The valid range for the expiration date is midnight, January 1, 1970 through 11:59, December 31st, 2037.
An example data file:
A Word About Passwords
For many versions now, GroupWise has had the ability to utilize passwords in eDirectory for account authentication. This is the preferred configuration, as the eDirectory password supports many features which the GroupWise native password does not, such as forced expiration, password history, and complex password rules. GroupWise post offices accomplish this by communicating with eDirectory over LDAP.
GWIU will import GroupWise passwords should you choose to continue to use them. However, it will not set eDirectory passwords. This feature may be added in a future version of GWIU.
One way to preset passwords for accounts in eDirectory is via LDIF (LDAP Data Interchange Format). A full discussion of LDIF is beyond the scope of this document. Novell includes a tool with eDirectory called ICE (Import/Convert/Export) that can read LDIF files. A sample LDIF entry to set passwords would look something like this:
The ICE tool would then be used to import the file (ICE can be accessed at the command line or via a GUI through ConsoleOne).