Quickbooks format converter?

[Anatortoise House]

Sorry if this is answered somewhere already, but searching this group, github home, irc channel, and googled web overall didn't find it for me yet. 

In this podcast ( http://castroller.com/Podcasts/FlossWeekly/2140974-FLOSS%20Weekly%20150%20Ledger )

John Wiegley mentioned someone had written a tool to port quickbooks files to ledger .dat files.  I'm inheriting some quickbook formatted files and would like to use ledger, but don't want to re-invent the wheel writing a conversion script.  Can anyone point me in the right direction?

maybe I need to work on my searching abilities, as I'm finding it hard to believe I'm the first to look for this.
Much appreciated

[John Wiegley]

Anatortoise House <anato...@gmail.com> writes:

> John Wiegley mentioned someone had written a tool to port quickbooks files
> to ledger .dat files. I'm inheriting some quickbook formatted files and
> would like to use ledger, but don't want to re-invent the wheel writing a
> conversion script. Can anyone point me in the right direction?

Ledger 2 is able to read QIF files. Is that close enough to what you need?

John

[Anatortoise house]

Thanks, I will find out! I've been using the Snowleopard pre-compiled binary, ledger -v gives:

Ledger 3.0.0-20100623

I haven't seen anything about QIF importing in any of the docs I've found, but I will look harder now that I know there is something to try in an earlier version.

Am I right in assuming that once I convert QIF to ledger.dat format with Ledger 2, I can probably process the file with a later version of ledger?

If yes, is there a reason that conversion functionality isn't included with v3?

[John Wiegley]

On May 20, 2011, at 5:14 PM, Anatortoise house wrote:

> I haven't seen anything about QIF importing in any of the docs I've found, but I will look harder now that I know there is something to try in an earlier version.

QIF support will not be integrated into Ledger 3, but may be provided as an external script.

> Am I right in assuming that once I convert QIF to ledger.dat format with Ledger 2, I can probably process the file with a later version of ledger?

Correct.

> If yes, is there a reason that conversion functionality isn't included with v3?

I don't use it, so I can't maintain it anymore. It should just be a simple Python script anyway, so that anyone can hack it or fix it for their needs.

John

[Anatortoise house]

Unfortunately, it looks like Quickbooks file format is .qbw not .qif (which is quicken), and Intuit doesn't seem to have an intermediate conversion.....So I'm thinking the only way I'm going to open this data (for exporting or otherwise) is with quickbooks.

Thanks anyway, let me know if you see something I'm missing here.