How to export Shapefile to GeoJSON with WGS 84 Pseudo-Mercator in QGIS

GeoJSON is a popular file format to store the coordinates and properties of a map.

With QGIS you can create GeoJSON files from Shapefiles (in this tutorial QGIS 3.8 is used).

First add your Shapefile layer to the project in main menu => Layer => Add layer => Add vector layer.  Make sure to specify the Coordinate Reference System (CRS) of the Shapefile while adding the shape.

Now you can export the shapefile to GeoJSON in the menu (right click on the layer and choose Export => Save Features As…)export shapefile to geojsonIn the next screen make sure to choose the right CRS: EPSG:4326 – WGS 84. This CRS works also if you want to project your map in EPSG:3857 – WGS 84  / Pseudo-mercator.

export shapefile to geojson

Now you have a GeoJSON file to use in Google Maps or OpenStreetMap.

Check this question on Stackexchange to read more about the difference between EPSG 3857 and 4326 for GoogleMaps, OpenStreetMap and Leaflet.



How to turn off ESMTP BDAT on Windows Server 2012

Although SMTP on Windows Server 2012 is deprecated, it still works fine, but support is not great. We had some complaints that e-mails where not delivered in some occasions. Looking in the SMTP log files we found it used a different protocol: BDAT:

SMTPSVC1 – 25 BDAT – 17830+LAST 0 0 4 0 610 SMTP

BDAT is part of ESMTP and is involved in sending binary data. You can check on your server if this option is turned on by using telnet: ‘telnet localhost 25’ and than typing ‘ehlo’. If you see BINARYMIME and CHUNKING in the list it’s turned on.

To turn ESMTP off you have to install the IIS Metabase Explorer. This is part of the IIS6 Resource Kit. NOTE: you only need the IIS Metabases Explorer to change some parameters.

Open the Metabase Explorer and go to: LM\SmtpSvc\1, there you see the SmtpInboundCommandSupportOptions default value is set to: 7697601. By using this table you can calculate the new value by subtracting 2097152 (BINARYMIME) and 1048576 (CHUNKING) from 797601-2097152-1048576 = 4551873

You can see CHUNKING and BINARYMIME is not listed any longer:


Last thing is to change the value of SmtpOutboundCommandSupportOptions in LM\SmtpSvc from 7 to 5 to disable the BDAT command.

You can read more on this page.



IIS 8.5 status error 500 and sc-substatus 19

I’m running a website on IIS8.5, but it gives me only a blank page and the following error in the IIS logs: status error 500 and sc-substatus 19

There is not much documentation on this error, the Microsoft website has a list with errors, with only the description: “Configuration data is invalid”. There is more detailed information here, but I didn’t get any Hresult codes.

After searching for clues, I finally found the solution: in IIS Manager, under the Server nameFeature delegation the IP Address and Domain Restrictions was set to readonly. This must be set to read/write in order to be able to get it working in the web.config. The same holds for the Handler Mappings in the web.config.


Microsoft Windows .NET Framework 4.5.2 install errors

There will be some new posts about some typical Microsoft Windows situations. Where you think the solution should be simple, but it turns out it’s almost impossible.

Installing .NET Framework 4.5.2 on Windows 7

This should be simple, the latest Framework will show up on Windows Update for installation, but this gives an error:


Microsoft offers some solutions for this here. Luckily none of them works.
If you try to install .NET Framework with the offline installer you get a strange error:

Returning IDOK. INSTALLMESSAGE_ERROR [Overlapped I/O operation is in progress. ]

After trying so many things I wanted to give up. Than I found a small message on the Microsoft website from a guy named: RURajesh Upadhayay:

The fix of this issue is to rename c:\program data\microsoft\crypto\RSA\S-1-5-18 and try re-installation of .net again.

This was the solution found after many hours waisted…

Windows Server 2012 SMTP

On Windows Server 2012 the SMTP Server is deprecated, but you can still install it using the Add Roles and Features Wizard in the Server Manager.

Lately we received this error:

