Incoming SMS is Not Lost Even When Database Connection or Network Connection is Lost

TEST OBJECTIVE: Is incoming SMS / message lost when MySQL database connection is lost while SMS Engine — Enterprise Edition version 7.x is running?

 

TESTING METHODOLOGY TEST RESULT REMARK
  1. Start WAMP, start SMS Engine — Enterprise Edition version 7.1. Make sure the modem can be initialized to show the connection with database.
  2. Stop all MySQL DB service only. Note the time.
  3. Send 1 SMS from mobile phone to 011-56368598. Note the time.
  4. After 5 minutes (from the time of sending 1 SMS in step 3) start MySQL DB service only.
  5. Verify that the modem is still initialized.
  6. Check in the “inbox” table for the incoming SMS.
  1. Log File: 2021_5_20.log
    Modem 1 initialized at 12:58:59pm
  2. MySQL DB service stopped at 13:14pm
  3. SMS sent to 011-56368598 at 13:19pm
  4. MySQL DB service started at 13:25pm
  5. Control Panel of SMS Engine — Enterprise Edition shows Modem ID 1 is still in “initialized” (green colour) state
  6. SMS inserted into “inbox” table at 13:27:13pm
Incoming SMS is NOT LOST Even though the database connection is lost.
  1. Start WAMP, start SMS Engine — Enterprise Edition version 7.1. Make sure the modem can be initialized to show the connection with database.
  2. Unplug network cable from Dell-E6410 (laptop).  Note the time.
  3. Send 1 SMS from mobile phone to 011-56368598. Note the time.
  4. After 5 minutes, reconnect network cable. Note the time. Verify that the modem is initialized.
  5. Check in the “inbox” table for the incoming SMS.
  1. Log File: 2021_5_21.log
    Modem 1 initialized at 10:29:48am
  2. Network cable unplugged at 10:33:37am and modem ID 1 failed to connect to GSM network (not initialized)
  3. SMS sent at 10:36am
  4. Network cable reconnect at 10:43:10am and modem ID 1 was initialized
  5. SMS inserted into “inbox” table at 10:43:20am
Incoming SMS is NOT LOST even though network connection is lost.

How to Reuse Existing VB.Net Form by “Add Existing Item”

  1. Copy VB.net form with the same filename  having these file extensions — “.vb”, “.resx” and “Designer.vb” into the project folder.
  2. Open the project, in “Solution Explorer”, right-click on project  “Add -> Existing Item…
  3. Select the VB.net form file with “.vb” extension.
  4. The same file added should appear in “Solution Explorer”.

How to Rename “List” in PHPRunner

There are 3 places that need to modify:

  1. Custom views table
  2. Top menu
  3. Landing page menu (no need to modify if this is removed)

 

BEFORE AFTER MODIFICATION IN PHPRunner
List Of Sales Contracts Not Reserved, Loaded Or Delivered Rename to
List Of Sales Contracts NOT Delivered
  1. Go to “Tables” tab -> right-click on select “list_of_sales_contracts_not_reserved_loaded_or_delivered” under Custom views -> select “Rename view”.
  2. In “Rename View”, rename “list_of_sales_contracts_not_reserved_loaded_or_delivered” to “list_of_sales_contracts_not_delivered”.
  3. In the same “Tables” tab -> click on “Menu editor” button.
  4. In “Menu Editor” -> select “List_Of_Sales_Contracts_Not_Reserved_Loaded_Or_Delivered” under the “Menu Settings” -> click “Edit item” button.
  5. In “Menu Item Editor”, rename “List Of Sales Contracts Not Reserved Loaded Or Delivered” to “List Of Sales Contracts Not Reserved Loaded Or Delivered”
  6. Go to “Designer” tab -> select “Common pages” in the Tables list -> select “List Of Sales Contracts Not Reserved Loaded Or Delivered” -> in “linkComments” and “linkText”, rename the text to “List Of Sales Contracts Not Delivered”.

How to Edit Landing Page (HTML File) Without Using PHPRunner

Applies to: PHPRunner version 10.4

Problem: the landing page — https://sot.sweetco.com.my/v.4.0/menu.php shows descriptions:-

 

If I want to edit the description, e.g. “Sot description”  change to “This form is to be filled by sales department” without using PHPRunner, how should I do it?

 

Solution: edit the file “.global_menu.htm”:

  1. Open “<Parent folder>/output/templates/.global_menu.htm” in Notepad++.
  2. Find the menu title, e.g: “Sales Order Tracking”. Go to “bs-welcome-content” <div> under the menu title <div>, change the text.
  3. Save the file and upload it to web server in the same path as where it is located in the local.
  4. Then reload the page.