Category Archives: Support

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.

Does Shutting Down 3G Network Affect the Functionality of MOBITK Q24 and MOBITEK S80 SMS Modem (GSM Modem)

Question: Malaysia TELCO phasing out 3G soon, may we know if MOBITEK S80 (3G) and MOBITEK Q24 (2G) SMS Modem will be affected (not able to send out SMS)?

 

Answer no. 1: please refer to

3G Shut Down: Millions of Maxis & Celcom 4G customers may need 2G to make Calls

“Malaysia is among a limited countries around the world that have decided to shut down its 3G networks while maintaining 2G.“

“As a safety net, 2G network will still be maintained to ensure customers are able to make calls and SMS seamlessly, whenever 4G is inaccessible,”

 

Answer no. 2: please refer to

Digi begins shutting down its 3G network, here’s the full schedule

Digi CTO Kesavan Sivabalan said: “Our priority remains in ensuring high availability and consistency of our 4G network services, and to do so effectively, it is necessary that we retire the 3G network, freeing up crucial spectrum and resources that would now be channelled towards increasing capacity of the 4G network to support higher usage.”  Users with 3G devices can still stay connected to 2G after the 3G shutdown. While 2G is sufficient for basic voice calls and SMS, it is barely usable for internet services in this day and age.

 

Answer no. 3: please refer to

Malaysia has not fully shut down its 3G networks, over 440,000 users have not switched to 4G phones

Malaysia was supposed to shut down all 3G networks by the end of 2021 but it turns out that some 3G sites are still operational. This was revealed during the recent JENDELA update for the final quarter of 2021.

3G users can still use their existing phones after the 3G shutdown but their devices will connect to the slower 2G connection, which can be used for basic voice calls and SMS.

Therefore, as long as 2G network is maintained, MOBITEK S80 (3G) and MOBITEK Q24 (2G) SMS Modem can still send and receive SMS.

How to Solve VCOM Hang or Crash

Applies to:-

  1. MOBITEK MobiGATE SMS Gateway model SG-B series and MOBITEK Q24 STK Modem Hub; and
  2. Windows OS with VMWare installed.

 

Problem: VCOM crashes when running the “Search” function on Windows 10 Professional x64 with VM previously installed on the same machine.

 

Solution:  disabling Virtual Network Adapter created by Virtual Machine.

  1. Open Control Panel -> Network and Internet -> Network and Sharing Center, click on “Change adapter settings”.
  2. In “Network Connections”, select the VM Network Adapter, in this case the VM Network Adapter labeled with “VMNet1” and “VMNet8”, then click on “Disable this network device”.
  3. Open the VCOM and try running the “Search” function again.

Control Panel for SMS Engine — Enterprise Edition version 2.7 is Released

List of  Fixes in Version 2.7

  • Added tab no. 3 to support modem no. 17 until 24, total 3 units of MobiGATE can be configured in Control Panel;
  • Added validation procedure for each Modem ID and COM Port number in all 3 modem tabs (1 to 24) is needed so as to prevent user from entering duplicate ID and COM Port number;
  • Added a new feature — automatic populate the values for “Modem ID” and “COM Port” and increase the value by 1; the “automatic and incremental” code will only execute when user enter values for “ID” and Port” for “Modem 1”, the code will not execute if user change / edit modem 2, 3, 4 and the rest;
  • Engine will NOT start when the “config.xml” file is not loaded/read into Control Panel;
  • Revise the error messages and warning messages;
  • All message boxes contain version number, e.g. “Control Panel v. 2.6”.

 

Download

Existing customers of MobiGATE with valid warranty period or with valid annual support programme could download version 2.7 from here … (www.mobitek.my/download/MOBITEK SMS ENGINE — ENTERPRISE EDITION/Setup v.2.7.1.exe.zip)

If you wish to subscribe to annual support programme for your MobiGATE, please contact us.

 

More Information

Change Date Format to YYYY-MM-DD Before Importing into MySQL Database

Problem: when importing from csv or ods file, the date imported into MySQL Database Server is messed up, e.g. DD-MM-YYYY in csv or ods file when imported into does not show correctly as dd-mm-yy.

 

Cause: MySQL Database Server only accepts date format as YYYY-MM-DD, it will not convert DD-MM-YY to YYYY-MM-DD . Refer to https://dev.mysql.com/doc/refman/8.0/en/datetime.html

 

Solution: a quick solution is to format the date in as csv or ods file as YYYY-MM-DD before import.