Re: [Koha] Problem uploading patrons

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


Re: [Koha] Problem uploading patrons

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


Re: [Koha] Problem uploading patrons

2019-04-03 Thread Holger Meissner
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 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 
Software Manager
Fenway Library Organization
550 Huntington Ave.
Boston, MA 02115
617-989-5032
___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz 
https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Problem uploading patrons

2019-04-03 Thread Holger Meissner
Hi Paul,

you can use SciTE.

View > End of Line
Options > Line End Characters
Options > Convert Line End Characters

https://en.wikipedia.org/wiki/SciTE

Regards,
Holger

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


Re: [Koha] Problem uploading patrons

2019-04-03 Thread Paul Hoffman
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 
Software Manager
Fenway Library Organization
550 Huntington Ave.
Boston, MA 02115
617-989-5032
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Problem uploading patrons

2019-04-02 Thread 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
*jcoeho...@york.edu *

*Please contact helpd...@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  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  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_hernan...@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_hernan...@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@lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
> >
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Problem uploading patrons

2019-04-02 Thread Chris Brown
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  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_hernan...@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_hernan...@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@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Problem uploading patrons

2019-04-02 Thread 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  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_hernan...@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_hernan...@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@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Problem uploading patrons

2019-04-02 Thread Elaine Bradtke
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 
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_hernan...@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@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Problem uploading patrons

2015-06-02 Thread Hernandez, Heather
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_hernan...@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@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Problem uploading patrons

2015-06-02 Thread Elaine Bradtke
Interesting question, but I don't think it's the problem She's running a
fairly recent version of Windows.  Probably the same version of Windows
that her colleague is using who successfully uploaded the file. Still, I'll
ask.
 I tested it via a windows emulator running XP (I know, but I only use
Windows for legacy database software) and had no problem with it.  We've
never had trouble with other CSV files. I suspect operator error somewhere,
but because we're not in the same room (or country for that matter) it's
hard for me to see where she's going wrong.
The complicated step is converting the file from the membership database to
the correct format for Koha.  She did that perfectly. It's odd that she
stumbled at the final hurdle.

On Fri, May 29, 2015 at 12:25 AM, Mark Tompsett 
wrote:

> Greetings,
>
> I'm curious if this is a windows/linux CR/LF issue?
> 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, 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 using her login
> (just to make sure it isn't her account).  I'm thinking it may be something
> local to her computer. The file, and the permissions on her account seem to
> be just fine.
>



-- 
Elaine Bradtke
Data Wrangler
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
---
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Problem uploading patrons

2015-05-28 Thread Mark Tompsett

Greetings,

I'm curious if this is a windows/linux CR/LF issue?
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, 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 using her login
(just to make sure it isn't her account).  I'm thinking it may be something
local to her computer. The file, and the permissions on her account seem to
be just fine. 


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Problem uploading patrons

2015-05-28 Thread Elaine Bradtke
​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 using her login
(just to make sure it isn't her account).  I'm thinking it may be something
local to her computer. The file, and the permissions on her account seem to
be just fine.

On Thu, May 28, 2015 at 11:43 PM, Robin Sheat  wrote:

> Elaine Bradtke schreef op do 28-05-2015 om 23:38 [+0100]:
> > But whenever she tries she
> > gets a long string of error messages that boil down to Koha not
> > parsing the
> > header row.
>
> Is she doing something funny to the file before importing? Like getting
> it, opening it, and resaving it?
>
> --
> Robin Sheat
> Catalyst IT Ltd.
> ✆ +64 4 803 2204
> GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>


-- 
Elaine Bradtke
Data Wrangler
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
---
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] Problem uploading patrons

2015-05-28 Thread Robin Sheat
Elaine Bradtke schreef op do 28-05-2015 om 23:38 [+0100]:
> But whenever she tries she
> gets a long string of error messages that boil down to Koha not
> parsing the
> header row.

Is she doing something funny to the file before importing? Like getting
it, opening it, and resaving it?

-- 
Robin Sheat
Catalyst IT Ltd.
✆ +64 4 803 2204
GPG: 5FA7 4B49 1E4D CAA4 4C38  8505 77F5 B724 F871 3BDF


signature.asc
Description: This is a digitally signed message part
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


[Koha] Problem uploading patrons

2015-05-28 Thread Elaine Bradtke
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 whenever she tries she
gets a long string of error messages that boil down to Koha not parsing the
header row.

I've asked her to clear her browser (Firefox)  history and cookies (there's
an 8 hour time difference so I won't know if this works til tomorrow)
 Other than that I don't know why she can't do it and we can.

Any ideas what might be causing the problem?
-- 
Elaine Bradtke
Data Wrangler
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
---
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha