Product Support

Run Application as Windows Service

Table Of Content.

1. Overview.

2. Setting PC SMS Gateway Server Application Running as Windows Service.


 

1.Overview

The SMSgee PC SMS Gateway Server support running as Windows Service.

 

When running as windows service, there are three components of the application.

1. Windows Service - PC SMS Gateway Server. The Windows Service is running independently from the GUI.

2. SMS Database. The SMS Windows Service and GUI connect to SMS Database using ADO Connection.

3. GUI - PC SMS Gateway Server. The GUI controlling the device on Windows Service - PC SMS Gateway Server , like "Starting" on stopping the "Device"

 

As described on Picture 1 each component of the application could be run on single PC or running on separate PC as described on the Picture 2.

Running on one PC

Picture 1. Application component running on one PC.

 

 

PC SMS Gateway Server Component Application Running On 3 PC

Picture 2. Application components running on separate PC

 

 

 

 

2. Setting PC SMS Gateway Server Application Running as Windows Service

The step to run the application as windows service :

  1. Open "Application Settings"
  2. Installing PC SMS gateway Server Windows Service on localhost. Select the "SMS Server" Tab.
    • Checked "Install as service" checkbox.
    • Then the message box shows up "Install and start SMSgee PC SMS Gateway Server as Windows Service On 'localhost'", click yes to install.
    • Port Number could be changed to any unused port number on the localhost.
    • Password could be changed  (ANSI character only)
    • installing windows service
  3. Case #1. Settings the GUI on same PC with the Windows Service.
    • Open "Application Settings".
    • Select the "Client Settings Tab" on "Application Settings"
    • Checked "Connect to SMS Server" checkbox.
    • Set "SMS Server Host" IP address with the 'localhost'.
    • Set Port Number and Password of the PC SMS Gateway Server Windows Service. Port Number and Password should be match with the "PC SMS Gateway Server Windows Service - Service" on previous step.
    • Checked the "Connect to SMS Server Database" Checkbox to connecting the SMS Database of PC SMS Gateway Server Windows Service, and set the "Database Connection Settings" with the parameter value same as on the SMS Database on SMS Server Settings
    • settings client service
  4. Case #2. Settings the GUI on different PC with the Windows Service.
    • Install the PC SMS Gateway Server on different PC.
    • Open "Application Settings".
    • Disable the 'Install as service'.
    • SMS Server
    • Select the "Client Settings Tab" on "Application Settings"
    • Checked "Connect to SMS Server" checkbox.
    • Set "SMS Server Host" with IP address of the PC SMS Gateway Server Windows Service IP Adress. (in the example set with 192.168.0.1)
    • SMS Client
    • Checked the "Connect to SMS Server Database" Checkbox to connecting the SMS Database of PC SMS Gateway Server Windows Service, and set the "Database Connection Settings" to connect the database used by the PC SMS Gateway Server Windows Service on remote computer.
  5. Close the "Application Settings". The device on Windows Service could be controlled from "Device on SMS Gateway Windows Service".
  • device viewer

 

  • SMSgee PC SMS Gateway Server Windows Service

 

Device Initialization Command-SMS Memory Type - When SMS Could Not Be Retrieved From Device (e.g : Wavecom Modem)

On some UMTS/GSM modem, for example Wavecom modem, the SMS memory type could not be detected automatically.

The Symtomp are the SMS could not be retrieved from the device.

To overcome this problem, the SMS Memory Type should be Predefined, using Override SMS Memory Type Detection, the example is in picture 1.

The step to set Override SMS Memory Type Detection are :

On PC SMS Gateway Server :

1. Open Settings in main form tool button to open Application Settings

2. In Application Settings choose SMS Server tab

3. Select the device, then click Edit to open Device Settings

4. In Device Settings select Receive SMS tab.

5. In Receive SMS tab checked the Override SMS Memory Detection

6. Fill the SMS Memory Edit box with SMS Memory Type List, each SMS Memory Type separated by a comma. For example the Wavecom M1306B the SMS memory type are SM, BM, SR

7. Click OK to save Device Settings

 

 

On PC SMS Bulk Sender :

1. Open Settings in main form tool button to open Application Settings

2. In Application Settings select Device and Database Settings tab

3. In Device and Database Settings tab click Detailed Settings

4. In Device Settings select Receive SMS tab

5. In Receive SMS tab checked the Override SMS Memory Detection

