[Koha] batch update patrons

[Jonathan Druart]

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 at 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 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
>>>>
>>>