← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:00 | jcamins | Bug 5141 has gotten worse. If you duplicate a field, you can no longer expand the duplicated field. |
| 00:00 | munin | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5141 normal, P5, ---, gmcharlt, NEW, Cannot duplicate subfields after duplicating a field |
| 00:03 | Genji joined #koha | |
| 00:03 | Genji | hiya! how do i sort via a new marc field? |
| 00:04 | like downloadable (enum('y','n')) now do i sort the y to the top? | |
| 00:04 | using CCL. | |
| 00:37 | Elwell_ joined #koha | |
| 00:37 | Elwell left #koha | |
| 00:44 | bankhead left #koha | |
| 00:47 | bankhead joined #koha | |
| 00:50 | chris_n | jcamins: probably more buggy js |
| 00:53 | jcamins: the question marks link to the loc marc explainations | |
| 00:53 | pretty cool actually | |
| 00:54 | jcamins | Yeah, I initially thought they were encoding errors. |
| 00:54 | chris_n | I can't duplicate 5141 |
| 00:54 | I can add a duplicate field | |
| 00:54 | then add subfields to the newly duplcated field | |
| 00:55 | as I would expect | |
| 00:55 | I do notice that if I duplicate a filled in subfiled that the value is also duplicated | |
| 00:55 | jcamins | Hm, you're right. |
| 00:55 | This is progress. | |
| 00:56 | I guess it just so happens that I was doing something that highlights a closely-related bug. | |
| 01:04 | bankhead left #koha | |
| 01:14 | bigbrovar joined #koha | |
| 01:17 | Elwell joined #koha | |
| 01:20 | Elwell_ left #koha | |
| 01:26 | Elwell_ joined #koha | |
| 01:29 | Elwell left #koha | |
| 01:34 | Elwell joined #koha | |
| 01:37 | Elwell_ left #koha | |
| 02:33 | Oak joined #koha | |
| 02:37 | jcamins is now known as jcamins_a | |
| 03:09 | thd-away` joined #koha | |
| 03:11 | thd-away left #koha | |
| 03:56 | richard left #koha | |
| 04:28 | cait joined #koha | |
| 04:29 | cait | good morning #koha |
| 04:46 | danielg joined #koha | |
| 04:55 | cait | hi daniel :) |
| 04:56 | how are you? dealing with jetlag too? | |
| 04:57 | danielg | hi! no, i'm dealing with a major allergy attack that started a few hours after i returned. seems like half the people around here are, too |
| 04:57 | other than jetlag, how are you? | |
| 05:02 | cait | good |
| 05:03 | suitcase was one day late | |
| 05:03 | but now everything is ok | |
| 05:03 | danielg left #koha | |
| 05:03 | cait | hope you get better soon |
| 05:03 | allergies are no fun | |
| 05:03 | hmpf | |
| 05:04 | danielg joined #koha | |
| 05:06 | wajasu left #koha | |
| 05:07 | danielg1 joined #koha | |
| 05:08 | cait | hope you get better soon, allergies are no fun |
| 05:09 | danielg left #koha | |
| 05:10 | danielg1 left #koha | |
| 05:10 | danielg joined #koha | |
| 05:10 | cait | you are flickering |
| 05:11 | danielg2 joined #koha | |
| 05:14 | danielg1 joined #koha | |
| 05:15 | danielg left #koha | |
| 05:18 | danielg joined #koha | |
| 05:19 | danielg1 left #koha | |
| 05:22 | danielg1 joined #koha | |
| 05:23 | danielg left #koha | |
| 05:27 | danielg1 left #koha | |
| 05:56 | ivanc joined #koha | |
| 05:56 | ivanc | good morning #koha |
| 05:56 | guten morgen cait | |
| 06:01 | cait | hi ivanc |
| 06:01 | :) | |
| 06:02 | ivanc | your presentation? |
| 06:02 | cait | I think it was ok |
| 06:02 | fell asleep in the car on the way back | |
| 06:03 | still a bit out of sync because of the time difference :) | |
| 06:05 | ivanc: pm'ed you | |
| 06:05 | danielg2 left #koha | |
| 06:06 | cait | getting ready for work now, will be back in a few |
| 06:06 | cait left #koha | |
| 06:06 | ivanc | see you |
| 06:15 | bigbrovar left #koha | |
| 06:22 | ivanc left #koha | |
| 06:28 | laurence joined #koha | |
| 06:53 | slef | moo from auckland cbd |
| 06:54 | about to leave... see you tomorrow/day after | |
| 07:01 | chris | cya, safe travels |
| 07:01 | maragar left #koha | |
| 07:05 | kmkale joined #koha | |
| 07:05 | kmkale | Hi all |
| 07:22 | kmkale left #koha | |
| 07:43 | kf joined #koha | |
| 07:43 | kf | chris: around? |
| 07:43 | and good morning all :) | |
| 07:51 | chris | yep, whats up? |
| 08:00 | francharb joined #koha | |
| 08:00 | chris | http://twitpic.com/3414ic |
| 08:32 | larsw | greetings be on this channel |
| 08:32 | kf | hi lars |
| 08:33 | chris | heya larsw |
| 08:46 | kmkale joined #koha | |
| 08:47 | kmkale | Wish you all a very happy Diwali !! |
| 08:48 | chris | thanks kmkale |
| 08:48 | Oak left #koha | |
| 08:52 | kmkale left #koha | |
| 09:05 | alex_a left #koha | |
| 09:06 | kmkale joined #koha | |
| 09:18 | alex_a joined #koha | |
| 09:20 | francharb left #koha | |
| 09:20 | kmkale left #koha | |
| 09:33 | kmkale joined #koha | |
| 09:33 | bigbrovar joined #koha | |
| 09:41 | kmkale left #koha | |
| 10:37 | collum joined #koha | |
| 11:04 | bigbrovar left #koha | |
| 11:22 | bigbrovar joined #koha | |
| 11:38 | fredericd left #koha | |
| 12:10 | francharb joined #koha | |
| 12:16 | francharb left #koha | |
| 12:23 | francharb joined #koha | |
| 12:23 | francharb left #koha | |
| 12:25 | owen joined #koha | |
| 12:26 | fredericd joined #koha | |
| 12:29 | bgkriegel joined #koha | |
| 12:46 | schuster joined #koha | |
| 13:03 | bigbrovar left #koha | |
| 13:03 | bigbrovar joined #koha | |
| 13:10 | bigbrovar left #koha | |
| 13:11 | kf left #koha | |
| 13:21 | jcamins_a is now known as jcamins | |
| 13:21 | jcamins | Good morning, #koha |
| 13:21 | owen | Hi jcamins |
| 13:21 | gmcharlt | hi jcamins, owen |
| 13:24 | jcamins | Hm. To clarify the issue with $e and $4 relators, this is an issue even without RDA. |
| 13:25 | M. de Rooy's patch for bug 5264 is a big help, though. | |
| 13:25 | munin | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5264 enhancement, PATCH-Sent, ---, m.de.rooy, CLOSED FIXED, Retain additional bibliographic subfields when merging authorities |
| 14:03 | tcohen joined #koha | |
| 14:14 | trea joined #koha | |
| 15:15 | owen | C'mon, The US, it's up to us. Everyone else is already in the weekend. |
| 15:15 | Or are we too, already? | |
| 15:17 | jcamins | owen: you mean I get a choice? |
| 15:17 | Yay! It's the weekend! | |
| 15:17 | * jcamins | looks around |
| 15:17 | jcamins | Nope. Didn't work. |
| 15:18 | So, owen, how're things post-Kohacon? | |
| 15:21 | owen | My jet lag is almost non-existent! |
| 15:22 | The downside is that I have no memory of having been to New Zealand. | |
| 15:22 | jcamins | Huh. I have the exact same problem. |
| 15:22 | owen | We should get that looked at |
| 15:30 | hdl joined #koha | |
| 15:36 | wizzyrea | post kohacon... hmm |
| 15:36 | there was some discussion of T:T, and there are people who want to redesign the interface. This seems like it might have interest for you | |
| 15:36 | ...those words are english, but they don't make sense | |
| 15:37 | i no speak good today. | |
| 15:38 | brendan | morning all |
| 15:39 | owen | Which interface wizzyrea? Or all? |
| 15:41 | wizzyrea | probably they meant the staff client |
| 15:42 | owen | Oh good I'm glad they picked the hard one. |
| 15:42 | wizzyrea | lol |
| 15:46 | owen | wizzyrea: Was there any discussion of what T:T will allow us to do beyond H:T's capabilities? |
| 15:47 | Brooke joined #koha | |
| 15:47 | Brooke | yo |
| 15:47 | owen | Hi Brooke |
| 15:47 | alex_a left #koha | |
| 15:48 | wizzyrea | mostly the talk was of how to duplicate current functionality :/ |
| 15:48 | at least, I didn't catch the above and beyond discussion, if it happened | |
| 15:49 | jcamins | "She is married to her husband" -- quote from an illustrator's biography. Isn't that the definition of a husband? |
| 15:49 | Brooke | Anyone have a 3.2 demo up and running yet? |
| 15:50 | owen | ByWater's is usually running the latest Git |
| 15:50 | Brooke | their demo is 3.0 currently |
| 15:50 | unless there's a new link I didn't find | |
| 15:50 | wizzyrea | I think the one on k-c.org is following master |
| 15:50 | jcamins | They're on 3.01.00.145. |
| 15:50 | brendan | it's 3.01.00.145 - that's pretty close |
| 15:51 | will update it now | |
| 15:51 | wizzyrea | ^^ |
| 15:51 | Brooke | thank you sir! |
| 15:51 | wizzyrea | 3.01 is a long way from 3.0 >.> |
| 15:51 | owen | If they were on 3.0 it would mean they were installing a version from 2008 ;) |
| 15:51 | wizzyrea | but an update would tick that to a proper 2 |
| 15:52 | even though 145 is prettyclose to 2 | |
| 15:52 | chobbs joined #koha | |
| 15:53 | brendan | demo at 3.03 |
| 15:56 | chobbs | Can somebody help me torubleshoot this problem: "Patron has had overdue items and is blocked for 107 day(s)." Patron has no overdue items. |
| 15:57 | jcamins | owen: are you the one who fixed the subfield cloning problems? |
| 15:57 | owen | I worked some on it |
| 15:57 | chris_n did some too | |
| 15:58 | Am I taking credit or blame? :) | |
| 15:58 | jcamins | There's a new bug now... if you clone an unexpanded field, you can't then expand it. |
| 15:58 | owen | Oh damn, blame. |
| 15:58 | * chris_n | tries to tiptoe out of the room quietly |
| 16:00 | chris_n | ouch |
| 16:01 | jcamins | I think maybe the new random number wasn't appended to the link. |
| 16:01 | chris_n | it looks like it expands the original field |
| 16:01 | rather than the cloned field | |
| 16:01 | was that the bug you mentioned last evening jcamins? | |
| 16:01 | jcamins | chris_n: yup. |
| 16:01 | I just confirmed it in ByWater's demo. | |
| 16:02 | * chris_n | confirmed it here as wee |
| 16:02 | chris_n | well even |
| 16:02 | the same happens when cloning an already expanded field | |
| 16:02 | it does not collapse, but rather the one cloned does | |
| 16:03 | chobbs | How can I clear USERBLOCKEDREMAINING for a patron? |
| 16:06 | wizzyrea | chobbs: can you undebar them |
| 16:06 | ? | |
| 16:06 | chobbs | wizzyrea: They're not debarred :/ |
| 16:06 | chris_n | chobbs: edit the patron's account info |
| 16:06 | opps | |
| 16:06 | strange | |
| 16:07 | chobbs | Yeah, exactly :-) |
| 16:07 | wizzyrea | do you happen to have a rule that's applying only to that patron category? |
| 16:07 | chobbs | Yes, we have rules against this category in both default and at this student's library. |
| 16:07 | wizzyrea | is there something special about that patron? |
| 16:07 | and you have NO account flags set? | |
| 16:08 | chobbs | Correct - all flags are set to "no" |
| 16:08 | markk joined #koha | |
| 16:08 | wizzyrea | hmm. Sounds like you have a bit flipped |
| 16:08 | maybe set the debarred status and then unset it? | |
| 16:08 | it's only 1 patron right? | |
| 16:08 | markk | hi guys |
| 16:09 | wizzyrea | (that is to say, you're not seeing a trend of this happening, right?) |
| 16:09 | chobbs | no, we've had several from this school report a simialr issue, but certainly not a large percentage. |
| 16:09 | markk | does anyone knows how to change/add users for the staff client? |
| 16:10 | chobbs | wizzyrea: flipped all flags back and forth and no change. |
| 16:10 | wizzyrea | http://koha-community.org/docu[…]-manual/?ch=c5606 |
| 16:11 | http://koha-community.org/docu[…]-manual/?ch=x5750 | |
| 16:11 | markk, the 2nd link | |
| 16:11 | markk | 10x wizzyrea |
| 16:12 | wizzyrea | markk: pardon? |
| 16:12 | owen | "All staff members must be entered into Koha as patrons of the 'Staff' type" That's not true. |
| 16:13 | wizzyrea | true. |
| 16:13 | they can be any type, but you do have to set the permisisons | |
| 16:13 | http://koha-community.org/docu[…]?ch=x5851#AEN5851 | |
| 16:13 | schuster | it's all about the user permission... |
| 16:13 | wizzyrea | they're easier to find if you make them staff types |
| 16:13 | markk | mmmmm i c |
| 16:13 | wizzyrea | :) |
| 16:14 | chobbs: can you send a screenshot of what you're seeing? I'm having a hard time grasping your issue :) | |
| 16:14 | markk | btw what's the diffrence between koha.org and koha-community.org? |
| 16:15 | chobbs | wizzyrea: stand by... |
| 16:15 | owen | koha.org is defunct. |
| 16:15 | wizzyrea | yea, it's not maintained |
| 16:16 | at least, it's not maintained by anyone affiliated by the community | |
| 16:16 | owen | chobbs: Is your "OverduesBlockCirc" preference turned on, and do you want it to be? |
| 16:17 | chobbs | owen: it is set to "don't block" |
| 16:18 | wizzyrea | so, you have many branches (or libraries) and you only have issues in this one? |
| 16:18 | at least they're the only ones reporting it? | |
| 16:18 | owen | and only certain patrons at that branch? |
| 16:18 | chris_n | jcamins: is bug 5141 still accurate in light of that earlier discussion? |
| 16:18 | munin | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5141 normal, P5, ---, gmcharlt, NEW, Cannot duplicate subfields after duplicating a field |
| 16:20 | schuster | chobbs - hmmm seems like we are missing something - USERBLOCKEDREMAINING - what's remaining? This comes up when they checkout - is there anything checked out to them? Do they have fees? Do you charge for library cards? |
| 16:20 | chobbs | wizzyrea: that is correct |
| 16:20 | schuster: nothing checked out, no fines | |
| 16:20 | schuster | Is there a comment in their borrower record? |
| 16:20 | chobbs | schuster: and no charge for cards - K-12 district |
| 16:21 | schuster | We have 67 schools shared and I've never seen this either. |
| 16:21 | a screen shot would be good... | |
| 16:21 | owen | schuster: I don't think it's in your version |
| 16:22 | schuster | what version are they running? |
| 16:23 | chobbs | We're on 3.01.00.140 |
| 16:24 | I believe that's the last beta prior to the 3.02 release | |
| 16:24 | owen | chobbs: Do you have any patrons or branches with a "Suspension in days" setting > 0 ? |
| 16:24 | In circulation and fines rules? | |
| 16:26 | wizzyrea | ooo, that's a good idea owen |
| 16:26 | chobbs | owen: we do for '9-12 students', but not for the patron type of the affected students (K-5 students) |
| 16:27 | and my mac is busted, so i'm in safe mode and screenshots are not working (grrrrr) | |
| 16:28 | schuster | sounds like owen might be on to something since those can be branch specific maybe one of the settings for that location didn't get set right. |
| 16:30 | hdl left #koha | |
| 16:31 | jcamins | chris_n: no, I think bug 5141 can be closed. After I've tested a bit more, I'll close it. |
| 16:31 | munin | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5141 normal, P5, ---, gmcharlt, NEW, Cannot duplicate subfields after duplicating a field |
| 16:32 | chobbs | owen: is that "suspension in days" in the issuingrulestable? |
| 16:32 | owen | Yes |
| 16:33 | I'm confused. I guess OverduesBlockCirc is unrelated to USERBLOCKEDREMAINING | |
| 16:34 | reva joined #koha | |
| 16:35 | chobbs | owen: finedays is the fiel;d in issuingtables, right? can i safely set those to 0 through the database rather than delete/re-add the circ rules? |
| 16:36 | Brooke | different types of naughty, Owen? |
| 16:36 | owen | chobbs: I believe so |
| 16:37 | chobbs | owen: ok, going to change that and see if it has any effect... |
| 16:37 | owen | I don't understand how "suspension in days" is supposed to work. |
| 16:39 | chobbs | owen: Me either, but setting all to 0 seems to have solved my problem! |
| 16:40 | owen | I set a category's finedays to 5 and tried to check out to a patron with overdues.. nothing stopped me. |
| 16:43 | laurence left #koha | |
| 16:45 | Brooke | ruh ohj |
| 16:46 | schuster | I can see this for like temporary cards - suspension in days 30 so in 30 days they have to show proof of address or something? |
| 16:46 | chobbs | owen: Maybe we're just special :-) |
| 16:47 | Odd bit was that the two issuingrules rows I changed were for an unrelated patron type, though they did apply to the default library | |
| 16:48 | owen is now known as owen-away | |
| 16:50 | reva | Hi good morning. I am testing export and import functions using records in my 3.0.6 install into my Koha 3.2 (in virtual box). I can stage and import fine. And I see my bib record in OPAC search ; but the item records are not showing up in the OPAC. I see it has imported from the staff side. But when I go to edit them they always have iterm record # 0. |
| 16:51 | Am I missing a step in importing item records? | |
| 16:53 | bankhead joined #koha | |
| 16:54 | reva | I have set it to always add item records because I would like to import the bib and the corresponding item record. |
| 16:55 | bankhead left #koha | |
| 17:01 | mib_0b800 joined #koha | |
| 17:02 | mib_0b800 | any obvious reasons why items that are checked out would be included in the available for loan count in the opac? i didn't see anything in the faq about it |
| 17:02 | wizzyrea | owen++ for solfing chobbs's problem |
| 17:03 | mib_0b800: index not refreshed yet? | |
| 17:03 | bankhead joined #koha | |
| 17:04 | mib_0b800 | wizzyrea: hmm, well setting them to withdrawn works just fine but checking out does not reduce the count of available items |
| 17:04 | koha version 3.02.00.004 btw | |
| 17:04 | chobbs | thanks all for the help. gonna get my computer fixed now. |
| 17:05 | chobbs left #koha | |
| 17:05 | jcamins | mib_0b800: do you have the rebuild_zebra task set up? |
| 17:06 | mib_0b800 | jcamins: no, i did the autopilot debian install so if it wasn't part of that process i haven't done it |
| 17:07 | jcamins | mib_0b800: so much for that idea. The Debian package sets everything up. |
| 17:07 | reva | Anyone has solution item records not importing from 3.0.6 into 3.2. Is the export function in 3.0.6 faulty or is it that there are issues between 3.0.6 and 3.2? |
| 17:08 | schuster | Do you have any bib records with more than say 250 items attached to it? |
| 17:10 | mib_0b800 | btw, what is the difference between checked out and withdrawn, and why are items that are checked out not marked as withdrawn? |
| 17:10 | chobbs joined #koha | |
| 17:10 | * chobbs | knew he brought his ubuntu laptop in for a reason today... |
| 17:10 | jcamins | mib_0b800: withdrawn means "no longer in the collection." |
| 17:10 | Checked out just means that you've charged the item to a patron. | |
| 17:11 | mib_0b800: did you get any error messages when you checked the items out to the patron? | |
| 17:11 | chobbs | What's the easiest and/or best way to create a report for users that show which MARC records are currently suppressed? |
| 17:11 | mib_0b800 | jcamins: no, none at all |
| 17:11 | danielg joined #koha | |
| 17:11 | Brooke | Danny boy! |
| 17:12 | owen-away | Hi danielg |
| 17:13 | jcamins | chobbs: do you mean, what is the SQL you might use? |
| 17:13 | chobbs | jcamins, SQl would be terrific, but I don't see fields for that info in the biblio table |
| 17:14 | danielg left #koha | |
| 17:15 | danielg joined #koha | |
| 17:17 | danielg left #koha | |
| 17:18 | mib_mike joined #koha | |
| 17:18 | danielg joined #koha | |
| 17:18 | mib_0b800 | the really odd thing is in the detail view of the item in the staff opac, under holdings i have 4 listings and the one that's checked out has the status "Checked out to (student name here): due (tomorrow's date) Available" |
| 17:18 | jcamins | You'll need to debug this, but something like: SELECT items.ccode, items.cn_sort, biblio.author, biblio.title, biblio.biblionumber FROM items LEFT JOIN (biblio) ON (biblio.biblionumber=items.biblionumber) WHERE items.wthdrawn=1; |
| 17:19 | Wait, items.itemcallnumber not items.cn_sort | |
| 17:20 | tcohen left #koha | |
| 17:20 | owen-away is now known as owen | |
| 17:21 | owen | mib_0b800: I see the same thing in my test installation. "due 11/25/2010 Available " |
| 17:21 | jcamins | chobbs: wait, you were asking about suppressed. |
| 17:22 | chobbs | jcamins: so items.withdrawn maps to suppressed? It seems that suppressed ought to exist at the biblio lvel. I'm referring the the 942n subfield. |
| 17:22 | jcamins | chobbs: no, I just combined two conversations and made a new question for myself to answer. ;) |
| 17:22 | danielg left #koha | |
| 17:22 | chobbs | jcamins: Yup, we're on the same page now :-) |
| 17:23 | jcamins | What version of MySQL do you have? |
| 17:24 | chobbs | jcamins: 5.1.37 |
| 17:25 | jcamins | Yay! |
| 17:25 | One moment while I provide you with a new SQL query. | |
| 17:25 | One which does what you asked for. | |
| 17:25 | CGI899 joined #koha | |
| 17:25 | chobbs | Awesome. |
| 17:26 | CGI899 left #koha | |
| 17:27 | mib_0b800 | owen: it seems like this is at least somewhat similar to bug 2708 but in my case no items are being shown as checked out in the opac search results |
| 17:27 | munin | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=2708 major, P3, ---, gmcharlt, NEW, Checked out items saying available |
| 17:27 | chobbs | jcamins: Can I guess where you're heading? Can this be pulled out of the marcxml field in biblioitems? |
| 17:27 | CGI935 joined #koha | |
| 17:27 | jcamins | chobbs: SELECT biblio.title, biblio.author FROM biblioitems JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE ExtractValue(marcxml, '//datafield[@tag="942"]/subfield[@code="n"]')<>'0'; |
| 17:28 | CGI935 | hello |
| 17:28 | Brooke | hi there |
| 17:28 | jcamins | Maybe beter to check whether it's equal to 1. |
| 17:28 | *better | |
| 17:28 | I never use suppressed, so I can't test that. | |
| 17:28 | chobbs | jcamins: testing now... |
| 17:29 | jcamins: not fast :-) 100K records to search | |
| 17:29 | jcamins | Oh, no, it wouldn't be fast. |
| 17:30 | chobbs | hmmm. 0 results. guess i better create a record just to make sure the librarians are really using that field like they should |
| 17:30 | jcamins | We could try it in the ByWater demo... |
| 17:31 | Did I miss some news today? | |
| 17:31 | brendan | right now the demo mysql isn't running a new enough mysql database to report on XPATH |
| 17:31 | mib_0b800 | well i figured out my problem |
| 17:31 | jcamins | Oh, never mind that plan, then. |
| 17:32 | brendan | jcamins: you need a new enough mysql database to pull XPATH reports |
| 17:32 | I think it's something like 5.1 or something like that for mysql XPATH (IRC) not totally sure though | |
| 17:32 | jcamins | Right. I remembered to ask chobbs about that. I just didn't think to ask you. ;) |
| 17:32 | 5.1.24, I think. | |
| 17:32 | brendan | sounds correct |
| 17:33 | mib_0b800 | apparently if you don't enter a due date , you can still checkout just fine, but the item won't be marked as such |
| 17:33 | brendan | ah reading the scroll back ;) I see you asked |
| 17:33 | chobbs | jcamins: Duh, used Y/N for my authorised values, not 1/0 - works great! And that ExtractValue will come in handy for lots of other reports down the road. Thanks a ton! |
| 17:34 | jcamins | Oh, excellent! |
| 17:35 | bgkriegel left #koha | |
| 17:35 | CGI935 | hello somebody can i help me, i want to migrate my database to koha, migrated the register MARC is ok but i dont know the items how migrate for example the codebar |
| 17:37 | owen | CGI935: Not an answer to your question, but are you aware that Koha has a new home page? http://www.koha-community.org |
| 17:40 | schuster | do you have some information that would link the item to the bib? ISBN or record number? Was there a reason when you "imported" the MARC you didn't have the 952 tag on the bib to create the items at the same time? |
| 17:46 | mib_0b800 left #koha | |
| 17:50 | collum left #koha | |
| 17:51 | CGI935 | I use the system alexandria but i want to migrate to koha, and the register MARC dont use the 952 tag, the reference to codebar is in other table it is separate |
| 17:51 | I use the system alexandria but i want to migrate to koha, and the register MARC dont use the 952 tag, the reference to codebar is in other table it is separate | |
| 17:51 | reva | Just want to post that it is working fine now; I am embarrassed: It was exporting and importing between 3.0.6 that was not pulling in the items properly. But between 3.0.6 and 3.2 the export/import functions fine. I(I had two Koha open in my virtual box, so the confusion.) |
| 17:52 | jcamins | CGI935: how are the two tables linked? |
| 18:00 | chobbs | jcamins: So when I try to create a report in the Koha interface using that SQL, I get an error: The database returned the following error: |
| 18:00 | 1 | |
| 18:00 | Please check the log for further details. | |
| 18:00 | Any idea where the referenced log file is? | |
| 18:02 | Ne'er mind. A space ' ' at the front of my sql command was the culprit. | |
| 18:02 | munin | New commit(s) kohagit: (MT 2985) simplify CanBookBeReserved <http://git.koha-community.org/[…]604c1345320f4a8c4> |
| 18:03 | jcamins | chobbs: yeah, I need to A) report that bug and B) fix it. |
| 18:03 | owen | I thought that had at least already been reported |
| 18:04 | jcamins | Perhaps it has been. |
| 18:04 | chobbs | jcamins: any way to make the results of my new report clickable? Could I spit out html in my result set with the right link to edit the MARC? |
| 18:04 | jcamins | chobbs: yes indeed. |
| 18:05 | chobbs | way cool |
| 18:05 | cait joined #koha | |
| 18:05 | markk left #koha | |
| 18:06 | jcamins | SELECT ... , CONCAT('<a href="/cgi-bin/koha/cataloguing/addbiblio.pl?biblionumber=', biblio.biblionumber, '">', biblio.biblionumber, '</a>') ... I think. |
| 18:08 | chris | morning |
| 18:08 | jcamins | Oh, you need to escape the quotes, I think. |
| 18:08 | Just stick a backslash behind the double quotes. | |
| 18:08 | cait | hi chris, hi jcmains |
| 18:08 | chris_n | g'morning chris |
| 18:08 | jcamins | Hi cait and chris. |
| 18:08 | chris_n | cait: did you get my message? |
| 18:08 | cait | right now |
| 18:08 | chris_n | cool |
| 18:08 | brendan | morning chris |
| 18:08 | cait | looking at your patch |
| 18:09 | chris_n | hey brendan |
| 18:09 | cait | funny thing is - I added a todo to my list today to test that |
| 18:09 | chris | http://git.koha-community.org/[…]nalytical_records |
| 18:09 | chris_n | hehe |
| 18:09 | cait | but had no time (of course :( ) |
| 18:09 | reva left #koha | |
| 18:09 | chris_n | cait: the problem was that we don't fine on bibs, but on items |
| 18:09 | chris | that needs a bunch of testing by people who understand analyitcal records :) |
| 18:09 | * chris_n | was the one who wrote that code for shame |
| 18:10 | jcamins | 38060000038331 |
| 18:10 | cait | chris: it's not that difficult at all |
| 18:10 | jcamins | Sorry, wrong window. I've got to stop doing that. |
| 18:10 | cait | and you know that ;) |
| 18:10 | chris_n: it was working correctly | |
| 18:10 | strange | |
| 18:10 | should have never worked then? | |
| 18:11 | chris_n | yeah, it did for me during testing, but stopped recently |
| 18:11 | cait | hmpf! |
| 18:11 | I tested with HEAD for a long while, must not been long since it stopped working | |
| 18:11 | chris_n | when I went back and looked, I realized that I should have been handing it itemnumbers anyway |
| 18:11 | cait | long time |
| 18:12 | chris_n | so I don't know what was going on which is why I hoped you might since you had it working before |
| 18:12 | cait | no idea, but I can test it |
| 18:12 | chris_n | that would be great |
| 18:12 | cait | is monday ok? I have mails working on my test installations at work |
| 18:12 | chris_n | if it works as we expect, I'll submit it |
| 18:13 | sure | |
| 18:13 | cait | hm, but coworker must upgrade first.. I will work something out |
| 18:13 | chris_n | no real rush, I've put it on my production box because it works |
| 18:13 | I just wanted a double check prior to submitting | |
| 18:14 | * chris_n | wonders about his sanity at times :-) |
| 18:14 | cait | is the only change biblio to itemnumer? |
| 18:14 | chris_n | yes |
| 18:14 | cait | I promised it worked |
| 18:14 | I had screenshots! | |
| 18:14 | or still have them in bugzilla :) | |
| 18:14 | chris_n | yes, in your bug |
| 18:15 | cait | promise... it's near to my bedtime |
| 18:15 | chris_n | don't stay up for this! :-) |
| 18:16 | cait | I won't - but for dinner |
| 18:17 | I am away for the weekend - so perhaps it will have to wait until monday | |
| 18:17 | and I have no working mails on the laptop I will take with me | |
| 18:20 | chris_n | tnx cait |
| 18:22 | cait | no problem, but I better make a big note somewhere :) |
| 18:30 | chris | owen: you about? |
| 18:30 | owen | Yes |
| 18:30 | wizzyrea left #koha | |
| 18:31 | wizzyrea1 joined #koha | |
| 18:31 | chris | owen: http://www.flickr.com/photos/4[…]2157625236896938/ |
| 18:31 | kristina was pretty good about naming people | |
| 18:31 | http://www.flickr.com/photos/4[…]2157625236896938/ | |
| 18:32 | munin | New commit(s) kohagit: Bug 5368 Browse Shelf link appears when no itemcallnumber <http://git.koha-community.org/[…]25d514b445280acdc> |
| 18:35 | owen | I think at the next KohaCon we should wear t-shirts with our IRC nicks on them in 6-in high letters |
| 18:35 | gmcharlt | owen++ |
| 18:35 | cait | I think you can figure it out owen |
| 18:35 | mine is quite easy :) | |
| 18:36 | wizzyrea1 left #koha | |
| 18:37 | wizzyrea joined #koha | |
| 18:38 | * owen | had better stop looking at pictures before he gets too sad he missed it all |
| 18:38 | wizzyrea | :/ |
| 18:39 | jcamins | owen: that might present problems for me... I don't think I remember how to wear regular clothes anymore. |
| 18:39 | * owen | knows the truth is that jcamins is rarely out of his superhero costume |
| 18:39 | jcamins | What about a tie with my nick... ;) |
| 18:47 | wizzyrea | he has a cape made of lost pages of ancient texts, embellished with old coins. |
| 18:49 | gmcharlt | chris_n: 363c1ca9f9392403b98f3a3604c1345320f4a8c4 is one I strongly recommend for 3.2.x |
| 18:49 | cait | :) |
| 18:49 | jcamins | wizzyrea: shhh. My alter-ego is trying to keep a low profile. |
| 18:50 | chris | yeah, pushed that one up as soon as it came in, it fixes a nasty bug |
| 18:50 | * chris_n | was just eyeballing that one |
| 18:50 | chris_n | quite a nice fix |
| 18:51 | cait left #koha | |
| 18:53 | cait joined #koha | |
| 18:54 | chris_n | done |
| 18:55 | cait | ok, what have I missed? :) |
| 18:57 | chris_n | only pushing a needed fix to 3.2.x |
| 18:58 | cait | chris_n: when do you plan to release 3.2.1? |
| 18:58 | soon? | |
| 18:58 | chris_n | 22 Nov is my target date unless something *big* demands earlier |
| 18:58 | cait | :) sorry, we discussed today, what we will do next, and upgrading our installations is one of the next things we need to do :) |
| 18:59 | wizzyrea | I like this date thing you guys got goin. |
| 18:59 | chris_n | once per month is the plan as long as there are patches moving |
| 18:59 | wizzyrea | oooOOOooo |
| 19:00 | cait | date_thing++ ;) |
| 19:00 | schuster | yes++ on dates... |
| 19:00 | chris_n++ | |
| 19:01 | chris++ | |
| 19:01 | jcamins | date_thing++ |
| 19:02 | owen | dating_the_thing-- |
| 19:02 | wizzyrea | rofl |
| 19:02 | cait | lol |
| 19:02 | gmcharlt | depends on the thing, surely ;) |
| 19:02 | jcamins | owen: lol |
| 19:03 | owen | dating_power_girl++ |
| 19:03 | Whoops, mixed up my comic universes there. | |
| 19:06 | Brooke | just don't date an axe wielding Librarian and ye'll be fine. |
| 19:07 | jcamins | Brooke: unless the axe wielding Librarian thinks you should be, in which case you're in trouble either way. |
| 19:07 | chobbs | jcamins: Yup, I came up with something similar that works brilliantly. This is going to make it very easy to create very useful reports. |
| 19:07 | jcamins | chobbs: just don't run too many of them at once... |
| 19:08 | chobbs | jcamins: easy to crush the database? |
| 19:09 | jcamins | chobbs: it could slow things down a bit. |
| 19:11 | As long as you keep your joins reasonable (and the relationships in the Koha databse pretty much guarantee they will be), I don't think you're too likely to take down the system. | |
| 19:22 | chobbs | Alright, I added my new report to the reports wiki page. Thanks again jcamins! |
| 19:23 | With that report done, I can turn to others our users want. However, most of the rest of my custom reports need to be run per school/branch. Is there a way to create custom reports that use a dropdown field to filter? | |
| 19:24 | schuster | Wouldn't that be nice... dreams of the reports page being much smaller! |
| 19:24 | chobbs | schuster: I guess that gives me my answer :/ |
| 19:25 | schuster | I had to create a seperate web page and linked those "custom" reports to a page for each school. Now I don't think that has been fixed in 3.2... anyone? |
| 19:25 | cait | chobbs: now possibility to filte,r but you can add a field for the branch code to be filled out before the report is started |
| 19:25 | now = no | |
| 19:26 | * cait | blames the jetlag for all her typos |
| 19:26 | wizzyrea | hehe |
| 19:26 | chobbs | cait: what would you add to the SQL statement to make that happen? |
| 19:26 | danielg joined #koha | |
| 19:26 | cait | it's easy, let me look it up |
| 19:26 | schuster | do tell cait! |
| 19:26 | owen | The help screen for guided reports has the details |
| 19:26 | cait | but I think it's in the online help somewhere too |
| 19:26 | perhaps on the sql reports page? | |
| 19:26 | ah, owen :) | |
| 19:27 | owen | (which, incidentally, links to wiki.koha.org) :( |
| 19:27 | chris | oh, send a patch for that |
| 19:27 | heya danielg | |
| 19:27 | wizzyrea | hey danielg |
| 19:27 | cait | hm, perhaps we need to grep the files for that |
| 19:27 | wizzyrea | made it home safely? |
| 19:28 | * cait | waves to danielg |
| 19:29 | Brooke | good idea cait |
| 19:29 | clean house! | |
| 19:29 | cait | ? |
| 19:29 | Brooke | grep find and replace of sorts |
| 19:29 | cait | ah |
| 19:29 | :) | |
| 19:30 | * cait | adds it to her todolist |
| 19:30 | danielg left #koha | |
| 19:30 | dg joined #koha | |
| 19:32 | chobbs | cait: I thought you could do it for guided reports, but I'm trying to filter custom SQL reports. |
| 19:33 | cait | ah sorry |
| 19:33 | bigbrovar joined #koha | |
| 19:34 | chobbs | had my hopes up there :) |
| 19:35 | cait | chobbs: not sure I understand your sentence |
| 19:35 | dg left #koha | |
| 19:35 | cait | it works for custom sql reports |
| 19:37 | jcamins | Ouch. 225 occurrences of "koha.org" |
| 19:37 | cait | ouch |
| 19:37 | are you going to do it? | |
| 19:37 | I can do it, it's a nice task for the train tomorrow | |
| 19:38 | jcamins | Yay! |
| 19:38 | chobbs | cait: THAT ROCKS! :-) |
| 19:38 | jcamins | cait++ # for volunteering to fix all the references to koha.org |
| 19:38 | cait | I must be really really really tired |
| 19:39 | chobbs | cait: Sorry for yelling, but that really is helpful. |
| 19:39 | jcamins | Heh. |
| 19:39 | chobbs | schuster: WHERE items.holdingbranch=<<holdingbranch|branches>> |
| 19:39 | cait | right |
| 19:39 | was going to paste it right now :) | |
| 19:40 | I used it for borrower numbers in one of my reports, it worked great | |
| 19:40 | chobbs | cait: However, it makes my report downloadable instead of onscreen, which breaks my pretty HTML links :( |
| 19:40 | cait | ? |
| 19:40 | jcamins | That's really nifty. |
| 19:40 | cait | you can have it onscreen too |
| 19:40 | wizzyrea | hey, i'm glad that you dug that up |
| 19:40 | jcamins | chobbs: Make them absolute links. |
| 19:41 | cait | what is your sql? |
| 19:41 | wizzyrea | excel or LO will translate them >.> |
| 19:41 | chobbs | SELECT concat('<a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=',biblio.biblionumber,'">',biblio.title,'</a>') as title, biblio.author FROM biblioitems JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) WHERE ExtractValue(marcxml, '//datafield[@tag="942"]/subfield[@code="n"]')='Y' AND items.holdingbranch=<<holdingbranch|branches>> |
| 19:41 | cait | wizzyrea: thats a good idea too! |
| 19:42 | no, it's not working | |
| 19:42 | hmhmhm, it did work for my report, let me dig it up | |
| 19:44 | chobbs: and your report works without the placeholder? | |
| 19:45 | chobbs: no items in my test database... | |
| 19:48 | can you try <<something>> instead of the branches version? that was what I used for the borrowernumber | |
| 19:49 | bankhead left #koha | |
| 19:50 | * Brooke | needs to feed the cat before she's disowned. |
| 19:51 | cait | lol |
| 19:51 | ok, do that | |
| 19:51 | gmcharlt | Brooke: your cat sounds unusually tolerant ;) mere disownment? |
| 19:51 | cait | I am still trying to get the report with placeholder work |
| 19:52 | wizzyrea | was gonna say, I'd probably get excrement in my clean laundry for that. |
| 19:52 | * Brooke | knows the cat is secretly a RM. |
| 19:52 | wizzyrea | sorry, that might have been a bit graphic. |
| 19:53 | Clearsky joined #koha | |
| 19:55 | Clearsky | can anyone tell me what sort of encryption is used on the password field for the borrowers table? |
| 19:55 | Brooke | ta folks, world of workcraft time |
| 19:55 | Brooke left #koha | |
| 19:56 | Clearsky | I"m writing an app in PHP that will need to add records to the koha database |
| 19:56 | gmcharlt | Clearsky: it's just an MD5 hash |
| 19:56 | Clearsky | ok thats interesting, the table I'm looking at has all 22 character hashes |
| 19:57 | thanks for the quic answer | |
| 19:57 | cait | chobbs: select * from items where holdingbranch = <<branch|branches>> |
| 19:57 | works perfect for me, displaying on the screen | |
| 19:57 | gmcharlt | Clearsky: sorry, more precisely it's a md5_base64 value as computed by Perl's Digest::MD5 |
| 19:57 | Clearsky | ok thanks! |
| 20:00 | Clearsky left #koha | |
| 20:00 | owen left #koha | |
| 20:22 | saorge left #koha | |
| 20:23 | saorge joined #koha | |
| 20:26 | jcamins | Time to close up. |
| 20:26 | Good night, #koha | |
| 20:26 | jcamins is now known as jcamnis_a | |
| 20:26 | wizzyrea | gnite jcamnis_a |
| 20:26 | jcamnis_a is now known as jcamins_a | |
| 20:27 | * jcamins_a | clearly needs the weekend... |
| 20:29 | cait | good night jcamins |
| 20:33 | chris | ok, time to deal with the kids |
| 20:33 | bbl | |
| 20:33 | wizzyrea | gl |
| 20:35 | cait | good night all :) |
| 20:35 | jcamins++ #for grep commands :) | |
| 20:35 | cait left #koha | |
| 20:39 | CGI935 left #koha | |
| 20:41 | chobbs | how do i tell munin to tell cait something later? |
| 20:41 | wizzyrea | type "@later tell cait whateveryouwanttotellher" |
| 20:41 | no quotes | |
| 20:42 | chobbs | @later tell cait Thanks for the help. I realized why my report wasn't working. |
| 20:42 | munin | chobbs: The operation succeeded. |
| 20:42 | chobbs | wizzyrea: thanks! |
| 20:42 | wizzyrea | \o/ |
| 20:42 | yw ;) | |
| 20:50 | wasabi left #koha | |
| 20:50 | chobbs | Must be Friday afternoon/evening - got quiet in here :) |
| 20:51 | phb_ joined #koha | |
| 20:51 | phb left #koha | |
| 20:52 | wasabi joined #koha | |
| 21:09 | schuster left #koha | |
| 21:20 | trea left #koha | |
| 21:21 | Nopal joined #koha | |
| 21:26 | clearsky joined #koha | |
| 21:27 | clearsky | can KOHA stop someone with an expired account from logging in? |
| 21:28 | wizzyrea | it's not an acronym :/ |
| 21:29 | clearsky | yeah sorry. do you know the answer though? |
| 21:29 | wizzyrea | I don't actually, but I can test it |
| 21:30 | clearsky | I've got database access but not access to the actual platform. |
| 21:30 | wizzyrea | hehe, let me check |
| 21:30 | clearsky | I just didn't know if there was a configuration someone that could change that |
| 21:30 | gmcharlt | clearsky: the answer is no - the expiration date affects circulation privileges, but not logging in |
| 21:30 | clearsky | thanks |
| 21:30 | ok thanks for the info | |
| 21:31 | is there a way to disable accounts? | |
| 21:31 | other than changing the password | |
| 21:41 | clearsky left #koha | |
| 21:45 | brendan | @wunder 93117 |
| 21:45 | munin | brendan: The current temperature in Northwest Goleta, Goleta, California is 24.8�C (2:59 PM PDT on November 05, 2010). Conditions: Clear. Humidity: 42%. Dew Point: 11.0�C. Pressure: 29.89 in 1012.1 hPa (Steady). |
| 22:08 | ivanc joined #koha | |
| 22:16 | rhcl_away left #koha | |
| 22:40 | dafydd left #koha | |
| 22:41 | mib_mike left #koha | |
| 22:51 | Nopal left #koha | |
| 22:52 | chris_n | @wunder 28334 |
| 22:52 | munin | chris_n: The current temperature in Dunn, North Carolina is 8.9�C (7:05 PM EDT on November 05, 2010). Conditions: Mostly Cloudy. Humidity: 43%. Dew Point: -3.0�C. Windchill: 9.0�C. Pressure: 29.41 in 995.8 hPa (Rising). Freeze watch in effect from late Saturday night through Sunday morning... |
| 22:52 | brendan | heya chris_n |
| 22:52 | chris_n | ooooOO |
| 22:52 | evening brendan | |
| 22:53 | * chris_n | lights a fire |
| 22:53 | brendan | seet |
| 22:53 | sweet | |
| 22:53 | catch you later than - enjoy that fire | |
| 23:09 | bigbrovar left #koha | |
| 23:10 | bigbrovar joined #koha | |
| 23:12 | ivanc left #koha | |
| 23:28 | chobbs left #koha | |
| 23:51 | fredericd left #koha |
← Previous day | Today | Next day → | Search | Index