[Koha] Problem in importing Patron Records
Sunil Kumar
sunil.kumar at ecoleglobal.com
Thu Jul 26 21:29:58 NZST 2012
Dear Prajeesh,
Try to de-active the mandatory field (BorrowerMandatoryField) in patron
category in Global Preference and remove all the fields.
Then try to upload the patron CSV files.
But make sure that patron category code and branch code of the library is
matching in Koha as per the CSV file.
Best of luck
Thanks and Regards
R Sunil Kumar
Library Technologist
-----Original Message-----
From: koha-bounces at lists.katipo.co.nz
[mailto:koha-bounces at lists.katipo.co.nz] On Behalf Of
koha-request at lists.katipo.co.nz
Sent: 06 June 2012 05:30
To: koha at lists.katipo.co.nz
Subject: Koha Digest, Vol 80, Issue 11
Send Koha mailing list submissions to
koha at lists.katipo.co.nz
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.katipo.co.nz/mailman/listinfo/koha
or, via email, send a message with subject or body 'help' to
koha-request at lists.katipo.co.nz
You can reach the person managing the list at
koha-owner at lists.katipo.co.nz
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha digest..."
Today's Topics:
1. Unable to input MARC field (Stew Wilson)
2. Problem in importing Patron Records (Prajeesh)
3. Re: CAS Server/koha (Matthias Meusburger)
4. Re: Problem in importing Patron Records (Paul)
----------------------------------------------------------------------
Message: 1
Date: Tue, 5 Jun 2012 13:34:54 +0800
From: Stew Wilson <stewartrwilson at gmail.com>
To: koha at lists.katipo.co.nz
Subject: [Koha] Unable to input MARC field
Message-ID:
<CAACR0DFK1bA=m=Q1mhppAjPFL00ZmC8za17bgV9iu9x=e8xYow at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1
Hi Everyone,
I'm very much a Koha newbie, so sorry if it's a silly question:
I have made myself a customised MARC framework. During this process I
accidentally deleted tag 260. So I added it again as a new tag and just
copied the details from the default framework. So now when I go into the
edit record screen of a book I can see tag 260, but I can't add any
information to it. I can see a cursor in each subfield, but I can't type
anything into it.
I guess this is something to do with authorities, but sadly I have no idea
if this is true, or how to fix it.
Is anyone able to point me in the right direction?
Cheers,
Stew
------------------------------
Message: 2
Date: Tue, 5 Jun 2012 15:09:19 +0530
From: Prajeesh <prajeeshb77 at gmail.com>
To: Koha <Koha at lists.katipo.co.nz>
Subject: [Koha] Problem in importing Patron Records
Message-ID:
<CAD=TC1quA1tsEA4teLQY+=xJieeZo7NGK8LwR73Q0PXtysZU1w at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
Dear all
I tried to import a .csv file to my Koha installation (version 3.06.01.000)
and got the following errors. I have checked the Branch code and the
Category Code. It is give correct in the .csv file. Is there any bug
reported in this version regarding patron import. Please help me. The .csv
file is attached.
Import Patrons Import results :
- 0 imported records
- 0 overwritten
- 0 not imported because already in borrowers table and overwrite
disabled
- 2 not imported because they are not in the expected format
- 2 records parsed
- Back to Tools<http://192.168.1.2:8000/cgi-bin/koha/tools/tools-home.pl>
Feedback:
- Parsing upload file patron_import BPT2011 (copy).csv
- Content-Type : text/csv
- Content-Disposition : form-data; name="uploadborrowers";
filename="patron_import BPT2011 (copy).csv"
- headerrow :
Error analysis:
- Header row could not be parsed
- Line 2 could not be parsed!
"BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT"
"22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05"
- Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF;
surname: UNDEF).
"BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT"
"22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05"
- Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF;
surname: UNDEF).
"BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT"
"22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05"
- Line 3 could not be parsed!
"BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT"
"22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06"
- Line 3 Critical field "categorycode" missing (borrowernumber: UNDEF;
surname: UNDEF).
"BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT"
"22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06"
- Line 3 Critical field "branchcode" missing (borrowernumber: UNDEF;
surname: UNDEF).
"BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT"
"22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06"
--
With Regards
Prajeesh Bhaskaran
Mahatma Gandhi University Library
Kottayam, Kerala- 686 560
http://kerala-lis.blogspot.com/.
------------------------------
Message: 3
Date: Tue, 05 Jun 2012 10:47:22 +0100
From: Matthias Meusburger <matthias.meusburger at biblibre.com>
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] CAS Server/koha
Message-ID: <4FCDD5AA.20600 at biblibre.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Hello,
The CAS Authentication (with the casAuthentication and casServerUrl
sysprefs) only works for OPAC side at the moment.
Is it through thoses sysprefs you tried to enable CAS ?
Matthias Meusburger
Le 04/06/2012 14:08, Samuel desseaux a ?crit :
> Hi!
>
> I want to link koha to a CAS Server (only for the professionnal side).
>
> In the administration tool, it seems to be easy.
>
>
> But, does koha need specific perl modules?
>
> I've enabled mod-proxy on apache and add this part in the virtualhost
>
> <IfModule mod_proxy.c>
> ProxyRequests Off
>
> <Proxy *>
> Order Allow,Deny
> Allow from All
> AuthName "Acces Koha"
> AuthType CAS
> Require valid-user ***** * * *
> </Proxy>
>
> Beste regards
>
> samuel
>
>
> _______________________________________________
> Koha mailing list http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
------------------------------
Message: 4
Date: Tue, 05 Jun 2012 10:11:40 -0400
From: Paul <paul.a at aandc.org>
To: Koha <Koha at lists.katipo.co.nz>
Subject: Re: [Koha] Problem in importing Patron Records
Message-ID: <5.2.1.1.2.20120605100748.050f2ad8 at localhost>
Content-Type: text/plain; charset="us-ascii"; format=flowed
At 03:09 PM 6/5/2012 +0530, Prajeesh wrote:
>Dear all
>
>I tried to import a .csv file to my Koha installation (version 3.06.01.000)
>and got the following errors. I have checked the Branch code and the
>Category Code. It is give correct in the .csv file. Is there any bug
>reported in this version regarding patron import. Please help me. The .csv
>file is attached.
The file was not attached. Did you use the default Koha format for dates as
YYYY-MM-DD? From the errors, you appear to be using DD/MM/YYYY (but this
could just be your sys pref for output.)
Paul
> Import Patrons Import results :
>
> - 0 imported records
> - 0 overwritten
> - 0 not imported because already in borrowers table and overwrite
> disabled
> - 2 not imported because they are not in the expected format
> - 2 records parsed
> - Back to
Tools<http://192.168.1.2:8000/cgi-bin/koha/tools/tools-home.pl>
>
> Feedback:
>
> - Parsing upload file patron_import BPT2011 (copy).csv
> - Content-Type : text/csv
> - Content-Disposition : form-data; name="uploadborrowers";
> filename="patron_import BPT2011 (copy).csv"
> - headerrow :
>
> Error analysis:
>
> - Header row could not be parsed
> - Line 2 could not be parsed!
> "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT"
> "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05"
> - Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF;
> surname: UNDEF).
> "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT"
> "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05"
> - Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF;
> surname: UNDEF).
> "BPT11/05" "Thomas" "Anilda " "Ms" "Kerala" 682015 "India" "MAIN" "BPT"
> "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/05"
> - Line 3 could not be parsed!
> "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT"
> "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06"
> - Line 3 Critical field "categorycode" missing (borrowernumber: UNDEF;
> surname: UNDEF).
> "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT"
> "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06"
> - Line 3 Critical field "branchcode" missing (borrowernumber: UNDEF;
> surname: UNDEF).
> "BPT11/06" "R" "Anjana " "Ms" "Kerala" 682015 "India" "MAIN" "BPT"
> "22/09/2011" "31/05/2016" "Female" 123456 "BPT11/06"
>
>
>
>--
>With Regards
>
>Prajeesh Bhaskaran
> Mahatma Gandhi University Library
>Kottayam, Kerala- 686 560
>http://kerala-lis.blogspot.com/.
>_______________________________________________
>Koha mailing list http://koha-community.org
>Koha at lists.katipo.co.nz
>http://lists.katipo.co.nz/mailman/listinfo/koha
---
Maritime heritage and history, preservation and conservation,
research and education through the written word and the arts.
<http://UltraMarine.ca>, <http://AandC.org> and <http://MarDoc.ca>
------------------------------
_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha
End of Koha Digest, Vol 80, Issue 11
************************************
More information about the Koha
mailing list