Re: [OPEN-ILS-GENERAL] Creating Database Sources for reports
We did this (with Galen's help) and I will try to elaborate on his answer. Here's what we did 1. Created some additional views in the extended reporter schema 2. Save a copy of the original fm_IDL.xml 3. Add information about the new views to /openils/conf/fm_IDL.xml, using previous entries as a model. Make sure you're the opensrf user when working with this file. a class definition with the following attributes id controller=open-ils.cstore ils_obj:fieldmapper=extend_reporter::long_name_of_view oils_persist.readonly=true reporter:core=true (if you want this to show up as a core reporting source) reporter:label For each column in the view or query output, add a field element and set the following attributes. Make sure these are wrapped in the fields container element: reporter:label name reporter:datatype (which can be id, bool, money, org_unit, int, number, interval, float, text, timestamp, or link) For each linking field, add a link element with the following attributes, wrapped in the link container element: field (should match field.name) reltype (has_a, might_have, or has_many) map () key (name of the linking field in the foreign table) class (ID of the IDL class of the table that is to be linked to) 4. Update the version of fm_IDL.xml used by the reporter cp /openils/conf/fm_IDL.xml /openils/var/web/reports/fm_IDL.xml 5. Run autogen as the opensrf user /openils/bin/autogen.sh 6. Restart C as the opensrf user osrf_ctl.sh -l -a restart_c 7. Restart reporter.We're running all on server, I think you need to do something slightly different with the -l option here for other configurations opensrf-perl.pl -l -action restart -service open-ils.reporter -config /openils/conf/opensrf_core.xml -pid-dir /openils/var/run 8. In the Evergreen Staff Client, you will need to either restart or clear cache (via Admin | For developers | Clear cache). If do you any upgrades, you'll want to compare the new fm_IDL.xml to the one you modified, and if there's differences add your views to the new fm_IDL.xml. Be careful because this file is used by the entire application and not just the reporter. Hope this helps. -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Galen Charlton Sent: Thursday, February 17, 2011 2:05 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Creating Database Sources for reports Hi, On Feb 17, 2011, at 1:25 PM, Tim Spindler wrote: I was playing around trying to add another database source. I thought all you had to do was create view in postgres but apparently not. My view is not showing up in the list of sources. I was wondering what you needed to do if you wanted to create a different source? *Very* briefly, the table or view also should be defined in fm_IDL.xml for it to show up as a reporting source. Hopefully somebody will jump in with a more detailed answer, but I hope this gets you started. In haste, Galen -- Galen Charlton VP, Data Services Equinox Software, Inc. / Your Library's Guide to Open Source email: g...@esilibrary.commailto:g...@esilibrary.com direct: +1 352-215-7548 skype: gmcharlt web:http://www.esilibrary.com/
[OPEN-ILS-GENERAL] MassLNC development interests
Hi all, The Massachusetts Library Network Cooperative is interested in sponsoring more enhancements for Evergreen and would like to share some of our ideas with the community. We're interested in hearing whether others would be interested in seeing these enhancements in Evergreen, if there are suggestions for improving upon our initial requirements, or if there is any overlap with a current development project. The ideas for our next round of development include some support for SMS, the ability to print spine labels on 8 1/2 x 11 sheets, enhancements to book bags, and the ability to access recent searches in the catalog. You can view our full list of possible enhancements with more detailed requirements at http://masslnc.cwmars.eorg/node/2273. We look forward to any feedback you may have! Kathy Lussier - Kathy Lussier Project Coordinator Massachusetts Library Network Cooperative (508) 756-0172 (508) 755-3721 (fax) kluss...@masslnc.org IM: kmlussier (AOL Yahoo) Twitter: http://www.twitter.com/kmlussier
[OPEN-ILS-GENERAL] FW: MassLNC development interests
My apologies! The URL I sent out had a typo - the corrected URL is below: http://masslnc.cwmars.org/node/2273 Kathy - Kathy Lussier Project Coordinator Massachusetts Library Network Cooperative (508) 756-0172 (508) 755-3721 (fax) kluss...@masslnc.org IM: kmlussier (AOL Yahoo) Twitter: http://www.twitter.com/kmlussier -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Kathy Lussier Sent: Friday, February 18, 2011 12:42 PM To: 'Evergreen Discussion Group' Subject: [OPEN-ILS-GENERAL] MassLNC development interests Hi all, The Massachusetts Library Network Cooperative is interested in sponsoring more enhancements for Evergreen and would like to share some of our ideas with the community. We're interested in hearing whether others would be interested in seeing these enhancements in Evergreen, if there are suggestions for improving upon our initial requirements, or if there is any overlap with a current development project. The ideas for our next round of development include some support for SMS, the ability to print spine labels on 8 1/2 x 11 sheets, enhancements to book bags, and the ability to access recent searches in the catalog. You can view our full list of possible enhancements with more detailed requirements at http://masslnc.cwmars.eorg/node/2273. We look forward to any feedback you may have! Kathy Lussier - Kathy Lussier Project Coordinator Massachusetts Library Network Cooperative (508) 756-0172 (508) 755-3721 (fax) kluss...@masslnc.org IM: kmlussier (AOL Yahoo) Twitter: http://www.twitter.com/kmlussier
[OPEN-ILS-GENERAL] Visual accessiblity in the catalog
Hi all, I know there has been a lot of discussion lately regarding a new OPAC for Evergreen, and I'm interested in knowing if any thought has been given to accessibility and usability for the visually impaired. A high priority identified by the MassLNC consortia is to ensure that the catalog is not only accessible to the visually impaired, but that it also has good usability for this group of users. Several months ago, we had contacted staff at the Perkins School for the Blind in Watertown, MA, who said they would be willing to test the accessibility of the Evergreen catalog for people using screen readers and those using screen magnification software. At the time, the KCLS catalog was still under active development, and we were planning to wait and test accessibility using the KCLS skin so that we would be testing something current. However, now that the community is working towards a re-write of the catalog, I'm wondering if there is a way we can get these volunteer involved in the process a little earlier so that some attention can be paid to ensuring that the catalog is accessible. In searching the mailing list archive about accessibility, I see that the SlimPAC was thought to be friendlier to screen readers, but there was no account access from the SlimPAC. I know the new mobile catalog will have account access, but the needs of mobile users are a lot different than the needs of visually-imparied users. I think this would be a great opportunity to make sure we reach out to a group of users who may not have always had good access to their library's catalogs. Thanks! Kathy Lussier - Kathy Lussier Project Coordinator Massachusetts Library Network Cooperative (508) 756-0172 (508) 755-3721 (fax) kluss...@masslnc.org IM: kmlussier (AOL Yahoo) Twitter: http://www.twitter.com/kmlussier
Re: [OPEN-ILS-GENERAL] MassLNC development interests
Thanks Kathy! Looks like your URL got a little goober stuck in it. Here's the right link: http://masslnc.cwmars.org/node/2273 http://masslnc.cwmars.eorg/node/2273. On Fri, Feb 18, 2011 at 9:41 AM, Kathy Lussier kluss...@masslnc.org wrote: Hi all, The Massachusetts Library Network Cooperative is interested in sponsoring more enhancements for Evergreen and would like to share some of our ideas with the community. We're interested in hearing whether others would be interested in seeing these enhancements in Evergreen, if there are suggestions for improving upon our initial requirements, or if there is any overlap with a current development project. The ideas for our next round of development include some support for SMS, the ability to print spine labels on 8 1/2 x 11 sheets, enhancements to book bags, and the ability to access recent searches in the catalog. You can view our full list of possible enhancements with more detailed requirements at http://masslnc.cwmars.eorg/node/2273. We look forward to any feedback you may have! Kathy Lussier - Kathy Lussier Project Coordinator Massachusetts Library Network Cooperative (508) 756-0172 (508) 755-3721 (fax) kluss...@masslnc.org IM: kmlussier (AOL Yahoo) Twitter: http://www.twitter.com/kmlussier -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-= Lori Bowen Ayre // Library Technology Consultant The Galecia Group // www.galecia.com (707) 763-6869 // lori.a...@galecia.com lori.a...@galecia.comSpecializing in open source ILS solutions, RFID, filtering, workflow optimization, and materials handling =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Re: [OPEN-ILS-GENERAL] FW: MassLNC development interests
Thanks to MassLNC for posting this. Regarding Enhancements to Z39.50 import, I always thought it might be useful to provide option to group Z39.50 targets by heading/category, streamlining the listing of large numbers of targets and allowing the targets to be selected at group (like library selector) or arbitrary individual level. Use case: large consortia or single systems with large numbers of targets. George George Duimovich NRCan Library / Bibliothèque de RNCan -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Kathy Lussier Sent: February 18, 2011 13:12 To: 'Evergreen Discussion Group' Subject: [OPEN-ILS-GENERAL] FW: MassLNC development interests My apologies! The URL I sent out had a typo - the corrected URL is below: http://masslnc.cwmars.org/node/2273 Kathy - Kathy Lussier Project Coordinator Massachusetts Library Network Cooperative (508) 756-0172 (508) 755-3721 (fax) kluss...@masslnc.org IM: kmlussier (AOL Yahoo) Twitter: http://www.twitter.com/kmlussier -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Kathy Lussier Sent: Friday, February 18, 2011 12:42 PM To: 'Evergreen Discussion Group' Subject: [OPEN-ILS-GENERAL] MassLNC development interests Hi all, The Massachusetts Library Network Cooperative is interested in sponsoring more enhancements for Evergreen and would like to share some of our ideas with the community. We're interested in hearing whether others would be interested in seeing these enhancements in Evergreen, if there are suggestions for improving upon our initial requirements, or if there is any overlap with a current development project. The ideas for our next round of development include some support for SMS, the ability to print spine labels on 8 1/2 x 11 sheets, enhancements to book bags, and the ability to access recent searches in the catalog. You can view our full list of possible enhancements with more detailed requirements at http://masslnc.cwmars.eorg/node/2273. We look forward to any feedback you may have! Kathy Lussier - Kathy Lussier Project Coordinator Massachusetts Library Network Cooperative (508) 756-0172 (508) 755-3721 (fax) kluss...@masslnc.org IM: kmlussier (AOL Yahoo) Twitter: http://www.twitter.com/kmlussier
[OPEN-ILS-GENERAL] Inventory
I am on a fact finding mission, so if anyone can tell me, have you taken an inventory since you migrated to Evergreen, how did you do it, were there problems, and are there reports to finalize it all and make sure everything scanned etc.? Any help would be greatly appreciated. Thank you Georgette Georgette Rogers Circulation Supervisor Liberty Lake Municipal Library 23123 E Mission Ave Liberty Lake, WA 99019 509-435-0778 1-866-729-8507