Callque Id

[Guest moula]

can i get any scripts of an out dial

 

that select a (phone number and message) from data base, dial the phone number and play the message

 

then go to the next record in data base

 

the data base containe a liste of records ( outdial number, message to play, valid call(yes/no) )

[Guest moula]

can i get the ID of records from CallQue table in data base after dailing out the phone number found in table

i have insert a record into CallQue table : id, phone,script , ..., msg1, msg2, msg3

the table may contain many records with the same phone number but with differents messages to play

after runing, the script must search in CallQue table the liste of message to play specified for this phone number dialed out:

SELECT msg1, msg2, msg3, msg4 FROM CallQue WHERE CallQue.ID = (varible)

 

what is the "variable" that can i use in my SELECT

[SupportTeam]

The ID field is an indexing 'auto-number'...

 

I think you'd be better served sticking your own information in the RV column - then you could search for entries which contain in the RV column the substring you're seeking.

 

Or you could just store the sound files as RVs (Result Variables) themselves...

 

There is no direct way to find out what is the ID of the call just queued.

[SupportTeam]

Have you read this: http://www.voiceguide.com/vghelp/html/DialListInto.htm

[Guest moula]

yes i have read this page.

and i have run the out dialer but i have to get the field CallQue.ID for the actual out call in order to play a liste of message specific for The phone number that is called

 

the structure of table CallQue is :

ID, PhoneNumber, ActivateTime,..., msg1, msg2, msg3

 

SELECT msg1, msg2, mg3 FROM CallQue where ID = "VARIABLE ID"

 

how can i get the "VARIABLE ID" from system?

[Guest moula]

after the system dial out a phone number, how can i affect the CallQue.ID (of actual call) to Result variables (in Telephone Numbers Loader) in order to use it in my SELECT?

after runing the script when a real person answers, i have to play a liste of messages (in data base CallQue) to this person

SELECT msg1, msg2, msg3, msg4 FROM CallQue WHERE CallQue.ID = (Result variable)

[SupportTeam]

The answer provided before still applies:

The ID field is an indexing 'auto-number'...

 

I think you'd be better served sticking your own information in the RV column - then you could search for entries which contain in the RV column the substring you're seeking.

 

Or you could just store the sound files as RVs (Result Variables) themselves...

 

There is no direct way to find out what is the ID of the call just queued

.