System.Net.Mail.SmtpException: Exceeded storage allocation. The server response was: 4.3.1 Session size exceeds fixed maximum session size
   at System.Net.Mail.DataStopCommand.CheckResponse(SmtpStatusCode statusCode, String serverResponse)
   at System.Net.Mail.DataStopCommand.Send(SmtpConnection conn)
   at System.Net.Mail.SmtpConnection.OnClose(Object sender, EventArgs args)
   at System.Net.ClosableStream.Close()
   at System.Net.Mail.MailWriter.Close()
   at System.Net.Mail.SmtpClient.Send(MailMessage message)

It turned out the attachment size was to big for the SMTP Server. You can change these settings the same way as in Windows Server 2012. Use the Windows Server 2012 Search charm to find the IIS 6.0 Manager. On the tab “messages” you can change the Limit message size.

No Bootable Device

Lately my PC (Windows 8.1) randomly ran into a problem and needed to restart. After the restart I get the message:

No Bootable Device
Strike the F1 key to retry boot, F2 to run the setup utility

F1 doesn’t help, but turning the PC off and on again does help and the PC starts again. I get this problem ones in a while.

One of the possible solutions to this problem is to search for corrupt files with SFC:

  1. Open Command Prompt (Admin)
  2. Run: sfc /scannow
  3. restart PC

SFC Scannow

After the restart I still had some corrupt files. You can filter the log (C:\Windows\Logs\CBS\cbs.log) with this CMD command:

  1. findstr /c:”[SR]” %windir%\Logs\CBS\CBS.log >”%userprofile%\

Than I found corrupt files like these:

Cannot repair member file [l:24{12}]”sppc.dll.mui” of Microsoft-Windows-Security-SPP-Client.Resources, Version = 6.3.9600.16384, pA = PROCESSOR_ARCHITECTURE_INTEL (0), Culture = [l:10{5}]”en-US”, VersionScope = 1 nonSxS, PublicKeyToken = {l:8 b:31bf3856ad364e35}, Type neutral, TypeName neutral, PublicKey neutral in the store, hash mismatch

Because these files where not altered after the Windows install, it turned out I had to repair my Windows image file where the sfc scan is checked upon, this can be done with the CMD command:

  1. Dism /Online /Cleanup-Image /CheckHealth
  2. Dism /Online /Cleanup-Image /RestoreHealth

After the image repair the system scan (sfc /scannow) had a verification 100% complete with no corrupt files.

MySQL For Excel

MySQL For Excel is very useful to quickly update or insert Excel sheets to the MySQL database.  You can install the application with the MySQL Installer. I’m using MySQL For Excel 1.3.2 in Excel 2010.

To insert Excel tables to MySQL:

  1. Open Excel > go to Data Tab > go to MySQL for Excel:
  2. MySQL For ExcelOpen Local instance MySQL
  3. Open your Schema and table you want to edit
  4. Use Edit MySQL Data and click on OK when the preview is shown.
  5. Now to insert a lot of rows you need to exit the edit mode. Otherwise you can only edit the data and not add rows (only one by one), so to Exit Edit mode right click on the gray screen like so:MySQL For Excel
  6. Now paste the data into the sheet and select all the data (Ctrl+A) and select Append Excel Data to Table
    MySQL For Excel
  7. Make sure your column names match and click on Append. Check your MySQL table in Query Bench to make sure everything is there.



WMI Provider Host spikes CPU usage

The last couple of weeks my computer (running Windows 8.1) was working so hard steam came out of the exhaust. In the Task Manager I found WMI Provider Host was using about 25% of the CPU on my system.

On StackExchange the same question is answered. To find which services depend on WMI Provider Host: open Computer Management > Services > Windows Management Instrumentation and go to tab Dependencies.

Windows Management Instrumentation

Dell Data Vault causes problems

I’ve performed a Windows Clean Boot to find the service which was causing this. The spike takes place a couple of minutes after a reboot. In the end it turned out the Dell Data Vault / Dell Data Vault Wizard was the cause of this.

Afterwards I found Dell was aware of problems with these services, but running the Dell PC Checkup didn’t give any results…

Update (2015-07-30):
I just did a reinstall of Dell SupportAssist and this uninstalled the Dell Data Vault / Wizard programs. I couldn’t figure out what these programs are doing anyway. Dell Support said they collect data from .dll files, but not why this done.