Home

User Manual Version 4.x

1. GSM Devices SMS Tasks a g amp Start Stop Device Info Add Device Code Picture 2 6 GSM Devices list Page 9 3 GUI Basic Operation 3 1 Receiving SMS Inbox g PC SMS Gateway Server 4 4 6 Trial Version 8 li E g Settings About Object Explorer Inbox 4 4 SMS Folders amp 2 fa Inbox 1 New Outbox Import Outbox Outbox 3 Archive Date Message Contact Name Mobile Number S Status Report 1 13 2015 1 56 17 Pl The quick brown fox jumps over laz 628565999 QA Draft Template Trash Search E Phonebook B SMS Gateway Server Blocalhost 2026 5 lt gt lt gt Connected to SMS Database Picture 3 1 Inbox Page e Inbox is the received SMS e The SMS received on the GSM Devices will shows up in the Inbox if the Enabled Receive SMS options on the GSM Device Settings is enabled and also the GSM Device is Started e To view the received SMS go to the Inbox Page on the Object Explorer select Inbox on the SMS Folder Inbox amp New Outbox Import Outbox Date Message Contact Name Mobile Num A 1 23 2015 1 19 42 AM Penggunaan terakhir anda adalah 1100 0 TELKOMSEL 1 23 2015 1 19 42 AM sampai 22 02 2015 TELKOMSEL 1 22 2015 675 Open da bisa membe 1 20 2015 6 Bees da bisa membe NSP1212 1 18 2015 7 14 Refresh 1 18 2015 7 16 Reply 1 18 2015 4 14 The quick brown fc 6285659 fox jumps ove
2. by accessing OUTBOXLOG table e 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 e The OUTBOXLOG also could be accessed from the application Y Outbox 31 01 2013 2 10 54 Sa ve a Forward Save as Subject Device GSMDEVICE1 Scheduled Message Lee Log 2 recipient number Mobile Number Contact Name Group Name Delivery Report Last Sent Date a 1 0 628388744713 0 No report 628996028540 1 0 0 No report n 4 b Picture 4 Outboxlog Check whether SMS has been sent Page 38 2 3 4 Sending SMS Using Custom Parameter e Sending SMS with custom value according to the purpose the custom value description could be found on OUTBOXMASTER table field description
3. A Display adapters 3 DVD CD ROM drives 1 Human Interface Devices Ga IDE ATA ATAPI controllers a Imaging devices Keyboards A Mice and other pointing devices LE Modems A Monitors Network adapters Ei Portable Devices a 7 Ports COM amp LPT YF GlobeTrotter GI1505 Control Interface COMS5 T GlobeTrotter GI1505 Diagnostics Interface COM4 17 Prolific USB to Serial Comm Port COM3 as Print queues BB Processors i Sensors Software devices amp Sound video and game controllers Stnrane controllers Picture 2 2 Ports COM amp LPT on Device Manager 2 4 2 Preparing the SIM Card e The GSM SIM Card should have SMS Subcription e The SIM PIN on the GSM SIM Card should be disabled 2 5 Connecting GSM Device to PC SMS Gateway Server e The PC SMS Gateway Server communicating with the GSM Devices through the serial ports COM Ports to use the functionality of the GSM Devices which have been properly setup on theDevice Manager gt gt Ports the COM Port should be add as GSM Devices on the PC SMS Gateway Server e The step to add the GSM Devices in the PC SMS Gateway Server 1 Inthe PC SMS Gateway Server GUI select SMS Gateway Server on the Object Explorer to view the GSM Devices page 2 Onthe GSM Devices page Click Add to add the new GSM Device Settings 3 Onthe GSM Device Settings select the COM Port or click Search to detect the GSM Devices Then click save
4. o Interval The interval cycle on the task Task Settings tab o Send SMS Click SMS Settings to open Send SMS Settings e Device for Sending SMS e SMS Message o Specify Message o Field Value from SQL Query e Recipient List o Recipient List o Execute SQL Script SQL Script could be Stored Procedure Function or Any SQL Statement When using multiple statement each statement should be wrapped with the lt HSQL gt lt SQL Statement gt lt SQL gt for example lt SQL gt Exec StoredProc1 param1 param2 param3 lt SQL gt lt SQL gt INSERT INTO PHONEBOOK CONTACTID CONTACTCANAME MOBILENUMBER VALUES A5AB87E JOHN DOE 6285659999105 lt HSQL gt Page 25 g Task EJ Task Name TASK 1 Enabled Task Task Type O Event Task Interval Task O Scheduled Task Interval Task Log Interval settings Next Execute on 12 11 2014 gt 12 00 00am EH Timeout Tolerance 10 ta Interval 1 i Days v sme Picture 4 8 Interval Task Interval Settings SMS Settings Execute SQL Script Execute SQL SQL Script Database Connection Use Server Database Connection Custom Database Connection Database Settings Connection string Connection Timeout 30 Command Timeout 60 Picture 4 9 Interval Task Task Settings
5. MySQL Version 5 or newer SQL script Page 19 The SMSgee PC SMS Gateway Server also could be running as Windows Service When running as windows service there are three components of the application 1 PCSMS Gateway Server Windows Service o The Windows Service is receiving command from GUI o The Windows Service connect to GSM Device and perform receive and send SMS o The GUI connect to windows service o The GUI read Inbox and write Outbox directly to the database o The SMS Windows Service and GUI connect to SMS Database using ADO Connection 2 Select the SMS Gateway Server Tab 4 2 Running as Windows Service 4 2 1 Introduction o o 2 PCSMS Gateway GUI 3 SMS Database 4 2 2 Setting Running as Windows Service 1 Open Application Settings g Application Settings EE SMS Service SMS Settings Notification SMS Service Settings SMS Database Settings Connection string Provider Microsoft Jet OLEDE Y Enable Log Log file C Program Files x86 SMSgee View Windows Service Y Install SMS Gateway Server as Windows Service Port number 2026 Password SMSSERVER 123 GUI Mode Settings _ Stand Alone Connect to SMS Gateway Server Windows Service Connection Settings Server IP Address localhost Port number 2026 Password SMSSERVER 123 C Override SMS Database Settings Save Picture 4 1 SMS Service on Application Settings 3 Installing PC SMS gateway Serve
6. Oracle MySQL Page 13 g Import from Excel File xls Ea a Send Device Code GSMDEVICE1 Source DataSet 2 record Sheet Name Sheeti FIELDA 62 8172302044 62 85659999105 lt Field Link Source Field FIELDA SMS Field v MOBILENUMBER iv SMSMESSAGE Picture 3 6 Import SMS 2 To Import the SMS Outbox from MS Excel xls file O O O Open the SMS Outbox Page Click Import Outbox tool Button and select From file MS Excel xls after the Open Dialog forms is shows up Select the MS Excel xls file After the form Import Outbox Import from Excel xls is shows up select the Sheet by selecting the Sheet Name After the Sheet is selected the Field Link should be set to link between the Field Link on the Sheet and the SMS Outbox select the Source Field which corresponded to the SMS Field Click Send to create new SMS Outbox 3 To Import the SMS from Database O O O Open the SMS Outbox Page Click Import Outbox tool Button and select From Database The Import Outbox tool Button could be accessed from Inbox Page or the Outbox Page After the Data Link Properties is shows up Setup the Database connection Settings by selecting the OLE DB Provider s on the Provider tab and click Next gt gt to fill the detailed settings of the connection After the Connection Settings is filled Click OK
7. 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 2 2 Receiving SMS 2 2 1 Introduction e The SMSgee PC SMS Gateway Server store received SMS in INBOX table When other application need to read the received SMS could be done by accessing the INBOX table 2 2 2 INBOX table fields e 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 e The INBOX table fields are Field Field Mas Field Name Type Length Description INBOXID VARCHAR 60 Table Primary Key PDU VARCHAR 1000 SMS Packet Data Unite PDU SMSMESSAGE VARCHAR 1170 SMS Message UDHI VARCHAR 1160 SMS UDHI MESSAGEREF VARCHAR 1160 SMS Message Ref ANUMBER VARCHAR 1160 SMS Sender Number SMSC VARCHAR 1160 SMS Centre Sender Number SMSCTIMESTAMP DOUBLE Originated SMS Centre time stamp RECEIVEDDATE DOUBLE Application time st
8. to Connect to the Database If Connection to the database is successfull the Form Import from Database will shows up After the form Import Outbox Import from Database is shows up select the Table by selecting the Table Name After the Table is selected the Field Link should be set to link bet ween the Field Link on the Table and the SMS Outbox select the Source Field which corresponded to the SMS Field Click Send to create new SMS Outbox 3 4 Search SMS e The SMS on SMS Folder could be searched on SMS Search e To open SMS Search go to Object Explorer gt gt SMS Folder gt gt SMS Search g RSS RER Object Explorer 4 4 SMS Folders Message Mobile Number Device code SMS Folder Inbox f Outbox y SMS Gateway Server localhost 2026 5 Archive Template Deleted Inbox Deleted Outbox Draft Status report Deleted Status report Y Display SMS recipient Filter by date From 1 49 2015 _ To 1 13 2015 lt sah Connected to SMS Database Picture 3 7 Search SMS e The search criteria o Message optional o Mobile Number optional o Device Code optional o SMS Folder required o SMS Date optional e Click Search to perform SMS Search 3 5 Managing Phonebook 3 5 1 Managing Contact Page 14 e Contact i
9. 220204 New Group lt gt lt Connected to SMS Database Picture 3 10 Phonebook Group e To acces the Group Page o Select Phonebook on the Object Explorer o Select Group Tab e Creating New Group o Click New Contact tool button on the Contact Page o After the new Group Form is shows up fill the Groupname which is the only required field another field is optional o Click Edit to Edit Contact List Group Member e Open Group o Double click on the Group Grid o or Right click on the Contact Grid and Select Open e Delete Group o Right click on the Group Grid and Select Delete Page 18 4 Advanced Operation 4 1 Database Setup e The default SQL database included on the SMSgee PC SMS Gateway Server installer are MS Access e The connection between the application and the database using ADO Connection e For any other purpose Beside the default SQL database another SQL Database supported for SMSgee PC SMS Gateway Server are o MS Access The default database is MS Access 2003 o MS SQL Server Express version 9 SQL Server 2005 or newer o MySQL InnoDB version 5 or newer o Oracle version 9 or newer e The SQL Table script for creating tables and indexes is available on the installer the file is located on the installation directory on folder DB Table Script e The available Database table Script are o MS SQL Server Express Version 2005 or newer SQLscript o Oracle Version 9 or newer SQL script o
10. 6 CEN Settings About Object Explorer Outbox Outbox Queue 1 SMS 4 Da SMS Folders 8 Inbox Refresh E outbox 1 E archive Device Code GSMDEVICE 1 v ES Status R t a ary al Device Code Priority Created Date Schedule Send Date Contact Name Mobile Number Group Name Message t GSMDEVICE1 Normal 0 1 13 2015 1 45 21 PM 628 172302044 The quick brown fox Template A Trash A Search E Phonebook E sus Gateway Server Blocalhost 2026 5 lt gt lt Connected to SMS Database Picture 3 4 SMS Outbox Queue 3 3 Open SMS Outbox Archive e The SMS Outbox that has been created but not sent yet stored on Outbox Folder e To open SMS Outbox go to Object Explorer and select Outbox Folder e The SMS Outbox that has been Seen stored on Archive Folder e To open SMS Archive go to Object Explorer and select Archive Folder e After the SMS Outbox Archive opened to view the SMS sending progress could be seen on Recipient List tab g Archive x r S 5 se Resend Forward Save As Subject Device Code GSMDEVICE1 CI Scheduled Message Recipient List 1 mobile number Mobile Number Contact Name Group Name Copy Sent Try Delivery Report Last Sent Date 6285659999105 1 1 1 1 13 2015 7 27 52 PM e Picture 3 5 Recipient List Outbox Log on SMS Archive SMS Outbox 3 3 1 Importing New SMS Outbox 1 The New SMS Outbox also could be created by using the data from the MS Excel xls files or Database MS Access MS SQL Server
11. GER N A not applicable MESSAGEREF INTEGER N A not applicable 2 3 3 Sending SMS Using Default Parameter e 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 e Make sure you have done the Device Settings and have Device Code named GSMDEVICE1 as described on Picture 3 pa About Object Explorer GSM Device SMS Task EJE SMS Folders 8 g B E X 3 Inbox 2083 Start sme Device Info Add Edit Remove KE Outbox Process 3 Archive 1700 MDEVICE 1 started idle E Status Report 963 GA Draft 3 Template soft Deleted a Phonebook i B Server localhost 2026 Started ui Connected to SMS Database Picture 3 Device Page 36 STEP 1 Insert SMS Outbox record into database follow step accoding to the Database used 2 3 3 1 Using MS SQL Server Database Notes e Inthe example below the PC SMS Gateway Server SQL Database is using the MS SQL Server 2005 e The table field Date data type of the PC SMS Gateway Server is stored in database as Double data type The application Date data type start from 0 as December 30 1899 e The MS SQL Server 2000 database Date data type start from O as January 1 1900 The va
12. IENTID 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 DEVICE CODE SMSSTATUS SCHEDULEDSENT LONGSMS 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 1 2 3 3 3 Using MS Access Database e Inthe example below the PC SMS Gateway Server SQL Database is using MS Access Page 37 e The table field Date data type of the PC SMS Gateway Server is stored in database as Double data type The application Date data type 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 DEVICE CODE SMSSTATUS SCHEDULEDSENT LONGSMS VALUES OUTBOX1 Sending SMS using SMS Gateway Server now 1 0 3 GSMDEVICE1 0 0 1 STEP 2 Check whether the SMS has been successfully sent to SMS centre
13. OM INBOX WHERE SMSTYPE 0 AND LONGSMS 1 o 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 0D and ANUMBER 6281320573350 then the SQL script will be Page 33 SELECT FROM INBOX WHERE SMSTYPE 0 AND LONGSMS 1 AND MESSAGEREF OD AND UDHI LIKE 0500033702 AND ANUMBER 6281320573350 2 3 Sending SMS Introduction 2 3 1 e The SMSgee PC SMS Gateway Server store Outbox SMS in OUTBOXMASTER OUTBOXRECIPIENT and OUTBOXLOG table e 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 2 3 2 OUTBOX Tables Fields e OUTBOXMASTER table store the SMS parameter value e OUTBOXRECIPIENT table store the recipient list and OUTBOXLOG store the SMS log whether has been sent to SMS centre e OUTBOXMASTER table field description are Field Name OUTBOXID SUBJECT SMSMESSAGE FLASHSMS LONGSMS CREATEDDATE SMSTYPE CHARENCODING PRIORITY MAXRETRY DEVICECODE SMS
14. Page 26 g Send SMS Properties Interval Task x Device Code GSMDEVICEL y Message Recipient List SMS Message Specify Message O Field value from SQL Query Incoming Message Variable Symbol Picture 4 10 Interval Task SMS Settings Message Device Code GSMDEVICE1 bd Message Recipient List Contact 0 Group 0 Import 0 Recipient List 0 Search Copy fi Name MobileNumber Contact Name Type Mobile Number Copy gt gt bes Picture 4 11 Interval Task SMS Settings Recipient List 4 3 3 Scheduled Task e Scheduled task is SMS Task which executed on specified Interval Page 27 Appendix 1 PC SMS Gateway Server Requirement e Operating System e Windows Desktop class o Windows 2000 or later e Windows Server class o Windows 2000 Server or later e PC Hardware Requirement e CPU o 1000 MHz Processor minimal e RAM 1024MB RAM minimal e Harddisk Space 20MB harddisk space for initial installation The harddisk space dynamically increase decrease depend on SMS number on INBOX OUTBOX e GSM Device e The GSM Device requirement is available on Appendix 2 Supported GSM Device e GSM SIM Card with active SMS subscription e Supported RDBMS Database e MS Access o The default installer database is using MS Access database o T
15. SMSGEE PC SMS Gateway Server4 4 User Manual SMSgee com Software 12 23 2014 Version 4 4 2 Page 2 e Contents L Introductions esta A ea deste cies An nt RE Le 4 1 1 Wh t is PCSMS Gateway Servers net MR is ee Ali nt eat a 4 1 2 How PC SMS Gateway Server Works inserer 4 2 e ment nee den eee 5 2 1 REQUIEM e AAA ER AA Re et te A mca beets 5 2 2 Installing the software nr ia aia 5 2 3 Running the Software cccecsecccececessessaeeecececeeseseeaeeeeeesseesesaeaeeeeecsseeesaeaeseeeesseeseaaeaeeeeeesseesaes 5 2 4 Setup GS MID VIC ner a A ed et oa te 6 2 4 1 Preparing the GSM Device 25 2 rente rate AEE EE AEEA EAE Ee etes er mens ne Ean 6 2 4 2 Preparing the SIM Card iii 6 2 5 Connecting GSM Device to PC SMS Gateway Server 6 3 GULBASICOp ratiION ii A ner vance ose gare ete nan see vase ee vane ede rene tes nd 9 3 1 RECEIVING SMS INbOX iii a bean cubes gab lasts cand t duree arret tee CT 9 3 2 Sending SMS ODUTDOX coi minis nent then nement tient 10 3 3 Open SMS Outbox Archive iii 12 3 3 1 Importing New SMS Outbox enr 12 3 4 SO arch SMS eas tennis nent nn en ni nn mean tnt en des 13 3 5 Managing Phonebook inserer 14 3 5 1 Managing Contacta ada cect etes daa 14 3 5 2 Managing Group nd cid 16 4 Advanced Operations reaa a aea e a a A Tin dead en ins a dada cite 18 4 1 D tab se Setup ENET E EEE E EE EE A O 18 4 2 Running as Windows Service cccconononoonnonononanononnnnnnncnnnnnnnonnnnnnnnnnnnannnnnnnnnnnn
16. STATUS Field Length VARCHAR 60 Field Type SUBJECT TEXT MEMO or VARCHAR 2000 INTEGER INTEGER DOUBLE INTEGER INTEGER INTEGER INTEGER VARCHAR 60 INTEGER Not Null yes no no no no yes yes no yes yes yes yes Description Table Primary Key SMS Subject for archiving purpose only and will not displayed on SMS message SMS Message SMS flag whether the SMS is flash SMS O Non Flash SMS default 1 Flash SMS SMS flag whether the SMS is Force non Long SMS or auto detect O Force non Long SMS 1 Auto detect default TimeStamp when the record is inserted SMS Type flag 1 Outbox 2 Archive 3 Template 5 DeletedOutbox 6 Draft SMS character encoding type O GSM Alphabet 7Bit 1 Octet 8bit 2 Ucs2 16 bit 3 Auto Detect default SMS Outbox Send Priority 2 Lowest 1 Lower O Normal 1 Higher 2 Highest Maximum Retry attemp to send SMS to SMS centre Default value is 3 DeviceCode used for Sending SMS Application flag wheter SMS has been read O unread 1 read USEVARIABLE INTEGER LASTSENTDATE DOUBLE USECUSTOMSMSC INTEGER CUSTOMSMSCNUMBER VARCHAR STATUSREQUEST INTEGER REQUESTREPLY INTEGER VALIDITYPERIOD INTEGER SCHEDULEDSENT INTEGER SCHEDULE DOUBLE 160 Page 34 SMS flag whether the SMS Using no Variable Tag Mail Merge like feature O Disable 1 Enabled default A N A Not applicable for compability only SMS flag whether the SMS usin
17. amp when the SMS inserted to Database SMSSTATUS INTEGER Application flag wheter SMS has been read 0 is unread and 1 is read Application flag of SMS type O Received Inbox SMS SMSTYPE INTEGER 4 deleted Received Inbox SMS 7 status report 8 deleted status report DEVICECODE VARCHAR 60 Device Code that receive the SMS Page 32 SMS flag whether the SMS is flash SMS O non flash SMS and 1 flash SMS SMS flag whether the SMS is Long SMS O non long SMS and 1 long SMS FLASHSMS INTEGER LONGSMS INTEGER SMS flag whether the SMS is Request Reply O non request reply and 1 request reply SMS character encoding type 0 GSM Alphabet 7Bit 1 Octet 8 bit 2 Ucs2 16 bit 3 Unknown REQUESTREPLY INTEGER CHARENCODING INTEGER International Mobile Subscriber Identity IMSI Number of IMSI MARCHE 160 Device Code that receive the SMS 2 2 3 Read non Long SMS from INBOX Table e Non long SMS are SMS which message length are less than 160 character and sent using single PDU e The example of SQL Script for reading received Inbox non long SMS are SELECT FROM INBOX WHERE SMSTYPE 0 2 2 4 Read Long SMS from INBOX Table e 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 e The example of SQL Script for reading received Inbox long SMS are o Step 1 Select a record a part of long SMS from the table SELECT FR
18. are require access to HKEY LOCAL MACHINE HKLM b The installer in ZIP file extract and run the setup exe file follow the instruction on the installer 3 Activating the Full version a The License is attached to the GSM Device IMEI Number in order to activate the License the GSM Device with IMEI Number should be Connected to PC SMS Gateway Server and Started 2 3 Running the Software e TheGraphical User Interface GUI executable file is smsgatewayserver exe this file is located in the installation folder g PC SMS Gateway Server 4 4 4 CES g Settings About Object Explorer Inbox PER so 15 Inbox New Outbox Import Outbox Outbox 3 Archive Date Message Contact Name Mobile Number Eg Status Report 142 Draft amp Template Trash Search Phonebook 8 SMS Gateway Server Started Connected to SMS Database Picture 2 1 PC SMS Gateway Server 4 4 GUI Page 6 2 4 Setup GSM Device 2 4 1 Preparing the GSM Device e The GSM Device connected to PC should using one of this connection o RS 232 o USB o Bluetooth e The PC SMS Gateway Server communicating with the GSM Devices through the serial ports the GSM Device should be seen as COM Port The list of Device which have COM Port connection could be seen in the Device Manager gt gt Ports a Device Manager DES File Action View Help Ao 7 o amp Audio inputs and outputs A 2 Batteries 8 Bluetooth Mi Computer a Disk drives
19. d List Restricted List Save Picture 4 3 Create Event Task e On the Filter tab Select the filter to be applied o Message Keyword Filter Keyword Keyword Type e Begin With e Exact phrase e Match Any Keywords e Match All Keywords Page 22 e Not Match Any Keywords o Sender Filter o Device Filter g Task x Task Name TASK 1 Y Enabled Task Task Type Event Task _ Interval Task Scheduled Task Filter Task Log Send sms Send SMS Settings C Execute SQL Script Execute SQL Database Connection Use S C 4b Save Picture 4 4 Task Settings e On Task tab set Task to enabled o Send SMS Click SMS Settings to open Send SMS Settings e Device for Sending SMS e SMS Message o Specify Message o Field Value from SQL Query o Incoming Message e Recipient List o Send to SMS Sender o Recipient List o Execute SQL Script SQL Script could be Stored Procedure Function or Any SQL Statement When using multiple statement each statement should be wrapped with the lt SQL gt lt SQL Statement gt lt SQL gt for example Page 23 lt SQL gt Exec StoredProc1 param1 param2 param3 INSERT INTO PHONEBOOK CONTACTID CONTACTCANAME MOBILENUMBER VALUES A5AB87E JOHN DOE 6285659999 105 lt SQL gt Picture 4 5 Example using lt SQL gt lt SQL gt for multiple SQL Statement Click the box on the right of SQL Script
20. et Name FIELDA 62 8172302044 62 85659999105 lt Field Link Source Field FIELDA FIELDB Page 16 Import from Excel File xls Update Contact With Duplicate Mobile Number _ Add Duplicate Contact To Group Only if Updated Sheet15 v A MA gt Phonebook Contact Field v CONTACTNAME v MOBILENUMBER v FIRSTNAME v LASTNAME v TITLE v ORGANIZATION v EMAIL STREETADDRESS v CITY v ZIPCODE v COUNTRY Picture 3 9 Import Contact e To perform importing Contact from MS Excel xls file O O O Open Contact Page Click Import Contact tool Button and select From file MS Excel xls after the Open Dialog forms is shows up Select the MS Excel xls file After the form Import Contact Import from Excel xls is shows up select the Sheet by selecting the Sheet Name After the Sheet is selected the Field Link should be set to link between the Field Link on the Sheet and the Contact select the Source Field which corresponded to the Contact Field If the Imported Contact would be added to Some Group s select the Group in the Group tab Click Import to perform import Contact 3 5 2 Managing Group e Group is the list of Contact s Page 17 g Group Group A E Properties Details Group ID Group Name Group A F SMS Gateway Server 4 4 6 Trial Version 5 Members Name Mob e Number Contact Group John Doe 462817
21. g no custom SMSC SMS Centre Number O Disable default 1 Enabled an SMSC SMS Centre Number used if USECUSTOMSMSC is set with 1 SMS flag whether the SMS is request no Status Report O Disable default 1 Enabled ets SMS flag whether the SMS is request Repl Disable default 1 Enabled o SMS validity period The default value 169 3 day ae Flag whether SMS Send on specified y date and time O Disable 1 Enabled m Date and Time if SCHEDULEDSENT set with 1 e OUTBOXRECIPIENT table field description are Field Name Field Type OUTBOXRECIPIENTID VARCHAR 60 OUTBOXID VARCHAR 60 COPY INTEGER RECIPIENT VARCHAR 160 RECIPIENTTYPE INTEGER e OUTBOXLOG table field description are Field Name Field Type OUTBOXRECIPIENTID VARCHAR CONTACTID VARCHAR SENT INTEGER RETRY INTEGER Field Length Description Table Primary Key Foreign Key OUTBOXMASTER primary key SMS copy SMS Recipient SMS Recipient type O Mobile Number 1 Contact ID from PHONEBOOK table 2 Contact ID from CONTACTGROUP table Field Tr Length Description 60 Foreign Key OUTBOXRECIPIENT Table Primary Key 160 SMS Recipient Number of SMS that has been sent Retry attemp to send SMS Page 35 BNUMBER VARCHAR 160 SMS Recipient mobile number TEXT MEMO or SMSMESSAGE VARCHAR 2000 SMS Message CREATEDDATE DOUBLE Timestamp when the record is inserted MODIFIEDDATE DOUBLE Last timestamp when the record is inserted or updated DELIVERYREPORT INTE
22. g MS Access Database iii 36 2 3 4 Sending SMS Using Custom Parameter ins 38 Page 4 1 Introduction 1 1 1 2 What is PC SMS Gateway Server The PC SMS Gateway Server is software for sending SMS using GSM Device support using multiple GSM Devices simultaneously The PC SMS Gateway Server have easy to use Graphical User Interface GUI to managing SMS and managing the GSM Devices The PC SMS Gateway Server store SMS on RDBMS Database provide flexible headroom for handling large number of SMS How PC SMS Gateway Server Works SMSgee sending SMS from PC using connected GSM Device GSM Phone Modem USB 3G Modem The GSM Device should have GSM SIM card with SMS subcription The cost of SMS is as is sending SMS from the mobile phone because the SMS is send like the way the mobile phone sending SMS The PC SMS Gateway Server is only provide the software the GSM Device amp SIM Card is not included Page 5 2 Getting started 2 1 Requirement e The detailed Requirement for hardware and software available on Appendix 1 PC SMS Gateway Server Requirement 2 2 Installing the software 1 Getting the Installer a Trial Version latest could be downloaed from http www smsgee com smsgatewayserver4 zi b The Full Version installer of the latest version please contact to SMSgee s support email support smsgee com 2 Run the installer a The Windows user account should have superuser admin access the SMSgee softw
23. he MS Access application doesn t necessary installed e MS SQL Server SQL Server Express 2005 or later e My SQL version 5 or later and ODBC connector version e Oracle 9 or later Page 28 Appendix 2 Supported GSM Device e The SMSgee software perform auto detect whether the connected device is supported e The GSM Device supported by SMSgee application is Device which Support Send SMS in PDU Mode and Support Load Inbox in PDU Mode e The list below is only the reference We haven t test all device simply if tdevice is not listed in this supported device list just connect with the SMSgee software and it will automatically detect whether the device is supported e 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 e Recommended UMTS GSM modem For 24 7 SMS server we only recommend Industrial Grade GSM Modem o sierra wireless formerly wavecom fastrack series modem o i tegno usb serial port modem o siemens serial port modem e g Siemens MC55 TC65 o Another brand which use Wavecom or Siemens Chipset e Some UMTS GSM phone or 3G USB Dongle is also supported but not for 24 7 use because often hang or disconnected o Some tested and supported USB Dongle GSM Device Option e Icon 505 e Icon 515 Huawei e K3565 e E173 e E220 e E510 Page 29 Appendix 3 Integrating SMS with other application Readi
24. lue 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 e The MS Access database Date data type start from O as December 30 1899 so no compensating value is necessary when using MS Acces database Example D 1 Create Outbox Recipient Create Recipient by Mobile Number INSERT INTO OUTBOXRECIPIENT OUTBOXRECIPIENTID OUTBOXID RECIPIENT RECIPIENITYPE COPY VALUES Ri OUTBOXi INSERT INTO OUTBOXRECIPIENT OUTBOXRECIPIENTID OUTBOXID RECIPIENT RECIPIENTTYPE COPY VALUES R2 OUTBOXi Example D 2 Create Outbox Master INSERT INTO OUTBOXMASTER OUTBOXID SMSMESSAGE CREATEDDATE SMSTYPE PRIORITY MAXRETRY DEVICECODE SMSSTATUS SCHEDULEDSENT LONGSMS 3 GS VALUES OUTBOX1i Sending SMS using SMS Gateway Server CAST GETDATE AS FLOAT 2 1 0 GSMDEVICE1 0 0 1 2 3 3 2 Using MySQL Database e Inthe example below the PC SMS Gateway Server SQL Database is using the MySQL 5 x e The table field Date data type of the PC SMS Gateway Server is stored in database as Double data type The application Date data type 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 OUTBOXRECIP
25. ng Inbox and WritingOutbox Directly onDatabase Contents 1 Introduction 2 Integrating PC SMS Gateway Server by Accessing SQL Database 2 1 Introduction 2 2 Receiving SMS 2 2 1 Introduction 2 2 2 Inbox Table Fields 2 2 3 Read Non Long SMS from Inbox Table 2 2 4 Read Long SMS from Inbox Table 2 3 Sending SMS 2 3 1 Introduction 2 3 2 Outbox Table Fields 2 3 3 Sending SMS Using Default Parameter 2 3 4 Sending SMS Using Custom Parameter Page 30 1 Introduction e 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 e 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 E SMSgee PC SMS Gateway Sever Other Application UMTS GSM Device Connected to PC SOL Database 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 Page 31 2 Integrating PC SMS Gateway Server by Accessing SQL Database 2 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
26. ng SMS If the long SMS enabled the Message longer than one SMS the message will be splitted to several SMS If the long SMS disabled if the Message longer than one SMS the message will be cut only one SMS o Use Variable When Variable tag is used the Use Variable options should be enabled o Character Set Encoding Some language has alphabet which could not be sent using the GSM Character Encoding then it should be send using the Unicode UCS2 Character Encoding Only Auto and Unicode UCS2 are could be selected e Ifthe auto selected the application will determine which Character Encoding should be used e Ifthe Unicode UCS2 is selected the SMS always will be sent in Unicode UCS2 encoding e The maximal charater for one SMS for Character Encoding o GSM 7 bit 160 character o Byte ASCII 8 bit 140 chracter o Unicode UCS2 70 character o Delivery Report o Request Reply The Recipient List tab e Recipient List required When the Send button is clicked on the New SMS will be saved to the Outbox except some required field os left blank there will be Notification about the Required Field to be filled in The progress on Sending SMS could be viewed on the Recipient List Outbox Log on SMS Archive SMS Outbox To view the Queued Outbox SMS go to the Outbox Page on the Object Explorer select Outbox in the SMS Folder and then select The Outbox Queue Tab Page 12 g PC SMS Gateway Server 4 4
27. ngs About Object Explorer 4 a SMS Folders GA Inbox Search E Phonebook lt Connected to SMS Database SMS Gateway Server localhost 2026 S PC SMS Gateway Server 4 4 6 Trial Version Outbox Outbox Queue amp New Outbox Import Outbox Date Subject Message Device Code g New Outbox SMS amp Send Save As Subject Testing Sending SMS Device Code GSMDEVICE1 Y scheduled Message Recipient List 2 Send Prority Z Options The quick brown fox jumps over lazy dog Variable Symbol GSM character Picture 3 3 Create New SMS Outbox J 39 character e To create Outbox click New Outbox tool Button to shows up the New SMS Outbox Form The New Outbox tool Button could be found on the SMS Folder Page Inbox Outbox Archive Status Report Draft Template Trash o Field on the Form New Outbox SMS Subject optional This field used only for archiving purpose only not will be included on the SMS message Device Code required This field determine which GSM Device is used for sending the SMS Scheduled optional This field determine when the SMS Outbox will be queued on the Outbox Queue The Message tab e Send Priority e Options o Flash SMS When Flash SMS is enabled the SMS Message will be displayed directly on the recipient handset On some Mobile Phone the Flash SMS will not be saved into Inbox Page 11 o Lo
28. nnnnnornnnnnnnnnnanones 19 4 2 1 INtrOUUCTION E EEE T EE an 19 4 2 2 Setting Running as Windows Service 19 4 3 SMS TaS kiaat tdt 21 4 3 1 A A EE 21 4 3 2 Interval Task a A At 23 4 3 3 Scheduled Task oia ia 26 Appendix 1 PC SMS Gateway Server Requirement sisi 27 Operating SYSTEM rieur rente die tenir ne ter Penn tee nada ne Bei def nets ed rente 27 PC Hardware Requirement sorsien ea aani eria era ar aa O a a EaR a a aaa aiian 27 GSM DU Ce penses en ie ese aa ak ese ne oes wa E A a DO as SS 27 e Supported RDBMS Database nine 27 Appendix 2 Supported GSM DeViCe ccccccccccssssssssssecececeseeseeaeseeeeecesseeaaeseceessessesaaaeceesesseeseaeaeeeeeens 28 Appendix 3 Integrating SMS with other application Reading Inbox and WritingOutbox Directly OnDatabase s iue ii le ste A Mea AL A AE Bs 29 COMNEN erii eee eee ae eee 29 Ls Introduction xs a eee aie eh a een Ud ae Ra lee ieee 30 2 Integrating PC SMS Gateway Server by Accessing SQL Database 31 21 FINTOAU HONEE ES RE A A A testa eee 31 2 23 s Receiving SMS TN 31 2 2 1 Introducir 31 2 2 2 INBOX tabla Telds rita AS 31 2 2 3 Read non Long SMS from INBOX Table 32 2 2 4 Read Long SMS from INBOX Table 32 23 Sending SMS A a A EA A A ete den rd 33 2 3 1 O A 33 2 3 2 OUTBOX Tables Fields ccoo a tae e rea 33 2 3 3 Sending SMS Using Default Parameter ss 35 2 3 3 1 Using MS SQL Server Database 36 2 3 3 2 Using MySQL Database cio 36 2 3 3 3 Usin
29. r Windows Service on localhost E Checked Install SMS Gateway Server as Windows Service checkbox b Port Number is TCP Port number of PC SMS Gateway Server Windows Service TP Port could be changed to any unused TCP port number c Password could be changed ASCII character only 4 GUI settings to connect Windows Service Page 20 Set SMS Server Host IP address with the PC SMS Gateway Server Windows Service IP number a If the GUI and the Windows Service is on same PC set to localhost or 127 0 0 1 Set Port Number and Password of the PC SMS Gateway Server Windows Service a Port Number and Password should be match with the PC SMS Gateway Server Windows Service Service on previous step 5 Click save to save and apply changes 6 If the Windows Service has been installed there will be SMSgee PC SMS Gateway Server 4 4 on Services 3 Services ste File Action View Help ess Ir su Gh Services Local less j SMSgee PC SMS Gateway Server Name Description Status Startup Type Log On As 5 440 Automatic A Sh SNMP Trap Receives tra Manual Local Service Stop the service Pause the service 4 Software Protection Enables the Automatic D Network Service Restart the service Spot Verifier Verifies pot Manual Trig Local System 4 SQL Full text Filter Daemon Launcher MSSQLSERVER Service to la Manual NT Service MSSQLI Soh SOL Server MSSQLSERVER Provides sto Manual NT Ser
30. r laz 6285659 The quick brown fe 6285659 Forward 1 18 2015 4 16 fox jumps over laz 6285659 1 18 2015 4 04 SMS History The quick brown f 6285659 1 18 2015 4 06 fox jumps over laz 6285659 1 18 2015 4 0 Delete The quick brown fi 46285659 1 18 2015 4 0 Select All fox jumps over laz 6285659 1 18 2015 3 5 The quick brown fc 6285659 1 18 2015 3 59 30 PM Hello The quick brown fox jumps over laz 6285659 1 18 2015 3 26 59PM jumps over lazy dog 4The quick brown ft 6285659 1 18 2015 3 26 57 PM Hello The quick brown fox jumps over laz 6285659 1 18 2015 3 16 05PM The quick brown fox jumps over lazy dog 46285659 M Picture 3 2 SMS Inbox Right Click Menu o Open SMS Double click the Message on the Grid to view the Detailed SMS Or right click on the SMS Grid and select Open o Reply SMS Select the SMS on the SMS grid then right click and select Reply the New Outbox SMS with replied number form will shows up O O Forward SMS Page 10 Select the SMS on the SMS grid then right click and select Forward the New Outbox SMS with forwared message form will shows up Deleting SMS Select the SMS on the SMS grid then right click and select Delete 3 2 Sending SMS Outbox e Outbox is the SMS that are queued to be sent e To make the GSM Device sending SMS the Enable Send SMS should be enabled in GSM Device Settings g Setti
31. s the list to correspond between the Mobile Number with the Contact Data Name Organization Address etc Page 15 g John Doe Ez Contactname EEA Mobile number 62817230204 C SMS Gateway Server 4 4 6 E Details Additional Field ContactID First name Contact Group FE Title New Contact Last name Import Contact Organization E mail Name Mobile Number Last Name First Street address City ZIP code Country lt gt lt gt Connected to SMS Database Picture 3 8 Create New Contact e The constraint for the contact is the mobilenumber couldn t be duplicated one mobile number only could be used by one contact e To acces the Contact Page o Select Phonebook on the Object Explorer o Select Contact Tab Creating New Contact o Click New Contact tol button on the Contact Page o After the new Contact Form is shows up fill the Contactname and the Mobilenumber which is required field another field is optional e Open Contact o Select a contact and then double click the Contact Grid o or Select a contact and then right click on the Contact Grid and Select Open e Delete Contact o Select some contact and then right click on the Contact Grid and Select Delete 3 5 1 1 Importing Contact e The Contact also could be created by using the data from the MS Excel xls g Import Overwrite Options Source Group DataSet 2 record She
32. to Open SQL Editor Device for Sending SMS 8 Reply using same Device O Specify device code Device Code GSMDEVICE 1 Message Recipient List SMS Message specify Message OField value from SQL Query O Incoming Message Variable Symbol Picture 4 6 Send SMS Settings Event Task Message Tab g Device for Sending SMS 8 Reply using same Device O specify device code i Device Code GSMDEVICE1 Message Recipient List Send to SMS Sender auto reply Contact 2 Group 0 Number Import 0 Recipient List 0 Copy serh i Name Mobile Number a ContactName Type Mobile Number Copy Jane Dane 46285659999105 ns Y John Doe 462817230204 gt gt lt Y lt lt p lt X Picture 4 7 Send SMS Settings Event task Recipient List Tab 4 3 2 Interval Task Page 24 e Interval task is SMS Task which executed on specified Interval 4 3 2 1 Create Interval Task To create Event Task go To SMS Object Explorer and select SMS Gateway Server Select the SMS Tasks tab After the form Task opened checked the Enabled Task and select Interval Task in Task Type Interval Settings o Next Execute On Time when the next cycle that the task will be executed o Timeout Tolerance Maximum late tolerance after Executed time
33. to save the settings and applying the changed to the GSM Device Settings Page 7 4 Toset the GSM Device to Receive SMS On the Receive SMS tab set the Enable Receive SMS to Enabled 5 Toset the GSM Device to Send SMS On the Receive SMS tab set the Enable Send SMS to Enabled 6 The GSM Device which have been created will be shown in the GSM Devices List g PC SMS Gateway Si y 7 3 A rag GSM Device Settings ajg Settings About Device Code Object Explorer GSM Devices SMS Tasks GSMDEVICE1 4 mn SMS Folders fl p A Inbox Device Connection Receive SMS Send SMS 5 Outbox A Archive Device Code COM Port COM Port Settings aj Status Report a Fa po COM Port v Search 9 Template Y Enabled autc COM Port Device Name IMEI Operator Name Device Code Trash COM3 o I Search Port speed coM4 1 Phonebook Speed bps coms 8 SMS Gateway Server Started COM6 Flow Control coms Preset RTS DIR Y Out CTS Out DSR DSR sen lt Search Supported GSM Device Connected to PC Save Connected to SMS Database Picture 2 3 Performing Search Supported GSM Devices g GSM Device Settings Device Code GSMDEVICE2 Device Connection Receive SMS Send SMS Receive SMS Options M Enable Receive SMS Y Save to SMS database Override SMS memory type AT CPMS Save Picture 2 4 GSM Device Settings Receive SMS Page 8
34. vice MSSQL SQL Server Agent MSSQLSERVER Executes jo Manual NT Service SQLSER wh SQL Server Analysis Services MSSQLSERVER Supplies onl Manual NT Service MSSQL 4 SQL Server Browser Provides SQ Manual Local Service Picture 4 2 SMSgee PC SMS Gatway Server Services Page 21 4 3 SMS Task e SMS Task is automated Task to Send SMS and or Execute the SQL Script 4 3 1 Event Task e Event Task is Task SMS Task which is triggered when the SMS is Received e Event task could be filtered by some SMS criteria If the Event Task is not filtered all received SMS will be triggered the Event Task e The filter for Event Task o SMS Filter based on SMS Message Content optional o SMS Filter based on SMS Sender Number optional o SMS Filter based on GSM Devices which receive the SMS optional 4 3 1 1 Create Event Task e To create Event Task go To SMS Object Explorer and select SMS Gateway Server e Select the SMS Tasks tab e After the form Task opened checked the Enabled Task and select Event Task in Task g Task Ea Task Name TASK 1 Y Enabled Task Task Type de E SMS Gateway Server 4 4 6 5 O Interval Task f acta SENE O Scheduled Task Filter i Teka ltog GSM Devices SMS Tasks Message Keyword Filter Z2 E X A Re use Filter by Keyword Message ES Fe Task Name 2 Status TASK Register Contact Enabled Keyword Type Sender Filter Allowed List Restricted List Device Filter Allowe

User Manual Version 4.x

Contents

Download Pdf Manuals

Related Search

Related Contents