An IT Services Company

Sharing the SMS Client Database

The SMS Client database can be shared between different users if all the following conditions are met:

  • All the computers using SMS Client are on the same network
  • The SMS Client database is copied to a shared location on the network that is accessible to all the computers
  • The configuration file on each computer is updated to point to the shared database
  • Note
    When a new release or update of SMS Client is installed the changes to the configuration files have to be made again.

    Procedure
    1. Create a shared folder on the network.
    The shared location should be accessible to all the computers. Ensure that all the users can write to the share. Test the share by copying a file to the shared folder from each of the computers.
    2. Copy the SMS Client database to the shared location on the network.
    The SMS Client database is displayed on the main screen of SMS Client

    Path to the SMS Client database in the status bar

    3. Update the SMS Client configuration file to point it to the new database location.

  • Open a new Command Prompt window.
    Windows XP users: Click on Start->All Programs->Accessories->Command Prompt.
    Windows Vista or Windows 7 users: Click on Start->All Programs->Accessories and the right-click on Command Prompt, and click on Run as administrator
  • Type the following:
    cd "C:\Program Files\C.A & W Services CC\SMS Client"
    and press enter
  • Type the following:
    copy SMSClient.exe.config SMSClient.exe.config.save
    and press enter
  • Type the following:
    notepad SMSClient.exe.config
    and press enter
  • Find the line that reads (line 78):
    connectionString="Data Source="C:\ProgramData\SMSClient\SMS.sdf""

    and replace the C:\ProgramData\SMSClient\SMS.sdf section with the full path for the SMS Client database in the shared folder (Step 2). Do not replace any of the other characters in the string.

    Be careful not to change anything else in the file. If this edit is not made correctly then SMS Client will fail to run
    Save the file.

  • 4. Run SMS Client and check that the Database information now points to the shared database. (See the picture at Step 2)

    Troubleshooting
    1. SMS Client fails to start after the edit
    This could be the result of the edit of SMSClient.exe.config changing some text or the structure of the file. Restore the backup configuration file:

  • Open a new Command Prompt window. Windows XP users: Click on Start->All Programs->Accessories->Command Prompt. Windows Vista or Windows 7 users: Click on Start->All Programs->Accessories and the right-click on Command Prompt, and click on Run as administrator
  • Type the following: cd "C:\Program Files\C.A & W Services CC\SMS Client\" and press enter
  • copy SMSClient.exe.config.save SMSClient.exe.config
  • Redo the step 1 to 4 and ensure no changes are made except the path to the database.
    2. SMS Client cannot connect to the database

  • Check that the database is in the expected shared location
  • Confirm that write access is enabled for the user to the shared folder
  • SMSClient Version History

    Version 2.0.25

    Remove duplicate numbers

    A new option to remove duplicate cell numbers when sending messages was added to Ad-hoc (single) SMS messages and Bulk SMS messages.

    The option is enabled by placing a check in the box ‘Send only one message to a number’. When compiling the batch of messages the system will ensure that only one SMS is sent to each cellphone number. This is very useful where multiple contacts may share a cell number, or where cell numbers are imported from a CSV or XLS file and you want to ensure nobody receives duplicate messages.

    Remove duplicate numbers

    Send only one message to a number

    Import cell numbers for Bulk SMS

    Cell numbers can be imported from CSV files or Excel 2003 (XLS) files.

    Requirements

    1. For CSV files: The first column should be the cell number, the second column should contain the recipient’s name. All other columns are ignored.
    Example:
    0825551234,John Doe
    0825551122,Jane Doe

    2. For XLS files: Only the first sheet in the document will be imported. The first column should be the cell number, the second column should contain the recipient’s name. All other columns are ignored.
    Reading of the data will stop on the first row with a blank cell number field. Therefore, ensure that all the rows in the XLS file (spreadsheet) contain data.

    Import numbers

    Alternative source for bulk SMS messages

    Version 2.0.8

    Connection Status

    Connection status is now visible at the bottom of the screen.

    Connection Status

    Offline Mode

    Outbox

    Access the Outbox from the menu

    The option is now available to work off-line. All messages will be queued on the workstation and will appear in the Outbox. The messages in the outbox will automatically send once the connection to the internet is established.

    Set the preferred Delivery Options in the Configuration section. We recommend the default setting of ‘Deliver directly or queue on local server if delivery fails’.

    Additionally, on all messages the ‘Do not send after’ option allows you to set an expiry date and time for the message. This will prevent a message from being delivered after the expiry date.

    For example: Consider the situation where you send an SMS message to a client to remind him of an appointment on Friday morning at ten. If the SMS message was waiting in the queue on the workstation and you connect to the internet after the appointment time, then the SMS will not be sent if the ‘Do not send after’ option was set to expire the message before Friday morning.

    The default expiry days can be set in the Configuration section.

    Set the message expiry date and time

    Delivery Status

    It is now possible to view the delivery status of the SMS messages. The delivery status can be accessed from SMS History.

    Delivery Status option

    The Delivery Status will only be available on messages sent using SMSClient 2.0.0 or above.

    Click on the Delivery Status button to see the status of the message.

    Delivery Status Window

    The status of the messages will be:

    • SUBMITTED – The SMS was sent to the recipient, but we have not received confirmation of the delivery
    • DELIVRD – The recipient’s provider confirmed the message delivery to the phone
    • numto invalid – The number is not a valid cellular number, or the number is not valid for the area. Messages can only be sent to numbers in the country of origen.
    • UNDELIV – The message was not delivered

    Note that messages past the ‘Do not send after’ date will not appear on the Delivery Status report as the delivery was canceled before sending

    Customer Options

    An additional field , ‘Salutation’, was added to the customers. This field is available as a merge field when sending messages or when creating templates. The purpose of the Salutation field is to allow a more personalized message.

    Consider the example where a message is sent to a couple of customers: ABC (Pty) Ltd, DEF Limited and Jennifer Doe. It will be difficult to personalize the messages to the first two, and it may also be a problem with Jennifer Doe if she is commonly known as Jenny. The Salutation field for the two companies may contain the name of the contact person, and for Jennifer Doe it will contain Jenny.

    Customer Salutation
    ABC (Pty) Ltd Fred
    DEF Limited Mary
    Jennifer Doe Jenny

    The messages can now be personalized by using the Salutation field.

    Keep in mind that the use of the Salutation field is an all-or-nothing choice. If you want to use it, then all customers will require an entry in the ‘Salutation’ field even if the name and the salutation is the same. If this is not done, then the merge will create blank entry for each customer with a blank Salutation.

    Version 3.0.1

    Multiple users sharing the same database

    Mutiple users can now access the same SMS database (see http://www.caw.co.za/?p=102)
    To ensure that replies to SMS messages are routed to the correct sender there are 2 configurations required.

    Set the default reply settings

    DefaultReply

    Set the users reply settings
    CustomReply

    Additional send options

    Three additional options were added:

      Print confirmation – This option will print a report of the SMS message for your own records
      Send only one message to a number – Select this option to ensure that duplicate cell numbers are ignored
      Do not send before/Do not send after – Use this option to limit the time during which the SMS may be delivered. Outside the selected range the SMS will not be sent.

    AdhocSend3Ad-Hoc Messages
    BulkSend3Bulk Messages

    Importing Pastel Partner customer contacts into SMS Client

    The ability to import Pastel customer details is available from SMS Client version 1.1.0 and later.

    Export the Pastel customer records

    Open the Pastel software.

    1. Click the File menu, then Import / Export.
    2. Under Choose a Function to Perform select Export Customer Accounts.
    3. Under Export File Name enter
      1. C:\cust.txt if you are using Windows XP, or
      2. C:\Users\cust.txt if you are using Windows Vista
    4. Click on Process to export the records.
    5. Click on Close to close the export window.

    Import the Pastel customer records

    Open the SMS Client software

    1. Click the File menu, then Import, then Pastel Customers.
    2.  In the Filename box, enter
      1. C:\cust.txt if you are using Windows XP, or
      2. C:\Users\cust.txt if you are using Windows Vista
    3. Place a check in the box Replace existing customer details with Pastel details if you want to overwrite the existing records in SMS Client with the Pastel customer details.
    4. Click Ok to import the records.

    Cannot connect to the database after installing SMS Client

    The SMS Client software uses a Microsoft SQL Compact Edition database to store customer and SMS history data. If the Microsoft SQL Server Compact Edition Runtime is not installed the SMS Client software cannot access the database.

    Resolution
    Check that the correction version of Microsoft SQL Server Compact Edition Runtime is installed.

      SMSClient 2x requires Microsoft SQL Server Compact Edition Runtime 3.5 SP1
      SMSClient 3x requires Microsoft SQL Server Compact Edition Runtime 3.5 SP2

    The versions of Microsoft SQL Server Compact Edition Runtime 3.5 cannot be mixed. Use the same version for all installations of SMSClient.

    Download the Microsoft SQL Server Compact Edition Runtime from here and install the package.
    The SMS Client software should now be able to connect to the database.

    If you are using Windows Vista/Windows 7/Windows 8/Windows 8.1
    Windows UAC (user access control) prevents software from updating configuration settings if the user is not running the software under elevated privilege. The first time after installing or upgrading SMSClient you may receive a message that SMSClient could not connect to the database.

    Resolution
    Right click on the SMSClient icon and select ‘Run as administrator’ from the popup menu (see below). This will allow SMSClient to update its configuration settings. You should only be required to do this once. Under normal conditions the elevated security is not required.

    faq-0001

    .

    SMS Client Download

    New installations

    All charges for SMS usage will be payable by debit order. Download the debit order mandate and email the completed form to accounts@caw.co.za.

    Once debit order mandate is received you will receive an email with the required registration details that will enable you to start sending SMS messages.

    Installation Requirements
    Monitor 1024×768 resolution or better
    Software Windows 7
    Windows 8/8.1
    Windows 10

    Prerequisites

    SMS Client requires that the Microsoft .Net Framework 4.6 or later is installed on the workstation.

    Installation Source for Microsoft .Net Framework 4.6
    Microsoft .NET Framework 4.6 (Web Installer) Download

    SMS Client Installation

    Download and install the following files in the order listed below.

    Installation Files
    Microsoft SQL Server Compact Edition Runtime* Download
    SMS Client Download

    * Running the downloaded file will extract 2 installation files. On a 32 bit system you need to install the 32 bit installation. On a 64 bit systems (x64) you need to install both installations.

    Upgrading the SMS Client Installation

    SMS Client will automatically check for upgrades during normal operation.

    To force an upgrade click the ‘Check for Updates’ option in the Help menu in the SMS Client application.