6. Fill the SMS Memory Edit box with SMS Memory Type List, each SMS Memory Type separated by a comma. For example the Wavecom M1306B the SMS memory type are SM, BM, SR

7. Click OK to save Device Settings

 

 

Predefined SMS memory type

Picture 1. Override SMS Memory Type Detection

Supported UMTS/GSM Device

  • The SMSgee software perform auto detect whether the connected device is supported.
  • The GSM Device supported by SMSgee application is Device which Support Send SMS in PDU Mode and Support Load Inbox in PDU Mode.
  • The list below is only the reference. We haven't test all device , simply if your device is not listed in this supported device list, just connect with the SMSgee software and it will automatically detect whether the device is supported.
  • The UMTS/GSM Device could be external device connected to PC using serial port (RS 232), USB, Infra Red(IrDA),Bluetooth or internal device (usually found on Netbook/UMPC)
  • UMTS/GSM modem
    Most UMTS/GSM modem from are supported. For example wavecom, i-tegno, siemens, nokia, ericsson, huawei UMTS USB modem , ZTE UMTS USB Modem
  • UMTS/GSM phone

This following list that some GSM/UMTS phone that has been tested & supported :

Brand
GSM
UMTS
Nokia

5070, 6070

 

 

Sony Ericsson

T series :
T39, T68, T68i, T230, T250, T610, T630, T650i

K series:
K300, K310, K320i, K500, K510i , K530, K550i, K750i

W Series:
W200, W300, W550, W580, W600, W610, W660, W700, W710, W800, W810, W830, W850, W880, W900, W910

Z Series:
Z250, Z310, Z320, Z500, Z520, Z525, Z530, Z550, Z558, Z600, Z610, Z710, Z750, Z800, Z1010

 

KSeries:
K600i, K608i, K610i, K618i,K630i, K660i, K770i, K800i, K810i, K850i

VSeries:
V600

Siemens

S Series:
S45, S50, S55, S57, S65, S75


M Series:
ME45, M55, M65, M75, ME75

C Series :
C45, C50, C55, C65, C75

CX Series:
CX65, CX75

 

Motorola (not tested)  (not tested) 
Samsung (not tested)  (not tested) 
LG (not tested)  (not tested) 

Table 1. List of supported mobile phone.

 

This following list that some UMTS/GSM phone that is not supported :

Brand
GSM
UMTS
Nokia

Symbian Operating System phone

e.g : 6600,9500,etc

Symbian Operating System phone

e.g : N6110,E65,E90,N70,etc

Sony Ericsson

Symbian Operating System phone

e.g: P800,P900,etc

Symbian Operating System phone

e.g: W950,W960,P1i ,etc

Siemens

Symbian Operating System phone

e.g: SX1,etc

 

 

Motorola (not tested)  (not tested) 
Samsung (not tested)  (not tested) 
LG (not tested)  (not tested) 

Table 2 . List of mobile phone which is not supported.

 

Note : The Symbian Operating System phone is not supported because they don't support sending SMS using AT Command PDU mode.

SMS Marketing (Overview)

One of SMSgee Software goal is to provide the SMS marketig tools, here are some useful feature for SMS marketing :

  • Import Phonebook from Phone, File (CSV file,MS Excel), SQL Database and Microsoft Outlook contact

import phonebook wizard

import phonebook from file

 

  • "Mail Merge". Create custom SMS based on phonebook data.

mail merge perzonalized sms

 

  • Select the recipients. Could be Contact on Phonebook, Groups or Mobile Number list on text file.

SMS recipient list

 

  • Check whether the SMS has been sent.

SMS Outbox Log

 

  • Check the SMS Outbox Queue

SMS Outbox Queue

 

Task Auto Reply Keyword Filter

 

Task Auto Reply Send SMS

 

 

SMSgee PC SMS Gateway Server Database Software Development Kit (SDK)

Table Of Content

1. Introduction

2. Preparing SQL Database For PC SMS Gateway Server

3. Integrating PC SMS Gateway Server by Accessing SQL Database

3.1 Introduction

3.2 Receiving SMS

3.2.1 Introduction

3.2.2 Receiving Single SMS

3.2.3 Receving Long SMS

3.3 Sending SMS

3.3.1 Introduction

3.3.2 Outbox Table Fields

3.3.3 Sending SMS Using Default Parameter

3.3.4 Sending SMS Using Custom Parameter

 

1. Introduction

This Software Development Kit (SDK) purpose is to explain about one of very useful feature from the SMSgee PC SMS Gateway Server which is capable to integrated with other application.

