[Koha] K-12 Users

Sunil Kumar sunil.kumar at ecoleglobal.com
Thu Nov 22 17:42:38 NZDT 2012


Dear Jeremy, 

For K-12 Koha is easy to use especially if you activate the opac enhancer
and display book images and all those things.. students can relate their
search very fast and even you can train senior students to use "Tags" and
"Comments" option; student will love these feature. 

For any technical help please send email to sunil.kumar at ecoleglobal.com /
info at ecoleglobal.com 

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: 22 November 2012 10:07
To: koha at lists.katipo.co.nz
Subject: Koha Digest, Vol 85, Issue 36

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. Re: K-12 Users (Scott Owen)
   2. Re: Problem in importing Patron Records (Sunil Kumar)


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

Message: 1
Date: Wed, 21 Nov 2012 18:04:27 -0500
From: "Scott Owen" <sowen at edzone.net>
To: koha at lists.katipo.co.nz
Subject: Re: [Koha] K-12 Users
Message-ID: <50AD17AA.D5C1.000C.1 at edzone.net>
Content-Type: text/plain; charset=utf-8

We have been using Koha for 3-4? years.
Works great.....we currently use it in one 4-5 grade building, but plan on
moving our HS and MS to it as well.
http://koha.almaschools.net/
Almost no issues.....every now and then I have to run a "rebuild" when
biblios get deleted out of the database.... other than that.....it's truly
plug it and forget it (and I could probably CRON that rebuild....but I just
never get around to it).

Feel free to contact me off list if you would like.
http://www.almaschools.net/district/technology/current-technology-staff/




>>> Jeremy Wellner<jwellner at stanwood.wednet.edu> 11/21/2012 2:34 PM >>>
Hello!

I am looking for some feedback from users who have Koha and are using it in
a K12 environment.  We are evaluating the option to see if it would be
suitable for our environment.

Any feedback at all would be welcome!

Thanks!

Jeremy Wellner
Technology Group
Stanwood-Camano School District
jwellner at stanwood.wednet.edu

Internal: x4357
External: 360-629-1205
Cell: 425-418-4972

?We?re here to put a dent in the universe. Otherwise why else even be here??
-Steve Jobs

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


-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2013.0.2793 / Virus Database: 2629/5910 - Release Date: 11/21/12

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

Message: 2
Date: Thu, 22 Nov 2012 10:06:58 +0530
From: "Sunil Kumar" <sunil.kumar at ecoleglobal.com>
To: <koha at lists.katipo.co.nz>
Subject: Re: [Koha] Problem in importing Patron Records
Message-ID: <000301cdc86b$050a4f30$0f1eed90$@kumar at ecoleglobal.com>
Content-Type: text/plain;	charset="us-ascii"

Dear Elaine

Can you share the patron excel file and also check the under system
configuration "BorrowerMandatoryField" which are the fields mandatory, for
uploading purpose you can remove those mandatory fields and try uploading
the patron records. Regarding the borrowernumber, What i used to do is
manually enter the borrowernumber (use the excel feature of auto numbering).


Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname:
UNDEF). > If Surname is mandatory field and any one row is missing the
surname data, Koha will show error. 
Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF; surname:
UNDEF). - check the branchcode in the .CSV file and the branchcode you have
defined in Koha, if both are not matching it will show error or if .CSV have
a new branch code it will again show you error. 
Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF;
surname: UNDEF). = same as branchcode error - you have not defined the
catagorycode in the Koha setting. 

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: 22 November 2012 04:22
To: koha at lists.katipo.co.nz
Subject: Koha Digest, Vol 85, Issue 35

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. Re: Problem in importing Patron Records (Elaine Bradtke)
   2. Re: Problem in importing Patron Records (Elaine Bradtke)
   3. Re: [Koha-devel] ldap / uid (Travis Elliott Davis)
   4. Re: Problem in importing Patron Records (Elaine Bradtke)
   5. Re: Problem in importing Patron Records (Elaine Bradtke)


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

Message: 1
Date: Wed, 21 Nov 2012 20:22:18 +0000
From: Elaine Bradtke <eb at efdss.org>
To: Quoc Uy <nguyenquocuy_1102 at yahoo.com>
Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
Subject: Re: [Koha] Problem in importing Patron Records
Message-ID:
	<CAPdfUuxghmzrirryi1PvjXR1ZWfxuKmZQ4hOkfNnk2o-JhXiXw at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Are you saying there should be quotes around the fields?
Because I'm getting similar failures and the fields are there, but it's not
seeing them.
Elaine

