Evergreen ILS Website

IRC log for #evergreen, 2016-07-05

| 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
01:17 bshum Calling 0982
01:19 bshum Dyrcona++
01:19 pinesol_green [evergreen|Jason Stephenson] LP#1568046: Replace last two uses of connectby with other function calls. - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=499d69d>
01:19 pinesol_green [evergreen|Ben Shum] LP#1568046: Stamping upgrade script for eliminating connectby from functions - <http://git.evergreen-ils.org/?p=​Evergreen.git;a=commit;h=50eb643>
04:13 gsams joined #evergreen
07:22 Christineb joined #evergreen
07:26 rjackson_isl joined #evergreen
07:29 agoben joined #evergreen
07:37 JBoyer joined #evergreen
07:47 mrpeters joined #evergreen
08:04 csharp Bmagic: following up on your question from late Friday, PINES libraries have wanted action.circulation and action.non_cataloged_circulation combined, but not in-house use that I remember
08:05 csharp in-house use is a different line item on most reports that I've seen
08:05 csharp ("reports" here referring to those sent to funding agencies)
08:33 mmorgan joined #evergreen
08:45 maryj joined #evergreen
08:50 jwoodard joined #evergreen
09:04 jvwoolf joined #evergreen
09:11 bos20k joined #evergreen
09:48 gsams joined #evergreen
11:07 Bmagic csharp: good to know. I was considering a view that would have a column to clairify which of the tables that the row belongs. Example "type" that would display "non cat in-house", "cataloged in-house", "non cat circ" ," regular circ"
11:07 Bmagic or something like that
12:12 Dyrcona joined #evergreen
12:17 agoben joined #evergreen
12:17 brahmina joined #evergreen
12:23 jihpringle joined #evergreen
12:27 bmills joined #evergreen
13:02 csharp Bmagic: sounds like that would do what our users would be after
13:42 Bmagic csharp: I know you are handy with reports. I am getting this view up and running. Now I am crafting the report in the UI. I know I need to enable nullability. I have tried all three (none, parent, default) for connecting back to actor.usr
13:42 Bmagic I want rows to show up where the reference to actor.usr is null
13:42 pastebot "Bmagic" at 64.57.241.14 pasted "SELECT * FROM (SELECT "2b6d56b" (13 lines) at http://paste.evergreen-ils.org/17
13:43 Bmagic I am running into a wall here. I am starting to second guess my fm_IDL.xml
13:43 tsbere Bmagic: You may be better off making a new virtual IDL view out of a complex SELECT statement...
13:45 Bmagic tsbere: last time I was working on code where a view was involved, you suggested that. I might end up using that method instead of a view, but I'm not sure how it would affect the nullability issue right now
13:46 tsbere Bmagic: Without knowing fully what you are doing I am less certain, I would probably need to see all your pieces to determine where you may have gone wrong.
13:47 pastebot "Bmagic" at 64.57.241.14 pasted "The view definition" (154 lines) at http://paste.evergreen-ils.org/18
13:50 Bmagic tsbere: do you more info from my attempted report template?
13:50 tsbere Bmagic: Probably more important to see the IDL entry at this point
13:51 Bmagic ah yes
13:51 pastebot "Bmagic" at 64.57.241.14 pasted "The IDL" (64 lines) at http://paste.evergreen-ils.org/19
13:52 tsbere Bmagic: Perhaps you need "might_have" on the nullable columns instead of "has_a"?
13:52 Bmagic that might be it
13:53 Bmagic I figured if it came back null, that would "override" the has_a
13:54 tsbere If the reporter thinks it will never be null, why do any nullability anything with it?
13:55 Bmagic tsbere: does has_many imply at least one, or will it allow none (aka might_have) ?
13:56 tsbere Bmagic: I am less certain there. That may be "none or more" or "one or more", I would have to code dive to be certain
13:59 Bmagic tsbere: this is weird
13:59 Bmagic "DBD::Pg::st execute failed: ERROR:  column 2b6d56b95f96e5302ac729b1be63190e.null does not exist LINE 7: ...tor.usr AS "9419e58708e607bf02ee0a59f537dd03" ON ("2b6d56b95...
13:59 Bmagic it's looking for a column named "null" ?
14:00 * tsbere has no clue offhand beyond "did you restart everything including clark when you made the changes?"
14:01 Bmagic I restarted opensrf, clark, staff client
14:01 Bmagic no worries, I will keep hammering! Thank you for your help! tsbere++
14:20 dbwells joined #evergreen
14:39 mmorgan Bmagic: autogen?
14:41 tsbere mmorgan / Bmagic: Just thought of one thing, there are two fm_IDL copies, if only one was edited...
14:42 tsbere (though "edit main copy and re-run install" instead of "edit in-place copy" should hopefully deal with some of that...)
14:52 Dyrcona Yep. Probably need to copy the main one over the one for the reporter.
15:16 bmills1 joined #evergreen
15:18 maryj_ joined #evergreen
15:48 csharp Bmagic: sorry - afk for a while - I'll take a look tomorrow
16:03 Bmagic tsbere: yeah, I have been updating  both /openils/conf/fm_IDL.xml and /openils/var/web/reports/fm_IDL.xml
16:40 jlitrell joined #evergreen
16:47 bshum phasefx++ # infinite loop testing
16:48 jlitrell That sounds like it could take a while.
16:48 * tsbere isn't entirely sure he would want to test in an infinite loop
16:48 tsbere ;_
16:48 tsbere er, ;)
16:49 * phasefx likes breaking things; it's his super-power
16:53 gsams phasefx++ #break all the things, for science.
17:02 mmorgan left #evergreen
17:43 Bmagic csharp tsbere: It looks like it will work if I remove columns such as patron which do not always connect
17:50 HBRENNAN joined #evergreen
17:50 * Bmagic waves at HBRENNAN and loves the new "facelift"
17:51 hbrennan :)  dang all caps
17:51 Bmagic lol, must have been working on the SQL prompt
17:51 hbrennan Excited someone is still here so late in the (east coast) day
17:52 hbrennan I have an issue....
17:53 hbrennan Reports are generating barcodes without the leading zeros.. How do we get reports to spit out ALL the digits in item barcodes?
17:53 hbrennan Example barcode: 000135045
17:53 hbrennan report only has 135045
17:54 hbrennan We need to do mass holds on a few hundred items
17:54 gsams hbrennan: In my experience this is more of an issue with the way excel treats numbers than how Evergreen reports it.
17:54 hbrennan If it was just a matter of adding zeros, i could do this in Excel.. but some have 3 zeros and some have 4
17:54 hbrennan gsams: Ahhh! Let me see
17:55 jlitrell =Text (A1, "00000") or whatever is the Excelly method...
17:55 jlitrell To not answer your question.  :)
17:55 gsams excel usually removes the leading zeros from numbers because it isn't sanitary for math.
17:57 hbrennan I changed the column to 'Text' but it didn't add the zeros
17:57 hbrennan It makes sense that this is an Excel issue though
17:57 gsams Yeah, excel just strips them out completely
17:58 hbrennan Ugh
17:58 gsams In my experience, I usually just format the barcode field with a custom setup ######## for our old 8 digit barcodes with leading zeros
17:58 gsams or rather, 000#####
18:00 gsams Actually, it's better to use a custom format that is simply a series of zeros, whatever length you need.
18:02 gsams That should at least make the numbers appear correctly after output.
18:03 hbrennan gsams: Yeah, that's what my goal is.. since these then need to be uploaded back to Evergreen for placing holds
18:04 hbrennan I am not the reports person at my library (he's gone this week), but it seems this is the hard way of doing things....
18:05 gsams hbrennan: Yep, then selecting the column and formatting the cells with 000000000 has been the only way I've gotten that to work.  I suppose there might be some other way, but this works.
18:06 hbrennan "works" is all I'm after for a Tuesday that feels like a Monday
18:07 gsams hopefully that does the trick for you then
18:08 hbrennan It does! gsams++
18:08 hbrennan jlitrell++ you pointed me there as well
18:10 gsams_ joined #evergreen
18:11 hbrennan off hand, anyone know the limit of entries for "upload from file" in Item Status?
18:11 bshum hbrennan: I don't think it limits, but the interface itself for Item Status can cut off after 20 or so I think
18:12 hbrennan bshum: Yes, the evil Trim List
18:13 hbrennan bshum: I meant brain power limit.. like should we wait to do this when we're not open
18:13 bshum hbrennan: Well, I've seen XUL clients crash from trying to do too much at once
18:14 bshum Like overburdened RAM usage from trying to keep all that info in memory
18:17 hbrennan bshum: Yeah, especially since we're going to ask Evergreen to place holds on all these items
18:17 hbrennan after importing the barcodes
18:18 gsams I've worked on items in chunks of a few hundred at a time before, but all I was doing was changing their status
18:18 hbrennan That sounds about the same thinking power as place holds, eh?
18:21 hbrennan We need to place holds on 304 items
18:22 gsams That's not too bad overall, maybe split it into 2-3 separate jobs.
18:22 hbrennan Yeah, I'm not feeling too frisky today
18:22 hbrennan I think I'll do this tomorrow before we open
18:26 hbrennan The official docs recommend no more than 100 items loaded using Upload From File in Item Status
18:26 hbrennan DIG++
18:27 gsams Heh, I tend to push boundaries a bit on those suggestions
18:27 hbrennan I do too, just not on post-holiday days :)
18:27 gsams indeed, bad timing.  Quiet days are much better.
18:27 hbrennan with two puppets shows
18:28 gsams @8ball Are quiet days much better?
18:28 pinesol_green gsams: What do you mean? An African or European swallow?
18:28 hbrennan and Minecraft competition sign-up
18:30 gsams @eightball Are quiet days much better?
18:30 pinesol_green gsams: Naturally.
18:30 hbrennan ha
18:30 gsams I'll take it
18:55 hbrennan Agk. Where is maximum holds setting.... Thought it was under Group Penalty Thresholds, but nay.
18:56 hbrennan Oh, Hold Policies
18:56 hbrennan Duh
20:41 gsams_ joined #evergreen
21:46 Christineb joined #evergreen
22:35 serflog joined #evergreen
22:35 Topic for #evergreen is now Welcome to the #evergreen library system channel! | We are publicly logged: http://irc.evergreen-ils.org/evergreen | Large pastes at http://paste.evergreen-ils.org
22:35 pastebot joined #evergreen
23:03 Callender joined #evergreen

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