Importing Customer data via csv file

[Edward Doolittle]

CSVs should be text files so you can view them with a text editor, compare
them with "diff", and so on.

On 11 March 2015 at 14:36, Charles Nightengale <cenight22 at me.com> wrote:

> Not sure how to do that. When I open the files they are in spreadsheet
> format. What could I use to look at the raw files?
>
> Cheers,
> Charlie
>
>
> On Mar 11, 2015, at 2:28 PM, Edward Doolittle <edward.doolittle at gmail.com>
> wrote:
>
> 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.
>
>
>


-- 
Edward Doolittle
Associate Professor of Mathematics
First Nations University of Canada
1 First Nations Way, Regina SK S4S 7K2

« Toutes les fois que je donne une place vacante, je fais cent mécontents
et un ingrat. »
-- Louis XIV, dans Voltaire, Le Siècle de Louis XIV, Chap. XXVI