Call Flow Script: Route Calls Based on Caller ID

[IliasL_3CX]

Direct incoming calls automatically based on the caller’s number to specific destinations.​

This script allows you to direct incoming calls to specific destinations based on the caller’s phone number. It checks a list of numbers stored in a file, and routes matching calls accordingly. This is useful for prioritizing VIP cust...

Continue reading the Original Blog Post.

 

[Bart - Libra ICT]

Would this work with a 30,000 line CSV or is there a maximum size or number of stored phonenumbers?

 

[fxbastler]

Would this work with a 30,000 line CSV

yes, it just takes some time

or is there a maximum size or number of stored phonenumbers?

Technically the limit could be 2^64 / 2 -1
But I think the 3CX's RAM will be used up before then.

 

[Evolute IT]

If you have a 30K lines CSV, consider using a database with a small web service and call that service in the call script instead of loading thousands of numbers in memory.

You can do HttpClient requests in the scripts.

 

[fxbastler]

I would look about the file size, the amount of memory taken during multiple calls and how long it takes to execute the whole query:

var watch1 = System.Diagnostics.Stopwatch.StartNew();
// ...  code to measure ...
watch1.Stop();
MyCall.Info("******** watch1 total duration in ms is " + watch1.ElapsedMilliseconds.ToString());

If something becomes too big and doesn't fit then solve it differently, see @ConceptsWeb above.

 

[N_G]

Good suggestions and great help by @fxbastler and @ConceptsWeb However this amount of data should be in a database. A CSV file with 30K records is ridiculous sorry. Of course results will be poor and then 3CX will be blamed.

 

[gonzague]

Very cool! thanks

 

[jmontero]

Hi all,

How upload .csv file? gui only permit .wav

Thanks