[GNC] GC 3.2 Import Price File CSV

[Deva -]

Thanks. I just recreated a new GC datafile with just 1 security definition as shown in your screenshot.

I put your CSV price entry in a text file and imported it but gives me the error you have shown.

Here’s why -

Your security definition is ABF.L, but your CSV file has this set to ABF. Change the CSV file to ABF.L (I know you said you tried this before and it still didn’t work, but we are not done yet).

Next, change the date format on the import screen from m-d-y to d-m-y. Now you will see your CSV price data being accepted. Click Next and Apply to import the price.

Of course, the question remains as to why the date format needs to change because the date 12/08/2018 should have been understood as 12-Aug (if the format was taken as d-m-y) and as 8-Dec (if the format was taken as m-d-y). From your stock and currency, I am guessing the date you intended was 12-Aug, so change the date format to match the data.

Hope this helps.

Cheers.

On 15-Aug-2018, at 9:29 PM, <gnucash-user-request at gnucash.org<mailto:gnucash-user-request at gnucash.org>> <gnucash-user-request at gnucash.org<mailto:gnucash-user-request at gnucash.org>> wrote:

Message: 1
Date: Tue, 14 Aug 2018 01:21:51 -0500 (CDT)
From: Megagrumpy <megagrumpy at hotmail.com<mailto:megagrumpy at hotmail.com>>
To: gnucash-user at gnucash.org<mailto:gnucash-user at gnucash.org>
Subject: Re: [GNC] GC 3.2 Import Price File CSV
Message-ID: <1534227711704-0.post at n4.nabble.com<mailto:1534227711704-0.post at n4.nabble.com>>
Content-Type: text/plain; charset=us-ascii

I will try to show my problem with screenshots  - hopefully it will work but
never tried this before.

This is my entry in the database:
<http://gnucash.1415818.n4.nabble.com/file/t377722/Database_img.jpg>

This is the single line in my CSV vile:
ABF,12/08/2018,25,GBP

And this is my import form:

<http://gnucash.1415818.n4.nabble.com/file/t377722/2018-08-14_%281%29.png>