Evergreen ILS Website

IRC log for #evergreen, 2016-04-15

| 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: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-Que​rying-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.o​rg/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

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