On Tue, Nov 20, 2012 at 9:45 PM, Quoc Uy <nguyenquocuy_1102 at yahoo.com>
wrote:
>      First, i have problem with this, too. I downloaded original file
patron_import.csv, opened it with Libreoffice Calc, watched table borrowers
in database by Phpmyadmin. Then i tried to fill all file with the similar
values as what i did before (add patron manual). Next i saved file as .csv
file, and tried import patron. I failed with message: "Line 2 Critical field
"surname" missing (borrowernumber: UNDEF; surname: UNDEF)"...
>     Next i tried to change fomats all fields in their fomats (text, 
> number, date), esspecially date YYY-MM-DD. Then i saved file as .csv 
> file,
and tried import patron. I failed with message: "Line 2 Critical field
"surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... (same error)
>     I saved .csv file as .ods file, and tried import, once more time fail.
>
>     Last time, maybe i was lucky, i use that.ods file, saved as .csv 
> file,
then i received a message:
>
> Export text file...
>
> field delimiter   ,
> text delimiter   "
>  I press Ok, then saved. And i imported patrons without error.
> I don't understand it very clear, but just wanna share experience. 
> Hope it
can help someone else.
> _______________________________________________
> Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz 
> http://lists.katipo.co.nz/mailman/listinfo/koha



--
Elaine Bradtke
Data Wrangler
VWML
English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp
House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance
and Song Society in London, England. If you wish to phone me personally,
send an e-mail first. I work off site)
--------------------------------------------------------------------------
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---------------------------------------------------------------------------
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)


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

Message: 2
Date: Wed, 21 Nov 2012 20:30:42 +0000
From: Elaine Bradtke <eb at efdss.org>
To: Quoc Uy <nguyenquocuy_1102 at yahoo.com>
Cc: "koha at lists.katipo.co.nz" <koha at lists.katipo.co.nz>
Subject: Re: [Koha] Problem in importing Patron Records
Message-ID:
	<CAPdfUuxbF+_wYiz-RE2+6a0T6qhCAhD4bkTJAW40HyNDoLyk+w at mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

Here's what I'm getting (in 3.08.05):
Feedback:

Parsing upload file Patron upload test2.csv
Content-Type : application/octet-stream
Content-Disposition : form-data; name="uploadborrowers";
filename="Patron upload test2.csv"
headerrow : CARDNUMBER, SURNAME, FIRSTNAME, TITLE, INITIALS, ADDRESS,
ADDRESS2, CITY, ZIPCODE, COUNTRY, EMAIL, PHONE, BRANCHCODE,
CATEGORYCODE, DATEEXPIRY


Error analysis:

Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname:
UNDEF).
Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF;
surname: UNDEF).
Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF;
surname: UNDEF).

It's all there.
Is Koha expecting the fields in a particular order? I'm supplying the
header row (above). But it's not connecting the two somehow. I have
tried with and without quotes around the fields, neither seems to
work.
Elaine

On Wed, Nov 21, 2012 at 8:22 PM, Elaine Bradtke <eb at efdss.org> wrote:
> Are you saying there should be quotes around the fields?
> Because I'm getting similar failures and the fields are there, but
> it's not seeing them.
> Elaine
>
> On Tue, Nov 20, 2012 at 9:45 PM, Quoc Uy <nguyenquocuy_1102 at yahoo.com>
wrote:
>>      First, i have problem with this, too. I downloaded original file
patron_import.csv, opened it with Libreoffice Calc, watched table borrowers
in database by Phpmyadmin. Then i tried to fill all file with the similar
values as what i did before (add patron manual). Next i saved file as .csv
file, and tried import patron. I failed with message: "Line 2 Critical field
"surname" missing (borrowernumber: UNDEF; surname: UNDEF)"...
>>     Next i tried to change fomats all fields in their fomats (text,
number, date), esspecially date YYY-MM-DD. Then i saved file as .csv file,
and tried import patron. I failed with message: "Line 2 Critical field
>> "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... (same
error)
>>     I saved .csv file as .ods file, and tried import, once more time
fail.
>>
>>     Last time, maybe i was lucky, i use that.ods file, saved as .csv
file, then i received a message:
>>
>> Export text file...
>>
>> field delimiter   ,
>> text delimiter   "
>>  I press Ok, then saved. And i imported patrons without error.
>> I don't understand it very clear, but just wanna share experience. Hope
it can help someone else.
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>
> --
> Elaine Bradtke
> Data Wrangler
> VWML
> English Folk Dance and Song Society | http://www.efdss.org
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance
> and Song Society in London, England. If you wish to phone me
> personally, send an e-mail first. I work off site)
> --------------------------------------------------------------------------
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
>
---------------------------------------------------------------------------
> "Writing about music is like dancing about architecture"
> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)



