From CLAWSWiki

Bulk operations allow you to script many additions, modifications and deletions in a row. You first set up a text file on your local computer. The text file contains comma delimited fields with one operation per line. Trailing commas are never needed but will not hurt. When you have a file ready, type the filename into the text box on the bulk operations' page. You can also click browse and select the text file. Finally, you click one of the operation buttons: Add, Modify, or Delete. Each operation requires a very specific text file.

Not all fields are required. If you do not have the information, just put the comma and continue. For the check box fields (marked (1) below) you should put a 1 if you want it checked. Be VERY careful with your commas.

Add

Each line in a bulk add text file has the following fields:

1. ritid
2. username
3. password
4. first name
5. middle name
6. last name
7. email
8. account type
9. program code
10. department
11. secret word
12. expiration date
13. account status
14. block quota
15. file quota
16. calendar user (1)
17. send notify (1)
18. restricted (1)
19. special (1)
20. notes

This example will create a non-restricted student account:

  999999999,zzz9999,zzz,z,zzz,zzz9999@osfmail.rit.edu,student,icsg,,,,active,9,9

Modify

Very similar to Add but there is an extra field at the end that is only used for renaming the account to a different username. Make sure you also rename the email address when you change the username. Also, there is a real name field after email. Please note that if you change any part of the name i.e. first or last, you should also type in the new real name field as this is not done for you.

You cannot remove field information in a bulk modify as any blank fields are ignored. Please use normal modify routines to do that. Each line in a bulk modify text file has the following fields:

1. ritid
2. username
3. password
4. password reset (1)
5. first name
6. middle name
7. last name
8. email
9. real name
10. account type
11. program code
12. department
13. secret word
14. expiration date
15. account status
16. block quota
17. file quota
18. calendar user (1)
19. send notify (1)
20. restricted (1)
21. special (1)
22. notes
23. new username

This example will change the first name of the user zzz9999 to Joe:

  ,zzz9999,,,Joe

This example will rename zzz9999 to zzz9998 and change his email address: (yes, you need all the commas)

  ,zzz9999,,,,,,zzz9998@ofsmail.rit.edu,,,,,,,,,,,,,,,zzz9998

Delete

The delete file is just a list of usernames. One username per line.

This example will delete the users zzz9999 and zzz9998:

  zzz9999
  zzz9998