Has anyone setup callerid with Freepbx. I have no problem connecting the Freepbx to the MSSQL database. Where I am stuck is how to get the phone number and name into SambaPOS like the CallerID Module does.
I would really like to see if this is possible too.
FreePBX is based on Asterisk with is a common software package used across many systems, so I have updated the title of this thread accordingly as it might be clearer to people browsing through.
If anyone has any hints on how we could connect Asterisk or FreePBX to SambaPOS I would be very interested to hear 
I have plans 
You want caller ID type setup.
From my understanding your way to achive that would be to add a trigger to the calling pattern on freepbx/astrix which triggers an automation command in samba which is doable through the API.
My project is to create a call billing system into our PMS API using similar tacktic of triggered event on hangupp which posts a charge to the PMS.
My backup plan is to use samba to read the call records and create the charges.
The other idea is to use room phones to mark rooms as clean by housekeeping.
This would be again most efficient as a call event on freepbx but backup plan again using samba is a callerID device on an extention which is called by housekeeping and samba takes the incoming caller id (room extention) and knowing that posts to PMS API to mark room as clean.
I can do all the above through samba already but want to try the inside freepbx option first before implimenting as would be the better solution.
However todate I have only been able to spend minimal time loking at how to make these customisations.
From my understanding you can call a script/cuntion from the call plan/routing system but thats the part I have yet to look at.
The script part would be fairly normal scripting for APIs.
In your case it would be to SambaPOS API to start some automation flow. In my case it would be directly to PMS API but principles are the same.