Re: [GNC] importing csv multisplit multicurrency problems

2020-03-11 Thread Gio Bacareza
gnucash-user-requ...@gnucash.org wrote: >> > >> > Date: Fri, 6 Mar 2020 12:23:17 +0800 >> > From: Gio Bacareza mailto:gbacar...@gmail.com>> >> > To: GnuCash Users > gnucash-user@gnucash.org>> >> > Subject: Re: [GNC] importing csv multisplit mult

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-10 Thread pobox . deva
om: Gio Bacareza mailto:gbacar...@gmail.com> > > <mailto:gbacar...@gmail.com <mailto:gbacar...@gmail.com>>> > > To: GnuCash Users > <mailto:gnucash-user@gnucash.org> <mailto:gnucash-user@gnucash.org > > <mailto

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-10 Thread Gio Bacareza
@gnucash.org wrote: > > > > Date: Fri, 6 Mar 2020 12:23:17 +0800 > > From: Gio Bacareza mailto:gbacar...@gmail.com>> > > To: GnuCash Users gnucash-user@gnucash.org>> > > Subject: Re: [GNC] importing csv multisplit multicurrency problems >

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-06 Thread Adrien Monteleone
Thanks, I had seen that link, but hadn’t looked it over carefully enough. I realize now you had 2 transactions with 2 splits each. (I first thought it was one with 4) I tried a similar test import without a price in the db. Indeed it imported as imbalanced, and would not let me fix it no matter

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-06 Thread Geert Janssens
Hi, Unfortunately I don't know what the other importers are capable of. I have not used those before. Regards, Geert Op vrijdag 6 maart 2020 04:50:06 CET schreef Gio Bacareza: > Hi Geert, thanks for the feedback. > > Questions: > Is it advisable then to convert csvs to another format? > What

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Gio Bacareza
Adrien, results here https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing On Fri, Mar 6, 2020 at 3:05 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > I might have misunderstood your earlier reply, but what if you leave off > the Trading

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Adrien Monteleone
I might have misunderstood your earlier reply, but what if you leave off the Trading accounts from the import entirely and don’t have a price defined in the database? (that is, only 2 splits, not 4) What does GnuCash do then? I should think it should add the Trading account splits as exact base

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread pobox . deva
. > On 06-Mar-2020, at 9:53 AM, gnucash-user-requ...@gnucash.org wrote: > > Date: Fri, 6 Mar 2020 12:23:17 +0800 > From: Gio Bacareza mailto:gbacar...@gmail.com>> > To: GnuCash Users mailto:gnucash-user@gnucash.org>> > Subject: Re: [GNC] importing csv multisplit multi

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Gio Bacareza
As mentioned I did some follow through tests with empty and pre-populated currency price databases. Sharing it here: Conclusions: When doing multi-currency csv imports, it works when the price database is pre-populated with exchange rates consistent with exchange rates used in the import. The issu

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Gio Bacareza
Hi Geert, thanks for the feedback. Questions: Is it advisable then to convert csvs to another format? What is the preferred format for multicurency imports? Any other tips on doing multicurrency imports? Thanks! On Fri, Mar 6, 2020 at 1:01 AM Geert Janssens wrote: > There are several bugs with

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Gio Bacareza
Thank you Adrien. Inspired by your answers I did a few more tests. 1. I got rid of the lines with the trading accounts assuming from past behavior that gnucash will autopopulate with trading currency accounts based on price database: Date Description Account Deposit Withdrawal 3/6/2020 Description

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Geert Janssens
There are several bugs with multi-currency csv imports. I don't think it's currently possible to do such imports. Sorry. Geert Op donderdag 5 maart 2020 14:14:56 CET schreef Gio Bacareza: > I'm encountering problems with importing transactions in csv when accounts > have different currencies. >

Re: [GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Adrien Monteleone
> On Mar 5, 2020 w10d65, at 7:14 AM, Gio Bacareza wrote: > > I'm encountering problems with importing transactions in csv when accounts > have different currencies. > > I've been reading the debates. So this is not about definitions of > multi-split or terminology. > > I did a test with a sam

[GNC] importing csv multisplit multicurrency problems

2020-03-05 Thread Gio Bacareza
I'm encountering problems with importing transactions in csv when accounts have different currencies. I've been reading the debates. So this is not about definitions of multi-split or terminology. I did a test with a sample csv with the following contents: Date,Description,Account,Deposit,Withdr