Since the SMSgee PC SMS Gateway Server store SMS data on SQL Database, to integrate with another application, so they can use the SMSgee PC SMS Gateway Server SMS capabilities, is by accessing the SMSgee PC SMS Gateway Server database.

SQL Database SMS Server Integrated with other application

Picture 1. SMSgee PC SMS Gateway Server System

 

Chapter 2 Explain about preparing SQL Database for SMSgee PC SMS Gateway Server.

Chapter 3 Explanation about integrating SMSgee PC SMS Gateway Server with other application.

2. Preparing SQL Database For PC SMS Gateway Server

The default SQL database included on the SMSgee PC SMS Gateway Server installer are MS Access, for any other purpose it is possible using another SQL database.

The SQL Database supported for SMSgee PC SMS Gateway Server are :

  • Microsoft Access (version 2000, 2003)
  • Microsoft SQL Server (version 9 / SQL Server 2005 or above) including Microsoft SQL Express
  • MySQL (version 5 or above)
  • Oracle (version 9 or above).

The SQL Table script for creating tables and indexes is available on the installer, after installation the file located on the installation directory on folder DB Table Script

.SQL Database Script Tables and Indexes

Picture 2. Table Script Shortcut

The available Database table Script are :

  • Microsoft SQL Server (Version 8 compatible script)
  • Oracle (Version 9 compatible script)
  • MySQL (Version 5 compatible script)

 

3. Integrating PC SMS Gateway Server by Accessing SQL Database

3.1 Introduction

The SMSgee PC SMS Gateway Server store SMS data on SQL Database, integrated by another application is by accessing the SMSgee PC SMS Gateway Server database.

For ensuring Date Time compability across database, the SMSgee PC SMS Gateway Server store the Date Time in Double data type(e.g: INBOX.SMSTIMESTAMP, INBOX.RECEIVEDDATE, OUTBOXMASTER.CREATEDDATE, OUTBOXMASTER.LASTSENTDATE, OUTBOXLOG.CREATEDDATE, OUTBOXLOG.MODIFIEDDATE ). The SMSgee PC SMS Gateway Server Date Time begin from December, 30 1899 00.00 , means the Date Time value is the day passed since 30 Desember 1899.For example, 1 day is valued 1, and time is the fraction part. For example, the value of 1.5 means December, 31 1899 12:00 (mid day)

3.2 Receiving SMS

3.2.1 Introduction

The SMSgee PC SMS Gateway Server store received SMS in INBOX table. When other application is wants to reead the received SMS could be done by accessing the INBOX table.

 

3.2.2 INBOX table fields

Each records on INBOX table holds one PDU. A non long SMS only consist of one part or one PDU. A long SMS consist of multiple part or multiple PDU, the SMS property that linked the part of long SMS are UDHI and MESSAGEREF.

The INBOX table fields are,

Field Name
Field Type
Field Length
Description
INBOXID VARCHAR 60 Table Primary Key
PDU VARCHAR 1000 SMS Packet Data Unite(PDU).
SMSMESSAGE VARCHAR 170 SMS Message
UDHI VARCHAR 160 SMS UDHI
MESSAGEREF VARCHAR 160 SMS Message Ref
ANUMBER VARCHAR 160 SMS Sender Number
SMSC VARCHAR 160 SMS Centre Sender Number
SMSCTIMESTAMP DOUBLE   Originated SMS Centre time stamp
RECEIVEDDATE DOUBLE   Application time stamp when the SMS inserted to Database
SMSSTATUS INTEGER   Application flag wheter SMS has been read. 0 is unread and 1 is read.
SMSTYPE INTEGER   Application flag of SMS type. 0=Received Inbox SMS, 4=deleted Received Inbox SMS , 7=status report, 8=deleted status report
DEVICECODE VARCHAR 60 Device Code that receive the SMS
FLASHSMS INTEGER   SMS flag, whether the SMS is flash SMS. 0=non flash SMS and 1= flash SMS
LONGSMS INTEGER   SMS flag, whether the SMS is Long SMS. 0=non long SMS and 1=long SMS
REQUESTREPLY INTEGER   SMS flag, whether the SMS is Request Reply. 0=non request reply and 1=request reply.
CHARENCODING INTEGER   SMS character encoding type. 0=GSM Alphabet(7Bit), 1=Octet(8 bit), 2=Ucs2(16 bit), 3=Unknown
IMSI VARCHAR 160 International Mobile Subscriber Identity(IMSI) Number of Device Code that receive the SMS

 

