[OPEN-ILS-GENERAL] live coverage from egcon2013
Hi, The live page on the conference website is now up: http://eg2013.evergreen-ils.org/live/ You'll find the Twitter feed (conference hashtag is #egcon2013), notes from our live note takers and video. The main track is being recorded and we hope to post the video in a few weeks. The tech track will be live streamed. Today's tech track starts at 11am Vancouver time. If you're at the conference and willing to be our volunteer conference photographer, please get in touch and we'll add your Flickr feed to this page too. If you have other ideas on making the conference better, please do it. Yesterday Jeff Davis had a great idea about taking photos of people who were at the Hackfest with their IRC handles, so you can match the handle to the face later. I hope this happens!!! If there's anything me or the other members of the organizing committee can do to help--please let us know. Cheers, Tara
[OPEN-ILS-GENERAL] SQL question
I need to count (via SQL) the number of checkout transactions that fall with 1/1/2012 and 12/31/2012. Could someone point me at the right table/fields to look at checkout transactions for my library (we are in a consortium). Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, TX 76248 jephr...@roanoketexas.com 817-491-2691
Re: [OPEN-ILS-GENERAL] SQL question
You want the action.circulation table. I would use the following query: SELECT COUNT(action.circulation.id) AS Circs FROM action.circulation WHERE DATE(xact_start) BETWEEN '2012-01-01' AND '2012-12-31' AND circ_lib = XXX /*Put your library ID in here, it can be found in actor.org_unit.id*/ AND phone_renewal IS FALSE /*Remove this if you want Phone renewals to be counted*/ AND desk_renewal IS FALSE /*Remove this if you want Circ Desk renewals to be counted*/ AND opac_renewal IS FALSE /*Remove this if you want OPAC renewals to be counted*/; Aaron Z Jr. Systems Administrator Pioneer Library System 2557 State Rt. 21 Canandaigua, New York 14424 Phone: (585) 394-8260 - Original Message - From: Jesse Ephraim jephr...@roanoketexas.com To: Evergreen Discussion Group open-ils-general@list.georgialibraries.org Sent: Thursday, April 11, 2013 1:36:47 PM Subject: [OPEN-ILS-GENERAL] SQL question I need to count (via SQL) the number of checkout transactions that fall with 1/1/2012 and 12/31/2012. Could someone point me at the right table/fields to look at checkout transactions for my library (we are in a consortium). Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, TX 76248 jephr...@roanoketexas.com 817-491-2691
Re: [OPEN-ILS-GENERAL] SQL question
Thanks much, Aaron – I appreciate it! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, TX 76248 jephr...@roanoketexas.com 817-491-2691 From: open-ils-general-boun...@list.georgialibraries.org [mailto:open-ils-general-boun...@list.georgialibraries.org] On Behalf Of Aaron Zsembery Sent: Thursday, April 11, 2013 1:03 PM To: Evergreen Discussion Group Subject: Re: [OPEN-ILS-GENERAL] SQL question You want the action.circulation table. I would use the following query: SELECT COUNT(action.circulation.id) AS Circs FROM action.circulation WHERE DATE(xact_start) BETWEEN '2012-01-01' AND '2012-12-31' AND circ_lib = XXX /*Put your library ID in here, it can be found in actor.org_unit.id*/ AND phone_renewal IS FALSE /*Remove this if you want Phone renewals to be counted*/ AND desk_renewal IS FALSE /*Remove this if you want Circ Desk renewals to be counted*/ AND opac_renewal IS FALSE /*Remove this if you want OPAC renewals to be counted*/; Aaron Z Jr. Systems Administrator Pioneer Library System 2557 State Rt. 21 Canandaigua, New York 14424 Phone: (585) 394-8260 From: Jesse Ephraim jephr...@roanoketexas.commailto:jephr...@roanoketexas.com To: Evergreen Discussion Group open-ils-general@list.georgialibraries.orgmailto:open-ils-general@list.georgialibraries.org Sent: Thursday, April 11, 2013 1:36:47 PM Subject: [OPEN-ILS-GENERAL] SQL question I need to count (via SQL) the number of checkout transactions that fall with 1/1/2012 and 12/31/2012. Could someone point me at the right table/fields to look at checkout transactions for my library (we are in a consortium). Thanks! Jesse Ephraim Director, Roanoke Public Library 308 S. Walnut Roanoke, TX 76248 jephr...@roanoketexas.commailto:jephr...@roanoketexas.com 817-491-2691
Re: [OPEN-ILS-GENERAL] SQL question
Additionally if you're in a system in a consortium (versus single library) you may want not just for one library but for your library system you may want to make a join and go by parent org ie... SELECT COUNT(action.circulation.id) AS Circs FROM action.circulation circ JOIN actor.org_unit org on org.id = circ.circ_lib WHERE DATE(xact_start) BETWEEN '2012-01-01' AND '2012-12-31' AND org.parent_ou = XXX /*Put library system org id found in actor.org_unit.id*/ AND circ.phone_renewal IS FALSE /*Remove this if you want Phone renewals to be counted*/ AND circ.desk_renewal IS FALSE /*Remove this if you want Circ Desk renewals to be counted*/ AND circ.opac_renewal IS FALSE /*Remove this if you want OPAC renewals to be counted*/; On Thu, Apr 11, 2013 at 11:02 AM, Aaron Zsembery azsemb...@pls-net.orgwrote: You want the action.circulation table. I would use the following query: SELECT COUNT(action.circulation.id) AS Circs FROM action.circulation WHERE DATE(xact_start) BETWEEN '2012-01-01' AND '2012-12-31' AND circ_lib = XXX /*Put your library ID in here, it can be found in actor.org_unit.id*/ AND phone_renewal IS FALSE /*Remove this if you want Phone renewals to be counted*/ AND desk_renewal IS FALSE /*Remove this if you want Circ Desk renewals to be counted*/ AND opac_renewal IS FALSE /*Remove this if you want OPAC renewals to be counted*/; Aaron Z Jr. Systems Administrator Pioneer Library System 2557 State Rt. 21 Canandaigua, New York 14424 Phone: (585) 394-8260 -- *From: *Jesse Ephraim jephr...@roanoketexas.com *To: *Evergreen Discussion Group open-ils-general@list.georgialibraries.org *Sent: *Thursday, April 11, 2013 1:36:47 PM *Subject: *[OPEN-ILS-GENERAL] SQL question I need to count (via SQL) the number of checkout transactions that fall with 1/1/2012 and 12/31/2012. Could someone point me at the right table/fields to look at checkout transactions for my library (we are in a consortium). Thanks! Jesse Ephraim Director, Roanoke Public Library * * *308 S. Walnut* *Roanoke, TX 76248* *jephr...@roanoketexas.com* *817-491-2691* -- 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] What software do you use for Evergreen training?
Hi all, Here in our consortium, we've used Join.me (www.join.me) with pretty good success as well as Google Hangouts for group training. Join.me is great for one on one training as well as remote desktop support. Google Hangouts is a great alternative to more traditional webinar-type software, but can be limiting as far as participants Tony Bandy to...@ohionet.org OHIONET 1500 West Lane Ave. Columbus, OH 43221-3975 614-486-2966 x19 On Wed, Apr 10, 2013 at 3:35 PM, Elizabeth Thomsen e...@noblenet.org wrote: The Trainers Interest Group had a lively meeting at the Evergreen Conference this morning, and one of the things we discussed was the various programs we use for training. This includes online meeting/training/webinar systems, software for screencasting and more. But we want to share with everyone, not just the group who was in the room this morning, so we thought we'd take ask everyone. Please share what you use, tell us anything about how you use it or why you chose a particular program, and any problems or limitations you've encountered with it. If there's interest, we'll organize this and post a list, but for now, let's start talking about it! Thanks! -- Elizabeth Thomsen, Member Services Manager NOBLE: North of Boston Library Exchange 26 Cherry Hill Drive Danvers Massachusetts 01923 E-mail: e...@noblenet.org