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