3.2.3 Read non Long SMS from INBOX Table

Non long SMS are SMS which message length are less than 160 character and sent using single PDU.

The example of SQL Script for reading received Inbox non long SMS are

SELECT * FROM INBOX WHERE SMSTYPE=0

Notes: SMSTYPE of Received Inbox SMS are 0

 

3.2.4 Read Long SMS from INBOX Table

Long SMS are SMS which message length are more than 160 character and sent using multiple PDU part. The SMS property that linked long SMS are UDHI and MESSAGEREF.

The example of SQL Script for reading received Inbox long SMS are,

Step 1. Select a record (a part) of long SMS from the table.

SELECT * FROM INBOX WHERE SMSTYPE=0 AND LONGSMS=1

Step 2. Using MESSAGEREF and UDHI value from a part of long SMS, then read all part of the SMS

SELECT * FROM INBOX WHERE SMSTYPE=0 AND LONGSMS=1 AND MESSAGEREF='[MESSAGEREF_OF_SMS]' AND UDHI LIKE '[UDHI_SUBSTRING_LENGTH_WITHOUT_LAST_TWO_CHARACTER]%' AND ANUMBER='[ANUMBER]'

For example,

if UDHI='050003370201', then UDHI_SUBSTRING_LENGTH_WITHOUT_LAST_TWO_CHARACTER='0500033702',

and Messageref ='OD',

and ANUMBER='+6281320573350'

then the SQL script will be ,

SELECT * FROM INBOX WHERE SMSTYPE=0 AND LONGSMS=1 AND MESSAGEREF='OD' AND UDHI LIKE '0500033702%' AND ANUMBER='+6281320573350'

 

3.3 Sending SMS

3.3.1 Introduction

The SMSgee PC SMS Gateway Server store Outbox SMS in OUTBOXMASTER, OUTBOXRECIPIENT and OUTBOXLOG table. To send SMS from other application could be done by inserting the Outbox SMS record in OUTBOXMASTER and OUTBOXRECIPIENT table, and read the log whether the SMS has been successfully sent (to SMS centre) could be done by acessing OUTBOXLOG table.

3.3.2 OUTBOX Tables Fields

OUTBOXMASTER store the SMS parameter value, the OUTBOXRECIPIENT store the recipient list, and OUTBOXLOG store the SMS log whether has been sent (to SMS centre).

OUTBOXMASTER table field description are

Field Name Field Type Field Length Not Null Description
OUTBOXID VARCHAR 60 yes Table Primary Key
SUBJECT SUBJECT   no SMS Subject, for archiving purpose only and will not displayed on SMS message.
SMSMESSAGE TEXT/MEMO or VARCHAR(2000)   no SMS Message
FLASHSMS INTEGER   no SMS flag whether the SMS is flash SMS. 0=Non Flash SMS(default), 1=Flash SMS
LONGSMS INTEGER   no SMS flag whether the SMS is Force non Long SMS or auto detect. 0=Force non Long SMS , 1=Auto detect(default)
CREATEDDATE DOUBLE   yes TimeStamp when the record is inserted
SMSTYPE INTEGER   yes SMS Type flag. 1=Outbox, 2=Archive, 3=Template, 5=DeletedOutbox, 6=Draft
CHARENCODING INTEGER   no SMS character encoding type. 0=GSM Alphabet-7Bit, 1=Octet-8bit, 2=Ucs2-16 bit, 3=Auto Detect(default)
PRIORITY INTEGER   yes SMS Outbox Send Priority -2=Lowest, -1=Lower, 0=Normal, 1=Higher, 2=Highest
MAXRETRY INTEGER   yes Maximum Retry attemp to send SMS to SMS centre. Default value is 3
DEVICECODE VARCHAR 60 yes DeviceCode used for Sending SMS
SMSSTATUS INTEGER   yes Application flag wheter SMS has been read. 0=unread, 1=read.
USEVARIABLE INTEGER   no SMS flag whether the SMS Using Variable Tag (Mail Merge like feature). 0=Disable, 1=Enabled(default)
LASTSENTDATE DOUBLE   no N/A(Not applicable) for compability only
USECUSTOMSMSC INTEGER   no SMS flag whether the SMS using custom SMSC(SMS Centre) Number. 0=Disable(default) , 1=Enabled
CUSTOMSMSCNUMBER VARCHAR 160 no SMSC(SMS Centre) Number used if USECUSTOMSMSC is set with 1
STATUSREQUEST INTEGER   no SMS flag whether the SMS is request Status Report. 0=Disable(default), 1=Enabled
REQUESTREPLY INTEGER   no SMS flag whether the SMS is request Repl. =Disable(default), 1=Enabled
VALIDITYPERIOD INTEGER   no SMS validity period. The default value 169 (3 day)
SCHEDULEDSENT INTEGER   yes Flag whether SMS Send on specified date and time . 0=Disable, 1=Enabled
SCHEDULE DOUBLE   no Date and Time if SCHEDULEDSENT set with 1

 

