Update UserID via AXL?

Answered Question
Aug 18th, 2008

Hi

I have a need to change the userID of a large number of users on a CM6.1 system.

Obviously pre-CM5 you couldn't change the userID, but on the linux versions you can.

I've reviewed the AXL API docs, but it doesn't appear to have been updated to include the ability to rename the UserID field.

Is this correct, or is there a way of doing this?

Thanks

Aaron

I have this problem too.
0 votes
Correct Answer by Sascha Monteiro about 8 years 3 months ago

Hi Aaron,

I haven't tried it myself but I guess you can use executeSQLUpdate on the enduser table?

I reckon you should extract all users and use the pkid to update userid

hth

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (2 ratings)
Loading.
Correct Answer
Sascha Monteiro Mon, 08/18/2008 - 12:45

Hi Aaron,

I haven't tried it myself but I guess you can use executeSQLUpdate on the enduser table?

I reckon you should extract all users and use the pkid to update userid

hth

Aaron Harrison Wed, 02/11/2009 - 03:18

Update- I was able to do this, submitting a SQL update via AXL.

There's no other native way in the AXL API yet to submit a userID change, I think this is a legacy problem as in CM4.x the UserID couldn't be changed!

I've done this for a couple of customers for large numbers of users, and haven't had any problems - EM and other things related to the user all continued to work so it doesn't break the DB.

The easiest way to do it is to get the axlSqlToolkit from the CallManager Plugins download page. Edit the sample.request to contain lines like this:

<?xml version="1.0" encoding="UTF-8"?>

query CDATA #IMPLIED

update CDATA #IMPLIED

>

]>

Please rate useful posts...

Actions

This Discussion