| Time |
Nick |
Message |
| 02:48 |
|
wjr joined #evergreen |
| 02:48 |
|
eby joined #evergreen |
| 02:48 |
|
mceraso joined #evergreen |
| 02:48 |
|
kmlussier joined #evergreen |
| 02:48 |
|
bshum joined #evergreen |
| 03:05 |
|
timlaptop joined #evergreen |
| 03:21 |
|
timf joined #evergreen |
| 04:54 |
|
mtj_ joined #evergreen |
| 07:24 |
|
collum joined #evergreen |
| 07:50 |
collum |
@wunder 41017 |
| 07:50 |
pinesol_green |
collum: The current temperature in Taylor Mill, Taylor Mill, Kentucky is 0.9°F (7:48 AM EST on January 06, 2014). Conditions: Overcast. Humidity: 76%. Dew Point: -5.8°F. Windchill: -20.2°F. Pressure: 30.14 in 1021 hPa (Rising). Wind chill warning in effect until 5 PM EST Tuesday... |
| 08:01 |
|
mrpeters joined #evergreen |
| 08:14 |
|
akilsdonk joined #evergreen |
| 08:26 |
* csharp |
cracks out of his holiday cocoon |
| 08:26 |
bshum |
csharp: Are you a pretty butterfly now? |
| 08:26 |
* csharp |
flutters wings, bats eyelashes |
| 08:27 |
csharp |
actually, I feel kinda hungover - my body's still on mountain time |
| 08:28 |
bshum |
I still can't quite remember what day it is anymore. |
| 08:28 |
* csharp |
feels Monday pretty strongly |
| 08:32 |
|
Shae joined #evergreen |
| 08:41 |
|
kbeswick joined #evergreen |
| 08:51 |
|
finnx joined #evergreen |
| 08:53 |
|
finnx joined #evergreen |
| 08:55 |
|
Dyrcona joined #evergreen |
| 08:55 |
|
finnx joined #evergreen |
| 08:56 |
|
finnx joined #evergreen |
| 08:58 |
|
finnx joined #evergreen |
| 08:58 |
Dyrcona |
@any Dyrcona |
| 08:58 |
pinesol_green |
Dyrcona: Dyrcona was last seen in #evergreen 3 minutes and 44 seconds ago: *** Dyrcona has joined #evergreen |
| 08:59 |
|
finnx joined #evergreen |
| 09:01 |
|
finnx joined #evergreen |
| 09:04 |
|
finnx joined #evergreen |
| 09:06 |
|
finnx joined #evergreen |
| 09:07 |
|
finnx joined #evergreen |
| 09:08 |
|
finnx joined #evergreen |
| 09:10 |
|
finnx joined #evergreen |
| 09:11 |
pinesol_green |
[evergreen|Dan Scott] Move default actor.org_unit entries into sample data - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=bcb9023> |
| 09:11 |
pinesol_green |
[evergreen|Dan Scott] Add sample library addresses and hours of operation - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=4a6d178> |
| 09:11 |
pinesol_green |
[evergreen|Dan Scott] Sample library external URLs, phone numbers, and emails - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=a1b07a3> |
| 09:12 |
|
finnx joined #evergreen |
| 09:12 |
|
mmorgan joined #evergreen |
| 09:13 |
|
finnx joined #evergreen |
| 09:14 |
|
finnx joined #evergreen |
| 09:27 |
bshum |
dbs: bug 1261939 was entertaining. Took me a few moments to figure out that the example.com external URL was being used instead of the hostname/eg/opac/library/shortname path I was initially expecting to get me to a given library page. |
| 09:27 |
pinesol_green |
Launchpad bug 1261939 in Evergreen "Add per-library TPAC pages with schema.org structured data support" (affected: 1, heat: 6) [Wishlist,New] https://launchpad.net/bugs/1261939 |
| 09:28 |
bshum |
I'm not entirely sure I like that, but we don't get external URLs in our system for org units (yet). So I'm unsure how we'd implement it down the road. |
| 09:32 |
kmlussier |
For those of you who are just returning from a long vacation, we have a Doodle poll going for a dev meeting this week. Please take a second to fill it out. http://doodle.com/5nfayxwi3kv7tew7 |
| 09:33 |
kmlussier |
It looks like it might be tomorrow afternoon or maybe Friday afternoon. |
| 09:33 |
dbs |
bshum: uhh, hmm. example.com was being surfaced? In theory that should only get surfaced if the org unit setting was set. I guess that was one of the branches with the concerto sample data then? |
| 09:34 |
bshum |
dbs: Correct, I loaded a fresh master with concerto to try things out. |
| 09:34 |
bshum |
And yeah, got super confused for 2 minutes with all the example.com/branch pointers :) |
| 09:34 |
dbs |
bshum: okay. But other branches should have the local default hostname |
| 09:34 |
bshum |
That's what I figured as well. |
| 09:34 |
dbs |
*phew* |
| 09:34 |
bshum |
After looking at the code more closely to see what I was doing wrong |
| 09:35 |
dbs |
Yes, MassLNC wanted the OUS for a URL to an external library page; the built-in pages just get dropped into place if there's no OUS |
| 09:35 |
dbs |
Good to expose that OUS via sample data so that people are aware that it exists I guess :) |
| 09:36 |
bshum |
Hehe |
| 09:37 |
bshum |
I guess it's just my personal opinion that if we create catalog library pages, I'd like to keep us within the catalog primarily and then have those links out to external library pages based on the OUS at the point you see it on the library info page. |
| 09:37 |
bshum |
Rather than link straight to the external URLs |
| 09:37 |
bshum |
But then, I don't use the feature. |
| 09:38 |
bshum |
So I don't really know. |
| 09:38 |
bshum |
Course that'd be an extra click I guess |
| 09:38 |
dbs |
kmlussier: thanks for the doodle reminder |
| 09:39 |
dbs |
bshum: sure, we could check with MassLNC to see if that would work for them |
| 09:39 |
kmlussier |
dbs: you're welcome |
| 09:39 |
dbs |
I suspect that if they had the built-in library pages to start with, then they might have opted for that design too |
| 09:40 |
kmlussier |
What exactly is it that you want? The library names to link to the library page which would then link to the external URL? |
| 09:40 |
dbs |
kmlussier: that's what bshum is suggesting, yes... so that you don't get thrown out of the context of the catalogue when you're just browsing copies |
| 09:40 |
dbs |
(or at least that's what I think he's saying) |
| 09:41 |
kmlussier |
Yes, we came up with that idea before there were library pages to link to, but I would need to check with people here to see what they think. |
| 09:41 |
* kmlussier |
isn't sure and hasn't had enough coffee to even make something up. |
| 09:41 |
bshum |
I think that's just what I expected to see when I read the concept of the page to begin with. |
| 09:42 |
bshum |
If that's not how it's supposed to work, I could see that... but then I'd definitely want to build another config option to make it configurable (as if we didn't need more config options) |
| 09:42 |
dbs |
bshum: right, I was just trying to break existing expectations of those sites already using the feature |
| 09:42 |
kmlussier |
I just noticed MVLC is using the external URL's in their catalog now. Looks very nice! dbs++ |
| 09:42 |
dbs |
*not* break, heh. |
| 09:42 |
* dbs |
needs coffee too |
| 09:43 |
bshum |
dbs: That's fair. We aren't using external URLs, so my point of view is definitely going to be different. |
| 09:44 |
dbs |
If I was developing it from the ground up, yes, I would totally do it the way you suggest. I guess I could add an OUS to make MassLNC's mode an opt-in approach, so the default works the way you and I would like :) |
| 09:46 |
bshum |
Hehe |
| 09:47 |
dbs |
Alternately, if the only sites that we know of that are using the feature (MassLNC / MVLC?) would be happy with the change to always link to the built-in page, then we could just do that |
| 09:48 |
jeff |
heh. doodle was sure to e-mail me that kmlussier had "changed information" in the dev meeting poll, but doesn't bother saying what was changed. :-) |
| 09:49 |
jeff |
+1 to at least inquiring with those using it to see if they'd be ok with the (logical, IMO -- but i'm not using it right now) change rather than having another behavior toggle. :-) |
| 09:49 |
kmlussier |
jeff: It wasn't anything terribly exciting. Just changed my availability to increase the chances of finding a date that works for everyone. |
| 09:49 |
jeff |
dbs++ |
| 09:49 |
jeff |
kmlussier: aha :-) |
| 09:55 |
kmlussier |
OK, e-mail sent to see what people think about library linking. |
| 09:55 |
* Dyrcona |
doesn't care but others in MassLNC might. |
| 09:57 |
kmlussier |
IIRC, the MassLNC library links made it into 2.5, and dbs 's new library pages won't be available until 2.6. So, even though MVLC may be the only site using it now, there may be more that see a changed behavior when they eventually do a 2.5 -> 2.6 upgrade. |
| 09:58 |
dbs |
kmlussier: true! At least 2.5 -> 2.6 is an abbreviated release cycle :) |
| 10:02 |
kmlussier |
berick: I'm confused by all these fund sorting bugs. Is bug 1266471 the same as bug 802700? And should they both be set to invalid now since the code was already merged? |
| 10:02 |
pinesol_green |
Launchpad bug 1266471 in Evergreen "ACQ funds selector should sort by year, code" (affected: 2, heat: 12) [Undecided,New] https://launchpad.net/bugs/1266471 |
| 10:02 |
pinesol_green |
Launchpad bug 802700 in Evergreen "Dojo interface dropdown sort method is not intuitive" (affected: 4, heat: 26) [Low,Confirmed] https://launchpad.net/bugs/802700 |
| 10:04 |
berick |
kmlussier: sort of. 802700 seems to be looking for a generic solution. mine is fund-specific |
| 10:04 |
berick |
1266471 will address one part of 802700 |
| 10:05 |
bshum |
https://bugs.launchpad.net/evergreen/+bug/1227344 <-- might be the bug that actually merged said fix |
| 10:05 |
pinesol_green |
Launchpad bug 1227344 in Evergreen 2.4 "Funds missing year and not sorted in acq general search" (affected: 2, heat: 10) [Medium,Fix released] |
| 10:05 |
berick |
bshum++ dang, i could not find that.. |
| 10:06 |
bshum |
Well it's fix released, took me a moment too. |
| 10:06 |
kmlussier |
berick: ok, thanks for the clarification! |
| 10:06 |
* berick |
notes that in his latest ticket |
| 10:10 |
bshum |
Should we mark the new bug a dupe of the one that was merged and close it? Since it's been fixed and all. |
| 10:10 |
|
mllewellyn joined #evergreen |
| 10:27 |
|
RoganH joined #evergreen |
| 10:33 |
csharp |
@wunder 30345 |
| 10:33 |
pinesol_green |
csharp: The current temperature in Lakeside, Atlanta, Georgia is 24.8°F (10:30 AM EST on January 06, 2014). Conditions: Light Snow. Humidity: 72%. Dew Point: 17.6°F. Windchill: 24.8°F. Pressure: 30.19 in 1022 hPa (Rising). Wind Advisory in effect until midnight EST tonight... |
| 10:33 |
csharp |
holy moly - it *is* snowing here! |
| 10:36 |
Dyrcona |
@wunder 01845 |
| 10:36 |
pinesol_green |
Dyrcona: The current temperature in North Andover, Massachusetts is 52.2°F (10:32 AM EST on January 06, 2014). Conditions: Fog. Humidity: 100%. Dew Point: 51.8°F. Pressure: 29.46 in 998 hPa (Falling). Dense fog advisory in effect until 2 PM EST this afternoon... |
| 10:37 |
Dyrcona |
We got rain. |
| 10:37 |
* bshum |
is sick of the rain already. |
| 10:37 |
bshum |
Not that I want snow either. |
| 10:37 |
* berick |
double-takes at 7° low |
| 10:37 |
Dyrcona |
I like it better than the 2 degrees Fahrenheit and snow last week. |
| 10:37 |
berick |
.. and spits out coffeee |
| 10:38 |
Dyrcona |
berick: You're going to be on the edge of the Arctic vortex. |
| 10:38 |
RoganH |
@wunder 29730 |
| 10:38 |
pinesol_green |
RoganH: The current temperature in Winthrop University, Rock Hill, South Carolina is 38.3°F (10:38 AM EST on January 06, 2014). Conditions: Overcast. Humidity: 81%. Dew Point: 33.8°F. Windchill: 37.4°F. Pressure: 29.88 in 1012 hPa (Rising). Wind Chill Advisory in effect from 6 PM this evening to noon EST Tuesday... |
| 10:38 |
berick |
Dyrcona: that makes it sound exciting |
| 10:39 |
csharp |
https://www.youtube.com/watch?v=jKMNSvpB9dY |
| 10:39 |
senator |
@wunder minneapolis, mn |
| 10:39 |
pinesol_green |
senator: The current temperature in Whittier, Minneapolis, Minnesota is -19.1°F (9:35 AM CST on January 06, 2014). Conditions: Overcast. Humidity: 42%. Dew Point: -29.2°F. Windchill: -18.4°F. Pressure: 30.37 in 1028 hPa (Rising). Wind chill warning in effect until noon CST Tuesday... |
| 10:40 |
senator |
no equinoxers but rob are allowed to complain about weather |
| 10:40 |
csharp |
heh |
| 10:40 |
berick |
senator: au contraire, he's used to it! |
| 10:40 |
senator |
heh |
| 10:41 |
* csharp |
makes plans to watch Fargo again to see how Rob lives |
| 10:41 |
berick |
well, maybe not used to -19, but still... |
| 10:52 |
phasefx |
is there an example where the dewey sorter is definitely more appropriate than generic? I'm trying to find an edge-case where a dewey-like number sorts incorrectly with generic, and am maybe not thinking clearly |
| 10:52 |
bshum |
dbs: line 59 of Library.pm -- # Generate naive (native?) schema.org format |
| 10:52 |
bshum |
Just a comment, but it made me laugh :) |
| 10:54 |
bshum |
I was perusing how the code worked. Curious to see if there's any styling options to put AM/PM instead of rendering only in 24h |
| 10:57 |
dbs |
Oh you North Americans and your AM/PM love :) |
| 10:57 |
bshum |
Well, it's how Google showed me my home library's hours when I looked them up just now :) |
| 10:57 |
* kmlussier |
thought dbs was North American. |
| 10:58 |
dbs |
There's nothing built-in at the moment but I suppose I could use something like the DATE_FORMAT option to keep everyone happy |
| 10:58 |
dbs |
build on something like http://www.template-toolkit.org/docs/manual/Plugins.html#section_Date |
| 11:00 |
bshum |
Doh |
| 11:00 |
dbs |
[% USE Date (locale = '<locale>'); %] in theory should make it work :/ |
| 11:01 |
bshum |
dbs: Someone just pointed out to me with the sample phone numbers that the formatting is weird to them: (555)-555-0271 (the extra dash between) |
| 11:01 |
dbs |
Hey, that's good feedback |
| 11:01 |
bshum |
I didn't notice that when I merged it earlier. |
| 11:02 |
dbs |
I can whip up a fix branch for that |
| 11:03 |
dbs |
so "(555) 555-0271" is okay? |
| 11:03 |
mrpeters |
what's the easiest way to clone the default OPAC skin for hacking? i tried copying it --- cp -R opac/ newopac/ and then replacing references to opac/ with newopac/ (find . -type f -print0 | xargs -0 sed -i 's/opac\//newopac/g') but that doesnt make things very happy :) |
| 11:03 |
dbs |
mrpeters: yikes, don't do that! |
| 11:03 |
mrpeters |
perhaps i need a second vhost to make everything work right? |
| 11:04 |
* Dyrcona |
wonders if there is a locale facet for phone numbers. |
| 11:04 |
mrpeters |
heh, it was worth a shot dbs |
| 11:04 |
|
roses joined #evergreen |
| 11:04 |
dbs |
Just copy the file(s) that you want to tweak and add the new template directory to your list of template overrides |
| 11:05 |
dbs |
Or if this is purely for local dev purposes, you could just use git and "cp -r Open-ILS/src/templates/* /openils/var/templates/." from time to time :) |
| 11:05 |
dbs |
(also assuming /openils/ prefix) |
| 11:05 |
mrpeters |
yeah, im just hacking around with some customizations |
| 11:06 |
mrpeters |
but wanted them to be able to use their DB (no test server available) |
| 11:06 |
* dbs |
tends to use the latter method when developing |
| 11:06 |
roses |
csharp: I'm trying to set up this weeding report that you created http://libmail.georgialibraries.org/pipermail/open-ils-general/2012-September/007430.html and can't seem to get either the base or aggregate filters to both stay not grayed out. I did some other searching and found out you "hate" that - but didn't find out how to get around it. |
| 11:06 |
dbs |
mrpeters: ah, in that case, yes, a second vhost with an extra templates directory with just the files you want to override would be bestest |
| 11:06 |
dbs |
(or at least the way I would do it) |
| 11:07 |
mrpeters |
dbs++ |
| 11:08 |
dbs |
bshum: user/dbs/weird_sample_phone_numbers if you want to peek |
| 11:08 |
bshum |
dbs: I think that looks right, but could also see it being shown as "555-555-0271" (without the parenthesis). I'm just a messenger. |
| 11:09 |
bshum |
Since these are just sample data |
| 11:09 |
bshum |
I'm not going to overly worry |
| 11:09 |
kmlussier |
roses: The base and aggregate filter tabs will grey out depending on what field you have selected at the time. |
| 11:09 |
bshum |
dbs: That fix branch looks good to me. I'll pull it into master, I'll tack it onto the bug ticket too, just for note. |
| 11:09 |
kmlussier |
If it's a non-aggregate output type, the aggregate tab will be grayed out. If it's an aggregate output type, the base tab will be grayed out. |
| 11:10 |
roses |
kmlussier: Okay I'll go try that. Thanks a bunch. |
| 11:13 |
pinesol_green |
[evergreen|Dan Scott] Make sample phone numbers "(xxx) xxx-xxxx" format - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=15d3db1> |
| 11:14 |
dbs |
bshum++ |
| 11:15 |
|
pmurray joined #evergreen |
| 11:16 |
|
bshum joined #evergreen |
| 11:16 |
|
mceraso joined #evergreen |
| 11:17 |
|
afterl joined #evergreen |
| 11:21 |
|
BigRig_ joined #evergreen |
| 11:21 |
|
bshum joined #evergreen |
| 11:23 |
|
kmlussier joined #evergreen |
| 11:23 |
|
BigRig__ joined #evergreen |
| 11:25 |
|
BigRig joined #evergreen |
| 11:27 |
|
BigRig_ joined #evergreen |
| 11:36 |
dbs |
bshum: I'll give the Date module a go to see if I can do a better job formatting times according to chosen locales |
| 11:37 |
bshum |
dbs: Cool! I'll be happy to test further on my end. Still looking things over to see how it works. |
| 11:40 |
dbs |
"how" is a good step forward from "if" :) |
| 11:51 |
|
granitize joined #evergreen |
| 11:55 |
|
snowball_ joined #evergreen |
| 11:55 |
|
snowball_ left #evergreen |
| 11:57 |
csharp |
roses: ha! yes, I both @hate that and hate that in real life ;-) |
| 11:57 |
csharp |
roses: the only way around that is to not select an "aggregate" field for display until you've finished with your base filters |
| 11:58 |
csharp |
so if you're doing a count, don't select that until you've got your filters in place |
| 11:58 |
dbs |
bshum: ugh. so "Date" really needs a full date as input, and really wants to format a full date as output, unless you give it a specific format |
| 12:00 |
dbs |
I can make it happy by doing something like "today = date.format(format='%Y-%b-%d');" and passing "today _ closing_time" to a subsequent date.format() call, but the format="%A %p" is going to have to be another specific setting, not just something we can inherit from the chosen locale :/ |
| 12:05 |
dbs |
ah, "format.time" OUS to the rescue |
| 12:05 |
csharp |
exceptions-- |
| 12:12 |
roses |
csharp: Thanks. |
| 12:26 |
* dbs |
has merged in format.time honorification |
| 12:37 |
bshum |
%l might be better than %H |
| 12:37 |
bshum |
5 instead of 17, and all that |
| 12:37 |
bshum |
But yes, dbs++ |
| 12:39 |
roses |
Is there a way to "backwards" apply a penalty threshold? ie if the patron has more than $5.00 in fines they can't check anything out - but right now it's only applying to fines/patrons after the threshold was set up? How do you go back to all patrons and apply? |
| 12:40 |
csharp |
roses: probably a direct SQL update |
| 12:42 |
bshum |
Pretty much |
| 12:43 |
mmorgan |
Hmm, I thought penalties were evaluated whenever a patron was retrieved. |
| 12:43 |
bshum |
mmorgan: They only get updated when you hard refresh (aka, click the refresh button after retrieval) |
| 12:44 |
bshum |
Or at least that's what I experienced last time |
| 12:45 |
bshum |
roses: In the old days, we made use of the function for actor.calculate_system_penalties to find out which penalties needed to be generated for a given set of patron IDs. |
| 12:45 |
bshum |
And then inserted penalties that came up |
| 12:46 |
bshum |
The last time I tried though, I had some strange mismatches |
| 12:46 |
bshum |
So I think newer versions of Evergreen either changed the syntax of the old queries or something in the function is different now. |
| 12:46 |
bshum |
Either way, csharp is right that SQL updates is the best way of retroactively applying different penalties. |
| 12:47 |
bshum |
(en masse, anyways) |
| 12:47 |
roses |
bshum++ csharp++ Thanks |
| 12:51 |
roses |
mmorgan++ bshum++ csharp++ The refresh button works also, but the long term solution will be the SQL - this library has self checkout so it couldn't be refreshed. |
| 12:54 |
jeff |
i use a script that calls the same opensrf call that hitting "Refresh" in the patron display does. Mostly works. I've also gone the manual insert or update/delete route. |
| 13:06 |
csharp |
it might be a nice side project to consolidate a lot of our individual admin-type scripts into something that lives in the EG source tree (maybe additions to support-scripts?) |
| 13:06 |
jeff |
yep. slightly higher bar for submission, but well worth it in a lot of cases. |
| 13:06 |
jeff |
of course, it's an additional burden to maintain at times, so there's that trade-off. |
| 13:07 |
csharp |
yeah - I was just thinking about that |
| 13:07 |
csharp |
also, making them universally applicable, rather than "this bash script I wrote for that thing" |
| 13:09 |
jeff |
right, that was the "slightly higher bar" i was referring to. |
| 13:18 |
dbs |
bshum: oh yeah, %l makes more sense if we're doing AM/PM |
| 13:19 |
|
akilsdonk joined #evergreen |
| 13:23 |
|
eeevil joined #evergreen |
| 13:23 |
|
phasefx2 joined #evergreen |
| 13:23 |
|
gdunbar joined #evergreen |
| 13:27 |
|
senator joined #evergreen |
| 13:36 |
kmlussier |
dbs / bshum: https://bugs.launchpad.net/evergreen/+bug/1261939/comments/3 |
| 13:37 |
pinesol_green |
Launchpad bug 1261939 in Evergreen "Add per-library TPAC pages with schema.org structured data support" (affected: 1, heat: 6) [Wishlist,New] |
| 13:48 |
dbs |
kmlussier++ |
| 13:55 |
Dyrcona |
whitespace_changes-- |
| 14:11 |
|
j_scott joined #evergreen |
| 14:19 |
Bmagic |
what is the opensrf call to change the status of a non-circed item ? |
| 14:19 |
bshum |
Well that's awkward... when we switched KVM hosts for one of our VMs, it ended up using the same MAC address as another VM did. The sporadic network wonkiness was not good. |
| 14:25 |
|
roses joined #evergreen |
| 14:26 |
RoganH |
bshum: ah, the best laid plans of mice and sysadmins |
| 14:26 |
bshum |
Indeed :( |
| 14:34 |
Dyrcona |
Bmagic: I would get a fieldmapped asset.copy object, set the status, and then use a CStoreEditor to update the copy. |
| 14:36 |
Bmagic |
Dyrcona: That sounds like more cod than I need, but if I have to I have to. I was considering crafting a SQL update query to switch them to "missing" and call it done. Is there something that the opensrf call would do other than flip the 0 to a 14 in the status column? |
| 14:40 |
Dyrcona |
Bmagic: open-ils.circ.mark_item_missing |
| 14:41 |
Bmagic |
Dyrcona: That requires a circ right? |
| 14:41 |
Bmagic |
Dyrcona: Here is a bigger question: When migrating data into an Evergreen system, is it safe to set the status of the items manually in the database to match the old system. Lost,missing, binding, etc ? |
| 14:42 |
Dyrcona |
Bmagic: No, it does not require a circulation, just an authtoken and a barcode. |
| 14:42 |
Dyrcona |
Bmagic: Yes, it is generally safe, but Evergreen 'lost' expects a circulation. |
| 14:43 |
Bmagic |
Dyrcona: as long as I stay away from lost, the system wouldnt be missing any other updates to other tables if I set the status column manually? |
| 14:44 |
Dyrcona |
Bmagic: Checked out expects a circulation, too. |
| 14:44 |
Bmagic |
Dyrcona: :) yeah, that too, but otherwise, I am just worried that the opensrf call will do something that I don't know about to make the database sound |
| 14:47 |
Dyrcona |
Bmagic: If you look in Circ.pm at the mark_item subroutine, you'll see damaged is the only status that requires special treatment. |
| 14:48 |
Bmagic |
Dyrcona: I really appreciate your help! I in fact looked at that code. Great, thank you so much for the verification! |
| 14:51 |
Dyrcona |
csharp++ |
| 14:51 |
Dyrcona |
For noticing that one of my scripts was "polluted with HTML." |
| 14:53 |
|
mtcarlso- joined #evergreen |
| 14:55 |
|
linuxhiker_away joined #evergreen |
| 15:04 |
csharp |
Dyrcona++ # sharing it in the first place! |
| 15:10 |
roses |
Back to my weeding report - if I put it Item > Circ Mod > In list and nothing appears in the list - then I haven't ask for the right thing? |
| 15:13 |
RoganH |
I'm not a guru at the in staff client reporter but assuming it carries the general SQL convention over In List would mean you want only occurrences that match a list you are giving it. |
| 15:14 |
RoganH |
For example give me age of item, call number, number of circs where barcode in list (barcode 1, barcode 2, barcode 3, etc...) |
| 15:14 |
RoganH |
Now I'm curious.... |
| 15:15 |
roses |
RoganH: I would expect circ mod list to populate with bot, dvd, etc - because when I look at circulation modifiers thats the code/name |
| 15:15 |
RoganH |
I'm about to go look but if it's a list the way I think it is, you populate that list, not it. |
| 15:16 |
|
phasefx2 joined #evergreen |
| 15:16 |
|
gdunbar joined #evergreen |
| 15:16 |
|
eeevil joined #evergreen |
| 15:16 |
akilsdonk |
roses: are you going into the linked tables (under the source) for the circ mod? |
| 15:18 |
roses |
akilsdonk: hmmmmm.... i'll go check - I was following this by Chris: http://libmail.georgialibraries.org/pipermail/open-ils-general/2012-September/007430.html |
| 15:18 |
RoganH |
Right, the in list there means you will get a weeding report for those circ mods and for those org units that you list. |
| 15:19 |
RoganH |
If you want to get a list for only a single org unit (say a library system) or a single branch there is another way. |
| 15:20 |
RoganH |
Chris' way works well for those "places a, c and j want a weeding report and this keeps me from having to run it three times" scenario. |
| 15:21 |
RoganH |
Bah, I don't see where it is in the staff client. It's really easy in sql. |
| 15:22 |
RoganH |
Here is one way in SQL. http://paste.evergreen-ils.org/48 |
| 15:22 |
roses |
RoganH: Don't have access to sql - I have to use staff client. |
| 15:23 |
RoganH |
Most of the same abilities are in the staff client but I don't find the reporter intuitive personally. |
| 15:24 |
RoganH |
I think I might get a bit more complicated with my weeding reports than chsarp does with his based on that one he posted (always a dangerous assumption). |
| 15:24 |
roses |
RoganH: I was actually going to ask you this in Boston at your SQL class but is there a way to give permissions (someone like me) to run sql reports but not do anything else - ie change major things :-) |
| 15:24 |
RoganH |
Sure, you can restrict in postgres by tables and restrict to read only. |
| 15:24 |
roses |
RoganH: Thanks, good to know. |
| 15:25 |
akilsdonk |
roses: if you are using Item as the source and are adding circ mod from the initial Field Name panel I don't think you would see the list when you go to run the report. You'll want to add the circ mod Code (Data Type: ID) from the linked table for EG to generate the list for you when you run the report. |
| 15:25 |
RoganH |
You can still cause some issues if you do something like select * from action.circulation circ join actor.usr au on au.id = circ.usr; |
| 15:25 |
roses |
akilsdonk: I changed it and it gave me the list but I'm still not gettting any results. |
| 15:26 |
RoganH |
You wouldn't break anything but the system will be busy a while churning up stuff for you. But just a tiny bit of experience and you'd get past that. |
| 15:26 |
roses |
RoganH: I have enough sql experience to be dangerous - used to work with ExLibris sql stuff. |
| 15:27 |
RoganH |
Pretty much any SQL experience will carry over into the basics you need with Postgres. And Postgres' web docs are pretty good. |
| 15:28 |
akilsdonk |
roses: so you're seeing the list of circ mods now when you go to run the report, but you're not getting any results in the output? |
| 15:33 |
csharp |
roses: yeah - I've learned since creating that report definition how to get the circ mods in a list to select from (as opposed to entering singly) |
| 15:34 |
csharp |
adding a source to filter on may be creating the wrong type of JOIN (or adding a table twice which can result in a loop and/or no data) |
| 15:34 |
csharp |
roses: can you pastebin (or otherwise share) the "Generated SQL" section of the debugging info? (make sure to remove any sensitive data) |
| 15:36 |
roses |
csharp++ akilsdonk++ Running again - be back |
| 15:38 |
pastebot |
"roses" at 64.57.241.14 pasted "sql output for weeding report" (17 lines) at http://paste.evergreen-ils.org/49 |
| 15:38 |
roses |
csharp: It worked - got results but I still posted the sql - I'm going to go tinker with the results some. |
| 15:39 |
roses |
csharp: Forgot to remove sensitive data - dang it. |
| 15:46 |
pastebot |
"csharp" at 64.57.241.14 pasted "how I would set up my report if I were to re-do it today" (16 lines) at http://paste.evergreen-ils.org/50 |
| 15:46 |
csharp |
roses: I don't see anything that I would consider compromising |
| 15:47 |
csharp |
I've learned a lot about the way reports work since I did that one a while back |
| 15:48 |
csharp |
I added the owning library (as opposed to copy circulating library) to the display and the shelving location, since this is theoretically for someone to walk around the library and use to weed |
| 15:48 |
roses |
csharp: Thanks. |
| 15:48 |
csharp |
it's totally untested, but I think it will probably do what you want |
| 15:49 |
csharp |
roses: one more thing... sometimes tinkering with an existing report will subtly change the generated SQL in ways that are not apparent in the user interface |
| 15:50 |
csharp |
so I often start over and create it from scratch (always with a heavy heart) |
| 15:50 |
* csharp |
is very much ready to follow jeff's lead and set up jasperreports |
| 15:51 |
roses |
csharp: Tinkering does cause me great pain - basically I was going to go back and add the shelving location like you did in your new report. I just named it Weeding (working) and then clone from there. |
| 15:51 |
roses |
csharp: What are jasperreports? |
| 15:52 |
csharp |
roses: http://community.jaspersoft.com/project/jasperreports-library - I've poked at it but never have set it up |
| 15:52 |
csharp |
jeff and others are using it actively (and happily avoiding what you and I are doing right now ;-)) |
| 15:54 |
* csharp |
goes AFK for a while |
| 15:54 |
RoganH |
There is a community segment that Jasper Reports would be great for I think. |
| 15:59 |
mmorgan |
Getting a FIXME error trying to print a checkout receipt from the standalone client. The error just says: "_print_tree". Any ideas? |
| 16:00 |
mmorgan |
Debug output says:"fileName":"chrome://open_ils_staff_client/content/main/JSAN.js","lineNumber":1823 |
| 16:07 |
jeff |
RoganH: yes, that segment of the community is called "people who use reports." ;-) |
| 16:07 |
jeff |
(i kid! i kid!) |
| 16:07 |
* jeff |
is upgrading our copy of jasperreports server this week or so |
| 16:07 |
RoganH |
jeff: I think the segment would be pretty large myself. |
| 16:08 |
jeff |
coaxing a selfcheck back to life, i'm overhearing one patron giving a tour of the library to what sounds like an out-of-town friend or family member. :-) |
| 16:33 |
|
roses joined #evergreen |
| 16:47 |
|
mrpeters1 joined #evergreen |
| 16:49 |
pinesol_green |
[evergreen|Lebbeous Fogle-Weekley] TPAC: Get rid of all unneccessary uppercase and some bold - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=1055125> |
| 16:49 |
pinesol_green |
[evergreen|Dan Scott] TPAC: Display public hold notes in user holds list - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=f90cd00> |
| 16:49 |
pinesol_green |
[evergreen|Lebbeous Fogle-Weekley] TPAC: Add Notes label to that row in small-screen My Account->Holds - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=24d254d> |
| 17:06 |
|
afterl left #evergreen |
| 17:07 |
|
dcook joined #evergreen |
| 17:09 |
jeff |
senator++ dbs++ |
| 17:17 |
|
mmorgan left #evergreen |
| 18:58 |
|
adbowling-isl_ joined #evergreen |
| 22:43 |
|
burlingtonwa joined #evergreen |
| 22:51 |
burlingtonwa |
I'm new to acq and reports; is there a way I can run a report of which new items are added copies (i.e. attached to an existing bib) and which are new bibs? |
| 22:52 |
burlingtonwa |
thanks in advance for your help! |