OUTBOXRECIPIENT table field description are,

Field Name Field Type Field Length Description
OUTBOXRECIPIENTID VARCHAR 60 Table Primary Key
OUTBOXID VARCHAR 60 Foreign Key (OUTBOXMASTER primary key)
COPY INTEGER   SMS copy.
RECIPIENT VARCHAR 160 SMS Recipient.
RECIPIENTTYPE INTEGER   SMS Recipient type. 0=Mobile Number, 1= Contact ID from PHONEBOOK table, 2=Contact ID from CONTACTGROUP table

 

OUTBOXLOG table field description are,

Field Name Field Type Field Length Description
OUTBOXRECIPIENTID VARCHAR 60 Foreign Key (OUTBOXRECIPIENT Table Primary Key)
CONTACTID VARCHAR 160 SMS Recipient.
SENT INTEGER   Number of SMS that has been sent.
RETRY INTEGER   Retry attemp to send SMS
BNUMBER VARCHAR 160 SMS Recipient mobile number
SMSMESSAGE TEXT/MEMO or VARCHAR(2000)   SMS Message
CREATEDDATE DOUBLE   Timestamp when the record is inserted
MODIFIEDDATE DOUBLE   Last timestamp when the record is inserted or updated
DELIVERYREPORT INTEGER   N/A(not applicable)
MESSAGEREF INTEGER   N/A(not applicable)

 

3.3.3 Sending SMS Using Default Parameter

This example demonstrate how to Send SMS using PC SMS Gateway Server by inserting SMS Outbox Record into Database using SMS default parameter, which means leave nullable table fields with NULL value, then later when the application read the record will be intepreted as default value.

 

Prequisities

- Make sure you have done the Device Settings, and have Device Code named "GSMDEVICE1" as described on Picture 3.

Device list

Picture 3. Device

 

 

STEP 1 Insert SMS Outbox record into database. (follow step accoding to the Database used)

 

3.3.3.1 using MS SQL Server Database

Notes:

  • In the example below the PC SMS Gateway Server SQL Database is using the Microsoft SQL Server 2000
  • The table field Date datatype of the PC SMS Gateway Server is stored in database as Double datatype. The application Date datatype start from 0 as December, 30 1899.
  • The Microsoft SQL Server 2000 database Date datatype start from 0 as January, 1 1900. The value converting is needing, this is could be done by after the GETDATE() is casted to float, it should be add with 2(two) to compensate the difference date start value.
  • The Microsoft Access database Date datatype start from 0 as December, 30 1899 so no compensating value is necessary when using Microsoft Acces database.


Example Create Outbox RecipientExample Create Outbox Master

3.3.3.2 Using MySQL Database

  • In the example below the PC SMS Gateway Server SQL Database is using the MySQL 5.x
  • The table field Date datatype of the PC SMS Gateway Server is stored in database as Double datatype. The application Date datatype start from 0 as December, 30 1899.

/* Example D.1 Create Outbox Recipient */

 

/* Create Recipient by Mobile Number */

INSERT INTO OUTBOXRECIPIENT(OUTBOXRECIPIENTID,OUTBOXID,RECIPIENT,RECIPIENTTYPE,COPY) VALUES('R1','OUTBOX1','+628388744713',0,1)

INSERT INTO OUTBOXRECIPIENT(OUTBOXRECIPIENTID,OUTBOXID,RECIPIENT,RECIPIENTTYPE,COPY) VALUES('R2','OUTBOX1','+628996028540',0,1)

 

/* Example D.2 Create Outbox Master */
INSERT INTO OUTBOXMASTER(OUTBOXID,SMSMESSAGE,CREATEDDATE,SMSTYPE,PRIORITY,MAXRETRY,DEVICECODE,SMSSTATUS,SCHEDULEDSENT)
VALUES('OUTBOX1','Sending SMS using SMS Gateway Server',DATEDIFF(CURRENT_TIMESTAMP,FROM_DAYS(693959))+ ( TIME_TO_SEC( TIMEDIFF(TIME(SYSDATE()), MAKETIME(0,0,0))) / 86400  ),1,0,3,'GSMDEVICE1',0,0)

 

