BulkuserCreation-in-zimbra

Script to create bulk user in zimbra

Output File from Customer

TYPE	ZONE	STATE	LOCATION	CODE	NAME					SSP new e mail id
SSP	NORTH ZONE	DELHI	CHIRAG DELHI	20315	M/S. POOJA AUTOMOBILES	asc.	pooja.chirag delhi	@	heromotocorp.biz	asc.pooja.chirag delhi@heromotocorp.biz
SSP	NORTH ZONE	DELHI	EAST OF KAILASH	20476	M/S. J.K.ENTERPRISES,	asc.	jKent.east of kailash	@	heromotocorp.biz	asc.jKent.east of kailash@heromotocorp.biz
SSP	NORTH ZONE	DELHI	PITAMPURA	20635	M/S. OSWAL AGENCIES,	asc.	oswal.pitampura	@	heromotocorp.biz	asc.oswal.pitampura@heromotocorp.biz
SSP	NORTH ZONE	DELHI	JAMIANAGAR	20622	M/S. PIONEER ENTERPRENEURS PVT LTD	asc.	 pioneer.jamianagar	@	heromotocorp.biz	asc.pioneer.jamianagar@heromotocorp.biz
SSP	NORTH ZONE	DELHI	NANGLOI	20901	M/S. SHARMA AUTOMOBILES	asc.	sharma .nangloi	@	heromotocorp.biz	asc.sharma .nangloi@heromotocorp.biz
SSP	NORTH ZONE	DELHI	BURARI	21055	M/S. DARA MOTORS	asc.	dara.burari	@	heromotocorp.biz	asc.dara.burari@heromotocorp.biz
SSP	NORTH ZONE	DELHI	DEOLI	20741	M/S. PASHUPATI AUTOS	asc.	pashupa.deoli	@	heromotocorp.biz	asc.pashupa.deoli@heromotocorp.biz

in excel

Convert it into csv

asc.pooja.chiragdelhi@heromotocorp.biz,cfG7C1rwvv1,NORTH ZONE,DELHI,CHIRAG DELHI,20315,M/S. POOJA AUTOMOBILES
asc.jKent.eastofkailash@heromotocorp.biz,jlkTJ6Yj181,NORTH ZONE,DELHI,EAST OF KAILASH,20476,M/S. J.K.ENTERPRISES
asc.oswal.pitampura@heromotocorp.biz,MzkSurtRpN1,NORTH ZONE,DELHI,PITAMPURA,20635,M/S. OSWAL AGENCIES
asc.pioneer.jamianagar@heromotocorp.biz,LnuIGf89VT1,NORTH ZONE,DELHI,JAMIANAGAR,20622,M/S. PIONEER ENTERPRENEURS PVT LTD
asc.sharma.nangloi@heromotocorp.biz,CE5oXj89w11,NORTH ZONE,DELHI,NANGLOI,20901,M/S. SHARMA AUTOMOBILES
asc.dara.burari@heromotocorp.biz,7qzSdtm1vX1,NORTH ZONE,DELHI,BURARI,21055,M/S. DARA MOTORS
asc.pashupa.deoli@heromotocorp.biz,jesNzY34MC1,NORTH ZONE,DELHI,DEOLI,20741,M/S. PASHUPATI AUTOS
asc.jmd.budhvihar@heromotocorp.biz,Kf9MHACGdx1,NORTH ZONE,DELHI,BUDH VIHAR,21582,M/S. JMD AUTOMOTIVE
asc.apex.patparganj@heromotocorp.biz,AVzqQ2zjld1,NORTH ZONE,DELHI,PATPARGANJ,21755,M/S. APEX AUTOMOBILES PVT LTD
asc.metro.bawana@heromotocorp.biz,bcCgWJkr6u1,NORTH ZONE,DELHI,BAWANA,22030,M/S. METRO AGENCIES
asc.sangam.kanjhawala@heromotocorp.biz,ENXeoVwKVm1,NORTH ZONE,DELHI,KANJHAWALA,22114,M/S. SANGAM AUTOMOBILES
asc.kukreja.munirka@heromotocorp.biz,lpkObU6rGu1,NORTH ZONE,DELHI,MUNIRKA,22360,M/S. KUKREJA AUTOMOBILES
asc.goyal.chattarpur@heromotocorp.biz,ubDeZKoikM1,NORTH ZONE,DELHI,CHATTARPUR,22540,M/S. GOYAL MOTORS
asc.kkauto.naraina@heromotocorp.biz,TsP0NCm48T1,NORTH ZONE,DELHI,NARAINA,22560,M/S. K K AUTO

#!/bin/sh
IFS=","
while read email password street State City postal display
do
   echo Email: $email
   echo Password: $password
   echo Street: $street
   echo State: $State
   echo l: $City
   echo postal: $postal
   echo Display: $display
   zmprov ca "$email" "$password" street "$street" st "$State" l "$City" displayName "$display" postalCode "$postal"  zimbraMailQuota "1073741824"

done </tmp/user-test.csv