Time |
Nick |
Message |
00:04 |
bshum |
Hmmm, parallel vacuum in PostgreSQL 9.5. Intriguing... |
00:04 |
bshum |
https://wiki.postgresql.org/wiki/What's_new_in_PostgreSQL_9.5 |
07:27 |
|
graced joined #evergreen |
07:39 |
|
rjackson_isl joined #evergreen |
07:54 |
|
ericar joined #evergreen |
08:13 |
|
jboyer_isl joined #evergreen |
08:44 |
|
Dyrcona joined #evergreen |
09:02 |
|
jwoodard joined #evergreen |
09:24 |
|
ericar_ joined #evergreen |
09:24 |
|
genpaku joined #evergreen |
09:25 |
|
genpaku joined #evergreen |
09:28 |
|
ericar_ joined #evergreen |
09:30 |
|
mrpeters joined #evergreen |
09:45 |
|
collum joined #evergreen |
09:46 |
|
krvmga joined #evergreen |
09:54 |
|
pmurray joined #evergreen |
09:54 |
|
pmurray left #evergreen |
10:18 |
Dyrcona |
So, I'm working on something where I'd like the mkurl macro, but not the rest of opac/parts/header.tt2. |
10:18 |
Dyrcona |
I think it would be nice to move the necessary bits to a macros.tt2 somewhere. |
10:19 |
Dyrcona |
For now, I'll copy and paste. |
10:21 |
Dyrcona |
Err, maybe I won't use it for now, anyway. |
10:22 |
kmlussier |
Dyrcona: I think it makes sense to use a separate tt2 file for that and for other things like that. For pages where you don't necessarily want to use the header. |
10:22 |
|
ericar_ joined #evergreen |
10:22 |
Dyrcona |
Well, I'm doing something rather bizarre, so... |
10:26 |
Dyrcona |
What's fun is you can drop tt2 files under /eg/<somewhere> and they "just work." |
10:28 |
|
ericar_ joined #evergreen |
10:28 |
kmlussier |
Dyrcona: What are you working on? Anything fun? |
10:29 |
Dyrcona |
I am making a page to restore deleted copies from a list of barcodes. |
10:29 |
Dyrcona |
Since we're not likely to use the web staff client, I'm adding it under /eg/utils/restorecopies |
10:29 |
Dyrcona |
I've even written a simple EGUtilsLoader.pm. |
10:41 |
Dyrcona |
An interesting feature was added to EGWeb for the staff client: OILSStopAtIndex. I was playing around with that one yesterday afternoon. |
10:45 |
Dyrcona |
I guess we don't have a way to load templates based on the locale, do we? |
10:46 |
Dyrcona |
Not that I should be worried about translations. |
10:47 |
Dyrcona |
I suppose, I could do something like include base . ctx.locale . ext |
10:53 |
berick |
normally you load the same template regardless of locale, only the l(...) strings are replaced. |
10:53 |
berick |
from the po files |
10:55 |
Dyrcona |
berick: Yeah, I know. In this case, I was going to add a paragraph of text that might change if it was ever internationalized. |
10:55 |
Dyrcona |
Seems a bit much to wrap with l(..). |
10:59 |
|
Christineb joined #evergreen |
10:59 |
|
sandbergja joined #evergreen |
11:00 |
Dyrcona |
I won't worry about that for now. |
11:17 |
berick |
a good formatting trick for l(): [% |l %]long text here[% END %] |
11:19 |
miker |
berick: but that would break the i18n string-extraction scripts that find things to translate, right? |
11:19 |
berick |
miker: I hope not. that trick is used a lot |
11:19 |
berick |
i haven't looked at the extraction scripts.. |
11:20 |
miker |
dbs: do you recall OTTOYH? -^ |
11:22 |
berick |
i see about 20 instances in the master templates |
11:26 |
|
graced joined #evergreen |
11:27 |
dbs |
miker: I don't think so. |
11:28 |
dbs |
I believe the TT2 locale-extraction tooling does real parsing to generate POT, not the kinds of brittle hacks I did with the other formats :) |
11:31 |
miker |
dbs: I just checked, you're right :) |
11:31 |
miker |
http://search.cpan.org/~drtech/Locale-Maketext-Lexicon-1.00/lib/Locale/Maketext/Extract/Plugin/TT2.pm |
11:31 |
miker |
berick: nm me ;) |
11:31 |
berick |
oh, great. |
11:32 |
berick |
a valid concern, nontheless. |
11:32 |
miker |
it's not clear if '()'s are required for that to work, though |
11:32 |
berick |
they are not required |
11:32 |
berick |
you can use l(params) if needed, but bare l also works |
11:32 |
miker |
oh, I meant for i18n |
11:32 |
berick |
oh |
11:33 |
miker |
(though you may have, too ;)) |
11:34 |
berick |
nope, i was talking about the templates |
11:34 |
miker |
in any case, I suppose just looking for one of the strings in question in the en_US po would tell us |
11:47 |
|
bmills joined #evergreen |
12:11 |
Dyrcona |
And, it "just works" in the staff client. |
12:11 |
Dyrcona |
;) |
12:13 |
Dyrcona |
load_simple is optional, apparently. |
12:31 |
|
jihpringle joined #evergreen |
12:42 |
|
graced joined #evergreen |
13:03 |
bshum |
Hmm |
13:03 |
bshum |
print overdues, bleh |
13:04 |
bshum |
What do you do when the name of the library is "Jones Public Library" and you also have a "New Jones Public Library". So the parsing will probably grab anything that says Jones, gah, gah |
13:05 |
* bshum |
ponders this and rethinks how the parsing is handled |
13:07 |
bshum |
I suppose if the name was somehow more unique |
13:08 |
bshum |
Then we could searchfor the more unique string |
13:27 |
* tsbere |
has his code do everything by shortname |
13:31 |
bshum |
tsbere: I'm thinking I need to change ours to that method too |
13:31 |
bshum |
I just haven't figured out how it knows yet |
13:43 |
|
graced joined #evergreen |
13:50 |
jboyer_isl |
bshum: 2 important things there, move to shortname like tsbere mentioned (you may have to add that field in the AT template?) and dump “contains” for that. It’s interesting that it’s available, but = does the job perfectly well. |
13:51 |
bshum |
jboyer_isl: Well, in our print_overdue.sh script, it's doing something like |
13:51 |
bshum |
xsltproc --stringparam gendate "${GENDATE}" --stringparam lid $SEARCHFOR $FO_XSL $XML_FILE > $PRINT_FO_FILE; |
13:51 |
|
Callender joined #evergreen |
13:51 |
bshum |
The part where it's doing a stringparam lid $SEARCHFOR |
13:51 |
bshum |
I think that's where the name is getting checked |
13:51 |
|
_bott_ joined #evergreen |
13:52 |
bshum |
I'm checking the XSL bit to try figuring out how "lid" is generated |
13:52 |
jboyer_isl |
Oh, that’s not where I was thinking you were looking. lid should already be the shortname, I think. |
13:55 |
rjackson_isl |
flashing back ti nightmares regarding shortname and printed notices - think Jason fixed that locally - but before the fix we (I) ended up ensuring the new shortname for a library was not a substr of an existing shortname :( |
13:55 |
rjackson_isl |
s/ti/to |
13:56 |
bshum |
We got something like <xsl:variable name="locname" select="$lid" /> in our .xsl file that draws from |
13:56 |
bshum |
So I assume that's how we get the full name of the library for lid |
13:57 |
jboyer_isl |
I think ours was an xsl change. That’s what I was referring to with the contains comment. Something in the xslt processing was using it instead of =. |
13:57 |
bshum |
Maybe I'll make a new variable |
13:57 |
bshum |
And test it by changing one of them to use shortname |
13:57 |
bshum |
And then convert everything over |
14:22 |
bshum |
In any case, tsbere++ rjackson_isl++ jboyer_isl++ |
14:22 |
bshum |
Thanks for feedback guys! Appreciate it :) |
15:05 |
|
graced joined #evergreen |
15:16 |
|
Ivran joined #evergreen |
15:19 |
Ivran |
Would someone be able to tell me what I am doing wrong in trying to run this Evergreen report...? All I am trying to do is run a report that counts the number of patrons assigned a particular stat category. |
15:19 |
Ivran |
Specifically count the number of male accounts vs female accounts for one of the libraries. |
15:20 |
bshum |
Sounds simple enough. |
15:20 |
* bshum |
is not a reports expert, but that scenario seems straightforward |
15:21 |
Ivran |
I think my problem is that I get lost in what to do for the statistical category |
15:21 |
Ivran |
I either get a report that doesn't run, or I get a report that just shoots back the total. |
15:24 |
Ivran |
I've tried this multiple ways, but right now I just have this as the basic fields to display: |
15:24 |
Ivran |
Home Library -- text -- raw data |
15:24 |
Ivran |
Stat Cat Value -- text -- raw data |
15:24 |
Ivran |
# of Patrons -- id -- count |
15:24 |
Ivran |
And the base filters are Org ID and Stat Cat ID in list |
15:26 |
jboyer_isl |
I can’t do a very good job of explaining it right now, but the short answer is it you are looking at stat cats at all you have to check the Nullability checkbox below the source box before building your report. can you walk Ivran through that bshum ? |
15:27 |
* bshum |
backs away slowly from his computer screen whenever people ask him about reports :( |
15:29 |
bshum |
I think I've heard of what jboyer_isl is describing, but unfortunately have not used it before |
15:32 |
jboyer_isl |
It lets you choose between left, inner, and sometimes right joins on the tables in the reporter. Default means “whatever the system thinks is best” which is usually left, I think. |
15:34 |
|
Ivran_ joined #evergreen |
15:34 |
Ivran_ |
I don't think the web client likes me very much. -- I will give the nullability a test and see what I can learn, though! |
15:37 |
jboyer_isl |
Ivran: you’ll probably want to choose links that have None in the Nullable column when you’re selecting the stat cat fields. That way you can inner join the user and SC tables to only look at users with SC entries, then you have to display the entry value (not sure of the field names off hand) and a count distinct on entry id to get the totals for each value. |
15:38 |
Ivran_ |
jboyer_isl: Thank you! I think I can attempt that well enough. I'll see what I can do. |
15:41 |
Bmagic |
Ivran_: I have had similar difficulties with stat cats - nullable is the answer |
15:41 |
Bmagic |
because not all patrons have a row in the stat cat tables |
15:43 |
Ivran_ |
I'm brand new to this, so I just keep trying until I get it. |
15:49 |
Ivran_ |
Ciao for now. I'll come back if I can't figure it out. Thank you! |
15:58 |
bshum |
dbwells: https://bugs.launchpad.net/evergreen/+bug/1526543 didn't have a pullrequest on it, but it looked fine for testing, I'm going to go ahead and push it through, though for note, the default is that reset_password = 'true' so the test approach as described confused me initially :\ |
15:58 |
pinesol_green |
Launchpad bug 1526543 in Evergreen 2.9 "Cannot disable password reset in TPAC" [Low,New] |
15:59 |
bshum |
I may update the test instruction in the git commit message to reflect the actual default and the need to alter the config.tt2 to set that to false. |
16:01 |
dbwells |
bshum: heh, sorry about that. I guess I assumed it was false, since optional things are often off by default. It does make more sense now that nobody else notice it :) And, thank you! |
16:02 |
bshum |
dbwells: Cool, cool |
16:02 |
bshum |
dbwells++ remingtron++ |
16:05 |
pinesol_green |
[evergreen|Dan Wells] LP#1526543 Truthiness check for reset_password is flawed - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=c1cec9a> |
16:09 |
pinesol_green |
[evergreen|Galen Charlton] LP#1530158: ensure that Business::OnlinePayment::PayflowPro is installed - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=96764f5> |
16:15 |
Bmagic |
anyone have trouble with offline circulation through a staff client upgrade? The staff client accumulates offline transactions. Then gets online and prompted for an upgrade, is upgraded, then offline transactions are OK? |
16:15 |
|
jlitrell joined #evergreen |
16:15 |
bshum |
Reading http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14759 because of https://bugs.launchpad.net/evergreen/+bug/1501781 |
16:15 |
pinesol_green |
Launchpad bug 1501781 in Evergreen 2.9 "Patron name search should be diacritic-insensitive" [Medium,Triaged] |
16:16 |
bshum |
And google search is funny |
16:16 |
bshum |
Bmagic: So you mean that staff are using the older client in offline, then upgraded, and try to upload their offline transactions? |
16:17 |
Bmagic |
bshum: yeah |
16:17 |
* bshum |
thinks that's worked out okay for us in the past |
16:17 |
bshum |
Are you seeing issues with recognizing something? |
16:17 |
bshum |
Or errors? |
16:31 |
pinesol_green |
[evergreen|Jason Stephenson] LP 1519465: POs with spaces in the name cause EDI problems. - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=7844c5e> |
16:31 |
pinesol_green |
[evergreen|Jason Boyer] LP1522686: Force SSL for Web Staff, Add Basic Redirect for Staff URL - <http://git.evergreen-ils.org/?p=Evergreen.git;a=commit;h=aa3da6f> |
16:37 |
|
jlitrell joined #evergreen |
16:41 |
Dyrcona |
bshum++ # Reviewing bug fixes. |
16:43 |
|
jeff_ joined #evergreen |
17:15 |
Bmagic |
bshum: no - I am just trying to think of potiential issues when we upgrade to 2.9.1. We have at least one library that wants to remain open while we take the servers down for two days |
17:24 |
|
graced joined #evergreen |
17:28 |
|
bmills joined #evergreen |
17:43 |
|
mrpeters joined #evergreen |
18:04 |
|
HoloIRCUser2 joined #evergreen |
18:05 |
|
HoloIRCUser3 joined #evergreen |
18:06 |
|
HoloIRCUser2 joined #evergreen |
20:47 |
|
bmills joined #evergreen |
21:13 |
|
bmills joined #evergreen |
22:49 |
|
geoffsams joined #evergreen |