i am using freepbx for some time now and have connected a 4 port FXO gateway and all is working well.
I have a client database of around 23K people, with few duplicates and few with incorrect contact details (missing numbers etc). i want to inform all of them regarding new activities and thus, I want to setup -
automated outbound calls and play pre recorded announcement and then hang up.
Have a sql database with contact details, thus want freepbx to access the sql database,
check the row for the contact number and if contact number is 10 digits then dial it else skip to next row.
i want to limit to 400 calls per day (with 4 concurrent calls) with time bound start and stop of the calling (morning 10 AM to evening 6 PM)
also next day it should start from the row it stopped on the previous day.
reports - summary of calls made, connected time
PS : i am not a good with creating scripts so would be glad if there is any GUI based solution.
I can export sql database to excel or csv if required.
i am not a coder by any means and it is hard to understand the syntax of VB or how to use it.
so using the tutorial, i am able to make .call files and it does make outbound calls … hurray!!
now i need to
-understand how to automate the process to create .call file and substitute the contact number from the separate list to the call file.
-have 4 trunks and thus need a script that will spit 4 call files and then wait for xxx time and then again spit out 4 files along with moving the files to the outgoing folder.
-also there is no feedback whether call went through/picked up/busy/call failure if any.
-also there is no way to transfer the files processed by the asterisk to another folder for archiving.