Author Archives: Taufiq

How to Rename VB.Net Project

  1. Open the project’s root folder.
  2. In Windows Explorer, right-click on project’s Main solution (.sln) → “Rename”.
  3. Open the project in Visual Basic. In “Solution Explorer”, right-click on project → “Rename”.
  4. In “Solution Explorer”, right-click on project → “Properties” → goto “Application” tab, rename “Assembly name” and “Default namespace” to match the project’s name.
  5. If you wish to also rename the namespace, open one of your class files. Right click the namespace →”Rename…. ” This should search and replace all references to your namespace throughout the project.
  6. Close the project. Delete the old “Solution User Option” (.suo).
  7. In Windows Explorer, right-click on project’s subfolder → “Rename”.
  8. Edit the .sln file and change the path of “.vbproj”.

Source: https://stackoverflow.com/questions/211241/how-can-i-rename-a-project-folder-from-within-visual-studio

Total Records Updated in the Tables of E-Mail Subscribers v. 4.4.8

Upon executing this SQL Statement:-

UPDATE `wp_ig_contacts`
INNER JOIN `wp_ig_lists_contacts` ON `wp_ig_contacts`.`id` = `wp_ig_lists_contacts`.`contact_id`
SET `wp_ig_contacts`.`updated_at` = "2021-07-06", `wp_ig_lists_contacts`.`status` = "unsubscribed"
WHERE `wp_ig_contacts`.`email` IN (SELECT `email` FROM `wp_ig_contacts_returned`)

 

If 1 email address belong to 1 group then 2 records will be updated:-

  • 1 record in table “wp_ig_contacts” will be updated with `updated_at` = "2021-07-06"
  • 1 record in table “wp_ig_lists_contacts” will be updated with `status` = "unsubscribed"

If 1 email address belong to 2 groups then 3 records will be updated:-

  • 1 record in table “wp_ig_contacts” will be updated with `updated_at` = "2021-07-06"
  • 2 records in table “wp_ig_lists_contacts” will be updated with `status` = "unsubscribed"

How to Solve “BadImageFormatException”

Applies to: SMS API v. 9.2 in Visual Studio Community 2019 and Windows Server 2019 64-bit

Problem: when SMS API v9.2 sample program in run in debug mode, Visual Studio Community 2019 always give this error :-

Inner Exception 1:

BadImageFormatException: Could not load file or assembly ‘Interop.MobitekSMSAPI9, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’ or one of its dependencies.

This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.

Solution: change the “Target Framework” of the project to “.NET Framework 4” with these steps:-

  1. Migrate the project “SMS API v. 9.2” to open in Visual Studio 2019.
  2. Open the project. Go to the project “Properties”. In “Application” tab, change the “Target framework” to “.NET Framework 4”.
  3. You will get below warning after changing the “Target framework”. Just click “Yes”.
  4. Close and reopen the project.
  5. Click “Start” button to start debugging the project. Please allow some times for the project to be built.
  6. After the project has completely built, try to click all menus and buttons to see if the problem occur again.

How to Install USB Driver of MOBITEK Q25 and Find the COM Port Number

Step 1: DO NOT connect USB cable or connect modem to PC/server.

Step 2: Install the USB driver first by extracting the “.zip” file after downloaded and run the “setup.exe”. USB driver can be downloaded from here – Download USB Driver

Step 3: Choose the installation folder or path, then click on ‘Next’.

Step 3: Click on ‘next’. Wait until the installation complete.

 

Step 4: Click on ‘Install’.

Step 7: Make sure to restart the machine or computer in order to use the installed driver.

Step 8: After computer is restarted, connect the modem to the computer. In device manager, the connected modem is listed as ‘Quectel USB AT Port (UMTS)’. In this example, the modem is connected to COM port number 8.

How to Use MOBITEK E-Mail Address Extractor to Extract E-Mail Addresses from Inbox

 

