Re: [GNC] GC 3.2 Import Price File CSV

Op dinsdag 4 september 2018 14:20:24 CEST schreef David T.: > Geert, > > Thanks for looking into this and coming up with a fix. > > Just out of curiosity, what is the fix that you’ve put in? Before trying to parse a csv file, make sure all possible line endings to "LF" (internally). So

Re: [GNC] GC 3.2 Import Price File CSV

Geert, Thanks for looking into this and coming up with a fix. Just out of curiosity, what is the fix that you’ve put in? Cheers, David > On Sep 4, 2018, at 5:34 AM, Geert Janssens wrote: > > Op dinsdag 4 september 2018 10:36:11 CEST schreef Andy Brown via gnucash-user: >> Tried TextEdit.

Re: [GNC] GC 3.2 Import Price File CSV

Op dinsdag 4 september 2018 10:36:11 CEST schreef Andy Brown via gnucash-user: > Tried TextEdit. It does have a UTF-8 option but it won't correct the EOL > character, (as far as I can make out from a one file test). I will try and > find a hex editor and investigate the exact source of the

Re: [GNC] GC 3.2 Import Price File CSV

Tried TextEdit. It does have a UTF-8 option but it won't correct the EOL character, (as far as I can make out from a one file test). I will try and find a hex editor and investigate the exact source of the problem when I have time. Andy -- Sent from:

Re: [GNC] GC 3.2 Import Price File CSV

Hello, I have this same issue with using the importer on Mac OS. CSV files that have been 'through' Excel in a workflow seem to lose their EOL character. I did some further investigation by opening the file with TextWrangler and discovered that if I did a 'save as' using UTF-8 and the 'Unix LF'

Re: [GNC] GC 3.2 Import Price File CSV

> On Sep 3, 2018, at 5:01 AM, Andy Brown via gnucash-user > wrote: > > Hello, > > I have this same issue with using the importer on Mac OS. CSV files that > have been 'through' Excel in a workflow seem to lose their EOL character. I > did some further investigation by opening the file with

Re: [GNC] GC 3.2 Import Price File CSV

Hello, I have this same issue with using the importer on Mac OS. CSV files that have been 'through' Excel in a workflow seem to lose their EOL character. I did some further investigation by opening the file with TextWrangler and discovered that if I did a 'save as' using UTF-8 and the 'Unix LF'

Re: [GNC] GC 3.2 Import Price File CSV

Hi, New user GnuCash here. The solution mentioned was to save the file in a different encoding than UTF-8. Is the file saved with a UTF-8 Byte-order Mark? I have seen cases (in other softwares) where the Byte-order Mark caused parsing failures. Maybe the same is happening here? Regards,

Re: [GNC] GC 3.2 Import Price File CSV

Op woensdag 29 augustus 2018 21:32:14 CEST schreef David T.: > Geert, > > I have filed Bug 796833 with both a short csv file from my copy of Excel, > and a screenshot of the importer result. > > Cheers, > David > Thanks. Geert ___ gnucash-user

Re: [GNC] GC 3.2 Import Price File CSV

Geert, I have filed Bug 796833 with both a short csv file from my copy of Excel, and a screenshot of the importer result. Cheers, David > On Aug 29, 2018, at 8:45 AM, Geert Janssens > wrote: > > If you can provide a sample file which you have verified to fail, we may be > able to debug it.

Re: [GNC] GC 3.2 Import Price File CSV

I don’t use the importer but this sounds like a good candidate for the FAQ or somewhere else appropriate on the wiki, if those of you who are more familiar with the process have the time. If it’s simply a case of ‘import directly, don’t open it in Excel first’ I can certainly add that in

Re: [GNC] GC 3.2 Import Price File CSV

I should mention that this thread alerted me to the problems that Excel csv files can cause with the importer. My own attempts to import price data also failed, as I was using Excel as a source. I attempted to use different encoding, as this person did, but none of the many format choices

Re: [GNC] GC 3.2 Import Price File CSV

Oh, I missed that solution post apparently. Thanks for informing me. Regards, Geert Op woensdag 29 augustus 2018 13:11:36 CEST schreef Deva -: > Thanks Geert. > > But please note this was not an issue for me; I was just trying to help > another poster with his problems (cc’d on this mail). >

Re: [GNC] GC 3.2 Import Price File CSV

Thanks Geert. But please note this was not an issue for me; I was just trying to help another poster with his problems (cc’d on this mail). Bob can rest easy because the OP said he finally solved it. Something to do with the way he exported his price data from a spreadsheet to CSV was the

Re: [GNC] GC 3.2 Import Price File CSV

grumpy <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: <1535093332487-0.p...@n4.nabble.com><mailto:1535093332487-0.p...@n4.nabble.com> Content-Type: text/plain; charset

Re: [GNC] GC 3.2 Import Price File CSV

