GroupWise External User Import (GWEUI) Version 1.1 ================================================== Last Update: 10/25/2009 1. Introduction GroupWise External User Import (GWEUI) is a utility that provides for the automated creation of External User accounts in a Novell GroupWise email system. It reads in a comma-separated variable (CSV) file and imports the data into the system creating an External User object ("white shirt"). This is not a full GroupWise account, rather a placeholder so that users from other systems can appear in the system-wide address book. This version has been written in Visual Basic .Net. However, the GroupWise administrative APIs are still COM objects, so the core functionality and how it gets the job done is pretty much the same. Because of this, GWEUI should work with any GroupWise versions from 5.5 through 8.0. 2. Requirements Since this tool is written in Visual Basic .NET, the .Net Framework version 2.0 is REQUIRED. This can be obtained from Microsoft (www.microsoft.com). In addition, the following are also required: - Novell Client for Windows - GroupWise Client for Windows GWEUI should work with any GroupWise system back to at least version 5.5 EP and just about any eDirectory version back to the original eDirectory 85. The latest version of GWEUI has been primarily tested in a GroupWise 8.0.1 environment with eDirectory 8.8.5. Feedback on how it performs with older versions of GroupWise and eDirectory is welcome (see contact information below). In addition to the above software requirements, the user running the tool must have FULL file rights to the domain directory and proper administrative rights in eDirectory to create accounts. 3. Installation Simply unzip the archive into a directory. The Interop.AdminTypeLibrary.DLL must be in the same directory as the executable. 4. Import File The import file must be in a CSV format and must have all the fields listed in the order below. AccountID* PO* Domain* Surname* GivenName* Title Department PhoneNumber FaxNumber Visibility PrefEmailID InternetDomainName The fields must be separated by commas and the fields with an * next to them are REQUIRED fields. Individual fields may be left blank if there is no data for that particular attribute. Each line must end with a CR/LF. The External Domain and Post Office must already exist in the system. An error will be generated if it does not. Visibility can be any one of the following: System, Domain, PostOffice, or None. If not specified, Visibility will be set to System. PrefEmailID allows overriding of the user's system generated Internet Email Address. This is a new feature in the API and is only available in GroupWise 7.0.1 and later. InternetDomainName allows overriding of the user's system generated Internet Domain value. This is a newer feature in the API and is only available in GroupWise 7.0.3 and later. An example data file: hpotter,External PO,Ext Domain,potter,harry,wizard,hogwarts,888-555-1000,888-555-1111,System,Hairy.Potter hgranger,External PO,Ext Domain,granger,hermione,witch,hogwarts,888-555-1000,888-555-1111,PostOffice,Herimone.Granger rweasley,External PO,Ext Domain,weasley,ronald,wizard,hogwarts,888-555-1000,888-555-1111,Domain,Ronald.Weasly 5. Operation Prior to launching GWEUI, the workstation should be logged into eDirectory with a drive mapped to a GroupWise domain directory. GWEUI must have access to WPDOMAIN.DB in order to function. 6. Command Line At a command prompt change directories to where the gweui.exe file is located. Run GWEUI using the format shown below. Format: GWEUI -d [domainpath] -f [filename] -l [filename] -c Parameters: -d [path] Path to Domain Directory - REQUIRED -f [filename] Import File - REQUIRED -l [filename] Error Log File -c Continue on Error 7. Acknowledgments Special thanks to Dave Stone for testing GWEUI and generating the first revision of the "readme" document. 8. Contact Information Should you have any questions/comments/feedback about GWEUI, please direct them to me via email: matt@weisberg.net Weisberg Consulting, Inc. www.weisberg.net 248-685-1970