Importing Customer data via csv file

[Edward Doolittle]

It would be interesting to compare the Excel and Numbers CSVs to see what the difference is.

Sent from my iPad

> On Mar 11, 2015, at 1:41 PM, Charles Nightengale <cenight22 at me.com> wrote:
> 
> Thanks. Saving as windows csv did the trick.
> 
> FYI, I had also tried moving the file to Numbers and saving as a csv file. The initial download seemed to work as shown in te window summary the window but when I did the full download Gnucash crashed.
> 
> Charlie
> 
> 
>> On Mar 11, 2015, at 8:58 AM, Edward Doolittle <edward.doolittle at gmail.com> wrote:
>> 
>> It could be an issue with the newline character (although that doesn't happen to me when I export csv from Excel on the Mac, it is apparently an issue with some releases of Excel). Try saving as Windows comma separated.  Line endings can also be changed with sed, perl, or various freeware programs. 
>> 
>> Sent from my iPad
>> 
>>> On Mar 10, 2015, at 3:37 PM, Charles Nightengale <cenight22 at me.com> wrote:
>>> 
>>> Having a problem importing customer data. I have data in a excel spreadsheet that I have formatted per 18.2 of help manual. ie, a leading space in each field and one line per customer. When I import the first customer appears correct but from then on it is garbage with data taken from various lines of input.
>>> 
>>> I am using a mac.
>>> 
>>> Any thoughts?
>>> 
>>> Thanks 
>>> Charlie
>>> _______________________________________________
>>> gnucash-user mailing list
>>> gnucash-user at gnucash.org
>>> https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>> -----
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>