Author Message
MauricioGonzález2
Joined: Nov 27, 2013
Messages: 40
Offline
Hello,
I want to populate Preview Contact database dynamically inserting new customer records, how can I achieve this?
CedricDSouza
Joined: Nov 6, 2008
Messages: 14
Offline
You can use the following stored procedure AddCallBack with the necessary parameters, the description of the parameters are shown below

USE [ASMSControl]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[AddCallBack]
@ProgramId = '894d07b6-a812-4c59-98b7-b6c90167649a', -- Program id of the PCMS Queue
@QueueId = '894d07b6-a812-4c59-98b7-b6c90167649a', -- Program id of the PCMS Queue
@ServerInstanceType = '50B4DADB-7F2E-41ef-AFBD-051B9C279D95', -- -- Fixed to PCMS ServerInstanceType-Dont change
@ServerInstanceId = '52197658-d4f4-4b9b-9726-20a7efdf061d', --- Get the server instance id from PCMS ini file
@CustomerId = N'6f077342-778e-41d3-8bc8-9d7af620440c', --- if you want to associate with customer id
@FirstContactOption = N'Voice', --- if you want the first option as Voice
@FirstContactOptionDetails = N'22006', -- the phone no
@SecondContactOption = N'Email', ----- if you want the second option as Email
@SecondContactOptionDetails = N'cedriccust@ccms.apac.avaya.com' --- the email id

SELECT 'Return Value' = @return_value

GO
MauricioGonzález2
Joined: Nov 27, 2013
Messages: 40
Offline
Thanks by the answer Cedric, for the return_value, what result should I consider as successful?
Go to:   
Mobile view