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