-- 
Elaine Bradtke
Data Wrangler
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance
and Song Society in London, England. If you wish to phone me
personally, send an e-mail first. I work off site)
--------------------------------------------------------------------------
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---------------------------------------------------------------------------
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)


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

Message: 3
Date: Wed, 21 Nov 2012 07:49:20 -0600
From: Travis Elliott Davis <elliott at bywatersolutions.com>
To: Samuel Desseaux <samuel.desseaux at ecp.fr>
Cc: Koha Devel <koha-devel at lists.koha-community.org>,
	"Koha at lists.katipo.co.nz" <Koha at lists.katipo.co.nz>
Subject: Re: [Koha] [Koha-devel] ldap / uid
Message-ID:
	<28B78772-DE99-4F1A-9AA7-4A733AD987AF at bywatersolutions.com>
Content-Type: text/plain; charset=iso-8859-1

Samuel,

If you want to map the userid field in Koha to "SupannAliasLogin" from your
ldap configuration simply change <userid is="uid"></userid> to <userid
is="SupannAliasLogin"></userid>.

If you are asking how to bind on SupannAliasLogin you should be able to
perform the step above and in the principal name field just enter %s and
nothing else.  That will try and bind on the username without joining any
other strings.

Best,


Travis Elliott Davis
Development Support Specialist
903.571.4257
Elliott at ByWaterSolutions.com



On Nov 21, 2012, at 3:34 AM, Samuel Desseaux <samuel.desseaux at ecp.fr> wrote:

> Hi,
> 
> I've a technical question about ldap.
> 
> My connexion with the ldap is enabled. The mapping is correct but we would
like to use "SupannAliasLogin" instead of "uid".
> Why? Our uid is  like this  [year of entry in the school]+supannAliasLogin
> 
> example:2012desseauxs
> 
> 2012:year of entry in the school
> desseauxs:SupannAliasLogin
> 
> 
> I don't know how to do and i i have to change the principal name
> 
> Actually, we have the following configuration
> 
> <ldapserver id="ldapserver" listenref="ldapserver">
> <hostname>*******</hostname>
> <base>ou=people,dc=ecp,dc=fr</base>
> <user>cn=syncrepl,ou=applications,dc=ecp,dc=fr</user>
> <pass>******</pass>
> <replicate>1</replicate>
> <update>1</update>
> <auth_by_bind>1</auth_by_bind>
> <principal_name>uid=%s,ou=people,dc=ecp,dc=fr</principal_name>
> <mapping>
> <firstname is="givenname"></firstname>
> <surname is="sn"></surname>
> <address is="">Ecole Centrale Paris</address>
> <city is="">Chatenay-Malabry</city>
> <zipcode is="">92290</zipcode>
> <branchcode is="">ECAM</branchcode>
> <userid is="uid"></userid>
> <password is="userpassword"></password>
> <cardnumber is="ecpbadgenumber"></cardnumber>
> <email is="mail"></email>
> <categorycode is="supannetudiplome">employee</categorycode>
> <phone is="telephonenumber">903-566-7654</phone>
> <dateenrolled is="">2012-09-01</dateenrolled>
> <dateexpiry is="">2013-09-01</dateexpiry>
> </mapping>
> </ldapserver>
> 
> 
> Many thanks
> 
> samuel
> 
> 
> 
> 
> <samuel_desseaux.vcf>_______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/



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

Message: 4
Date: Wed, 21 Nov 2012 21:06:23 +0000
From: Elaine Bradtke <eb at efdss.org>
To: Uy nguy?n qu?c <nguyenquocuy_1102 at yahoo.com>
Cc: koha <koha at lists.katipo.co.nz>
Subject: Re: [Koha] Problem in importing Patron Records
Message-ID:
	<CAPdfUuzUE5FDwmCkJ82bgCu=ubhVwTazC7O0DT1HieLcg-CEKg at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8

I have to set up a system to convert information from our membership
list into patron files on a monthly basis to catch expired
memberships. I run the file through a database called Cardbox for
batch editing. Cardbox exports have never cause any problems with csv
formatting before.
As an experiment, I ran the Cardbox csv file through (an old version
of) excel and exported a new csv file.  But it didn't help, and in
fact broke the date formatting (deleting the zero padding).

