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 <gbacar...@gmail.com> 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 <pobox.d...@outlook.in > <mailto:pobox.d...@outlook.in>> 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, gnucash-user-requ...@gnucash.org > > <mailto:gnucash-user-requ...@gnucash.org> wrote: > > > > Date: Fri, 6 Mar 2020 12:23:17 +0800 > > From: Gio Bacareza <gbacar...@gmail.com <mailto:gbacar...@gmail.com> > > <mailto:gbacar...@gmail.com <mailto:gbacar...@gmail.com>>> > > To: GnuCash Users <gnucash-user@gnucash.org > > <mailto:gnucash-user@gnucash.org> <mailto:gnucash-user@gnucash.org > > <mailto:gnucash-user@gnucash.org>>> > > Subject: Re: [GNC] importing csv multisplit multicurrency problems > > Message-ID: > > <caec3bmq5irklc0ew79ra3ktvb+xejkou72r9pv0a9v7bxi_...@mail.gmail.com > > <mailto:caec3bmq5irklc0ew79ra3ktvb%2bxejkou72r9pv0a9v7bxi_...@mail.gmail.com> > > <mailto:caec3bmq5irklc0ew79ra3ktvb+xejkou72r9pv0a9v7bxi_...@mail.gmail.com > > <mailto:caec3bmq5irklc0ew79ra3ktvb%2bxejkou72r9pv0a9v7bxi_...@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> > > > > <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 > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > <https://lists.gnucash.org/mailman/listinfo/gnucash-user> > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists > <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 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.
