[Koha] Patron Import via csv file (SATISH)

Tue Feb 10 13:31:13 NZDT 2015

The import csv must contain the attributes you wish to load in the patron record from the columns in the manual: http://manual.koha-community.org/3.16/en/tools.html#patronimport

Column categorycode must match the categorycode corresponding to the patron attribute in http://manual.koha-community.org/3.16/en/patscirc.html#patcats. You must also match the branchcode if you have more than one library.

Special attributes must match a corresponding column titled patron_attributes.  In that column the attribute is listed with the CODE followed by a colon and then the value.  Each attribute is separated by a comma.
Example:
patron_attributes
ID:22222,GRAD:2015,CLASS:SENIOR

Hope this helps. 

Rebecca Crago
Systems and Teaching Librarian
Mercyhurst University
Erie, PA
http://library.mercyhurst.edu

________________________________________
From: Koha [koha-bounces at lists.katipo.co.nz] on behalf of koha-request at lists.katipo.co.nz [koha-request at lists.katipo.co.nz]
Sent: Monday, February 09, 2015 6:00 PM
To: koha at lists.katipo.co.nz
Subject: Koha Digest, Vol 112, Issue 19

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. slow processing (Sandra Busutel)
   2. Re: Patron Import via csv file (SATISH)
   3. Koha web installation page downloading (Admire Mutsikiwa)
   4. Re: Testing to move a koha 3.08 system to 3.18, on Debian.
      (Howard Fleming)
   5. Re: Koha web installation page downloading (Chris Cormack)

----------------------------------------------------------------------

Message: 1
Date: Mon, 9 Feb 2015 10:07:39 +1100
From: Sandra Busutel <sbusutel at stpeters.nsw.edu.au>
To: koha at lists.katipo.co.nz
Subject: [Koha] slow processing
Message-ID:
        <CAPBObDrzZtm3uCfsHA2BWLUVB9WjbiBxdJozCLxQvcUak_FX0Q at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8

Hi
It takes up to 6 seconds for our students to borrow but our staff borrowing
takes upto 15-20  seconds per item. Can anyone suggest why this is so slow.
Sandra

Mrs Sandra Busutel
Director of Information Services
sbusutel at stpeters.nsw.edu.au <Email%3Asbusutel at stpeters.nsw.edu.au>

--

5 Howe Street, Campbelltown NSW 2560 *| *PO Box 997, Campbelltown NSW 2560
02 4627 2990 *| *administration at stpeters.nsw.edu.au *| *
www.stpeters.nsw.edu.au

Disclaimer: The contents of this email may be confidential and is intended
for the addressee only.
Any unauthorised use of the contents is prohibited. If you have received
the document in error,
please contact the sender by telephone immediately on 02 4627 2990 and then
destroy the email.
St. Peter's Anglican Primary School do not permit unauthorised use or
copying of the email or its contents.

------------------------------

Message: 2
Date: Mon, 9 Feb 2015 11:24:22 +0530
From: SATISH <lis4satish at gmail.com>
To: Sean Monaghen <smonaghen at usd259.net>
Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
Subject: Re: [Koha] Patron Import via csv file
Message-ID:
        <CAJkM6UEkziF2YZAzr-+7U-nUa=fqAqiCB9-uEObKP+YRA9qdLg at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8

Hi Sean,

You could copy and paste card number and patron's sir name,
branch code, patron category, date enrolled, date expired, information from
source file to patron_import.csv and when you try to open csv file with
LibreOfficeCalc, cross check,
the Separator Options ..Tab and Comma are not selected. So that, preview
would be comma separated and if you do not have borrowernumber informaiton,
you can delete that entire column in the csv file.

with thanks,

Satish
Librarian
GEC Hassan.
Karnataka.

On Thu, Feb 5, 2015 at 8:49 PM, Sean Monaghen <smonaghen at usd259.net> wrote:

> I can not seem to import patrons even using the provided blank file and
> adding one person to the file.  Below is the output. Attached is the cvs
> file I am trying to import.
> _______________________________________________
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>

--

------------------------------

Message: 3
Date: Mon, 9 Feb 2015 16:26:34 +0200
From: "Admire Mutsikiwa" <amutsikiwa at uzlib.uz.ac.zw>
To: <koha at lists.katipo.co.nz>
Subject: [Koha] Koha web installation page downloading
Message-ID: <014501d04474$68552510$38ff6f30$@uzlib.uz.ac.zw>
Content-Type: text/plain;       charset="us-ascii"

Hi

I have installed Koha 3.18.03 on Ubuntu using the tarball. When I try to
access the web-based  page http://hostname:8080 , instead of presenting the
web page, the page is downloading. I cannot figure out what the issue.

Kind Regards,

Admire Mutsikiwa (Mr)

ICT Manager

Libraries

University of Zimbabwe

Tel:+263-4-303276

Mob:+263782476883

"It is easy to dodge our responsibilities, but we cannot dodge the
consequences of dodging our responsibilities."  Josiah Charles Stamp
<http://www.goodreads.com/author/show/4867406.Josiah_Charles_Stamp>

------------------------------

Message: 4
Date: Mon, 09 Feb 2015 11:44:18 -0500
From: Howard Fleming <hfleming at mei.edu>
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] Testing to move a koha 3.08 system to 3.18, on
        Debian.
Message-ID: <54D8E3E2.5060402 at mei.edu>
Content-Type: text/plain; charset=utf-8; format=flowed

Just  a quick note to let you know your instructions on upgrading/moving
the system seems to have fixed the problem I was running into, thanks!

Howard

On 02/03/2015 05:43 PM, Robin Sheat wrote:
> Robin Sheat schreef op wo 04-02-2015 om 11:36 [+1300]:
>> * Make sure you've reindexed everything: sudo koha-rebuild-zebra -f
>> -v
> And by that, I actually mean:
> sudo koha-rebuild-zebra -f -v instancename
>

------------------------------

Message: 5
Date: Tue, 10 Feb 2015 08:23:51 +1300
From: Chris Cormack <chrisc at catalyst.net.nz>
To: Admire Mutsikiwa <amutsikiwa at uzlib.uz.ac.zw>
Cc: koha at lists.katipo.co.nz
Subject: Re: [Koha] Koha web installation page downloading
Message-ID: <20150209192351.GE26338 at rorohiko.wgtn.cat-it.co.nz>
Content-Type: text/plain; charset=us-ascii

* Admire Mutsikiwa (amutsikiwa at uzlib.uz.ac.zw) wrote:
> Hi
>
>
>
> I have installed Koha 3.18.03 on Ubuntu using the tarball. When I try to
> access the web-based  page http://hostname:8080 , instead of presenting the
> web page, the page is downloading. I cannot figure out what the issue.
>
>
>
Hi Admire

Id recommend the packages on Ubuntu, but that is a separate thing,
the fix for your issue is

http://wiki.koha-community.org/wiki/Koha_on_Debian#Troubleshooting_Ubuntu_14.04

The third one there
sudo a2enmod cgi
sudo service apache2 restart

Chris
--
Chris Cormack
Catalyst IT Ltd.
+64 4 803 2238
PO Box 11-053, Manners St, Wellington 6142, New Zealand

------------------------------

Subject: Digest Footer

_______________________________________________
Koha mailing list
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha

------------------------------

End of Koha Digest, Vol 112, Issue 19
*************************************