Re: [Koha] Problem in importing Patron Records
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@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@efdss.org> To: Uy nguyễn quốc <nguyenquocuy_1102@yahoo.com> Cc: koha <koha@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@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@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@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@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)
Hi Elaine, I think it's not the date format that is a problem here. The date format should be what you have set in the dateformat system preference. I think your problem could be, that you are not providing a borrowernumber. I found in the past that the import works nicely providing a sequential borrowernumber for all my entries in the CSV file. Also maybe try to lower case your header row. It's only a guess as I haven't tested it, but maybe it makes a difference. Another idea is that you provide a anonymized sample file of your data, so we can take a look at the headerrow and 2 or more additional lines to help you find the problem. Hope this helps, Katrin -----Original Message----- From: koha-bounces@lists.katipo.co.nz on behalf of Elaine Bradtke Sent: Wed 21.11.2012 23:51 To: Quoc Uy Cc: koha Subject: Re: [Koha] Problem in importing Patron Records 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@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@efdss.org> To: Uy nguy?n qu?c <nguyenquocuy_1102@yahoo.com> Cc: koha <koha@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@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@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@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@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 http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
On Thu, Nov 22, 2012 at 6:18 AM, Fischer, Katrin <Katrin.Fischer@bsz-bw.de> wrote:
Hi Elaine,
I think it's not the date format that is a problem here. The date format should be what you have set in the dateformat system preference. I think your problem could be, that you are not providing a borrowernumber. I am providing a borrower number, and all the fields that are required.
I found in the past that the import works nicely providing a sequential borrowernumber for all my entries in the CSV file.
Our borrower numbers are existing membership numbers. They have to be, because one must be a member in order to borrow anything from the library. I have no control over these numbers. We need to retain this link, because we have to periodically update the borrowers based on current membership data. I could theoretically move this to another field, but I've got to be able to overwrite the old data (expiration dates, old addresses, etc.). Also maybe try to lower
case your header row. It's only a guess as I haven't tested it, but maybe it makes a difference.
I woke up at 4:30 this morning wondering about that. Cardbox exports the header row in upper case. I'll see if this makes a difference.
Another idea is that you provide a anonymized sample file of your data, so we can take a look at the headerrow and 2 or more additional lines to help you find the problem.
I could do that. It's a national holiday today. . . so I'm not actually working (ha, ha). I will say having to jump through all these hoops to get the data into Koha means I probably won't be able to delegate the monthly updates to another member of staff. This is unfortunate, it shouldn't be this difficult.
Hope this helps,
Katrin
-----Original Message----- From: koha-bounces@lists.katipo.co.nz on behalf of Elaine Bradtke Sent: Wed 21.11.2012 23:51 To: Quoc Uy Cc: koha Subject: Re: [Koha] Problem in importing Patron Records
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@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@efdss.org> To: Uy nguy?n qu?c <nguyenquocuy_1102@yahoo.com>
Cc: koha <koha@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@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@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@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@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 http://koha-community.org Koha@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 (eb@efdss.org) wrote:
I will say having to jump through all these hoops to get the data into Koha means I probably won't be able to delegate the monthly updates to another member of staff. This is unfortunate, it shouldn't be this difficult.
Yeah, that's the thing, it isn't usually this difficult. So this is what we are trying to do, figure out what you are doing differently that is making it not work for you. Constrained by not being able to see the data, or peer over your shoulder while you do it, the next best thing is to take guesses at what it is and have you try them. Definitely not the ideal way to debug an issue, but we are trying :) Chris -- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand
Solved! It appears the header row is case sensitive. Once I converted the all caps to lower case it went right in. Would have been nice to know. . . . Thanks for everyone's input. I kept saying I wasn't going to work on the holiday. . . at least now I won't wake up in the middle of the night wondering about it! Elaine On Thu, Nov 22, 2012 at 6:16 PM, Chris Cormack <chrisc@catalyst.net.nz> wrote:
* Elaine Bradtke (eb@efdss.org) wrote:
I will say having to jump through all these hoops to get the data into Koha means I probably won't be able to delegate the monthly updates to another member of staff. This is unfortunate, it shouldn't be this difficult.
Yeah, that's the thing, it isn't usually this difficult. So this is what we are trying to do, figure out what you are doing differently that is making it not work for you.
Constrained by not being able to see the data, or peer over your shoulder while you do it, the next best thing is to take guesses at what it is and have you try them. Definitely not the ideal way to debug an issue, but we are trying :)
Chris
-- Chris Cormack Catalyst IT Ltd. +64 4 803 2238 PO Box 11-053, Manners St, Wellington 6142, New Zealand
-- 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 <eb@efdss.org>
It appears the header row is case sensitive. Once I converted the all caps to lower case it went right in. Would have been nice to know. .
I think I wrote the header row support, or at least I've worked on it at some point. The header row will be because the underlying database is case-sensitive, which they tend to be. It's always been all lower case in the sample file offered for download, isn't it? If we made it case-insensitive (which might not be straightforward), I fear there would still be people who would replace underscores and dashes with spaces and so on - so maybe it's better if we simply add a warning that the header column names must be exactly what's in the sample? Thanks, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/
On Fri, Nov 23, 2012 at 11:59 AM, MJ Ray <mjr@phonecoop.coop> wrote:
Elaine Bradtke <eb@efdss.org>
It appears the header row is case sensitive. Once I converted the all caps to lower case it went right in. Would have been nice to know. .
I think I wrote the header row support, or at least I've worked on it at some point.
The header row will be because the underlying database is case-sensitive, which they tend to be. It's always been all lower case in the sample file offered for download, isn't it?
Yes, indeed it is. Mine started out lower case, but our database software changed it to all caps while I was batch editing the data (sigh).
If we made it case-insensitive (which might not be straightforward), I fear there would still be people who would replace underscores and dashes with spaces and so on - so maybe it's better if we simply add a warning that the header column names must be exactly what's in the sample? A simple statement somewhere obvious (or in the manual?) - "headers must be lower case" would do it.
Thanks, -- MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op. http://koha-community.org supporter, web and library systems developer. In My Opinion Only: see http://mjr.towers.org.uk/email.html Available for hire (including development) at http://www.software.coop/ _______________________________________________ Koha mailing list http://koha-community.org Koha@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)
participants (4)
-
Chris Cormack -
Elaine Bradtke -
Fischer, Katrin -
MJ Ray