| Time |
Nick |
Message |
| 05:17 |
pinesol_green |
Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html> |
| 07:30 |
|
jboyer-isl joined #evergreen |
| 07:33 |
|
graced joined #evergreen |
| 07:52 |
|
rjackson_isl joined #evergreen |
| 08:00 |
|
ericar joined #evergreen |
| 08:06 |
|
collum joined #evergreen |
| 08:07 |
|
mrpeters joined #evergreen |
| 08:08 |
|
TaraC joined #evergreen |
| 08:31 |
|
mmorgan joined #evergreen |
| 08:42 |
|
Shae joined #evergreen |
| 08:50 |
|
akilsdonk joined #evergreen |
| 09:00 |
|
maryj joined #evergreen |
| 09:08 |
|
Dyrcona joined #evergreen |
| 09:21 |
* csharp |
comes up with a (probably unfair) rule of thumb that when given the chance, and enough committee meetings, librarians turn what should be simple in to something complicated :-/ |
| 09:21 |
csharp |
"but what about ____?" |
| 09:21 |
dbs |
corollary: when given a chance, librarians will turn a simple decision into a committee meeting |
| 09:22 |
csharp |
dbs++ |
| 09:22 |
mmorgan |
s/librarians/<almost anyone> ;-) |
| 09:22 |
dbs |
mmorgan++ |
| 09:22 |
* csharp |
is scheduled up to to the teeth with exactly those kinds of meetings for the next 2 days |
| 09:22 |
csharp |
however, my original comment referred to creating reports templates |
| 09:23 |
csharp |
the descriptions are things like "total circs by library" but they become massive templates with many knobs and buttons ;-) |
| 09:27 |
tsbere |
"Give us a list of holds" ends up implying "and every piece of data we have ever considered being possibly useful from the bib those holds are placed on" |
| 09:27 |
tsbere |
<_< |
| 09:28 |
csharp |
tsbere: right |
| 09:29 |
csharp |
I'm also dealing with the "we want this to display *and* be a filter" issue (which in most cases means potentially excluding the very data they're after) |
| 09:29 |
tsbere |
And of course the "Oh, and can we get information from other levels? This report is based on bib records, but we want these copy stat cats included...." |
| 09:30 |
csharp |
there are use cases for "cast broadly" reports and for "targeted" reports - and they can't be all-in-one as our end users desire |
| 09:30 |
csharp |
yep |
| 09:30 |
dbs |
csharp: there's pgdump you know |
| 09:30 |
csharp |
:-) |
| 09:31 |
csharp |
actually, we often recommend that they cast broadly and sort it all out in Excel, which is way better at doing what they're actually after |
| 09:31 |
jeff |
this is why i like reports that link to subreports for the specific details, or just link to the catalog. it's rare that that level is detail is desired to be printed or sorted or even seen on the screen all at once, and for those, we handle with another report. |
| 09:31 |
tsbere |
One of my favorites from a phone conversation: They wanted a list of bibs that their patrons had placed holds on, that they don't have copies of, that met some other criteria. And one of the output columns they wanted was their call number. |
| 09:31 |
csharp |
but then the problem is one of poor Excel competency :-/ |
| 09:31 |
jeff |
an optional subreport is also a possibility -- i'm pretty sure i can do that without too much effort, though i've not tried yet. |
| 09:33 |
jeff |
"here's a count of different circ modifiers in each shelving location at or below this org unit. what, you want to know which items in the Browsing Hot DVDs shelving location have circ modifier BOOK? click on that line." |
| 09:34 |
jeff |
rather, "you see two items with circ modifier BOOK in what seems to be the wrong shelving location and want to see what those two items are? click." |
| 09:35 |
jeff |
sometimes i miss procmail. i have an automated mail where i like to set a label if the mail contains "Warning: " |
| 09:35 |
jeff |
but it false positives when the output contains this title: ``Warning: do not open this book!'' |
| 09:52 |
Dyrcona |
Whee! Finding out you didn't move over a couple of circ rules from your migration that you did four years ago! |
| 09:53 |
Dyrcona |
No, wait. It is there, but I must need more than 1 rule. |
| 10:00 |
Dyrcona |
So, an example of complicating things.... |
| 10:00 |
Dyrcona |
That rule I was talking about being missing. |
| 10:00 |
Dyrcona |
It's there and it works. |
| 10:01 |
Dyrcona |
It stops patrons in a certain group from circulating anything anywhere. |
| 10:01 |
Dyrcona |
However, we have patrons in that group who were barred. |
| 10:01 |
Dyrcona |
Why? |
| 10:01 |
Dyrcona |
There's also a rules that blocks them from placing holds. |
| 10:02 |
Dyrcona |
However, there are 680 other rules that allow anyone to place holds for certain things for local pickup only. |
| 10:02 |
Dyrcona |
Apparently, I need 680 exceptions to those other rules. |
| 10:02 |
Dyrcona |
Just another case of, we want people to place holds on everything, except this and this and this and that stuff over there, and.... |
| 10:04 |
Dyrcona |
Oh, and except these people.... |
| 10:05 |
Dyrcona |
I suppose before I add another 680 hold matrix entries, I should test if the rules are already working as intended. |
| 10:06 |
Dyrcona |
Without an actual test, it is all conjecture and anecdotes. |
| 10:14 |
jonadab |
Every time you large-library-system people start talking about holds, I remember how glad I am to work for a single-ou library system. |
| 10:15 |
Dyrcona |
Well, I may be going to a lot of trouble for nothing. |
| 10:15 |
jeff |
if we could eliminate our use of age hold protection, i'd be pretty happy with holds in general. our rules are pretty simple. |
| 10:15 |
Dyrcona |
We only have 24 of these patrons, and 7 are expired. |
| 10:16 |
jeff |
it's the "you can't have that unless you go there to pick it up" that's hard to explain without sounding ridiculous. |
| 10:16 |
jonadab |
Ah. |
| 10:16 |
jonadab |
For us that would be either "I'm sorry, we don't have that, do you want me to see if we can get it for you from another library?" |
| 10:17 |
jeff |
but we're not "large", either. six locations in this district. |
| 10:17 |
eeevil |
Dyrcona: you could consider giving those 17 users a custom penalty that blocks holds and circs, instead of using rules |
| 10:17 |
jonadab |
And then if the organization we ILL from doesn't have it, then "I'm sorry, we can't get that one." |
| 10:17 |
eeevil |
(IIUC) |
| 10:17 |
Dyrcona |
eeevil: Staff have been barring them, but the group should be working, and for circ I'm confident that it is. |
| 10:18 |
Dyrcona |
I think it might not be block holds. |
| 10:18 |
jonadab |
Admittedly, you don't really want to know about the system we're using for ILL circs. It's... a holdover from a holdover. |
| 10:18 |
jonadab |
(It involves barcodes on 3x5 cards...) |
| 10:18 |
Dyrcona |
And, I need to reember to add this group to our NCIPServer config as a blocked group. |
| 10:19 |
Dyrcona |
jeff: We have a lot of that "you have to go here to pick it up" stuff, and that's where I think my trouble lies. |
| 10:19 |
eeevil |
Dyrcona: I suspect that the behavior is "allow holds, just don't allow them to actually pick them up" ... some libraries treat that as a way to get "bad" patrons to come in and pay their fines. "Hey, you're book's here!" |
| 10:19 |
jeff |
jonadab: sometimes i think i'd love a system that involved barcodes on cards. we have to fire up a modified/stripped client for an ILS we don't use in order to process items from our state ILL system. :-) |
| 10:20 |
Dyrcona |
eeevil: We have that on the penalties, not on groups, and that was not the intention here. |
| 10:20 |
Dyrcona |
Mass. has this notion of "certified for ILL." |
| 10:20 |
jeff |
eeevil: we do that, but alas it sounds like in Dyrcona's case there's no easy way to bring the patron back into good standing. :-) |
| 10:20 |
eeevil |
Dyrcona: gotcha ... I'll hush :) |
| 10:20 |
Dyrcona |
Mass. also has a law that says you must serve any patron from a certified library. |
| 10:20 |
Dyrcona |
So, we put their home barcode in our system. |
| 10:21 |
Dyrcona |
When a library loses its ILL certification, we put them into this group. |
| 10:21 |
Dyrcona |
Of course, we almost never take them out later..... |
| 10:21 |
Dyrcona |
But, seems like a lot of effort for 24 out of 600,000 patrons. |
| 10:21 |
Dyrcona |
give or take. |
| 10:21 |
|
RoganH joined #evergreen |
| 10:21 |
jeff |
Are these patrons eligible to receive any kind of service from your libraries? Why not set them to that group + inactive and/or barred? |
| 10:23 |
Dyrcona |
Well, why do that? TIMTOWTDI! |
| 10:27 |
Dyrcona |
Trouble is, as usual, I'm getting information third hand, so I can't trust any of it. |
| 10:28 |
|
jwoodard joined #evergreen |
| 10:46 |
_bott_ |
Please forgive my not looking for the answer first, but what's the best Postgres version to use these days. Any gotchas with 9.4.x? |
| 10:49 |
|
mrpeters joined #evergreen |
| 10:52 |
|
ningalls joined #evergreen |
| 10:53 |
Dyrcona |
_bott_: AFAIK, 9.3.6 is the highest being used in production. |
| 10:54 |
Dyrcona |
_bott_: That said, I am not aware of any problems with 9.4.x. |
| 10:55 |
_bott_ |
I shall pay attention while testing! |
| 10:57 |
|
vlewis joined #evergreen |
| 10:57 |
|
vlewis_ joined #evergreen |
| 11:01 |
|
RoganH joined #evergreen |
| 11:06 |
csharp |
_bott_: we're very happy on 9.3.X |
| 11:06 |
Dyrcona |
Looks like I'm hit with another case of mistaken folkore. |
| 11:07 |
Dyrcona |
The hold and circ rules are doing what we want for this patron group, and staff are barring them because, well.... |
| 11:08 |
jeff |
"because their card still scans at the self checkout terminal unless we bar them" |
| 11:09 |
jeff |
"because they were able to use electronic resources" |
| 11:09 |
jeff |
"because they were able to get on a computer" |
| 11:09 |
jeff |
"because they could log in to the catalog" |
| 11:09 |
jeff |
"because." |
| 11:09 |
tsbere |
"because they assumed it wasn't working without actually checking" |
| 11:09 |
jeff |
lots of possible reasons. frustrating when it's a game of telephone to find out the answers. |
| 11:10 |
tsbere |
maybe "because it doesn't scream at staff why the card doesn't work just because the patron type was assigned" |
| 11:12 |
Dyrcona |
I still don't know if any libraries are presently not certified for ILL. I'm not sure how to find out, either. |
| 11:14 |
Dyrcona |
Heh, and searching turns up certification for public librarians in the state, and that the director of a public library must have this certification for the library to get state aid. |
| 11:18 |
* Dyrcona |
did find a directory of all the libraries in the state, but no mention of their ILL certification status. Still, that's a handy thing to have. |
| 11:21 |
Dyrcona |
We have a similar issue with what tsbere last said in regard to our "Local Use Only" patron group. |
| 11:21 |
Dyrcona |
Nothing can be simple. |
| 11:24 |
Dyrcona |
I imagine that is the main reason the patrons end up barred. |
| 11:46 |
kmlussier |
Dyrcona: ILL is a service made available through MLS or through the BPL as library of last recourse. I think they should contact MLS to get an answer to that question. |
| 11:46 |
* kmlussier |
thinks that decertified libraries still gets those services, but isn't sure. |
| 11:47 |
Dyrcona |
kmlussier: Yes, but I was hoping for a list of non-certified libraries. |
| 11:47 |
Dyrcona |
Last one that I remember for sure was from 2010, and they usually don't stay non-certified for very long, a year or two usually. |
| 11:48 |
Dyrcona |
Just another tempest in a tea pot, or a typical day for me. :) |
| 11:48 |
kmlussier |
IIRC, there were a lot back then. I think the numbers have gone down since. |
| 11:48 |
|
sandbergja joined #evergreen |
| 11:49 |
kmlussier |
Dyrcona: This? http://mblc.state.ma.us/grants/state_aid/awards/noncert_list.php |
| 11:50 |
Dyrcona |
kmlussier++ # You're the best. |
| 11:50 |
|
bmills joined #evergreen |
| 11:50 |
Dyrcona |
I searched the MBLC site and didn't turn that up. |
| 11:50 |
kmlussier |
Dyrcona: Thanks for a reason to put my librarian skills to work. :) |
| 11:51 |
Dyrcona |
The one patron that I looked at should probably not be in that group any longer. |
| 11:52 |
* Dyrcona |
updates an internal bug ticket. |
| 11:52 |
|
bmills joined #evergreen |
| 11:55 |
* Dyrcona |
wonders if there is a list of barcode prefixes for all MA libraries somewhere. |
| 11:55 |
Dyrcona |
The statewide library directory doesn't include that information. |
| 11:55 |
|
bmills joined #evergreen |
| 11:58 |
kmlussier |
Dyrcona: I think the librarians view of the directory may have it, but you need to log in. pk could probably get that info for you. |
| 11:58 |
Dyrcona |
OK. |
| 11:59 |
Dyrcona |
That makes sense. |
| 11:59 |
Dyrcona |
I could probably get an account, too. |
| 12:05 |
|
mglass joined #evergreen |
| 12:10 |
|
mrpeters joined #evergreen |
| 12:29 |
bshum |
_bott_: We're using PG 9.3.6 in production, but I've got a test server giving PG 9.4.1 a whirl. Love to compare notes with you later on. |
| 13:15 |
|
sarabee joined #evergreen |
| 13:23 |
dbs |
Members of the Evergreen Oversight Board, a heads-up that I was asked if Evergreen would be willing to have their logo added to the http://www.libhub.org/sponsors-partners/ page as a "Partner" (given our focus on many of the same goals as libhub, re: visibility on the web, schema.org, etc) |
| 13:24 |
dbs |
and my response was "Umm, I don't know if the new logo terms of usage were ever finalized (all I could find is a draft) but I think you would need the EOB's okay" |
| 13:25 |
kmlussier |
They were finalized. |
| 13:25 |
dbs |
It's not clear to me what being a "partner" would actually mean. On the other hand, there was discussion about raising Evergreen's visibility / PR, so this might fall under that |
| 13:25 |
kmlussier |
I don't know if they're posted anywhere, but I know we voted on them. |
| 13:26 |
dbs |
http://wiki.evergreen-ils.org/doku.php?id=governance:trademark-policy is what I was able to find |
| 13:26 |
kmlussier |
I think it would need the EOB's okay too. bbqben should be here soon. I'll direct him to the question. |
| 13:27 |
jeff |
libhub apparently uses squarespace. |
| 13:27 |
jeff |
i know this because it stole my Esc key. :P |
| 13:27 |
dbs |
http://wiki.evergreen-ils.org/doku.php?id=governance:minutes:2012-10-17 - we did approve it |
| 13:28 |
maryj |
Looking at the website, the focus is on exploring "BIBFRAME and the Linked Data in Libraries movement" |
| 13:28 |
kmlussier |
I think gmcharlt has had a standing action time to update the trademark page on the site. gmcharlt: Do you want help with that task? |
| 13:28 |
kmlussier |
Asks the person who has very little time to help with anything ATM |
| 13:29 |
dbs |
kmlussier++ |
| 13:30 |
maryj |
But I was surprised to see SirsiDynix as a sponsor (maybe I shouldn't be?) |
| 13:30 |
dbs |
And III |
| 13:31 |
dbs |
BIBFRAME is a part, yes, the linked data part is perhaps more relevant to the libhub goals, which (as far as I understand them) are all about improving discoverability of library resources on the general web |
| 13:31 |
|
krvmga joined #evergreen |
| 13:31 |
maryj |
Gotcha, and improving discoverablility would be a great thing. |
| 13:32 |
dbs |
e.g. in the search engines most people use, by using sitemaps / integrating schema.org / not sending search engines to search result pages etc |
| 13:32 |
dbs |
all things that Evergreen is arguable an industry leader in |
| 13:33 |
krvmga |
in the opac, the black diamond/white question mark keeps popping up in various places. (See http://bark.cwmars.org/eg/opac/record/3309215?query=creative%20class%20goes%20global;qtype=keyword;locg=1 ) |
| 13:33 |
dbs |
Zepheira's approach (again, if I understand it) is to take MARC from participating libraries, convert it to BIBFRAME & link up the resulting data as much as possible, then publish that on libhub.org using the web discoverability best practices that Evergreen largely already does on its own |
| 13:34 |
krvmga |
now this typically just screams "encoding" |
| 13:34 |
dbs |
krvmga: yep |
| 13:34 |
krvmga |
but where to find where the encoding went wrong? |
| 13:34 |
krvmga |
tracking it down is the issue |
| 13:34 |
* tsbere |
isn't sure if a...discrepency he found should be considered a security issue or not. <_< |
| 13:35 |
krvmga |
i need troubleshooting tips on the order of "computer won't start?" "is it plugged in?" "is it turned on?" "is the monitor on?" etc. |
| 13:35 |
dbs |
krvmga: almost 100% that the original MARC record was messed up to begin with |
| 13:35 |
dbs |
e.g. that it was in MARC8 but claimed to be UTF8, or vice versa |
| 13:36 |
dbs |
or that someone just entered Latin-1 into an existing MARC8 / UTF8 record |
| 13:36 |
krvmga |
dbs: thanks for that. i'm trying to be sensitive to our cataloging dept. and not just immediately say "your end!" |
| 13:36 |
krvmga |
but what you say is completely reasonable |
| 13:37 |
|
abneiman joined #evergreen |
| 13:37 |
dbs |
It could be the record source |
| 13:37 |
dbs |
If it was copy-catalogued, they might have messed up the encoding when it was transferred to you |
| 13:37 |
dbs |
(they being the z39.50 source) |
| 13:38 |
krvmga |
so how do my catalogers insure everything's UTF-8 before they import records? |
| 13:38 |
dbs |
tsbere: report it as a security issue and then we'll decide whether to publicize? |
| 13:38 |
jeff |
+1 that is my default recommendation |
| 13:39 |
|
RoganH joined #evergreen |
| 13:39 |
jeff |
i feel that line would benefit from some punctuation |
| 13:41 |
krvmga |
i don't want to give my catalogers a problem without pointing to a solution. |
| 13:43 |
dbs |
krvmga: not sure if when they import the record whether the marc view shows the characters as they'll end up being in the catalogue |
| 13:43 |
dbs |
Would be worth trying to reproduce |
| 13:43 |
krvmga |
dbs: i will ask. |
| 13:44 |
krvmga |
dbs++ |
| 13:44 |
dbs |
And if they don't, we have another bug to work on :) |
| 13:45 |
dbs |
s/they don't/the characters look fine in the import marc view but are corrupted once the record is imported/ |
| 13:45 |
|
montgoc1 joined #evergreen |
| 13:47 |
Dyrcona |
I've seen records that won't import via Z39.50 or won't show up in the list because of encoding issues. |
| 13:47 |
Dyrcona |
Dunno if I've made Launchpad bugs. |
| 13:48 |
Dyrcona |
I think the SRU double encoding might be part of the problem when talking to an Evergreen server at least. |
| 13:51 |
|
bbqben joined #evergreen |
| 13:54 |
Dyrcona |
EOB meeting today? |
| 13:54 |
bshum |
Yeah, at 2 |
| 13:55 |
bshum |
Well, 2pm Eastern |
| 13:55 |
kmlussier |
bbqben: Can I direct your attention to a discussion we just had? http://irc.evergreen-ils.org/evergreen/2015-03-19#i_164971 |
| 13:55 |
kmlussier |
I didn't know if you wanted to raise the question with the EOB if there is time at the end of the meeting. |
| 13:57 |
bbqben |
kmlussier: thanks - will slot this in under new business if there's time (should be) ... |
| 13:57 |
Dyrcona |
I should book mark the community calendar. |
| 13:58 |
bbqben |
All - EOB meeting starting here in a few Alabama Shakes (earworm) - cheers |
| 14:01 |
bbqben |
ok, lets get rolling |
| 14:01 |
bbqben |
#startmeeting Evergreen Oversight Board Meeting, 19.03.15 |
| 14:01 |
pinesol_green |
Meeting started Thu Mar 19 14:01:57 2015 US/Eastern. The chair is bbqben. Information about MeetBot at http://wiki.debian.org/MeetBot. |
| 14:01 |
pinesol_green |
Useful Commands: #action #agreed #help #info #idea #link #topic. |
| 14:01 |
pinesol_green |
The meeting name has been set to 'evergreen_oversight_board_meeting__19_03_15' |
| 14:02 |
bbqben |
#topic introductions |
| 14:02 |
bbqben |
EOB members, please introduce yourself with #info |
| 14:02 |
graced |
#info graced is Grace Dunbar, Equinox |
| 14:02 |
bshum |
#info bshum is Ben Shum, Bibliomation |
| 14:02 |
bbqben |
#info bbqben is Ben Hyman, BC Libraries Co-op / Sitka |
| 14:02 |
montgoc1 |
#info montgoc1 is Chauncey Montgomery, Consortium of Ohio Libraries |
| 14:02 |
RoganH |
#info RoganH is Rogan Hamby, SCLENDS |
| 14:03 |
kmlussier |
#info kmlussier is Kathy Lussier, MassLNC |
| 14:03 |
bbqben |
hi everyone! |
| 14:03 |
abneiman |
#info abneiman is Andrea Buntz Neiman, Kent County Public Library |
| 14:04 |
bbqben |
#topic Minutes/Actions from last meeting |
| 14:04 |
bbqben |
#info http://evergreen-ils.org/meetings/evergreen/2015/evergreen.2015-02-19-14.04.html |
| 14:05 |
csharp |
#info csharp is Chris Sharp, GPLS |
| 14:05 |
bbqben |
looks like most of the actions are on this agenda either explicitly or kindof |
| 14:05 |
bbqben |
So, moving on... |
| 14:05 |
bbqben |
#topic EG2015 Conference Report |
| 14:05 |
|
buzzy joined #evergreen |
| 14:05 |
bbqben |
buzzy: nice timing! |
| 14:06 |
buzzy |
great! sorry, i got pulled away to deal with something at the desk |
| 14:06 |
bbqben |
buzzy: no worries - how are things coming with planning? |
| 14:07 |
buzzy |
conference planning is going fairly well. local staff and i are starting to work on the individual details of how the conference will go with the venue. |
| 14:07 |
buzzy |
the programming committee sounds like they got some great proposals, which are viewable on the wiki. i'm working with the venue to get more rooms for wednesday, as it sounds like we'll have the two hackfests as well as a couple of other items |
| 14:08 |
buzzy |
we're working on sponsors. we don't have as many as i'd like, but graced and bmills are working on that |
| 14:09 |
buzzy |
registration numbers are slightly over 100 right now, which is not where i'd like to be at, but i think they'll go up once we confirm more sponsors and get out the shuttle and program schedules |
| 14:09 |
csharp |
#info 2015 EG Conference proposals: http://wiki.evergreen-ils.org/doku.php?id=conference:2015:proposals |
| 14:09 |
buzzy |
thanks csharp |
| 14:09 |
csharp |
buzzy: sure thing :-) |
| 14:10 |
bbqben |
buzzy: shuttle arrangements / costing coming together ok? |
| 14:10 |
buzzy |
i do have one area of the budget where we need eob approval. as you've probably heard, we have the awesome joseph janes from the uw information school as our keynote. his honorarium is $1,500, but we only budgeted $1,000. however ... |
| 14:11 |
buzzy |
the total price we budgeted for the keynote was $1,950, including travel and incidentals. because he's traveling from seattle, i'm not sure that we'll actually go over that amount. nonetheless, the honorarium line item will be overspent |
| 14:11 |
kmlussier |
Do we know how much the travel costs will be? |
| 14:12 |
buzzy |
i'd need to talk with tony about that to learn what the sfc pays for mileage. or perhaps someone here knows? |
| 14:12 |
RoganH |
Seattle to Hood River is ~228 miles each way. Not a huge but not a trivial trip. |
| 14:13 |
buzzy |
assuming federal reimbursement rate, it'd be about $275 |
| 14:13 |
kmlussier |
I don't know, but I just pinged Tony. |
| 14:14 |
bbqben |
looks like the all-in will still be fairly close, unless I'm reading this wrong. |
| 14:15 |
buzzy |
yes. if travel gets rounded up to $300, it would be $300+$1,500+$200 = $2,000 |
| 14:15 |
buzzy |
although i have a feeling the incidentals won't be that high, either, as alas he's unable to stay for the whole conference |
| 14:15 |
bbqben |
so unless there's strong disagreement, the $50 discrepancy can be managed by the local planning team |
| 14:16 |
bbqben |
shuttle arrangements / costing coming together ok? |
| 14:16 |
kmlussier |
Tony confirms that it's the federal reimbursement rate, so $2,000 sounds about right. |
| 14:16 |
buzzy |
sorry, bbqgen, i missed your other question. yes, shuttle is fine. i just confirmed it today. about $2,800. $3,000 was budgeted |
| 14:16 |
buzzy |
*bbqben |
| 14:17 |
bbqben |
buzzy: great news that the shuttle's within budget. |
| 14:17 |
buzzy |
yes indeed! i have nothing further to report, unless there are questions |
| 14:17 |
abneiman |
Any sense of the timing of the shuttle? |
| 14:17 |
kmlussier |
Can I talk about the Eventbrite sponsorship? |
| 14:18 |
kmlussier |
After you answer abneiman's question. |
| 14:19 |
buzzy |
abneiman: realizing that we can't serve everyone's needs, they'll be shuttle service in the afternoon and evenings on the 12th and 13th, and service on 16th during the morning and afternoon, and on the morning of the 17th |
| 14:19 |
buzzy |
and yes, absolutely, kmlussier |
| 14:19 |
abneiman |
thanks buzzy |
| 14:20 |
kmlussier |
Tony Sebro was able to get an Eventbrite sponsorship again this year. |
| 14:20 |
kmlussier |
However, as in previous years, there are conditions on the sponsorship - http://pastebin.com/N2mkPMnm |
| 14:20 |
kmlussier |
The last bullet point is actually something new that was added to the conditions. |
| 14:21 |
kmlussier |
I just want to bring it to the Board's attention. Since the Eventbrite sponsorship doesn't go through our typical sponsorship package, I think the EOB needs to be okay with any conditions placed on the sponsorship. |
| 14:22 |
RoganH |
It's a bit burdensome but allows us to avoid a substantial cost. |
| 14:22 |
kmlussier |
I know when they added the second bulletpoint last year, the EOB requested that all sponsors be acknowledged in the confirmation email so that Eventbrite wasn't getting a benefit that other sponsors weren't receiving. |
| 14:22 |
graced |
I think it's going to be challenging to recognize Eventbrite in tweets and still have enough characters to talk about the conference update. |
| 14:22 |
abneiman |
whoa. |
| 14:22 |
kmlussier |
graced: I asked Tony that very question. :) |
| 14:22 |
* kmlussier |
searches for his response. |
| 14:22 |
graced |
Can we get an exception for Twitter at the very least? |
| 14:22 |
RoganH |
Sorry, I will have to step away, I have a security issue to deal with a patron harassing a woman. I'll be back shortly. |
| 14:23 |
kmlussier |
From Tony: re: social media: No, I don't think it's reasonable to apply that requirement to require mentioning Eventbrite in every Twitter blast. If Evergreen uses Facebook or G+, I'd definitely recommend including the magic language in any Facebook or G+ event page created for the conference. But, I wouldn't bother including it in short microblogs, e.g., "Evergreen Conference - see you in May!" |
| 14:23 |
graced |
So there's some flexibility. |
| 14:23 |
* csharp |
exhales |
| 14:24 |
kmlussier |
His suggestion was that we use the following language in other publicity: ""register via Eventbrite [url], Evergreen's official ticketing provider" |
| 14:24 |
* csharp |
was getting ready for having to put their logo on the PINES catalog :-/ |
| 14:24 |
graced |
But I feel like that's an awful lot of free marketing that we're giving them when our Platinum sponsors at $4,000 don't get the same benefit. |
| 14:25 |
abneiman |
I agree with graced ... I mean, mentioning EB on every.single.thing (except I guess Twitter)? That seems both excessive, and unfair to other sponsors who won't get the same consideration. |
| 14:25 |
graced |
OTOH, there's not a ton of choice at this late of an hour... |
| 14:25 |
montgoc1 |
It does seem like a bit much for logo placement. |
| 14:26 |
* csharp |
agrees |
| 14:26 |
abneiman |
And that lack of choice at this point makes me even more uncomfortable with this ... feels a little forced? |
| 14:26 |
montgoc1 |
Yes |
| 14:26 |
kmlussier |
buzzy: How do you feel about the budget? Do you think the Eventbrite fees would add a burden to the budget? |
| 14:27 |
kmlussier |
buzzy: I know you mentioned that registrations were lower than you wanted. |
| 14:27 |
buzzy |
i was just going to calculate that! hold please .. |
| 14:27 |
csharp |
GPLS/PINES staff *just* got approved to go to the conference, so expect us to register this week or next :-/ |
| 14:28 |
bbqben |
Should mention that the SFC-Eventbrite partnership agreement is for all SFC projects, not just Evergreen |
| 14:28 |
kmlussier |
Yes, thank you for that clarification Ben! |
| 14:29 |
buzzy |
we're currently on the hook for them for about $475. even if registration numbers more than double, it wouldn't exceed $1,500 |
| 14:30 |
buzzy |
bbqben: well that changes things a bit, but i'd imagine the sfc's other projects would have similar discomfort |
| 14:30 |
bbqben |
IMHO, only EventBrite wins in this arrangement relative to what other sponsors get for their $ |
| 14:30 |
graced |
Is there room for negotiation? |
| 14:30 |
kmlussier |
$475 isn't that much money. And if it's $1,500 then we have enough registration to not be concerned about the budget. :) |
| 14:31 |
graced |
good point kmlussier :) |
| 14:31 |
bbqben |
kmlussier: you're suggesting going solo via EventBrite? |
| 14:32 |
RoganH |
back |
| 14:32 |
bbqben |
graced: negotiation scope wasn't implied in the emails I saw. A concern that projects weren't consulted on the terms. |
| 14:32 |
kmlussier |
bbqben: It seems like an option if you all don't feel comfortable with the terms. |
| 14:33 |
graced |
bbqben: I assumed no negotiation since it was a blanket agreement for all the SFC.... but thought I'd ask. |
| 14:33 |
kmlussier |
From Tony: renegotiating the deal will be difficult -- we're negotiating on behalf of three different projects. |
| 14:33 |
csharp |
+1 to going solo (if that's a feasible option) |
| 14:34 |
montgoc1 |
+1 for solo |
| 14:34 |
graced |
+1 to solo if the budget will handle it |
| 14:34 |
RoganH |
I don't like the deal they get compared to our sponsors and feels like it undercuts community members who pay for sponsorships so .... |
| 14:34 |
abneiman |
yeah +1 for solo as long as it won't impact the budget negatively |
| 14:34 |
RoganH |
+1 to solo if the budget will handle it as well |
| 14:34 |
buzzy |
i think the budget will be fine without their sponsorship |
| 14:34 |
bbqben |
technicality: if solo, whose bank is collecting the $? |
| 14:35 |
bbqben |
(presumably the current setup points to SFC's account) |
| 14:35 |
kmlussier |
Yes, it points to SFC's account. |
| 14:35 |
buzzy |
bbqben: likely, but wouldn't the fee be skimmed off before going to the sfc? |
| 14:36 |
kmlussier |
buzzy: No, I don't think it does. I believe a monthly bill is sent to them to collect the fees. |
| 14:36 |
buzzy |
kmlussier: ah, okay. thank you |
| 14:38 |
bbqben |
seems no one's really opposed to going solo, and I understand from kmlussier that the heavens won't fall if we do |
| 14:38 |
bbqben |
any further discussion on this before we move on? |
| 14:39 |
csharp |
bbqben: just that your technical concern needs to be addressed before we assume it's a go, right? |
| 14:39 |
kmlussier |
Do we need a vote on the budget request re keynote speaker? |
| 14:39 |
csharp |
(i.e., can eventbrite fees still be run through the SFC if we refuse sponsorship?) |
| 14:39 |
bbqben |
csharp: I think kmlussier was saying we'd just be levied the fee, but the funds would still go to SFC. So, all's well |
| 14:40 |
csharp |
ok cool |
| 14:40 |
csharp |
thanks |
| 14:40 |
buzzy |
i'm afraid that i have to leave for another meeting in a couple of minutes. do you have any further questions of me? |
| 14:40 |
* csharp |
wasn't reading it that way, so glad he was wrong |
| 14:40 |
bbqben |
kmlussier: IIRC, its a $50 difference on the whole, so no vote required |
| 14:40 |
csharp |
buzzy++ EG2015++ |
| 14:40 |
bbqben |
buzzy++ let's get that shuttle info on the site and drive reg up! |
| 14:40 |
buzzy |
yes indeed! |
| 14:40 |
montgoc1 |
buzzy++ |
| 14:40 |
kmlussier |
Oh, was it $50? My math is bad today. Carry on.. |
| 14:41 |
buzzy |
thanks, folks. happy thursday! |
| 14:41 |
bbqben |
kmlussier: its $50 relative the the keynote budget, overall even if the honoraria line item is $500 |
| 14:42 |
* kmlussier |
nods |
| 14:42 |
bbqben |
ok, so the other #EG2015 bit is scheduling our In person meeting & arrangements |
| 14:42 |
bbqben |
otherwise known as ... |
| 14:43 |
bbqben |
#topic In person meeting @ EG2015 - scheduling / arrangements |
| 14:44 |
bbqben |
so, we need to meet :) Friday? Saturday am? |
| 14:44 |
bshum |
Thursday evening. |
| 14:44 |
kmlussier |
bshum: Do you know when we're on the schedule? |
| 14:44 |
bshum |
Would be my recommendation for that. |
| 14:45 |
bshum |
Yes I was just looking at the schedule, and EOB update is Friday morning. |
| 14:45 |
bshum |
So if we want to meet before that update to the community, then we should do it on Thursday evening. |
| 14:45 |
bbqben |
bhsum++ Thursday eve works for me; hwo about everyone else? |
| 14:45 |
kmlussier |
I'll be there |
| 14:45 |
RoganH |
Sounds good. |
| 14:45 |
montgoc1 |
That's fine. |
| 14:45 |
csharp |
count me in |
| 14:46 |
bbqben |
#action EOB will meet in person on Thursday, May 14 @ 1900 Pacific |
| 14:46 |
abneiman |
OK |
| 14:46 |
bbqben |
#action secure a meeting space for that time |
| 14:47 |
bbqben |
ok, moving on |
| 14:47 |
bbqben |
(but looking forward to seeing you all!) |
| 14:47 |
bbqben |
#topic Financial Report |
| 14:47 |
bbqben |
#info http://list.evergreen-ils.org/pipermail/eg-oversight-board/2015-March/000962.html |
| 14:47 |
bbqben |
bshum++ |
| 14:48 |
bbqben |
any q's about the financials? |
| 14:49 |
bbqben |
ok, moving on in 10.... |
| 14:49 |
bbqben |
#topic Evergreen 2.8 Release Manager's Report |
| 14:50 |
* csharp |
nudges berick awake |
| 14:51 |
bbqben |
methinks berick has a statnding mtg in this spot |
| 14:51 |
csharp |
ah |
| 14:51 |
bbqben |
so, 2.8 is in the wild! anyone have anything to add :) |
| 14:51 |
bshum |
Well, 2.8.0 RC was released recently. And 2.8.0 official is coming along soon. |
| 14:51 |
csharp |
rock on |
| 14:51 |
bbqben |
bshum++ berick++ |
| 14:51 |
bshum |
So before month's end, definitely. |
| 14:52 |
kmlussier |
bshum++ berick++ |
| 14:52 |
bbqben |
bhsum: you are a mensch |
| 14:52 |
bbqben |
#topic 2015 EOB Elections |
| 14:52 |
bbqben |
#info http://list.evergreen-ils.org/pipermail/eg-oversight-board/2015-March/000958.html |
| 14:53 |
bbqben |
graced++ abneiman++ |
| 14:53 |
bbqben |
so, a few things here... |
| 14:54 |
graced |
bbqben++ |
| 14:54 |
bbqben |
First, a draft call for nominations & announcement re: voting registration |
| 14:54 |
bbqben |
Second, a call for colunteers for the nominations committee |
| 14:54 |
bbqben |
Third, a recommendation for voting platform / process and timeline |
| 14:55 |
bbqben |
Fourth, a proposed revision to our rules re: voting platform / method |
| 14:55 |
bbqben |
and finally, I apparently need a typing assistant... |
| 14:56 |
bbqben |
with apologies for a multi part message ... q's, comments, concerns? |
| 14:56 |
kmlussier |
The draft call for nominations looks good. |
| 14:57 |
abneiman |
graced++ for finding opavote, which I like a lot |
| 14:58 |
kmlussier |
Are you asking us to choose between SurveyMonkey and opavote? |
| 14:58 |
bbqben |
kmlussier: no - we're proposing to register voters with surveymonkey, but vote with opavote |
| 14:59 |
kmlussier |
Ah, sorry. I understood that when I read it an hour ago, but soon forgot. |
| 14:59 |
kmlussier |
It all looks good to me. |
| 14:59 |
bbqben |
kmlussier: pas de probleme |
| 15:01 |
bbqben |
anyone care to volunteer for the nominations committee? |
| 15:01 |
RoganH |
I'll raise my hand. |
| 15:01 |
montgoc1 |
Sure. What does it entail? |
| 15:01 |
* csharp |
volunteers |
| 15:01 |
csharp |
heh |
| 15:02 |
kmlussier |
Looks like a committee! |
| 15:02 |
bbqben |
RoganH++ montgoc1++ csharp++ |
| 15:02 |
bbqben |
montgoc1: primarily, responding Q&A style to queries from potential nominees/nominators |
| 15:03 |
montgoc1 |
Alrighty. |
| 15:03 |
bbqben |
re: Proposed changes to existing Rules (2.4e) re: STV - this requires a vote with 2/3 support. Any discussion before we call that? |
| 15:05 |
bbqben |
ok then... |
| 15:05 |
bbqben |
#startvote Modify the EOB's Rules, s 2.4(e) as follows: Each year the Board shall undertake the electronic collection and counting of votes for the Board election using a documented voting platform that is widely accessible to the Evergreen community.? Yes, No, Abstain |
| 15:05 |
pinesol_green |
Begin voting on: Modify the EOB's Rules, s 2.4(e) as follows: Each year the Board shall undertake the electronic collection and counting of votes for the Board election using a documented voting platform that is widely accessible to the Evergreen community.? Valid vote options are Yes, No, Abstain. |
| 15:05 |
pinesol_green |
Vote using '#vote OPTION'. Only your last vote counts. |
| 15:06 |
bshum |
#vote Yes |
| 15:06 |
csharp |
#vote Yes |
| 15:06 |
kmlussier |
#vote Yes |
| 15:06 |
montgoc1 |
#vote Yes |
| 15:06 |
abneiman |
#vote yes |
| 15:06 |
bbqben |
#vote Yes |
| 15:06 |
RoganH |
#vote Yes |
| 15:06 |
graced |
#vote yes |
| 15:07 |
bbqben |
#endvote |
| 15:07 |
pinesol_green |
Voted on "Modify the EOB's Rules, s 2.4(e) as follows: Each year the Board shall undertake the electronic collection and counting of votes for the Board election using a documented voting platform that is widely accessible to the Evergreen community.?" Results are |
| 15:07 |
pinesol_green |
Yes (8): kmlussier, abneiman, bbqben, graced, RoganH, montgoc1, csharp, bshum |
| 15:07 |
bbqben |
thanks all! |
| 15:07 |
csharp |
bbqben++ graced++ abneiman++ |
| 15:08 |
kmlussier |
bbqben++ graced++ abneiman++ |
| 15:08 |
bbqben |
#action graced abneiman bbqben to coordinate opavote setup and finalization of call for nominations / get the vote out etc |
| 15:08 |
bshum |
bbqben: I can help amend the entry in the git repo for EOB. I'll check with gmcharlt on how that works. |
| 15:08 |
bbqben |
how are we all doing - push through despite the time? |
| 15:08 |
bbqben |
bshum: awesome |
| 15:08 |
csharp |
bbqben: let's do this! |
| 15:08 |
kmlussier |
I'm not going anywhere |
| 15:09 |
abneiman |
onward |
| 15:09 |
graced |
I'm okay for 10 more minutes |
| 15:09 |
montgoc1 |
I'm good. |
| 15:09 |
bbqben |
ok... |
| 15:09 |
bbqben |
#topic Public Relations Proposal |
| 15:09 |
bbqben |
kmlussier: over to you |
| 15:09 |
kmlussier |
#link http://list.evergreen-ils.org/pipermail/eg-oversight-board/2015-March/000964.html |
| 15:10 |
kmlussier |
I've refined the proposal, added the trial period, and provided a ballpark on costs. |
| 15:10 |
kmlussier |
With graced's help, of course. |
| 15:10 |
RoganH |
agreed |
| 15:11 |
kmlussier |
The one thing I was unsuccessful in was getting some info from the Conservancy on doing some targeted fundraising around this. I'll reach out again tomorrow once I'm done with some local meetings. |
| 15:11 |
kmlussier |
But I guess we would need a vote to establish the committee and maybe another one for the budget to exhibit at ALA? |
| 15:12 |
kmlussier |
That is, if it looks okay to everyone. |
| 15:14 |
RoganH |
+1 |
| 15:14 |
RoganH |
By the way, we're having network issues, sorry for laggy responses. |
| 15:14 |
bbqben |
kmlussier++ |
| 15:15 |
bbqben |
proposal looks good, and again - kudos to the MassLNC partners |
| 15:16 |
graced |
kmlussier++ |
| 15:18 |
bbqben |
Looks like we need a vote to establish an ALA exhibit budget. Any discussion before we do? |
| 15:20 |
bbqben |
#startvote Establish a budget line item for PR at ALA in the amount $5000 per knlussier proposal? Yes, No, Abstain |
| 15:20 |
pinesol_green |
Begin voting on: Establish a budget line item for PR at ALA in the amount $5000 per knlussier proposal? Valid vote options are Yes, No, Abstain. |
| 15:20 |
pinesol_green |
Vote using '#vote OPTION'. Only your last vote counts. |
| 15:20 |
bshum |
#vote Yes |
| 15:20 |
graced |
#vote Yes |
| 15:20 |
montgoc1 |
#vote Yes |
| 15:20 |
bbqben |
#vote Yes |
| 15:20 |
abneiman |
#vote yes |
| 15:21 |
RoganH |
#vote yes |
| 15:21 |
kmlussier |
#vote Yes |
| 15:21 |
bbqben |
#endvote |
| 15:21 |
pinesol_green |
Voted on "Establish a budget line item for PR at ALA in the amount $5000 per knlussier proposal?" Results are |
| 15:21 |
pinesol_green |
Yes (7): kmlussier, abneiman, bbqben, graced, RoganH, montgoc1, bshum |
| 15:22 |
bbqben |
thanks, and we're ok with kmlussier soliciting membership for the committee? |
| 15:22 |
bbqben |
kmlussier: let's interpret the silence as a resounding yes :) |
| 15:23 |
montgoc1 |
+1 |
| 15:23 |
csharp |
sorry - stepped away - I was gonna vote yes |
| 15:23 |
abneiman |
+1 |
| 15:23 |
csharp |
+1 |
| 15:23 |
graced |
+1 |
| 15:23 |
RoganH |
+1 |
| 15:24 |
bbqben |
thanks all. #action kmlussier: yet another awesome call for community interest re: PR committee |
| 15:24 |
bbqben |
I'm going to suggest we table one piece of new business (will bring to the list) and call this a meeting |
| 15:24 |
* graced |
has to run - sorry! |
| 15:24 |
bbqben |
graced++ |
| 15:24 |
bbqben |
we meet again 16.04.15 same bat time, same bat place. adios all - thanks for your time today |
| 15:24 |
bbqben |
#endmeeting |
| 15:24 |
pinesol_green |
Meeting ended Thu Mar 19 15:24:54 2015 US/Eastern. Information about MeetBot at http://wiki.debian.org/MeetBot . (v 0.1.4) |
| 15:24 |
pinesol_green |
Minutes: http://evergreen-ils.org/meetings/evergreen/2015/evergreen.2015-03-19-14.01.html |
| 15:24 |
pinesol_green |
Minutes (text): http://evergreen-ils.org/meetings/evergreen/2015/evergreen.2015-03-19-14.01.txt |
| 15:24 |
pinesol_green |
Log: http://evergreen-ils.org/meetings/evergreen/2015/evergreen.2015-03-19-14.01.log.html |
| 15:24 |
kmlussier |
bbqben++ |
| 15:25 |
montgoc1 |
bbqben++ |
| 15:25 |
abneiman |
bbqben++ |
| 15:25 |
bshum |
bbqben++ |
| 15:26 |
bbqben |
all y'all++ |
| 15:28 |
|
afterl joined #evergreen |
| 15:30 |
csharp |
bbqben++ |
| 15:32 |
|
sarabee joined #evergreen |
| 15:34 |
|
frank___ joined #evergreen |
| 15:38 |
frank___ |
Hi all, Id want to know if someone know why if I check the last few circulations for a copy the result said that the due date is "Due date: 3/26/15 10:59" but in database the same id register due_date=2015-03-26 23:59:59-05 |
| 15:39 |
Dyrcona |
frank___: Daylist savings time or timezone mismatch. |
| 15:39 |
|
jihpringle joined #evergreen |
| 15:39 |
Dyrcona |
Daylight... |
| 15:40 |
frank___ |
where should I check that? |
| 15:42 |
csharp |
frank___: just doing 'date' on each server should tell you what time it thinks it is |
| 15:42 |
Dyrcona |
frank___: Your desktop, the server. The database looks like it is on America/New_York. |
| 15:42 |
Dyrcona |
-05 is the current offset from UTC in that time zone. |
| 15:43 |
Dyrcona |
Could be you need to change the time zone on your server. |
| 15:43 |
Dyrcona |
database server, I mean. |
| 15:43 |
Dyrcona |
Unless, you're in the next time zone over and haven't done DST, yet..... |
| 15:43 |
Dyrcona |
Gotta love time. |
| 15:44 |
bshum |
Seems like it'd be on the client's point of view. |
| 15:44 |
Dyrcona |
Doh! I'm stupid. |
| 15:44 |
Dyrcona |
-04 is the current offset. |
| 15:44 |
Dyrcona |
for America/New_York. |
| 15:44 |
csharp |
date +%z and date +%Z will work too |
| 15:44 |
* Dyrcona |
goes back to spending money on servers. |
| 15:45 |
kmlussier |
We should just get rid of daylight savings time and make life easier for everyone. |
| 15:45 |
jonadab |
Right, -4 is currently Eastern Daylight. |
| 15:45 |
jonadab |
kmlussier: Well, it /would/ be possible for all dates in the database to be in GMT, and have the client convert them for display purposes only... |
| 15:45 |
csharp |
bshum: yeah, prolly a client machine that isn't configured to care about DST |
| 15:46 |
csharp |
eww |
| 15:46 |
jonadab |
... doing that conversion could be painful, though. |
| 15:46 |
csharp |
(to jonadab's suggestion) |
| 15:46 |
kmlussier |
jonadab: Yeah, well, my gripes with DST go beyond technology. :) |
| 15:46 |
jeff |
hrm. anyone done partial pg_restores with an evergreen database, from the perspective of "restore data for tables in this schema" then at some later point "restore data for tables in this other schema"? |
| 15:46 |
jonadab |
kmlussier: Fair. |
| 15:46 |
jeff |
not sure i even want to do that right now, but I'm mostly wondering if inter-schema FK/constraints/triggers will complicate things. |
| 15:47 |
jeff |
i suspect the answer to be "yes" |
| 15:47 |
jonadab |
(I don't mean converting for display would be painful. I mean converting the database schema to GMT would be painful.) |
| 15:47 |
csharp |
jeff: yeah, I've tried to restore just the action schema, for instance - it's ugly ;-) |
| 15:47 |
frank___ |
CDT=-0500, so I just have to change the time zone to Mexico city right? |
| 15:47 |
bshum |
bbqben: The governance page has been updated accordingly. |
| 15:48 |
jeff |
csharp: thanks. my usual (other than stripping _replication bits from slony) on a restore is to omit table data and sequences for the auditor schema, but going beyond that will probably get complex fast. |
| 15:48 |
bbqben |
bshum: thanks! |
| 15:48 |
csharp |
jeff: yep, that's my experience |
| 15:48 |
jeff |
csharp++ thanks for the confirmation |
| 15:48 |
jonadab |
frank___: The main thing is that the time zone setting on the server and the time zone settings on the client workstations should match -- ideally. |
| 15:48 |
bshum |
Thing is, even if they match |
| 15:48 |
jonadab |
(Though I don't know what happens when a library system spans timezones...) |
| 15:49 |
bshum |
If the circ happened in -05 |
| 15:49 |
bshum |
It's recorded as such |
| 15:49 |
jeff |
jonadab: it's not great. sitka has to deal with that. |
| 15:49 |
bshum |
And then displays as -04, which would be off by an hour |
| 15:54 |
jeff |
pg_restore: restoring data for table "record_entry" |
| 15:56 |
Dyrcona |
frank___: Yes, you should set the timezone by the major city in your timezone. That is the preferred method. |
| 15:57 |
Dyrcona |
And, the country, 'cause DST is different. |
| 16:01 |
kmlussier |
jonadab: I think this is what happens when a library system spans timezones - https://bugs.launchpad.net/evergreen/+bug/1074195 |
| 16:01 |
pinesol_green |
Launchpad bug 1074195 in Evergreen "due dates rolled past midnight in local time zone" (affected: 2, heat: 12) [Undecided,Confirmed] |
| 16:03 |
jonadab |
Oh, ick. |
| 16:03 |
jonadab |
Could be worse, I suppose: somebody could have a library spanning the date line. |
| 16:03 |
jonadab |
Although, the rolling-to-midnight thing almost does that. |
| 16:05 |
Dyrcona |
The database uses timestamp with timezone for those fields. |
| 16:05 |
Dyrcona |
Dates and times are so much fun from a programming stand point, plus all of the different calendars. |
| 16:06 |
Dyrcona |
And, don't get me started on first day of the week..... |
| 16:12 |
eeevil |
just a head's up, I'm /currently/ working on the TZ issue :) |
| 16:17 |
|
afterl left #evergreen |
| 16:20 |
kmlussier |
eeevil++ |
| 16:20 |
kmlussier |
I knew that when I shared the link to the bug, but I didn't know if it was a sure thing yet. :) |
| 16:35 |
|
bbqben joined #evergreen |
| 17:00 |
pinesol_green |
Incoming from qatests: Test Success - http://testing.evergreen-ils.org/~live/test.html <http://testing.evergreen-ils.org/~live/test.html> |
| 17:26 |
|
bmills joined #evergreen |
| 18:18 |
|
RBecker joined #evergreen |
| 18:36 |
|
bmills joined #evergreen |
| 18:59 |
|
bmills joined #evergreen |
| 19:14 |
|
bmills1 joined #evergreen |
| 19:29 |
|
bbqben joined #evergreen |
| 20:26 |
|
jammin joined #evergreen |
| 20:29 |
jammin |
anybody know where in the database to find the most recent patron to check out an item? there's action.circ of course, but I'm positive I saw a "most recent transactions" field somewhere, just can't remember where, or find it in the schema |
| 20:33 |
berick |
action.circulation order by xact_start desc lmit 1 |
| 20:35 |
berick |
where parent_circ is null -- if you don't want renewals |
| 20:35 |
jammin |
thanks, yes could get it along those lines... that could get interesting to do for a whole bunch of items |
| 20:36 |
jammin |
I need to come up with a report on "count of items lost by patron profile, per library" |
| 20:37 |
jammin |
count of items lost per library (total, or within time range, or whatever) is no prob |
| 20:38 |
jammin |
But I have to group by patron profile... which (I think) means chasing down the most recent checkout for each one for the join. Eek. |
| 20:40 |
jammin |
I thought I saw a table somewhere that had a field with item id, and another with a list of three transaction ids... looked like where the client gets the "recent checkouts" from. Was thinking I could use that... if I could only find it again. |
| 20:41 |
jammin |
...and I have to bail, will have to check in later, thanks! |
| 20:41 |
jammin |
\q |
| 20:41 |
jammin |
lol, wrong window. :) |
| 20:50 |
|
sarabee joined #evergreen |
| 21:36 |
|
sarabee joined #evergreen |
| 22:14 |
|
bbqben joined #evergreen |
| 22:47 |
|
sarabee joined #evergreen |
| 23:47 |
|
sarabee joined #evergreen |
