MOBITEK MobiGATE — How to Send and Read SMS

MOBITEK MobiGATE -- SMS Gateway for Enterprise

MOBITEK MobiGATE — SMS Gateway for Enterprise

MOBITEK® MobiGATE is a SMS Gateway for Enterprise.

MOBITEK® MobiGATE is an intelligent 8 port modem pool.

These are the supported protocol to send and read SMS:-

  1. SQL Statement:- 
    • to send out SMS: 
Insert into Outbox (message, destination) values ('Hello!', '+60172233111');
    • to read SMS: 
Select * from Inbox where read_status = 'N';
    • to out SMS in bulk:
Insert into Outbox (message, destination) values ('Hello!', '+60172233111'),  ('Hello!', '+60172233112'), ('Hello!', '+60172233113'), ('Hello!', '+60172233114'), ('Hello!', '+60172233115');
    • to out SMS in bulk (MS SQL):
BULK INSERT Outbox FROM 'C:\MSSQLTextFile.txt' WITH(FIELDTERMINATOR=',',ROWTERMINATOR='n'
    • example of the text file, "MSSQLTextFile.txt":
,Hello!,,,+60172233111,,,,,,,,

,Hello!,,,+60172233112,,,,,,,,

,Hello!,,,+60172233113,,,,,,,,

,Hello!,,,+60172233114,,,,,,,,

,Hello!,,,+60172233115,,,,,,,,
    • to out SMS in bulk (MySQL):
LOAD DATA INFILE 'C:\MySQLTextFile.txt' INTO Table Outbox FIELDS TERMINATED BY ',';
    • example of the text file, "MySQLTextFile.txt":
,Hello!,,2015-12-17 09:33:29,+60172233111,P,NULL,NULL,NULL,NULL,T,NULL,

,Hello!,,2015-12-17 09:33:29,+60172233112,P,NULL,NULL,NULL,NULL,T,NULL,

,Hello!,,2015-12-17 09:33:29,+60172233113,P,NULL,NULL,NULL,NULL,T,NULL,

,Hello!,,2015-12-17 09:33:29,+60172233114,P,NULL,NULL,NULL,NULL,T,NULL,

,Hello!,,2015-12-17 09:33:29,+60172233115,P,NULL,NULL,NULL,NULL,T,NULL,
  2. MOBITEK SMS API over TCP/IP

More Information