2014 – WordPress, WP-CLI, Database Migration, Data import

For a new version of the website (a dutch new site) I changed the import tool for, it required an addition to allow importing attachments and being able to deal with multisites. I could also add some more performance improvements to increase the import speed. In total 250,000 news articles (most with images) were imported to the main site.


2014 – WordPress, WP-CLI, Database Migration, Data import

For I created multiple import modules to import company reviews and companies into a WordPress database. As there was a lot of data this required a creative sollution as using regular WordPress functions to import the data would be much too slow. I created a WP-CLI import tool which used PDO without autocommit to insert large amounts of data into the WordPress database. There were multiple data sources such as an API, a database dump and CSV files, all of the source data is converted to a basic format and imported through the same module.


2014 – WordPress, GravityForms, Google Charts

This WordPress plugin, for the dutch innovation institute TNO, allows comparing products based on configurable criteria. A questionairre is configured using a custom post type and would generate a GravityForms form once configured. The form would only be accessible through a unique link send to participants by email. With the filled in questionairres a report and many charts are generated based on the Analytical Hierarchy Process (AHP). The initiators can then download the report and charts for further use and processing.

BIM BCF Server

2014 – WordPress, API, JSON, BCF

A WordPress plugin which adds a number of shortcodes to WordPress to allow management of BIM BCF issues, users can upload their issues and link them to a BIM server. The BCF API allows users to extract their issues and add new issues to their account. Users have access to any issues belonging to projects they have access to through a BIM server.

Crypto Currency Chart

2013 – YUI3, Charts, PHP

A website which shows the price history of crypto-currencies in bitcoin, dollars, euros or GBPs. The chart can be configured to show linear or logarithmic scaling and more than 100 crypto-currencies can be compared. It also shows the last stored values of these currencies and allows users to calculate the total value of any amount of these currencies in USD, Euro or GBP.

BIM Quickscan

2013 – WordPress, GravityForms, JavaScript

A WordPress plugin which extends the GravityForms plugin to allow creating a custom form to determine the level of Building Information Model (=BIM) capability for a company. It can show charts per company type and for self filled in forms or forms filled in by a professional.

News site data import/export and migration

2013 – WordPress, XML, Database migration

A plugin which handles the extraction of news articles from an old database (about 1GB in data) and could import from news feeds. Imported news could be automatically published or during business hours when editors are available news articles are not published but stored and a notification mail tells the editors of the new message so they can adjust it and decide to publish it.

GravityForms Google Docs and iDeal

2013 – WordPress, Gravity Forms, iDEAL for Gravity Forms

Expanding on the plugin which could connect Gravity Forms with Google Docs Spreadsheet it can now also send Gravity Forms with iDeal payment. These forms are sent after payment confirmation has been received (or another payment status) instead of directly after users submit the form, this way the right status can be set for the payment in the form as well.

De goedkoper site

2013 – WordPress, Google Maps

A simple WordPress network theme to display customized product related sites and a site to show an overview of all the product sites. Product sites can contain printable vouchers and Google maps with locations where to redeem these or make use of the offers on the site.

WordPress plugin for event management

2012 – WordPress plugin, PDF, Excel, GravityForms

A plugin which extends GravityForms by adding a field for selecting a company, location and creating a special WordPress post with every entry serving as an event. After each month bills can be generated based on the entered events for each company, these are available for download as PDF files. Statistics about the events and event lookups can be accessed at any time and downloaded in an Excel file.