[GNC] importing (QIF/OFX)

David Carlson david.carlson.417 at gmail.com
Wed Jun 27 15:29:53 EDT 2018


Jeff,

I think the best answer to your question would be whatever provides the
most direct route from your source to GnuCash.

That may also change when you migrate to release 3.2 or later of GnuCash.
That release has a much improved CSV importer and the other importers have
better transaction matching.  Before migrating carefully read the known bug
list in the release announcement to see if there is a deal breaker for your
use.

David C

On Wed, Jun 27, 2018 at 2:07 PM, Jeff Abrahamson <jeff at p27.eu> wrote:

> I wanted to import a bunch of transactions.  I had a CSV file, which
> gnucash (2.6.19) doesn't like to import.  So I wrote a quick CSV to QIF
> translator.  This worked, it recognized account names even though I
> provided only the tail, and it correctly caught duplicates.  But a
> couple quibbles: I'm wondering if they are inevitable.
>
> - The importer asks me a lot of questions. ;-)
>
> - When it finds matching transactions (because I tested importing the
> same file a second time to make sure it wouldn't do it quietly), it
> proposed matches.  (Good!)  In my case, every transaction had a unique
> transaction id (the "number" field in gnucash, the N prefix in QIF) but
> most of the transactions had one of a handful of values.  I would have
> thought that 20180515-XQUFEF-3 would be matched uniquely, but it's not.
> I'm proposed every transaction with that value.
>
> These aren't deal-killers, but it does make automation feel like a weak
> concept.  I'm wondering if I can optimise better.
>
> In passing, since I'll surely write more of these converters, would I
> have been better off converting to OFX?  QIF simply had the advantage of
> being dead simple, permitting splits, and having a wikipedia page that
> describes the format.
>
> Thanks!
>
> --
>
> Jeff Abrahamson
> +33 6 24 40 01 57
> +44 7920 594 255
>
> http://p27.eu/jeff/
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


More information about the gnucash-user mailing list