The file must be a list of cardnumbers, 1 cardnumber per line, nothing more.
On Tue, 14 Aug 2018 at 16:58 Scott Owen <[email protected]> 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 <[email protected]> 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 < >> [email protected]> 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 <[email protected]> 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 >>>> [email protected] >>>> https://lists.katipo.co.nz/mailman/listinfo/koha >>>> >>> _______________________________________________ Koha mailing list http://koha-community.org [email protected] https://lists.katipo.co.nz/mailman/listinfo/koha
