Evergreen ILS Website

IRC log for #evergreen, 2014-01-06

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat

All times shown according to the server's local time.

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/doc​s/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/eve​rgreen/+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_cli​ent/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!

| Channels | #evergreen index | Today | | Search | Google Search | Plain-Text | summary | Join Webchat