CSV import question

Geert Janssens geert.gnucash at kobaltwit.be
Fri Sep 23 16:29:06 EDT 2016


Yes, the c++ version can certainly be extended to support more complex transactions. If time permits I intend to improve this part some more.

Regards,

Geert

John Ralls <jralls at ceridwen.us> schreef op 23 september 2016 21:33:21 CEST:
>
>> On Sep 23, 2016, at 7:31 PM, David Solet <dsolet at gmail.com> wrote:
>> 
>> As a small non-profit, we are working with an internet business to
>process
>> our credit card transactions. With this processor, you can export
>activity
>> from your account in csv or iif format. Since Gnucash doesn't
>recognize iif
>> format, I was able to import the csv transactions file. Each
>transaction in
>> the csv file has a field for the payment and the processing fee. When
>I
>> defined the payment as Deposit and the fee as Withdrawal, Gnucash
>> automatically subtracted the fee from the payment for the Total
>Deposit in
>> each transaction. However, I need to keep track of the payment and
>fee
>> amounts separately and charge them to different accounts. When we
>were
>> using another credit card processor that let you export in QIF, I was
>able
>> to import that detail for each transaction. I realize I can do two
>imports,
>> one with the payment and the other with the fee, but was hoping to
>keep
>> both charges associated with one transaction. Is there any way I can
>get
>> gnucash to do that with a csv import? Thanks for any advice.
>
>David,
>
>Unfortunately the CSV importer is able to handle only simple, meaning
>two split, transactions. Geert's been working on rewriting it in C++
>and based on my review of his work there earlier this week it seems
>feasible to expand that to more complex transactions at some point.
>Unfortunately we're severely limited by available developer time and I
>can't say whether that support will happen in time for 2.8 or even
>2.10.
>
>There's a possible work-around, though: If you Google for "csv to qif"
>you'll get plenty of possible scripts to try out. I imagine you'll find
>at least one that converts your complex CSV into a comparable QIF or
>OFX that GnuCash can use to import complex transactions.
>
>Regards,
>John Ralls
>
>
>_______________________________________________
>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.

Sent from my smartphone. Please excuse my brevity.


More information about the gnucash-user mailing list