I've been using gnucash for years and it's awesome. But the reports are a bit rough. I'm planning to load the data into Mysql so I can write my reports easily.
I started using the xml but when I try to "Save as..." to Mysql, gnucash doesn't create data into the database, only tables.
Is there a way I can get the data across to Mysql or I need to start all over again?
On
Have you tried this export script ? It was written to export gnucash to mysql using perl. The script can also be found at github https://github.com/xaprb/gnucash2mysql
Albeit this question being old, I wanted to share my experience in the case someone needs a solution for it, as the answer is very easy but probably not the most natural or intuitive for everyone's perception.
Technically, gnucash supports mysql (at least on linux) natively. So to migrate, one can just use the "File -> Save as" dialog, select mysql with the proper database and credentials and then gnucash will migrate everything from the file to the mysql target. I have no experience with Mac or Windows on this topic however...
This is how it looks on my machine:
I use the sqlite3 variant regularly and encountered no problems so far.