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-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org>> 
<gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org>> 
wrote:

Message: 1
Date: Tue, 14 Aug 2018 01:21:51 -0500 (CDT)
From: Megagrumpy <megagru...@hotmail.com<mailto:megagru...@hotmail.com>>
To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org>
Subject: Re: [GNC] GC 3.2 Import Price File CSV
Message-ID: 
<1534227711704-0.p...@n4.nabble.com<mailto:1534227711704-0.p...@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>







_______________________________________________
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.

Reply via email to