Topic: Looking to Post updates to website via email/SMS (Page 1 of 1) Pages that link to <a href="http://ozoneasylum.com/backlink?for=32375" title="Pages that link to Topic: Looking to Post updates to website via email/SMS (Page 1 of 1)" rel="nofollow" >Topic: Looking to Post updates to website via email/SMS <span class="small">(Page 1 of 1)</span>\

 
Thundercat267
Obsessive-Compulsive (I) Inmate

From:
Insane since: Sep 2011

IP logged posted posted 09-11-2011 06:14 Edit Quote

Hi,

I run with a volunteer fire department and we were looking to create a system that would allow our volunteers to send an email from a mobile phone to a webpage that would list whether or not they were available for service or out of service. This webpage would be displayed in the garage and responders would have a clearer idea of who was in the area to respond for calls.

The page could be as simple as displaying all of the members names and the field next to them showing "In Service" and "Out of Service"

Can anyone give some suggestions on how to do the above?

My knowledge of programming and scripting is limited, so if you could make it a clear explaination, that would be great.

Thanks for your time

Tyberius Prime
Maniac (V) Mad Scientist with Finglongers

From: Germany
Insane since: Sep 2001

IP logged posted posted 09-15-2011 10:53 Edit Quote

You write as script that queries an email account (an inbox) for new mails,
then adds them to the database that is running your website (and deletes the emails
less it posts them over and over again).
Or in your case, updates the member's status in the database.

Then you hook this script up to a cron job that run's every minute.

Done

Thundercat267
Obsessive-Compulsive (I) Inmate

From:
Insane since: Sep 2011

IP logged posted posted 09-18-2011 21:37 Edit Quote

I'm sorry, but like I said, I'm not really sure how I would query that email address, write the script, or what database I should use.

Sorry, but can you give a detailed description or give me an example to get started?

Thundercat267
Nervous Wreck (II) Inmate

From:
Insane since: Sep 2011

IP logged posted posted 09-19-2011 03:06 Edit Quote

This is going to be run in a Microsoft environment. Users are going to send to send an SMS to an email (tested already) I want the users to only have to type "RFS" (Ready for service) or "OOS" (Out of Service). I want these keywords to change their status on an internal website.



What kind of scripting or scripting examples can I use to scan their SMS that comes into Outlook as an email for those three characters? How to I can I have that keyword trigger a change on an Status field ( IN OR OUT) found on an Internal IIS website?


Please let me know, any help is appreciated.

Thanks

Rinswind 2th
Maniac (V) Inmate

From: The Royal Residence
Insane since: Jul 2000

IP logged posted posted 11-27-2011 15:37 Edit Quote

It's probably to late for you but this could be a solution:
OZEKI NG SMS Gateway

If the volunteers all have a smartphone a dedicated twitter page would be easier. In this case they would send something like IN #firedept. for in service or OUT #firedept. for out of service.

.........................................................................
:: Develop yourself, develop your life, develop the world ::
:: Blog <--Dutch only ::
.........................................................................



Post Reply
 
Your User Name:
Your Password:
Login Options: Remember Me On This Computer
 
Your Text:
Loading...
Options: Show Signature
Enable Slimies
Enable Linkwords

« BackwardsOnwards »

Show Forum Drop Down Menu