[GNC] importing csv multisplit multicurrency problems

[Gio Bacareza]

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 <pobox.deva at outlook.in> 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 <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> 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 wrote:
>> >
>> > Date: Fri, 6 Mar 2020 12:23:17 +0800
>> > From: Gio Bacareza <gbacareza at gmail.com <mailto:gbacareza at gmail.com>>
>> > To: GnuCash Users <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+XeJkOU72r9PV0a9v7bXi_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
>> >
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at 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.
>>
>
>
> --
> cheers,
>
> Gio
>
>
>