Re: [GNC] GC 3.2 Import Price File CSV

[Geert Janssens]

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 regardless of what line endings the file has, our parser will only see 
"LF", the "unix" format or what C++ libraries expect by default.


Geert

> 
> 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.  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
> > 
> > Thanks for the feedback. The exact source of the problem is in the
> > difference in line-endings. GnuCash currently expects "LF" (the C++
> > default), but some files can have "CRLF" (Windows) or "CR" (Macos) as
> > line ending.
> > 
> > I have made changes to the code to fix this for gnucash 3.3.
> > 
> > Geert
> > 
> > 
> > ___
> > 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.




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

Re: [GNC] GC 3.2 Import Price File CSV

[David T. via gnucash-user]

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.  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
> 
> Thanks for the feedback. The exact source of the problem is in the difference 
> in line-endings. GnuCash currently expects "LF" (the C++ default), but some 
> files can have "CRLF" (Windows) or "CR" (Macos) as line ending.
> 
> I have made changes to the code to fix this for gnucash 3.3.
> 
> Geert
> 
> 
> ___
> 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.

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

Re: [GNC] GC 3.2 Import Price File CSV

[Geert Janssens]

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 problem when I
> have time.
> 
> Andy

Thanks for the feedback. The exact source of the problem is in the difference 
in line-endings. GnuCash currently expects "LF" (the C++ default), but some 
files can have "CRLF" (Windows) or "CR" (Macos) as line ending.

I have made changes to the code to fix this for gnucash 3.3.

Geert


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

Re: [GNC] GC 3.2 Import Price File CSV

[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 problem when I
have time.

Andy



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] GC 3.2 Import Price File CSV

[Andy Brown via gnucash-user]

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' option,
for line breaks, then everything was fine.  Bit of a messy workaround but
may help someone :-).

Cheers
Andy



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] GC 3.2 Import Price File CSV

[John Ralls]

> 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 TextWrangler and
> discovered that if I did a 'save as' using UTF-8 and the 'Unix LF' option,
> for line breaks, then everything was fine.  Bit of a messy workaround but
> may help someone :-).

Since TextWrangler isn’t part of MacOS, could you try the same thing with 
TextEdit?

Regards,
John Ralls

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

Re: [GNC] GC 3.2 Import Price File CSV

[Andy Brown via gnucash-user]

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' option,
for line breaks, then everything was fine.  Bit of a messy workaround but
may help someone :-).

Cheers
Andy



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] GC 3.2 Import Price File CSV

[Anirvan Sarkar]

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,
Anirvan

On Wed, 29 Aug 2018 at 20:18, Geert Janssens 
wrote:

> 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).
>
> > 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
> > problem. Once he fixed that, everything worked ok. He posted his solution
> > on this list as well.
>
> > Thanks for the follow up.
> >
> > Cheers.
> >
> > On 29-Aug-2018, at 4:06 PM, Geert Janssens
> > mailto:geert.gnuc...@kobaltwit.be>> wrote:
>
> > megagru...@hotmail.com
> >
>
>
>
>
> ___
> 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.



-- 
Anirvan
___
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.

Re: [GNC] GC 3.2 Import Price File CSV

[Geert Janssens]

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

Re: [GNC] GC 3.2 Import Price File CSV

[David T. via gnucash-user]

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. Best is to attach it to a bug in our bugzilla.
> 
> Geert
> 
> Op woensdag 29 augustus 2018 14:36:35 CEST schreef D:
>> 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 solved it
>> for me. My solution was to remove Excel from the process altogether.
>> 
>> It seems to me that there is need to determine precisely what needs to
>> change for the importer to work with Excel.
>> 
>> [For the record, I could never get the importer to process the EOL
>> characters in the Excel csv file. I'm on a Mac, and I know that EOL
>> characters can vary by OS. I tried replacing the newline character with
>> CRLF, but that didn't work. Nor did any other changes, and so I gave up.
>> Regardless, suffice to say that importing from an Excel-generated csv file
>> didn't work on my Mac.]I
>> 
>> David
>> 
>> 
>> On August 29, 2018, at 7:14 AM, Geert Janssens 
>> wrote:
>> 
>> 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).
>>> 
>>> 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
>>> problem. Once he fixed that, everything worked ok. He posted his solution
>>> on this list as well.
>>> 
>>> Thanks for the follow up.
>>> 
>>> Cheers.
>>> 
>>> On 29-Aug-2018, at 4:06 PM, Geert Janssens
>>> mailto:geert.gnuc...@kobaltwit.be>> wrote:
>>> 
>>> megagru...@hotmail.com
>> 
>> ___
>> 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.
> 
> 
> 
> 

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