We are using the same date format as is set in our system preferences
(dd/mm/yyyy).  For some patrons there is no expiration date (life
members). Would this be a problem - are expiration dates required?
Must I convert it to yyyy-mm-dd ? (the notes on patron import seem to
imply it's OK to use your specified date format).
Elaine
On Wed, Nov 21, 2012 at 8:36 PM, Uy nguy?n qu?c
<nguyenquocuy_1102 at yahoo.com> wrote:
> So u have the same error as i had. I'm using Koha on Ubuntu. If u try to
open file with excel in windows, then save file as .csv, then import, i
think there is no error more. If u use in ubuntu, or debian, should follow
what i said before. Open .csv file with Libre Calc (it may ask for default-
seperated by semicolon and comma, choose those values), then fill it, save
as .ods file, then open .ods file, save as new .csv file. U can import this
.csv file. Good luck
> On 22 Nov 2012, at 00:30, Elaine Bradtke wrote:
>
>> Here's what I'm getting (in 3.08.05):
>> Feedback:
>>
>> Parsing upload file Patron upload test2.csv
>> Content-Type : application/octet-stream
>> Content-Disposition : form-data; name="uploadborrowers";
>> filename="Patron upload test2.csv"
>> headerrow : CARDNUMBER, SURNAME, FIRSTNAME, TITLE, INITIALS, ADDRESS,
>> ADDRESS2, CITY, ZIPCODE, COUNTRY, EMAIL, PHONE, BRANCHCODE,
>> CATEGORYCODE, DATEEXPIRY
>>
>>
>> Error analysis:
>>
>> Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname:
UNDEF).
>> Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF;
>> surname: UNDEF).
>> Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF;
>> surname: UNDEF).
>>
>> It's all there.
>> Is Koha expecting the fields in a particular order? I'm supplying the
>> header row (above). But it's not connecting the two somehow. I have
>> tried with and without quotes around the fields, neither seems to
>> work.
>> Elaine
>>
>> On Wed, Nov 21, 2012 at 8:22 PM, Elaine Bradtke <eb at efdss.org> wrote:
>>> Are you saying there should be quotes around the fields?
>>> Because I'm getting similar failures and the fields are there, but
>>> it's not seeing them.
>>> Elaine
>>>
>>> On Tue, Nov 20, 2012 at 9:45 PM, Quoc Uy <nguyenquocuy_1102 at yahoo.com>
wrote:
>>>>     First, i have problem with this, too. I downloaded original file
patron_import.csv, opened it with Libreoffice Calc, watched table borrowers
in database by Phpmyadmin. Then i tried to fill all file with the similar
values as what i did before (add patron manual). Next i saved file as .csv
file, and tried import patron. I failed with message: "Line 2 Critical field
"surname" missing (borrowernumber: UNDEF; surname: UNDEF)"...
>>>>    Next i tried to change fomats all fields in their fomats (text,
number, date), esspecially date YYY-MM-DD. Then i saved file as .csv file,
and tried import patron. I failed with message: "Line 2 Critical field
>>>> "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... (same
error)
>>>>    I saved .csv file as .ods file, and tried import, once more time
fail.
>>>>
>>>>    Last time, maybe i was lucky, i use that.ods file, saved as .csv
file, then i received a message:
>>>>
>>>> Export text file...
>>>>
>>>> field delimiter   ,
>>>> text delimiter   "
>>>> I press Ok, then saved. And i imported patrons without error.
>>>> I don't understand it very clear, but just wanna share experience. Hope
it can help someone else.
>>>> _______________________________________________
>>>> Koha mailing list  http://koha-community.org
>>>> Koha at lists.katipo.co.nz
>>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>>
>>>
>>>
>>> --
>>> Elaine Bradtke
>>> Data Wrangler
>>> VWML
>>> English Folk Dance and Song Society | http://www.efdss.org
>>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>>> Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance
>>> and Song Society in London, England. If you wish to phone me
>>> personally, send an e-mail first. I work off site)
>>>
--------------------------------------------------------------------------
>>> Registered Company No. 297142
>>> Charity Registered in England and Wales No. 305999
>>>
---------------------------------------------------------------------------
>>> "Writing about music is like dancing about architecture"
>>> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
>>
>>
>>
>> --
>> Elaine Bradtke
>> Data Wrangler
>> VWML
>> English Folk Dance and Song Society | http://www.efdss.org
>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>> Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance
>> and Song Society in London, England. If you wish to phone me
>> personally, send an e-mail first. I work off site)
>>
--------------------------------------------------------------------------
>> Registered Company No. 297142
>> Charity Registered in England and Wales No. 305999
>>
---------------------------------------------------------------------------
>> "Writing about music is like dancing about architecture"
>> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
>