> On Aug 24, 2018, at 1:36 PM, Colin Law wrote: > > In Fri, 24 Aug 2018 at 17:58, Megagrumpy wrote: >> >> SUCCESS!!! It turns out that I was very carefully ensuring that I was saving >> the file from Excel in "CSV UTF-8 (Comma delimited)" format as I thought >> this was the closest match to

Re: [GNC] GC 3.2 Import Price File CSV

In Fri, 24 Aug 2018 at 17:58, Megagrumpy wrote: > > SUCCESS!!! It turns out that I was very carefully ensuring that I was saving > the file from Excel in "CSV UTF-8 (Comma delimited)" format as I thought > this was the closest match to the Encoding required for the import tool. > Changing to the

Re: [GNC] GC 3.2 Import Price File CSV

SUCCESS!!! It turns out that I was very carefully ensuring that I was saving the file from Excel in "CSV UTF-8 (Comma delimited)" format as I thought this was the closest match to the Encoding required for the import tool. Changing to the option "CSV (comma delimited)" works. Or, as you

Re: [GNC] GC 3.2 Import Price File CSV

> On Aug 23, 2018, at 11:48 PM, Megagrumpy wrote: > > There are no spaces in the stock definition. Also in answer to your question > about the date format. I have tried all the date formats and I never get a > failure to read the date correctly. When I import data in quicken format > from my

Re: [GNC] GC 3.2 Import Price File CSV

There are no spaces in the stock definition. Also in answer to your question about the date format. I have tried all the date formats and I never get a failure to read the date correctly. When I import data in quicken format from my bank it tends to be in M-D-Y format for some reason. I have

Re: [GNC] GC 3.2 Import Price File CSV

, gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org> wrote: Date: Tue, 21 Aug 2018 01:28:54 -0500 (CDT) From: Megagrumpy mailto:megagru...@hotmail.com>> To: gnucash-user@gnucash.org<mailto:gnucash-user@gnucash.org> Subject: Re: [GNC] GC 3.2 Import Price F

Re: [GNC] GC 3.2 Import Price File CSV

I have checked the CSV file and there are no spaces. I tried initially to import a number of shares and none or them were recognised by the import tool. It must be a fault in my security definitions I think. When F::Q was working it would import the prices from Alphavantage so it was happy with

Re: [GNC] GC 3.2 Import Price File CSV

+0200 From: S?bastien de Menten mailto:sdemen...@gmail.com>> To: Megagrumpy mailto:megagru...@hotmail.com>> Cc: Gnucash userlist mailto:gnucash-user@gnucash.org>> Subject: Re: [GNC] GC 3.2 Import Price File CSV Message-ID: mailto:cab2pxduxsxxjp71wkfbqownbagw_wqsldz24ssj32m3prhx...@

Re: [GNC] GC 3.2 Import Price File CSV

Would it be possible you have a blank as first character in your security editor (i.e. " ABF.L")? The screenshot you sent give me this impression... But it may be just a visual artifact. On Sat, Aug 18, 2018, 08:54 Megagrumpy wrote: > Thanks for the response, Deva. I have tried every

Re: [GNC] GC 3.2 Import Price File CSV

Thanks for the response, Deva. I have tried every combination of date format, and security ID with no luck. Unfortunately my screenshots were taken from different times so I agree - if I had tried to use those particular settings I would have had an error. I have followed your instructions to the

Re: [GNC] GC 3.2 Import Price File CSV

Sent: Wednesday, August 15, 2018 11:02:41 AM To: gnucash-user@gnucash.org Subject: Re: [GNC] GC 3.2 Import Price File CSV On Tue, 14 Aug 2018 10:06:48 -0500 (CDT) Megagrumpy wrote: > Thanks for your responses. I have submitted a reply to this thread > with screen shots a few hours ago

Re: [GNC] GC 3.2 Import Price File CSV

@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 p

Re: [GNC] GC 3.2 Import Price File CSV

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: This is the single line in my CSV vile: ABF,12/08/2018,25,GBP And this is my import form:

Re: [GNC] GC 3.2 Import Price File CSV

ilto: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: <1534150764820-0.p...@n4.nabble.com<mailto:1534150764820-0.p...@n4.nabble.com>> Content-Type: text/plain; charset=us

Re: [GNC] GC 3.2 Import Price File CSV

That is what I have done. I am testing now with only one commodity - Associated British Food. I have the id set in the security editor as ABF.L. I have tried setting this on the CSV file to ABF.L. I have also tried ABF. Still get the message "Commodity From could not be recognised". I have changed

Re: [GNC] GC 3.2 Import Price File CSV

I was specifically referring to the the CSV price import tool in Version 3.2. I am trying to import the stock prices using this tool. Cannot get the Share ID to be recognised whatever I do. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html

[GNC] GC 3.2 Import Price File CSV

Very pleased to see this feature in 3.2 as I have been getting problems importing with F:Q. Unfortunately I am having a problem with getting the tool to recognise the stock ID. I have tried the normal version eg ABF. GVC, ITV etc and I get the reddish colour with the message Commodity From could