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@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@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@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