Re: [GNC] GC 3.2 Import Price File CSV

[Adrien Monteleone]

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

Regards,
Adrien

> On Aug 29, 2018, at 7:36 AM, D via gnucash-user  
> wrote:
> 
> 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 solved it 
> for me. My solution was to remove Excel from the process altogether.
> 
> It seems to me that there is need to determine precisely what needs to change 
> for the importer to work with Excel.
> 
> [For the record, I could never get the importer to process the EOL characters 
> in the Excel csv file. I'm on a Mac, and I know that EOL characters can vary 
> by OS. I tried replacing the newline character with CRLF, but that didn't 
> work. Nor did any other changes, and so I gave up. Regardless, suffice to say 
> that importing from an Excel-generated csv file didn't work on my Mac.]I
> 
> David
> 
> 
> On August 29, 2018, at 7:14 AM, Geert Janssens  
> wrote:
> 
> 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).
> 
>> 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
>> problem. Once he fixed that, everything worked ok. He posted his solution
>> on this list as well.
> 
>> Thanks for the follow up.
>> 
>> Cheers.
>> 
>> On 29-Aug-2018, at 4:06 PM, Geert Janssens
>> mailto:geert.gnuc...@kobaltwit.be>> wrote:
> 
>> megagru...@hotmail.com
>> 
> 
> 
> 
> 
> ___
> 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.
> ___
> 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.


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

Re: [GNC] GC 3.2 Import Price File CSV

[D via gnucash-user]

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 solved it for 
me. My solution was to remove Excel from the process altogether.

It seems to me that there is need to determine precisely what needs to change 
for the importer to work with Excel.

[For the record, I could never get the importer to process the EOL characters 
in the Excel csv file. I'm on a Mac, and I know that EOL characters can vary by 
OS. I tried replacing the newline character with CRLF, but that didn't work. 
Nor did any other changes, and so I gave up. Regardless, suffice to say that 
importing from an Excel-generated csv file didn't work on my Mac.]I

David


On August 29, 2018, at 7:14 AM, Geert Janssens  
wrote:

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).
 
> 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
> problem. Once he fixed that, everything worked ok. He posted his solution
> on this list as well.
 
> Thanks for the follow up.
> 
> Cheers.
> 
> On 29-Aug-2018, at 4:06 PM, Geert Janssens
> mailto:geert.gnuc...@kobaltwit.be>> wrote:
 
> megagru...@hotmail.com
> 




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

Re: [GNC] GC 3.2 Import Price File CSV

[Geert Janssens]

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).
 
> 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
> problem. Once he fixed that, everything worked ok. He posted his solution
> on this list as well.
 
> Thanks for the follow up.
> 
> Cheers.
> 
> On 29-Aug-2018, at 4:06 PM, Geert Janssens
> mailto:geert.gnuc...@kobaltwit.be>> wrote:
 
> megagru...@hotmail.com
> 




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

Re: [GNC] GC 3.2 Import Price File CSV

[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).

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 
problem. Once he fixed that, everything worked ok. He posted his solution on 
this list as well.

Thanks for the follow up.

Cheers.

On 29-Aug-2018, at 4:06 PM, Geert Janssens 
mailto:geert.gnuc...@kobaltwit.be>> wrote:

megagru...@hotmail.com

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

Re: [GNC] GC 3.2 Import Price File CSV

[Deva -]

