my blog. for you.

Let’s talk digital.

I’m an independent IT consultant and entrepreneur in the Internet and software business. I’m interested in design, enterprise applications, web apps and SaaS products. I design and develop business solutions and applications. I help companies in terms of software quality and knowledge transfer, e.g. with Angular and Spring Boot.

Exporting table data in web applications as CSV or Excel files

In business applications being able to export data to Microsoft Excel is a very common requirement. In most business environments Excel is the go-to tool for business analytics and quick-and-easy data processing. Hence, being able to communicate with Excel is an essential feature for most kinds of business software. The usual approach for meeting that requirement is generating a CSV file on the server. However, while simple this approach can come with a few downsides: While CSV is a useful, accessible plain text ... Read more

Follow-up on “Accounting in 2016”

Two months ago, I wrote an article on how accounting in 2016 still is a manual and tedious process. What made me write this article in the first place was the problem that I couldn't automatically get the bank account statements for my business account into my accounting software because my bank's online banking service and my accounting software have incompatible import / export file formats and neither exposes a public API for facilitating communication between and automation of accounting software ... Read more

Accounting in 2016 – Still a manual and tedious process

The past few weeks I've been struggling with automating my accounting, invoicing and banking processes to the point I don't really have to think about it anymore. Currently, a lot of my accounting-related processes are still way too manual for my liking. Being both a virtuous, lazy programmer and an entrepreneur I'd like to automate every process that can be automated at reasonable cost, especially if that process doesn't generate any revenue. Now, as far as invoicing and small business accounting is ... Read more