[Koha] Problem uploading patrons

[Alvaro Cornejo]

Hi Elaine

You can use a text editor like Notepad++ to edit the file and remove the
returns.

Once you open the file go to replace and choose extended, search for \r\n
and choose replace by \n.

"\r" is the return and "\n" is new line.

Then save as csv file and try to upload it again.

Regards,

Alvaro




|-----------------------------------------------------------------------------------------------------------------|
Envíe y Reciba Datos y mensajes de Texto (SMS) hacia y desde cualquier
celular y Nextel
en el Perú, México y en mas de 180 paises. Use aplicaciones 2 vias via SMS
y GPRS online
              Visitenos en www.perusms.com


Le mar. 2 avr. 2019 à 13:37, Elaine Bradtke <eb at efdss.org> a écrit :

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