That's a bummer! And I am out of ideas...

Perhaps a developer can shed some light on your problems...

Cheers.

On Friday 24 August 2018 08:05 PM, 
gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org> wrote:

Date: Fri, 24 Aug 2018 01:48:52 -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 File CSV
Message-ID: 
<1535093332487-0.p...@n4.nabble.com><mailto:1535093332487-0.p...@n4.nabble.com>
Content-Type: text/plain; charset=us-ascii

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 also followed your advice and generated a completely new GC file with
only one stock in it. I have put in ABF under Eurex as the default format
only shows Amex, Eurex, Nasdaq and NYSE as options for the "Type" of stock.
(My stocks are all LSE so I had added LSE as an additional type in my
definitions and thought that maybe that was causing the problem). I get
exactly the same problem with the message "Commodity From could not be
understood. Value can't be parsed into valid commodity."




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

Re: [GNC] GC 3.2 Import Price File CSV

[John Ralls]

> 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 the Encoding required for the import tool.
>> Changing to the option "CSV (comma delimited)" works. Or, as you suggested,
>> changing to Western (ASCII) also works.
> 
> I think that would possibly count as a bug in the importer would it not?

Maybe, though I suspect it’s a bug in Excel. Microsoft is well known for not 
really understanding UTF-8, and there’s always the possibility that Excel tried 
to write UTF-8 and Windows gratuitously transcoded it to the locale’s codepage.

Regards,
John Ralls

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

Re: [GNC] GC 3.2 Import Price File CSV

[Colin Law]

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 option "CSV (comma delimited)" works. Or, as you suggested,
> changing to Western (ASCII) also works.

I think that would possibly count as a bug in the importer would it not?

Colin
___
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.

Re: [GNC] GC 3.2 Import Price File CSV

[Megagrumpy]

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 suggested,
changing to Western (ASCII) also works.  Thanks for helping me out - will
now have to go away and do some reading on encoding standards!



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] GC 3.2 Import Price File CSV

[John Ralls]

> 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 bank it tends to be in M-D-Y format for some reason. 
> 
> I have also followed your advice and generated a completely new GC file with
> only one stock in it. I have put in ABF under Eurex as the default format
> only shows Amex, Eurex, Nasdaq and NYSE as options for the "Type" of stock.
> (My stocks are all LSE so I had added LSE as an additional type in my
> definitions and thought that maybe that was causing the problem). I get
> exactly the same problem with the message "Commodity From could not be
> understood. Value can't be parsed into valid commodity."

I just tested with the following CSV:
AAPL,23/8/2018,USD,255.37
ABF.L,23/8/2018,GBP,25
AZN.L,23/8/2018,GBP,37.12

My securities table in the test account is
LSE
 ABF.L  Associated British FoodsABF.L  GB0006731235 
1
NASDAQ
 AAPL   Apple   AAPL
 1

AAPL and ABF.L are accepted by the csv price importer and AZN.L is rejected, 
all as expected.

This with GnuCash 3.2 on MacOS.

I was able to get ABF.L to break by adding a trailing space to the symbol (i.e. 
“ABF.L “) in the security editor. Please check again to ensure that you have no 
stray spaces. The only way to be sure is to edit it in the security editor, 
select the symbol field, and press the  and  keys and observe that 
there’s no space between the cursor and the letter at each end.

If it’s really not a stray space encoding is the only possible source of the 
mismatch. That shouldn’t be possible as all the code points in “ABF.L” are in 
the 0x20-0x7f range that are the same for all encodings, but just to be sure 
try selecting “Western:English(ASCII)” in the encoding listbox and see if that 
gets the symbol accepted.

Regards,
John Ralls

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

Re: [GNC] GC 3.2 Import Price File CSV

[Megagrumpy]

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 also followed your advice and generated a completely new GC file with
only one stock in it. I have put in ABF under Eurex as the default format
only shows Amex, Eurex, Nasdaq and NYSE as options for the "Type" of stock.
(My stocks are all LSE so I had added LSE as an additional type in my
definitions and thought that maybe that was causing the problem). I get
exactly the same problem with the message "Commodity From could not be
understood. Value can't be parsed into valid commodity."



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] GC 3.2 Import Price File CSV