3.3.3.3 Using Microsoft Access Database

  • In the example below the PC SMS Gateway Server SQL Database is using Microsoft Access
  • The table field Date datatype of the PC SMS Gateway Server is stored in database as Double datatype. The application Date datatype start from 0 as December, 30 1899.

/* Example D.1 Create Outbox Recipient */

 

/* Create Recipient by Mobile Number */

INSERT INTO OUTBOXRECIPIENT(OUTBOXRECIPIENTID,OUTBOXID,RECIPIENT,RECIPIENTTYPE,COPY) VALUES('R1','OUTBOX1','+628388744713',0,1)

INSERT INTO OUTBOXRECIPIENT(OUTBOXRECIPIENTID,OUTBOXID,RECIPIENT,RECIPIENTTYPE,COPY) VALUES('R2','OUTBOX1','+628996028540',0,1)

 

/* Example D.2 Create Outbox Master */
INSERT INTO OUTBOXMASTER(OUTBOXID,SMSMESSAGE,CREATEDDATE,SMSTYPE,PRIORITY,MAXRETRY,DEVICECODE,SMSSTATUS,SCHEDULEDSENT)
VALUES('OUTBOX1','Sending SMS using SMS Gateway Server',now(),1,0,3,'GSMDEVICE1',0,0)

 

 

STEP.2

. Check whether the SMS has been successfully sent (to SMS centre), by accessing

OUTBOXLOG

table.

The SQL script for reading OUTBOXLOG for checking whether the SMS has been sent are,

SELECT * FROM OUTBOXLOG INNER JOIN OUTBOXRECIPIENT ON OUTBOXRECIPIENT.OUTBOXRECIPIENTID=OUTBOXLOG.OUTBOXRECIPIENTID WHERE OUTBOXRECIPIENT.OUTBOXID='OUTBOX1'

The OUTBOXLOG also could be accessed from the application,

SQL Database Outbo Log

Picture 4. Outboxlog: Check whether SMS has been sent.

3.3.4 Sending SMS Using Custom Parameter

Sending SMS with custom value according to the purpose, the custom value description could be found on OUTBOXMASTER table field description.

SMS Add On Feature(Overview)

(Integrating PC SMS Gateway Server 4.2 with other application)

 

SQL Database Script Tables and Indexes

  • Example I. Inserting SMS Outbox record into SQL Database Table

This example demonstrate how to Send SMS using PC SMS Gateway Server by inserting SMS Outbox Record into Database using SMS default parameter, which means leave nullable table fields with NULL value, then later when the application read the record will be intepreted as default value.

Notes:

  • In the example below the PC SMS Gateway Server SQL Database is using the Microsoft SQL Server 2000
  • The table field Date datatype of the PC SMS Gateway Server is stored as Double datatype. The application Date datatype start from 0 as December, 30 1899.
  • The Microsoft SQL Server 2000 database Date datatype start from 0 as January, 1 1900. The value converting is needing, this is could be done by after the GETDATE() is casted to float, it should be add with 2(two) to compensate the difference date start value.
  • The Microsoft Access database Date datatype start from 0 as December, 30 1899 so no compensating value is necessary when using Microsoft Acces database.

 

STEP 1. Insert SMS Outbox record into database

Example Create Outbox RecipientExample Create Outbox Master

After the SMS record inserted into database, the current SMS appear on Outbox Folder. Inserting SMS directly into Database is another way to Create New SMS than Create New SMS from the application.

PC SMS Gateway Server Outbox Folder

 

 

STEP.2. Check whether the SMS has been successfully sent (to SMS centre), by accessing OUTBOXLOG table.

The SQL script for reading OUTBOXLOG for checking whether the SMS has been sent are,

SELECT * FROM OUTBOXLOG INNER JOIN OUTBOXRECIPIENT ON OUTBOXRECIPIENT.OUTBOXRECIPIENTID=OUTBOXLOG.OUTBOXRECIPIENTID WHERE OUTBOXRECIPIENT.OUTBOXID='OUTBOX1'

 

Beside view the SM Sent status from database, it also could be viewed on Log

