CUPC listing users

Unanswered Question
Jul 14th, 2008
User Badges:
  • Purple, 4500 points or more

In CUPC, is there any way to populate the general group with all the users in the directory ? or end users have to search individual users from directory and add them manually?

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Tommer Catlin Fri, 07/18/2008 - 10:02
User Badges:
  • Green, 3000 points or more

I dont think there is a way to do this. Because it's a customized "buddy list" What you could do, not sure if it will work, but build one CUPC client, then use BAT and export it. Then copy and paste the output (if any for the buddy list) to another CUPC client.

Good question though

kylepetree Mon, 03/29/2010 - 10:19
User Badges:

  FYI - I tried exporting a user and it did not contain their contacts....

Aaron Harrison Mon, 03/29/2010 - 11:07
User Badges:
  • Super Bronze, 10000 points or more
  • Community Spotlight Award,

    Member's Choice, May 2015

Hi All

I've just had a little play around with this...

The contacts seem to be stored in a table called 'epascontacts', and these reference the owner user in the endusers table (via pkid) and the users list of contact groups in the epascontactgroup table (again via PKID).

It appears you can insert contacts to a user with a query like so (replacing john.doe with the 'owning' user ID, and jane.doe with the useridof the contact you want them to have):

run sql insert into epascontacts (fkenduser_owner,fkepascontactgroup,buddy) values ((select pkid from enduser where userid='john.doe'),(select  pkid from epascontactgroup where fkenduser = (select pkid from enduser where userid ='john.doe') and index = '0' ),'jane.doe')

As each user can have more than one contact group, and may have renamed the 'General' one, it just sticks the contact in the 0 index contact group. For new users, this should be fine..

So if you are feeling reckless, and dismayed by the lack of a documented AXL API... you could just batch up a load of such statements generated in Excel or whatever means you have... and fire them in using the AXLSQLToolkit.

Bear in mind my 10 minutes testing this doesn't mean you should use it on a production system...



Please rate helpful posts...


This Discussion