[Deva -]

I think what Sebastien meant was that there appears to be a leading space in 
your stock definition in gnucash, not in your CSV file. At least, it appears 
that way from the screenshots you sent out. Of course, as he noted, it may just 
be a visual effect…

Cheers.

On 21-Aug-2018, at 9:30 PM, 
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 File CSV
Message-ID: 
<1534832934531-0.p...@n4.nabble.com<mailto:1534832934531-0.p...@n4.nabble.com>>
Content-Type: text/plain; charset=us-ascii

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
the security definition but maybe the CSV import tool is looking for a
specific structure in the database. I have defined all my shares in a
subcategory "LSE" and I cannot remember if this was a Gnucash structure or
one I made myself. See Screen shot:

<http://gnucash.1415818.n4.nabble.com/file/t377722/Account_structure.jpg>





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

Re: [GNC] GC 3.2 Import Price File CSV

[Megagrumpy]

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
the security definition but maybe the CSV import tool is looking for a
specific structure in the database. I have defined all my shares in a
subcategory "LSE" and I cannot remember if this was a Gnucash structure or
one I made myself. See Screen shot:

 





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] GC 3.2 Import Price File CSV

[Deva -]

Hmmm… Other than what Sebastien suggested, one other thing I can think of is to 
delete the commodity in your gnucash datafile and recreate it.

Perhaps you can try what I did. Just create a new blank datafile and setup this 
single security of ABF.L for testing. You don’t need any accounts as such. Then 
import and see what happens. If that works, then something in your main 
datafile is inconsistent with the import definition.

Do you have multiple definitions of accounts using ABF.L security or multiple 
definitions of ABF.L itself setup in different namespaces (perhaps for 
different brokerage accounts)? Not sure why that would cause a problem, but if 
the test datafile with a single definition works, then that might be an area to 
look at.

Since you are using m-d-y for dates, is your locale still UK or some other? 
Reason I ask is because your security currency is GBP, but if your locale is 
set to imply some other, then that might be causing a problem.

Sorry, grasping at straws here! Wish I could be of better help…

Cheers.

On 18-Aug-2018, at 8:04 PM, 
gnucash-user-requ...@gnucash.org<mailto:gnucash-user-requ...@gnucash.org> wrote:

Date: Sat, 18 Aug 2018 10:35:02 +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...@mail.gmail.com>>
Content-Type: text/plain; charset="UTF-8"

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 
mailto:megagru...@hotmail.com>> wrote:

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 letter
and still I get the message "Commodity From could not be understood"! In
this case I have used the MDY date format. my input file reads:
ABF.L,08/12/2018,25,GBP

My commodity in the security editor is defined as ABF.L - see Scrrebshot:
<http://gnucash.1415818.n4.nabble.com/file/t377722/ABF_Security_Editor.jpg>


I still get the same error and it is only that the security ABF.L cannot be
recognised - see Screenshot:

<
http://gnucash.1415818.n4.nabble.com/file/t377722/ABF_error_screenshot.jpg>


As you can see the date and all the other fields are OK and parse
successfully. Only the Stock ID is rejected.





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
gnucash-user mailing list
gnucash-user@gnucash.org<mailto: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.



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

Re: [GNC] GC 3.2 Import Price File CSV

[Sébastien de Menten]

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 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 letter
> and still I get the message "Commodity From could not be understood"! In
> this case I have used the MDY date format. my input file reads:
> ABF.L,08/12/2018,25,GBP
>
> My commodity in the security editor is defined as ABF.L - see Scrrebshot:
> 
>
>
> I still get the same error and it is only that the security ABF.L cannot be
> recognised - see Screenshot:
>
> <
> http://gnucash.1415818.n4.nabble.com/file/t377722/ABF_error_screenshot.jpg>
>
>
> As you can see the date and all the other fields are OK and parse
> successfully. Only the Stock ID is rejected.
>
>
>
>
>
> --
> Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
> ___
> 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.
>
___
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.

