[Koha] Problem uploading patrons

[Chris Brown]

Hi Elaine,

If you can access a Linux command prompt on your Koha server, you could use
the command:

tr  '\r'  '\n'  <  infile  >   outfile

(replacing infile and outfile with the appropriate file names)

You might also explore the command dos2unix which will convert dos-style
lie terminators (return+linefeed) to Linux style (just linefeed)

Hope this helps.

Chris Brown




On Tue, Apr 2, 2019 at 7:36 PM Elaine Bradtke <eb at efdss.org> wrote:

> It has taken a while to figure out what caused the patron import to fail.
> The CSV file that failed has returns between each patron instead of new
> line.   Koha doesn't parse returns as new lines and so the file kept
> failing.
> Unfortunately, the software that we get the data from exports it with
> returns instead of new lines, and there's not a way to fix it on their end.
> I'd like to find a way to convert the returns to new lines so that the
> assistant librarian can do the uploads without my intervention. Excel
> doesn't seem to do the trick, unless there's a secret setting somewhere (if
> you know, do tell!).  Does Open Office work better?
>
>
> Elaine Bradtke
> VWML
> English Folk Dance and Song Society | http://www.efdss.org
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance and
> Song Society in London, England. If you wish to phone me personally, send
> an e-mail first. I work off site)
> --------------------------------------------------------------------------
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
>
>
> On Tue, Jun 2, 2015 at 8:38 AM Hernandez, Heather <
> heather_hernandez at nps.gov>
> wrote:
>
> > Hi, Elaine--
> >
> > Could she make a video of what she's doing using some tool like Jing,
> that
> > records what she's doing on her computer, to send to you?  That way she
> > could record exactly what she's doing and then send the video to you,
> which
> > might help you figure out if it's operator error or not.
> >
> > Cheerio!
> > heather
> > ~~~~~~~~~~~~~~
> > Heather Hernandez
> > Technical Services Librarian
> > San Francisco Maritime National Historical Park Research Center
> > 415-561-7032, heather_hernandez at nps.gov
> > http://www.nps.gov/safr/learn/historyculture/museum-collections.htm
> >
> > "The sailor does not pray for wind, he learns to sail."--Gustaf Lindborg
> >
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>