| # | Time | Nick | Message |
|---|
| # | 02:16:51 | EGUEST526 has joined #openils-evergreen |
| # | 02:18:14 | EGUEST526 has quit IRC |
| # | 02:20:28 | Mark__T has joined #openils-evergreen |
| # | 04:21:02 | mib_eyjt4c has quit IRC |
| # | 04:22:06 | mib_eyjt4c has joined #openils-evergreen |
| # | 04:44:07 | mib_eyjt4c has quit IRC |
| # | 04:49:15 | mib_eyjt4c has joined #openils-evergreen |
| # | 04:54:05 | BenO has joined #openils-evergreen |
| # | 04:54:57 | BenO has quit IRC |
| # | 04:56:08 | BenO has joined #openils-evergreen |
| # | 05:16:56 | mib_eyjt4c has quit IRC |
| # | 05:25:19 | mib_eyjt4c has joined #openils-evergreen |
| # | 07:33:46 | brendan_g has joined #openils-evergreen |
| # | 08:02:16 | Mark__T has quit IRC |
| # | 08:04:25 | Mark__T has joined #openils-evergreen |
| # | 08:36:18 | kgs_ has quit IRC |
| # | 08:54:07 | kgs has joined #openils-evergreen |
| # | 09:20:25 | wlayton_work has joined #openils-evergreen |
| # | 09:21:17 | dbs has joined #openils-evergreen |
| # | 09:48:08 | rsinger has joined #OpenILS-Evergreen |
| # | 10:14:31 | mrpeters-isl has joined #openils-evergreen |
| # | 10:14:40 | mrpeters-isl | hey guys....is there a list of all of the "fine stopped reasons" anywhere? |
| # | 10:15:35 | berick | mrpeters-isl: in psql, \d action.circulation .. i think it has a constraint on the column |
| # | 10:17:09 | mrpeters-isl | k thanks! |
| # | 10:23:06 | Mark__T has left #openils-evergreen |
| # | 10:31:48 | dbs_ has joined #openils-evergreen |
| # | 10:37:55 | dbs has quit IRC |
| # | 10:38:21 | gmcharlt has joined #OpenILS-Evergreen |
| # | 11:24:40 | wlayton_work | I'm looking at Vandelay and want to export all of my bib records from Evergreen in MARC21 format. Is creating a Record Bucket the quickest/easiest way to do this? |
| # | 11:26:31 | wlayton_work | If yes, my second question is: Is it possible to quickly add all records to a Record Bucket in the SC? I'm looking at the "Record Query" interface and I'm not sure how to go about adding them all. |
| # | 11:31:58 | dbs_ was off shovelling again |
| # | 11:34:42 | dbs_ | wlayton_work: other en-CA words to keep in mind: "check/cheque" (actually very nice for disambiguation) and "humor/humour" |
| # | 11:35:21 | wlayton_work | dbs_: Ah. Will check for those, too. |
| # | 11:35:29 | dbs_ | I also cleaned up a ton of fuzzies and wrong translations in lang.dtd for en-CA - not sure if those were from the old en-CA "translation" |
| # | 11:36:30 | dbs_ | also - it may be best to work from rel_1_4 for the translations, as backporting PO work from trunk to rel_1_4 is harder than I would like it to be |
| # | 11:45:17 | mrpeters-isl | color / colour too! |
| # | 11:50:06 | wlayton_work | dbs_: If you mean that the file that I gave you is very fuzzy, then I think I didn't run the "make updatepo" for en-CA or something. Hang on - I'll send you another patch for rel_1_4 which will hopefully work. |
| # | 11:51:01 | dbs_ | wlayton_work: no, I meant the one from a few days back |
| # | 11:51:27 | dbs_ | anyways, I checked in the updated version |
| # | 11:52:04 | dbs_ | (into trunk) |
| # | 11:55:06 | wlayton_work | dbs_: Thanks. |
| # | 11:59:08 | dbs_ | wlayton_work: no no - thank you! |
| # | 11:59:23 | dbs_ | mrpeters-isl: yep, wlayton_work caught color/colour already :) |
| # | 12:01:51 | wlayton_work | dbs_: Just to make sure I've got this right: Before I start updating PO files, I should do a "make newpot" / "make LOCAL=fr-CA updatepo" / "make LOCAL=fr-CA install" ? |
| # | 12:02:01 | wlayton_work | I think I've been goofing this up. |
| # | 12:02:03 | phasefx_ | wlayton_work: the Record Query interface isn't quite finished (has a cap on results that you can't get around, for example), but buckets may not be suitable for what you want to do either |
| # | 12:02:43 | dbs_ | wlayton_work: if you're working in trunk, yes; if you're working in rel_1_4, then those steps shouldn't be necessary |
| # | 12:03:46 | phasefx_ | I haven't played with Vandelay yet, so if I were tasked with dumping all MARC records, I'd be using the database. \o filename.marc.xml select marc from biblio.record_entry where marc <> ''; \o |
| # | 12:03:52 | wlayton_work | dbs_: Okay. I wasn't doing them in either. I really should've gone back to read the i18n info in the DokuWiki. Hopefully that hasn't messed too much up. |
| # | 12:05:08 | brendan_g has quit IRC |
| # | 12:05:08 | dbs_ | wlayton_work: well, the i18n info in the wiki probably needs simplification for the plain old translation case |
| # | 12:06:02 | dbs_ | wlayton_work: normally you declare a "string freeze" for an upcoming release (like 1.4) and generate the POT files that the translators can then use to create their own translations |
| # | 12:06:30 | dbs_ | trying to keep in sync with trunk is a much trickier (and probably frustrating) proposition |
| # | 12:07:36 | wlayton_work | dbs_: Ah - good to know. Working with i18n is new for me. |
| # | 12:08:16 | wlayton_work | phasefx: Thanks for the info! |
| # | 12:11:13 | wlayton_work | actually, is it possible to export directly to MARC21, or only in MARCXML? |
| # | 12:11:20 | wlayton_work | (not a big deal - I can run yaz-marcdump) |
| # | 12:12:44 | phasefx_ | marcxml is the format used in the database, so not possible unless you there is some stored procedure somewhere that can munge marc |
| # | 12:12:45 | eby- has joined #OpenILS-Evergreen |
| # | 12:12:59 | wlayton_work | phasefx: Ok - not a problem. |
| # | 12:13:00 | dbs_ | or you could poke and see what vandelay is doing. |
| # | 12:13:51 | phasefx_ | my bet is on the middle layer doing that, but could be a stored procedure |
| # | 12:14:35 | dbs_ | Open-ILS/src/perlmods/OpenILS/WWW/Exporter.pm is where the bulk of the action is at |
| # | 12:16:04 | dbs_ | line 199 is the loop that generates marc21 from the in-db marcxml, for a given list of records |
| # | 12:22:17 | eby has quit IRC |
| # | 12:25:17 | BenO has quit IRC |
| # | 12:34:59 | kgs has quit IRC |
| # | 12:36:01 | dbs_ | my mission for today: create a brand new clean schema. import one record via marc2bre.pl et al. dump schema. then reproduce, with srfsh-based ingest step added. compare and contrast. |
| # | 12:38:16 | dbs_ is now known as dbs |
| # | 12:53:11 | dbs | did someone whack sboyette? or did miker_ just abscond with him in some dark data-munging corner? |
| # | 12:53:34 | dbs was hoping to see the EG Perl modules get the same treatment as sboyette gave to the OpenSRF modules |
| # | 12:53:41 | berick chuckles |
| # | 12:54:03 | berick | i was just lementing how multi-box bricks need new treatment because of the perl modules move about |
| # | 12:54:13 | berick | can't just nfs mount /openils anymore |
| # | 12:54:18 | dbs | berick: hah / bah |
| # | 12:54:59 | berick | i wonder if you can tell nfs to share symlink'd files |
| # | 12:55:33 | mib_eyjt4c has quit IRC |
| # | 12:56:09 | dbs | I'm supposed to look into making Conifer a multi-brick architecture for our uptime / redundancy goals |
| # | 12:57:40 | dbs | is a minimal brick two or three servers? (Web server on one, apps on another, jabber on a third - and memcache co-existing on the web or app server?) |
| # | 12:58:02 | dbs needs to stop being sick |
| # | 12:59:10 | berick | we usually do box-1: apache/ejabberd/settings-server box-2/box-3 all other services ... with a dedicated memcache server on a different machine for all bricks to share |
| # | 12:59:14 | berick | and a dedicated syslog server |
| # | 12:59:23 | berick | and dedicated utility server (holds processing, etc.) |
| # | 12:59:28 | berick | some can be condensed, of course |
| # | 12:59:56 | berick | so, 3-box bricks, adding more bricks as necessary |
| # | 13:00:30 | dbs | berick: very helpful, thanks |
| # | 13:19:02 | eby has joined #OpenILS-Evergreen |
| # | 13:31:43 | kgs has joined #openils-evergreen |
| # | 13:32:33 | eby- has quit IRC |
| # | 13:40:19 | mrpeters-isl | hey guys...looking to write a report that will list all of the ILS User > Main Permission Group > Group Name's and then a count of how many registered in each group....probably a "count distinct" on barcode |
| # | 13:40:38 | mrpeters-isl | the issue im having is, i cant see how i can do 1 report to show all of this...the only way i can see is to do a report for each group name as a filter |
| # | 13:45:22 | mrpeters-isl | someone doesnt want to go through 20+ profile types to get a count of how many patrons belong to each profile group...i hope im not forced to do so |
| # | 13:56:25 | phasefx_ | mrpeters-isl: look on demo.gapines.org as admin/open-ils, under Templates -> Test, jason/mrpeters profile/patron count |
| # | 13:57:00 | dbs thinks that would normally fall into the domain of a GROUP BY in a SQL stmt |
| # | 13:57:46 | dbs also wonders whether importing problems reported by peeps might be a case of parallel_pg_loader vs. pg_loader, as pg_loader test with one record worked perfectly |
| # | 13:57:53 | dbs | now trying a 5000 record test |
| # | 14:00:33 | mrpeters-isl | @phasefx_ actually figured out a way to do it |
| # | 14:00:33 | pinesol | mrpeters-isl: Error: "phasefx_" is not a valid command. |
| # | 14:00:49 | mrpeters-isl | phasefx_: actually got it working |
| # | 14:00:58 | mrpeters-isl | list Group Name text |
| # | 14:01:14 | mrpeters-isl | then a 2nd column with Library Card Barcode as count distinct |
| # | 14:04:09 | phasefx_ | I did it similarly, but with User ID as the thing being counted (involves less tables) |
| # | 14:04:41 | mrpeters-isl | that makes sense |
| # | 14:06:46 | dbs | wlayton_work: btw - https://bugs.launchpad.net/ubuntu/+source/perl/+bug/303765 |
| # | 14:08:30 | mrpeters-isl | where would i find the tables for all of the circ modifiers? |
| # | 14:08:40 | mrpeters-isl | to list them all, and count # of items belonging to them |
| # | 14:09:23 | mrpeters-isl | CN Volume > Copies > Circ Modifier (text)? or is that using too many tables |
| # | 14:10:21 | phasefx_ | mrpeters-isl: the circ modifiers aren't in a table until 1.4 |
| # | 14:10:24 | wlayton_work | dbs: ack |
| # | 14:10:45 | dbs | wlayton_work: was surprised nobody had run into that problem before |
| # | 14:10:53 | dbs | (well, or reported it) |
| # | 14:10:54 | phasefx_ | mrpeters-isl: though you could certainly group a set of items by circ modifier |
| # | 14:11:03 | mrpeters-isl | phase...how best to do it then? |
| # | 14:11:24 | phasefx_ | mrpeters-isl: similar to the way you did users and profiles... display the circ modifier, and do a distinct count on item id |
| # | 14:11:45 | phasefx_ | all in one table |
| # | 14:13:14 | mrpeters-isl | ah, item id |
| # | 14:13:23 | mrpeters-isl | but you said circ modifiers werent in? |
| # | 14:13:28 | dbs | in other news - pg_loader vs parallel_pg_loader works identically & well in trunk on Ubuntu Intrepid (with pgsql 8.3 no less) |
| # | 14:13:54 | phasefx_ | circ modifiers aren't normalized in 1.2.. they exist as a freetext string on the item table.. they're defined in a config file for the purpose of the item attribute editor |
| # | 14:15:20 | mrpeters-isl | hmm |
| # | 14:15:23 | mrpeters-isl | getting no results with that |
| # | 14:15:33 | mrpeters-isl | obviuously using Copy ID rather than Item Id (since i cant find that?) |
| # | 14:19:46 | phasefx_ | see jason/mrpeter item circmod count in Templates -> Test on demo.gapines.org |
| # | 14:33:37 | mrpeters-isl | not seeing a shared folder for test |
| # | 14:34:06 | phasefx_ | it's not shared |
| # | 14:34:15 | phasefx_ tries that |
| # | 14:34:20 | mrpeters-isl | what login is it tied to then |
| # | 14:35:30 | phasefx_ | admin/open-ils |
| # | 14:35:48 | mrpeters-isl | ah |
| # | 14:35:50 | mrpeters-isl | that helps |
| # | 14:35:52 | phasefx_ | should be shared now |
| # | 14:36:46 | mrpeters-isl | yeah, identical to what i had on production |
| # | 14:36:48 | mrpeters-isl | and i get no results |
| # | 14:36:59 | mrpeters-isl | only other thing is im filtering on shortname |
| # | 14:37:12 | phasefx_ | that report on demo does get results.. hrmm |
| # | 14:37:33 | mrpeters-isl | yeha, very strange |
| # | 14:37:35 | phasefx_ | item -> circ lib -> shortname? |
| # | 14:37:40 | mrpeters-isl | let me double check everything |
| # | 14:37:48 | phasefx_ | try using item -> circ lib -> id (in list) |
| # | 14:37:57 | mrpeters-isl | ok |
| # | 14:38:10 | phasefx_ | that'll get you a selection widget where you can pick the libraries, instead of having to enter a shortname to compare against |
| # | 14:38:19 | mrpeters-isl | right, thats what i usually do |
| # | 14:42:20 | mrpeters-isl | beautiful |
| # | 14:42:28 | mrpeters-isl | must have been the filter for the library |
| # | 14:49:41 | melissa_ has joined #OpenILS-Evergreen |
| # | 15:02:49 | mrpeters-isl | it would be sweet to somehow have a "shared" report repository for the entire community so different consortia could share templates with each other |
| # | 15:03:09 | mrpeters-isl | i think these would be helpful to others, along with many from the past and in the future...something to consider :) |
| # | 15:03:21 | dbs | mrpeters-isl: I have asked the same question on the list |
| # | 15:03:36 | mrpeters-isl | yeah, i think its something everyone wants just a matter of time/priority |
| # | 15:03:59 | mrpeters-isl | would be sweet to just download a "definition" file that EI would load and would attach it your staff client user id for you to report with |
| # | 15:07:41 | jeff_ | it would be useful to just have an easy way to import/export templates :) |
| # | 15:07:50 | mrpeters-isl | or better yet, these are just sql queries....maybe if there were a way to view the SQL string (if thats the right term) and share that in plain text, then allow the user to paste it in or modify as needed to run a report based on that SQL string |
| # | 15:08:44 | mrpeters-isl | maybe jason can shed some light on if that is actually how this works....but i assume these templates are just a graphical way of generating a string to tell the SQL database what information you want to view |
| # | 15:09:46 | phasefx_ | I'm not really sure how the templates are implemented, but I've been wanting an import/export mechanism for them too :) |
| # | 15:10:31 | mrpeters-isl | i bet that a "create template from SQL" option would do the trick |
| # | 15:10:41 | mrpeters-isl | then you could paste in the string, and run the report |
| # | 15:10:58 | mrpeters-isl | that might be a great short term solution, instead of coding an import/export mechanism which might be more in depth |
| # | 15:12:07 | mrpeters-isl | Koha, does something similar: SELECT biblioitems.marcxml FROM items LEFT JOIN biblioitems on (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio on (biblioitems.biblionumber=biblio.biblionumber) WHERE items.itype='VIDEO' AND items.holdingbranch='MADISONPL' AND items.homebranch='MADISONPL' |
| # | 15:12:22 | mib_a2ykyi has joined #openils-evergreen |
| # | 15:12:31 | mrpeters-isl | not something i have the brain to do, but its an idea :) |
| # | 15:14:25 | phasefx_ | I think all the logic is one-way.. sql ultimately gets generated, but you can't take sql and re-populate the template editor |
| # | 15:22:20 | mrpeters-isl | i see |
| # | 15:28:04 | phasefx_ | looking at the data field in reporter.template, it seems like the biggest obstacle is the reference to md5sum's (which I think map to dynamically created tables) |
| # | 15:28:39 | phasefx_ | so, for example, the profile/patron count template I created on demo starts off like this... {"version":2,"core_class":"au","select":[{"alias":"Group Name","column":{"colname":"name","transform":"Bare","transform_label":"Raw Data"},"path":"au-profile-pgt-name","relation":"36cbae28efe27cc2b3a89bcfe8043584"} |
| # | 15:29:01 | phasefx_ | but I don't think "36cbae28efe27cc2b3a89bcfe8043584" could be transported to another instance of EG and mean anything |
| # | 15:29:34 | miker_ | phasefx_: sure it can. look in the from:{...} chunk of that same field |
| # | 15:30:02 | miker_ | that md5sum is specific to that template, and references a named table in the from tree |
| # | 15:30:36 | phasefx_ peers |
| # | 15:31:51 | phasefx_ | so "alias":"blah" is where that value is defined? |
| # | 15:31:57 | miker_ | yeah |
| # | 15:32:01 | phasefx_ | gotcha |
| # | 15:32:17 | phasefx_ | so how easy is it to make an import/export template mechanism? :) |
| # | 15:33:17 | phasefx_ brings dbs, mrpeters-isl, and jeff_ into a huddle around miker_ |
| # | 15:33:20 | miker_ | depends on what you want that mechanism to actually do ... the variable bits between EG installations will be the owner and folder (and, of course, any custom IDL-described views or tables) |
| # | 15:33:22 | dbs | and what is its priority in comparison to testing and finishing off in-db circ or acq? |
| # | 15:33:39 | miker_ | dbs: low :) (IMO) |
| # | 15:33:54 | dbs votes for miker_ to focus on in-db circ or acq or serials stuff and let peons like me worry about template import / export |
| # | 15:34:10 | miker_ | ha! |
| # | 15:34:13 | phasefx_ | :D |
| # | 15:35:20 | miker_ | fine by me. I'd rather see a "show me the SQL for this template+report" function, and separately but related, a "add this SQL as a virtual source" function |
| # | 15:35:28 | miker_ | the former would be just good all around |
| # | 15:35:54 | phasefx_ | pretty printed |
| # | 15:35:55 | miker_ | the latter would be awesome for custom reporting |
| # | 15:36:18 | miker_ | phasefx_: it's more or less done, it just isn't wrapped up in a service |
| # | 15:37:25 | miker_ | see http://svn.open-ils.org/trac/ILS/browser/trunk/Open-ILS/examples/reporter-sql-builder-test.pl |
| # | 15:38:10 | miker_ | the tiny chunk of code at the bottom just needs to be wired up to a "fetch template and report" thing |
| # | 15:39:58 | mrpeters-isl | :) |
| # | 15:40:02 | mrpeters-isl | good to know |
| # | 15:41:02 | dbs | miker_++ |
| # | 15:41:03 | miker_ | it's something that I want to do SOOO BAD but I'm trying really hard not to let slip ahead of other stuff |
| # | 15:41:39 | dbs | miker_++ # keep up the good fight |
| # | 15:42:11 | miker_ | so, if someone were to pick it up and turn it into method inside open-ils.reporter, well, that would be immensely rad |
| # | 15:42:51 | mrpeters-isl | wish that didnt look like greek to me |
| # | 15:55:39 | mrpeters-isl | another tricky reporitng question |
| # | 15:55:49 | mrpeters-isl | i need a base filter filtering out all patrons less than 18 years of age |
| # | 15:57:21 | mrpeters-isl | what is the operator to get the option to do less than 1 xxxx ago |
| # | 15:57:34 | mrpeters-isl | 1 month, or 1 year, or 50 years...i know there is a widget for this |
| # | 15:59:53 | melissa_ has quit IRC |
| # | 15:59:56 | mrpeters-isl | so filter between "18 years and over", between "17 years 364 days and 13 years" and finally between "12 years 364 days and 1 day" |
| # | 16:02:01 | jeff_ has quit IRC |
| # | 16:08:12 | dbs | miker_: any objection to a unique key on (owning_lib, name) for asset.copy_location? |
| # | 16:08:43 | dbs | I've created duplicate locations for a given OU every time I step away from imports for > 1 week due to my own stupidity |
| # | 16:09:40 | miker_ | dbs: hrm... I thought that was there already |
| # | 16:10:10 | miker_ | but ... it seems not |
| # | 16:10:12 | dbs | miker_: maybe in your installs :) |
| # | 16:10:14 | miker_ | no objection |
| # | 16:10:20 | miker_ | no, it's not... |
| # | 16:10:20 | dbs | cool |
| # | 16:15:53 | jeff has joined #openils-evergreen |
| # | 16:45:13 | brendan_g has joined #openils-evergreen |
| # | 16:59:30 | wlayton_work has quit IRC |
| # | 17:09:00 | jeff_ has joined #openils-evergreen |
| # | 17:09:14 | jeff has quit IRC |
| # | 17:20:03 | brendan_g has quit IRC |
| # | 17:21:02 | jamesrf has joined #openils-evergreen |
| # | 17:21:33 | jamesrf | dbs++ |
| # | 17:22:16 | dbs | jamesrf: heh, stubbed your toe on that occasionally too? |
| # | 17:22:54 | jamesrf | eh? |
| # | 17:23:27 | jamesrf | i like the aggregator, but our RSS feed is broken so we can't add it |
| # | 17:24:06 | jamesrf | http://sitka.bclibraries.ca/news/RSS |
| # | 17:24:33 | jamesrf | i don't know what's going on and i don't have access to fix it, but i think it might be fixed one day |
| # | 17:24:43 | jamesrf | it seems to be displaying this backwars |
| # | 17:25:36 | dbs | jamesrf: yeah, I tried to add it and then realized it was b0rked :) |
| # | 17:26:14 | berick | where's the aggregator? |
| # | 17:26:18 | dbs | could add a filter to planet-venus to resort things, I guess, but that would be kinda ugly |
| # | 17:26:19 | berick pulls head from sand for .43 seconds |
| # | 17:26:29 | dbs | berick: there's a demo at planet-evergreen.coffeecode.net |
| # | 17:26:47 | berick | rad, thanks |
| # | 17:35:28 | mib_a2ykyi has quit IRC |
| # | 17:44:34 | kgs has quit IRC |
| # | 17:47:13 | dbs | just updated the import_demo package for 1.4 |
| # | 17:47:23 | EGUEST458 has joined #openils-evergreen |
| # | 17:51:04 | EGUEST458 has quit IRC |
| # | 18:00:07 | jamesrf has quit IRC |
| # | 18:05:55 | jamesrf has joined #openils-evergreen |
| # | 18:08:05 | jfournie has joined #openils-evergreen |
| # | 18:29:59 | jamesrf has quit IRC |
| # | 18:30:15 | jfournie has quit IRC |
| # | 18:35:03 | eby has quit IRC |
| # | 19:37:04 | djfiander has joined #OpenILS-Evergreen |
| # | 20:19:09 | dbs has quit IRC |
| # | 20:30:55 | brendan_g has joined #openils-evergreen |
| # | 20:39:15 | jamesrf has joined #openils-evergreen |
| # | 20:42:53 | brendan_g has quit IRC |
| # | 20:47:16 | mrpeters-isl has quit IRC |
| # | 20:47:46 | skmurphy has joined #openils-evergreen |
| # | 20:54:35 | eby has joined #OpenILS-Evergreen |
| # | 21:29:01 | wlayton has joined #OpenILS-Evergreen |
| # | 21:38:38 | djfiander | apparently I am to assume that a quarterly is identified by season: Spring, Summer, Autumn Winter. |
| # | 21:53:42 | djfiander has quit IRC |
| # | 22:01:07 | dbs has joined #openils-evergreen |
| # | 22:04:01 | jamesrf has quit IRC |
| # | 22:30:54 | eby has quit IRC |
| # | 22:38:00 | dbs is pleased to discover that virtualbox pretty happily loads vmware images |
| # | 22:54:07 | wlayton has quit IRC |
| # | 23:12:49 | dbs has quit IRC |
April 10-13