MOBITEK® E-mail Address Extractor is an useful digital marketing tool to extract the e-mail addresses from the body or the header of an e-mail. E-mail address extracted and then be imported into any e-mail broadcasting application or can be used to remove undeliverable e-mail address.

Note: free version does not support extracting e-mail address from Gmail and Yahoo Mail.

User’s Guide

  1. Run “MOBITEK E-mail Address Extractor.exe”.
  2. Go to “Settings” -> “POP3 Settings”.
  3. In “Settings”, enter “Server Name”, “Username” and “Password” for POP3 e-mail. In “Security Settings” area, select the “Connection Security”, choose whether to use the default “None” or “SSL/TLS”. The “Port” will automatically change based on the selection.
  4. To extract e-mail address from the body of e-mail, select “Extract E-mail Address from Body of E-mail”.
  5. To extract e-mail address from the header of e-mail, select “Extract E-mail Address from Header”.
  6. To extract e-mail address from only “Cc”, “To” and “From” section, select “Extract E-mail Address from ‘to’, ‘cc’ and ‘from’.
  7. If you entered the wrong login information, you will a warning message, please re-check the settings (user name, password, etc.).
  8. To cancel the extraction process, click the “Cancel” button.
  9. After the extraction completed, a summary of the extraction process will be displayed.
  10. All extracted e-mails will be shown in the “List of Extracted E-mails” tab. The total number of e-mails extracted will be shown in “The total e-mail(s) extracted”.  Copy e-mail addresses and paste a spreadsheet (csv) file that can be imported into any e-mail broadcast application.
  11. Any duplicated e-mail extracted will be shown and added into “List of Duplicate E-mails” and the total number of duplicates shown in “Total duplicate e-mail(s)”.

 

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.

List of Functions Supported by MOBITEK EC20 4G Router & IoT Gateway

MOBITEK EC20 4G Router and IoT Gateway

 

Home -> Basic Info

 

System Info -> Clients Info

 

System Info -> Statistics

 

System Info -> 4G/WAN Status

 

Wireless Setting -> 2.4G Basic Setting

 

Wireless Setting -> 2.4G Repeater Setting

 

Network Setting -> Work Mode Setting

 

Network Setting -> WAN Setting

 

Network Setting -> LAN Setting

 

Network Setting -> DHCP Setting

 

Network Setting -> 4G Setting

 

Network Setting -> VPN Setting -> Open VPN Setting

 

Network Setting -> VPN Setting -> PPTP Setting

 

Network Setting -> VPN Setting -> L2TP Setting

 

Network Setting -> Ping Reboot

 

System Admin -> Web Access Control -> Web Password Setting

 

System Admin -> Web Access Control -> Wan Access Control

 

System Admin -> Backup/Restore -> Backup Configs

 

System Admin -> Backup/Restore -> Restore Factory

 

System Admin -> Backup/Restore -> Restore Backup Configs

 

System Admin -> Firmware Upgrade -> Local Upgrade

 

System Admin -> Firmware Upgrade -> Online Upgrade

 

System Admin -> Time Setting -> System Time

 

System Admin -> Time Setting -> Time Zone

 

System Admin -> Reboot -> Reboot Now

 

System Admin -> Reboot -> Schedule Reboot

 

System Admin -> System Log -> Kernel Log

 

 

System Admin -> System Log -> App Log

 

Advance Setting -> Intranet Passthrough

Advance Setting -> Oray Passthrough

 

Advance Setting -> DTU Setting -> Ser2net Setting1

 

Advance Setting -> DTU Setting -> Ser2net Setting2

 

Advance Setting -> DTU Setting -> Ser2net Setting3

 

Advance Setting -> DTU Setting -> Ser2net Setting4

 

Advance Setting -> PLC Setting

 

Advance Setting -> Remote Help

 

Advance Setting -> DMZ Setting

 

Advance Setting -> Port Mapping

 

 

Advance Setting -> Static Route

 

Advance Setting -> MQTT

 

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”.