batch update patrons
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
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 On Tue, 14 Aug 2018 at 16:29 Scott Owen <sowen@edzone.net> wrote:
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 Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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 < jonathan.druart@bugs.koha-community.org> wrote:
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
On Tue, 14 Aug 2018 at 16:29 Scott Owen <sowen@edzone.net> wrote:
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 Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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 ??? On Tue, Aug 14, 2018 at 3:49 PM Scott Owen <sowen@edzone.net> wrote:
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 < jonathan.druart@bugs.koha-community.org> wrote:
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
On Tue, 14 Aug 2018 at 16:29 Scott Owen <sowen@edzone.net> wrote:
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 Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
The file must be a list of cardnumbers, 1 cardnumber per line, nothing more. On Tue, 14 Aug 2018 at 16:58 Scott Owen <sowen@edzone.net> wrote:
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 ???
On Tue, Aug 14, 2018 at 3:49 PM Scott Owen <sowen@edzone.net> wrote:
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 < jonathan.druart@bugs.koha-community.org> wrote:
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
On Tue, 14 Aug 2018 at 16:29 Scott Owen <sowen@edzone.net> wrote:
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 Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
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 < jonathan.druart@bugs.koha-community.org> wrote:
The file must be a list of cardnumbers, 1 cardnumber per line, nothing more.
On Tue, 14 Aug 2018 at 16:58 Scott Owen <sowen@edzone.net> wrote:
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 ???
On Tue, Aug 14, 2018 at 3:49 PM Scott Owen <sowen@edzone.net> wrote:
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 < jonathan.druart@bugs.koha-community.org> wrote:
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
On Tue, 14 Aug 2018 at 16:29 Scott Owen <sowen@edzone.net> wrote:
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 Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
participants (2)
-
Jonathan Druart -
Scott Owen