Novell Cool Solutions

Import users from CSV to GroupWise 2014



By:

May 2, 2014 2:54 pm

Reads:2,018

Comments:2

Score:5

Print/PDF

Download gw2014Import.zip

Ok,  you’ve created a GroupWise 2014 test system to play around before making the plunge to update your current system.  Or,  you have already dived into the deep end of the pool and are running in production with GroupWise 2014,  awesome!   You may have noticed that you can now export GroupWise users (and other objects) to a CSV file.  However,  you may want to be able to import users from a CSV to your GroupWise system.

Here is a utility that will take a CSV file and create GroupWise users in a GW 2014 system.   It will create the users as GroupWise only users, meaning they will not be associated to either a eDirectory or Active Directory account.

The utility was created via Python and creates the users via the new GroupWise admin REST API.  The zip file contains an exe file as well as the source .py file.  The GUI was created using WXPython and the REST module used is called requests.   The requests module is not available as a standard Python module via most Linux or Windows Python installations.   Information on getting and installing the module is at https://pypi.python.org/pypi/requests/ .

Also in the zip file is a sample CSV that lists most of the common fields used for a user with the appropriate field names as a header row.

2 votes, average: 5.00 out of 52 votes, average: 5.00 out of 52 votes, average: 5.00 out of 52 votes, average: 5.00 out of 52 votes, average: 5.00 out of 5 (2 votes, average: 5.00 out of 5)
You need to be a registered member to rate this post.
Loading...Loading...

Tags: , ,
Categories: Collaboration, Cool Tools, GroupWise

Disclaimer: This content is not supported by Novell. It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test it thoroughly before using it in a production environment.

2 Comments

  1. By:MGiovaninni

    Very handy utility – I added the “fileId” field in the CSV and used it to recreate user accounts with specified FID’s to import archives from users moved from other systems – much easier than using curl. Bravo!

  2. By:simsx

    I’m attempting to use this wonderful tool but when I click Import I get the following error(s) in a pop up window.. Any ideas?
    Traceback (most recent call last):
    File “”, line 194, in goClick
    File “”, line 226, in gwAdd
    KeyError: ‘object’

Comment

RSS