Re: [GNC] GC 3.2 Import Price File CSV

[Megagrumpy]

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 letter
and still I get the message "Commodity From could not be understood"! In
this case I have used the MDY date format. my input file reads: 
ABF.L,08/12/2018,25,GBP

My commodity in the security editor is defined as ABF.L - see Scrrebshot:
 

I still get the same error and it is only that the security ABF.L cannot be
recognised - see Screenshot:

 

As you can see the date and all the other fields are OK and parse
successfully. Only the Stock ID is rejected.





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] GC 3.2 Import Price File CSV

[Adrian Holbrook]

Thanks for your response. Can you tell me when the spam was sent? I did have 
some problems some time ago but have changed my password a couple of times 
since then.

Get Outlook for Android<https://aka.ms/ghei36>


From: gnucash-user  on 
behalf of Liz 
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 but it seems to be stuck with the
> moderator as I have not seen it posted yet.
>
>

Yes, spam arrived claiming to be from your email address, so to reduce
the burden on list members, your email address is on moderation.

I do not believe that you sent the mail, but Mailman cannot distinguish
intent (yet, patches welcome!) so currently all mail claiming to come
from your email address is moderated.

Liz
The Moderator
___
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.gnucash.org%2Fmailman%2Flistinfo%2Fgnucash-userdata=02%7C01%7C%7Ce7c0c925989346c85b5a08d6029666b1%7C84df9e7fe9f640afb435%7C1%7C0%7C636699242320565550sdata=MAyqroqEoqc3LuybFKJm8PTnh0UjCKLPmHtdMOcWuzc%3Dreserved=0
If you are using Nabble or Gmane, please see 
https://nam01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.gnucash.org%2Fwiki%2FMailing_Listsdata=02%7C01%7C%7Ce7c0c925989346c85b5a08d6029666b1%7C84df9e7fe9f640afb435%7C1%7C0%7C636699242320565550sdata=4xoA46VXzvzl6KWuXZuvM86zAL%2FdlXqxI38hM5BtVzY%3Dreserved=0
 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.
___
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.

Re: [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, 
mailto: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 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.

Re: [GNC] GC 3.2 Import Price File CSV

[Megagrumpy]

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:

 







--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] GC 3.2 Import Price File CSV

[Deva -]

Can you please share a screenshot? Of both CSV import setting screen and the 
definition of the security in the security editor.

The CSV import price screen should also allow settings for date formats, 
locale, delimiters and such. Once I look at your whole import screen, I may be 
able to help further.

Things to check -

a. your date formats (though this is less likely to be your problem)
b. are your stock ids enclosed in quotes? If so, either change the import 
setting to imply that or remove enclosed quotes from the file
c. In the small grid shown in the import window, are all your fields correctly 
divided into columns? If not, there may be a delimiter problem

Cheers.

On 14-Aug-2018, at 11:31 AM, 
mailto:gnucash-user-requ...@gnucash.org>> 
mailto:gnucash-user-requ...@gnucash.org>> 
wrote:


Message: 8
Date: Mon, 13 Aug 2018 03:59:24 -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 File CSV
Message-ID: 
<1534150764820-0.p...@n4.nabble.com<mailto:1534150764820-0.p...@n4.nabble.com>>
Content-Type: text/plain; charset=us-ascii

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


--

Message: 9
Date: Mon, 13 Aug 2018 07:49:19 -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 File CSV
Message-ID: 
<1534164559579-0.p...@n4.nabble.com<mailto:1534164559579-0.p...@n4.nabble.com>>
Content-Type: text/plain; charset=us-ascii

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 the ID in the security editor to both ABF.L and ABF and still get
the same error message.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html


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

Re: [GNC] GC 3.2 Import Price File CSV

[Megagrumpy]

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 the ID in the security editor to both ABF.L and ABF and still get
the same error message.



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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.

Re: [GNC] GC 3.2 Import Price File CSV

[Megagrumpy]

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