[GNC] GC 3.2 Import Price File CSV
Adrien Monteleone
adrien.monteleone at lusfiber.net
Wed Aug 29 12:33:21 EDT 2018
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 <gnucash-user at gnucash.org> 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 <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.
> _______________________________________________
> 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