Re: [CODE4LIB] ActiveSierra - Gem for connecting to III Sierra db
James, This looks very useful indeed. Does it work against both hosted and local versions of Sierra? Regards, Chris Chris Awre Head of Information Management Library and Learning Innovation University of Hull Hull, HU6 7RX www.hull.ac.ukhttp://www.hull.ac.uk T: 01482 465441 M: 07545 422674 Skype: clja1967 Twitter: clawre On 9 May 2014, at 04:00, CODE4LIB automatic digest system wrote: Date:Thu, 8 May 2014 18:29:09 + From:Van Mil, James (vanmiljf) vanmi...@ucmail.uc.edumailto:vanmi...@ucmail.uc.edu Subject: ActiveSierra - Gem for connecting to III Sierra db My colleague Sean Crowe and I have written a simple Rails engine with models for the Postgresql database backend to Innovative Interfaces Inc. Sierra ILS. Within a host rails app, it can be used to spin up mediated access to the database via Ruby objects. With a few additional controllers, it would also be straightforward to enable the serialization of database contents over http via json or xml. Though there is a pending release of API functionality for Sierra, this gem offers broader and more granular access to the database. See the github repo: https://github.com/uclibs/active_sierra/ We’re both primarily tech services librarians, and our first use cases for this gem have focused on back-end workflow. For example, we’re developing a Rails app to track and report lost, missing, or long-overdue items in Sierra. With a rake task, a webapp will query Sierra monthly and build a local database of targeted item record numbers and values, which will be served to a site for use in making decisions about replacement. Other possible use cases could be record quality control reports. Out of security concerns, we've purposefully excluded models for patron tables but we haven’t ruled out adding these once we can ensure the security of this data. We still have some short-term development planned, but we noticed that the repo was getting some attention yesterday, and thought it would be a good time to share. Some of our planned work includes: - Developing tests for the models and methods - Adding more scopes and methods to abstract the tables (we have a goal of making our testing application backend as friendly as possible to other tech services staff, and so we’d like the code to be readable to anyone who is familiar with both MARC cataloging and III system conventions) - Modeling additional tables Please feel free to use, fork or contribute. We are very open to comments and suggestions (especially from experienced Rails developers who may be able to offer some perspective on our direction – we both started learning about Rails at Code4Lib2013). And of course we welcome any questions. Thanks! James James Van Mil Collections Electronic Resources Librarian University of Cincinnati Libraries Telephone: (513)556-1410 vanmi...@ucmail.uc.edumailto:vanmi...@ucmail.uc.edu ** To view the terms under which this email is distributed, please go to http://www2.hull.ac.uk/legal/disclaimer.aspx **
Re: [CODE4LIB] ActiveSierra - Gem for connecting to III Sierra db
We don't run III Sierra but I'm still finding this news to be very interesting. You don't mention how III was involved (IF they were involved) and I'm curious to hear about that piece. For our vendor (not naming names) certain things that you might think to do with the database voids our maintenance agreement and I'm just wondering if that situation applies with III's Sierra. Thanks for sharing the news. Christina Salazar Systems Librarian John Spoor Broome Library California State University, Channel Islands 805/437-3198 -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Van Mil, James (vanmiljf) Sent: Thursday, May 08, 2014 11:29 AM To: CODE4LIB@LISTSERV.ND.EDU Subject: [CODE4LIB] ActiveSierra - Gem for connecting to III Sierra db My colleague Sean Crowe and I have written a simple Rails engine with models for the Postgresql database backend to Innovative Interfaces Inc. Sierra ILS. Within a host rails app, it can be used to spin up mediated access to the database via Ruby objects. With a few additional controllers, it would also be straightforward to enable the serialization of database contents over http via json or xml. Though there is a pending release of API functionality for Sierra, this gem offers broader and more granular access to the database. See the github repo: https://github.com/uclibs/active_sierra/ We're both primarily tech services librarians, and our first use cases for this gem have focused on back-end workflow. For example, we're developing a Rails app to track and report lost, missing, or long-overdue items in Sierra. With a rake task, a webapp will query Sierra monthly and build a local database of targeted item record numbers and values, which will be served to a site for use in making decisions about replacement. Other possible use cases could be record quality control reports. Out of security concerns, we've purposefully excluded models for patron tables but we haven't ruled out adding these once we can ensure the security of this data. We still have some short-term development planned, but we noticed that the repo was getting some attention yesterday, and thought it would be a good time to share. Some of our planned work includes: - Developing tests for the models and methods - Adding more scopes and methods to abstract the tables (we have a goal of making our testing application backend as friendly as possible to other tech services staff, and so we'd like the code to be readable to anyone who is familiar with both MARC cataloging and III system conventions) - Modeling additional tables Please feel free to use, fork or contribute. We are very open to comments and suggestions (especially from experienced Rails developers who may be able to offer some perspective on our direction - we both started learning about Rails at Code4Lib2013). And of course we welcome any questions. Thanks! James James Van Mil Collections Electronic Resources Librarian University of Cincinnati Libraries Telephone: (513)556-1410 vanmi...@ucmail.uc.edu
Re: [CODE4LIB] ActiveSierra - Gem for connecting to III Sierra db
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/08/2014 02:29 PM, Van Mil, James (vanmiljf) wrote: My colleague Sean Crowe and I have written a simple Rails engine with models for the Postgresql database backend to Innovative Interfaces Inc. Sierra ILS. Within a host rails app, it can be used to spin up mediated access to the database via Ruby objects. With a few additional controllers, it would also be straightforward to enable the serialization of database contents over http via json or xml. Though there is a pending release of API functionality for Sierra, this gem offers broader and more granular access to the database. See the github repo: https://github.com/uclibs/active_sierra/ NICE! We’re both primarily tech services librarians, and our first use cases for this gem have focused on back-end workflow. For example, we’re developing a Rails app to track and report lost, missing, or long-overdue items in Sierra. With a rake task, a webapp will query Sierra monthly and build a local database of targeted item record numbers and values, which will be served to a site for use in making decisions about replacement. Other possible use cases could be record quality control reports. Out of security concerns, we've purposefully excluded models for patron tables but we haven’t ruled out adding these once we can ensure the security of this data. We still have some short-term development planned, but we noticed that the repo was getting some attention yesterday, and thought it would be a good time to share. Some of our planned work includes: - Developing tests for the models and methods - Adding more scopes and methods to abstract the tables (we have a goal of making our testing application backend as friendly as possible to other tech services staff, and so we’d like the code to be readable to anyone who is familiar with both MARC cataloging and III system conventions) - Modeling additional tables Please feel free to use, fork or contribute. We are very open to comments and suggestions (especially from experienced Rails developers who may be able to offer some perspective on our direction – we both started learning about Rails at Code4Lib2013). And of course we welcome any questions. Watch for pull requests coming your way soon. Again thanks for not paywalling this in the IUG Clearinghouse! Cheers, ./fxk - -- What I want to find out is -- do parrots know much about Astro-Turf? -BEGIN PGP SIGNATURE- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJTa88vAAoJEBKglk8SA18whiAH/iFDDq7TrUdTF7F8n3/vs9xZ RrBleQGby5fcaRS9Qj3DRZP/ePReLtnrvTSAe6rxTGfCQkYMVajJeWyy7HtVFerY qMV7/SJFqBPNPCGnxD7WuV72s7B8cMnKlxzdASOEamyy69m+a+BGmtKsBkMytIwk 5bZoUqScHJ2X0R66kFcSqUl/8cHKe0RLPNwSeWDaqlwZ2d5+uA1rEr9qY+vjBFJY gPeZY+GihVYVsYLnpY0LFluoBbT9cbJcK1PvKf7HyM1TwvFw9DdUbuZvKBymCuGG kk7bEPWMtEZDnyFu/aTxXVbh6AogAWQJoGemKub7rfZoVRVt48xd3RKAUudodcQ= =dDB9 -END PGP SIGNATURE-
Re: [CODE4LIB] ActiveSierra - Gem for connecting to III Sierra db
Hi Cristina, III wasn¹t directly involved in this code, but Sierra customers to have access the the Postgresql database behind the ILS. It¹s read-only so there¹s no risk of breaking all your things. Thanks, James James Van Mil Collections Electronic Resources Librarian University of Cincinnati Libraries Telephone: (513)556-1410 vanmi...@ucmail.uc.edu On 5/8/14, 2:38 PM, Salazar, Christina christina.sala...@csuci.edu wrote: We don't run III Sierra but I'm still finding this news to be very interesting. You don't mention how III was involved (IF they were involved) and I'm curious to hear about that piece. For our vendor (not naming names) certain things that you might think to do with the database voids our maintenance agreement and I'm just wondering if that situation applies with III's Sierra. Thanks for sharing the news. Christina Salazar Systems Librarian John Spoor Broome Library California State University, Channel Islands 805/437-3198 -Original Message- From: Code for Libraries [mailto:CODE4LIB@LISTSERV.ND.EDU] On Behalf Of Van Mil, James (vanmiljf) Sent: Thursday, May 08, 2014 11:29 AM To: CODE4LIB@LISTSERV.ND.EDU Subject: [CODE4LIB] ActiveSierra - Gem for connecting to III Sierra db My colleague Sean Crowe and I have written a simple Rails engine with models for the Postgresql database backend to Innovative Interfaces Inc. Sierra ILS. Within a host rails app, it can be used to spin up mediated access to the database via Ruby objects. With a few additional controllers, it would also be straightforward to enable the serialization of database contents over http via json or xml. Though there is a pending release of API functionality for Sierra, this gem offers broader and more granular access to the database. See the github repo: https://github.com/uclibs/active_sierra/ We're both primarily tech services librarians, and our first use cases for this gem have focused on back-end workflow. For example, we're developing a Rails app to track and report lost, missing, or long-overdue items in Sierra. With a rake task, a webapp will query Sierra monthly and build a local database of targeted item record numbers and values, which will be served to a site for use in making decisions about replacement. Other possible use cases could be record quality control reports. Out of security concerns, we've purposefully excluded models for patron tables but we haven't ruled out adding these once we can ensure the security of this data. We still have some short-term development planned, but we noticed that the repo was getting some attention yesterday, and thought it would be a good time to share. Some of our planned work includes: - Developing tests for the models and methods - Adding more scopes and methods to abstract the tables (we have a goal of making our testing application backend as friendly as possible to other tech services staff, and so we'd like the code to be readable to anyone who is familiar with both MARC cataloging and III system conventions) - Modeling additional tables Please feel free to use, fork or contribute. We are very open to comments and suggestions (especially from experienced Rails developers who may be able to offer some perspective on our direction - we both started learning about Rails at Code4Lib2013). And of course we welcome any questions. Thanks! James James Van Mil Collections Electronic Resources Librarian University of Cincinnati Libraries Telephone: (513)556-1410 vanmi...@ucmail.uc.edu
Re: [CODE4LIB] ActiveSierra - Gem for connecting to III Sierra db
James, Awesome. Really nice work! …adam On May 8, 2014, at 14:29, Van Mil, James (vanmiljf) vanmi...@ucmail.uc.edu wrote: My colleague Sean Crowe and I have written a simple Rails engine with models for the Postgresql database backend to Innovative Interfaces Inc. Sierra ILS. Within a host rails app, it can be used to spin up mediated access to the database via Ruby objects. With a few additional controllers, it would also be straightforward to enable the serialization of database contents over http via json or xml. Though there is a pending release of API functionality for Sierra, this gem offers broader and more granular access to the database. See the github repo: https://github.com/uclibs/active_sierra/ We’re both primarily tech services librarians, and our first use cases for this gem have focused on back-end workflow. For example, we’re developing a Rails app to track and report lost, missing, or long-overdue items in Sierra. With a rake task, a webapp will query Sierra monthly and build a local database of targeted item record numbers and values, which will be served to a site for use in making decisions about replacement. Other possible use cases could be record quality control reports. Out of security concerns, we've purposefully excluded models for patron tables but we haven’t ruled out adding these once we can ensure the security of this data. We still have some short-term development planned, but we noticed that the repo was getting some attention yesterday, and thought it would be a good time to share. Some of our planned work includes: - Developing tests for the models and methods - Adding more scopes and methods to abstract the tables (we have a goal of making our testing application backend as friendly as possible to other tech services staff, and so we’d like the code to be readable to anyone who is familiar with both MARC cataloging and III system conventions) - Modeling additional tables Please feel free to use, fork or contribute. We are very open to comments and suggestions (especially from experienced Rails developers who may be able to offer some perspective on our direction – we both started learning about Rails at Code4Lib2013). And of course we welcome any questions. Thanks! James James Van Mil Collections Electronic Resources Librarian University of Cincinnati Libraries Telephone: (513)556-1410 vanmi...@ucmail.uc.edu