[Koha] Problem uploading patrons

[Coehoorn, Joel]

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
*jcoehoorn at york.edu <jcoehoorn at york.edu>*

*Please contact helpdesk at york.edu <helpdesk at york.edu> 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 <chris at stayawake.co.uk> 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 <eb at 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 at 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 at 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 at lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>