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, <[email protected]<mailto:[email protected]>> <[email protected]<mailto:[email protected]>> wrote: Message: 1 Date: Tue, 14 Aug 2018 01:21:51 -0500 (CDT) From: Megagrumpy <[email protected]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> Subject: Re: [GNC] GC 3.2 Import Price File CSV Message-ID: <[email protected]<mailto:[email protected]>> 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 [email protected] 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.
