Welcome to WebmasterWorld Guest from 34.236.170.48

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Integrating SMS Replies with database

Need major help figuring this one out

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

Junior Member

10+ Year Member

joined:Apr 23, 2004
posts: 142
votes: 0


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 Sept 17, 2007 (gmt 0)

Administrator

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

joined:July 24, 2001
posts:15756
votes: 0


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 Sept 17, 2007 (gmt 0)

Junior Member

10+ Year Member

joined:Apr 23, 2004
posts:142
votes: 0


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 Sept 17, 2007 (gmt 0)

Administrator

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

joined:July 24, 2001
posts:15756
votes: 0


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 Sept 17, 2007 (gmt 0)

Junior Member

10+ Year Member

joined:Apr 23, 2004
posts:142
votes: 0


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

Junior Member

10+ Year Member

joined:Apr 23, 2004
posts:142
votes: 0


Anyone else able to lend some knowledge?
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members