Re: [Koha] jquery : barcode triggers submit
Hie, This behavior is added by the JS code : $(fieldset.rows input, fieldset.rows select).addClass(noEnterSubmit); A better solution is to remove this class : $(tag_952_subfield_p_971027).removeClass(noEnterSubmit); Le 22/07/2014 23:20, Chad Roseburg a écrit : Our cataloging department liked the short-lived behavior in 3.14 where scanning barcodes would submit forms [ no one else did ]. I decided to try and reintroduce that for the cataloging module only -- testing using greasemonkey. Here's what I've got so far [ doesn't work ]: $('tag_952_subfield_p_971027').keypress(function(e) { if ( e.which == 13 ) { $( input[value='Save changes']).trigger('click'); } }); Any ideas? Thanks! Chad -- Fridolin SOMERS Biblibre - Pôles support et système fridolin.som...@biblibre.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] jquery : barcode triggers submit
Chad, A better solution is to remove this class : $(tag_952_subfield_p_971027).removeClass(noEnterSubmit); And, of course, you will need a valid selector. 971027 is a random number, and the tag_952... is an id and not a tag name. Something like $('input[id^=tag_952_subfield_p]') might serve you better. Regards, Jared -- Jared Camins-Esakov Bibliographer, C P Bibliography Services, LLC (phone) +1 (917) 727-3445 (e-mail) jcam...@cpbibliography.com (web) http://www.cpbibliography.com/ ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Cataloging questions
I have altered the default framework to include marc tag 595. (590 is also there must I may have added that sometime ago.) 1. When loading records that have a 595 tag, and the framework includes it, what do I to get tag 595 contents to actually load? 2. When I edit a record neither the 590 nor the 595 is included in the list of the tags. What do I do to get the editor to include all of the tags that are in the framework? Thanks Steve Sowder Systems Librarian sow...@andrews.edu Andrews University ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Manual PDF Links Broken
Hi all, It looks like the links to the PDFs on the documentation page are broken: http://koha-community.org/documentation/ Nicole ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Cataloging questions
Responding with more data to my own question. The MARC tag 595 is not displayed anywhere in Koha. However, if the record is exported (buy bib number range) the 595 tags are present. So, question #1 is answered. They _are_ loaded. But, they are not displayed anywhere except when exporting. We ran the program to create an OAI-PMH file but none of the records defined by the map were included. Just about everything else was however. Still wondering how to display _all_ of the contents of the record when editing? Steve On 7/23/2014 10:45 AM, Steve Sowder wrote: I have altered the default framework to include marc tag 595. (590 is also there must I may have added that sometime ago.) 1. When loading records that have a 595 tag, and the framework includes it, what do I to get tag 595 contents to actually load? 2. When I edit a record neither the 590 nor the 595 is included in the list of the tags. What do I do to get the editor to include all of the tags that are in the framework? Thanks Steve Sowder Systems Librarian sow...@andrews.edu Andrews University ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] ldap and extended patron attributes
Hi all, we are testing Koha (3.16.01) with openldap and have an error with extended patron attributes. DBD::mysql::st execute failed: Unknown column 'preflang' in 'field list' at /usr/share/koha/lib/C4/Auth_with_ldap.pm line 320, DATA line 522. 'preflang' is one of our extended attributes. Mapping in koha-conf.xml is done. intranet-error.log (with debug) shows all attribs and values from ldap incuding the extended ones without failure. When it comes to update the extended fields, the error shows up. [Wed Jul 23 17:00:13 2014] [error] [client 192.168.56.1] [Wed Jul 23 17:00:13 2014] mainpage.pl: DBD::mysql::st execute failed: Unknown column 'preflang' in 'field list' at /usr/share/koha/lib/C4/Auth_with [Wed Jul 23 17:00:13 2014] [error] [client 192.168.56.1] [Wed Jul 23 17:00:13 2014] mainpage.pl: DBD::mysql::st execute failed: Unknown column 'preflang' in 'field list' at /usr/share/koha/lib/C4/Auth_with Can anybody help? We patched Auth_with_ldap.pm a bit, because passwords in our ldap are stored with MD5. Maybe it is useful for others. Insert at the top: use Digest::MD5 qw(md5_base64); Search for this line: my $cmpmesg = $db-compare( $userldapentry, attr='userpassword', value = $password ); exchange with this one my $cmpmesg = $db-compare( $userldapentry, attr='userpassword', value = {MD5}.md5_base64($password).== ); Regards -- Heiko Weier Technische Universität Hamburg-Harburg Fachreferent Bibliothek Tel.: 040-42878-3449 Denickestr. 22 Fax.: 040-42878-2527 21073 Hamburg WWW : http://www.tub.tu-harburg.de PGP Key http://www.tub.tu-harburg.de/ext/keys/Heiko_Weier_pub.asc D8DF 3FFD 3910 AB1C 12D2 940B 65B6 2A73 524A 2C1E ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] [Koha-docs] Manual PDF Links Broken
Hi, there was a problem on the local copy of manual's repository. Now is fixed, please check. Regards, Bernardo -- Bernardo Gonzalez Kriegel bgkrie...@gmail.com On Wed, Jul 23, 2014 at 11:43 AM, Nicole Engard neng...@gmail.com wrote: Hi all, It looks like the links to the PDFs on the documentation page are broken: http://koha-community.org/documentation/ Nicole ___ Koha-docs mailing list koha-d...@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-docs ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Cataloging questions
Thanks. I was not aware of this area of Koha. We are on 3.16 and I did not see the SER framework structure. Instead, just click on default's MARC Structure to edit it. All is working now. Thanks again. Steve On 7/23/2014 12:26 PM, Elaine Bradtke wrote: Steve: Older versions of Koha may be slightly different but the short answer is you need to modify the subfields in your framework so that it displays in the editor (the default for 590 is to not display, probably the same for 595). Home › Administration › MARC frameworks › SER framework structure › Tag 590 Subfield structure Edit subfields cosntraints You'll find the display controls under Advanced constraints. in 3.14 or later, it's a matter of ticking the correct boxes. Earlier versions you need to enter the correct number for the display you want - http://manual.koha-community.org/3.2/en/catadmin.html On Wed, Jul 23, 2014 at 4:35 PM, Steve Sowder sow...@andrews.edu mailto:sow...@andrews.edu wrote: Responding with more data to my own question. The MARC tag 595 is not displayed anywhere in Koha. However, if the record is exported (buy bib number range) the 595 tags are present. So, question #1 is answered. They _are_ loaded. But, they are not displayed anywhere except when exporting. We ran the program to create an OAI-PMH file but none of the records defined by the map were included. Just about everything else was however. Still wondering how to display _all_ of the contents of the record when editing? Steve On 7/23/2014 10:45 AM, Steve Sowder wrote: I have altered the default framework to include marc tag 595. (590 is also there must I may have added that sometime ago.) 1. When loading records that have a 595 tag, and the framework includes it, what do I to get tag 595 contents to actually load? 2. When I edit a record neither the 590 nor the 595 is included in the list of the tags. What do I do to get the editor to include all of the tags that are in the framework? Thanks Steve Sowder Systems Librarian sow...@andrews.edu mailto:sow...@andrews.edu Andrews University _ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz mailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/__mailman/listinfo/koha http://lists.katipo.co.nz/mailman/listinfo/koha _ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz mailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/__mailman/listinfo/koha 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) Forget previous vote ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Cataloging questions
I had found the GetRecord format and tested it and got the list. (Your first example) but had not found for a specific record. Thanks i have also disco9vered from i.e. http://koha.andrews.edu/cgi-bin/koha/oai.pl?verb=ListRecordsfrom=2014-07-20metadataPrefix=oai_dc But, it isn't fast. I haven't found a format to search for content. i.e. search for a subject. There must be a way to do that. ?? Steve On 7/23/2014 1:35 PM, ramirouvia . wrote: Hi Steve: I am not sure if this will help you, but just in case... http://koha.andrews.edu/cgi-bin/koha/oai.pl?verb=ListRecordsmetadataPrefix=oai_dc http://koha.andrews.edu/cgi-bin/koha/oai.pl?verb=GetRecordidentifier=SANDBOX:1metadataPrefix=oai_dc http://koha.andrews.edu/cgi-bin/koha/oai.pl?verb=GetRecordidentifier=SANDBOX:2metadataPrefix=oai_dc http://koha.andrews.edu/cgi-bin/koha/oai.pl?verb=GetRecordidentifier=SANDBOX:4metadataPrefix=oai_dc Hope it helps, Ramiro 2014-07-23 13:26 GMT-03:00 Elaine Bradtke e...@efdss.org mailto:e...@efdss.org: Steve: Older versions of Koha may be slightly different but the short answer is you need to modify the subfields in your framework so that it displays in the editor (the default for 590 is to not display, probably the same for 595). Home › Administration › MARC frameworks › SER framework structure › Tag 590 Subfield structure Edit subfields cosntraints You'll find the display controls under Advanced constraints. in 3.14 or later, it's a matter of ticking the correct boxes. Earlier versions you need to enter the correct number for the display you want - http://manual.koha-community.org/3.2/en/catadmin.html On Wed, Jul 23, 2014 at 4:35 PM, Steve Sowder sow...@andrews.edu mailto:sow...@andrews.edu wrote: Responding with more data to my own question. The MARC tag 595 is not displayed anywhere in Koha. However, if the record is exported (buy bib number range) the 595 tags are present. So, question #1 is answered. They _are_ loaded. But, they are not displayed anywhere except when exporting. We ran the program to create an OAI-PMH file but none of the records defined by the map were included. Just about everything else was however. Still wondering how to display _all_ of the contents of the record when editing? Steve On 7/23/2014 10:45 AM, Steve Sowder wrote: I have altered the default framework to include marc tag 595. (590 is also there must I may have added that sometime ago.) 1. When loading records that have a 595 tag, and the framework includes it, what do I to get tag 595 contents to actually load? 2. When I edit a record neither the 590 nor the 595 is included in the list of the tags. What do I do to get the editor to include all of the tags that are in the framework? Thanks Steve Sowder Systems Librarian sow...@andrews.edu mailto:sow...@andrews.edu Andrews University ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz mailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz mailto: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) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz mailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha Forget previous vote ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Cataloging questions
Oops, my bad I was in the serials framework when I answered your question. . . you were right make the changes in your default framework. Elaine On Wed, Jul 23, 2014 at 6:54 PM, Steve Sowder sow...@andrews.edu wrote: Thanks. I was not aware of this area of Koha. We are on 3.16 and I did not see the SER framework structure. Instead, just click on default's MARC Structure to edit it. All is working now. Thanks again. Steve On 7/23/2014 12:26 PM, Elaine Bradtke wrote: Steve: Older versions of Koha may be slightly different but the short answer is you need to modify the subfields in your framework so that it displays in the editor (the default for 590 is to not display, probably the same for 595). Home › Administration › MARC frameworks › SER framework structure › Tag 590 Subfield structure Edit subfields cosntraints You'll find the display controls under Advanced constraints. in 3.14 or later, it's a matter of ticking the correct boxes. Earlier versions you need to enter the correct number for the display you want - http://manual.koha-community.org/3.2/en/catadmin.html On Wed, Jul 23, 2014 at 4:35 PM, Steve Sowder sow...@andrews.edu mailto:sow...@andrews.edu wrote: Responding with more data to my own question. The MARC tag 595 is not displayed anywhere in Koha. However, if the record is exported (buy bib number range) the 595 tags are present. So, question #1 is answered. They _are_ loaded. But, they are not displayed anywhere except when exporting. We ran the program to create an OAI-PMH file but none of the records defined by the map were included. Just about everything else was however. Still wondering how to display _all_ of the contents of the record when editing? Steve On 7/23/2014 10:45 AM, Steve Sowder wrote: I have altered the default framework to include marc tag 595. (590 is also there must I may have added that sometime ago.) 1. When loading records that have a 595 tag, and the framework includes it, what do I to get tag 595 contents to actually load? 2. When I edit a record neither the 590 nor the 595 is included in the list of the tags. What do I do to get the editor to include all of the tags that are in the framework? Thanks Steve Sowder Systems Librarian sow...@andrews.edu mailto:sow...@andrews.edu Andrews University _ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz mailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/__mailman/listinfo/koha http://lists.katipo.co.nz/mailman/listinfo/koha _ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz mailto:Koha@lists.katipo.co.nz http://lists.katipo.co.nz/__mailman/listinfo/koha 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) Forget previous vote -- 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
Re: [Koha] Report help
This is the basic report: SELECT count(biblio.copyrightdate), biblio.copyrightdate,items.itype FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) GROUP BY biblio.copyrightdate ORDER BY biblio.copyrightdate asc I also used an expanded version with more fields so I could see what the numbers really mean. - It doesn't pick up everything. A lot of our 18th and 19th century publications have partial or conjectural dates in square brackets. These seem to be ignored. - It gives a count of the items. Not the biblios. So this skews the count further (we have a lot of 18th century pamphlets bound together - many biblios, but only one item record for the bound volume). Is there any way we can be more precise? Would a query on the MARCXML for the 260 c produce a more accurate result? Can we to force it to count biblios instead of items? It may be we have to settle for doing the counting in the spreadsheet rather than via Koha. But it would be nice to have some control over what is counted. I know next to nothing about SQL, any help would be greatly appreciated. Thanks On Wed, Jul 23, 2014 at 12:31 AM, Robin Sheat ro...@catalyst.net.nz wrote: Elaine Bradtke schreef op di 22-07-2014 om 17:35 [+0100]: One of my colleagues was asking if I could give statistics on what we have from the 17th, 18th and first half of the 19th century. Preferably by year. When my Elasticsearch work is finished, this'll be just a matter of finding an elasticsearch visualisation tool that lets you explore your data, and telling it to do what you want. The way I'd do it currently would be to script something that pulls the date from the MARC of each entry and exports that. Then you could pop it into libreoffice calc and make graphs or whatever you need. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ 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) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help
Elaine: I think you should use 008 date: SELECT CASE SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag=008]'),8,2) WHEN '19' THEN 'XX' WHEN '20' THEN 'XXI' WHEN '18' THEN 'XVIII' WHEN '17' THEN 'XVII' ElSE 'OLDER' END AS bibtype, count(DISTINCT biblionumber) AS bibs FROM biblioitems m GROUP BY bibtype I made this report based on two reports from the library by Nicole C. Engard. Ramiro 2014-07-23 15:57 GMT-03:00 Elaine Bradtke e...@efdss.org: This is the basic report: SELECT count(biblio.copyrightdate), biblio.copyrightdate,items.itype FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) GROUP BY biblio.copyrightdate ORDER BY biblio.copyrightdate asc I also used an expanded version with more fields so I could see what the numbers really mean. - It doesn't pick up everything. A lot of our 18th and 19th century publications have partial or conjectural dates in square brackets. These seem to be ignored. - It gives a count of the items. Not the biblios. So this skews the count further (we have a lot of 18th century pamphlets bound together - many biblios, but only one item record for the bound volume). Is there any way we can be more precise? Would a query on the MARCXML for the 260 c produce a more accurate result? Can we to force it to count biblios instead of items? It may be we have to settle for doing the counting in the spreadsheet rather than via Koha. But it would be nice to have some control over what is counted. I know next to nothing about SQL, any help would be greatly appreciated. Thanks On Wed, Jul 23, 2014 at 12:31 AM, Robin Sheat ro...@catalyst.net.nz wrote: Elaine Bradtke schreef op di 22-07-2014 om 17:35 [+0100]: One of my colleagues was asking if I could give statistics on what we have from the 17th, 18th and first half of the 19th century. Preferably by year. When my Elasticsearch work is finished, this'll be just a matter of finding an elasticsearch visualisation tool that lets you explore your data, and telling it to do what you want. The way I'd do it currently would be to script something that pulls the date from the MARC of each entry and exports that. Then you could pop it into libreoffice calc and make graphs or whatever you need. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ 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) ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help
Ramiro That's very useful, thanks. I've expanded it a little to accommodate our date range (yes we have some old items) and changed it to say Unknown rather than older, because I suspect these are questionable dates or missing data. Quite a few dates are missing in the 008 field. One of the difficulties in producing reliable statistics! SELECT CASE SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag=008]'),8,2) WHEN '19' THEN 'XX' WHEN '20' THEN 'XXI' WHEN '18' THEN 'XIX' WHEN '17' THEN 'XVIII' WHEN '16' THEN 'XVII' WHEN '15' THEN 'XVI' ElSE 'Unknown' END AS bibtype, count(DISTINCT biblionumber) AS bibs FROM biblioitems m GROUP BY bibtype On Wed, Jul 23, 2014 at 8:35 PM, ramirouvia . ramirou...@gmail.com wrote: Elaine: I think you should use 008 date: SELECT CASE SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag=008]'),8,2) WHEN '19' THEN 'XX' WHEN '20' THEN 'XXI' WHEN '18' THEN 'XVIII' WHEN '17' THEN 'XVII' ElSE 'OLDER' END AS bibtype, count(DISTINCT biblionumber) AS bibs FROM biblioitems m GROUP BY bibtype I made this report based on two reports from the library by Nicole C. Engard. Ramiro 2014-07-23 15:57 GMT-03:00 Elaine Bradtke e...@efdss.org: This is the basic report: SELECT count(biblio.copyrightdate), biblio.copyrightdate,items.itype FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) GROUP BY biblio.copyrightdate ORDER BY biblio.copyrightdate asc I also used an expanded version with more fields so I could see what the numbers really mean. - It doesn't pick up everything. A lot of our 18th and 19th century publications have partial or conjectural dates in square brackets. These seem to be ignored. - It gives a count of the items. Not the biblios. So this skews the count further (we have a lot of 18th century pamphlets bound together - many biblios, but only one item record for the bound volume). Is there any way we can be more precise? Would a query on the MARCXML for the 260 c produce a more accurate result? Can we to force it to count biblios instead of items? It may be we have to settle for doing the counting in the spreadsheet rather than via Koha. But it would be nice to have some control over what is counted. I know next to nothing about SQL, any help would be greatly appreciated. Thanks On Wed, Jul 23, 2014 at 12:31 AM, Robin Sheat ro...@catalyst.net.nz wrote: Elaine Bradtke schreef op di 22-07-2014 om 17:35 [+0100]: One of my colleagues was asking if I could give statistics on what we have from the 17th, 18th and first half of the 19th century. Preferably by year. When my Elasticsearch work is finished, this'll be just a matter of finding an elasticsearch visualisation tool that lets you explore your data, and telling it to do what you want. The way I'd do it currently would be to script something that pulls the date from the MARC of each entry and exports that. Then you could pop it into libreoffice calc and make graphs or whatever you need. -- Robin Sheat Catalyst IT Ltd. ✆ +64 4 803 2204 GPG: 5FA7 4B49 1E4D CAA4 4C38 8505 77F5 B724 F871 3BDF ___ 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) ___ 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
[Koha] Report to find biblios without dates in 008 - needs work
I'm halfway there: SELECT biblionumber, SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag=008]'),8,4) as Date FROM biblioitems m LEFT JOIN biblio b USING (biblionumber) WHERE Date = '' Doesn't quite work. If I omit the last line, it spits out a list of all our biblios, and the date. I'd like to limit the results to just the biblios with in the first date section of the 008 WHERE (Date = '') didn't work. NULL in place of '' doesn't work either. WHERE (ExtractValue(m.marcxml,'//controlfield[@tag=008]'),8,4) = '' also didn't work. I've exhausted my cut and paste abilities. . . . -- Elaine Bradtke (What I don't know about SQL would fill a few books) 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
[Koha] Koha 3.16.2 released
The Koha community is pleased to announce the release of version 3.16.2 of the Koha library automation system. Koha 3.16.2 is a bugfix release and can be downloaded from http://download.koha-community.org/ Debian packages of Koha 3.16.2 will be available shortly. Full release notes can be found at http://koha-community.org/koha-3-16-2-released/ Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: g...@esilibrary.com direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web:http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org http://evergreen-ils.org ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Report help
Salvete! SELECT CASE SUBSTR(ExtractValue(m.marcxml,'//controlfield[@tag=008]'),8,2) WHEN '19' THEN 'XX' WHEN '20' THEN 'XXI' WHEN '18' THEN 'XVIII' WHEN '17' THEN 'XVII' ElSE 'OLDER' END AS bibtype, count(DISTINCT biblionumber) AS bibs FROM biblioitems m GROUP BY bibtype I made this report based on two reports from the library by Nicole C. Engard. Should prolly be WHEN '19' THEN 'X1X' WHEN '20' THEN 'XX' WHEN '18' THEN 'XVIII' WHEN '17' THEN 'XVII' yeah? Cheers, Brooke ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
[Koha] Koha live dvd 3.14.08
So this is second live dvd for version 3.14. Sorry all, i was so busy with my work and can't make live dvd more frequently. You can download from here, don't forget download koha-3.14.08_readme. koha-latest - Browse Files at SourceForge.net koha-latest - Browse Files at SourceForge.net No description View on sourceforge.net Preview by Yahoo Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn http://vietnamlib.net ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha live dvd 3.14.08
Dear Nguyen Quoc Uy, Are you able to make live DVD of latest version, if yes than please explain how? On Thu, 24 Jul 2014 06:36:04 +0530 Quoc Uy wrote So this is second live dvd for version 3.14. Sorry all, i was so busy with my work and can't make live dvd more frequently. You can download from here, don't forget download koha-3.14.08_readme. koha-latest - Browse Files at SourceForge.net koha-latest - Browse Files at SourceForge.net No description View on sourceforge.net Preview by Yahoo Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn http://vietnamlib.net ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librar...@rediffmail.com : mishrav...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Re: [Koha] Koha live dvd 3.14.08
No, how did you made live DVD now? if with remastersys than please confirm is it still working? because few day back i checked and found it does not work more now. On Thu, 24 Jul 2014 08:55:12 +0530 Quoc Uy wrote I just updated from my old live dvd to latest oldstable version. Nothing special. Why did you ask? Did you get error to make new dvd? Sent from Yahoo Mail on Android From: Vinod Kumar Mishra ; To: ; Cc: ; Subject: Re: [Koha] Koha live dvd 3.14.08 Sent: Thu, Jul 24, 2014 3:20:28 AM Dear Nguyen Quoc Uy, Are you able to make live DVD of latest version, if yes than please explain how? On Thu, 24 Jul 2014 06:36:04 +0530 Quoc Uy wrote So this is second live dvd for version 3.14. Sorry all, i was so busy with my work and can';t make live dvd more frequently. You can download from here, don';t forget download koha-3.14.08_readme. koha-latest - Browse Files at SourceForge.net koha-latest - Browse Files at SourceForge.net No description View on sourceforge.net Preview by Yahoo Best regards! Nguyen Quoc Uy Admin http://dreamlib.vn http://vietnamlib.net ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librar...@rediffmail.com : mishravk79@gmail.comGet your own FREE website, FREE domain FREE mobile app with Company email. �Know More With regards, Vinod Kumar Mishra, Assistant Librarian, (Library In-Charge) Biju Patnaik Central Library, NIT Rourkela, Mob:91+9439420860 91+6612462103 (O) email: vinod_librar...@rediffmail.com : mishrav...@gmail.com ___ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha