Welcome to WebmasterWorld Guest from 54.159.165.175

Forum Moderators: coopster & jatar k

Integrating SMS Replies with database

Need major help figuring this one out

   
2:17 pm on Sep 17, 2007 (gmt 0)

10+ Year Member



Hey everyone,

I posted this in mobile computing and there doesn't seem to be many eyeballs over there. We've developed a site that gathers leads for our clients and distributes them to the client's reps. Currently, the reps need to log in to the site to either accept or reject the leads because if they don't accept them within a few hours, the leads get passed on to the next rep. Because of the time sensitive nature of the leads, we want to integrate an SMS system that would send them an SMS alert along with the ability to reply with a simple "1" to accept the lead or "2" to reject it. Then we need to accept those responses and gather them into our dbase (MySQL) and interpret them accordingly.

I know one of you geniuses out there must have done something similar. Please help me out on this one as I am slamming my head into a wall looking at gateways.

Benny

3:19 pm on Sep 17, 2007 (gmt 0)

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member



I have done similar types of things with email

- store leads in db
- send email and check a column as sent
- id in subject of email
- person replies with appropriate response
- email is sent to a processing address which uses [procmail.org...]
- procmail sends it through a script that will process the response
- set column to confirm or resend to next person

3:27 pm on Sep 17, 2007 (gmt 0)

10+ Year Member



But have you done this with SMS ever? Responses with email is something we have done in the past as well, but never with SMS. Thanks
3:30 pm on Sep 17, 2007 (gmt 0)

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member



it isn't that different, you need to send a message to a phone and you you need the message sent back to where a script can get at it and process it
3:41 pm on Sep 17, 2007 (gmt 0)

10+ Year Member



Exactly. Just wondering if anyone can help with a recommended SMS gateway or an existing script that may help.
5:10 pm on Sep 18, 2007 (gmt 0)

10+ Year Member



Anyone else able to lend some knowledge?
 

Featured Threads

My Threads

Hot Threads This Week

Hot Threads This Month