[OPEN-ILS-GENERAL] Reminder for Conference proposals

Thu Feb 12 11:12:00 EST 2015

+1 to anything regarding reports.

On Thu, Feb 12, 2015 at 11:04 AM, Geoff Sams <GSams at roanoketexas.com> wrote:

>  +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>
> 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>
>

-- 
Ruth Frasur
Director of the Historic(ally Awesome) Hagerstown - Jefferson Township
Library
10 W. College Street in Hagerstown, Indiana (47346)
p (765) 489-5632; f (765) 489-5808

Our Kickin' Website <http://hagerstownlibrary.org>  Our Rockin' Facebook
Page <http://facebook.com/hjtplibrary>  and Stuff I'm Reading
<http://pinterest.com/hjtplibrary/ruth-reads/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20150212/d409051a/attachment-0001.html>