Fix the "need new app to open ms-wpc" message keeps on pop-up problem in Windows 10

If you are facing a problem with Windows 10 with a pop-up message as below that keeps on prompting even though you continuously clicked on the OK button, here is the fix.

Right click on the Windows icon on the left of taskbar, and run Windows PowerShell as admin.

Copy and paste the following command to run in the Windows PowerShell admin console.

Get-AppXPackage -AllUsers | Foreach {Add-AppxPackage -DisableDevelopmentMode -Register "$($_.InstallLocation)\AppXManifest.xml"}

Hopefully after this, your problem will be fixed.

EmEditor - lightweight text editor able to open large file and also manipulate CSV

Recently, I was looking for a text editor that is capable to open and edit an SQL dump as large as 2.7 GB, and I only found EmEditor to be the workable one. Most of the well-known text editors for Windows failed to open the file. Several managed to open, but became extremely slow and easy to crash during navigation or editing.

EmEditor by Emurasoft has been around since 1997. Its user interface is still Windows 95 alike, and not that impressive at all. It seems to be powerful, with quite a lot of functions, but looking for the function will probably need some times searching in its menu items. It has most of the basic function of a modern text editor, including syntax highlighting for programming languages and scripts.

Due to its old fashion user interface, you probably won't use EmEditor for normal text editing or program coding. However, EmEditor has 2 unique features that really make a difference from other editors. These 2 superb features are:

• ability to open and edit large text file, as big as 248 GB or 2.1 billion lines!
• ability to manipulate CSV file with nice tabulation of the data into columns.

If you need a lightweight editor to open text file with millions of line, you are very likely end up with EmEditor. EmEditor is able to open such large file without consuming much memory or taking up much CPU resources.

Example of those large text files including but not limited to:

• SQL dump with data
• Log file
• Large dataset in CSV or XML

EmEditor is pretty fast in loading the large text file. If the file is really large and over a gigabit, it still needs some times to fully load the file, but not that long.

Sequential moving in between text is seamless and fast, but jumping will take a longer time. Editing character by character is also fast, but text replacement with highlighting and cut will also take a longer time.

 

EmEditor has function to split a file into multiple smaller files, and also the reverse function to combine several files into one.

This is handy in the situation whereby you need to search for a portion of the large file, and export it out for further manipulation using other tools. Another situation is to split a large chunk of SQL dump into smaller files, so that the SQL server can import by handling smaller files.

EmEditor has powerful CSV manipulation functions similar to spreadsheet such as MS Excel or LibreOffice Calc. Compared with those spreadsheet programs, EmEditor is pretty lightweight and faster to load up.

It can tabulate the CSV data into columns, insert/delete a column, perform sorting, perform filtering, convert the CSV separator, etc.

Because of these 2 unique functions, I find EmEditor a handy tools for IT person, particularly for dealing with large text files involving dataset or log file.

Cellular frequency bands allocated to Malaysia mobile network operators

The telecommunication spectrum assignment in Malaysia is handled by Malaysian Communications and Multimedia Commission (MCMC).

Mobile network operators (MNOs) need to pay multi-million ringgit to MCMC in order to get the spectrum assignment in specific frequency band, so that they can provide cellular mobile service to customers with their assigned frequency bands.

The customers' device need to be able to communicate on the same band with the cellular transmitter at the nearby telco tower of the mobile service provider in order to establish a connection for voice and data transmission.

SIRIM is the certification body who will test and certify the mobile devices sold in the local market are complying to the spectrum used in Malaysia.

Current allocated frequency bands to MNOs in Malaysia are as below. Note that the mobile operator might not make use of all of their allocated frequency bands. In fact, most of them are not using the 900MHz band for 2G GSM.

Lower frequency means longer wavelength. This will have better in-house penetration and also able to reach a longer distance, but the bandwidth is lower and connection speed is slower.

Higher frequency means shorter wavelength. This can carry more bandwidth and also provide faster connection speed, at the trade-off of poorer in-house penetration and shorter coverage distance.

LTE frequency bands are numbered according to either the FDD specification or the TDD specification. For example, FDD Band 5 used by Unifi Mobile has a low frequency of 850MHz, therefore the LTE connection speed in this band is generally slower than those in FDD Band 3 (1800MHz).

Android mobile device users can install an app called LTE Discovery by Simply Advanced to have realtime information about which LTE band the device is connected to, as well as the signal strength, cellular tower position, and many other related information.

Tourists bringing mobile phone and/or tablet to Malaysia can check the table above with their own device specification on 2G/3G/4G to ensure that their device can function well in Malaysia, either using roaming or a SIM card purchased in Malaysia from one of the MNOs or MVNOs.