Not your fault at all but mine. I was looking at all possible causes for the faulty import. Thanks
On Wed, Mar 11, 2020, 1:40 PM <[email protected]> wrote: > Sorry Gio, I don’t have any experience with the import or multi-currency > transactions in GnuCash. > > I only responded to your query because you wanted a better way to load a > price database rather than entering them manually. > > Cheers. > > On 11-Mar-2020, at 10:32 AM, Gio Bacareza <[email protected]> wrote: > > Hi Pobox.Deva, > > Thank you for the suggestion. I'll try that out. However my problem, I > think though I may be wrong, is not the price database but the importing > multicurrency transactions. > > I even made it simpler. Pre-import, I calculated and populated the > currency conversions using just 1 exchange rate. I thought that by doing > this I avoid having to maintain a price database that could change on a > daily basis. Because this would mean the calculating the conversions prior > to import will require me to have a different conversion rate depending on > the day. It's possible but I thought it will take more work. > > But I may be wrong. So do you think that fixing the price database will > fix the multi-currency import problem I am having? > > Thanks. > > > On Fri, Mar 6, 2020 at 1:37 PM <[email protected]> wrote: > >> Gio, >> >> If you are using the 3.x series, there’s a convenient CSV price importer >> that works well. You can even save the CSV price file template for future >> use, so you’d have to set it up only once. >> >> That should alleviate a lot of burden in entering prices in price >> database manually. >> >> Cheers. >> >> > On 06-Mar-2020, at 9:53 AM, [email protected] wrote: >> > >> > Date: Fri, 6 Mar 2020 12:23:17 +0800 >> > From: Gio Bacareza <[email protected] <mailto:[email protected]>> >> > To: GnuCash Users <[email protected] <mailto: >> [email protected]>> >> > Subject: Re: [GNC] importing csv multisplit multicurrency problems >> > Message-ID: >> > < >> caec3bmq5irklc0ew79ra3ktvb+xejkou72r9pv0a9v7bxi_...@mail.gmail.com >> <mailto: >> caec3bmq5irklc0ew79ra3ktvb+xejkou72r9pv0a9v7bxi_...@mail.gmail.com>> >> > Content-Type: text/plain; charset="UTF-8" >> > >> > 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 issue I have with this is that pre-populating the price DB is >> > cumbersome. >> > There has to be a better way. >> > >> > More details of test here >> > >> https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing >> < >> https://docs.google.com/document/d/1d-j6195r3-hHyKopCCwFmGDu94f_8m5bj-fVPb4IJwk/edit?usp=sharing >> > >> _______________________________________________ >> gnucash-user mailing list >> [email protected] >> 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. >> > > > -- > cheers, > > Gio > > > _______________________________________________ gnucash-user mailing list [email protected] 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.
