[Koha] batch update patrons

[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 ???



On Tue, Aug 14, 2018 at 3:49 PM Scott Owen <sowen at 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 at 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 at 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 at lists.katipo.co.nz
>>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>