loc.gov← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:27 | cfouts left #koha | |
| 00:28 | cfouts joined #koha | |
| 00:31 | brendan left #koha | |
| 00:41 | rich-away is now known as richard | |
| 01:03 | cfouts left #koha | |
| 01:12 | brendan joined #koha | |
| 01:14 | brendan left #koha | |
| 01:52 | wajasu joined #koha | |
| 01:55 | wajasu left #koha | |
| 02:50 | brendan joined #koha | |
| 02:50 | brendan | @wunder 93117 |
| 02:51 | munin | brendan: The current temperature in Eastern Goleta Valley, Santa Barbara, California is 17.8�C (7:52 PM PDT on July 21, 2010). Conditions: Clear. Humidity: 73%. Dew Point: 13.0�C. Pressure: 29.83 in 1010.0 hPa (Falling). |
| 03:19 | Amit joined #koha | |
| 03:19 | Amit | heya chris, brendan |
| 03:19 | good morning #koha | |
| 03:19 | brendan | heya Amit |
| 03:28 | brendan left #koha | |
| 05:05 | darling left #koha | |
| 05:06 | richard left #koha | |
| 06:17 | CGI415 left #koha | |
| 06:17 | tani joined #koha | |
| 06:30 | magnus joined #koha | |
| 06:38 | alex_a joined #koha | |
| 06:48 | tani | how to install C4/Context |
| 06:48 | becuse i run rebuilt_zebra | |
| 06:49 | and it says cant locate c4/context.pm | |
| 06:53 | magnus | tani: did you "export PERL5LIB" before running rebuild_zebra? |
| 06:54 | tani | no |
| 06:54 | a have no records | |
| 07:02 | francharb joined #koha | |
| 07:11 | magnus | tani: you need to set two environment variables before you run rebuild zebra. on a standard install they would be "export KOHA_CONF=/usr/share/koha/etc/koha-conf.xml" and "export PERL5LIB=/usr/share/koha/lib" (depending on where you chose to put your files during installation) |
| 07:11 | alan left #koha | |
| 07:12 | * magnus | notices that INSTALL.debian doesn't actually say anything about exporting PERL5LIB. huh? |
| 07:13 | chris | cos the installer itself does |
| 07:14 | and there are a lot of ways to do it, i dont set PERL5LIB, i use the -I switch | |
| 07:16 | (the last thing the Makefile.PL does is tell you to set the ENV variables, and gives you the correct paths) | |
| 07:18 | magnus | ah, thanks chris, i knew i had seen it *somewhere*... |
| 07:19 | kf joined #koha | |
| 07:19 | chris | hi kf |
| 07:19 | magnus | guten morgen kf |
| 07:19 | kf | morning chris |
| 07:19 | morning magnus and all #koha | |
| 07:29 | irma joined #koha | |
| 07:34 | chris | hi irma |
| 07:36 | irma | Hi |
| 07:37 | I thought you might be giving your boys their dinner | |
| 07:37 | chris | they are both asleep |
| 07:37 | (7.40pm) | |
| 07:37 | they are usually asleep by 7.15ish | |
| 07:37 | irma | what time is the going to bed timne? |
| 07:37 | chris | 7 |
| 07:37 | irma | I see |
| 07:38 | bring memories back :-) | |
| 07:38 | chris | :) |
| 07:39 | they had a late night last night so were tired | |
| 07:39 | irma | This page still links Koha to koha.org http://www.loc.gov/marc/marcsysvend.html |
| 07:39 | chris | do you want to drop them an email? |
| 07:39 | irma | I was looking up an email address to ask for an update to koha-community.org |
| 07:39 | could I or does it have to be you or Galen? | |
| 07:40 | or someone else? I am happy to do it ... | |
| 07:40 | chris | it can be anyone |
| 07:40 | there's no boss of koha :) | |
| 07:40 | irma | OK. I shall and report back. |
| 07:40 | Also | |
| 07:40 | chris | thanks |
| 07:41 | irma | the default MARC 21 framework marc structure has not been updated sine 2008 |
| 07:41 | chris | this is true, does it need updates? |
| 07:41 | irma | and has a number of missing fields and subfields |
| 07:42 | and a number of now obselete fields/subfields | |
| 07:42 | chris | right |
| 07:42 | for the obsolete we would need to just mark them as such | |
| 07:42 | for existing koha anywya | |
| 07:43 | but for new installs they could be gone, and the missing ones could be added for both | |
| 07:43 | irma | tru or would a new uipload be more appropriate |
| 07:44 | there are over 3400 fields it's better to reload an update from the source | |
| 07:44 | LOC | |
| 07:44 | chris | it has to be upgradable for existing koha |
| 07:45 | irma | yes |
| 07:45 | chris | and there is a serious amount of work making the framework you get from LOC, in the sql commands suitable for loading into koha |
| 07:45 | irma | woudl it need two default frameworks (the current uploded 2008) and the new one (uploaded 2010) ? |
| 07:46 | chris | thats one possibility |
| 07:46 | irma | Could I work on this after KohaCon during the hack fest? |
| 07:46 | chris | you sure could |
| 07:47 | kf might want to help too | |
| 07:47 | * chris | volunteers people randomly |
| 07:47 | chris | :) |
| 07:47 | laurence joined #koha | |
| 07:47 | chris | she has done quite a bit of marc21 koha work |
| 07:47 | irma | OK. My arm was already half bent ;-) |
| 07:48 | KF? | |
| 07:48 | chris | she probably ran away to escape me volunteering her for work :) |
| 07:48 | irma | I know K. Fisher |
| 07:49 | Hello kf ... I wont bite | |
| 07:49 | kf are you coming to Wellington? | |
| 07:50 | Chris ... pls put this down as a task to do and I shall prepare for it | |
| 07:50 | magnus | irma: she's in on the road trip, so i think so... ;-) |
| 07:51 | chris | cool |
| 07:51 | irma | great |
| 07:51 | I will be able to spruce up my German... | |
| 07:53 | off to type that email to LOC | |
| 07:53 | chris | :) |
| 07:53 | magnus | go irma! |
| 07:55 | irma | I just reread the text and it might be good to update that at the same time |
| 07:55 | http://www.loc.gov/marc/marcsysvend.html | |
| 07:55 | what do you think? | |
| 07:55 | chris | yep |
| 07:56 | magnus | isn't it kind of strange that that page is a mix of vendors and systems? |
| 07:56 | chris | well traditonally it was the same thing |
| 07:57 | in library world anyway | |
| 07:57 | but yeah doesnt really work | |
| 07:57 | irma | off looking if Ferraro's details are still there ...yeeks ... |
| 07:58 | chris | under liblime? |
| 07:59 | irma | info has been updated |
| 08:00 | ok ...off looking for LOC's email address | |
| 08:00 | chris | :) |
| 08:01 | magnus | hm, make that lots of systems and a couple of vendors. even stranger. makes the librarian in me slightly uncomfortable... ;-) |
| 08:02 | * magnus | thinks crontab.example would look better with standard file paths |
| 08:03 | kf | sorry, was on the phone |
| 08:03 | chris | yeah good idea, wanna send a patch? :) |
| 08:03 | kf | reading back now |
| 08:05 | magnus | chris: i might just do that |
| 08:05 | kf: we were talking about you! ;-) | |
| 08:05 | kf | irma: will be at kohacon and glad to have a project to work on - I think thd wanted to some updates |
| 08:05 | the mab things | |
| 08:06 | irma: I already did some updates to add $w subfields- those patches are waiting for 3.4, but a general overhaul would be a good thing | |
| 08:06 | is she still here? :) | |
| 08:06 | magnus: long phone call from koha library | |
| 08:06 | irma | yep. I am back with the contact address for LOC |
| 08:06 | ndmsoloc.gov |
|
| 08:07 | to update the Koha link to koha-community.org | |
| 08:07 | kf | hi :) |
| 08:08 | irma | hi kf ... |
| 08:08 | kf | irma: I talked about this to thd (a long time ago) but neither of us had time to add all the missing fields. I think a lot of new fields are linked to features we use here in Germany |
| 08:08 | irma | Das dachte ich auch |
| 08:08 | kf | and perhaps we could hide some of the deprecated fields too |
| 08:08 | oh | |
| 08:08 | Deutsch :) | |
| 08:09 | irma | Ich habe auch nicht sher viel Zeit aber nach KohaCon bestimt ya |
| 08:09 | sehr | |
| 08:09 | kf | ich fliege am wahrscheinlich am montag zurück |
| 08:09 | irma | Mine Mama kommt von Koln |
| 08:09 | kf | :) |
| 08:10 | irma | Wir auch (nach Sydney) unsere Heimstadt :-) |
| 08:11 | kf | ich wohne in konstanz, am bodensee |
| 08:11 | irma | Sehr schone Gegend! |
| 08:12 | Ich freue mich dich kennen zu lernen ... Tchuss bis bald! | |
| 08:12 | Tchuss? correct spelling? | |
| 08:13 | kf | Tschüss :) |
| 08:13 | und ich freue mich auch :) | |
| 08:13 | magnus | wir allen freuen uns! |
| 08:14 | irma | Wir freuen us alle ... |
| 08:14 | Wir freuen us zusammen ... | |
| 08:15 | Tschuss kf und magnus! | |
| 08:16 | Chris about the Koha text | |
| 08:16 | magnus | Tschüss irma! |
| 08:16 | irma | Do you have any suggestions |
| 08:16 | chris | hmm |
| 08:17 | http://koha-community.org/about/ | |
| 08:17 | indradg left #koha | |
| 08:17 | chris | is pretty similair i think |
| 08:17 | i hate that enterprise class bit tho | |
| 08:17 | in my experience of 16 years of software development | |
| 08:18 | irma | I think adding http://wiki.koha-community.org/wiki/Kohausers too? |
| 08:18 | chris | enterprise = stupidly expensive and broken |
| 08:18 | but it might have better connotations for others :) | |
| 08:19 | irma: we'd need to fix that page up first i think (the kohausers one) | |
| 08:19 | irma | yep a bit more left to do there |
| 08:22 | To move forwards, what about using this text : http://koha-community.org/about/ | |
| 08:23 | and I will send a second email when this page is fixed http://wiki.koha-community.org/wiki/Kohausers | |
| 08:23 | ? OK? | |
| 08:26 | chris | sounds good |
| 08:43 | magnus | sorry chris, any thoughts on line 79 of http://git.koha-community.org/[…]b.example;hb=HEAD etc/logrotate.conf doesn't seem to exist? |
| 08:44 | chris | hmm yeah probably never got committed |
| 08:45 | have you used logrotate before? | |
| 08:46 | magnus | nope |
| 08:47 | seems strange to have an example with non-existing files... | |
| 08:47 | chris | its not the only strange thing liblime did |
| 08:47 | magnus | :-) |
| 08:47 | tani | hello, i can"t find my records |
| 08:47 | chris | if you look at /etc/logrotate.conf |
| 08:48 | it would look something like that, ill have a look at doing one if i get a chance tomorrow | |
| 08:49 | tani | if i add a new book record then it doesnt show to staff client and opac |
| 08:49 | magnus | chris: that would be cool! should i hold off on submitting the patch for crontab.example until you have had a go at it? |
| 08:49 | tani | when i search for that |
| 08:50 | chris | magnus: well fixing the others paths is a good start, and i can do a follow up patch |
| 08:50 | magnus | chris ok, so i'll just leave line 79 as it is? |
| 08:50 | chris | yep |
| 08:51 | magnus | chris: cool! |
| 08:51 | chris | tani: do you have a cronjob set up to run rebuild_zebra.pl ? |
| 08:52 | tani | no a have no cronjob |
| 08:52 | but i try rebuilt zebra | |
| 08:52 | chris | then the indexes wont be getting updated |
| 08:52 | tani | and it said c4/context |
| 08:52 | cant locate | |
| 08:53 | chris | yes you need to set your PERL5LIB like people have been saying |
| 08:53 | tani | koha version 3.00.06 |
| 08:54 | ubuntu 10.04 | |
| 08:54 | irma | chris email to LOC is on it's way cc'ed to you |
| 08:54 | magnus | irma++ |
| 08:54 | chris | cool |
| 08:56 | irma | a teeny weeny help but still it feels good to have asked for the update |
| 08:56 | chris | :) |
| 08:57 | irma | thinking about something for dinner now ... ciao all |
| 08:57 | irma left #koha | |
| 09:10 | davi joined #koha | |
| 09:44 | kf | does someone know if this is still up-to-date? http://www.slideshare.net/ohio[…]-integration-ldap |
| 09:45 | I have a question about LDAP support and we don't use it, so no experience | |
| 09:45 | tani left #koha | |
| 09:57 | chris | probably pretty close, that was done by joe atz, who wrote most of the sip stuff |
| 10:00 | kf | thx chris |
| 10:00 | chris+ | |
| 10:00 | chris++ | |
| 10:12 | alex_a left #koha | |
| 10:15 | kf | chris++ for great koha knowledge :) |
| 10:16 | chris | heh thanks |
| 10:37 | francharb left #koha | |
| 10:37 | francharb joined #koha | |
| 10:37 | wasabi | chris: http://translate.koha-community.org points to koha.org |
| 10:37 | i just noticed... | |
| 10:37 | "Visit Koha official web site. Start translating Koha into your language." | |
| 10:38 | Amit | heya mason |
| 10:38 | wasabi | hi amit |
| 10:38 | how is india? :) | |
| 10:39 | its raining here in wellington, nz :/ | |
| 10:39 | alex_a joined #koha | |
| 10:39 | wasabi | @wunder nz |
| 10:39 | munin | wasabi: Error: No such location could be found. |
| 10:39 | wasabi | @wunder new zealand |
| 10:39 | munin | wasabi: Error: No such location could be found. |
| 10:41 | kf | @wunder wellington |
| 10:41 | munin | kf: Error: No such location could be found. |
| 10:41 | kf | @wunder Konstanz |
| 10:41 | munin | kf: The current temperature in Taegerwilen, Taegerwilen, Germany is 25.6�C (12:44 PM CEST on July 22, 2010). Conditions: Partly Cloudy. Humidity: 63%. Dew Point: 18.0�C. Pressure: 29.88 in 1011.7 hPa (Falling). |
| 10:41 | kf | hm |
| 10:41 | wasabi | @wunder wellington, new zealand |
| 10:41 | munin | wasabi: The current temperature in Wellington, New Zealand is 10.0�C (10:00 PM NZST on July 22, 2010). Conditions: Light Rain. Humidity: 94%. Dew Point: 9.0�C. Windchill: 7.0�C. Pressure: 29.86 in 1011 hPa (Steady). |
| 10:44 | magnus | @wunder bodo, norway |
| 10:44 | munin | magnus: The current temperature in Bodo, Norway is 10.0�C (12:20 PM CEST on July 22, 2010). Conditions: Light Rain. Humidity: 87%. Dew Point: 8.0�C. Windchill: 8.0�C. Pressure: 29.53 in 1000 hPa (Steady). |
| 10:45 | magnus | wow, that's quite similar between wllington and bodø! |
| 10:45 | wasabi | yeah, it is |
| 10:48 | wizzyrea: about? | |
| 10:50 | chris | wasabi: i dont run that, its fredericd and its not live yet |
| 10:50 | wasabi | aaaahh.. |
| 10:51 | ok, all good | |
| 10:51 | chris | translate.koha.org is still the current translation site, that one will takeover as soon as 3.2 is released and i stop as translation manager |
| 10:52 | Amit | @wunder Bangalore |
| 10:52 | munin | Amit: The current temperature in Bangalore, India is 23.0�C (2:30 PM IST on July 22, 2010). Conditions: Light Drizzle. Humidity: 78%. Dew Point: 20.0�C. |
| 10:52 | Amit | @wunder New Delhi |
| 10:52 | munin | Amit: The current temperature in New Delhi, India is 32.0�C (4:00 PM IST on July 22, 2010). Conditions: Haze. Humidity: 66%. Dew Point: 25.0�C. Pressure: 29.53 in 1000 hPa (Steady). |
| 10:52 | Amit | @wunder Dehradun |
| 10:52 | munin | Amit: The current temperature in Dehradun, India is 26.0�C (11:30 AM IST on July 22, 2010). Conditions: Haze. Humidity: 81%. Dew Point: 24.0�C. Pressure: 29.60 in 1002 hPa. |
| 10:53 | magnus | ooh, the temperature in bangalore sounds pleasant today |
| 10:53 | wasabi | i noticed liz was talking about a OPAC back-button security issue |
| 10:54 | Amit | heya magnus |
| 10:54 | magnus | hi Amit |
| 10:54 | wasabi | i have something of a fix for it |
| 10:56 | ill send in my patch for 3.2 tomorrow | |
| 10:58 | its a little JS hack, to close/open a new browser-tab on 'logout' | |
| 10:59 | hdl joined #koha | |
| 10:59 | wasabi | ...which also destroys the logged-out users back-history |
| 11:03 | nengard joined #koha | |
| 11:04 | chris | cool wasabi |
| 11:06 | pentarex joined #koha | |
| 11:06 | wasabi | yeah, i did the fix for kapiti-lib a wee while back - their users spotted the same problem |
| 11:06 | pentarex | hey guys |
| 11:06 | wasabi | heya pentarex |
| 11:06 | pentarex | can anyone help me with instalation of koha in gentoo |
| 11:07 | wasabi | im a gentoo n00b :/ |
| 11:07 | pentarex | i have problem with perl makefile.pl |
| 11:07 | it says can't locate dbi.pm | |
| 11:07 | something | |
| 11:07 | ssss joined #koha | |
| 11:08 | pentarex | i searched in google, install gcc and still the same problem |
| 11:08 | :( | |
| 11:09 | wasabi | http://bugs.gentoo.org/208430 |
| 11:09 | $ sudo cpan DBI | |
| 11:09 | will install dbi.pm | |
| 11:10 | pentarex | and what i have to do with this files ? |
| 11:10 | aha | |
| 11:10 | wasabi | pentarex: pass, try an easier linux distro 1st |
| 11:10 | pentarex | nice :) |
| 11:10 | wasabi | debian or ubuntu |
| 11:11 | pentarex | sorry my browser chat is very slow |
| 11:11 | wasabi | ok, debian or ubuntu arent *easier* ... |
| 11:12 | but most people here use them, over gentoo | |
| 11:13 | http://git.koha-community.org/[…];f=INSTALL.debian | |
| 11:13 | http://git.koha-community.org/[…];f=INSTALL.ubuntu | |
| 11:14 | pentarex | :) |
| 11:15 | hdl left #koha | |
| 11:19 | pentarex left #koha | |
| 11:25 | collum joined #koha | |
| 11:33 | ssss | how to unistall koha on ubuntu and make a fresh install |
| 11:35 | jwagner joined #koha | |
| 11:37 | magnus | ssss: http://git.koha-community.org/[…]untu;hb=HEAD#l377 line 377 etc |
| 11:48 | good morning jwagner ;-) | |
| 11:49 | jwagner | No caffeine yet. You could tell, right? |
| 11:49 | saorge joined #koha | |
| 11:49 | magnus | ;-) |
| 11:50 | wasabi | i think im looking at koha-db with 900megs of session-rows... :/ |
| 11:50 | saorge_ left #koha | |
| 11:51 | wasabi | which is around 90% of the db size , lol |
| 11:51 | Amit left #koha | |
| 11:55 | kf | morning jwagner |
| 11:55 | jwagner | wasabi, druthb wrote a patch & submitted it a while back that includes a nightly cleanup script to empty out the sessions table. If it gets too large, the whole system gets dragged down. |
| 11:55 | morning kf | |
| 11:56 | nahuel left #koha | |
| 11:56 | wasabi | yep, i run that one on my boxes, works great! |
| 11:58 | kf | jwagner: afaik we use that script too |
| 12:00 | jwagner: It's short after lunch, feels like morning without caffeine | |
| 12:22 | schuster joined #koha | |
| 12:25 | jwagner | morning, schuster |
| 12:26 | nahuel joined #koha | |
| 12:27 | schuster | Howdy all! busy day of packing up the office and trying to do some internal software testing... |
| 12:28 | I'll also try and finish the formating on http://wiki.koha-community.org/wiki/Kohausers today. | |
| 12:29 | jwagner | Are you moving? |
| 12:37 | owen joined #koha | |
| 12:37 | jwagner | Morning, owen -- I was waiting for you :-) |
| 12:38 | * owen | jumps back in fear |
| 12:38 | jwagner | See Bug 4385 -- for you & anyone else interested in OPAC interface, I don't know how to diagnose & fix the underlying problem. |
| 12:38 | munin | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=4385 enhancement, P5, ---, oleonard, NEW, With XSLT on, results list doesn't show both hardcopy and URL availability |
| 12:38 | owen | Oh wait, there was no evil cackle after what you said. |
| 12:38 | * owen | calms down. |
| 12:38 | jwagner | But I do know that by separating the URL line & the availability line, it works. |
| 12:38 | * jwagner | will cackle if you want.... |
| 12:39 | owen | Do you have a live example I could look at? |
| 12:39 | jwagner | So would there be objection to splitting the line in the results list? |
| 12:39 | Not offhand -- the one publicly accessible site that was having the problem I fixed with a local mod | |
| 12:39 | owen | What needs to be in the record to cause the problem? |
| 12:40 | jwagner | What I'm envisioning is one line for Availability with branch, callnum, etc., and another line for Online that only shows if there's an 856. |
| 12:40 | It's described in the bug report -- the combination of an 856 in the record and a circulating item type | |
| 12:41 | I've replicated on current head | |
| 12:44 | schuster | jwagner - me moving no just doing some renovation here at the office, but we don't know when so need to packup as they could come while I'm out of the office the next 5 days. |
| 13:01 | Nate joined #koha | |
| 13:04 | owen | jwagner: What version of Koha is Northeast Harbor Library running? |
| 13:06 | jwagner | Our latest -- Harley plus new features |
| 13:07 | owen | I'm disappointed that the press release doesn't state that explicitly |
| 13:07 | jwagner | Talk to the marketing people :-) |
| 13:08 | owen | The marketing people know quite well what they're doing. |
| 13:10 | nengard left #koha | |
| 13:14 | jcamins_a is now known as jcamins | |
| 13:14 | jcamins | Hello, #koha |
| 13:15 | owen | HI jcamins |
| 13:16 | jcamins | irma++ # for planning to bring Koha's MARC21 framework up-to-date |
| 13:16 | kf++ # for the same | |
| 13:19 | schuster | irma++ will that have the new RDA tags then too? |
| 13:19 | kf | schuster: if it is part of MARC21 I think so |
| 13:19 | schuster | I think I have finished editing to the best of my ability the kohausers page |
| 13:20 | kf | schuster: I know nothing about RDA, but I think we should be MARC21 standard compliant |
| 13:20 | jcamins | Most of the RDA tags have been added to the MARC21 standard. |
| 13:20 | kf | ok, I think we will try to do that (and hope we can) :) |
| 13:21 | schuster | kf, jcamins - I don't know anything about the authority MARC changes but I suspect there will be changes to that framework too...??? |
| 13:22 | jcamins | Ooh. Good question. |
| 13:22 | Checking now. | |
| 13:23 | Yup. | |
| 13:23 | kf | schuster: not sure, I had no problems so far and our union catalog uses a lot of new fields |
| 13:23 | jcamins | Oh my. |
| 13:23 | kf | ah ok |
| 13:23 | yeah, a great task | |
| 13:23 | jcamins | That's a lot of changes. |
| 13:23 | kf | I have patches for adding $w subfields to all frameworks -... and it took long |
| 13:24 | jcamins | The last two updates alone add 16 fields to the MARC21 authority standard. |
| 13:24 | kf | hm perhaps not change the sql but generate new sql fiels from the database |
| 13:25 | wasabi | ive been chatting to irma about getting a LOC spec for marc21 |
| 13:25 | * kf | volunteers jcamins to help with that too |
| 13:26 | kf | I was volunteered by chris ;) |
| 13:26 | jcamins | Hey, now! |
| 13:26 | I saw. | |
| 13:26 | Actually, I was surprised chris didn't volunteer me, since I complained about this yesterday. | |
| 13:26 | kf | I talked to thd about it a long time ago |
| 13:26 | jcamins | I won't be at KohaCon, but I'll do what I can from a distance. |
| 13:26 | wasabi | and getting a script to compare the koha-marc21.sql with the LOC-MARC21 spec file |
| 13:26 | kf | I will try and write him a mail to find out if he already started |
| 13:27 | jcamins | Does irma need a contact in the network development and MARC standards office? |
| 13:27 | wasabi | to detect errors/changes in the koha marc21 def. |
| 13:27 | jcamins | Because that's something I could contribute. |
| 13:27 | cfrank487 joined #koha | |
| 13:27 | cfrank487 | i'm new to sql and have 2 quick questions |
| 13:29 | owen | Ask away cfrank487 |
| 13:30 | wasabi | jcamins: i think any contact at MARC office would be useful |
| 13:30 | what i am looking for is a nice MARC21 spec file to parse | |
| 13:31 | jcamins | Okay. I will try and get that for you next week (both the contact, and the spec file). |
| 13:32 | I keep my rolodex at home. | |
| 13:32 | wasabi | something nicer to parse than this -> http://www.loc.gov/marc/biblio[…]hic/ecbdhome.html |
| 13:32 | jcamins | Right. That would not be fun. |
| 13:32 | kf | this is better than a pdf... |
| 13:33 | wasabi | yep, website is prolly easier to parse that a pdf |
| 13:39 | jcamins: thanks - if we can find a nice enuff spec-file, ill def. do the script for it | |
| 13:40 | jcamins | I don't know if they'd share one, but at least I know someone in the standards office who might be able to help us. |
| 13:46 | cfrank487 | 1. Where is a good place i can learn about sql in reference to koha? |
| 13:46 | owen | cfrank487: What task are you trying to accomplish? |
| 13:47 | * magnus | parsed normarc out from html, thankfully it was almost stuctured... |
| 13:47 | cfrank487 | Well, I'm just trying out some of the sql reports like "list new items" but.. |
| 13:47 | owen | cfrank487: Tons of SQL reporting resources here: http://wiki.koha-community.org[…]L_Reports_Library |
| 13:48 | * magnus | ...and was slightly shocked to learn that there is no master/authoritative file that describes the format in a structured way |
| 13:48 | cfrank487 | that's the page i was on..i just don't know where to put my own library information |
| 13:49 | owen | There are three things to change in that report: The two "between" dates, and the item homebranch |
| 13:49 | items.homebranch is looking for the code for the library you're reporting on. | |
| 13:50 | cfrank487 | which code? |
| 13:50 | owen | When you set up libraries in Administration you would have put in a library code |
| 13:50 | /cgi-bin/koha/admin/branches.pl | |
| 13:50 | Or Administration -> Libraries, branches, groups | |
| 13:50 | cfrank487 | oh, ok that code...thanks |
| 13:50 | one last question... | |
| 13:51 | magnus left #koha | |
| 13:51 | cfrank487 | for other SQL statements does the ' ' mean that i need to input my own library data? |
| 13:52 | owen | I would say so, unless the SQL is testing for an empty value |
| 13:53 | SELECT COUNT(barcode) AS Count FROM items WHERE barcode <> '' AND barcode IS NOT NULL | |
| 13:53 | That is a case where it's testing for an empty value | |
| 13:53 | cfrank487 | ok..that helps..thank very much |
| 13:53 | owen | Actually it looks like generally speaking '' means empty value |
| 13:53 | It looks like most examples fill in with dummy text if you're supposed to enter something | |
| 13:54 | cfrank487 | ok..thank you again |
| 13:54 | see you later | |
| 13:59 | ssss left #koha | |
| 13:59 | cfrank487 left #koha | |
| 14:08 | jwagner | owen or others, any feedback on my question about splitting the results display (Bug 4385)? |
| 14:08 | munin | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=4385 enhancement, P5, ---, oleonard, NEW, With XSLT on, results list doesn't show both hardcopy and URL availability |
| 14:08 | jwagner | I may have some time to work on that soon. |
| 14:08 | owen | jwagner: I encourage you to pinpoint the exact combination of factors that leads to the discrepancy |
| 14:09 | jwagner | Thought I had.... |
| 14:09 | owen | "For a title with an 856 and a physical item with a circulating item type (like book), either only the 856 will show or neither will show" |
| 14:09 | jwagner | I know what causes it, but I haven't been able to decipher in the code why |
| 14:09 | owen | That sentence made it sound like it wasn't clear when the problem occurred |
| 14:10 | jwagner | No, in that situation (856 and circulating item) the display never shows both. It will either only show the 856, or show neither. |
| 14:10 | But if you change the item type to non-circulating, both will show | |
| 14:11 | It's somewhere in the murky area of how the system defines availability, I think | |
| 14:11 | But if I pull the 856 out of the availability line and put it on a separate line, then everything displays fine. | |
| 14:13 | owen | I'm curious what factor determines whether an 856+circulating record will show the 856 or not |
| 14:13 | Because I want to understand how it works | |
| 14:14 | jwagner | Me too. But I spent several hours poking around the .xsl file and XSLT.pm and couldn't find it. |
| 14:14 | owen | But if you're happy with your patch, go ahead and submit it and then we can test it |
| 14:14 | jwagner | My proposed fix is definitely a workaround. It doesn't fix why the problem occurs because I don't know why the problem occurs. |
| 14:19 | jcamins | Not related to jwagner's bug, but I have karma for whoever made date formatting strings auto-fill-in for the title. |
| 14:21 | owen | kf around? |
| 14:21 | kf | here |
| 14:22 | owen | I wonder if you can confirm something: standalone .js files aren't processed by the translator are they? |
| 14:22 | kf | no |
| 14:22 | there is bug report | |
| 14:22 | owen | I was just starting to file a report about members.js |
| 14:23 | I see, Bug 4503 | |
| 14:23 | munin | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=4503 enhancement, P5, ---, frederic, NEW, Javascript files in js directory are not translated |
| 14:23 | kf | bug 4503 |
| 14:23 | yep :) | |
| 14:23 | owen | Okay, thanks |
| 14:24 | wizzyrea | owen: jquery query: say you have a dropdown, and it doesn't necessarily make sense to make a global change to the project to get the default you want, how can you change the default selection with jquery? |
| 14:24 | example: in the label creator, it defaults to title search, our libraries like it to be barcode | |
| 14:24 | I changed the template directly, but they're not allowing us to do that anymore | |
| 14:25 | owen | wizzyrea: I know you can do it, but I have to look it up every time for some reason |
| 14:25 | wizzyrea | hehe ok then I'll just look it up myself :) |
| 14:25 | I thought you might have it on one of the many tips of your brain | |
| 14:25 | cuz you're smart and stuff. :) | |
| 14:26 | owen | I see some relevant examples here: http://www.myphpetc.com/2009/0[…]s-and-tricks.html |
| 14:26 | wizzyrea | brilliant |
| 14:26 | owen | My brain doesn't want to retain that particular fact for some reason |
| 14:26 | Just like my brain won't let me remember that I need to make a dentist appointment | |
| 14:26 | * wizzyrea | giggles |
| 14:26 | owen | D'oh! Tricked you brain! |
| 14:26 | kf | owen: members.js was the one where I noticed |
| 14:27 | owen | kf: There are methods for dealing with it. See basket.js and its use of variables set in the template |
| 14:27 | kf | yep |
| 14:27 | thats what I wrote in the bug | |
| 14:27 | owen | "showCartUpdate(MSG_BASKET_EMPTY);" |
| 14:28 | kf | 'Perhaps error messages should be handled in the template, as basket.js in opac does. ' ;) |
| 14:28 | owen | You're way ahead of me on all counts :) |
| 14:28 | kf | no, not really |
| 14:29 | I felt not brave enough to change the javascript | |
| 14:29 | and atm I have not much time and other more important problems to solve :( | |
| 14:30 | owen | I'm going to go ahead and file a bug specifically for members.js and leave your bug to address the wider question of whether js files /should/ be translated |
| 14:31 | kf | perhaps you can link them? |
| 14:33 | owen | I don't think one blocks the other, since we can modify members.js and move the error messages into the memberentrygen.tmpl template |
| 14:35 | Bug 5056 | |
| 14:35 | munin | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5056 normal, P5, ---, oleonard, NEW, Untranslatable strings in members.js |
| 14:35 | wizzyrea | owen: $("#myselect option:eq(2)").attr("selected", "selected"); worked mahvelously |
| 14:36 | with the proper values, of cours | |
| 14:36 | owen | wizzyrea: Just hope that your count of options doesn't change ;) |
| 14:36 | wizzyrea | ya, it's the label creator so seems fairly static? |
| 14:36 | dk, maybe I'll do it by name | |
| 14:37 | owen | I've dealt with similar requests with regard to collection codes, and they folks wonder why things don't work after they add and remove a few |
| 14:37 | wizzyrea | mmm yea |
| 14:42 | kf | owen:not blocks, but depends perhaps |
| 14:43 | msg2 += ("Warning !!!! Duplicate organisation!!!!"); | |
| 14:43 | perhaps you can make the messages a bit nicer too... :) | |
| 14:44 | owen | Oh, do you think there aren't enough exclamation points? ;) |
| 14:44 | cfrank487 joined #koha | |
| 14:45 | cfrank487 | We need to print fine slips for patrons with overdue notices with patron information.. |
| 14:47 | kf | owen: perhaps add some angry looking smileys :) |
| 14:48 | cfrank487 | hello owen again...i came across another problem... |
| 14:48 | i'm testing out koha before we go live.. we trained with your colleague ms. engard.. | |
| 14:49 | here's the problem.. at out library overdue patrons are not allowed to check out books.. | |
| 14:49 | kf | cfrank487: atm you cant print a special fine slip |
| 14:49 | you can print the fines page, but its not formated for a receipt printer | |
| 14:49 | cfrank487 | yeah, that's what i was going to ask... |
| 14:49 | we don't use a receipt, just a standard printer.. | |
| 14:49 | kf | I think there is a development to do that, but not for 3.2 (afaik) |
| 14:50 | cfrank487 | i did print a fines page, but we want to customize..i'll guess we'll have to wait until 3.2? |
| 14:51 | kf | not sure you can do your customization in 3.2 |
| 14:51 | I think the fines page has not changed much | |
| 14:51 | cfrank487 | oh.. we're using 3.0 which is the stable version? |
| 14:52 | cfouts joined #koha | |
| 14:52 | owen | 3.0.6 is the current stable version, but the stable release of 3.2 is coming very soon |
| 14:52 | jwagner is now known as jwag_mtg | |
| 14:53 | cfrank487 | thanks for the info.. 3.01.00.143 is the version we are using.. |
| 14:53 | kf | ah |
| 14:53 | this is a 3.1 - a development version of 3.2 | |
| 14:53 | cfrank487: what do you want to do? | |
| 14:54 | as customization to the fines receipt? | |
| 14:54 | cfrank487 | yes.. so let's say you owe our library $30.00 |
| 14:54 | and want to check out a book.. | |
| 14:55 | i would have to decline your request and give you a slip stating your fines to give to the business office | |
| 14:55 | kf | ah |
| 14:55 | perhaps this will help you: http://bugs.koha-community.org[…]w_bug.cgi?id=1232 | |
| 14:55 | munin | 04Bug 1232: enhancement, PATCH-Sent, ---, gmcharlt, NEW, Add Invoice/Credit/Fines Payed For Day on Issues (Print Page) (Print Slip) |
| 14:55 | cfrank487 | you would give this to the business office, get a receipt from them and we post that you paid it... |
| 14:55 | kf | but is has not been pushed to 3.2 - perhaps it will go into 3.2 |
| 14:55 | 3.4 | |
| 14:56 | sorry | |
| 14:56 | cfrank487 | i know it's an old fashioned method, but when in rome... |
| 14:58 | joetho joined #koha | |
| 14:59 | cfrank487 | lright..until the next question, you can bet there will more questions, but I will try to give you a break.. |
| 14:59 | cfrank487 left #koha | |
| 15:03 | owen | Oh, is it break time? |
| 15:03 | * owen | kicks back. |
| 15:06 | francharb left #koha | |
| 15:08 | trea joined #koha | |
| 15:18 | alex_a left #koha | |
| 15:52 | cfrank487 joined #koha | |
| 15:52 | wizzyrea | hm, what is usually the problem when you get Error exporting report when trying to export CSV? |
| 15:52 | cfrank487 left #koha | |
| 15:52 | wizzyrea | the error log isn't all that helpful |
| 15:54 | briceSanc joined #koha | |
| 15:54 | briceSanc | hi! |
| 15:55 | wizzyrea | oh, this is the error: guided_reports.pl: PARAM:LOOP:loop argument:array pointer was expected but not found at /usr/local/lib/perl/5.10.0/HTML/Template/Pro.pm line 191., referer: http://lecompton.nekls.org:808[…]n%20this%20report |
| 15:55 | briceSanc | is there any tutorial to install multiple koha on the same system ? |
| 16:04 | owen | briceSanc: Have you Googled for the answer? It has probably come up on the mailing list before |
| 16:05 | * wizzyrea | googled hers, but the only time it occurred no one answered :( |
| 16:06 | tance joined #koha | |
| 16:06 | owen | wizzyrea: At least you know it's not just a quirk of your system |
| 16:08 | wizzyrea | or it's the same quirk of my system that it was of his |
| 16:08 | Nate left #koha | |
| 16:08 | owen | And you guys can be quirk-buddies. |
| 16:08 | tance | how it is better to install koha from git? |
| 16:08 | wizzyrea | that sounds dirty |
| 16:09 | tance | or from the zip file |
| 16:11 | owen | tance: If you're comfortable with git, it makes upgrading much easier |
| 16:12 | It also allows you to make local customizations in git branches which can be easily merged with new development | |
| 16:12 | tance | the version 3.00.06 is stable or not? |
| 16:13 | because a have a lot of troubleshoots | |
| 16:13 | when i search on the opac it show ony rexult | |
| 16:13 | *result | |
| 16:14 | the same and the staff client, no result found | |
| 16:14 | owen | 3.00.06 is the latest stable version. |
| 16:15 | jcamins | tance: http://koha-community.org/docu[…]faq/searching/#16 |
| 16:15 | tance | am new user on koha and linux os |
| 16:15 | i saw this link | |
| 16:16 | somthing is going wrong with C4 /cantext module | |
| 16:17 | jcamins | tance: The problem is with your PERL5LIB environment variable. |
| 16:17 | tance | i dont know what to do |
| 16:17 | with PERL5LIB | |
| 16:18 | CAN u tell me waht to do | |
| 16:18 | some instruction | |
| 16:18 | wizzyrea | export PERL5LIB=/path/to/koha |
| 16:19 | if you've done it with standard install: it's usually export PERL5LIB=/usr/share/koha | |
| 16:19 | if you've done it with dev install | |
| 16:19 | it's usually /home/yourusername/kohaclone | |
| 16:20 | or something | |
| 16:22 | tance | im on ubuntu 10.04 |
| 16:22 | wizzyrea | kinda irrelevant |
| 16:22 | useful to know though | |
| 16:24 | ok | |
| 16:24 | 1. log in as your koha user | |
| 16:24 | 2. | |
| 16:24 | type at the command prompt | |
| 16:24 | no quotes: "export PERL5LIB=/usr/share/koha" | |
| 16:24 | 3. try to run your index | |
| 16:28 | tance | just to type at terminal "export PERL5LIB=/usr/share/koha |
| 16:28 | wizzyrea | yes, as your koha user |
| 16:28 | tance | sorry because i am new user on koha and linux OS |
| 16:28 | wizzyrea | it's ok :) |
| 16:41 | jcamins | Huh. Weird problem: if you search for tag 005 in the frameworks editor, you don't get a link to go back. |
| 16:42 | (that is, a link to go back so you can see 001 and 003) | |
| 16:47 | tance | i did all of these but nothing hapen |
| 16:49 | kf | bye :) |
| 16:49 | kf left #koha | |
| 16:51 | wizzyrea | did you reindex after you added your environment variable? |
| 16:52 | aside, I find it amusing that there's a column in the messaging preferences for "days in advance" when only one option allows that | |
| 16:52 | I want to get my checkout notices before I even check out my books! | |
| 16:52 | </sarcasm> | |
| 16:53 | Koha should read my mind! | |
| 16:53 | owen | It would certainly make it easier to find the books you were going to check out |
| 16:53 | You'd have your list in hand! | |
| 16:53 | wizzyrea | hehe |
| 16:54 | owen | You could get into all kinds of cool "Minority Report" situations |
| 16:54 | "Why did I check out a book on how to murder my wife?" | |
| 16:54 | wizzyrea | I'm wondering if there's a reason we have a "do not notify" column as well |
| 16:54 | doesn't unchecking the email tickboxes mean you dont get notices? | |
| 16:55 | is there another notification that could be sent unless the "do not notify" checkbox is checked? | |
| 16:55 | krisztof joined #koha | |
| 16:56 | briceSanc | sorry wizzyrea it was my dinner time |
| 16:57 | is there a koha forum? | |
| 16:57 | krisztof left #koha | |
| 16:57 | wizzyrea | no, we have very active mailing lists though |
| 16:57 | owen | http://koha-community.org/supp[…]ha-mailing-lists/ |
| 16:58 | briceSanc | ok |
| 16:58 | i check that | |
| 16:58 | wizzyrea | i really like that that page shows the latest messages. Something about it, I just like it. |
| 16:59 | owen | I hadn't see that wizzyrea, that's really cool! |
| 16:59 | wizzyrea | was trying to bring home the point that we've got active lists :) |
| 17:00 | jcamins | Wow! That's really nice! |
| 17:00 | laurence left #koha | |
| 17:05 | brice joined #koha | |
| 17:06 | briceSanc left #koha | |
| 17:06 | briceSanc joined #koha | |
| 17:07 | briceSanc left #koha | |
| 17:07 | brice left #koha | |
| 17:07 | briceSanc joined #koha | |
| 17:07 | tance | how to reindex zebra on ubuntu 10.04? |
| 17:10 | wizzyrea | tance: http://git.koha-community.org/[…]a2e6;hb=HEAD#l320 |
| 17:11 | actuall | |
| 17:11 | y | |
| 17:11 | this is better: http://git.koha-community.org/[…]a2e6;hb=HEAD#l284 | |
| 17:21 | pianohack joined #koha | |
| 17:21 | wizzyrea | I suppose I ought to pull that bit out, clean it up, and make it a FAQ |
| 17:21 | lots of caveats in that process though | |
| 17:21 | *sigh* | |
| 17:22 | tance | i try this but is says koha is not in sudoers file |
| 17:23 | im going crazy | |
| 17:23 | why so dificult to install koh | |
| 17:23 | a | |
| 17:25 | wizzyrea | http://kenno.wordpress.com/200[…]-in-debianubuntu/ <- to address your sudoer issue |
| 17:26 | we need to move the admonition to export environment variables out of the installation file and into the install docs | |
| 17:26 | or at least copy it | |
| 17:26 | objections? | |
| 17:31 | brendan joined #koha | |
| 17:41 | Nate joined #koha | |
| 17:44 | jcamins | wizzyrea: A very good idea. |
| 17:51 | brendan left #koha | |
| 17:54 | jcamins | Does anyone know how authorities are linked to genre terms? |
| 17:54 | (MARC21 655) | |
| 17:58 | Ah-ha. | |
| 17:58 | There is a subfield 9 missing from the framework. | |
| 18:03 | brendan joined #koha | |
| 18:05 | brendan left #koha | |
| 18:10 | tance | im trying to make e fresh install of koha |
| 18:12 | what is recomended to install from git or from koha 3.00.06 tar.gz file? | |
| 18:14 | please reply anyone is mergency | |
| 18:14 | *emergency | |
| 18:16 | owen | tance: If you're comfortable with git, it makes upgrading much easier |
| 18:16 | It also allows you to make local customizations in git branches which can be easily merged with new development | |
| 18:17 | If you're not comfortable with git, it may not be worth it to be struggling with another new thing to learn | |
| 18:17 | * owen | is trying to imagine what causes a Koha installation emergency |
| 18:18 | tance | git is stable version |
| 18:18 | chris | owen++ #for the marketing comment |
| 18:18 | owen | tance: It depends which version you get from git. |
| 18:19 | You can get the stable version from git, or you can get the latest, possibly unstable version | |
| 18:19 | tance | ok thanks |
| 18:19 | i can get any version i want | |
| 18:20 | ? | |
| 18:22 | tance left #koha | |
| 18:24 | jcamins | owen: board of directors breathing down your neck? |
| 18:24 | epic budget cuts? | |
| 18:25 | owen | The only way to diffuse this bomb is to install Koha? |
| 18:25 | wizzyrea | consultant that only has x hours of work left to get this dang thing working? |
| 18:25 | ;) | |
| 18:25 | jcamins | wizzyrea: Yeah, I guess that's probably it. |
| 18:25 | wizzyrea | and a plane ticket that sends them home at the end that's already bought |
| 18:26 | * wizzyrea | has heard this story before |
| 18:26 | cait joined #koha | |
| 18:26 | cait | hi all :) |
| 18:26 | schuster | with a promise that it can be done remotely... |
| 18:27 | owen | That's good guys, let it all out ;) |
| 18:27 | jcamins | owen's idea is more fun, though. A bomb hooked up to a screenscraper that can only handle Koha, and a file full of MARC records it's going to e looking for? |
| 18:28 | chris | i suspect given how much trouble he/she had with environment variables after being told by 6 different people ... if its a bomb we are all dead |
| 18:29 | wizzyrea | pssst.... he's still here ;) |
| 18:29 | chris | not im my irc client |
| 18:30 | wizzyrea | AH, indeed you're correct, I didn't see his D/C |
| 18:30 | jcamins | I waited until after s/he'd quit to unleash my pent-up snark. |
| 18:30 | wizzyrea | nvm, continue the snarkfest |
| 18:30 | chris | and after 3 days of ppl saying set PERL5LIB .. i wouldnt actually care if they were :) |
| 18:31 | wizzyrea | lol |
| 18:31 | cait | tance? |
| 18:32 | owen | chris, I have a git question for you. Say I have a bunch of branches I'm working on. Is there a way to do a batch rebase of them all? |
| 18:32 | jcamins | cait: Yep. |
| 18:33 | brendan joined #koha | |
| 18:33 | chris | owen: nope, i rebase them as i switch to them, for whatever reason, ie first think i do after any git checkout is fetch and rebase (or sometimes pull depends on the branch) |
| 18:34 | owen | Okay, that's what I've been doing. I thought there might be some magic I was missing. |
| 18:34 | I'd love to be able to batch rebase a bunch of branches and have it abort any with merge problems | |
| 18:35 | chris | there are bound to be git tools that do something like that |
| 18:55 | brendan | hi |
| 18:55 | trea left #koha | |
| 18:56 | cait | hi brendan |
| 18:56 | jcamins | Hello. |
| 18:56 | brendan | :) |
| 19:14 | jwag_mtg is now known as jwagner | |
| 19:22 | pianohack left #koha | |
| 19:22 | pianohack joined #koha | |
| 19:23 | brendan | @wunder 93117 |
| 19:23 | munin | brendan: The current temperature in Eastern Goleta Valley, Santa Barbara, California is 20.6�C (12:24 PM PDT on July 22, 2010). Conditions: Overcast. Humidity: 77%. Dew Point: 16.0�C. Pressure: 29.92 in 1013.1 hPa (Steady). |
| 19:24 | pianohac1 joined #koha | |
| 19:24 | pianohack left #koha | |
| 19:42 | jwagner left #koha | |
| 19:54 | jcamins left #koha | |
| 19:55 | jcamins joined #koha | |
| 19:57 | collum left #koha | |
| 20:08 | indradg joined #koha | |
| 20:18 | cfrank487 joined #koha | |
| 20:18 | cfrank487 | can we schedule reports on koha? |
| 20:20 | owen | Theoretically. There is the task scheduler. (Tools -> Task scheduler) |
| 20:20 | I've never used it myself. | |
| 20:21 | cfrank487 | i've tried but i was never able to get it to work.. |
| 20:21 | wizzyrea | there is some trick to it, but if you have access to your server |
| 20:21 | it's just as easy to use cron to schedule reports | |
| 20:21 | cfrank487 | cron? |
| 20:22 | wizzyrea | chris knows more about it, doing it through the web interface involves some back end configuration, something about at |
| 20:22 | yes, unix's crontab | |
| 20:24 | cfrank487 | oh, ok the reason i ask because our circulation manager wanted to get daily reports of overdue materials |
| 20:24 | chris | at actually |
| 20:24 | Not cron | |
| 20:24 | wizzyrea | right, through the web interface you have to configure at |
| 20:24 | cfrank487 | she could always just run the report, but i thought if it would be cool(and less time-consuming) if she received an e-mail |
| 20:24 | wizzyrea | but you can always use cron for that |
| 20:24 | 2 ways :) | |
| 20:25 | seewhatimean | |
| 20:25 | chris | Yup |
| 20:25 | cfrank487 | ok..how do we get it or develop it? |
| 20:26 | owen left #koha | |
| 20:26 | chris | owen++ #for the new blog post |
| 20:27 | cfrank487 left #koha | |
| 20:27 | chris | Build the report in the report builder, using sql save it |
| 20:27 | cfrank487 joined #koha | |
| 20:28 | chris | Then you can signoff halfway thru |
| 20:29 | For the log, you can then set up cron to run the script knowing the id of the report | |
| 20:30 | Ill paste syntax when I'm at a computer | |
| 20:31 | richard joined #koha | |
| 20:31 | richard | hi |
| 20:31 | wizzyrea | hey richard |
| 20:31 | richard | hi wizzyrea |
| 20:31 | briceSanc left #koha | |
| 20:33 | chris | Hi richard |
| 20:33 | richard | heya chris |
| 20:34 | 'nother wonderful day in paradise :) | |
| 20:34 | chris | Heh |
| 20:34 | Yeah its a bit damp | |
| 20:43 | cfrank487 left #koha | |
| 21:05 | cait left #koha | |
| 21:07 | alan joined #koha | |
| 21:12 | darling joined #koha | |
| 21:14 | Nate left #koha | |
| 21:18 | wizzyrea | owen++ owen++ for several really really great blog posts |
| 21:19 | chris | yup |
| 21:23 | nengard joined #koha | |
| 21:23 | nengard | hi all, i need some report writing help - i'm looking to generate a report of all the bibs that have cookery in the subject |
| 21:23 | SELECT biblionumber, ExtractValue('//datafield[@tag="650"]/subfield[@code>="a"]') AS lcsh FROM biblioitems WHERE lcsh LIKE '%cookery%' | |
| 21:23 | and this does nothing | |
| 21:24 | chris | um yeah it wont |
| 21:24 | nengard | hehe |
| 21:24 | i've had a rough day | |
| 21:25 | chris | cos you havent told it what field to extract that data from |
| 21:25 | 2 secs ill just finish my email | |
| 21:25 | and ill write ya a query | |
| 21:25 | nengard | LOL - that would help |
| 21:26 | pianohac1 | nengard: chris might have a more comprehensive solution, but try putting marcxml before the '//datafield... |
| 21:26 | so it reads like ExtractValue(marcxml, '//datafield etc. etc. etc. | |
| 21:26 | nengard | yeah - that's what i forgot .... i did some deleting and must have gotten rid of it accidentally |
| 21:27 | SELECT biblionumber, ExtractValue(marcxml, '//datafield[@tag="650"]/subfield[@code>="a"]') AS lcsh FROM biblioitems WHERE lcsh LIKE '%cookery%' | |
| 21:27 | schuster left #koha | |
| 21:27 | nengard | nada - and i did a search there is at least one bib that should come up |
| 21:27 | pianohack joined #koha | |
| 21:28 | chris | are you running it at the commandline, cos that will tell you why its not working :) |
| 21:28 | SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="650"]/subfield[@code>="a"]') AS lcsh FROM biblioitems WHERE lcsh LIKE '%cookery%'; | |
| 21:28 | ERROR 1054 (42S22): Unknown column 'lcsh' in 'where clause' | |
| 21:28 | pianohac1 left #koha | |
| 21:28 | chris | heres how i would do it |
| 21:29 | pianohack | @later tell wizzyrea I really like the recent activity thing on the mailing lists page; would it be possible to show a date for each message? |
| 21:30 | munin | pianohack: The operation succeeded. |
| 21:30 | wizzyrea | hmm |
| 21:30 | I'm not sure | |
| 21:30 | if that's part of the RSS feed, sure | |
| 21:30 | but I'm not sure it is | |
| 21:30 | pianohack | k |
| 21:30 | wizzyrea | but I will check |
| 21:30 | :) | |
| 21:31 | pianohack | Sorry, pidgin sorts ops-first and I can't seem to get that into my little brain |
| 21:32 | wizzyrea | :D |
| 21:32 | sok | |
| 21:32 | I can sling some intelligence related epithets at you if you'd like | |
| 21:33 | but iti's not really necessary | |
| 21:33 | ;) | |
| 21:33 | well, and would be patently false, in addition | |
| 21:34 | nengard | chris .... |
| 21:35 | how would you do it? :) | |
| 21:35 | chris | still writing my email, gimme a sec :) |
| 21:35 | nengard | oh!! |
| 21:35 | okay | |
| 21:35 | hehe | |
| 21:35 | chris | ok, now thats sent |
| 21:35 | ok, id use a subquery | |
| 21:35 | eg | |
| 21:35 | select biblionumber,lcsh from (SELECT biblionumber, ExtractValue(marcxml,'//datafield[@tag="650"]/subfield[@code>="a"]') AS lcsh FROM biblioitems) as subjects where lcsh like "%cookery%"; | |
| 21:35 | try that | |
| 21:37 | nengard | nada |
| 21:38 | chris | i get 765 rows |
| 21:38 | | 93312 | COOKERY (NATURAL FOODS) NATURAL FOODS CHILDREN - NUTRITION | | |
| 21:38 | nengard | i only have 1 cookery in my catalog |
| 21:38 | but it's there | |
| 21:38 | chris | | 94211 | COOKERY CONFECTIONERY | |
| 21:38 | nengard | 650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM |
| 21:38 | a Topical term or geographic name as entry element Cookery Auth | |
| 21:38 | v Form subdivision Periodicals. | |
| 21:38 | brb | |
| 21:39 | chris | nengard: are you running this in mysql? |
| 21:39 | jcamins | nengard: Did you check to make sure you're using a recent veresion of MySQL? |
| 21:39 | Debian has a really old version by default. | |
| 21:40 | nengard | i'm running it in the reports tool |
| 21:40 | chris | yeah, try it at the commandline first |
| 21:40 | nengard | jcamins |
| 21:40 | mysql Ver 14.12 Distrib 5.0.51a, for debian-linux-gnu (i486) using readline 5.2 | |
| 21:40 | chris | cos it gives you nicer output |
| 21:41 | if there is a syntax error or whatever it will catch it | |
| 21:41 | jcamins | nengard: There's your problem. |
| 21:41 | chris | the reports tool, just hides it |
| 21:41 | and yeah, thats too old, that cant do extractvalue | |
| 21:41 | nengard | ERROR 1305 (42000): FUNCTION koha.ExtractValue does not exist |
| 21:41 | k | |
| 21:41 | jcamins | You need at least 5.1.5. |
| 21:41 | I don't know how to get a new version on Debian. | |
| 21:41 | nengard | is there an easy way to upgrade? apt-get or something? |
| 21:44 | chris | you are running lenny right? |
| 21:44 | jcamins | I don't know, and the security guard just made his "we're closing now" announcement, but I look forward to checking the scrollback this evening and reading about the solution. :) |
| 21:44 | Good night, all. | |
| 21:44 | nengard | yes chris |
| 21:44 | jcamins is now known as jcamins_a | |
| 21:44 | chris | ill just see if there is a nice backport for you |
| 21:45 | nengard | Linux debian 2.6.26-2-686 #1 SMP Tue Mar 9 17:35:51 UTC 2010 i686 GNU/Linux |
| 21:46 | chris | http://packages.debian.org/len[…]/mysql-server-5.1 |
| 21:46 | you are in luck | |
| 21:46 | nengard | ooooo |
| 21:46 | chris | http://www.backports.org/dokuw[…]p?id=instructions |
| 21:46 | nengard | now what do i do? |
| 21:46 | ah | |
| 21:46 | thanks | |
| 21:47 | chris | so apt-get -t lenny-backports install mysql-server (once yyou have done steps 1 and 2) |
| 21:49 | nengard | step 2 running now |
| 21:49 | chris | coolio |
| 21:50 | nengard | error: |
| 21:50 | Fetched 1125kB in 4s (252kB/s) | |
| 21:50 | W: GPG error: http://www.backports.org lenny-backports Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY EA8E8B2116BA136C | |
| 21:50 | W: Failed to fetch http://www.backports.org/debia[…]ary-i386/Packages 404 Not Found | |
| 21:50 | E: Some index files failed to download, they have been ignored, or old ones used instead. | |
| 21:50 | chris | typo |
| 21:50 | non-free | |
| 21:50 | not non-fre | |
| 21:50 | nengard | heh |
| 21:50 | if you knew the day i had - i'll rant when i get this fixed | |
| 21:50 | chris | bad cut and paste in step 1 :) |
| 21:51 | nengard | Reading package lists... Done |
| 21:51 | W: GPG error: http://www.backports.org lenny-backports Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY EA8E8B2116BA136C | |
| 21:51 | W: You may want to run apt-get update to correct these problems | |
| 21:51 | wasn't i just running apt-get update?? :) | |
| 21:52 | chris | yeah thats ok, we can live with that message for now |
| 21:52 | nengard | k |
| 21:52 | chris | if you want it to go away |
| 21:52 | wget -O - http://backports.org/debian/archive.key | sudo apt-key add - | |
| 21:53 | nengard | already running step 3 |
| 21:54 | davi left #koha | |
| 21:54 | nengard | bingo |
| 21:54 | one result! | |
| 21:54 | next question - will that only pull it if it's in the first 650? | |
| 21:56 | chris | shouldnt do |
| 21:56 | but it might | |
| 21:57 | no | |
| 21:57 | it will get it from all | |
| 21:57 | eg | |
| 21:57 | <datafield tag="650" ind1=" " ind2=" "> | |
| 21:57 | <subfield code="a">COOKERY (NATURAL FOODS)</subfield> | |
| 21:57 | <subfield code="a">NATURAL FOODS</subfield> | |
| 21:57 | <subfield code="a">CHILDREN - NUTRITION</subfield> | |
| 21:57 | </datafield> | |
| 21:57 | | 93312 | COOKERY (NATURAL FOODS) NATURAL FOODS CHILDREN - NUTRITION | |
| 21:57 | it gets extracted into one value | |
| 22:00 | nengard | k |
| 22:00 | thank you!!!! | |
| 22:01 | nengard left #koha | |
| 22:11 | one2one joined #koha | |
| 22:11 | one2one | hi |
| 22:11 | hi | |
| 22:13 | when i try to install koha via git i can choose the version i want ? for example 3.00.06 | |
| 22:14 | or automatically it gets the latest version? | |
| 22:15 | hello | |
| 22:15 | pianohack | hey one2one |
| 22:15 | It automatically gets the latest unstable version | |
| 22:15 | If you want an earlier version | |
| 22:15 | run git tag | |
| 22:16 | look for a version that meets your needs | |
| 22:16 | then run git checkout <version name> | |
| 22:17 | If you just want the latest 3.0.x, run git checkout -b origin/3.0.x | |
| 22:19 | nengard joined #koha | |
| 22:20 | nengard left #koha | |
| 22:21 | cfouts left #koha | |
| 22:22 | moodaepo1 joined #koha | |
| 22:22 | moodaepo left #koha | |
| 22:29 | joetho left #koha | |
| 22:34 | nengard joined #koha | |
| 22:35 | brendan left #koha | |
| 22:48 | nengard left #koha | |
| 23:01 | one2one left #koha | |
| 23:05 | druthb joined #koha | |
| 23:06 | druthb left #koha | |
| 23:27 | munin | New commit(s) kohagit: bug 4989: set DB rev to 145 <http://git.koha-community.org/[…]f9d69a9c5f00e5649> / (bug 4989) add index on guarantorid <http://git.koha-community.org/[…]609b8070359d7944b> |
| 23:27 | brendan joined #koha | |
| 23:32 | moodaepo1 | @wunder 56001 |
| 23:32 | munin | moodaepo1: The current temperature in South on Monks, Mankato, Minnesota is 29.2�C (6:31 PM CDT on July 22, 2010). Conditions: Clear. Humidity: 65%. Dew Point: 22.0�C. Pressure: 29.72 in 1006.3 hPa (Steady). |
| 23:32 | brendan | @wunder 93117 |
| 23:32 | munin | brendan: The current temperature in Eastern Goleta Valley, Santa Barbara, California is 23.9�C (4:34 PM PDT on July 22, 2010). Conditions: Clear. Humidity: 59%. Dew Point: 15.0�C. Pressure: 29.88 in 1011.7 hPa (Falling). |
| 23:32 | brendan | hi moodaepo1 |
| 23:33 | moodaepo1 | brendan: Hey. Drove by your part of the landscape couple of weeks ago pretty awesome : ) |
| 23:33 | brendan | yeah pretty isn't it |
| 23:34 | moodaepo1 | Got sucked into a tourist trap of a town built by some Dutchmen escaped with a cowboy hat. |
| 23:34 | brendan | ah solvang |
| 23:35 | that's a great town for danishes | |
| 23:35 | * moodaepo1 | thinks it was Solvang |
| 23:35 | brendan | also really great vineyards - that's where they shot the movie "sideways" |
| 23:36 | moodaepo1 | nice. wish I'd tried some danishes...found out getting a beer in wine country is *hard* |
| 23:44 | brendan | heh - yup wines the way to go |
| 23:58 | jcamins_a left #koha |
← Previous day | Today | Next day → | Search | Index
