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
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
Sorry Paul, I meant: Hi Elaine.
-Ursprüngliche Nachricht-
Von: Koha Im Auftrag von Paul Hoffman
Gesendet: Mittwoch, 3. April 2019 16:32
An: koha@lists.katipo.co.nz
Betreff: Re: [Koha] Problem uploading patrons
On Tue, Apr 02, 2019 at 11:36:36AM -0700, Elaine Bradtke wrote:
> It
An: koha@lists.katipo.co.nz
Betreff: Re: [Koha] Problem uploading patrons
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
> li
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.
>
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
*jcoeho...@york.edu *
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
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,
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
?
Are the files the identical size? If not, then this might be a possibility.
GPML,
Mark Tompsett
-Original Message- From: Elaine Bradtke
Sent: Thursday, May 28, 2015 6:58 PM
To: Robin Sheat
Cc: koha
Subject: Re: [Koha] Problem uploading patrons
We get an export from our membership database
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.
We're running 3.18.04.
One (and only one) of my colleagues is unable to upload patron files. It's
very curious, she has all the permissions, and I and another colleague have
uploaded the same file without a problem. I have even logged into her
account and uploaded the file successfully. But
] Problem uploading patrons
We get an export from our membership database, run it through some batch
edits in another piece of software that spits out a .CSV file with the
proper headers. The .CSV file she sent me is the one she tried to use.
It works fine for me, and another colleague, and for me
13 matches
Mail list logo