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 <e...@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_hernan...@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_hernan...@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@lists.katipo.co.nz > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha