Import GnuCash data into MoneyDance

Sun, 13 Jun 2010 00:00:00 +0000

GnuCash served me well while I was running Ubuntu as my primary desktop but since moving to a Mac Pro I've been disappointed in the performance and non-native nature of the GnuCash Mac port. I decided to migrate to MoneyDance and was quickly dismayed to discover GnuCash's poor support for standards based exporting.This GnuCash wiki-entry describes a few convoluted approaches to data export but the items it references are hopelessly outdated and generally do not function for the latest stable release - reason enough to ditch GnuCash.MoneyDance hadn't solved the problem on their end either but their wiki does reference a Perl script that converts the deprecated GnuCash Postgre storage format into a MoneyDance XML file. Since I knew that the development release of GnuCash supports a SQLite storage format I decided to see if I could update Sid Reed's aforementioned script for this new SQLite container.I'm no Perl Monger, but I do know regular expressions. My updated script worked well for me and seamlessly converted several years of GnuCash data. Please read the pre-requisites section in the header of this GnuCash to MoneyDance Migration Script before attempting to run it. In addition to the linked zip archive, this script is also available on github. Enjoy!

Moneydance on technocracy

Import GnuCash data into MoneyDance