[Koha] Problem uploading patrons

[Elaine Bradtke]

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 <paul at flo.org> 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 <paul at flo.org>
> Software Manager
> Fenway Library Organization
> 550 Huntington Ave.
> Boston, MA 02115
> 617-989-5032
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>