Category Archives: Support

How Does PHPRunner Label the Column Name in UI of PHP (List Page)

PHPRunner use the column name of table as the column name of list page.

PHPRunner will automatically convert “_” to space, convert the list letter to big capital

COLUMN NAME IN TABLE	CONVERTED BY PHPRUNNER INTO	REMARK
modem_id	Modem Id
mobile_number	Mobile Number

Sales_Contract	Sales Contract

How to Remove Space using SQL Statement

Problem: there are leading space and trailing space in the records.

leading space
trailing space

Solution: to remove leading space, e.g. ” EKONOR-25M”, use

UPDATE `Stock_Card-20220218` SET `Item_ID`=TRIM(`Item_ID`) WHERE `Item_ID` LIKE '% ';

BEFORE	AFTER

Solution: to remove trailing space, e.g. “EKONOR-25M “, SQL statement (“Trim”, “Rtrim”, “Replace”) CANNOT be used. The only way is to delete it manually.

How To Insert SIM Card into the Modem

Please use your fingernail to push the SIM card in until it is fully inserted and to eject the SIM card out.

How to Set EC20 to Reboot When Internet Connection is Lost

MOBITEK EC20 4G Router and IoT Gateway

By default, EC20 will automatically try to re-connect to 4G network if internet connection is lost. To perform an automatic reboot instead, follow these steps:-

Continue reading →

MOBITEK SMS API version 9.3 is Released

MOBITEK® SMS API

Release Date: 09-Dec-2021
Two “Read” methods added:
- SMS.ReadSMS() – read text format SMS
- SMS.ReadSMSText() – read PDU format SMS
Supports MOBITEK^® Q25 4G Modem

More Information

How to Upgrade or Downgrade the Firmware of MOBITEK Q25 4G Modem

Steps

Run “QFlash v5.1”.
Select the COM port number of “Quectel USB DM Port” (must use the USB port because serial port does not have “Quectel USB DM Port”).
Set Baud Rate to 460800.
Load Firmware Files.
Upgrade firmware.
Unplug the USB cable and plug it back. Use “AT+CMGR” or “ATI” to check the firmware version.

Download QFlash version 5.1

QFlash version 5.1 User’s Guide

Taking too long?

Reload document

Open in new tab

How to Schedule Win 10 PC to Sleep and Wake-Up

Conclusion

“psshutdown.exe” and “wosb.exe” are working — can sleep, wake up and stay awake. For each setting refer to:-
- psshutdown.exe Setting in Task Scheduler
- wosb.exe Setting
“Put PC to Sleep” (rundll32.exe powrprof.dll,SetSuspendState 0,1,0) and “wosb.exe” are NOT working — it can sleep but cannot wake-up.
“psshutdown.exe” and “Wake-Up from Sleep” (Windows Task Scheduler) are NOT working — it can sleep, wake-up but after 5 minutes will return to sleep, it cannot stay awake.
Method mentioned in https://www.howtogeek.com/204742/how-to-make-any-computer-boot-up-or-shut-down-on-a-schedule/ (rundll32.exe powrprof.dll,SetSuspendState 0,1,0) is not working in Windows 10 PC to sleep. Once it is slept, it cannot be woke-up.
Method mentioned in https://www.howtogeek.com/119028/how-to-make-your-pc-wake-from-sleep-automatically/ is not able to wake-up Windows 10 PC.

psshutdown.exe Setting in Task Scheduler

Download the “Sleep using psshutdown.exe” task here …

The argument is –d -t 0 -accepteula

wosb.exe Setting

Download the wosb.exe setting here ….

Place “wosb.exe” in “C:\Users\mobitek1\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup” so that the program can autorun whenever the PC is rebooted.

Test Result

DATE DID HPC-8300 SLEEP AT 10 PM using psshutdown.exe? (Y/N) DID HPC-8300 WAKE UP AT 8:30 AM using wosb.exe? (Y/N)

Example of Task Scheduler successfully put PC to sleep.

Example of wosb.exe successfully wake up PC.

9-Dec

10-Dec

13-Dec

14-Dec

15-Dec

16-Dec

17-Dec

How to Filter Event Viewer and Save it as a Custom View

Create 2 custom views for “Kernel Power” and “Power-Troubleshooter”.

Select “Filter Current Log …”.
Select “Kernel-Power”
Select “Save Filter to Custom View …”
Save the custom view as “Kernel-Power”
Repeat it for “Power-Troubleshooter”

Control Panel for SMS Engine — Enterprise Edition version 3.1 has been Released

List of Fixes in Version 3.1

Fix bug “Conversion from string “” to type ‘Double’ is not valid” when “Start Monitoring” is clicked;
Remove any unused subroutines, functions, variables, code comments;
Rename “ModemState.vb” to “MonitorModem.vb”;
Combine “MonitorModem.CheckModemStatusVersion2_MSSQL()” and “MonitorModem.CheckModemStatusVersion2()” into one subroutine;
Rename “RelabelModemStatusVersion2()” to “MonitorModem.UpdateStatus()”;
Rename “RestoreBackColorVersion2()” to “MonitorModem.RestoreStatus()”;
Disable “Open Configuration File” and “Reset Configuration File” button when engine is running;
Condensing “If…Else” with “For…next” inside ModemState.CheckModemStatusForVersion2()” and “ModemState.CheckModemStatusVersion2_MSSQL()” subroutines.

Download

Existing customers of MobiGATE with valid warranty period or with valid annual support programme could download version 3.17 from here …

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

More Information

Chilkat Mail ActiveX version 9.4 Does Not Support GMail and Yahoo Mail Server

CONCLUSION

Chilkat Mail ActiveX version 9.4 does not support GMail and Yahoo Mail with or without SSL connection.
Chilkat Mail ActiveX version 9.4 supports mail server of mobitek.my with or without SSL connection.