[Koha] Problem uploading patrons

[Elaine Bradtke]

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 <eb at efdss.org> 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 <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
>>
>