[GNC] GC 3.2 Import Price File CSV

David T. sunfish62 at yahoo.com
Wed Aug 29 15:32:14 EDT 2018


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 <geert.gnucash at kobaltwit.be> 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 <geert.gnucash at kobaltwit.be>
>> 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
>>> <geert.gnucash at kobaltwit.be<mailto:geert.gnucash at kobaltwit.be>> wrote:
>>> 
>>> megagrumpy at hotmail.com<mailto:megagrumpy at hotmail.com>
>> 
>> _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at 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.
> 
> 
> 
> 



More information about the gnucash-user mailing list