Kylix SMS Server User Manual 2.5

 

General

Screen shots

 

 

Features

 

Hardware and software requirements
1. There should be at least one PC running Windows with the system server or client, such as: Windows9X, Windows Me, Windows 2000, Windows XP and Windows 2003.


2. There should be one existed database in the original software, or you can create a new one.

FAQ: Is Kylix SMS Server able to work with software without database?


3. A GSM mobile phone or GSM Modem, we recommend GSM Modem.

FAQ: How to choose GSM Device?


4. A SIM card with SMS service.

 

 

Installation
1. Choose one PC running with Windows from your system as SMS server, and each following step should be done on that PC.


2. Double click "SMSServerSetup. exe " to install this software. When the installing finished it can run automatically, then the Configuration dialog box will be displayed for you to set the parameters.


3. The software installed with a MS Access database file "SMSDemo.mdb", 2 tables in this file are used for sending and receiving message. If you are first times use this software we suggest you use the default database, and then go to step 5. If you want to use the database of your own software, open "ODBC Data Source Manager" in Control Panel, and build a DSN based on the information of your database. 


4. Choose Database Tab Page of the software, and then enter DSN and other database information such as login user name and password. Set SQL scripts according to the names of the tables and fields of your database. If you don’t have SMS In/Out table in your software yet, we suggest you use default value. Please refer to "Configuration" on next chapter for detailed explanation. How to: Configuration of Database


5. Follow the instruction of your GSM device, connect your device to a serial port or USB port, or align it with the infrared port, turn on the device and wait about 30 seconds before the device properly logged itself into GSM network, and then go on with the following step. FAQ: How to choose GSM device?


6. Choose Device Tab Page, and then choose the right port number and baud rate according to the user’s manual of your GSM device, and enter SMS center number. If your SIM card asks for PIN code, please enter the proper PIN code. Leave it blank if PIN code is not required.


7. Click Apply button after complete parameter setting. Locate Kylix SMS Server icon in Windows tray, and then right click on it, choose "SMS Server Start" from the menu to start the service.


8. Choose Information Tab Page and wait for about 10 seconds before you can see correct GSM device parameters, otherwise you should check if the port number and baud rate of your GSM device is properly set. If there are unsent SMS messages in your SMSOut Table, then you can see the number of the messages in "Unsent" field, otherwise you should check the parameter settings of the database.

 

9. Select "send-receive SMS" from start menu, the database file will be opened by MS Access. Modify any record in SMSOut table, change the value in Phone field to receiver's phone number, and change the value of status field to 0. Wait several seconds, before receiver's phone will receive the message. Send a message with a mobile phone to the number of the GSM device, and wait several seconds, after the GSM device receives the message, open SMSIn table and you can see the received message.

 

10. When the software is running, status in "Service Status" of Information Tab Page, and you will find the icon displaying current status in Windows tray. There are 3 modes of status altogether, Running, Stopped and Error. In case any errors appear, please open the "Configuration" dialog box, check each option is correctly set, the database is well connected and the GSM device is working properly.

 

11. Upgrade your software, insert SMS messages need to be sent into the SMSOut Table, and query SMSIn table when you want to check answered SMS messages. Now the SMS functions of your software are ready for use.

 

Parameter Setting Reference
1. Device Tab Page

FAQ: How to choose GSM device?

Port Number: when the IR or blue tooth GSM device connects to your PC through virtual serial port, you should choose the virtual serial Port Number rather than IR port. 

COM Baudrate: please refer to your GSM device instruction manual, usually it would be 9600, 19200 or 57600.
FAQ: How to set Connection Mode and Port Number. 
Retry Interval(s): the waiting time before retrying when error sending message. Increase this value when you encounter errors in sending SMS in batch, and this will decrease the sending speed.
Retry Times: times of retry if sending message fails.
SMS Center Number: leave it blank if you have set it in your SIM Card. You can also set SMS Center number with your mobile phone.
PIN Code: leave it blank if your SIM card does not require PIN code.
Concatenated SMS Mode: use Concatenated SMS mode. 

FAQ: What is Concatenated SMS mode?


2. Database Tab Page

Connection: ADO connection string or ODBC DSN or OLE DB udl file.
User: database user name.
Password: user password.
Interval(s): the time interval for database querying. The smaller value means more promptly sending but heavier database load, and the larger value means less promptly sending but lighter database load.
SMSOut select SQL: to query messages need to be sent, among which <MSGID>,<PHONE>,<MSGBODY> are escape sequences, and no other value should be used.
SMSOut update SQL: to update the sent result to the database, among which <RESULT>,<MSGID> are escape sequences, and no other value should be used.
SMSIn insert SQL: to insert the received messages into the database, among which <PHONE>,<MSGBODY>,<TIME> are escape sequences, and no other value should be used.

