[OPEN-ILS-GENERAL] Reminder for Conference proposals

Thu Feb 12 11:04:34 EST 2015

+1

This would be in general a very helpful approach for me.  Starting large and whittling it down to a specific need.

Thanks,
Geoff Sams
Library Manager
Roanoke Public Library

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Rogan Hamby
Sent: Thursday, February 12, 2015 8:20 AM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Reminder for Conference proposals

Certainly there is a sort of feedback loop between SQL and the Reporter.  I was thinking along the lines of doing some practical ones that show off common useful features in SQL like UNION statements (great for weeding and circulation reports) and the idea of using a query as a source for a join (great for too many things to mention).

Specifically, what I'd like to do in a workshop is maybe start with a very basic statement like

select * from asset.copy;

which isn't very useful since it's just a dump of the copy table and how do you get to a robust weeding report, showing not just the code but at least one way of how to approach it as a process.

Along the way I'd like to showcase some "this isn't how they'd tell you to do it in a book but let's be good librarians" ways to do things, like using the online Postgres docs (OK, a book would tell you that) and, frankly, using Google.  I've gotten many a good idea off Stack Exchange.  Additionally, I think it would be useful to show people how to access a git copy of Evergreen because the code itself is invaluable once you dig deeply into reports.  Not sure where the heck that foreign key leads off to?  Going the source may seem intimidating to many people but it's actually very easy and a huge time saver once it's demystified.

On Wed, Feb 11, 2015 at 9:18 PM, Geoff Sams <GSams at roanoketexas.com<mailto:GSams at roanoketexas.com>> wrote:
I’m not sure that I’d be speaking for a majority, but I’d like to see some of the more difficult requests for information that you may have gotten.  Okay, maybe moderately difficult for you, I’m not asking for the magnum opus “weeding query” (I think that was what you said it was anyway, it’s been almost a year now) that you showed a snippet of last year.  But sometimes I get requests that don’t seem feasibly possible in reports that if I were a bit more comfortable I’d be happy to tackle in SQL.  I feel bad because I don’t have an example coming to mind today, but if I think of something I’d be happy to forward it along.

Other than that, perhaps a mashup between SQL and reports would be helpful to some?  Showing how certain choices translate between reports and SQL?  I’m not sure if that would be helpful or not really, but it seemed like an idea.

Thanks,
Geoff Sams
Library Manager
Roanoke Public Library

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org<mailto:open-ils-general-bounces at list.georgialibraries.org>] On Behalf Of Rogan Hamby
Sent: Wednesday, February 11, 2015 7:53 PM

To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Reminder for Conference proposals

If I do a hands on workshop (I threw a rough proposal up) what kinds of sql tasks would folks like to step through as learning examples?

On Wed, Feb 11, 2015 at 5:24 PM, Holly Brennan <haderhold at ci.homer.ak.us<mailto:haderhold at ci.homer.ak.us>> wrote:
+1

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org<mailto:open-ils-general-bounces at list.georgialibraries.org>] On Behalf Of Rogan Hamby
Sent: Wednesday, February 11, 2015 1:21 PM

To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Reminder for Conference proposals

I had been hoping to do a half day session this year but I was under the impression that format wasn't an option this year.  I may have misunderstood though.  Heck, I'll put one on the proposal listing and we'll see what works out in the wash.

On Wednesday, February 11, 2015, Holly Brennan <haderhold at ci.homer.ak.us<mailto:haderhold at ci.homer.ak.us>> wrote:

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Rogan Hamby
Sent: Wednesday, February 11, 2015 12:46 PM
To: Evergreen Discussion Group
Subject: Re: [OPEN-ILS-GENERAL] Reminder for Conference proposals

I'm game for that.  Heck I'll take requests if someone finds me space in the schedule.  I'm willing to do anything useful to others.  I learn from others continually in the community so I'm glad to do what I can.

What would you like?  Something like a workshop?

>>Something like the half day tutorial would be terrific! Having your session last year on Saturday (and only 1 hour) made it difficult to digest, and I left the conference wanting more. Heck, you could just re-present your session from 2014! I will still attend it every year. ☺

-Holly

On Wednesday, February 11, 2015, Holly Brennan <haderhold at ci.homer.ak.us<mailto:haderhold at ci.homer.ak.us>> wrote:
I’m really hoping that Rogan (or someone) will be doing a longer SQL session this year! ☺

From: Open-ils-general [mailto:open-ils-general-bounces at list.georgialibraries.org] On Behalf Of Beth Longwell
Sent: Wednesday, February 11, 2015 10:54 AM
To: Evergreen Discussion Group
Subject: [OPEN-ILS-GENERAL] Reminder for Conference proposals

Hi everyone,
Just a gentle reminder to submit your program proposals for the upcoming Evergreen conference. Below is the original message. Thanks to those who have already submitted.
Beth

-----------------------
Dear Evergreen Community,

The 2015 Evergreen International Conference Program Committee is seeking program proposals for this year's conference. The conference will be held in Hood River, Oregon May 13-16, 2015.

There are three programming tracks:

  *   End User: best practices and techniques for using Evergreen in day-to-day library operations
  *   General: programs on administration, training, making the decision to move to Evergreen, participating in the Evergreen community, and other topics related to using Evergreen and open source software
  *   Technical: topics related to system administration, software development, implementation, hardware, and integration with other software
The deadline for submission is February 27, 2015.

Help us make this conference a great one by submitting your idea for a program. For more details on how to submit your proposal, tips, the review process, and sample program topics go to http://evergreen-ils.org/conference/proposals/

--

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>

--

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>

--

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>

--

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>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150212/cc8e17bc/attachment-0001.html>