[OPEN-ILS-GENERAL] Reminder for Conference proposals

Thu Feb 12 09:20:10 EST 2015

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> 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] *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>
> wrote:
>
>  +1
>
>
>
> *From:* Open-ils-general [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>
> wrote:
>
>
>
>
>
> *From:* Open-ils-general [
> mailto:open-ils-general-bounces at list.georgialibraries.org
> <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. J
>
>
>
> -Holly
>
>
>
> On Wednesday, February 11, 2015, Holly Brennan <haderhold at ci.homer.ak.us>
> wrote:
>
> I’m really hoping that Rogan (or someone) will be doing a longer SQL
> session this year! J
>
>
>
> *From:* Open-ils-general [
> mailto:open-ils-general-bounces at list.georgialibraries.org
> <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/395ac3cc/attachment.html>