View SMS Outbox LogView  SMS Outbox

 

  • Example II. Read SMS Inbox from SQL Database

This example demonstrate how to read received SMS by PC SMS Gateway Server. Simply, read the INBOX table using SQL Script.

View Inbox on SMS Database

Send SMS on Specified Schedule

This article describing an example Send SMS by Schedule. SMSgee software support send SMS by Schedule, on specify date and time the SMS will be added to Outbox Queue list. The Outbox Queue list is SMS that waiting to be send.

 

  • First step to send SMS by schedule is just like send an ordinary SMS. As in Picture 1 below, the only difference is the Scheduled check box is checked, and the Date and Time should be set to specified date and time.
  • Date and time means the current SMS will be added into Outbox Queue.

Create new SMS Send SMS by Schedule

Picture 1. Create new SMS by Schedule

 

  • After the "Send" button is clicked, the current SMS will be added into Outbox, as in Picture 2 below.

View Outbox SMS Send By Schedule

Picture 2. SMS added into Outbox

 

View SMS Outbox Quee

Picture 3. The current SMS is included on Outbox Queue list since has not passed yet the "Send Schedule Date"

 

  • After Send Schedule Date is passed, the current SMS will be added into Outbox Queue list.

View SMS Outbox Queue

Picture 4. The current SMS is included on Outbox Queue list since has passed the "Send Schedule Date"

 

  • Then after the send process finished, the current SMS moved to Archive folder

View SMS Archive

Picture 5. The current SMS automatically moved to Archive folder after the send process is done

 

  • Detailed information about current SMS could be found on log.

View SMS Archive Log

Picture 6. The detailed log of the current SMS

Send SMS on Interval Schedule

(Feature Available on PC SMS Gateway Server 4.2)

 

This article explaining how to Send SMS by Fix Interval Schedule. The PC SMS Gateway Server support send SMS by Fix Interval Schedule, the interval range from seconds, minutes, hours, days and weeks.

To create task for Send SMS by Interval Schedule please follow the steps below.

1. Open "Task" tab. To open "Task" tab, on main form click Settings button, after the "Application Settings" shows up select the Task tab. The Task Tab shows on Picture 1 below.

Application Settings, Task

Picture 1. Task Tab.

2. Add New Task. To add new task click Add, then the Task Properties form will be shows up. The Task properties form shows in the Picture 2 below.

Task Properties

Picture 2. Blank Task properties

3. Set the Interval Task Settings.

  • Check the "Enabled Task" checkbox
  • Select the "Interval task"
  • Adjust the Interval Task Settings," Execute Every", "Starting Point", etc.

Task Properties, Interval Task

Picture 3. Task Properties set as Interval Task

4. Set Send SMS Settings.

  • Select "Send SMS" tab.
  • Check the "Send SMS" checkbox.
  • Check the "Use recipient list" checkbox, then Click "Edit the recipient list" to edit SMS recipient list (shows in picture 5).
  • Select Device For Sending SMS. (If no device listed please add the device, the add the device please follow this procedure)
  • Select SMS Outbox Profile if necessary.
  • Set SMS Message as "Specify Message", and then fill the message on "SMS Message". Click SMS Editor to open larger text editing form.

Task Propeties, Interval Task, Send SMS

Picture 4. Setting Send SMS properties

Task, Interval Task, Recipient List

Picture 5. Recipient List

5. Click OK on "Task Properties" form to save and activating Task.

6. On schedule due, the SMS will be automatically add to Outbox (Shows on Picture 6)

View SMS Outbox Created

Picture 6. The SMS automatically added to Outbox on schedule due

Send/Receive SMS From PC (Overview)

SMSgee Software simplify send/receive large number of SMS.

  • Read Received SMS

View Inbox Received SMSee

 

  • Sending SMS

Create New SMS

 

  • Check Whether the SMS has been sent

View SMS Outbox Log

 

  • Import Phonebook from Phone, File (CSV file,MS Excel), SQL Database and MS Outlook contact

Import Phonebook From Phone

 

Device Settings for SMSgee Software

Perform Searching Supported UMTS/GSM Device

Often is quite tricky to know whether which UMTS/GSM Device is supported. Starting from PC SMS Gateway Server version 4.2.5 and SMS Bulk Sender 2.0.1, the searching supported UMTS/GSM Device is done by the software to scan the all available COM Ports.

To perform searching supported GSM Device.

 