How to: Configuration of Database


3. Message Tab Page

Sending period limit: set messages to be sent in specified period.
Start sending time: the start time for the sending period.
End sending time: the close time for the sending period.
DB Connection Lost Warning: when the database connection is broken, it will send warning message to the specified phone.
Send Daily Report: send report at specified time every day.
Report Time: time for sending the report message.
Battery Low Warning: send warning message to specified phone when battery level is low.

Start Service when OS starts: start SMS service when Operating System starts.


4. Information Tab Page

Manufacturer: the brand of GSM device.
Model: the Model of GSM device.
IMEI: the Sequence Number of GSM device.
Battery Level: current battery level of GSM device.
Signal Quality: current signal quality of GSM device.
Sent: accumulated sent messages.
Unsent: number of unsent messages in the database.
Received: accumulated received messages.
Failed: accumulated failed sending messages.

 

5. Gateway Tab Page

POP3 Server: Email server domain or IP address.

POP3 Account: Email account.
POP3 Password: account password.
POP3 Port: Email server POP3 port, default port is 110.
Query Interval: Polling interval, minimum value is 60s.

Test POP3: test the POP3 settings.

Email Content: send Email body to mobile phone.

Email Address: send Email sender address to mobile phone. If both Email Content and Email Address are unchecked, software only send Email subject to mobile phone.
Default Number: if Number Prefix string is not found in Email subject, the SMS will be sent to this number.
Number prefix: identifier string of the receptor number. If this string is not found in Email subject, the SMS will be sent to Default Number. At least one of Default Number and Number Prefix must be set to use Gateway functions.


6. About Tab Page

Device Code: hardware identify code of GSM device, which should be supplied during registration.
Registration Code: registration code you purchased.
Register: register the software with the registration code you purchased.
Order Online: Purchase the software online.

 

 

Configuration of Database

            select msgid as <MSGID>, phone as <PHONE>, msgbody as <MSGBODY> from smsout where status=0

            update smsout set status=<RESULT> where msgid=<MSGID>
            insert into smsin(phone, msgbody, rectime) values('<PHONE>', '<MSGBODY>', #<TIME>#)

 

 

FAQs
1. How do I run this software as soon as possible, I want to try if it works before adding these feature to my software and database, what should I do?
2. How to choose GSM Device?
3. Does the software support GPRS or CDMA Modem?
4. How to Set Connection Mode and Port Number?
5. What is Concatenated SMS Mode?
6. Is Kylix SMS Server able to work with software without database?
7. Why there are some unsent messages in "Unsent" of Information Tab Page, and the software does not send it automatically?
8. I am using Linux server on my system, can I still use Kylix SMS Server?
9. Our system is B/S structure and developed with PHP, how do I send SMS message?
10. How do I know whether the message is successfully sent?
11. My device was damaged and I changed a new one, how can I keep using it?
12. How to make Kylix SMS Server as a integrate part of our software product rather than an additional software?
13. I feel inconvenient with the device related registration, can I use other registration means?
14. We want to build in SMS functions into our software, but not as additional software, what should we do?
 

1. How do I run this software as soon as possible, I want to try if it works before adding these feature to my software and database, what should I do?

2. How to choose GSM Device?

3. Does the software support GPRS or CDMA Modem?

4. How to Set Connection Mode and Port Number?

5. What is Concatenated SMS Mode?

6. Is Kylix SMS Server able to work with software without database?

7. Why there are some unsent messages in "Unsent" of Information Tab Page, and the software does not send it automatically?

8. I am using Linux server on my system, can I still use Kylix SMS Server?

9. Our system is B/S structure and developed with PHP, how do I send SMS message?

10. How do I know whether the message is successfully sent?

11. My device was damaged and I changed a new one, how can I keep using it?

12. How to make Kylix SMS Server as a integrate part of our software product rather than an additional software?

                         install service:          SMSServer /install

                         start service:            SMSServer /start

                         stop service:             SMSServer /stop

                         uninstall service:      SMSServer /remove

 

          Windows 95, Windows 98, Windows ME

                         run:                            SMSServer /win9x

13. I feel inconvenient with the device related registration, can I use other registration means?

14. We want to build in SMS functions into our software, but not as additional software, what should we do?

 

Registration

 

Contact us
If you have any problems during your using or trial, or if you have any idea or suggestion, please feel free to connect us.

Sale:

sales@kylixsoft.com

Support:

support@kylixsoft.com

Website:

www.kylixsoft.com

Note: Please do not forget to send your error report along with the log files KylixSVR.log and KylixSMS.log and your system specifications. We need to know the model of the mobile phone or GSM/GPRS modem you have, your Connection Mode, Cable/Adapter Model, COM Port Number, COM Port Baudrate, your developing tools and the Operating System you use, so that we can help you.