I've also used notepad++ to fix this issue in the past. Another similar issue to watch for is UTF-8 byte order marks: Koha doesn't like them, at least in our environment, and Notepad++ can clear those out, too.
Joel Coehoorn Director of Information Technology 402.363.5603 *[email protected] <[email protected]>* *Please contact [email protected] <[email protected]> for technical assistance.* The mission of York College is to transform lives through Christ-centered education and to equip students for lifelong service to God, family, and society On Tue, Apr 2, 2019 at 3:32 PM Chris Brown <[email protected]> wrote: > 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 <[email protected]> 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 < > > [email protected]> > > 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, [email protected] > > > 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 > > [email protected] > > https://lists.katipo.co.nz/mailman/listinfo/koha > > > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
