| Time |
Nick |
Message |
| 01:29 |
|
phasefx_ joined #evergreen |
| 02:23 |
|
gsams joined #evergreen |
| 02:55 |
|
geoffsams joined #evergreen |
| 04:46 |
|
Callender joined #evergreen |
| 04:59 |
|
lualaba joined #evergreen |
| 04:59 |
lualaba |
Hello i have question regardind emails: how to configure gmail smtp server with evergreen for outgoing emails |
| 06:04 |
|
Callender joined #evergreen |
| 06:35 |
|
rlefaive joined #evergreen |
| 06:48 |
|
kmlussier joined #evergreen |
| 06:53 |
kmlussier |
@coffee |
| 06:53 |
* pinesol_green |
brews and pours a cup of Ethiopia Natural Yirgacheffe Aricha Special Microlot, and sends it sliding down the bar to kmlussier |
| 07:46 |
|
Callender joined #evergreen |
| 08:00 |
|
kmlussier joined #evergreen |
| 08:14 |
|
ericar joined #evergreen |
| 08:19 |
|
Dyrcona joined #evergreen |
| 08:23 |
|
Callender joined #evergreen |
| 08:28 |
|
gsams joined #evergreen |
| 08:38 |
|
Dyrcona joined #evergreen |
| 08:38 |
Dyrcona |
Well, that's nice. |
| 08:42 |
|
Callender joined #evergreen |
| 08:43 |
|
mrpeters joined #evergreen |
| 08:45 |
|
ericar_ joined #evergreen |
| 08:51 |
|
Callender joined #evergreen |
| 08:55 |
|
Callender joined #evergreen |
| 09:00 |
kmlussier |
Dyrcona: What's nice? |
| 09:00 |
Dyrcona |
Getting kicked out of IRC and saying something in the channel in between being kicked out and your client knowing you're kicked out. |
| 09:13 |
|
maryj joined #evergreen |
| 09:13 |
|
jvwoolf1 joined #evergreen |
| 09:24 |
|
rlefaive joined #evergreen |
| 09:46 |
|
kmlussier joined #evergreen |
| 09:54 |
|
yboston joined #evergreen |
| 10:07 |
|
atheia joined #evergreen |
| 10:08 |
atheia |
Hello |
| 10:08 |
atheia |
I have a question about using json_query, I was hoping someone might be able to point me in the right direction: |
| 10:09 |
atheia |
I need to perform some date math on a datefield prior to retrieving it from the database. |
| 10:10 |
atheia |
I was hoping I could use psql's 'timestamp + "N days"' syntax — but I seem to be having difficulty getting that into json_query syntax. |
| 10:10 |
atheia |
Presumably because '+' isn't a function but an operator? |
| 10:10 |
tsbere |
atheia: There are some limitations to what you can do with json_query, that may be one of the things you can't actually pull off |
| 10:10 |
atheia |
Any ideas how I might pursue this? |
| 10:10 |
atheia |
tsbere: Ah, what a shame. Thanks for your thoughts though. |
| 10:11 |
atheia |
So I imagine the solution to go for would be some form of "retrieve date, then perform calculation outside of SQL (Perl in my case)"? |
| 10:14 |
Dyrcona |
I think there might be a way to do in JSON query.... Give me a few minutes. |
| 10:15 |
tsbere |
Dyrcona / atheia: To quote the jsontutorial doc: You can't select an arbitrary expression, such as "percentage / 100" or "last_name || ', ' || first_name". |
| 10:16 |
tsbere |
As such, I assume that date math counts there as PG doesn't have date math *functions* that you could cheat with using transform |
| 10:16 |
Dyrcona |
Right, but I think there might be a more convoluted way to make it work. |
| 10:16 |
Dyrcona |
I just want to try something. If it works, I'll share. If it doesn't, I'll just you can't do that. :) |
| 10:17 |
atheia |
tsbere: That sounds eminently coherent; nonetheless, Dyrcona, if you find something that be a life-saver :-) |
| 10:17 |
Dyrcona |
You'll have read into the omissions. ;) |
| 10:17 |
atheia |
:-) |
| 10:17 |
Dyrcona |
gah... |
| 10:18 |
Dyrcona |
Never mind, that won't work. I don't even have to run the code to know. |
| 10:21 |
atheia |
Dyrcona: k, thanks for giving it a try anyway. |
| 10:29 |
Dyrcona |
atheia: Beyond adding intervals to dates, what are you trying to do? |
| 10:30 |
|
sandbergja joined #evergreen |
| 10:30 |
atheia |
We have a custom table that describes when an item was last moved to a new branch. For UI convenience we want to display the date when the item is next scheduled to be moved. This would be the last transfer date + 'an interval'. |
| 10:31 |
atheia |
I'm trying to find a convenient way to extract the latter value. |
| 10:31 |
atheia |
Does that make sense? |
| 10:31 |
tsbere |
atheia: If it is a custom table *already* then make a custom view |
| 10:31 |
tsbere |
The view does the math for you, then you select from the view |
| 10:32 |
atheia |
That is definitely an approach worth considering indeed. Cheers for that :-) |
| 10:32 |
atheia |
That hadn't even come into my head as a possible approach…! |
| 10:33 |
tsbere |
atheia: You could also jam a trigger function in that updates a column on your table with the pre-calculated date |
| 10:35 |
atheia |
tsbere: Right. I think from my perspective I'd prefer the custom view. I've been considering an additional column, but might call that plan B. |
| 10:38 |
|
kmlussier joined #evergreen |
| 10:42 |
|
mllewellyn joined #evergreen |
| 10:52 |
|
Christineb joined #evergreen |
| 10:53 |
kmlussier |
berick++ # bug 1570909 |
| 10:53 |
pinesol_green |
Launchpad bug 1570909 in Evergreen "User activity tracking should be transient by default" [Undecided,New] https://launchpad.net/bugs/1570909 |
| 10:54 |
kmlussier |
I had the same thought a few months ago when we were looking at user activity tracking, but then I forgot about it. |
| 10:57 |
berick |
tried to collect data on user activity only to find it was taking forever because the table has 350M rows :( |
| 11:07 |
|
hopkinsju joined #evergreen |
| 11:09 |
|
brahmina joined #evergreen |
| 11:18 |
|
ejk joined #evergreen |
| 11:18 |
|
ericar_ joined #evergreen |
| 11:20 |
|
hopkinsju joined #evergreen |
| 11:25 |
|
csharp_ joined #evergreen |
| 11:27 |
|
kmlussier joined #evergreen |
| 11:27 |
Dyrcona |
Well, that's even nicer.... ;) |
| 11:27 |
* Dyrcona |
was typing a message to kmlussier when the net split happened. |
| 11:28 |
kmlussier |
Dyrcona: Somebody is trying to tell you that you shouldn't be typing in IRC today. |
| 11:29 |
Dyrcona |
Could be. |
| 11:29 |
Dyrcona |
Turns out that the problem I mentioned when I was offline, but thought I was online, is a local issue with our marc_export missing a commit. |
| 11:30 |
Dyrcona |
No big deal, but mystery solved. |
| 11:31 |
Dyrcona |
So, now you all know what I said when you didn't know I had said anything in the first place. |
| 11:33 |
kmlussier |
@swill Dyrcona |
| 11:33 |
* pinesol_green |
grabs a forty of Private Stock and sends it sliding down the bar to Dyrcona |
| 11:34 |
|
akilsdonk joined #evergreen |
| 11:39 |
Dyrcona |
"Private Stock was discontinued in 2013." |
| 11:43 |
|
jvwoolf1 left #evergreen |
| 11:45 |
|
justdoglet joined #evergreen |
| 11:46 |
|
bmills joined #evergreen |
| 12:09 |
dbs |
who's probably silly proud of himself for taking two spreadsheets of almost 1000 titles, uploading them to Google Sheets, and adding a custom "checkForISBN()" function to Google Sheets that then returns a Yes or No response? THIS GUY |
| 12:11 |
|
jihpringle joined #evergreen |
| 12:12 |
dbs |
it's 8 lines of javascript, and simply checks for an ISBN via SRU, but with a bit of polishing I could probably make it a bit more flexible and available (e.g. don't hardcode the base URL, and allow for other search params, and return more than "yes" / "no") in the Chrome Web App Store |
| 12:12 |
berick |
nice. obligatory http://xkcd.com/1667/ |
| 12:12 |
miker |
atheia / Dyrcona / tsbere: actually, you can add an interval to a date or timestamp column in the select list of a json_query. you use the transform syntax, and the function you want to use would be either timestamptz_pl_interval or date_pl_interval, depending on the column type |
| 12:13 |
|
ldw joined #evergreen |
| 12:14 |
tsbere |
miker: Ok, I will admit I hadn't considered "go find the backend implementation function for the operator and use it instead" |
| 12:14 |
miker |
what you can't do is pass two columns in as parameters |
| 12:14 |
tsbere |
But yea, if the second piece of the addition is being pulled from the table as well that wouldn't work |
| 12:16 |
dbs |
berick++ |
| 12:17 |
dbs |
Yeah, the bonus of Google Sheets is that it's very approachable for non-geeks like me, vs my normal approach of just creating a temporary table with the ISBNs and running match queries directly in SQL |
| 12:18 |
dbs |
Sure don't want to turn it into another spreadsheet-based acquisitions system though :) |
| 12:19 |
miker |
dbs: whoa... I had no idea you could write functions in JS for gsheets that can talk to the world! that ... is pretty awesome. |
| 12:22 |
dbs |
miker: yeah, I've known about it in the back of my head but finally had the right combination of "we shouldn't ask a human to check all of these manually" and "I have time to explore for an hour" |
| 12:22 |
dbs |
https://developers.google.com/apps-script/quickstart/macros#set_it_up for a quickstart, https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app#fetchurl for the outside world talker |
| 12:26 |
miker |
thanks, kind sir |
| 12:27 |
gsams |
dbs++ #Thanks for sharing that bit of fantasticness |
| 12:27 |
dbs |
will share the code i used after lunch |
| 12:31 |
|
mcarlson joined #evergreen |
| 12:33 |
atheia |
miker++ |
| 12:33 |
atheia |
miker: Thanks for that — some good digging about? |
| 12:39 |
|
atheia left #evergreen |
| 12:57 |
|
akilsdonk joined #evergreen |
| 13:00 |
|
csharp joined #evergreen |
| 13:19 |
|
jihpringle_ joined #evergreen |
| 13:19 |
|
akilsdonk_ joined #evergreen |
| 13:20 |
|
phasefx__ joined #evergreen |
| 13:22 |
|
ldw_ joined #evergreen |
| 13:23 |
|
ejk_ joined #evergreen |
| 13:23 |
|
kmlussier joined #evergreen |
| 13:24 |
|
csharp joined #evergreen |
| 13:24 |
|
csharp joined #evergreen |
| 13:28 |
|
bmills joined #evergreen |
| 13:29 |
|
rfrasur joined #evergreen |
| 13:30 |
|
ericar joined #evergreen |
| 13:52 |
|
mrpeters joined #evergreen |
| 13:58 |
|
remingtron joined #evergreen |
| 13:59 |
|
ericar_ joined #evergreen |
| 15:02 |
|
jlitrell joined #evergreen |
| 15:04 |
|
maryj joined #evergreen |
| 15:07 |
|
ericar_ joined #evergreen |
| 15:10 |
dbs |
my blog is alive: https://coffeecode.net/archives/310-Querying-Evergreen-from-Google-Sheets-with-custom-functions-via-Apps-Script.html |
| 15:12 |
kmlussier |
dbs++ |
| 15:15 |
bshum |
dbs++ |
| 15:17 |
gsams |
dbs++ #great writeup |
| 15:19 |
|
ericar joined #evergreen |
| 15:20 |
Dyrcona |
dbs++ |
| 15:21 |
|
phasefx_ joined #evergreen |
| 15:21 |
|
csharp_ joined #evergreen |
| 15:25 |
|
ejk joined #evergreen |
| 15:26 |
|
mrpeters joined #evergreen |
| 15:36 |
dbs |
Aww. Hopefully that makes up a little bit for me missing the EG Conf :( |
| 15:37 |
bshum |
dbs: Aww, too bad... we will miss you :( |
| 15:43 |
|
rtjure3 joined #evergreen |
| 15:46 |
rtjure3 |
Hello #evergreen, I would like to try the MyAccount Options on https://demo.evergreencatalog.com/ or http://mlnc4.mvlcstaff.org |
| 15:46 |
rtjure3 |
Do I need to register an User? |
| 15:48 |
phasefx |
rtjure3: you should be able to use the admin user. I forget the password, either demo123 or open-ils |
| 15:48 |
phasefx |
looks like evergreen123 for the mlnc4 server |
| 15:49 |
phasefx |
and demo123 for the first one |
| 15:49 |
Dyrcona |
Concerto expects demo123 |
| 15:49 |
Dyrcona |
I think the patrons/other users have preset/predictable passwords, too. |
| 15:49 |
jeff |
there is a list. |
| 15:50 |
Dyrcona |
You could always register a new user. |
| 15:50 |
jeff |
http://wiki.evergreen-ils.org/doku.php?id=qa:concerto_logins |
| 15:50 |
rtjure3 |
thank you that worked! |
| 15:50 |
Dyrcona |
jeff++ |
| 15:51 |
jeff |
and a minor correction to the above: demo and webby use admin/demo123, but concerto itself doesn't drive the admin username or password. |
| 15:52 |
Dyrcona |
The live tests for concerto assume demo123, which is what I should have said. |
| 15:52 |
jeff |
ah! |
| 15:52 |
Dyrcona |
It's hardcoded in most of the test scripts. |
| 15:56 |
rtjure3 |
are there any examples of auto lending/ self-checkout or do you think that is in the reach of evernote? |
| 15:56 |
rtjure3 |
sorry |
| 15:57 |
rtjure3 |
evergreen |
| 15:58 |
phasefx |
rtjure3: you have a web-based self-check option, and SIP-based for 3rd party products. here's the former: http://docs.evergreen-ils.org/2.10/_self_checkout.html |
| 15:58 |
|
bmills joined #evergreen |
| 15:59 |
Dyrcona |
Also, a product called Boopsie can do self-check from an app on a patron's phone if the library adds that feature. |
| 16:02 |
Dyrcona |
Boopsie is a commercial product, I should add. |
| 16:03 |
csharp_ |
@who originally thought "boopsie" was a term for a baby's toy? |
| 16:03 |
pinesol_green |
bwicksall originally thought boopsie was a term for a baby's toy. |
| 16:03 |
bshum |
"You mean you have to use your hands? That's like a baby's toy..." |
| 16:04 |
Dyrcona |
McFly!!!!! |
| 16:05 |
csharp_ |
"such a good boy - he made his first boopsie!" |
| 16:05 |
Dyrcona |
hah |
| 16:05 |
Dyrcona |
csharp++ |
| 16:05 |
bshum |
Ha! csharp++ |
| 16:05 |
|
csharp joined #evergreen |
| 16:06 |
Dyrcona |
Been a hard day for Freenode by the looks of it. |
| 16:06 |
csharp |
yep |
| 16:26 |
|
csharp joined #evergreen |
| 16:26 |
|
csharp joined #evergreen |
| 16:51 |
|
serflog joined #evergreen |
| 16:51 |
|
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 |
| 17:08 |
rtjure3 |
hmm. May I ask for digital media? something like a repository add on? |
| 17:16 |
jeffdavis |
rtjure3: can you clarify what you mean? |
| 17:20 |
rtjure3 |
jeffdavis:I have trainingmaterial that would like directly link to after a self - checkout. Pdf/html any kind of files. |
| 17:22 |
rtjure3 |
Just to add a possibility to track who is studying what. As a user/client you see what is actually still on your interestlist.. |
| 20:02 |
|
geoffsams joined #evergreen |
| 21:02 |
|
bmills joined #evergreen |
| 22:46 |
|
kmlussier joined #evergreen |
