[Koha] batch update patrons

Discussion:

Scott Owen

2018-08-14 19:29:21 UTC

Hi all,

**********************************koha info******************************
Koha version: 17.11.06.000
OS version ('uname -a'): Linux Pine 3.16.0-4-686-pae #1 SMP Debian
3.16.43-2+deb8u5 (2017-09-19) i686
Perl interpreter: /usr/bin/perl
Perl version: 5.020002
Perl @INC: /usr/share/koha/lib
/etc/perl
/usr/local/lib/i386-linux-gnu/perl/5.20.2
/usr/local/share/perl/5.20.2
/usr/lib/i386-linux-gnu/perl5/5.20
/usr/share/perl5
/usr/lib/i386-linux-gnu/perl/5.20
/usr/share/perl/5.20
/usr/local/lib/site_perl
.
MySQL version: mysql Ver 14.14 Distrib 5.5.60, for debian-linux-gnu (i686)
using readline 6.3
Apache version: Server version: Apache/2.4.10 (Debian)

****************************************************************************

I'm trying to batch update some patron info , via "Home › Tools › Batch
patron modification"

I have valid card numbers for all of my patrons (I can search and find the
card numbers) but when I try to modify by a file...
I get :

Warning, the following cardnumbers were not found:

Cardnumbers not found

and a list of my import file...

I'm using a standard CSV file for the modification...??

Any ideas where I may be going wrong here ?

-S
_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
htt

Scott Owen

2018-08-14 19:49:14 UTC

Permalink

data file looks good...no spaces, no odd characters, no leading zeros etc...
the data file is just a updated version of the patron export ...

I looked in /var/log/koha/<site> and see nothing new in any log files ..
should I be looking someplace else..??

On Tue, Aug 14, 2018 at 3:35 PM Jonathan Druart <

Hi Scott,
Make sure you do not have invisible characters at the beginning or the end
of your lines.
Otherwise check the log files.
Regards,
Jonathan

Post by Scott Owen
Hi all,
**********************************koha info******************************
Koha version: 17.11.06.000
OS version ('uname -a'): Linux Pine 3.16.0-4-686-pae #1 SMP Debian
3.16.43-2+deb8u5 (2017-09-19) i686
Perl interpreter: /usr/bin/perl
Perl version: 5.020002
/etc/perl
/usr/local/lib/i386-linux-gnu/perl/5.20.2
/usr/local/share/perl/5.20.2
/usr/lib/i386-linux-gnu/perl5/5.20
/usr/share/perl5
/usr/lib/i386-linux-gnu/perl/5.20
/usr/share/perl/5.20
/usr/local/lib/site_perl
.
MySQL version: mysql Ver 14.14 Distrib 5.5.60, for debian-linux-gnu (i686)
using readline 6.3
Apache version: Server version: Apache/2.4.10 (Debian)
****************************************************************************
I'm trying to batch update some patron info , via "Home › Tools › Batch
patron modification"
I have valid card numbers for all of my patrons (I can search and find the
card numbers) but when I try to modify by a file...
Cardnumbers not found
and a list of my import file...
I'm using a standard CSV file for the modification...??
Any ideas where I may be going wrong here ?
-S
_______________________________________________
Koha mailing list http://koha-community.org
https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://lists.k

Scott Owen

2018-08-14 19:58:09 UTC

Permalink

first line of file

cardnumber,surname,firstname,branchcode,categorycode,sex,email,sort1,sort2

the field "sex" and "sort2" are both blank.

does my data need to be "double quoted" for the csv ???

Post by Scott Owen
data file looks good...no spaces, no odd characters, no leading zeros etc...
the data file is just a updated version of the patron export ...
I looked in /var/log/koha/<site> and see nothing new in any log files ..
should I be looking someplace else..??
On Tue, Aug 14, 2018 at 3:35 PM Jonathan Druart <

Hi Scott,
Make sure you do not have invisible characters at the beginning or the
end of your lines.
Otherwise check the log files.
Regards,
Jonathan

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.n

Scott Owen

2018-08-15 12:23:23 UTC

Permalink

yep.....that's it.... :-)
Maybe I should read the directions ... and follow them....
Thank you.
-S

On Tue, Aug 14, 2018 at 4:04 PM Jonathan Druart <

The file must be a list of cardnumbers, 1 cardnumber per line, nothing
more.

Post by Scott Owen
first line of file
cardnumber,surname,firstname,branchcode,categorycode,sex,email,sort1,sort2
the field "sex" and "sort2" are both blank.
does my data need to be "double quoted" for the csv ???

Hi Scott,
Make sure you do not have invisible characters at the beginning or the
end of your lines.
Otherwise check the log files.
Regards,
Jonathan

Post by Scott Owen
Hi all,
**********************************koha
info******************************
Koha version: 17.11.06.000
OS version ('uname -a'): Linux Pine 3.16.0-4-686-pae #1 SMP Debian
3.16.43-2+deb8u5 (2017-09-19) i686
Perl interpreter: /usr/bin/perl
Perl version: 5.020002
/etc/perl
/usr/local/lib/i386-linux-gnu/perl/5.20.2
/usr/local/share/perl/5.20.2
/usr/lib/i386-linux-gnu/perl5/5.20
/usr/share/perl5
/usr/lib/i386-linux-gnu/perl/5.20
/usr/share/perl/5.20
/usr/local/lib/site_perl
.
MySQL version: mysql Ver 14.14 Distrib 5.5.60, for debian-linux-gnu (i686)
using readline 6.3
Apache version: Server version: Apache/2.4.10 (Debian)
****************************************************************************
I'm trying to batch update some patron info , via "Home › Tools › Batch
patron modification"
I have valid card numbers for all of my patrons (I can search and find the
card numbers) but when I try to modify by a file...
Cardnumbers not found
and a list of my import file...
I'm using a standard CSV file for the modification...??
Any ideas where I may be going wrong here ?
-S
_______________________________________________
Koha mailing list http://koha-community.org
https://lists.katipo.co.nz/mailman/listinfo/koha

_______________________________________________
Koha mailing list http://koha-community.org
***@lists.katipo.co.nz
https://lists.katip