SMS = Short Message Service. This is a network
service provided by mobile phone network operators or service providers. It
enables you to send and receive short text messages over the digital cellular
network. With the PRODBX SMS connection client you are able to store or initiate
those SMS messages in another system.
SMS is limited to 160 characters. Depending on
your hardware, operator's network and the recipient's phone support you may send
longer messages. In that case they will will be cut in messages of 160
characters and concatenated back by the recipient. This technique is outside
PRODBX, and more information on this subject is to be found in the documentation
of your phone hardware.
Select SMS in the connection type listbox when
defining the database connection. Your screen will look like:
- GSM interface: Select the hardware
you are using. Check the technology
section for more specific information. If your hardware is not in the
list, please contact us.
- Pin code: PIN = Personal Identity
Number. This is the numeric code you use to startup your phone. Is the
number you programmed on the SIM (Subscriber Identity Module) card of your
network provider. This code is minimum 4 and maximum 8 digits long. Defining
your PIN code is not done by PRODBX. You must define it through the software
of your hardware, or directly on the phone. This is also when you used a
wrong PIN code and your SIM card gets blocked and asks you to enter the PUK
code (Personal Unlocking Key). The PUK code is supplied by your network
provider together with the SIM card.
- Number SMS centre: Text messages are
always first transmitted to a Short Message Service Centre (SMSC) run by the
network operator. The SMSC then forwards the message to the recipient. If
the recipient is not immediately reached, the message is stored in the SMSC
until the recipient can be reached. The number to enter here is therefore
typical to your network operator. Enter the number in its full notation,
this is with '+' and country code.
- Field name Message: Basically an SMS
message contains 3 parts of relevant information, the message itself, the
phone number of the transmitter and the timestamp when it was issued to the
network. In order to use this information in later definitions in PRODBX you
must get this information to behave as if it was a database table. The name
of the table is fixed to 'SMS', and the name of the fields are defined over
here. In our example (screenshot) you can use the message of your SMS later
by calling the table SMS and access the field 'Message'. See picture below,
based on the screenshot example.
- Field name Tel. Number: see Field
- Field name Timestamp: see Field name