-- 
Elaine Bradtke
Data Wrangler
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance
and Song Society in London, England. If you wish to phone me
personally, send an e-mail first. I work off site)
--------------------------------------------------------------------------
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---------------------------------------------------------------------------
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)


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

Message: 5
Date: Wed, 21 Nov 2012 22:51:55 +0000
From: Elaine Bradtke <eb at efdss.org>
To: Quoc Uy <nguyenquocuy_1102 at yahoo.com>
Cc: koha <koha at lists.katipo.co.nz>
Subject: Re: [Koha] Problem in importing Patron Records
Message-ID:
	<CAPdfUuz-w_zjvjfCoS=555Dgo69LFgdmnkj4zf--5SfiiWq3uQ at mail.gmail.com>
Content-Type: text/plain; charset=UTF-8

I changed the date format to YYYY-MM-DD
I also added a date to the patron records that didn't have them.
I saved it as an ods file, and then closed it opened it and saved it as csv.
None of these things worked. Same error messages.

Elaine
On Wed, Nov 21, 2012 at 9:16 PM, Quoc Uy <nguyenquocuy_1102 at yahoo.com>
wrote:
> Better give it a try. Do exactly as i say. Maybe change fotmat YYY-MM-DD.
> Because u have same error as i did.
>
>
> ________________________________
> From: Elaine Bradtke <eb at efdss.org>
> To: Uy nguy?n qu?c <nguyenquocuy_1102 at yahoo.com>
> Cc: koha <koha at lists.katipo.co.nz>
> Sent: Thursday, November 22, 2012 12:06 AM
> Subject: Re: [Koha] Problem in importing Patron Records
>
> I have to set up a system to convert information from our membership
> list into patron files on a monthly basis to catch expired
> memberships. I run the file through a database called Cardbox for
> batch editing. Cardbox exports have never cause any problems with csv
> formatting before.
> As an experiment, I ran the Cardbox csv file through (an old version
> of) excel and exported a new csv file.  But it didn't help, and in
> fact broke the date formatting (deleting the zero padding).
>
> We are using the same date format as is set in our system preferences
> (dd/mm/yyyy).  For some patrons there is no expiration date (life
> members). Would this be a problem - are expiration dates required?
> Must I convert it to yyyy-mm-dd ? (the notes on patron import seem to
> imply it's OK to use your specified date format).
> Elaine
> On Wed, Nov 21, 2012 at 8:36 PM, Uy nguy?n qu?c
> <nguyenquocuy_1102 at yahoo.com> wrote:
>> So u have the same error as i had. I'm using Koha on Ubuntu. If u try to
>> open file with excel in windows, then save file as .csv, then import, i
>> think there is no error more. If u use in ubuntu, or debian, should
follow
>> what i said before. Open .csv file with Libre Calc (it may ask for
default-
>> seperated by semicolon and comma, choose those values), then fill it,
save
>> as .ods file, then open .ods file, save as new .csv file. U can import
this
>> .csv file. Good luck
>> On 22 Nov 2012, at 00:30, Elaine Bradtke wrote:
>>
>>> Here's what I'm getting (in 3.08.05):
>>> Feedback:
>>>
>>> Parsing upload file Patron upload test2.csv
>>> Content-Type : application/octet-stream
>>> Content-Disposition : form-data; name="uploadborrowers";
>>> filename="Patron upload test2.csv"
>>> headerrow : CARDNUMBER, SURNAME, FIRSTNAME, TITLE, INITIALS, ADDRESS,
>>> ADDRESS2, CITY, ZIPCODE, COUNTRY, EMAIL, PHONE, BRANCHCODE,
>>> CATEGORYCODE, DATEEXPIRY
>>>
>>>
>>> Error analysis:
>>>
>>> Line 2 Critical field "surname" missing (borrowernumber: UNDEF; surname:
>>> UNDEF).
>>> Line 2 Critical field "branchcode" missing (borrowernumber: UNDEF;
>>> surname: UNDEF).
>>> Line 2 Critical field "categorycode" missing (borrowernumber: UNDEF;
>>> surname: UNDEF).
>>>
>>> It's all there.
>>> Is Koha expecting the fields in a particular order? I'm supplying the
>>> header row (above). But it's not connecting the two somehow. I have
>>> tried with and without quotes around the fields, neither seems to
>>> work.
>>> Elaine
>>>
>>> On Wed, Nov 21, 2012 at 8:22 PM, Elaine Bradtke <eb at efdss.org> wrote:
>>>> Are you saying there should be quotes around the fields?
>>>> Because I'm getting similar failures and the fields are there, but
>>>> it's not seeing them.
>>>> Elaine
>>>>
>>>> On Tue, Nov 20, 2012 at 9:45 PM, Quoc Uy <nguyenquocuy_1102 at yahoo.com>
>>>> wrote:
>>>>>    First, i have problem with this, too. I downloaded original file
>>>>> patron_import.csv, opened it with Libreoffice Calc, watched table
borrowers
>>>>> in database by Phpmyadmin. Then i tried to fill all file with the
similar
>>>>> values as what i did before (add patron manual). Next i saved file as
.csv
>>>>> file, and tried import patron. I failed with message: "Line 2 Critical
field
>>>>> "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"...
>>>>>    Next i tried to change fomats all fields in their fomats (text,
>>>>> number, date), esspecially date YYY-MM-DD. Then i saved file as .csv
file,
>>>>> and tried import patron. I failed with message: "Line 2 Critical field
>>>>> "surname" missing (borrowernumber: UNDEF; surname: UNDEF)"... (same
>>>>> error)
>>>>>    I saved .csv file as .ods file, and tried import, once more time
>>>>> fail.
>>>>>
>>>>>    Last time, maybe i was lucky, i use that.ods file, saved as .csv
>>>>> file, then i received a message:
>>>>>
>>>>> Export text file...
>>>>>
>>>>> field delimiter  ,
>>>>> text delimiter  "
>>>>> I press Ok, then saved. And i imported patrons without error.
>>>>> I don't understand it very clear, but just wanna share experience.
Hope
>>>>> it can help someone else.
>>>>> _______________________________________________
>>>>> Koha mailing list  http://koha-community.org
>>>>> Koha at lists.katipo.co.nz
>>>>> http://lists.katipo.co.nz/mailman/listinfo/koha
>>>>
>>>>
>>>>
>>>> --
>>>> Elaine Bradtke
>>>> Data Wrangler
>>>> VWML
>>>> English Folk Dance and Song Society | http://www.efdss.org
>>>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>>>> Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance
>>>> and Song Society in London, England. If you wish to phone me
>>>> personally, send an e-mail first. I work off site)
>>>>
>>>>
--------------------------------------------------------------------------
>>>> Registered Company No. 297142
>>>> Charity Registered in England and Wales No. 305999
>>>>
>>>>
---------------------------------------------------------------------------
>>>> "Writing about music is like dancing about architecture"
>>>> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
>>>
>>>
>>>
>>> --
>>> Elaine Bradtke
>>> Data Wrangler
>>> VWML
>>> English Folk Dance and Song Society | http://www.efdss.org
>>> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
>>> Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance
>>> and Song Society in London, England. If you wish to phone me
>>> personally, send an e-mail first. I work off site)
>>>
>>>
--------------------------------------------------------------------------
>>> Registered Company No. 297142
>>> Charity Registered in England and Wales No. 305999
>>>
>>>
---------------------------------------------------------------------------
>>> "Writing about music is like dancing about architecture"
>>> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
>>
>
>
>
> --
> Elaine Bradtke
> Data Wrangler
> VWML
> English Folk Dance and Song Society | http://www.efdss.org
> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
> Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance
> and Song Society in London, England. If you wish to phone me
> personally, send an e-mail first. I work off site)
> --------------------------------------------------------------------------
> Registered Company No. 297142
> Charity Registered in England and Wales No. 305999
>
---------------------------------------------------------------------------
> "Writing about music is like dancing about architecture"
> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)
>
>



-- 
Elaine Bradtke
Data Wrangler
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel    +44 (0) 20 7485 2206 (This number is for the English Folk Dance
and Song Society in London, England. If you wish to phone me
personally, send an e-mail first. I work off site)
--------------------------------------------------------------------------
Registered Company No. 297142
Charity Registered in England and Wales No. 305999
---------------------------------------------------------------------------
"Writing about music is like dancing about architecture"
--Elvis Costello (Musician magazine No. 60 (October 1983), p. 52)


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

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


End of Koha Digest, Vol 85, Issue 35
************************************



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

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


End of Koha Digest, Vol 85, Issue 36
************************************



More information about the Koha mailing list