| # | Time | Nick | Message |
|---|
| # | 01:01:10 | dbs has quit IRC |
| # | 01:42:47 | r123__ has joined #openils-evergreen |
| # | 01:44:05 | twirlip_ has joined #openils-evergreen |
| # | 01:45:14 | twirlip has quit IRC |
| # | 01:59:43 | r123 has quit IRC |
| # | 02:17:44 | lisppaste6 | makekee pasted "untitled" at http://paste.lisp.org/display/87484 |
| # | 02:25:03 | lisppaste6 | makekee pasted "settings-tester" at http://paste.lisp.org/display/87485 |
| # | 04:03:56 | r123__ is now known as r123 |
| # | 04:29:22 | eguest309 has joined #openils-evergreen |
| # | 05:45:23 | eguest309_ has joined #openils-evergreen |
| # | 05:45:25 | eguest309 has quit IRC |
| # | 05:45:26 | eguest309_ is now known as eguest309 |
| # | 05:49:37 | natschil has joined #openils-evergreen |
| # | 06:34:18 | eguest309 has quit IRC |
| # | 07:21:32 | kgs has joined #openils-evergreen |
| # | 08:40:44 | mck9 has joined #openils-evergreen |
| # | 08:47:26 | mrpeters-isl | anoopa: i am happy to show you the code for Indiana's splash page |
| # | 08:47:51 | mrpeters-isl | it will show you how to launch most of the most common staff client functions |
| # | 08:51:41 | wlayton has joined #openils-evergreen |
| # | 08:53:02 | senator has joined #OpenILS-Evergreen |
| # | 09:00:46 | natschil has quit IRC |
| # | 09:04:53 | jenny has joined #OpenILS-Evergreen |
| # | 09:15:15 | natschil has joined #openils-evergreen |
| # | 09:26:43 | natschil has quit IRC |
| # | 09:49:48 | mrpeters-isl has quit IRC |
| # | 09:49:54 | mrpeters-isl has joined #openils-evergreen |
| # | 09:50:15 | wlayton has quit IRC |
| # | 09:50:19 | wlayton has joined #openils-evergreen |
| # | 10:02:53 | mrpeters-isl | if anyone has any tips/documentation for the usage of the import scripts (import_bibs.sh) in rel_1_6_0_0 for example, i would greatly apprecaite them! |
| # | 10:03:01 | natschil has joined #openils-evergreen |
| # | 10:35:41 | jenny1 has joined #OpenILS-Evergreen |
| # | 10:39:07 | meliss has joined #OpenILS-Evergreen |
| # | 10:53:08 | jenny has quit IRC |
| # | 10:57:43 | wlayton has quit IRC |
| # | 10:57:51 | wlayton has joined #openils-evergreen |
| # | 11:16:45 | anoopa | mrpeters-isl I used the import demo which has that script and am somewhat familiar |
| # | 11:19:39 | jenny has joined #OpenILS-Evergreen |
| # | 11:23:58 | mrpeters-isl | err, its actually importer.sh that i need help with |
| # | 11:25:17 | jenny1 has quit IRC |
| # | 11:31:14 | brendan_ga has quit IRC |
| # | 11:43:14 | anoopa | yea it seems to be calling the same scripts that import_bibs.sh calls...what's the issue? |
| # | 11:45:23 | weather15 has joined #openils-evergreen |
| # | 11:45:49 | weather15 | Hello |
| # | 11:47:12 | anoopa | Hello |
| # | 11:48:47 | weather15 | Hi |
| # | 11:49:37 | weather15 | I am wondering how evergreen compares with other popular library systems |
| # | 11:49:44 | mrpeters-isl | anoopa: for starters, Usage: importer.sh {Config File} {MARC file} {Output File} [{key file}] |
| # | 11:49:51 | mrpeters-isl | what is the config? what is the output? etc. |
| # | 11:51:06 | weather15 | I am thinking of using evergreen to power a small private collection and I am wondering if I am looking at the wrong solution |
| # | 11:51:52 | mrpeters-isl | weather15: evergreen is a great solution |
| # | 11:51:58 | mrpeters-isl | do you have any specific questions? |
| # | 11:52:08 | weather15 | I have used it before |
| # | 11:52:24 | weather15 | I am also wondering if an ISO install is available? |
| # | 11:52:41 | mrpeters-isl | weather15: no, not that I am aware of though im sure you or someone else could create one |
| # | 11:53:02 | mrpeters-isl | i assume you are meaning an ISO of the os with the evergreen software already installed, no? |
| # | 11:53:19 | weather15 | I could create one |
| # | 11:53:32 | anoopa | weather15 there is one available |
| # | 11:53:48 | weather15 | where could I find this? |
| # | 11:53:52 | anoopa | mrpeters-isl I think the config is for the evergreen db access info |
| # | 11:53:59 | mrpeters-isl | anoopa: interesting, i hadnt seen one |
| # | 11:54:14 | anoopa | mrpeters-isl I'll check and make sure hold on |
| # | 11:54:24 | weather15 | okay |
| # | 11:54:27 | mrpeters-isl | anoopa no rush...help out weather15 |
| # | 11:54:49 | anoopa | weather15 > http://www.open-ils.org/dokuwiki/doku.php?id=virtual:virtualbox:lenny |
| # | 11:55:30 | weather15 | could use it but I'm looking for something that is not dependant of an os already being installed |
| # | 11:56:26 | mrpeters-isl | weather15: yeah, though im not sure what you would be acheiving by having an "ISO" of evergreen |
| # | 11:56:39 | mrpeters-isl | it still has to have a host OS (usually Debian or Ubuntu) |
| # | 11:57:06 | mrpeters-isl | so im sure you could create a custom ISO of one of those distro's with Evergreen configured, but I am not sure it would be much of a shortcut |
| # | 11:57:14 | anoopa | weather15 evergreen might be overkill for your needs |
| # | 11:58:03 | brendan_ga has joined #OpenILS-Evergreen |
| # | 11:58:06 | mrpeters-isl | weather15: perhaps you could look into a hosted solution? there are some out there who will provide this service, of course at a cost |
| # | 11:58:30 | mrpeters-isl | this would allow you to simply run the staff client on your local machines while all of the evergreen "inner workings" would be hosted elsewhere |
| # | 11:59:32 | weather15 | I happen to like to have more than I need for the future |
| # | 12:00:06 | weather15 | Plus I like hosting things my-self so if issues arrise such as internet down time I can still access the server on the local network |
| # | 12:00:23 | weather15 | Also I always like to use OSS |
| # | 12:02:08 | jeff | in that case, evergreen might be just enough overkill for you! ;-) |
| # | 12:02:45 | mrpeters-isl | indeed |
| # | 12:03:04 | mrpeters-isl | i think its the right solution |
| # | 12:03:33 | mrpeters-isl | get a box up and running with the Evergreen Software and then perhaps image that install somehow and backup to your choice of media so you always have a "fresh install" |
| # | 12:03:46 | mrpeters-isl | we're all here to assist with the installation of the software |
| # | 12:09:36 | anoopa | mrpeters-isl weather15 yea the image has Evergreen 14.0.4 and fake data already thanks to dbs |
| # | 12:10:19 | mrpeters-isl | yes, but its not an "ISO" |
| # | 12:10:28 | mrpeters-isl | still requires a host OS to be installed + virtualbox |
| # | 12:10:47 | mrpeters-isl | i think weather15 was simply looking for an image he could "install" which would include OS and Evergreen and then be done with it |
| # | 12:10:51 | mrpeters-isl | but i will allow him to clarify |
| # | 12:10:57 | anoopa | aaa |
| # | 12:11:08 | weather15 | yes that is correct |
| # | 12:11:23 | weather15 | Anyhow I would not mind trying to make one for the community |
| # | 12:11:26 | anoopa | I get it...I should see if there is some way I can save that image as an iso hold on |
| # | 12:11:38 | anoopa | good you do it : ) |
| # | 12:15:14 | miker_ | @later tell dbs http://acq.open-ils.org/opac/en-US/skin/default/xml/rdetail.xml?r=1139 in IE |
| # | 12:15:14 | pinesol | miker_: The operation succeeded. |
| # | 12:15:28 | miker_ | @later tell dbs also, I hate IE |
| # | 12:15:28 | pinesol | miker_: The operation succeeded. |
| # | 12:18:48 | mrpeters-isl | weather15: http://wiki.linuxquestions.org/wiki/Live_CD_distributions#Create_your_own_Debian_Live_CD |
| # | 12:19:00 | mrpeters-isl | might be able to create a live cd with one of the virtualbox images |
| # | 12:19:23 | mrpeters-isl | another - http://www.debuntu.org/how-to-customize-your-ubuntu-live-cd |
| # | 12:33:06 | weather15 has quit IRC |
| # | 12:33:58 | anoopa | miker_ if I may...what's the issue with that link and IE? |
| # | 12:45:48 | miker_ | anoopa: nothing now :) ... IE is just a huge pain to program around |
| # | 12:46:45 | miker_ | but now I see that a version of the fix is already in svn (but more IE specific than what I did) |
| # | 12:48:27 | anoopa | miker_ argh hear that. Of course if the closed source basterds support only IE we should say support for everything but IE...if only. |
| # | 12:50:18 | miker_ | heh |
| # | 12:50:48 | dbs has joined #openils-evergreen |
| # | 12:53:35 | gmcharlt | mrpeters-isl: re import.sh, it's simple (if not simple-minded) |
| # | 12:53:53 | gmcharlt | mrpeters-isl: it's purpose is purely to load MARC bib records, it doesn't handle copies |
| # | 12:54:27 | gmcharlt | mrpeters-isl: the config parameter is just the path to opensrf.xml |
| # | 12:54:46 | gmcharlt | MARC file is just a file in MARC format |
| # | 12:55:28 | gmcharlt | the output file parameter is a misnomer - the script doesn't actually have any output per se except for log messages printed to screen |
| # | 12:57:05 | anoopa | gmcharlt are you sure the config is not for db info...that's what I thought it was |
| # | 12:57:07 | dbs | miker_: hate for IE is the glue that holds the Web universe together |
| # | 12:57:50 | dbs is watching his IE8 instance lock up as it attempts to load the concat version of that same record for comparison |
| # | 12:58:22 | gmcharlt | anoopa: opensrf_core.xml, actually is want it wants, not openils.xml |
| # | 12:58:47 | anoopa | hmm I'm comparing import_bibs.sh from import_demo and importer.sh from /src/extras |
| # | 12:59:10 | gmcharlt | yeah, importer.sh seems a bit out of date |
| # | 12:59:46 | anoopa | yea gmcharlt I was going to tell mrpeters-isl that he should not use importer.sh but look at the import demo download and redo some things differently |
| # | 13:00:10 | gmcharlt | the keys parameter, which gets passed to marc2bre.pl, is now deprecated according to marc2bre.pl, for example, in favor of tcn_dumpfile |
| # | 13:00:18 | anoopa | we can still use regular MARC instead of MARC-XML as suggested in import_bib |
| # | 13:01:05 | gmcharlt | right, marc2bre.pl will accept either MARC or MARCXML |
| # | 13:02:15 | dbs | just depends on which toolchain you prefer to convert from MARC to MARCXML - MARC::File::XML or yaz-marcdump :) |
| # | 13:02:42 | anoopa | now tcn_dumpfile is new to me is that where we do mappings for MARC? |
| # | 13:03:00 | gmcharlt | dbs: often the answer is both, depending on exactly how the incoming MARC blobs are broken |
| # | 13:03:18 | dbs | aah, http://laurentian.concat.ca/opac/en-CA/skin/lul/xml/rdetail.xml?r=345631 is the comparison record - looks like miker_ improved the spacing of concatenated fields in IE |
| # | 13:03:20 | miker_ | dbs: btw, just ingore the @later ... different issue |
| # | 13:03:36 | miker_ | and, yes, spacing is improved for title |
| # | 13:03:38 | dbs | gmcharlt++ |
| # | 13:03:43 | dbs | miker_++ |
| # | 13:04:23 | jeff | oh, and 0.91 (and 0.92) are out! |
| # | 13:04:28 | jeff | gmcharlt++ |
| # | 13:04:30 | jeff | miker_++ |
| # | 13:04:39 | jeff | (for that stray space being killed) |
| # | 13:05:08 | anoopa | since the super-devs are here a quick question...I want to open up our demo setup's config (I asked this yesterday) via our svn |
| # | 13:05:25 | miker_ | dbs: do you have a located uri example record? |
| # | 13:05:35 | dbs | miker_: will grab one for you |
| # | 13:06:48 | anoopa | I suspect opensrf_core.xml and live-db-setup.pl as the only files that hold sensitive data...I mean in /openils/conf and /openils/var/ (I am excluding run log lock folders in var) |
| # | 13:07:09 | gmcharlt | anoopa: tcn_dumpfile = outputs all TCNs assigned and used during the marc2bre.pl; if you are running multiple files through separate marc2bre.pl runs, you'd use the TCN file dumped by the previous run as the value for the --used-tcn-file parameter |
| # | 13:07:32 | gmcharlt | doing that avoids TCN collisions when it comes time to load the records into the database |
| # | 13:07:40 | dbs | anoopa: opensrf.xml contains database credentials |
| # | 13:07:42 | anoopa | ah |
| # | 13:07:57 | anoopa | dbs does it...hmm |
| # | 13:08:02 | atz | why is DoB "hidden" when I select a patron from patron search.... but displayed in the list of "hits" right next to the "hidden" subframe? |
| # | 13:08:22 | anoopa | ah yes it does...how did I miss that |
| # | 13:08:49 | jenny1 has joined #OpenILS-Evergreen |
| # | 13:09:34 | anoopa | ok so I'll use the example files for those 3 and am going to open up the rest...oh and what about the bootstrap files as far as I can tell they are safe to be visible to all...right? |
| # | 13:09:49 | phasefx_ | atz: search columns are configurable. Really need to tie that "hidden" thing to an org setting so it too is more easily configurable |
| # | 13:11:00 | phasefx_ | and then tie the default column visibility for the list to the same org setting |
| # | 13:11:48 | atz | phasefx: yeah, the current situation is not coherrent. |
| # | 13:12:11 | phasefx_ | atz: you can tell we hang around librarians too much when we use the socratic method of pointing such things out :) |
| # | 13:12:38 | atz | v. true |
| # | 13:13:27 | phasefx_ | atz: so in short, the <hidden> thing was a proof of concept for a library that should only be in trunk currently, and hasn't been scrutinized for sanity until you just did it :) |
| # | 13:14:23 | atz | i was afraid of that. those type of permission-sensitive tweaks really need to have intentional architecture behind them, and not just one off toggles somewhere. |
| # | 13:14:24 | phasefx_ | bug it and I'll fix it; atz++ |
| # | 13:14:29 | atz | k |
| # | 13:15:27 | phasefx_ | and it's not a true <hidden>, more of a display speedbump for prying eyes |
| # | 13:15:39 | phasefx_ | click on it to reveal dob, etc. |
| # | 13:16:45 | atz | phasefx: it's just flat "<Hidden>" for me |
| # | 13:17:00 | atz | no mouseover, or link |
| # | 13:17:01 | phasefx_ | ughers |
| # | 13:17:34 | atz | text isn't selectable either... which is annoying |
| # | 13:18:03 | phasefx_ | it's missing a class name, click_link |
| # | 13:18:09 | dbs | miker_: bah, sorry, try http://comet.cs.uoguelph.ca/opac/en-CA/skin/lul/xml/rdetail.xml?r=2032831 in IE vs. FF |
| # | 13:19:35 | dbs | miker_: ugh, let me mod the asset.uri entry for that |
| # | 13:20:24 | miker_ | thanks |
| # | 13:20:43 | miker_ | hey ... I got a fix |
| # | 13:20:45 | miker_ | I think |
| # | 13:20:53 | miker_ | in IE8, anyway |
| # | 13:21:20 | miker_ | in /openils/var/web/opac/skin/default/xml/rdetail/rdetail_summary.xml, on line 129, in the query, remove the >s ... query='volumes volume uris uri' |
| # | 13:21:22 | phasefx_ | atz: http://svn.open-ils.org/trac/ILS/changeset/14088 I think a lot of that we can refactor out into a common overlay (you were looking at the vertical patron summary; there's a variant for horizontal display) |
| # | 13:21:56 | dbs | miker_: there we go, replaced the text in asset.uri with "Foo foo bar" |
| # | 13:22:09 | dbs | miker_: okay, I can give that a shot |
| # | 13:22:17 | miker_ | http://acq.open-ils.org/opac/en-US/skin/default/xml/rdetail.xml?r=1544 in IE (has an alert, ignore) |
| # | 13:22:37 | dbs | yep, ignored the alert first time around :) |
| # | 13:24:43 | dbs | miker_: nice, that seems to shake it up! well done |
| # | 13:25:29 | miker_ | mike_-- # for assuming the true selectors are faithfully replicated on all browswers |
| # | 13:26:02 | dbs | ie-- # forever and always, amen |
| # | 13:26:04 | jenny has quit IRC |
| # | 13:27:24 | dbs goes to put baby to sleep |
| # | 13:38:25 | mrpeters-isl reads up |
| # | 13:38:46 | mrpeters-isl | so it sounds as if there is no publicly available method for importing bibs/holdings and generating the copies and copy locations? |
| # | 13:40:23 | atz | mrpeters-isl: there should be scripts on wiki or in Contrib repo |
| # | 13:40:26 | dbs | mrpeters-isl: http://coffeecode.net/archives/184-Unicorn-to-Evergreen-migration-rough-notes.html is my attempt to document one such process |
| # | 13:40:58 | mrpeters-isl | dbs: thanks! this looks much like what i need |
| # | 13:42:05 | dbs | (albeit out of date - e.g. missing the stuff for localized URIs, although the corresponding scripts are in the ILS-Contrib/conifer/trunk/tools directory IIRC) |
| # | 13:48:21 | pinesol has joined #openils-evergreen |
| # | 13:48:56 | phasefx_ | test |
| # | 13:49:27 | jenny has joined #OpenILS-Evergreen |
| # | 13:55:20 | phasefx_ is experimenting with pinesol, please bare with him :) |
| # | 13:56:03 | pinesol has joined #openils-evergreen |
| # | 13:57:21 | atz | hrm... get error viewing patron detail too |
| # | 13:57:22 | atz | FIXME: If you encounter this alert, please inform your IT/ILS helpdesk staff or your friendly Evergreen developers. |
| # | 13:57:22 | atz | Tue Sep 22 2009 13:56:15 GMT-0400 (Eastern Daylight Time) |
| # | 13:57:22 | atz | Error determining whether to disable checkout. |
| # | 13:57:41 | mrpeters-isl | dbs: did you somehow extract your holdings data from the MARC records to get this - i9780195402537|DESMARAIS|DESM-CIR|DESM-CIR|BOOKS|30007000000033 |1|0|20030612|0|0|FC 23 C65|LC| |
| # | 13:57:58 | mrpeters-isl | or did unicorn allow you to export delimited holdings data like this natively? |
| # | 13:58:38 | dbs | unicorn exports pipe-delimited holdings data |
| # | 13:58:59 | mrpeters-isl | i see |
| # | 13:59:08 | mrpeters-isl | sadly, most of the time i don't think we have that luxury :) |
| # | 13:59:08 | gmcharlt | mrpeters-isl: alas, not all ILSs make it easy to do that, so often you're stuck parsing item information embedded in fields in the bib record |
| # | 13:59:13 | dbs | the import_demo approach was written for sites that had holdings exported as part of the bibs |
| # | 13:59:20 | dbs | (albeit pretty poorly) |
| # | 13:59:45 | mrpeters-isl | gmcharlt: yeah, definetly not and I think thats how Equinox handles most of our data at this point |
| # | 14:00:03 | mrpeters-isl | im headed down for some training on this ni November, but trying to have some knowledge up front |
| # | 14:07:13 | jenny1 has quit IRC |
| # | 14:07:46 | agJohn has joined #openils-evergreen |
| # | 14:10:05 | diogenes_ | Does anyone have a matrix of feilds used across various ILS systems for holdings? |
| # | 14:10:36 | diogenes_ | If not maybe we could collectively compile a list for the community at large. |
| # | 14:11:02 | dbs | miker_: I can't help but look at the other "return dojox.data.dom.textContent(item)" and think that it should have a " || item.innerHTML" appended to it as well |
| # | 14:14:16 | gmcharlt | diogenes_++ |
| # | 14:17:31 | miker_ | dbs: which one? |
| # | 14:17:46 | miker_ | dbs: er, rather, what line number |
| # | 14:18:42 | miker_ | dbs: the default slot handler? |
| # | 14:19:34 | miker_ | dbs: yeah, the funny thing is, I think it's a problem with CDATA ... that, apparently, is not considered text content by IE |
| # | 14:19:52 | dbs | miker_: aww, man |
| # | 14:20:06 | anoopa | mrpeters-isl what ILS are you getting the data from? |
| # | 14:20:16 | anoopa | diogenes_ ++ |
| # | 14:20:57 | mrpeters-isl | anoopa - you name it, we'll be importing from it |
| # | 14:21:39 | dbs | miker_: yeah, line 62: http://svn.open-ils.org/trac/ILS/browser/trunk/Open-ILS/web/js/dojo/openils/BibTemplate.js#L62 |
| # | 14:22:48 | miker_ | yeah, that works in IE |
| # | 14:23:25 | anoopa | mrpeters-isl ah cool cool |
| # | 14:24:10 | dbs | miker_: okay, and of course all the uses in rdetail_summary work. You're getting quarter-brained dbs these days. |
| # | 14:24:18 | miker_ | I mean, I guess we could return a format for a bib that used <![CDATA[ ... ]]> to wrap text ... but we don't today |
| # | 14:45:27 | twirlip_ is now known as twirlip |
| # | 15:32:35 | mrpeters-isl | all - see this search - http://evergreen.lib.in.us/opac/en-US/skin/default/xml/rresult.xml?if=&it=&lf=&a=&la=&cl=&d=1&l=102&s=rel&sd=asc&adt=ml&tp=&t=author%3Amagazine&av=&rt=multi |
| # | 15:32:46 | jenny has quit IRC |
| # | 15:32:58 | mrpeters-isl | trying to clean up these entries (mark them deleted=t) but I cant seem to find any in database location to pull out those items |
| # | 15:33:25 | mrpeters-isl | tried |
| # | 15:33:25 | mrpeters-isl | SELECT ac.id, ac.circ_lib, rsr.title, rsr.author FROM asset.copy ac INNER JOIN reporter.simple_record rsr ON ac.id = rsr.id WHERE rsr.author IN ('magazine', 'Magazine', 'MAGAZINE') AND ac.circ_lib=103; |
| # | 15:33:44 | mrpeters-isl | but reporter.simple_record doesnt seem to have any entries where author matches those |
| # | 15:34:01 | mrpeters-isl | question is, what tables could i use to find the id's of those items who meet this criteria? |
| # | 15:35:28 | natschil has quit IRC |
| # | 15:36:02 | dbs | mrpeters-isl: metabib.full_rec? tag = 100, subfield = 'a', value = 'MAGAZINE' |
| # | 15:37:00 | anoopa | dbs real_full_rec in my db |
| # | 15:37:03 | mrpeters-isl | Did not find any relation named "metabib.full_rec.value". |
| # | 15:38:16 | dbs | anoopa: as of 1.4, metabib.full_rec should be a nicely indexed view on metabib.real_full_rec |
| # | 15:38:23 | mrpeters-isl | disgregard |
| # | 15:38:24 | mrpeters-isl | i got it |
| # | 15:39:04 | anoopa | dbs do'h I do have that need to remember views are better than tables |
| # | 15:39:19 | dbs | anoopa: sometimes :) |
| # | 15:39:20 | anoopa | mrpeters-isl how? |
| # | 15:40:02 | mrpeters-isl | select * from metabib.full_rec.value WHERE tag=100 AND subfield='a' AND value='MAGAZINE"; |
| # | 15:40:11 | mrpeters-isl | or something like that to suit your needs |
| # | 15:40:58 | anoopa | ah ok so what dbs suggested |
| # | 15:41:21 | mrpeters-isl | ERROR: cross-database references are not implemented: "metabib.full_rec.value" |
| # | 15:41:23 | mrpeters-isl | crap |
| # | 15:41:32 | mrpeters-isl | why would that be? |
| # | 15:42:08 | lisppaste6 | mrpeters-isl pasted "sql to fix "MAGAZINE"" at http://paste.lisp.org/display/87521 |
| # | 15:42:17 | mrpeters-isl | does my sql just suck? |
| # | 15:45:10 | senator | mrpeters-isl: select * from metabib.full_rec ... i think. instead of from metabib.full_rec.value |
| # | 15:47:03 | anoopa | hmm actually |
| # | 15:47:43 | mrpeters-isl | yeah, actually my sql is all f'd up |
| # | 15:48:22 | dbs | weird looking join condition :) |
| # | 15:48:27 | anoopa | I would say metabib.full_rec.value does work |
| # | 15:48:40 | anoopa | yea the join looks weird |
| # | 15:48:42 | mrpeters-isl | dbs: probably, im pretty new (modifying an example of yours actually! haha) |
| # | 15:49:21 | anoopa | mrpeters-isl I'll try running it here one sec |
| # | 15:49:36 | mrpeters-isl | this one works (but no results) |
| # | 15:49:41 | lisppaste6 | mrpeters-isl annotated #87521 "untitled" at http://paste.lisp.org/display/87521#1 |
| # | 15:50:03 | miker_ | mrpeters-isl: ac.id is not the same as mb.id |
| # | 15:50:13 | mrpeters-isl | miker_ yeah, i was beginning to wonder that |
| # | 15:50:32 | mrpeters-isl | how can i join those so that i can spot check the titles/authors before marking the copies in ac.id deleted? |
| # | 15:50:50 | anoopa | where is this ac.id? |
| # | 15:50:57 | dbs | mrpeters-isl: I think you'll need to follow mfr.record -> asset.call_number.record -> asset.copy.call_number |
| # | 15:51:00 | mrpeters-isl | asset.copy.id |
| # | 15:51:19 | anoopa | aah |
| # | 15:51:34 | miker_ | asset.copy.call_number -> asset.call_number.id, asset.call_number.record -> mfr.record |
| # | 15:51:58 | mrpeters-isl | whew |
| # | 15:52:04 | dbs | Like Blondie says, one way, or another |
| # | 15:52:57 | mrpeters-isl | asset.call_number.id = asset.copy id? |
| # | 15:53:02 | miker_ | no |
| # | 15:53:12 | mrpeters-isl | oh man |
| # | 15:53:16 | mrpeters-isl | im all confused now lol |
| # | 15:53:16 | miker_ | asset.copy.call_number = asset.call_number.id |
| # | 15:53:36 | miker_ | and asset.call_number.record = metabib.full_rec.record |
| # | 15:53:53 | jenny1 has joined #OpenILS-Evergreen |
| # | 15:53:53 | mrpeters-isl | ok |
| # | 15:54:07 | miker_ | and that's looking for an author of 'magazine' and friends |
| # | 15:54:25 | mrpeters-isl | yeah, thats a bit more clear |
| # | 15:54:48 | miker_ | sec, I'll annotate |
| # | 15:54:59 | mrpeters-isl | ok |
| # | 15:55:28 | meliss has quit IRC |
| # | 15:56:34 | mrpeters-isl | only thing i forsee is that none of those tables give a title |
| # | 15:56:38 | miker_ | mrpeters-isl: is that what you're trying to do, find bibs with an author ILIKE 'magazine'? |
| # | 15:56:47 | mrpeters-isl | unless dummy_title has a value |
| # | 15:56:55 | mrpeters-isl | miker_: yes, see http://evergreen.lib.in.us/opac/en-US/skin/default/xml/rresult.xml?if=&it=&lf=&a=&la=&cl=&d=1&l=102&s=rel&sd=asc&adt=ml&tp=&t=author%3Amagazine&av=&rt=multi |
| # | 15:57:11 | mrpeters-isl | i want to mark all of those records as deleted in asset.copy |
| # | 15:57:38 | mrpeters-isl | but i need to give it a visual once over to make sure we don't delete anything that may, for some reason actually have an author "magazine" |
| # | 15:57:42 | lisppaste6 | miker_ annotated #87521 "finding titles and authors" at http://paste.lisp.org/display/87521#2 |
| # | 15:58:52 | miker_ | well, I removed dummy_title and dummy_author, but you can add those back into the select list |
| # | 16:00:02 | mrpeters-isl | sure |
| # | 16:00:10 | mrpeters-isl | your's actually gives enough info though |
| # | 16:00:36 | [1]atz has joined #openils-evergreen |
| # | 16:03:20 | lisppaste6 | mrpeters-isl annotated #87521 "untitled" at http://paste.lisp.org/display/87521#3 |
| # | 16:03:34 | mrpeters-isl | miker_ that annotation look sane for updating those records? |
| # | 16:04:09 | miker_ | mrpeters-isl: I'd suggest using a subselect ... sec |
| # | 16:04:25 | mrpeters-isl | yeah, an example of that would be great :) |
| # | 16:06:52 | lisppaste6 | miker_ annotated #87521 "updating" at http://paste.lisp.org/display/87521#4 |
| # | 16:07:44 | mrpeters-isl | whew, these can get quite complicated but its very cool when they work! |
| # | 16:07:59 | mrpeters-isl | makes evergreen awesome for reporting too, since postgres can be used to get this sort of data |
| # | 16:08:05 | mrpeters-isl | and update it, of course |
| # | 16:08:08 | mrpeters-isl | thanks miker_! |
| # | 16:10:36 | miker_ | np |
| # | 16:14:44 | atz has quit IRC |
| # | 16:14:46 | [1]atz is now known as atz |
| # | 16:24:18 | wlayton has quit IRC |
| # | 16:30:55 | jenny has joined #OpenILS-Evergreen |
| # | 16:39:25 | diogenes_ has quit IRC |
| # | 16:47:30 | jenny1 has quit IRC |
| # | 17:28:42 | weather15 has joined #openils-evergreen |
| # | 17:28:58 | weather15 | Hello |
| # | 17:30:22 | weather15 | I have installed evergreen and am nowhaving problems loging into the staff client |
| # | 17:30:44 | lisppaste6 | weather15 pasted "Staff Client Error" at http://paste.lisp.org/display/87526 |
| # | 17:31:34 | weather15 | Any insights on what to do? |
| # | 17:31:35 | jenny has quit IRC |
| # | 17:33:57 | jenny has joined #OpenILS-Evergreen |
| # | 17:34:07 | lisppaste6 | weather15 pasted "Also Part Of The Error" at http://paste.lisp.org/display/87527 |
| # | 17:35:28 | weather15 | Hello |
| # | 17:42:38 | jenny has quit IRC |
| # | 17:50:27 | jamesrf_ has joined #openils-evergreen |
| # | 17:50:46 | jamesrf_ is now known as jamesrf |
| # | 17:53:43 | weather15 | Hello |
| # | 17:53:50 | jamesrf | hi |
| # | 17:54:51 | weather15 | I have installed evergreen and am nowhaving problems loging into the staff client |
| # | 17:55:08 | jamesrf | can you search the OPAC? |
| # | 17:55:08 | weather15 | <lisppaste6> weather15 pasted "Staff Client Error" at http://paste.lisp.org/display/87526 |
| # | 17:55:38 | weather15 | <lisppaste6> weather15 pasted "Also Part Of The Error" at http://paste.lisp.org/display/87527 |
| # | 17:56:09 | weather15 | I have no titles this is a fresh install but I can access http://www.mydomain.com and I get the opac |
| # | 17:56:29 | jamesrf | can you log in to the "My Account" part of the OPAC? |
| # | 17:57:30 | weather15 | yes I can |
| # | 17:59:58 | phasefx_ | that schema action does not exist is scary |
| # | 18:00:20 | phasefx_ | any errors when you built your database? |
| # | 18:01:01 | weather15 | nope |
| # | 18:01:01 | weather15 | would you recommend that I re-create the database if so how? |
| # | 18:01:05 | phasefx_ | in psql, does \d action.* produce any output? |
| # | 18:01:35 | weather15 | give me a minute |
| # | 18:02:36 | weather15 | nope no output |
| # | 18:03:37 | phasefx_ | weather15: yeah, something went wrong with your installation |
| # | 18:04:10 | phasefx_ | for wiping my database, I do something like this: |
| # | 18:04:21 | phasefx_ | perl Open-ILS/src/support-scripts/eg_db_config.pl --create-schema --user evergreen --password evergreen --hostname localhost --database evergreen > db_wipe.log && less db_wipe.log |
| # | 18:04:36 | phasefx_ | depending on how yours is configured, you may need to tweak those arguments |
| # | 18:04:55 | phasefx_ | errors from 000.english.pg82.fts-config.sql are expected |
| # | 18:04:55 | weather15 | hold on a minute |
| # | 18:05:16 | phasefx_ | but if ERROR exists for any other file in that log, then something is wrong |
| # | 18:06:17 | weather15 | what users should run this as root, opensrf, postgres ? |
| # | 18:06:57 | phasefx_ | I don't think it matters; I do root or opensrf |
| # | 18:09:04 | jamesrf has quit IRC |
| # | 18:09:34 | jamesrf has joined #openils-evergreen |
| # | 18:11:21 | weather15 | Why would the database be the issue though because the error is open-ils.circ.survey.retrieve.required |
| # | 18:11:50 | phasefx_ | open-ils.circ.survey.retrieve.required is looking for a table in the database that doesn't exist in your installation |
| # | 18:12:21 | phasefx_ | you're missing the entire action. schema, which holds things like circulations, hold requests, transits, etc. |
| # | 18:12:36 | phasefx_ doesn't know why you're missing such things though :( |
| # | 18:14:22 | weather15 | I re-created the database and the error still exists |
| # | 18:14:51 | phasefx_ | paste the contents of your db_wipe.log? |
| # | 18:15:22 | weather15 | where is this log liocated? |
| # | 18:15:52 | weather15 | *located |
| # | 18:16:10 | phasefx_ | in the example I pasted, I redirected output to a file like so, > db_wipe.log that would have went into the current working directory, wherever you ran the command |
| # | 18:19:24 | weather15 | okay give me a minute |
| # | 18:20:07 | kgs has quit IRC |
| # | 18:23:08 | lisppaste6 | weather15 pasted "Database Re-Create Log" at http://paste.lisp.org/display/87531 |
| # | 18:23:56 | phasefx_ | weather15: okay, I found what got you |
| # | 18:23:56 | phasefx_ | psql:012.schema.vandelay.sql:150: ERROR: language "plperlu" does not exist |
| # | 18:24:00 | phasefx_ | HINT: Use CREATE LANGUAGE to load the language into the database. |
| # | 18:24:21 | phasefx_ | there's a step in the installation instructions where you add plperlu and friends to the database |
| # | 18:24:28 | phasefx_ | recall any errors there? |
| # | 18:24:58 | weather15 | no I will try it again |
| # | 18:25:59 | weather15 | createlang: language installation failed: ERROR: could not load library "/usr/local/stow/pgsql/lib/plperl.so": /usr/local/stow/pgsql/lib/plperl.so: undefined symbol: boot_DynaLoader |
| # | 18:26:29 | weather15 | createlang plperlu evergreen |
| # | 18:26:42 | phasefx_ | ah, did you compile postgres from source or use a package? |
| # | 18:27:13 | weather15 | source |
| # | 18:27:43 | phasefx_ | this 8.2? |
| # | 18:27:43 | weather15 | Sorry my error I ran that from command line not logged into postgres |
| # | 18:27:55 | phasefx_ | ah |
| # | 18:27:55 | weather15 | I logged in to postgres and the commands ran fine yes it is 8.2 |
| # | 18:28:01 | phasefx_ | coool |
| # | 18:28:26 | phasefx_ | you'll want to redo step 4 with eg_db_config.pl |
| # | 18:28:26 | weather15 | now what? |
| # | 18:28:37 | phasefx_ | you're going from http://evergreen-ils.org/dokuwiki/doku.php?id=server:1.4.0:install, right? |
| # | 18:29:08 | weather15 | yup give me a minute |
| # | 18:29:20 | phasefx_ | or you can re-use the command I gave earlier that produced db_wipe.log |
| # | 18:29:43 | phasefx_ | after that, I think you're ready to go. Make sure everything opensrf is stopped, and then start it back up |
| # | 18:30:13 | weather15 | How can I delete that database all together? |
| # | 18:30:42 | phasefx_ | that I don't know |
| # | 18:31:01 | phasefx_ | the db_wipe thing will re-create all the schemas, which is a pretty good substitute |
| # | 18:31:32 | weather15 | I tried drop database evergreen and I get ERROR: database "evergreen" is being accessed by other users |
| # | 18:31:40 | phasefx_ | as user postgres, dropdb |
| # | 18:32:01 | phasefx_ | any opensrf processes running? or a psql shell left connected? |
| # | 18:33:01 | weather15 | okay now it worked |
| # | 18:34:32 | weather15 | following wiki instructions I get this error: createlang: language installation failed: ERROR: could not load library "/usr/local/stow/pgsql/lib/plperl.so": /usr/local/stow/pgsql/lib/plperl.so: undefined symbol: boot_DynaLoader |
| # | 18:35:32 | weather15 | now what do I do? |
| # | 18:35:48 | phasefx_ | that was as user postgres? |
| # | 18:36:47 | weather15 | yup |
| # | 18:38:23 | phasefx_ | now we're outside my realm of familiarity. I'd punt to the mailing list with your steps and current error |
| # | 18:39:24 | weather15 | This is strange the file /usr/local/stow/pgsql/lib/plperl.so exists |
| # | 18:40:44 | phasefx_ | do you have multiple postgres installations? |
| # | 18:40:58 | phasefx_ | the createlang for the wrong one may be getting sued |
| # | 18:41:29 | weather15 | I might I don't think so |
| # | 18:41:29 | weather15 | how can I check? |
| # | 18:43:48 | phasefx_ | try using the fullpath /usr/local/stow/pgsql/bin/createlang instead of a mere createlang |
| # | 18:47:18 | weather15 | nope |
| # | 18:51:42 | phasefx_ | yeah, I'm at a loss and have to bow out for a while. I'd try the list again |
| # | 18:51:47 | weather15 | Should I do another install? |
| # | 18:52:22 | weather15 has quit IRC |
| # | 18:54:17 | phasefx_ | @later tell weather15 nm /usr/local/stow/pgsql/lib/plperl.so | grep Dyna yielded U boot_DynaLoader |
| # | 18:54:17 | pinesol | phasefx_: The operation succeeded. |
| # | 18:56:15 | phasefx_ | @later tell weather15 more google digging.. I'd try this perl -MExtUtils::Embed -e 'print;' if that fails, you m to get ExtUtils::Embed from CPAN |
| # | 18:56:15 | pinesol | phasefx_: The operation succeeded. |
| # | 18:56:51 | Jwreid has joined #openils-evergreen |
| # | 18:57:10 | Jwreid | ++ |
| # | 18:58:27 | Jwreid has quit IRC |
| # | 19:12:03 | kgs has joined #openils-evergreen |
| # | 19:23:25 | jamesrf has quit IRC |
| # | 19:35:35 | jamesrf has joined #openils-evergreen |
| # | 20:02:48 | mck9 has left #openils-evergreen |
| # | 20:08:32 | jamesrf has quit IRC |
| # | 20:08:47 | mck9 has joined #openils-evergreen |
| # | 20:32:36 | kgs has quit IRC |
| # | 20:32:36 | greg-g has quit IRC |
| # | 20:32:36 | edbarrett has quit IRC |
| # | 20:32:36 | _dkyle_ has quit IRC |
| # | 20:32:36 | sylvar has quit IRC |
| # | 20:32:36 | bradl has quit IRC |
| # | 20:32:36 | berick has quit IRC |
| # | 20:32:36 | _bott_ has quit IRC |
| # | 20:32:36 | kbeswick has quit IRC |
| # | 20:32:36 | phasefx_ has quit IRC |
| # | 20:32:36 | dbs has quit IRC |
| # | 20:32:36 | brendan_ga has quit IRC |
| # | 20:32:36 | anoopa has quit IRC |
| # | 20:33:30 | kgs has joined #openils-evergreen |
| # | 20:33:30 | dbs has joined #openils-evergreen |
| # | 20:33:30 | brendan_ga has joined #openils-evergreen |
| # | 20:33:30 | greg-g has joined #openils-evergreen |
| # | 20:33:30 | anoopa has joined #openils-evergreen |
| # | 20:33:30 | edbarrett has joined #openils-evergreen |
| # | 20:33:30 | sylvar has joined #openils-evergreen |
| # | 20:33:30 | _dkyle_ has joined #openils-evergreen |
| # | 20:33:30 | bradl has joined #openils-evergreen |
| # | 20:33:30 | berick has joined #openils-evergreen |
| # | 20:33:30 | kbeswick has joined #openils-evergreen |
| # | 20:33:30 | phasefx_ has joined #openils-evergreen |
| # | 20:33:30 | _bott_ has joined #openils-evergreen |
| # | 21:01:17 | brendan_ga has quit IRC |
| # | 21:27:56 | CinncinatiILS has joined #openils-evergreen |
| # | 21:28:41 | brendan_ga has joined #OpenILS-Evergreen |
| # | 21:47:59 | CinncinatiILS | brendan_ga++ |
| # | 21:48:49 | CinncinatiILS has quit IRC |
| # | 22:21:40 | agJohn has quit IRC |
| # | 23:50:02 | jeff | phasefx++ |
| # | 23:50:17 | jeff | (for fixing the duplicate rows in holds lists bug) |
| # | 23:50:51 | phasefx_ | hrmm, do I need to backport that? is oils persist in 1.6? *looks* |
| # | 23:51:17 | jeff | maybe i'm thinking of the wrong bug. |
| # | 23:51:44 | phasefx_ | no, just trunk |
| # | 23:51:47 | jeff | 1.2 and 1.4 have issues with holds (i think) being doubled when you do some things. |
| # | 23:51:57 | phasefx_ | ah |
| # | 23:51:59 | jeff | my memory is vague. maybe it was only 1.2, also. |
| # | 23:52:28 | jeff | i ran into it a lot the first two weeks after our go live, and i don't remember if it was reported or "known" |
| # | 23:53:03 | phasefx_ | I don't remember it |
| # | 23:53:50 | jeff | i'll see if i can duplicate |
| # | 23:54:00 | phasefx_ | cool deal |
April 10-13