I'm hoping someone might be able to see what I'm doing wrong. I'm trying to set up an SRU target for SwissBib. The SRU information for SwissBib is at http://www.swissbib.org/wiki/index.php?title=SRU . (We're using Koha v. 3.18.05.100) I've used the SRU Explain function ( http://sru.swissbib.ch/sru/explain?operation=explain ) to get information about search attributes. In setting up the SRU target in Koha, I've used the following. Hostname: sru.swissbib.ch Port: 80 Database: sru/search/defaultdb Syntax: UNIMARC Encoding: utf8 Additional SRU options: operation=searchRetrieve (I've tried using other SRU options, too, but this seems to be the minimum required.) SRU Search fields mapping: Title - dc:title ISBN - dc:identifier Any - dc:anywhere Author - dc:author ISSN - dc:identifier Standard ID - dc:id The following URL will produce results in my web browser, but I get no results when I do an equivalent SRU search in Koha. http://sru.swissbib.ch/sru/search/defaultdb?query=+dc.anywhere+%3D+verne&operation=searchRetrieve&maximumRecords=10 Does anyone have any thoughts about what's wrong? Thanks in advance. -- Andy Boze, Associate Librarian University of Notre Dame 208 Hesburgh Library (574) 631-8708
Hi Andy, Does this SRU server also return marcxml ? In your example it returns Dublin Core. Koha does (currently) not support it as input format. Normally, you should recordSchema to specify the format. Regards, Marcel ________________________________________ Van: Koha <koha-bounces@lists.katipo.co.nz> namens Andy Boze <boze.1@nd.edu> Verzonden: woensdag 6 april 2016 02:00 Aan: Koha list Onderwerp: [Koha] Need assistance setting up SRU target I'm hoping someone might be able to see what I'm doing wrong. I'm trying to set up an SRU target for SwissBib. The SRU information for SwissBib is at http://www.swissbib.org/wiki/index.php?title=SRU . (We're using Koha v. 3.18.05.100) I've used the SRU Explain function ( http://sru.swissbib.ch/sru/explain?operation=explain ) to get information about search attributes. In setting up the SRU target in Koha, I've used the following. Hostname: sru.swissbib.ch Port: 80 Database: sru/search/defaultdb Syntax: UNIMARC Encoding: utf8 Additional SRU options: operation=searchRetrieve (I've tried using other SRU options, too, but this seems to be the minimum required.) SRU Search fields mapping: Title - dc:title ISBN - dc:identifier Any - dc:anywhere Author - dc:author ISSN - dc:identifier Standard ID - dc:id The following URL will produce results in my web browser, but I get no results when I do an equivalent SRU search in Koha. http://sru.swissbib.ch/sru/search/defaultdb?query=+dc.anywhere+%3D+verne&operation=searchRetrieve&maximumRecords=10 Does anyone have any thoughts about what's wrong? Thanks in advance. -- Andy Boze, Associate Librarian University of Notre Dame 208 Hesburgh Library (574) 631-8708 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Andy, you need to configure Koha so it retrieves MARCXML data from the SRU target. 2016-04-05 21:00 GMT-03:00 Andy Boze <boze.1@nd.edu>:
I'm hoping someone might be able to see what I'm doing wrong. I'm trying to set up an SRU target for SwissBib. The SRU information for SwissBib is at http://www.swissbib.org/wiki/index.php?title=SRU . (We're using Koha v. 3.18.05.100)
I've used the SRU Explain function ( http://sru.swissbib.ch/sru/explain?operation=explain ) to get information about search attributes.
In setting up the SRU target in Koha, I've used the following.
Hostname: sru.swissbib.ch Port: 80 Database: sru/search/defaultdb Syntax: UNIMARC Encoding: utf8
Additional SRU options: operation=searchRetrieve (I've tried using other SRU options, too, but this seems to be the minimum required.)
SRU Search fields mapping: Title - dc:title ISBN - dc:identifier Any - dc:anywhere Author - dc:author ISSN - dc:identifier Standard ID - dc:id
The following URL will produce results in my web browser, but I get no results when I do an equivalent SRU search in Koha.
Does anyone have any thoughts about what's wrong? Thanks in advance.
-- Andy Boze, Associate Librarian University of Notre Dame 208 Hesburgh Library (574) 631-8708 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Tomás Cohen Arazi Theke Solutions (http://theke.io) ✆ +54 9351 3513384 GPG: B2F3C15F
Thanks to both Marcel and Tomas for mentioning MARCXML. I hadn't noticed anything in the documentation about that. I had already tried setting recordSchema to every format that SwissBib supports, without any luck. The following URL requests records in MARCXML format. http://sru.swissbib.ch/sru/search/defaultdb?query=+dc.anywhere%3Djardin&operation=searchRetrieve&recordSchema=info%3Asrw%2Fschema%2F1%2Fmarcxml-v1.1&maximumRecords=10&recordPacking=XML Based on that URL, I've set the "Additional SRU options" field like this. operation=searchRetrieve,recordSchema=info:srw/schema/1/marcxml-v1.1-light,maximumRecords=10,recordPacking=XML (It's not clear to me whether I should percent-encode special characters such as : and / in the SRU options field. I've tried it with and without encoding.) Also for the database field I've tried it both with and without a leading slash (/). I would have assumed without, but just in case... sru/search/defaultdb /sru/search/defaultdb And since its a regular http: URL, I've assumed port 80. I continue to get no results when I do an SRU search in Cataloging. Is there a way to determine what Koha is sending to the SRU server and what response is sent back? Is this logged anywhere? Thanks in advance. On 4/6/2016 9:34 AM, Tomas Cohen Arazi wrote:
Andy, you need to configure Koha so it retrieves MARCXML data from the SRU target.
2016-04-05 21:00 GMT-03:00 Andy Boze <boze.1@nd.edu>:
I'm hoping someone might be able to see what I'm doing wrong. I'm trying to set up an SRU target for SwissBib. The SRU information for SwissBib is at http://www.swissbib.org/wiki/index.php?title=SRU . (We're using Koha v. 3.18.05.100)
I've used the SRU Explain function ( http://sru.swissbib.ch/sru/explain?operation=explain ) to get information about search attributes.
In setting up the SRU target in Koha, I've used the following.
Hostname: sru.swissbib.ch Port: 80 Database: sru/search/defaultdb Syntax: UNIMARC Encoding: utf8
Additional SRU options: operation=searchRetrieve (I've tried using other SRU options, too, but this seems to be the minimum required.)
SRU Search fields mapping: Title - dc:title ISBN - dc:identifier Any - dc:anywhere Author - dc:author ISSN - dc:identifier Standard ID - dc:id
The following URL will produce results in my web browser, but I get no results when I do an equivalent SRU search in Koha.
Does anyone have any thoughts about what's wrong? Thanks in advance.
-- Andy Boze, Associate Librarian University of Notre Dame 208 Hesburgh Library (574) 631-8708 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Andy Boze, Associate Librarian University of Notre Dame 208A Hesburgh Library (574) 631-8708
Hi Andy, Andy Boze schrieb am 06.04.2016
Based on that URL, I've set the "Additional SRU options" field like this.
operation=searchRetrieve,recordSchema=info:srw/schema/1/marcxml-v1.1-light,maximumRecords=10,recordPacking=XML
Good idea, but it does not work that way. Koha expects ZOOM in that field. http://www.indexdata.com/yaz/doc/zoom.html sru=get is the equivalent to operation=searchRetrieve, schema the equivalent to recordSchema…
(It's not clear to me whether I should percent-encode special characters such as : and / in the SRU options field. I've tried it with and without encoding.)
…a tilde (~) in the URL has to be encoded at least in newer versions of Koha. I would assume the same for the other fields. That would give you something like sru=get,sru_version=1.1,schema=info%3Asrw%2Fschema%2F1%2Fmarcxml-v1.1-light
Also for the database field I've tried it both with and without a leading slash (/). I would have assumed without, but just in case...
Not sure if that matters, but it works without / for other servers. Try YAZ-client to test the connection. http://www.indexdata.com/yaz Spoiler: it did not work for me anyway, but maybe the ZOOM stuff and YAZ get you in the right direction. You may want to get in contact with the Swissbib people if you can't get it to work. I put up the information related to DNB (German National Library) a while back. It's in German, but you can probably understand the config part and how to use yaz-client to test. http://abunchofthings.net/blog/freie-metadaten-von-der-dnb-per-sru/ HTH, Mirko -- Mirko Tietgen mirko@abunchofthings.net http://koha.abunchofthings.net http://meinkoha.de
sru/search/defaultdb /sru/search/defaultdb
And since its a regular http: URL, I've assumed port 80.
I continue to get no results when I do an SRU search in Cataloging.
Is there a way to determine what Koha is sending to the SRU server and what response is sent back? Is this logged anywhere?
Thanks in advance.
On 4/6/2016 9:34 AM, Tomas Cohen Arazi wrote:
Andy, you need to configure Koha so it retrieves MARCXML data from the SRU target.
2016-04-05 21:00 GMT-03:00 Andy Boze <boze.1@nd.edu>:
I'm hoping someone might be able to see what I'm doing wrong. I'm trying to set up an SRU target for SwissBib. The SRU information for SwissBib is at http://www.swissbib.org/wiki/index.php?title=SRU . (We're using Koha v. 3.18.05.100)
I've used the SRU Explain function ( http://sru.swissbib.ch/sru/explain?operation=explain ) to get information about search attributes.
In setting up the SRU target in Koha, I've used the following.
Hostname: sru.swissbib.ch Port: 80 Database: sru/search/defaultdb Syntax: UNIMARC Encoding: utf8
Additional SRU options: operation=searchRetrieve (I've tried using other SRU options, too, but this seems to be the minimum required.)
SRU Search fields mapping: Title - dc:title ISBN - dc:identifier Any - dc:anywhere Author - dc:author ISSN - dc:identifier Standard ID - dc:id
The following URL will produce results in my web browser, but I get no results when I do an equivalent SRU search in Koha.
Does anyone have any thoughts about what's wrong? Thanks in advance.
-- Andy Boze, Associate Librarian University of Notre Dame 208 Hesburgh Library (574) 631-8708 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
Mirko, Thanks very much for your assistance. I can successfully search SwissBib, and I now have a much better understanding of how Koha works with SRU. In case anyone else comes across this, I'll mention that I found that the "Additional SRU options" should not be percent-encoded, as they would be in a URL. Apparently Koha can take care of encoding the characters appropriately. On 4/6/2016 4:16 PM, Mirko Tietgen wrote:
Hi Andy,
Andy Boze schrieb am 06.04.2016
Based on that URL, I've set the "Additional SRU options" field like this.
operation=searchRetrieve,recordSchema=info:srw/schema/1/marcxml-v1.1-light,maximumRecords=10,recordPacking=XML
Good idea, but it does not work that way. Koha expects ZOOM in that field. http://www.indexdata.com/yaz/doc/zoom.html
sru=get is the equivalent to operation=searchRetrieve, schema the equivalent to recordSchema…
(It's not clear to me whether I should percent-encode special characters such as : and / in the SRU options field. I've tried it with and without encoding.)
…a tilde (~) in the URL has to be encoded at least in newer versions of Koha. I would assume the same for the other fields. That would give you something like
sru=get,sru_version=1.1,schema=info%3Asrw%2Fschema%2F1%2Fmarcxml-v1.1-light
Also for the database field I've tried it both with and without a leading slash (/). I would have assumed without, but just in case...
Not sure if that matters, but it works without / for other servers.
Try YAZ-client to test the connection. http://www.indexdata.com/yaz
Spoiler: it did not work for me anyway, but maybe the ZOOM stuff and YAZ get you in the right direction. You may want to get in contact with the Swissbib people if you can't get it to work.
I put up the information related to DNB (German National Library) a while back. It's in German, but you can probably understand the config part and how to use yaz-client to test. http://abunchofthings.net/blog/freie-metadaten-von-der-dnb-per-sru/
HTH,
Mirko
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Andy Boze, Associate Librarian University of Notre Dame 208A Hesburgh Library (574) 631-8708
Andy Boze schrieb am 07.04.2016
Mirko,
Thanks very much for your assistance. I can successfully search SwissBib, and I now have a much better understanding of how Koha works with SRU.
That's fantastic! Would you mind sharing your full config so others can reuse it? -- Mirko -- Mirko Tietgen mirko@abunchofthings.net http://koha.abunchofthings.net http://meinkoha.de
On 4/7/2016 6:42 PM, Mirko Tietgen wrote:
Andy Boze schrieb am 07.04.2016
Mirko,
Thanks very much for your assistance. I can successfully search SwissBib, and I now have a much better understanding of how Koha works with SRU.
That's fantastic! Would you mind sharing your full config so others can reuse it?
Gladly. BTW, one thing I've noticed is that any search on a numeric term always times out. For example, if I search on the ISBN 3451169940 (with or without dashes) in either the ISBN field or the Any field, it always times out. If I put a letter in front of the number, I get a response rather quickly, but of course without any results. When I submit the query as a URL in my web browser, I get a response. <http://sru.swissbib.ch/sru/search/defaultdb?query=+dc.anywhere%3D3451169940&operation=searchRetrieve&recordSchema=info%3Asrw%2Fschema%2F1%2Fmarcxml-v1.1&maximumRecords=10> I'll experiment some more and send another e-mail to the list. SwissBib Hostname: sru.swissbib.ch Port: 80 Database: sru/search/defaultdb Syntax: UNIMARC Encoding: utf8 Additional SRU options: sru=get,sru_version=1.1,schema=info:srw/schema/1/marcxml-v1.1 SRU Search fields mapping: Title - dc.title ISBN - dc.identifier Control no - dc:id Any - dc.anywhere Author - dc.creator ISSN - dc.identifier Subject - dc.subject Standard ID - dc:identifier -- Andy Boze, Associate Librarian University of Notre Dame 208A Hesburgh Library (574) 631-8708
I've just gotten more time to look into the problem I was having searching SwissBib via SRU and not getting results for numeric terms. Whatever the problem was, numeric searches are now returning results. I had made no change to my configuration in Koha, so I can only assume there was a problem at SwissBib's end. On 4/8/2016 12:13 PM, Andy Boze wrote:
On 4/7/2016 6:42 PM, Mirko Tietgen wrote:
Andy Boze schrieb am 07.04.2016
Mirko,
Thanks very much for your assistance. I can successfully search SwissBib, and I now have a much better understanding of how Koha works with SRU.
That's fantastic! Would you mind sharing your full config so others can reuse it?
Gladly.
BTW, one thing I've noticed is that any search on a numeric term always times out. For example, if I search on the ISBN 3451169940 (with or without dashes) in either the ISBN field or the Any field, it always times out. If I put a letter in front of the number, I get a response rather quickly, but of course without any results. When I submit the query as a URL in my web browser, I get a response.
I'll experiment some more and send another e-mail to the list.
SwissBib Hostname: sru.swissbib.ch Port: 80 Database: sru/search/defaultdb Syntax: UNIMARC Encoding: utf8 Additional SRU options: sru=get,sru_version=1.1,schema=info:srw/schema/1/marcxml-v1.1
SRU Search fields mapping: Title - dc.title ISBN - dc.identifier Control no - dc:id Any - dc.anywhere Author - dc.creator ISSN - dc.identifier Subject - dc.subject Standard ID - dc:identifier
-- Andy Boze, Associate Librarian University of Notre Dame 208A Hesburgh Library (574) 631-8708
participants (4)
-
Andy Boze -
Marcel de Rooy -
Mirko Tietgen -
Tomas Cohen Arazi