[GNC] Help with mult-currency multi-split import

[John Ralls]

Gio,

Can you fake up a CSV and gnucash file to demonstrate the problem? You could attach them to a bug report.

Regards,
John Ralls


> On Aug 14, 2020, at 11:16 PM, Gio Bacareza <gbacareza at gmail.com> wrote:
> 
> Thanks John. That's really weird because I swear the csv contains a 2nd transaction that  is 1678 to 56286.85. I've been copy pasting from a set of csvs for the tests.
> 
> I tried it with some other accounts since then because I had to get the transactions in. In some imports it worked. In some I noticed a pattern where gnucash for some weird reason takes the AUD of the preceding transaction, uses that as an entry into the next one. Hence I think that's causing the exchange rates conflicts. I should have collected the screenshots.
> 
> I will try the experiment on another computer and share results and figure it out.
> 
> I will continue to try this out on the next batch of statement imports next month.
> 
> I will also test if doing it in OFX will be more predictable. Will just have to do pre-processing to translate csv to to ofx. Does anyone in the community have any leads for csv->ofx tools? thanks
> 
> On Sat, Aug 15, 2020 at 12:07 AM John Ralls <jralls at ceridwen.us> wrote:
> 
> 
> > On Aug 13, 2020, at 10:07 PM, Gio Bacareza <gbacareza at gmail.com> wrote:
> > 
> > Test 1:
> > Import:
> >    Withdraw Deposit 
> > 02/21/2020,test first transaction,Account 1 in AUD,1486,0,,
> > ,,Account 2 in AUD,0,1486,,
> > 02/27/2020,test second transaction,Account 1 in AUD,0,1678.08,,
> > ,,Account 3 in PHP,56286.85,0,,note- conversion price stored in gnucash is is 33.54241157. That is the same price I use to pre-convert. So 1678.08*33.54241157 = 56286.85
> > 
> 
> BZZZT! That's not what your first screen shot says. It says the second transaction is Account 1 DR AUD 1468.00, Account3 CR 56286.85.
> 
> Regards,
> John Ralls
> 
> 
> -- 
> cheers,
> 
> Gio