[GNC] importing (QIF/OFX)

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

[GNC] importing (QIF/OFX)

Jeff Abrahamson
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
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: [GNC] importing (QIF/OFX)

David Carlson-4
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 <[hidden email]> 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
> [hidden email]
> 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.
_______________________________________________
gnucash-user mailing list
[hidden email]
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.