I am looking for a means to script the MR Admin functions for maintaining Users' entries and their Group enrollments.

Is there an API? -- I couldn't find any method referenced in the admin manual other than the GUI.

Has anyone done this successfully with SQL code?

This message has been edited. Last edited by: Kerry,

Webservices has a number of calls that can be utilised. Have used this and it works okay, but a bit limited in some respects.

There are Web Service that can do most funtions that you can do in the GUI.

If you have your MRE repository in an RDBMS you can use SQL to update user information. I normally recommend the use of the GUI for maintaining role, group and domain information since this doesn't change often then use SQL to add a row for the user in WF_MRUSERS and then one row each for the user to group relationships. the WF_USRGRPTB.

There is no supported migration routine to migrate from the file based repository to a RDBMS repository. Send me an email and I can send you something which was field developed if you would like to migrate and use SQL. ron_eernisse@ibi.com