Solved Predictive Dialer Numbers to call

[n1mbul4n]

Greetings,

I have a problem in setting up my predictive Dialer, I create an extension to call the Predictive Dialer to 100 but then when I call the said extension it will not answer and it will connect to Voicemail and Operator, what am I missing?

The second thing where do I add numbers on the list?

 

[n1mbul4n]

this is the Screenshot

 

[n1mbul4n]

 

[edossantos]

I have a problem in setting up my predictive Dialer, I create an extension to call the Predictive Dialer to 100 but then when I call the said extension it will not answer and it will connect to Voicemail and Operator, what am I missing?

You should set a free extension number to your CFD app, from the Build > Project Extension menu. Then, when you upload your dialer to 3CX, it will use this extension. You need to call this extension number once in order to wake up the dialer. You can do this from your normal extension, you don't need to create a special extension for this.

The second thing where do I add numbers on the list?

From your screenshot I can see that your dialer is getting numbers from a database... Please read the guide and take the time to understand what you're doing, because the sample is not a dialer ready to use out of the box. You need to understand what it does, because you will need to make changes to it.

 

[n1mbul4n]

Thank you so much Boss, will study the guide thoroughly, will get back to your when I find any difficulties on understanding the flow. God bless

 

[n1mbul4n]

Hi @edossantos I manage to connect to the Database but the problem is when I dial the number it says call not found and can you check if the SQL statement is on the right track

 

[edossantos]

Your SQL statement should end with "LIMIT 1" and not 0, otherwise no record will be returned.

I'm not sure if this is causing the issue. You need to check the logs in verbose mode to understand what's going on. I would recommend you to check this troubleshooting guide:
https://www.3cx.com/docs/manual/cfd-troubleshooting/

 

[n1mbul4n]

Your SQL statement should end with "LIMIT 1" and not 0, otherwise no record will be returned.

I'm not sure if this is causing the issue. You need to check the logs in verbose mode to understand what's going on. I would recommend you to check this troubleshooting guide:
https://www.3cx.com/docs/manual/cfd-troubleshooting/

Hi @edossantos

Here is the recent Log File after I woke up the Dialer.

 

[edossantos]

Hi @edossantos

Here is the recent Log File after I woke up the Dialer.

View attachment 22315

That's the 3CX activity log. CFD apps write their logs to the 3CXCallFlow.log file, you should check there.

 

[n1mbul4n]

I'm sorry, here is the log file on Call Flow

 

[n1mbul4n]

Hi Edo,

I just look at the Log File it says Error Handler Flow is Empty

 

[edossantos]

This is the error you're having, taken from the log you sent:

2021/06/02 13:22:12.041|945|0049|Err|CallPair._100_4.Callflow.237.[C:107.2]-From script: PredictiveDialer - Dialer 0 - Dialer - Error executing last component: MySqlConnector.MySqlException (0x80004005): Host '192.41.56.189' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

 

[n1mbul4n]

Hi Edo, I manage to fix the following Issue with the Database, I am wondering why I get the following error ->


2021/06/22 10:15:03.085|936|0031|Err|CallPair._100_4.Callflow.48.[C:22.2]-From script: PredictiveDialer - Dialer 0 - Dialer - Error executing last component: MySqlConnector.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM `Customers` WHERE Number='getNextNumber.ScalarResult"' at line 1


This is the settings on my call Flow ->

 

[edossantos]

Mmmm, the error you get doesn't seem to be related to the screenshots you sent. Can you send me a ZIP with your entire CFD project sources so I take a look? Send it in a private message, or remove passwords before sending it.

 

[n1mbul4n]

Hi Edo I manage to fix the error and I able to activate the Dialer but stuck on the first phone # - see the ss - I tried to update to the very next number, but it seems like it stock on the first one here is the SQL statement under update #: UPDATE `Customers`.`Number`FROM `Customers` WHERE Number='getNextNumber.ScalarResult"

 

[edossantos]

I tried to update to the very next number, but it seems like it stock on the first one here is the SQL statement under update #: UPDATE `Customers`.`Number`FROM `Customers` WHERE Number='getNextNumber.ScalarResult"

You're using a constant string there, so the WHERE clause will never match a record. You should use an expression:
CONCATENATE("UPDATE `Customers`.`Number`FROM `Customers` WHERE Number='",getNextNumber.ScalarResult,"'")

 

[n1mbul4n]

You're using a constant string there, so the WHERE clause will never match a record. You should use an expression:
CONCATENATE("UPDATE `Customers`.`Number`FROM `Customers` WHERE Number='",getNextNumber.ScalarResult,"'")

Thanks Edo for the response, I already updated the Query, the only thing that bothers me is why It stuck at the first number and it didn't move to the very next number when the Dialer was activated.

 

[n1mbul4n]

I got this following error when checking on the Log after I update the WHERE clause.

Error executing last component: MySqlConnector.MySqlException (0x80004005): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONCATENATE("UPDATE `Customers`.`Number`FROM `Customers` WHERE Number='",getNext' at line 1

 

[edossantos]

The dialer will call the number you get from the database. Your database query is returning always the same number. You should add a WHERE clause to filter out numbers that you already called.

 

[n1mbul4n]

Solved! Thanks, Edo for all your help! God bless.