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 <so...@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.dru...@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 <so...@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 >>> >> _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha