Import transaction from CSV

[R. Victor Klassen]

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.