PC SMS Gateway Server:

  1. Select "Settings" on the Main Menu TaskBar.
  2. Select "SMS Server" tab. On the "Device" Section, "Add" device or "Edit" device to open "Device Settings".
  3. On the "Device Settings" select "Device Connection" tab. On "COM Port Settings" section click "Search Device..." to perform searching supported GSM Device. The message box will shown, click yes. The picture below is illustration of the result the searching supported UMTS/GSM device
  4. Select the device that you want to use, then click select.
  5. Click OK to save Device Settings.

PC SMS Bulk Sender:

  1. Click "Settings"on Taskbar Main Menu
  2. On "Device and Database Settings" Tab, click "Search Device". The confirmation for perform "Searching Supported Device" will shows up, click yes to perform "Searching Supported Device".
  3. Searching process takes time about 120 second.
  4. The Supported Device list will shows up after the Searching process finished.
  5. The All ComPort Scan result list shows all the connected device on COM port.

 

 

In some cases the supported device is undetected using "Search Device" function although it has been properly connected to PC, this happen because the "Search Device" function is not trying all available combinations of "Port Speed" and "Flow Control", then the device should be set manually.

Searching Supported Device

Picture 1. Searching Supprted Device Result

 

Settings Device Manually

PC SMS Gateway Server:

  1. Select "Settings" on the Main Menu TaskBar.
  2. Select "SMS Server" tab. On the "Device" Section, "Add" device or "Edit" device to open "Device Settings".
  3. On the "Device Settings" select "Device Connection" tab.
    • On "COM Port Settings" section, set the "PortName" from list or type the "Port Name" (e.g: COM1).
    • On "COM Port Settings" section, click "Advanced settings"  to set "Port Speed" and "Flow Control".
  4. Click OK to save Device Settings.

PC SMS Bulk Sender:

  1. Click "Settings"on Taskbar Main Menu.
  2. On Device and Database Settings Tab select "Port Name" from list or type the "Port Name" (e.g: COM1).
  3. Click "Detailed Settings" to set another parameter. The "Device Settings" window will shows up, click "Advanced settings"  to set "Port Speed" and "Flow Control".

 

To connecting the Device , the "Device Settings" COM Port, Port Speed and Flow Control should be set correctly, these settings are :

Advance Port Settings

Picture 2. Device Settings

 

  1. COM Port. Set "Port Name" , set the COM ports to the device attached to. To see which port the device attached to , could be found on Windows Control Panel "Phone and Modem Options" , or Control Panel Device Manager "Ports (COM & LPT)", the picture are shown on Picture 3 and Picture 4 respectively.
  2. Port Speed and Flow Control. On "Device Settings", Click "Advanced Settings" to set "Advanced Port Settings", Port Speed and Flow Control. (this settings usually found on UMTS/GSM Device Manual).

 

Phone and Modem Options

Picture 3 . Modems on Phone and Modem Options

 

Device Manager Ports COM & LPT

Picture 4 . Ports (COM & LPT) on Device Manager.

 

Error Message When Connecting To The Device

 

Error Message Number Message Description
4000 Device is not found Could not be connecting the device on specified COM port
4001 Device is not responding The device has been connected but now is not responding.
4050 Device is not support Send SMS in PDU Mode Connected device not support Send SMS in PDU mode (The SMSgee software only support device which has Send SMS in PDU mode capability)
4051 Device is not support Read SMS in PDU Mode Connected device not support Read SMS in PDU mode (The SMSgee software only support device which has Read SMS in PDU mode capability)
4052 Device SMS Memory is not Detected Connected device doesn't have any SMS Memory (The SMSgee software only support device which has at least one SMS memory)

 

 

Receive SMS Options

Device Settings Receive SMS

  • Enable load Inbox SMS from device.

Enabled this option to load SMS from device.

  • Load unread only.

Enabled this option to load only unread SMS from device.

  • Save to database.

Enabled this option to save loaded SMS from device to SMS database.

  • Check Inbox on device intervally.

Perform checking received SMS on device periodecally whether new received SMS on device.

  • Override SMS memory type detection (AT+CPMS).

Override SMS memory type used for loading SMS from device.
       

  • Override Phonebook memory type detection (AT+CPBS).

Override phonebook memory type for loading contact from device.

 

 

Send SMS Options

Device Settings Send SMS Options

  • Enable send SMS

Set this option to enable send SMS.
      

  • Ratio between send and receive.

Ratio between send SMS and load SMS from the device.

 

  • Message signature.

Appended text on end of the SMS message.

 

Syndicate content