Simple touchtone recorder - $100
Submitted by PatrickMathews on Wed, 06/04/2008 - 4:20pm.
I'm fairly new to trixbox so I may be not be describing the best way this could work...
I'd like to have a full on database dipping agi script for my pharmacy but after reading what is involved in that I think it's probably a bit out of my budget. So short of that, I'd like to be able to have a customer call and get a recording asking for (in this case) prescription number, then have asterisk convert the touch tones that the customer enters to a text file along with a time and date stamp and the caller id. I would like the option of having the number read back to them for verification. I would like to get to this file via excel or something similar and from there I could cut and paste to our pharmacy system each morning. This would save me from listening to voice mail messages and transcribing them.
I think this could be a nice generic tool for a lot of trixbox/asterisk/free pbx users.
I'm not sure the best way to do this but I think a custom destination???
I might toy with this a
Wed, 06/04/2008 - 4:26pm
I might toy with this a little, sounds fun.... and wouldn't be to involved to do a simple deal that goes in to a webpage to cut and paste......
Can you give me a sample perscription ID#
The full on project...
Wed, 06/04/2008 - 5:36pm
There are really two levels beyond what is described above (just capturing the number input by the caller).
Level two is to capture the number input by the caller, find the number in the file, look at the next field (number of refills available) and return a result code that would determine which announce to play back to the caller. There would be three possible result codes:
Prescription number not found
No refills available (if number of refills available is 0)
Refill available (if number of refills is greater than 0 and expiration date is after today)
Level three would be all of level one and two and update our pharmacy system to put the refill in the work queue or request a new refill from the doctor. This level of integration with our pharmacy system would require some help from that vendor. We do have odbc access to the database (it is not a sql database). I've been trying to pry open the ability to do this programaticly from them but they are somewhat closed architechture.
As far as budget goes - I couldn't really say until I know what is going to be required by our pharmacy system vendor.
Ok, once you have some
Wed, 06/04/2008 - 5:43pm
Ok, once you have some estimates of budgets, contact me. Also let me know where the responsibilities lay in interfacing with disparate systems. I think you may find that the development cost on the Asterisk platform is lower than you think, especially if you can provide easy mechanisms for sending and receiving information into the pharmacy systems involved.
Gads, didnt read till this
Thu, 06/05/2008 - 8:15am
Gads, didnt read till this morning... Here is my thought....
Even at level 3 this is about a 200 line and probably 1200 if I go all whitespace and comment crazy. I could dum this in to freepbx module format as a destination....
I am guesssing writing + Testing 3 to 4 hours max
The first level could probably be done in about 30 minutes max in fact that would probably be most of the work and since I would write to a database anyway for the results web page it wouldn't be hard to expand that to an external system,,, I would not certify it HIPPA compliant however as that would take more forethought on security and encryption. But as long as I don't claim HIPPA I guess its up to you to be sure it is all secure :)
Member Since:
2008-05-22