[GNC] importing csv multisplit multicurrency problems

pobox.deva at outlook.in pobox.deva at outlook.in
Wed Mar 11 01:40:44 EDT 2020


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 <gbacareza at 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.deva at outlook.in <mailto:pobox.deva at 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-request at gnucash.org <mailto:gnucash-user-request at gnucash.org> wrote:
> > 
> > Date: Fri, 6 Mar 2020 12:23:17 +0800
> > From: Gio Bacareza <gbacareza at gmail.com <mailto:gbacareza at gmail.com> <mailto:gbacareza at gmail.com <mailto:gbacareza at gmail.com>>>
> > To: GnuCash Users <gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org> <mailto:gnucash-user at gnucash.org <mailto:gnucash-user at gnucash.org>>>
> > Subject: Re: [GNC] importing csv multisplit multicurrency problems
> > Message-ID:
> >       <CAEC3bMQ5irKLC0ew79Ra3Ktvb+XeJkOU72r9PV0a9v7bXi_oqQ at mail.gmail.com <mailto:CAEC3bMQ5irKLC0ew79Ra3Ktvb%2BXeJkOU72r9PV0a9v7bXi_oqQ at mail.gmail.com> <mailto:CAEC3bMQ5irKLC0ew79Ra3Ktvb+XeJkOU72r9PV0a9v7bXi_oqQ at mail.gmail.com <mailto:CAEC3bMQ5irKLC0ew79Ra3Ktvb%2BXeJkOU72r9PV0a9v7bXi_oqQ at 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 at gnucash.org <mailto:gnucash-user at 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



More information about the gnucash-user mailing list