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 <gbacar...@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 <jra...@ceridwen.us> wrote: > > > > On Aug 13, 2020, at 10:07 PM, Gio Bacareza <gbacar...@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 _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
