BulkuserCreation-in-zimbra: Difference between revisions
Created page with " == '''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..." |
No edit summary |
||
| Line 5: | Line 5: | ||
'''Output File from Customer''' | '''Output File from Customer''' | ||
TYPE ZONE STATE LOCATION CODE NAME SSP new e mail id | 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 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 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 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 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 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 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 | SSP NORTH ZONE DELHI DEOLI 20741 M/S. PASHUPATI AUTOS asc. pashupa.deoli @ heromotocorp.biz asc.pashupa.deoli@heromotocorp.biz | ||
in | in excel | ||
'''Convert it into csv''' | '''Convert it into csv''' | ||
asc.pooja.chiragdelhi@heromotocorp.biz,cfG7C1rwvv1,NORTH ZONE,DELHI,CHIRAG DELHI,20315,M/S. POOJA AUTOMOBILES | 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.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.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.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.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.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.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.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.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.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.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.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.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 | asc.kkauto.naraina@heromotocorp.biz,TsP0NCm48T1,NORTH ZONE,DELHI,NARAINA,22560,M/S. K K AUTO | ||
#!/bin/sh | #!/bin/sh | ||
IFS="," | |||
IFS="," | while read email password street State City postal display | ||
while read email password street State City postal display | do | ||
do | |||
echo Email: $email | echo Email: $email | ||
echo Password: $password | echo Password: $password | ||
| Line 47: | Line 46: | ||
echo postal: $postal | echo postal: $postal | ||
echo Display: $display | echo Display: $display | ||
zmprov ca "$email" "$password" street "$street" st "$State" l "$City" displayName "$display" postalCode "$postal" zimbraMailQuota "1073741824" | zmprov ca "$email" "$password" street "$street" st "$State" l "$City" displayName "$display" postalCode "$postal" zimbraMailQuota "1073741824" | ||
done </tmp/user-test.csv | done </tmp/user-test.csv | ||
Revision as of 14:30, 26 June 2014
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