It turns out Libre Office saving as text files, give an option that allows you to choose the line termination. 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 Thu, Apr 4, 2019 at 9:19 AM Elaine Bradtke <[email protected]> wrote: > Thanks everyone for your advice - I know you can fix this with Linux or > Unix (that's how it was fixed this time around), but that's not something > the assistant librarian is able to do. We will try the other approaches. > 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 Wed, Apr 3, 2019 at 7:32 AM Paul Hoffman <[email protected]> wrote: > >> On Tue, Apr 02, 2019 at 11:36:36AM -0700, Elaine Bradtke 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? >> >> In Linux or UNIX, this command will do the trick: >> >> perl -i -p -e 'tr/\x0d/\x0a/' FILE >> >> (Option -i means "change the file in place"; _perldoc perlrun_ can help >> you understand the other options.) >> >> To do the same but keeping a backup with extension .bak: >> >> perl -i.bak -p -e 'tr/\x0d/\x0a/' FILE >> >> To copy from FILE1 to FILE2, changing CR to LF: >> >> perl -p -e 'tr/\x0d/\x0a/' < FILE1 > FILE2 >> >> Paul. >> >> -- >> Paul Hoffman <[email protected]> >> Software Manager >> Fenway Library Organization >> 550 Huntington Ave. >> Boston, MA 02115 >> 617-989-5032 >> _______________________________________________ >> 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
