[SOLVED] Automating user add/remove

[ceefus]

Hello,

I'm trying to move my company from Exchange to Zimbra. Currently I have about 10 users migrated and everything is working well. The obsticle that I need to overcome is the addition and removal of users. Currently there is a script in place for Exchange that will add/remove a user based on entries from payroll. The script is Tab delimited and has the user, domain (there are 13), employee number, and their status (active,inactive). I need to find a way to take this file and add a user if they're put in active status or remove a user if they're inactive. I also need it to set their password to their employee number and set the domain according to which office they work at..

The file we'll be using looks like this:

User Domain Emp# Status
Jim Smith Office1 123456 Active
Jon Smith Office2 112345 Inactive
Jan Smith Office3 111345 Active

I could also make this file a CSV if needed or manipulate the fields as needed.. I need an idea of how to accomplish this before I can migrate all of the offices....

Any help would be much appreciated!

Thanks in advance.

[uxbod]

Zmprov - Zimbra :: Wiki

[ceefus]

Thanks UXBOD, I saw the wiki on zmprov... The problem I have is... I'm not sure how to script it.. I have done some programming but I'm not sure how to get zmprov to roll down the list.. Especially when the list is long, recently we closed an office and let go about 120 people...

The output will be either:

Name,EmployeeNumber,Domain,Status
John Smith,1003001,Green1.com,active
Jane Smith,1004002,Green2.com,active
Jannet Lafferty,1005500,Green3.com,inactive
Jeffery Campbell,1005110,Green3.com,active

Or

Name EmployeeNumber Domain Status
John Smith 1003001 Green1.com active
Jane Smith 1004002 Green2.com active
Jannet Lafferty 1005500 Green3.com inactive
Jeffery Campbell 1005110 Green3.com active

[uxbod]

Well CSV is always nicer So perhaps something like this

su - zimbra
while read NAME EMPNO DOMAIN STATUS
do
  case ${STATUS} in
    active) zmprov ca ${NAME}@${DOMAIN} ${EMPNO} displayName ${NAME}
    ;;
    inactive) zmprov da ${NAME}@${DOMAIN} 
    ;;
  esac
done < /tmp/filename.csv

[ceefus]

I have created a fully functional perl script that adds users from a .CSV. If anyone needs it please PM me and I'll get you a copy.

Have a good one