This software is recommended if you have a Microsoft SQL server. Incoming messages will be inserted into the SMS_In table, and messages inserted into the SMS_Out table will be automatically sent.
1) Install the application
2) Follow the instructions in the readme.txt file
Insert messages into the SMS_Out table to send messages. Incoming messages are automatically inserted into the SMS_IN table. The SMS_Out_Log table will store delivery information of messages that are sent.
Changelog:
v1.0.83
- Fixed some decimal separator parsing problems
v1.0.80
- Unicode support
v1.0.71
- Fixed delivery report bug
v1.0.70
- Fixed overflow in campaignid
- Increased fromalpha field length to 11 characters
v1.0.34
- Added support for delivery reports
- Support for specifying when a message will be sent
v1.0.31
- Fixed bug in DB poller
v1.0.29
- Fixed replypathid in SMS_In
v1.0.27
- Changed databaseprovider
- Added field for Nrq in Sms_Out
- Added field for DestTel in Sms_In
v1.0.25
- Fixed errors in ViaNett.sql script
v1.0.24
- Fixed missing field in upgrade script. Removed ViaNett_Upgrade_1.0.22.sql
v1.0.23
- Fixed bug in logfile format. Service did not create new files until restart
- Fixed bug in message encoding introduced in v1.0.22
v1.0.22
- Added parameter for Catalog Name (Database name) in config file,
see ConfigExample.xml for usage. This will override database name specified in
connection string. Users witch use database name other than "Vianett" has to
add this parameter to their config file.
- Added support for multiple connections and databases. Add a filename on a new line
in ConfigFiles.ini for each connection you want to add.
- You can split logfile up in the way you want by renaming it in the config file, see ConfigExample.xml for usage.
The format is LogFileName_{<format>}.extesion
eg: SocketLog_{yyyy_MM}.log -> SocketLog_2005_02.log
This example will make a new logfile every month
You can use any Custom .NET DateTime Format Strings:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomdatetimeformatstrings.asp
- Moved log files to "Logs" directory
- Moved is_alive and is_alive_ack messages to separat log file
- Added fields for content messages
- Fixed encoding problems
v1.0.21
- Moved DB ConnectionString to Config.xml, default is
<ConnectionString>data source=localhost;initial catalog=Vianett;integrated security=SSPI;persist security info=False;packet size=4096</ConnectionString>
- Fixed bug when two processes tries to append to logfile simultaneous
v1.0.20
- Added field RecievedTime in SMS_In table, run ViaNett_Upgrade_1.0.20.sql
v1.0.19
- Added support for using DB polling instead of MSMQ, this is the default option
- new optional sections in config fil:
<UseMSMQ>false</UseMSMQ>
<MSMQPath>.\private$\ViaNettOut</MSMQPath>
<DBPollingInterval>15</DBPollingInterval>
- Fixed bug when sending and recieving MMS
v1.0.18
- Added fields refno, CountryId and ErrorDescription to SMS_Out_Log table,
upgrade script is provided in MSI file
- Changed PK of table SMS_Out_Log to CLUSTERED (msgID, refno)
- Changed naming of SQL upgrade scripts to reflect version number.
- Fixed error when sending long messages. Messages that are splitted by ViaNett will
generate multiple delivery reports which will be logged as seperat records in SMS_Out_Log.
- The Msg field in SMS_Out_Log is provided from delivery report, not SMS_Out table.
v1.0.17
- SMS_Out_Log did not contain campaignID
- new optional sections in config fil which will force creation of log message even though delivery report
has no coresponding message in SMS_Out table:
<ForceCreationOfSmsOutLog>true</ForceCreationOfSmsOutLog>
v1.0.16
- The service now waits for Meassage Queue service to start before invoking
the MSMQ listener.
- If config file exists, it will not be rewritten when upgrading after this
version. When you upgrade to this version the config file will be rewritten.
Print the article