SMS Processing Service

Project Overview

GSM Short Message Service becomes more and more popular world wide due to its low price, reliability and easiness of processing. It's used for personal communication as well as for business processes. Our team has developed such SMS Service for MS Windows Operating Systems. It supports notification messages delivery on configurable events as well as SMS receiving and processing in accordance with predefined templates. SMS Service publishes ActiveX API for integration with a customer application.

Functional Overview

SMS Service works with either mobile phone or GSM card connected to a computer. SMS Service publishes ActiveX API that allows GSM modem configuration and SMS Delivery. It works with templates defined in the configuration file for processing of incoming messages. Also SMS Service delivers Messages stored in outcoming queue. Depending on SMS Service configuration incoming messages can be interpreted as parameters of database stored procedure or as text to be appended in the specified file or as parameters for external procedure execution. SMS Service does not use many computer resources. SMS delivering and receiving routines work interruptedly with configurable timeout. Messages outcoming through API are delivered immediately. When Service wakes up it at first receives incoming messages and processes them then sends outcoming messages. All SMS Service activity is stored in the log file.

This system has been integrated into Facilitor 4i. Depending on configuration it sends notification when data related to user gets changed. It may be enabled for reservations, complains and orders.

In receiving mode it's used for complains processing. Company employees can confirm order execution in remote mode. They can just send really short message in predefined format to a mobile phone connected to Facilitor Server. In fact this message contains operation code and operation item identification (order ID). SMS Service reads incoming messages, checks user's credential using phone number and processes messages in accordance with the template. The default template enables Oracle procedure execution that changes the status of the correspondent order.

Work Flow Diagram

Technologies Involved

• GSM/SMS
• Oracle Database
• ActiveX
• Active Server Pages Technology, VBScript and JavaScript
• ADO and OLE DB as database access technology

Back to Information Technology