[OPEN-ILS-GENERAL] Circulation Policies - list?
All - We already have a rather complicated and multipage circ policies list. Is there ANY way that we can view it and print out the WHOLE list? Rather than the view in the staff client where we see only one page at a time and cannot copy or print the whole table. You can also only sort on the data that is in the current view. It does not sort the whole table, but one page at a time. Very frustrating! On a side note, it would also be great if this table worked like other tables where you can change the size of the columns. Or even better not see some of the columns and have the whole table fit on one screen! That would be marvelous. Any help would be very much appreciated. Thanks! Jennifer -- Jennifer Walz, MLS - person designated to deal with the ILS Kinlaw Library - Asbury University One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu
Re: [OPEN-ILS-GENERAL] Circulation Policies - list?
Hi Jennifer, It is possible to have some control over the display of the Circulation Policies table in the client. If you Right click on the column header row, you'll get a pop-up box with options to sort and choose display fields. Using this sort will apply to the entire table. You can also save your settings so you'll get your preferred view of the table everytime you view it. Here's a page from the 2.6 Evergreen documentation describing this, but this has been true for a few versions back: http://docs.evergreen-ils.org/2.6/_sorting_circulation_policies.html If you Uncheck Auto Width, you should be able to drag the column separators to resize columns. Depending on your Evergreen version, you may also have a Filter option (next to the Back and Next links) option which would allow you to view subsets of the table based on values in the columns. Hope this helps, Michele On 11/7/2014 12:53 PM, Walz, Jennifer wrote: All – We already have a rather complicated and multipage circ policies list. Is there ANY way that we can view it and print out the WHOLE list? Rather than the view in the staff client where we see only one page at a time and cannot copy or print the whole table. You can also only sort on the data that is in the current view. It does not sort the whole table, but one page at a time. Very frustrating! On a side note, it would also be great if this table worked like other tables where you can change the size of the columns. Or even better not see some of the columns and have the whole table fit on one screen! That would be marvelous. Any help would be very much appreciated. Thanks! Jennifer -- Jennifer Walz, MLS – person designated to deal with the ILS Kinlaw Library - *Asbury University* One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu -- Michele Morgan, Technical Assistant North of Boston Library Exchange, Danvers Massachusetts mmor...@noblenet.org
[OPEN-ILS-GENERAL] ***SPAM*** RE: Circulation Policies - list?
That is really wonderful. Thank you. But where will I run this? What kind of output? Is it plain text? Csv file?I suppose this assumes that I have some kind of server access right? Is there a way to run a report? Jennifer -- Jennifer Walz, MLS - Head of Research Distance Services Kinlaw Library - Asbury University One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Yamil Suarez Sent: Friday, November 07, 2014 1:40 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Circulation Policies - list? Jennifer, Here is a SQL query I came up with that was based on something that Ben Shum once posted. It shows all of my circ policies, and the human readable values from most of the circ policies tables by joining with the related tables. SELECT ccmm.id AS ID, ccmm.active AS Active, org.shortname AS copy_circ_lib, pgt.name AS Patron Group, ccmm.circ_modifier AS Circ Modifier, loc.name AS copy_location, ccmm.is_renewal AS Renewal?, ccmm.circulate AS Circulate?, crcd.name AS Circ Duration, crrf.name AS Recurring Fine, ccmm.grace_period, crmf.name AS Max Fine, limit_set.items_out AS Max Items Out, array_to_string(array_agg(lscm.circ_mod), ', ') AS Limited Circ Mods FROM config.circ_matrix_matchpoint ccmm INNER JOIN actor.org_unit aou ON aou.id = ccmm.org_unit INNER JOIN permission.grp_tree pgt ON pgt.id = ccmm.grp INNER JOIN config.rule_circ_duration crcd ON crcd.id = ccmm.duration_rule INNER JOIN config.rule_recurring_fine crrf ON crrf.id = ccmm.recurring_fine_rule INNER JOIN config.rule_max_fine crmf ON crmf.id = ccmm.max_fine_rule LEFT OUTER JOIN config.circ_matrix_limit_set_map map ON map.matchpoint = ccmm.id LEFT OUTER JOIN config.circ_limit_set limit_set ON limit_set.id = map.limit_set LEFT OUTER JOIN config.circ_limit_set_circ_mod_map lscm ON lscm.limit_set = limit_set.id LEFT OUTER JOIN actor.org_unit org on (ccmm.copy_circ_lib = org.id) LEFT OUTER JOIN asset.copy_location loc on (loc.id = ccmm.copy_location) WHERE ccmm.copy_circ_lib = 101 GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9,10, 11, 12, 13 ORDER BY copy_circ_lib, pgt.name, ccmm.circ_modifier; You may want someone that know SQL to make some tweaks make it look the way you need, for example by change what you sort by. Right now it is sorting by the copy circulation library, the patron group, and the circ modifier. Hope it helps, Yamil On Fri, Nov 7, 2014 at 12:53 PM, Walz, Jennifer jlw...@asbury.edu wrote: All – We already have a rather complicated and multipage circ policies list. Is there ANY way that we can view it and print out the WHOLE list? Rather than the view in the staff client where we see only one page at a time and cannot copy or print the whole table. You can also only sort on the data that is in the current view. It does not sort the whole table, but one page at a time. Very frustrating! On a side note, it would also be great if this table worked like other tables where you can change the size of the columns. Or even better not see some of the columns and have the whole table fit on one screen! That would be marvelous. Any help would be very much appreciated. Thanks! Jennifer -- Jennifer Walz, MLS – person designated to deal with the ILS Kinlaw Library - Asbury University One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu -- Yamil Suarez, MCS Library System Administrator/Developer Stan Getz Library Berklee College of Music 1140 Boylston St Boston, MA 02215 ysua...@berklee.edu 617-747-2617
Re: [OPEN-ILS-GENERAL] ***SPAM*** RE: Circulation Policies - list?
Jennifer, Do you have a support vendor? They should be able to run it on the server for you and output to CSV, Tab Delimited, etc. If you do not, we would be happy to help out, as we offer a variety of support options for Evergreen, including one-time hourly support. Please feel free to give me a call if we can be of any assistance to you. Michael Peters Senior Systems Analyst Emerald Data Networks, Inc. Phone: 678.302.3000 x1013 Help Desk: 678.302.3000 x1500 www.emeralddata.net -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Walz, Jennifer Sent: Friday, November 07, 2014 3:36 PM To: Evergreen Discussion Group Subject: [OPEN-ILS-GENERAL] ***SPAM*** RE: Circulation Policies - list? That is really wonderful. Thank you. But where will I run this? What kind of output? Is it plain text? Csv file?I suppose this assumes that I have some kind of server access right? Is there a way to run a report? Jennifer -- Jennifer Walz, MLS - Head of Research Distance Services Kinlaw Library - Asbury University One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Yamil Suarez Sent: Friday, November 07, 2014 1:40 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Circulation Policies - list? Jennifer, Here is a SQL query I came up with that was based on something that Ben Shum once posted. It shows all of my circ policies, and the human readable values from most of the circ policies tables by joining with the related tables. SELECT ccmm.id AS ID, ccmm.active AS Active, org.shortname AS copy_circ_lib, pgt.name AS Patron Group, ccmm.circ_modifier AS Circ Modifier, loc.name AS copy_location, ccmm.is_renewal AS Renewal?, ccmm.circulate AS Circulate?, crcd.name AS Circ Duration, crrf.name AS Recurring Fine, ccmm.grace_period, crmf.name AS Max Fine, limit_set.items_out AS Max Items Out, array_to_string(array_agg(lscm.circ_mod), ', ') AS Limited Circ Mods FROM config.circ_matrix_matchpoint ccmm INNER JOIN actor.org_unit aou ON aou.id = ccmm.org_unit INNER JOIN permission.grp_tree pgt ON pgt.id = ccmm.grp INNER JOIN config.rule_circ_duration crcd ON crcd.id = ccmm.duration_rule INNER JOIN config.rule_recurring_fine crrf ON crrf.id = ccmm.recurring_fine_rule INNER JOIN config.rule_max_fine crmf ON crmf.id = ccmm.max_fine_rule LEFT OUTER JOIN config.circ_matrix_limit_set_map map ON map.matchpoint = ccmm.id LEFT OUTER JOIN config.circ_limit_set limit_set ON limit_set.id = map.limit_set LEFT OUTER JOIN config.circ_limit_set_circ_mod_map lscm ON lscm.limit_set = limit_set.id LEFT OUTER JOIN actor.org_unit org on (ccmm.copy_circ_lib = org.id) LEFT OUTER JOIN asset.copy_location loc on (loc.id = ccmm.copy_location) WHERE ccmm.copy_circ_lib = 101 GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9,10, 11, 12, 13 ORDER BY copy_circ_lib, pgt.name, ccmm.circ_modifier; You may want someone that know SQL to make some tweaks make it look the way you need, for example by change what you sort by. Right now it is sorting by the copy circulation library, the patron group, and the circ modifier. Hope it helps, Yamil On Fri, Nov 7, 2014 at 12:53 PM, Walz, Jennifer jlw...@asbury.edu wrote: All – We already have a rather complicated and multipage circ policies list. Is there ANY way that we can view it and print out the WHOLE list? Rather than the view in the staff client where we see only one page at a time and cannot copy or print the whole table. You can also only sort on the data that is in the current view. It does not sort the whole table, but one page at a time. Very frustrating! On a side note, it would also be great if this table worked like other tables where you can change the size of the columns. Or even better not see some of the columns and have the whole table fit on one screen! That would be marvelous. Any help would be very much appreciated. Thanks! Jennifer -- Jennifer Walz, MLS – person designated to deal with the ILS Kinlaw Library - Asbury University One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu -- Yamil Suarez, MCS Library System Administrator/Developer Stan Getz Library Berklee College of Music 1140 Boylston St Boston, MA 02215 ysua...@berklee.edu 617-747-2617
Re: [OPEN-ILS-GENERAL] Circulation Policies - list?
Personally I agree with Yamil that sql is the best way to go about this. His report is a good basic one. Depending on what you want you could get much more complicated. If you're looking for something to do troubleshooting with, see interaction with the values set in the circ matrix matchpoints, circ limits, etc... it can get far more complicated (and pretty darn verbose). On Fri, Nov 7, 2014 at 1:39 PM, Yamil Suarez ysua...@berklee.edu wrote: Jennifer, Here is a SQL query I came up with that was based on something that Ben Shum once posted. It shows all of my circ policies, and the human readable values from most of the circ policies tables by joining with the related tables. SELECT ccmm.id AS ID, ccmm.active AS Active, org.shortname AS copy_circ_lib, pgt.name AS Patron Group, ccmm.circ_modifier AS Circ Modifier, loc.name AS copy_location, ccmm.is_renewal AS Renewal?, ccmm.circulate AS Circulate?, crcd.name AS Circ Duration, crrf.name AS Recurring Fine, ccmm.grace_period, crmf.name AS Max Fine, limit_set.items_out AS Max Items Out, array_to_string(array_agg(lscm.circ_mod), ', ') AS Limited Circ Mods FROM config.circ_matrix_matchpoint ccmm INNER JOIN actor.org_unit aou ON aou.id = ccmm.org_unit INNER JOIN permission.grp_tree pgt ON pgt.id = ccmm.grp INNER JOIN config.rule_circ_duration crcd ON crcd.id = ccmm.duration_rule INNER JOIN config.rule_recurring_fine crrf ON crrf.id = ccmm.recurring_fine_rule INNER JOIN config.rule_max_fine crmf ON crmf.id = ccmm.max_fine_rule LEFT OUTER JOIN config.circ_matrix_limit_set_map map ON map.matchpoint = ccmm.id LEFT OUTER JOIN config.circ_limit_set limit_set ON limit_set.id = map.limit_set LEFT OUTER JOIN config.circ_limit_set_circ_mod_map lscm ON lscm.limit_set = limit_set.id LEFT OUTER JOIN actor.org_unit org on (ccmm.copy_circ_lib = org.id) LEFT OUTER JOIN asset.copy_location loc on (loc.id = ccmm.copy_location) WHERE ccmm.copy_circ_lib = 101 GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9,10, 11, 12, 13 ORDER BY copy_circ_lib, pgt.name, ccmm.circ_modifier; You may want someone that know SQL to make some tweaks make it look the way you need, for example by change what you sort by. Right now it is sorting by the copy circulation library, the patron group, and the circ modifier. Hope it helps, Yamil On Fri, Nov 7, 2014 at 12:53 PM, Walz, Jennifer jlw...@asbury.edu wrote: All – We already have a rather complicated and multipage circ policies list. Is there ANY way that we can view it and print out the WHOLE list? Rather than the view in the staff client where we see only one page at a time and cannot copy or print the whole table. You can also only sort on the data that is in the current view. It does not sort the whole table, but one page at a time. Very frustrating! On a side note, it would also be great if this table worked like other tables where you can change the size of the columns. Or even better not see some of the columns and have the whole table fit on one screen! That would be marvelous. Any help would be very much appreciated. Thanks! Jennifer -- Jennifer Walz, MLS – person designated to deal with the ILS Kinlaw Library - Asbury University One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu -- Yamil Suarez, MCS Library System Administrator/Developer Stan Getz Library Berklee College of Music 1140 Boylston St Boston, MA 02215 ysua...@berklee.edu 617-747-2617 -- Rogan Hamby, MLS, CCNP, MIA Managers Headquarters Library and Reference Services, York County Library System “You can never get a cup of tea large enough or a book long enough to suit me.” ― C.S. Lewis http://www.goodreads.com/author/show/1069006.C_S_Lewis
Re: [OPEN-ILS-GENERAL] ***SPAM*** RE: Circulation Policies - list?
Jennifer, To run my SQL code you will need to have access to the Postgres database that Evergreen uses. Your systems librarian or local system administrator should be able to connect with a command line tool like psql (a copy of it comes with Postgres and lives on the server), or a graphical tool like pgAdmin[1] that can be installed on a library staff person's machine. I believe your library was using Horizon, like I was. If some one there used to run raw SQL code on the database that Horizon used (Sybase or MSSQL), then they should be able to connect with one of the tools I mentioned above to run a version of my SQL code to get you your list. Feel free to ask someone on your end to contact me for some tips or keep asking on this mailing list or IRC. BTW, I also get Evergreen support from a vendor when I am really stumped or for emergencies. Good luck, Yamil [1] http://www.pgadmin.org/ On Fri, Nov 7, 2014 at 3:35 PM, Walz, Jennifer jlw...@asbury.edu wrote: That is really wonderful. Thank you. But where will I run this? What kind of output? Is it plain text? Csv file?I suppose this assumes that I have some kind of server access right? Is there a way to run a report? Jennifer -- Jennifer Walz, MLS - Head of Research Distance Services Kinlaw Library - Asbury University One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu -Original Message- From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Yamil Suarez Sent: Friday, November 07, 2014 1:40 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] Circulation Policies - list? Jennifer, Here is a SQL query I came up with that was based on something that Ben Shum once posted. It shows all of my circ policies, and the human readable values from most of the circ policies tables by joining with the related tables. SELECT ccmm.id AS ID, ccmm.active AS Active, org.shortname AS copy_circ_lib, pgt.name AS Patron Group, ccmm.circ_modifier AS Circ Modifier, loc.name AS copy_location, ccmm.is_renewal AS Renewal?, ccmm.circulate AS Circulate?, crcd.name AS Circ Duration, crrf.name AS Recurring Fine, ccmm.grace_period, crmf.name AS Max Fine, limit_set.items_out AS Max Items Out, array_to_string(array_agg(lscm.circ_mod), ', ') AS Limited Circ Mods FROM config.circ_matrix_matchpoint ccmm INNER JOIN actor.org_unit aou ON aou.id = ccmm.org_unit INNER JOIN permission.grp_tree pgt ON pgt.id = ccmm.grp INNER JOIN config.rule_circ_duration crcd ON crcd.id = ccmm.duration_rule INNER JOIN config.rule_recurring_fine crrf ON crrf.id = ccmm.recurring_fine_rule INNER JOIN config.rule_max_fine crmf ON crmf.id = ccmm.max_fine_rule LEFT OUTER JOIN config.circ_matrix_limit_set_map map ON map.matchpoint = ccmm.id LEFT OUTER JOIN config.circ_limit_set limit_set ON limit_set.id = map.limit_set LEFT OUTER JOIN config.circ_limit_set_circ_mod_map lscm ON lscm.limit_set = limit_set.id LEFT OUTER JOIN actor.org_unit org on (ccmm.copy_circ_lib = org.id) LEFT OUTER JOIN asset.copy_location loc on (loc.id = ccmm.copy_location) WHERE ccmm.copy_circ_lib = 101 GROUP BY 1, 2, 3, 4, 5, 6, 7, 8, 9,10, 11, 12, 13 ORDER BY copy_circ_lib, pgt.name, ccmm.circ_modifier; You may want someone that know SQL to make some tweaks make it look the way you need, for example by change what you sort by. Right now it is sorting by the copy circulation library, the patron group, and the circ modifier. Hope it helps, Yamil On Fri, Nov 7, 2014 at 12:53 PM, Walz, Jennifer jlw...@asbury.edu wrote: All – We already have a rather complicated and multipage circ policies list. Is there ANY way that we can view it and print out the WHOLE list? Rather than the view in the staff client where we see only one page at a time and cannot copy or print the whole table. You can also only sort on the data that is in the current view. It does not sort the whole table, but one page at a time. Very frustrating! On a side note, it would also be great if this table worked like other tables where you can change the size of the columns. Or even better not see some of the columns and have the whole table fit on one screen! That would be marvelous. Any help would be very much appreciated. Thanks! Jennifer -- Jennifer Walz, MLS – person designated to deal with the ILS Kinlaw Library - Asbury University One Macklem Drive, Wilmore, KY 40390 859-858-3511 ext. 2269 jlw...@asbury.edu -- Yamil Suarez, MCS Library System Administrator/Developer Stan Getz Library Berklee College of Music 1140 Boylston St Boston, MA 02215 ysua...@berklee.edu 617-747-2617 --