ACS 5.2 - adding and updating users automatically

[msingh2007]

Hello, I have a Cisco ACS 5.2 and have set it up as a RADIUS server.  I was wondering if there is a way to add and update users automatically?  We have a large number of users > 1000 that need to be added into the system and I don't want to do this manually.  These users also update their passwords on a regular basis so I would need a script that would update the users automatically without any user intervention.  Please let me know.

Thanks!

[aneelaka]

Dear Valued Cisco Customer,

I will be out of the office from 03/20/2010 until 04/04/2010. During

this time, I will have no access to email or voicemail. If you require

assistance during my absence, please contact Manivannan Srinivasan via

phone at 469-255-4806 or via email at mansrini@cisco.com and this

engineer will continue to work any immediate concerns you may have at

this time. If this issue can wait until my return on 04/05/2010, I will

be glad to continue working with you. If you require assistance outside

of our business hours (10:00am - 7:00pm CST), please contact the TAC by

calling 1800-553-2447 or email tac@cisco.com and request to have the

service request re-assigned.

Best Regards,

Abhishek Neelakanata

[padatta]

There is a provision to update this using csv file. Here is the reference.

http://www.cisco.com/en/US/partner/docs/net_mgmt/cisco_secure_access_control_system/5.2/user/guide/users_id_stores.html#wp1059904

Step 1 Click File Operations on the Users, Network Devices, or MAC Address page of the web interface.

The Operation dialog box appears.

Step 2 Click Next to download the .csv file template if you do not have it.

Step 3 Click any one of the following operations if you have previously created a template-based .csv file on your local disk:

•Add—Adds the records in the .csv file to the records currently available in ACS.

•Update—Overwrites the records in ACS with the records from the .csv file.

•Delete—Removes the records in the .csv file from the list in ACS.

Step 4 Click Next to move to the next page.

Step 5 Click Browse to navigate to your .csv file.

Step 6 Choose either of the following options that you want ACS to follow in case of an error during the import process:

•Continue processing remaining records; successful records will be imported.

•Stop processing the remaining records; only the records that were successfully imported before the error will be imported.

Step 7 Check the Password check box and enter the password to decrypt the .csv file if it is encrypted in GPG format.

Step 8 Click Finish to start the bulk operation.

The Import Progress window appears. Use this window to monitor the  progress of the bulk operation. Data transfer failures of any records  within your .csv file are displayed.

You can click the Abort button to stop importing data that is under way;  however, the data that was successfully transferred is not removed from  your database.

When the operation completes, the Save Log button is enabled.

Step 9 Click Save Log to save the log file to your local disk.

Step 10 Click OK to close the Import Progress window.

You can submit only one .csv file to the system at one time. If an  operation is under way, an additional operation cannot succeed until the  original operation is complete.

Paps

[aneelaka]

Dear Valued Cisco Customer,

I will be out of the office from 03/20/2010 until 04/04/2010. During

this time, I will have no access to email or voicemail. If you require

assistance during my absence, please contact Manivannan Srinivasan via

phone at 469-255-4806 or via email at mansrini@cisco.com and this

engineer will continue to work any immediate concerns you may have at

this time. If this issue can wait until my return on 04/05/2010, I will

be glad to continue working with you. If you require assistance outside

of our business hours (10:00am - 7:00pm CST), please contact the TAC by

calling 1800-553-2447 or email tac@cisco.com and request to have the

service request re-assigned.

Best Regards,

Abhishek Neelakanata

[msingh2007]

Thanks for those notes but I have already seen this in the guide.  This is a manual way to do it.  What I was asking is if there is an automatic way to add/update users.

Does anyone know how to create a scheduled command/script that would look for a CSV file with a fixed name in the repository to perform a bulk add/update operation?  I know ACS support Python but I don't know how to program in Python.  Please let me know if anyone can provide me with this script and how I would schedule this on the ACS system.

Thanks!