jonaskoperdraat / convert-ingcsv-to-gnucash

Application to convert csv export from ING to a format GnuCash can import

convert-ingcsv-to-gnucash

Application to convert csv export from ING to a format GnuCash can import. The application will parse a ING CSV export file and output a new CSV file containing 8 columns matching the column options in the gnucash CSV import dialog. The columns "Nr" and "Saldo" will be empty as thsi information is not available in the ING CSV export.

build

mvn clean install assembly:single

Usage

java -jar <jarfile> <path-to-csv-file>

Will parse the given CVS file and output a new CSV file in the same location as the original file and with the same filename appended with "_converted".

convert-ingcsv-to-gnucash's Issues

Output single runnable jar

Problem

Currently the build command mvn clean install assembly:single outputs two jars, one without the dependencies and one including the dependencies with the name `convert-ingcsv-to-gnucash--jar-with-dependencies.jar.

Desired situation

The goal is to output a single jar that contains the dependencies and that has the standard name convert-ingcsv-to-gnucash-<version>.jar

Empty columns

Problem

The output file contains the columns "Nr" and "Saldo" that don't contain data.

Solution

This information is not available in the ING CSV format. These columns can therefore be left out.

Large columns first make determining the type of the column in GnuCash cumbersome

Goal

Smaller columns first on a line.

String delimiter not escaped in ing's csv format.

Problem

The CSV format outputted by the ING online banking export tool can have " characters within a field whils using the same " character as a delimiter for each field.

For example:

"20160203","Nieskens "The Readsh","NL29INGB*******","","BA","Af","33,96","Betaalautomaat","Pasvolgnr:003 02-02-2016 14:33 Transactie:****** Term:******"

The second field here, contains an extra ", which leads to problems parsing the CSV file, which results in an improperly converted file.

Solution

Scan the input file for these extra " characters and replace them with single quotes: '.

The regular expression for finding these fiels is ,\"[^"]*"[^"]*\",.