zimbra bulk

[MrPstv]

Morning all,

How would i go about creating bulk email accounts in zimbra for students, 3 columns are needed ! account name, display name and password.

My problem is i am pathetic at using excel! any scripts, formulas ,a write up out there in the big wide world of edugeek? Account name would be yr6user@ yr5user@ yr4user@ so on and so forth.help

[3s-gtech]

Do you have the users in AD already? You can just export them from the directory into a .csv file, delete a couple of columns and the data is pretty much ready to use.

[CarolBooth]

Here's my crib sheet for the process using the command line, adapted from the zimbra wiki (we have a specific COS for students but you can ignore this part if you don't use different COSs)

Carol

 

first log in as zimbra on the command line then:

 

To create one account with a password that is assigned to a specified COS. You must know the COS ID number. To find a COS ID, type

 

zmprov gc zimbraID

or look at the Class of Service in the admin console. The number appears top right

 

Create Account:

 

Type on one line.

zmprov ca [email protected] test123 displayName JSmith

 

some example account attributes:

displayName = 'forename surname'

givenName = forename

sn = surname

 

 

Examples:

to create one account:

 

zmprov ca [email protected] zimbraCOSid displayName <'Joe Bloggs'> givenName sn

 

 

 

to force a user to change password:

 

zmprov ma [email protected] zimbraPasswordMustChange TRUE

 

to change description:

 

zmprov ma [email protected] description S12345

 

to delete:

zmprov da j*@wolsinghamschool.net

 

 

Zmprov Command Files (bulk)

 

The Zmprov command will accept commands from a file (or stdin) as input. Create a text file ("commands.zmp" for example) with the zmprov subcommands each on a line.

 

 

createAccount [email protected] password displayName 'Andy Anderson' givenName Andy sn Anderson

createAccount [email protected] password displayName 'Betty Brown' givenName Betty sn Brown

 

This can be set up in Excel then saved as tab delimited. Note fields with spaces must have 'inverted commas' around them

Then send the contents of the file to zmprov.

 

Logged in As Zimbra:

 

 

zmprov < commands.zmp

Edited September 22, 2010 by CarolBooth
formatting