Import transaction from CSV

Ricardo Biloti biloti at gmail.com
Wed Apr 16 16:18:12 EDT 2014


Thanks Victor

I found the project "Gnucash to QIF and IIF" (
http://gnucashtoqif.sourceforge.net/) which provides a tool to convert a
XML Gnucash file into QIF. With some reverse engineering, I found out how
to produce QIF files from my CSV files. I works like a charm.


On Wed, Apr 16, 2014 at 5:11 PM, R. Victor Klassen <rvklassen at gmail.com>wrote:

> It’s the account name.  And if you get it somewhat wrong - but not another
> existing name - you can train GNUCash the first time you import.
>
>
> On Apr 16, 2014, at 11:09 AM, Ricardo Biloti <biloti at gmail.com> wrote:
>
> > Thats fine to me. In a QIF file, I just need to know how to make a
> > reference to the (at least two) accounts of a transaction. Is it by its
> > name in my Gnucash book or by some sort of ID?
> >
> > By knowing that, I can produce a script to convert a CSV file to a QIF
> with
> > all sort of information that Gnucash needs. I would be glad to share such
> > script with others.
> >
> > Thanks.
> > Ricardo
> >
> >
> > On Wed, Apr 16, 2014 at 11:01 AM, Derek Atkins <warlord at mit.edu> wrote:
> >
> >> Hi,
> >>
> >> Ricardo Biloti <biloti at gmail.com> writes:
> >>
> >>> Dear co-users of Gnucash
> >>>
> >>> I'm used to import transaction from CSV files. However it is a bit
> >> tedious
> >>> to have to set the account for each transaction. I know Gnucash tries
> to
> >>> infer the proper account. However, many of them still have to be set
> >>> manually.
> >>>
> >>> My question is if there is a way to inform as an additional field in
> the
> >>> CSV file the right account for each transaction.
> >>
> >> Nope.  If you want that you should convert the file to QIF (where you
> >> can exactly specify the target account) or OFX (where you can teach
> >> GnuCash how to match).
> >>
> >>> Best regards,
> >>> R.Biloti
> >>
> >>> Please remember to CC this list on all your replies.
> >>> You can do this by using Reply-To-List or Reply-All.
> >>
> >> -derek
> >>
> >> --
> >>       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
> >>       Member, MIT Student Information Processing Board  (SIPB)
> >>       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
> >>       warlord at MIT.EDU                        PGP key available
> >>
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > 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