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