SMS Watch

Top  Previous  Next

 

SMS Watch is a separate application that monitors and automatically processed replies to SMS messages

 

SMS Overview

 

 

Databuild, Job Control and Front End generate SMS messages by sending SMTP messages to an external SMS server which then relays those messages onto the required mobile phone.

 

By setting up a virtual connection on the SMS Servers, replies to those SMS messages can be trapped and forwarded as emails onto a predetermined email account.

 

SMS Watch monitors that account, reads the email, deciphers the response and finally updates actual or anticipated completion dates in the main system.

 

SMS Watch can be set to run manually (press buttons to read emails, process replies) or automatically, performing tasks at preset times.

 

By placing SMS Watch  in your Startup folder, SMS Watch can run continually in the background on ONE computer.

 

 

 

SMS Watch has 4 main tabs:

 

SMS Replies

 

SMS WatchReplies

 

When SMS Watch reads Emails, they are parsed, and if they pass the tests, they are added to the list of SMS messages.

If not, they are added to the list of extraneous Emails

 

Check boxes allow restricting SMS messages to selected statuses, and the filter bar further restricts your selection.

 

Completion request SMS messages sent from Job Control are always in the format

 

[Identifier]:Comp Date [Job Code] [Job Address] [Activity Code] [Activity Name] ??

 

where        [Identifier]        is the SMS identifier as set in Setup/Defaults/SMS in the main Databuild system

       [Job Code]        is the Job Code in the main Databuild system

       [Job Address]        is the Job Address in the main Databuild system, with spaces removed and limited to 10 characters

       [Activity Code]        is the Activity Code in the main Databuild system

       [Activity Name]        is the Activity Name in the main Databuild system, with spaces removed and limited to 10 characters

 

When replying to an SMS, the reipient must retain the original message and append his reply.

Because space is at a premium (160 characters max), we have developed a "shorthand" reply syntax:

 

Valid responses:

 

Any valid date                "3/6",  "3/6/04", "3/6/2004", "3 June", "3 June 2004", "3 Jun" etc

 

Days of the week:        "s",  "su","sun", "sunday"                        Aplies to current week (week starts on Sundays)

                       "m", "mo", "mon", "monday"

                       "tu", "tue", "tues", "tuesday"        

                       "w", "we", "wed", "wednesday"

                       "th", "thu", "thurs", "thursday"

                       "f", "fr", "fri", "friday"

                       "s", "sa", "sat", "saturday"

 

Relative days                "y", "yes", "yday", "yesterday"                Relative to date of SMS reply

                       "t", "td", "tod", "today"

                       "tom", "tm", "tomorow"

 

A Number plus                 "d", "day", "days"                                e.g "10 days"

                       "w", "wk", "week", "weeks", "wks"

                       "m", "month", "months"

 

Last/Next                "l", "lw", "last"                                e.g. "monday last", "m l"

                       "n", "nw", "nx", "next"

 

 

Note that all dates are based on the SMS reply date. If that date is a monday, "Wed Next" will be 9 days later, not 2

 

On processing, any replies that do not generate a valid date will be given a status of "Rejected" and the reason entered in the comments field.

If Dates,Companies,Jobs and Activity are all valid, the completion date will be set and locked. If the date is equal to or before today, then the activity will be declared complete. These actions will also be added to the Security Log in the parent system (user="SMSWatch") so that actions can be reviewed at a later date

 

Extraneous Emails

 

SMS Extra

 

Not all emails are solicited these days.

Any that fail the initial test of being a redirected SMS reply (the subject must contain both ":Comp Date" and "??") is directed to this grid rather than the SMS Response grid

 

 

Companies

 

SMSW Companies

 

SMS Watch can monitor multiple companies simultaneously.

To do this, it needs to know what company the SMS reply refers to.

Each SMS sent from Databuild is prefixed by an identifier, as set in Setup/Defaults/SMS on the parent system.

 

If those identifiers are entered in the inculsion key field of the companies grid, SMS replies will be processed on that company

Multiple identifiers can be attached to each company, but you should avoid including the same identifier on multiple companies.

 

A command button        Import        lets you import company information from a Databuild system on the same computer

 

Setup

 

SMS Setup

 

The frequency of scanning for new SMS replies and processing any pending SMS replies can be set by selecting hours & minutes text boxes

This only applies when in automatic mode

 

A Start on Load checkbox sets automatic mode running whenever SMS Watch is loaded (either manually or if it is included in your Startup script)

A Minimize on Start checkbox forces SMS Watch to minimize whenever Automatic mode is started.

 

Details of your POP3 server account are maintained here.

 

The common database of the parent system is also nominated here. This needed to import companies and to write to the security log

 

 

Toolbar

 

All_None        Selects or Deselects ALL SMS Replies, Extraneous Emails or Companies

 

delete        Delete selected SMS Replies, Extraneous Emails or Companies

 

Live        Scans for SMS reply emails

 

Workup        Processes pending SMS replies

 

timesheet        Sets automatic mode running

 

stop        Stops automatic mode

 

exit        Closes the routine