[Koha] batch update patrons

[Scott Owen]

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