CUPC contact SQL insert

Unanswered Question
Apr 18th, 2012
User Badges:

Has anyone used the following command to populate a users contacts? Just wondering if I need to include all of the table fields (i.e., index,displayonphone,iscup,isblocked).

Get user pkid:

run sql select pkid from enduser where userid='Enduser ID'

Get fkepascontactgroup:

run sql select * from epascontacts where fkenduser_owner = 'pkid'

Insert new contact:

run sql insert into epascontacts (fkenduser_owner,fkepascontactgroup,buddy) values 'pkid','fkepascontactgroup','buddy'

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)


This Discussion