![http://02varvara.files.wordpre[…]no-bear.jpg?w=800](http://02varvara.files.wordpress.com/2011/04/01-how-about-no-bear.jpg?w=800){kind=link}
← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 00:18 | mib_chnxgi joined #koha | |
| 00:31 | BigRig_ joined #koha | |
| 00:46 | kathryn joined #koha | |
| 01:09 | barriers joined #koha | |
| 01:25 | melia joined #koha | |
| 01:51 | barriers joined #koha | |
| 02:55 | qu-bit_ joined #koha | |
| 03:11 | barriers joined #koha | |
| 03:34 | clrh_ joined #koha | |
| 03:37 | qu-bit_ joined #koha | |
| 03:37 | thd-away` joined #koha | |
| 03:37 | moodaepo joined #koha | |
| 03:37 | logbot joined #koha | |
| 03:37 | Manderson joined #koha | |
| 03:37 | fredericd joined #koha | |
| 03:37 | khall joined #koha | |
| 03:50 | huginn joined #koha | |
| 03:58 | trea left #koha | |
| 04:25 | Oak joined #koha | |
| 04:26 | * Oak | waves |
| 04:26 | barriers joined #koha | |
| 04:26 | druthb | Hi, Oak! |
| 04:32 | Oak_ joined #koha | |
| 04:34 | barriers joined #koha | |
| 05:07 | thd-away joined #koha | |
| 05:08 | barriers joined #koha | |
| 05:11 | Oak joined #koha | |
| 05:21 | barriers joined #koha | |
| 05:29 | Oak_ joined #koha | |
| 06:26 | trea joined #koha | |
| 06:27 | cait joined #koha | |
| 06:27 | trea left #koha | |
| 06:36 | cait | good morning #koha |
| 06:41 | magnuse | hiya cait and #koha |
| 06:46 | cait | hiya magnuse |
| 06:46 | magnuse | @wunder boo |
| 06:46 | huginn | magnuse: The current temperature in Bodo, Norway is 1.0°C (7:20 AM CET on January 03, 2013). Conditions: Partly Cloudy. Humidity: 75%. Dew Point: -3.0°C. Windchill: -4.0°C. Pressure: 29.33 in 993 hPa (Steady). |
| 06:59 | cait | @wunder Konstanz |
| 06:59 | huginn | cait: The current temperature in Taegerwilen, Taegerwilen, Germany is -0.8°C (7:55 AM CET on January 03, 2013). Conditions: Mostly Cloudy. Humidity: 96%. Dew Point: -1.0°C. Windchill: -1.0°C. Pressure: 30.57 in 1035 hPa (Rising). |
| 07:02 | magnuse | wow, 200 attendees at the meeting in portugal! |
| 07:14 | cait | nice :) |
| 07:23 | rangi | evening |
| 07:24 | cait | evening rangi |
| 07:40 | lms joined #koha | |
| 07:44 | rangi | hi lms |
| 07:45 | cait left #koha | |
| 07:47 | reiveune joined #koha | |
| 07:47 | reiveune | hello |
| 07:52 | magnuse | kia ora rangi |
| 07:52 | ...and reiveune and lms | |
| 07:55 | lms left #koha | |
| 07:55 | asaurat joined #koha | |
| 08:01 | Joubu joined #koha | |
| 08:01 | Joubu left #koha | |
| 08:05 | lds joined #koha | |
| 08:26 | barriers joined #koha | |
| 08:51 | kf joined #koha | |
| 09:00 | H joined #koha | |
| 09:01 | H | All a happy year (in and out Koha) |
| 09:02 | asaurat | yeah!! happy new year :) |
| 09:14 | kf | Happy new year :) |
| 09:17 | lds joined #koha | |
| 09:23 | druthb_mobile joined #koha | |
| 09:23 | JesseM joined #koha | |
| 09:39 | trea joined #koha | |
| 09:43 | trea left #koha | |
| 09:51 | gerundio | good morning |
| 09:51 | "An error has occurred. Thank you for your patience. | |
| 09:51 | Error accessing /var/www/Pootle/po/38/pt/pt-PT-pref.po, Filesystem sent error: Permission denied" | |
| 09:52 | still getting a permission denied error while trying to download translation files (http://translate.koha-communit[…]ref.po/download/) | |
| 09:52 | paul_p joined #koha | |
| 09:53 | vfernandes joined #koha | |
| 09:53 | vfernandes joined #koha | |
| 09:54 | vfernandes | hello all |
| 09:54 | kf | gerundio: I think druthb_away has to fix that, maybe drop her a mail |
| 09:55 | gerundio | good morning vfernandes |
| 09:57 | kf, have no ideia what her mail address his :| | |
| 09:57 | vfernandes | hi gerundio... yesterday I saw what maybe is a bug |
| 09:58 | gerundio | vfernandes, tell me about it |
| 09:58 | vfernandes | gerundio: go to your OPAC, do a search and check your refine search facets |
| 09:58 | look at authors... there is a double comma | |
| 09:59 | I think it's that Koha is putting a extra comma in the tt file | |
| 09:59 | gerundio | I see, always a double comma yes |
| 09:59 | vfernandes | in my 3.8 happens the same thing |
| 10:00 | I don't know if in 3.8 with MARC21 the same happens | |
| 10:01 | kf | vfernandes: is that for unimarc or marc21? |
| 10:01 | gerundio: you can see on bugzilla :) | |
| 10:01 | gerundio | kf, it's UNIMARC |
| 10:01 | and thanks for the tip on bz | |
| 10:03 | kf | vfernandes: I am about to answer your mail on updating translation files |
| 10:04 | vfernandes | kf: thanks.... it's a UNIMARC installation |
| 10:05 | barriers joined #koha | |
| 10:10 | kf | vfernandes: mail sent :) |
| 10:11 | vfernandes | thanks kf |
| 10:13 | i will do it later... now it's time for XSLT | |
| 10:13 | lolol | |
| 10:13 | kf | fun :) |
| 10:17 | barriers joined #koha | |
| 10:19 | gerundio | is there any way to bulk update datelastseen for biblio items? |
| 10:20 | kf | I think you could maybe do it using the batch functionality |
| 10:20 | but not sure if the field is available there | |
| 10:20 | or using the inventory module and a barcode file | |
| 10:20 | or update in items via sql and do a complete reindex | |
| 10:26 | H | fighting with nullmailer here annyne had smtp: Failed: 550 5.7.1 Unable to relay |
| 10:27 | gerundio | kf, the Batch item modification feature doesn't allow the update of the datelastseen field :| |
| 10:27 | not sure what you mean with "inventory module and a barcode file", could you add some detail to that please? | |
| 10:29 | I found the Inventory/Stocktaking under Tools, I guess that's what you meant, right? | |
| 10:30 | kf | yep :) |
| 10:30 | it's supposed to update the date last seen when you do the inventory, so I thought it could work - but not sure what you want to do | |
| 10:30 | gerundio | that's exactly what I want to do |
| 10:31 | I'll read the documentation on this feature to better understand it | |
| 10:31 | but I think this might do just what we want :) | |
| 10:31 | kf | I haven't used it so far, only did some testing for sign-offs |
| 10:31 | gerundio | thanks a lot for the help |
| 10:31 | kf | np :) |
| 10:33 | magnuse | kf++ |
| 10:33 | barriers joined #koha | |
| 10:41 | barriers joined #koha | |
| 10:51 | vfernandes | magnuse or kf are you using 3.8 and MARC21? |
| 10:51 | I want to check if the double comma in the authors facets are a bug or not | |
| 10:52 | magnuse | vfernandes: 3.8 yes, marc21 no :-( |
| 10:52 | kf | 3.6 and MARC21 |
| 10:56 | vfernandes | ok... can you send me a link to your OPAC? |
| 10:57 | kf | we have lots :) |
| 10:58 | as an example | |
| 11:06 | thd-away` joined #koha | |
| 11:14 | barriers joined #koha | |
| 11:17 | vfernandes | ok in that there isn't the double comma problem |
| 11:18 | kf | maybe it's unimarc specific |
| 11:18 | vfernandes | maybe... i would like to check a 3.8 installation with MARC21 |
| 11:23 | gerundio | vfernandes, try some on this list: http://wiki.koha-community.org[…]sers/NorthAmerica |
| 11:23 | I tried the Toronto Friends (Quaker) Library at http://tmm.xxvii.net/ | |
| 11:24 | on the notes it states it's using v3.8 | |
| 11:24 | I assume those installations are using MARC21 | |
| 11:24 | kf | gerundio: if you are not sure about the version, check the source code |
| 11:24 | gerundio | there's no double comma issue there |
| 11:24 | kf | the version is always noted in a comment on top |
| 11:25 | gerundio | Koha 3.0804000 on that one |
| 11:25 | kf | cool :) |
| 11:25 | gerundio | how can I tell if it's MARC21 or UNIMARC? |
| 11:25 | kf | hm |
| 11:25 | from the data I think | |
| 11:25 | look at the marc view or export as marcxml | |
| 11:25 | marc21 has the title in 245 | |
| 11:25 | unimarc in 200 I think? | |
| 11:26 | vfernandes | yes |
| 11:26 | unimarc title is field 200 | |
| 11:26 | kf | I think you might see it on the detail paes too, as they are different, but not sure where the differences are |
| 11:26 | for america it should be marc21 tho | |
| 11:27 | vfernandes | yes, the link that gerundio said is MARC21 |
| 11:28 | i'm looking at the code of facet building... | |
| 11:29 | kf | be careful |
| 11:29 | could be dangerous :) | |
| 11:29 | gerundio | kf, the title field does the trick, that installation has the title at 245 indeed |
| 11:30 | vfernandes, http://lawlibrary.in.gov/ is also 3.8 MARC21 | |
| 11:30 | same thing, just a single comma | |
| 11:30 | vfernandes | { idx => 'au', label => 'Authors', tags => [ qw/ 700ab 701ab 702ab / ], sep => ', ', }, |
| 11:30 | this is on Koha.pm | |
| 11:30 | barriers joined #koha | |
| 11:31 | vfernandes | the problem is the sep |
| 11:31 | * kf | nods |
| 11:31 | kf | the code was not too long ago changed to make it posible to include different fields and different subfields |
| 11:31 | it might be that it was forgotten to change that then | |
| 11:32 | vfernandes | the problem is the following: 7XXa in UNIMARC is filled with "SURNAME," |
| 11:33 | and when the separator is "," there will be a double comma | |
| 11:34 | should I fill a bug and send a patch? | |
| 11:34 | kf | vfernandes: of course :) |
| 11:36 | vfernandes | the patch is extra small... is only to change the sep to ' ' instead of ', ' |
| 11:36 | but first I will confirm with a librarian if 70Xa if always filled with a comma | |
| 11:45 | kf | hm german library statistic asks for the number of searches in the opac. hm. |
| 11:48 | WaylonR joined #koha | |
| 11:48 | WaylonR | hiya all! |
| 11:48 | kf | hi WaylonR |
| 11:48 | happy new year :) | |
| 11:48 | WaylonR | Happy new year to all. |
| 11:50 | Okay, my question of the day, koha 3.0.0, how do i make biblios with Titles with the search term in them, appear before purely keyword results, with the search term not in the title? | |
| 11:50 | We are getting complaints of non-relevance, even though its the keywords that is matching, not the title. | |
| 11:51 | or is this search ranking feature, only a possiblity in later versions? | |
| 11:52 | vfernandes | bug 9341 - solved :) |
| 11:52 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9341 major, P1 - high, ---, vfernandes, Needs Signoff , Problem with UNIMARC authors facets |
| 11:53 | kf | WaylonR: you might want to talk to jcamins_away about relevance ranking |
| 11:53 | search rewrite? | |
| 11:53 | wahanui | somebody said search rewrite was http://wiki.koha-community.org[…]earch_Rewrite_RFC |
| 12:01 | vfernandes | i would like to see bug 1993 solved... :P |
| 12:01 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=1993 enhancement, P3, ---, sophie.meynieux, Failed QA , Task Scheduler Needs Re-write |
| 12:03 | gerundio | vfernandes, have you looked at the suggestions on the 3.8 translations? |
| 12:03 | I submitted one a while ago | |
| 12:03 | and I see there are a few more waiting for moderation | |
| 12:05 | vfernandes | for me it's quickly to change than do moderation |
| 12:05 | I know that are many suggestions but it's almost impossible to do moderation :/ | |
| 12:07 | but when I was doing the translation I used many suggestions | |
| 12:10 | there is around 900 suggestions in OPAC | |
| 12:10 | 9 in staff | |
| 12:11 | * 6 in staff | |
| 12:12 | 83 in prefs - in this I think that the suggestions aren't that good | |
| 12:14 | by the way how it's possible to reject/accept suggestions? | |
| 12:14 | :D | |
| 12:19 | barriers joined #koha | |
| 12:21 | jwagner joined #koha | |
| 12:21 | gerundio | don't really know, I guess you just copy + paste it and click submit |
| 12:22 | btw, how can we use the Add comment feature | |
| 12:22 | I clicked it, inserted the text but then I don't know how to save it | |
| 12:22 | vfernandes | that's what I do |
| 12:22 | kf | vfernandes: about 1993 - if you added a test plan this could move on |
| 12:23 | vfernandes | copy paste and submit |
| 12:23 | kf yes I added.. | |
| 12:23 | kf | and about suggestions |
| 12:23 | you go to the review page | |
| 12:23 | look for the link to the list of suggestions there | |
| 12:23 | then there is an x and a... check thing you can click to moderate | |
| 12:23 | it will automatically copy the suggestion into the field when you accept | |
| 12:24 | and delete the suggestion when you x it | |
| 12:24 | you need permission to moderate suggestions to do so | |
| 12:24 | and to see them, the options | |
| 12:24 | if that's the problem we can fix it I think :) | |
| 12:25 | gerundio | vfernandes, there are some suggestions that really don't make sense to me too |
| 12:26 | kf, about the "Add Comment", how do we make it stick there? :) | |
| 12:28 | kf | hm? |
| 12:28 | sorry, brb | |
| 12:28 | and does one of you see the red/green buttons for moderating suggestions? | |
| 12:35 | nengard joined #koha | |
| 12:36 | vfernandes | no |
| 12:36 | gerundio | I see the X button on my suggestion only |
| 12:37 | I thought vfernandes would see it, as I thought is was the pt-PT translation moderator | |
| 12:38 | lunchtime now | |
| 12:38 | see you guys later | |
| 12:40 | kf | vfernandes: i can check that, give me a moment |
| 12:41 | we are talking about portugese, right? | |
| 12:48 | vfernandes: still around? | |
| 12:50 | vfernandes | yes |
| 12:51 | can we talk later, i'm going out for lunch... | |
| 12:51 | kf | ah, I have the admin panel open |
| 12:51 | was pt right? | |
| 12:51 | vfernandes | yes |
| 12:51 | kf | what's your user name on pootle? |
| 12:51 | vfernandes | vfernandes |
| 12:53 | kf | i will take a look |
| 12:53 | go get your lunch :) | |
| 12:58 | barriers joined #koha | |
| 13:01 | kf | @later tell vfernandes I gave you permissions - now you can review suggestions - use your new power with wisdom :) |
| 13:01 | huginn | kf: The operation succeeded. |
| 13:04 | kf | @later tell druthb I gave vfernandes permissions for pt language in pootle :) |
| 13:04 | huginn | kf: The operation succeeded. |
| 13:08 | druthb | :) |
| 13:14 | oleonard joined #koha | |
| 13:15 | oleonard | Hi #koha |
| 13:15 | kf | hi druthb and oleonard :) |
| 13:16 | druthb | :) Hi, oleonard. :) |
| 13:22 | kf | barriers is making me nervous |
| 13:26 | trea joined #koha | |
| 13:27 | barriers joined #koha | |
| 13:30 | magnuse | kia ora oleonard trea barriers |
| 13:30 | druthb | kia ora, magnuse! |
| 13:33 | jcamins | WaylonR: there is nothing you can do about relevance ranking. |
| 13:33 | magnuse | hiya druthb |
| 13:33 | hiya jcamins | |
| 13:33 | druthb | Hi, jcamins! |
| 13:34 | WaylonR | jcamins, this is relevance ranking im refering to? |
| 13:34 | jcamins | Yes. |
| 13:34 | WaylonR | does relevance ranking exist in current koha? |
| 13:35 | jcamins | Not in any useful way, no. |
| 13:35 | search rewrite? | |
| 13:35 | wahanui | hmmm... search rewrite is http://wiki.koha-community.org[…]earch_Rewrite_RFC |
| 13:35 | jcamins | Once the relevance-related portions of that are fully-funded I will fix it. |
| 13:36 | WaylonR | what about in zebra? |
| 13:36 | jcamins | What about Zebra? |
| 13:36 | WaylonR | relevance searching? |
| 13:36 | via zebra? | |
| 13:37 | jcamins | Koha uses Zebra. |
| 13:37 | WaylonR | i mean, could i hardcode some CCL to do it? |
| 13:37 | jcamins | No. |
| 13:37 | Well... I suppose if you were crazy you could. | |
| 13:38 | But you know how I've been right every time you've asked about taking a shortcut? | |
| 13:38 | WaylonR | Well, it'll be a kludge only mandumah.com would use. |
| 13:39 | but how much would mandumah.com would have to pay you, to do the relevance related portions? | |
| 13:39 | jcamins | You can look at C4::Search::_build_weighted_query, but that is the extent of the time I'm spending on helping you screw up your system. |
| 13:39 | To do it properly? | |
| 13:39 | WaylonR | yes. |
| 13:40 | jcamins | That's item 1(f) on the search rewrite, which is priced at $6,000. |
| 13:40 | WaylonR | hmmmmm... |
| 13:41 | Im guessing its expert level code, and you already have a rough idea of how to do it yes? | |
| 13:41 | jcamins | It requires a nearly complete rewrite of C4::Search. |
| 13:42 | Which is why I am so certain that trying to kludge a fix into 3.0 can only result in misery. | |
| 13:42 | WaylonR | wow. yeah.. something i have no idea where to start. Will CCL based queries still work after all of it? |
| 13:42 | jcamins | Yes and no. |
| 13:42 | kf | WaylonR: you could turn it off and go back to sort by publication year. |
| 13:42 | in 3.0. | |
| 13:43 | * oleonard | wonders why his system is showing German descriptions for some preferences, French for others |
| 13:43 | kf | but helping to fund a proper fix would be better :) |
| 13:43 | oleonard: that sounds unfun? | |
| 13:43 | jcamins | oleonard: to improve your language skills? :) |
| 13:43 | oleonard | Something is messed up with the pref files |
| 13:43 | WaylonR | hmmm... so doing like "branch: blah or branch: blah" will still work? |
| 13:43 | magnuse | oleonard: i have seen that too, when nb-NO is the active language |
| 13:43 | jcamins | Just as with right now, directly-entered CCL (ccl=...) queries would bypass relevancy. |
| 13:43 | Yes. | |
| 13:44 | WaylonR | and can that work, with relevancy? |
| 13:44 | so (search params) order by relevancy? | |
| 13:44 | jcamins | Though, per bug 9233 I think "branch:blah || branch:blah" is better. |
| 13:44 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9233 enhancement, P5 - low, ---, jcamins, NEW , Use unambiguous boolean operators for searches |
| 13:44 | oleonard | magnuse: Looks like I was in en-NZ instead of en. Hard to tell with Bug 9339 in effect. |
| 13:44 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9339 minor, P5 - low, ---, koha-bugs, NEW , Intranet translation bar display en-GB when en is selected |
| 13:45 | jcamins | WaylonR: yes. |
| 13:45 | If the only search is on branch:, though, I don't really see how relevancy ranking would help. | |
| 13:47 | It'd be more useful for something like "books && (branch:blah || branch:blah2)" | |
| 13:51 | WaylonR | thats what i mean, term + branch or branches limits order by relevancy |
| 13:56 | jcamins | Yep. Right now the way we do relevancy is... somewhere between absurd and insane. With the search rewrite, I will adjust the relevancy to work more like one would expect, where titles and authors _really_ receive higher priority, and have it easily configurable using a configuration file. |
| 13:57 | * magnuse | wishes he had lots of money to throw at jcamins |
| 13:57 | jcamins | I have a separate component in the search rewrite that would allow the librarian to configure relevance in the staff interface, which might be very helpful in your case. |
| 13:58 | kf | magnuse: me too |
| 13:59 | WaylonR | hmmm..... so for the relevancy and its related config interface, how much would you require? |
| 14:00 | jcamins | Without the staff interface portion, the relevancy work would be $6k. The staff interface portion would be an additional $6k. |
| 14:01 | WaylonR | Could you email me something I could forward to my boss? I might be able to get you the funds. |
| 14:01 | jcamins | Sure. |
| 14:03 | edveal joined #koha | |
| 14:03 | magnuse | WaylonR++ |
| 14:03 | kf | oleonard: I got a jquery question... do you have a second? |
| 14:04 | oleonard | yes |
| 14:06 | kf | do you think it's possible? maybe just could pase out the links and put that back... |
| 14:06 | WaylonR | email sent, jcamins |
| 14:07 | barriers joined #koha | |
| 14:07 | kf | WaylonR++ :) |
| 14:07 | jcamins | WaylonR: received. I will send you a proposal. |
| 14:08 | WaylonR | thankyou muchly, jcamins |
| 14:10 | oleonard | kf: I think maybe grabbing the links you want and reformatting the whole thing might be better |
| 14:11 | kf | oleonard: trying to do that now... but still kinda stuck. |
| 14:11 | talljoy joined #koha | |
| 14:12 | kf | could you throw some keywords at me? like which functions you would use? |
| 14:12 | jcamins | kf: trout. Knitting. Garlic. Copper. |
| 14:12 | kf | jcamins: :P |
| 14:12 | oleonard | kf: You're trying to remove any link which contains "read me?" |
| 14:12 | kf | yes |
| 14:12 | I got that bit | |
| 14:13 | but the || don't look so nice | |
| 14:13 | $(".online_resources a:contains('Read me')").remove(); | |
| 14:13 | francharb joined #koha | |
| 14:15 | oleonard | kf: Do you have code that copies the online resources link to the holdings tab? |
| 14:15 | kf | yes |
| 14:16 | but that's just moving the complete element around | |
| 14:16 | libsysguy joined #koha | |
| 14:18 | kf | hmm |
| 14:18 | let me try something | |
| 14:19 | oleonard | kf: What I was thinking was that you could use .each() to loop over the links in the .online_resources span and put the links you want into a new array or string to output |
| 14:19 | kf | yep |
| 14:19 | I was thiking that too, butnot sure about the right syntax | |
| 14:20 | trying to figure it out | |
| 14:20 | never used .each() so far :) | |
| 14:22 | oleonard++ :) | |
| 14:27 | JesseM joined #koha | |
| 14:28 | H joined #koha | |
| 14:29 | H | Does annyone know where i can change the list in the opac for Browse by author or subject |
| 14:31 | oleonard | H: Change the list? Do you mean change the text of the link? |
| 14:31 | wahanui | oleonard: that doesn't look right |
| 14:32 | wahanui joined #koha | |
| 14:32 | H | ehm change the possibilities |
| 14:32 | define the field i wanna be searched | |
| 14:33 | jcamins | H: the "Browse by author or subject" page is for browsing authorities only. |
| 14:33 | H | can i hide it ? |
| 14:34 | jcamins | Sure. Disable OpacAuthorities. |
| 14:34 | H | i was looking at that button as you typed |
| 14:39 | my authors are in field 700 how do i get them in the authoreties ... | |
| 14:39 | or do i move them to an other field ? | |
| 14:39 | jcamins | 700 fields are authority-controlled. |
| 14:39 | H | wrong field ? |
| 14:39 | i still can move them so | |
| 14:39 | jcamins | You just need to create authority records for them -- assuming you don't already have -- and run the linker. |
| 14:40 | Why would you move them? | |
| 14:40 | 700 fields are used for authors. | |
| 14:40 | H | dont get the authority concept yet |
| 14:40 | jcamins | Ah. |
| 14:41 | Authorities are records that describe particular entities. | |
| 14:41 | In this case, authors. | |
| 14:41 | H | ok |
| 14:42 | jcamins | Authority-controlled fields in bibliographic records can be linked to authorities for better colocation. |
| 14:42 | H | and how do i create them ore where do i find the info |
| 14:43 | jcamins | Usually you would download authority records from somewhere else- OCLC or the like. |
| 14:44 | If you don't have an OCLC account, you can also tell Koha to generate authority records for you when you edit bibliographic records. | |
| 14:44 | H | aha |
| 14:44 | jcamins | However, Koha does not have a bulk authority generator. |
| 14:44 | H | i just imported 50000 records out off my old system |
| 14:45 | jcamins | You may not need authorities at all. |
| 14:45 | trea joined #koha | |
| 14:46 | H | thx for informing me now i have a starting point |
| 14:46 | jcamins | What was your old system? |
| 14:46 | It might have authority records you can use. | |
| 14:47 | H | ehm a sort off home made system by people who asked too much money for it (IMIS) |
| 14:47 | :OP | |
| 14:48 | jcamins | Ah... yeah, they probably won't be using authorities. |
| 14:48 | francharb joined #koha | |
| 14:48 | H | i got a database dumb and made marc records from it + the koha item fields (with some perls script and it is all imported) ... looks good ... still need toi get the ldap and mail ok |
| 14:52 | ill post the link whenn we go public ... i probably need to register myself on the site somewhere (no time untill now) maybe in the future there's something i can do to help the community (afther the koha is up and running :) public) | |
| 14:55 | vfernandes | back :) |
| 14:55 | po for portuguese prefs is still in error.... :/ | |
| 14:57 | kf | oleonard++++ :) |
| 14:57 | jcamins | druthb: ping |
| 14:57 | druthb | eh? |
| 14:57 | kf | vfernandes: I can't fix that - druthb will have to - but check out the suggestions, it should make more sense now :) |
| 14:57 | vfernandes | ok thanks kf for all the help |
| 14:57 | kf++ | |
| 15:12 | kf | khall: around? |
| 15:12 | khall | what's up kf? |
| 15:12 | kf | looking at your video |
| 15:13 | what time is it for you? | |
| 15:13 | khall: all I can tell you is that my system was 1 hour off | |
| 15:13 | jcamins | 10:13ish. |
| 15:14 | kf | we are currently in daylight savings I think - my timezone is 'berlin', if that helps to test |
| 15:15 | i double checked, because I thought it was very odd too, and can only retest when I get home later | |
| 15:15 | and you are only looking at the due date in your video - the problem is in today's date - at the top of the slip | |
| 15:15 | khall | so, when you test it you get different times listed on circulation.pl and on the slip, right? |
| 15:15 | kf | nope |
| 15:15 | the today's date on top of the slip is wrong | |
| 15:16 | khall | oh, I see now. |
| 15:16 | kf | that doesn't appear in circulation.pl |
| 15:16 | oh good :) | |
| 15:16 | khall | I was focusing on the wrong thing. |
| 15:17 | kf | I am sorry for that |
| 15:18 | khall | no prob, that's why I made the video ; ) |
| 15:18 | kf | :) |
| 15:18 | we should have tried talking it out earlier | |
| 15:18 | next time :) | |
| 15:19 | khall | What's odd is for me, my server is set to 10:17 AM, and the time I'm seeing is 3:18 PM |
| 15:19 | I'll start digging | |
| 15:21 | jcamins | khall: are all the times being converted to UTC? |
| 15:22 | khall | Could be, I'll find out seen enough |
| 15:27 | kf | khall: if you want, split out <<today>> changes to a separate bug, if that helps |
| 15:28 | lds joined #koha | |
| 15:28 | kf | but we should fix it too - because that is just weird. |
| 15:30 | jcamins | Possibly relevant: timezone detection in Javascript: https://bitbucket.org/pellepim/jstimezonedetect |
| 15:34 | khall | jcamins, you were correct. The time zone was never being set, so it was defaulting to UTC |
| 15:34 | new patch on the way | |
| 15:35 | kf | yay :) |
| 15:35 | khall | up and ready for testing |
| 15:36 | kf | I will try to take a look later tonight and sign off - if someone else beats me to it I will qa it instead ;) |
| 15:41 | khall | excellent! |
| 16:03 | reiveune | bye |
| 16:03 | reiveune left #koha | |
| 16:23 | asaurat left #koha | |
| 16:27 | qu-bit joined #koha | |
| 16:34 | talljoy1 joined #koha | |
| 16:42 | rambutan joined #koha | |
| 16:42 | rambutan | wahanui: pastebin? |
| 16:42 | wahanui | i think pastebin is at http://paste.koha-community.org/ |
| 16:43 | kf left #koha | |
| 17:06 | melia joined #koha | |
| 17:07 | thd-away joined #koha | |
| 17:08 | khall joined #koha | |
| 17:08 | thd-away joined #koha | |
| 18:11 | rangi | Morning |
| 18:11 | wahanui | it has been said that Morning is a state of mind. or whenever the cat wants breakfast. |
| 18:14 | magnuse | kia ora rangi |
| 18:30 | vfernandes | OPAC do 3.10 fully translated to portuguese :) |
| 18:30 | jcamins | vfernades++ |
| 18:30 | vfernandes++ | |
| 18:31 | rangi | Yay! |
| 18:31 | jcamins | My fingers are too cold to type, sorry. |
| 18:31 | rangi | Post on koha.pt? :) |
| 18:32 | Seems like koha is becoming very popular in Portugal | |
| 18:32 | cait joined #koha | |
| 18:32 | vfernandes | I think I can't post there because i need company authorization first |
| 18:34 | rangi | Ahh |
| 18:34 | vfernandes | yes very popular because of the economy... open source software are a cheaper solution because no licenses associated. |
| 18:34 | rangi | No fees anyway :) |
| 18:35 | Strong licenses ;) | |
| 18:35 | jcamins | khall: /tmp is a ramdisk under a normal Debian install. |
| 18:35 | vfernandes | yes i think you understand what I wanted to say :P |
| 18:36 | khall | didn't know that, thanks jcamins! |
| 18:36 | jcamins | khall: yeah, that's why wajasu and I had so much trouble with Zebra indexes. |
| 18:39 | khall: http://en.wikipedia.org/wiki/Tmpfs | |
| 18:39 | cait joined #koha | |
| 18:41 | jcamins | khall: and if you're crazy you can do some really bizarre things with tmpfs+lxc. |
| 18:43 | rambutan | tmpfs is used for lots of things |
| 18:43 | tmpfs 3966720 39776 3926944 2% /dev/shm | |
| 18:44 | tmpfs 3966720 0 3966720 0% /sys/fs/cgroup | |
| 18:44 | tmpfs 3966720 708 3966012 1% /var/run | |
| 18:44 | tmpfs 3966720 708 3966012 1% /var/lock | |
| 18:45 | jcamins | I hadn't realized that /dev/shm was implemented with tmpfs. Tht's pretty cool. |
| 18:45 | rambutan | at least on opensuse :) |
| 18:48 | rangi | jcamins: http://photos.bigballofwax.co.[…]/album11/DSC01796 |
| 18:50 | jcamins | That's Koha green? :) |
| 18:50 | rangi | one of the greens we used |
| 18:52 | rambutan | koha.org??? |
| 18:52 | wahanui | the first rule of Koha is that you don't talk about koha.org |
| 18:52 | rambutan | yea, well, there's a pic in that collection |
| 18:52 | rangi | from 2005 |
| 18:53 | rambutan | yea, I assumed past use-by date |
| 18:53 | booth right beside Dynix | |
| 18:55 | rangi | yep i made shirts to annoy them for 2006 |
| 18:55 | rambutan | that's a cool green box. I could put 5 Pis in there, with a power supply, and have a little mini cluster |
| 18:55 | rangi | http://gallery.katipo.co.nz/lianza2006/img_1454 |
| 18:56 | jcamins | Nice! |
| 19:01 | ibooter joined #koha | |
| 19:01 | ibooter | wanna attack your friends internet ? Strong Booter ! i b o o t e r . t k Join Now And Start Attacking! |
| 19:01 | ibooter left #koha | |
| 19:02 | oleonard | Uh... Okay. |
| 19:06 | rangi | why would you attack your friend? |
| 19:06 | i think they need a dictionary | |
| 19:07 | oleonard | That's to make it legal. "all in good fun!" |
| 19:07 | jcamins | lol |
| 19:09 | "But investigator, I had a drink with my victim the other day. That makes it totally okay to hack into all the servers between me and them." | |
| 19:09 | qu-bit joined #koha | |
| 19:30 | rangi | wahanui: we should use more MARC? |
| 19:30 | wahanui | http://02varvara.files.wordpre[…]no-bear.jpg?w=800 |
| 19:31 | rangi | hmm another error with pootle |
| 19:31 | is druthb about? | |
| 19:31 | jcamins | lol |
| 19:31 | druthb | sort of. |
| 19:31 | cait | I think it#s always the same |
| 19:31 | something aobut file permissions :( | |
| 19:31 | rangi | yep |
| 19:31 | druthb | hm. lemme get in there and see if I can spot it. |
| 19:31 | rangi | thanks |
| 19:35 | druthb | try now, rangi n cait? |
| 19:35 | rangi | ah it wasnt me, it was a couple of mails on the koha-translate list |
| 19:36 | druthb | I'll send a note. |
| 19:36 | rangi | awesome |
| 19:39 | trea left #koha | |
| 19:45 | cait | druthb: I will test arabic |
| 19:45 | druthb | I tested pt, and it was working. |
| 19:45 | cait | druthb: there is also a bug on bugzilla - I added you to the cc list ealrier today |
| 19:45 | druthb | I got that bug. |
| 19:46 | cait | looks good to me |
| 19:50 | barriers joined #koha | |
| 19:54 | wizzyrea | faq? |
| 19:54 | wahanui | faq is probably found at http://koha-community.org/documentation/faq/ |
| 19:58 | wizzyrea | also, good morning |
| 19:59 | jcamins | Good morning. |
| 20:00 | oleonard | Hi wizzyrea, got your msg |
| 20:01 | That's new territory to me, so I don't have anything in particular to recommend | |
| 20:02 | jcamins | rangi: hey, don't you have the student program coming up soon? |
| 20:02 | rangi | nexxt week |
| 20:02 | wizzyrea and cjh_ are doing it | |
| 20:02 | jcamins | Do you know what they'll be working on? |
| 20:02 | wizzyrea | ok cool oleonard, just didn't want to |
| 20:02 | jcamins | Woohoo! |
| 20:02 | wizzyrea | step on anything |
| 20:02 | :) | |
| 20:02 | jcamins | wizzyrea: do you know what they'll be working on? |
| 20:02 | wizzyrea | we will be working on intranet accessibility |
| 20:02 | jcamins | I'll nudge the QA team if there are any outstanding patches that should be pushed before they arrive. |
| 20:04 | wizzyrea | oleonard: http://www.w3.org/TR/wai-aria-[…]tices/#kbd_layout this is I think where we are going to be doing some of our work |
| 20:04 | going through circ/member management | |
| 20:05 | cjh_ | good morning :) |
| 20:05 | wizzyrea | and defining/labeling the regions |
| 20:05 | magnuse | wizzyrea: very cool! |
| 20:05 | wizzyrea | at least, that's what I've got in my mind |
| 20:06 | rangi | its 80s rock friday |
| 20:06 | http://www.youtube.com/watch?v=raql_Hh_NmU | |
| 20:07 | put your headphones and crank the dial up | |
| 20:07 | qu-bit joined #koha | |
| 20:08 | wizzyrea | we missed weird wednesday |
| 20:08 | rangi | yep |
| 20:08 | cjh_ | random food friday |
| 20:08 | wizzyrea | \o/ |
| 20:09 | rangi | this song is 2 years older than cjh_ |
| 20:10 | there i just made you all feel old | |
| 20:10 | you're welcome | |
| 20:10 | cjh_ | hahaha |
| 20:11 | jcamins | When did it come out? |
| 20:11 | rangi | 89 |
| 20:11 | jcamins | Okay, I feel old. |
| 20:11 | druthb | cjh_ is a *youngling*, then. |
| 20:11 | This song was #1 the week I was born: https://www.youtube.com/watch?v=bE1dz6_u2JI | |
| 20:12 | oleonard | The trouble with feeling old is that you can only complain about it to people your own age. |
| 20:12 | rangi | there are much worse songs |
| 20:13 | cait | hm six years older than me... htat's still not sooo bad |
| 20:13 | oh, younger. | |
| 20:13 | cjh_ | fire woman isnt anywhere near as bad as I had expected :) |
| 20:13 | cait | hmpf. |
| 20:13 | rangi | heh |
| 20:13 | cait | hehe |
| 20:13 | * rangi | ponders what other music his parents used to tell him to turn down |
| 20:15 | * wizzyrea | is slightly younger than you, goes for Pearl Jam and Soundgarden |
| 20:15 | rangi | ohh sisters of mercy |
| 20:15 | http://www.youtube.com/watch?v=-o-6ftmw8CE | |
| 20:16 | oleonard | Never was a fan, but I did see them in concert in the 90s |
| 20:17 | druthb | oooh....sisters of mercy...mmmm |
| 20:17 | * cjh_ | was raised on Queen and Meat loaf |
| 20:17 | oleonard | I was practically asphyxiated by the smoke machine |
| 20:17 | wizzyrea | >.< |
| 20:17 | rangi | heh |
| 20:19 | early chili peppers? | |
| 20:20 | wizzyrea | always good. |
| 20:20 | cjh_ | oh wow they were 80s? |
| 20:20 | wizzyrea | ^.^ |
| 20:20 | rangi | yep |
| 20:20 | cjh_ | wikipedia agrees :o |
| 20:21 | * wizzyrea | is not an authority on 80's rock. |
| 20:21 | * druthb | switches to even older stuff.... |
| 20:21 | rangi | http://www.youtube.com/watch?v=0MBljztEeg0 |
| 20:22 | druthb | Cass Elliott in her white go-go boots...gotta love it. |
| 20:22 | https://www.youtube.com/watch?v=N-aK6JnyFmk | |
| 20:26 | liw | wait, what? the 80s are over? we're in the 90s already? I feel old now |
| 20:26 | rangi | hmm im still in the 80s |
| 20:26 | http://www.youtube.com/watch?v=ad37pR8lrEo | |
| 20:27 | this one really annoys parents | |
| 20:27 | wizzyrea | uh oh, I'm going to be one of THOSE parents. |
| 20:27 | "TURN THAT #$%@ DOWN" | |
| 20:28 | rangi | heh |
| 20:28 | * wizzyrea | goes back to her (slightly later) chilli peppers. |
| 20:29 | wizzyrea | i am pretty sure there is no parent alive that would tell you to turn down "soul to squeeze" |
| 20:29 | rangi | do it do it do it do it |
| 20:29 | gotta love rollins | |
| 20:29 | specially rollins and shatner! | |
| 20:29 | wizzyrea | he's actually quite a good artist/poet person |
| 20:29 | if you leave off the shouting. | |
| 20:29 | rangi | cant get behind that |
| 20:29 | wizzyrea | (but just m/o) |
| 20:29 | rangi | http://www.youtube.com/watch?v=q-eJQ1mTVzA |
| 20:29 | wizzyrea | lol |
| 20:33 | oleonard | http://www.youtube.com/watch?v=I5xyuT9MgRs |
| 20:34 | rangi | oooh |
| 20:34 | i can get behind that | |
| 20:37 | oleonard | Unfortunately this is a year too late to count: https://www.youtube.com/watch?v=reSOp1domrU |
| 20:37 | rangi | http://www.youtube.com/watch?v=qcG8oNfpih8 |
| 20:37 | ahh good old sonic youth | |
| 20:37 | cjh_ | i can't get behind htat is fantastic |
| 20:38 | but my typing isnt :( | |
| 20:45 | JDatTeTakere joined #koha | |
| 20:51 | trea joined #koha | |
| 20:54 | cjh_ | drats, all my favourite queen songs are 70s. Defeated. |
| 20:54 | dpavlin | I'm having problems with currency exchange rates with current master acqui/invoices.pl - is there existing bug I can look at? |
| 20:54 | wizzyrea | what kind of problem? |
| 20:56 | dpavlin | currency_rate in html page gets default currency exchange (1.0) from GetCurrency (active currencry, HRK 1.0) but |
| 20:56 | * cait | waves at dpavlin and wishes him and mglavica a happy new year :) |
| 20:57 | dpavlin | Vendor price is in USD, so all javascript updated fields gets overwritten with USD values except of Actual cost which stays in HRK |
| 20:58 | since there is Replacement cost: (adjusted for HRK) it should stay in HRK and not get rewritten by USD values, right? | |
| 20:59 | wizzyrea | hm I haven't heard of this particular thing |
| 21:00 | cait | not sure I get it :( |
| 21:00 | dpavlin | this behavior was introduced by Bug 5335 from Fri Feb 24 16:24:05 2012 +0100 so it's pretty old... |
| 21:00 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5335 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , define VAT/taxes at orderline level, with default value for supplier and list of valid tax rates |
| 21:00 | cait | hm |
| 21:00 | wonder about the date | |
| 21:00 | I was quite sure that's a 3.10 feature | |
| 21:01 | rangi | yeah |
| 21:01 | it was only pushed 21/september | |
| 21:01 | so is in only in master and 3.10.x | |
| 21:01 | wizzyrea | well 8832 is fixed |
| 21:02 | cait | wowthere are lots of bugs linked to it :( |
| 21:03 | dpavlin | I get that for Receive shipment from vendor when entering Accounting Details |
| 21:05 | I think it should use vendor price currency for exchange rate, and not default currency, it's that simple :-) | |
| 21:05 | rangi | i agree, that bug should probably be reverted |
| 21:06 | jcamins | rangi: unfortunately, looking at the history it looks like I might not be able to. |
| 21:06 | dpavlin | rangi: or I can fix it in another bug? We see a few more texes regressions, but it should be fixable. |
| 21:07 | rangi | dpavlin: fixing is the next best option |
| 21:07 | cjh_ | if it is too difficult to revert, then a linked bug is clean. |
| 21:07 | JDatTeTakere | Well, it's that time of month again where I'm running reports showing last year's issue stats...and they are telling me fibs. |
| 21:07 | jcamins | I would favor reverting, except I don't think I'll be able to. |
| 21:07 | rangi | but i agree with jcamins that regressions should be reverted first, fixed after |
| 21:07 | but yeah if you cant revert then fixing is the next best thing | |
| 21:07 | jcamins | It should've been reverted in September, per the note on the bug. |
| 21:07 | rangi | *nod* |
| 21:07 | jcamins | I'll try reverting tonight. |
| 21:08 | rangi | thanks |
| 21:09 | cjh_ | jcamins: may the force be with you. |
| 21:09 | jcamins | cjh_: thanks. I think I'll need it. |
| 21:09 | cait | jcamins: it shuffles around a lot of acq data |
| 21:09 | not sure it's easy to rever, wlel pretty sure it isn't | |
| 21:10 | jcamins | I just looked. |
| 21:10 | cait | and you will lose data if you revert now and have been using it |
| 21:10 | wizzyrea | probably better to fix :/ |
| 21:10 | dpavlin | generally, we really like new acquisition, so reverting that might not be the best way to go. |
| 21:10 | cait | oh i am confusing it |
| 21:10 | with parcels. | |
| 21:10 | jcamins | There's no merge commit, so I wouldn't be able to revert it safely even if reversion wouldn't cause data loss. |
| 21:11 | dpavlin | we quite like other exchange rates features of it :-) |
| 21:11 | cait | I like the idea too, not necessarily the change to the syspref |
| 21:11 | but being able to set tax on order level is kind of important here | |
| 21:11 | jcamins | It looks like about a dozen patches interspersed over several days worth of commits. |
| 21:12 | dpavlin: A patch on a separate bug would be most welcome. :) | |
| 21:13 | rangi | i dont mind the idea, but its a shame it wasnt reverted back on 28/9 |
| 21:13 | and fixed and re pushed | |
| 21:13 | jcamins | Yup. |
| 21:14 | rangi | revert early .. and save everyone tons of hassle |
| 21:15 | jcamins | That's why --no-ff is so important. |
| 21:16 | eythian | what is --no-ff? |
| 21:16 | rangi | no fast forward |
| 21:16 | cjh_ | no fastforward for git merge, why is it important? |
| 21:16 | rangi | makes a merge commit |
| 21:16 | eythian | oh right |
| 21:16 | rangi | then you can revert the merge |
| 21:16 | cjh_ | oh so a merge commit is easier to revert? |
| 21:16 | rangi | well it reverts the 8 commits |
| 21:17 | instead of havin to do each one | |
| 21:17 | (if there were 8 in the branch) | |
| 21:17 | jcamins | Without it, you have to revert each one individually, which makes the history a mess. |
| 21:17 | cjh_ | ahh, whereas with ff they appear in the same line (as if they were developed on the branch) |
| 21:17 | * oleonard | can't seem to find a time when Bug 9339 didn't exist |
| 21:17 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9339 minor, P5 - low, ---, koha-bugs, NEW , Intranet translation bar display en-GB when en is selected |
| 21:17 | jcamins | Exactly. |
| 21:17 | cjh_ | makes sense, I always wondered why ff was hated so much. ty :) |
| 21:17 | jcamins | oleonard: I'm not sure it ever worked. I'd never used en-GB before. |
| 21:17 | I don't understand why ff is the default. | |
| 21:18 | wizzyrea | because merge commits are confusing. |
| 21:18 | is my guess. | |
| 21:18 | jcamins | wizzyrea: but how many times do people use "git merge"? |
| 21:18 | eythian | ff makes sense when you're working on your own repo. Merge commits clutter things up a lot, in general. |
| 21:18 | * oleonard | quits with the intention of being productive tomorrow, for real this time |
| 21:18 | wizzyrea | bye oleonard |
| 21:22 | * wizzyrea | just opened the dash, saw the quote "And before that I used the garden of razorblades that is OpenBSD" |
| 21:22 | wizzyrea | which made me laugh. |
| 21:23 | nengard left #koha | |
| 21:23 | wizzyrea | crikey you guys are funny. |
| 21:23 | cjh_ | hah! queensryche are 80s!! http://www.youtube.com/watch?v=adtE2H7sXJM (1988) |
| 21:29 | rangi | http://www.youtube.com/watch?v=E-WHW-QNswE <-- 1984 |
| 21:30 | wizzyrea | oh you are evil. |
| 21:30 | rangi | hehe |
| 21:30 | i dedicate this to ibeardslee and cjh_ who both do karate | |
| 21:30 | * cjh_ | watches |
| 21:31 | cjh_ | hahahha I know this song \o/ |
| 21:31 | cait | gema :( |
| 21:31 | wizzyrea | http://www.youtube.com/watch?v=rwer1CiteBg |
| 21:31 | take that. | |
| 21:31 | rangi | cjh_: you know the movie its the theme for eh? |
| 21:32 | cjh_ | rangi: http://www.youtube.com/watch?v=oomCIXGzsR0 :) |
| 21:32 | best childhood movie, miyagi is awesome | |
| 21:32 | rangi | wizzyrea: http://www.youtube.com/watch?v=LPsz5C4SED8 |
| 21:32 | * cait | can't listen to any of those :( |
| 21:32 | rangi | i upped the ante! |
| 21:33 | rambutan joined #koha | |
| 21:34 | wizzyrea | LOOL |
| 21:34 | i bow to you sir. | |
| 21:34 | cjh_ | hahha eye of the tiger, oh god. |
| 21:34 | wizzyrea | also, 1982 |
| 21:34 | * cjh_ | is a few videos behind |
| 21:34 | wizzyrea | ;) |
| 21:36 | I was hoping this was the 80's, but 1977: http://www.youtube.com/watch?v=-ZKhpbfR-LE | |
| 21:37 | rangi | http://www.youtube.com/watch?v=Ym6W-xSa3Ls <-- better |
| 21:37 | wizzyrea | oh yes, that really captures the spirit of that particular bucket list item |
| 21:47 | JDatTeTakere | Sorry to intrude ;-) Koha question for you guys. |
| 21:47 | wizzyrea | go for it :) |
| 21:48 | JDatTeTakere | I'm trying to find all items without a barcode using this report I found in the Koha Reports Library - SELECT items.dateaccessioned,items.ccode,items.itemcallnumber,items.itype,biblio.author,biblio.title, biblio.copyrightdate FROM items LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) LEFT JOIN biblio ON (biblioitems.bib |
| 21:48 | I'm getting the following error "The following error was encountered: The database returned the following error: 1 Please check the log for further details." | |
| 21:48 | wizzyrea | that's the exact report? |
| 21:49 | because that one is incomplete :) | |
| 21:49 | JDatTeTakere | Ahhh...I got it from http://wiki.koha-community.org[…]uts_by_Item_Type_.28previous_month.29 |
| 21:50 | wizzyrea | SELECT items.dateaccessioned,items.ccode,items.itemcallnumber,items.itype,biblio.author,biblio.title, biblio.copyrightdate |
| 21:50 | FROM items | |
| 21:50 | LEFT JOIN biblioitems ON (items.biblioitemnumber=biblioitems.biblioitemnumber) | |
| 21:50 | LEFT JOIN biblio ON (biblioitems.biblionumber=biblio.biblionumber) | |
| 21:50 | WHERE Barcode IS NULL | |
| 21:50 | JDatTeTakere | but further down that page...it's not the report I was looking for but I wanted to try it anyway as I came across a book yesterday that I couldn't issue because the Item barcode was entered in the call number field...so wanted to see if there were any others. |
| 21:50 | cait_ joined #koha | |
| 21:51 | rangi | you don't need the biblioitems, you arent selecting anything from it |
| 21:51 | but it wont hurt | |
| 21:51 | wizzyrea | it works |
| 21:51 | rangi | just slows the query down some |
| 21:51 | wizzyrea | that one I pasted. |
| 21:51 | JDatTeTakere | Fantastic - thanks guys. |
| 21:51 | rangi | i might do this |
| 21:52 | WHERE ( barcode IS NULL OR barcode = '') | |
| 21:52 | * wizzyrea | gets ready to edit the wiki |
| 21:53 | JDatTeTakere | My other problem is that our monthly issues report tells me that issues of MP (Rental Magazines) but we know they |
| 21:56 | cjh_ | http://www.youtube.com/watch?v=aqAUmgE3WyM |
| 21:56 | wizzyrea | JDatTeTakere: also, if you have a space in front of a report |
| 21:56 | when you put it in, you'll get that message. | |
| 21:56 | eythian | cjh_: one day I shall build one of those |
| 21:56 | JDatTeTakere | Thanks Liz...I'll know to look out for spaces in future problem reports. |
| 21:57 | wizzyrea | just thought I'd mention it, as I just had it happen to me :) |
| 21:57 | (*&($#@$# why isn't this working... oh | |
| 21:57 | :D | |
| 21:57 | JDatTeTakere | I'm happy to benefit from any little bits of knowledge you can share. |
| 21:57 | eythian | someone needs to sponsor the tiny patch it would take to fix that stupid query issue. |
| 21:59 | JesseM_away left #koha | |
| 21:59 | wizzyrea | I updated that report on the wiki to get rid of the unnecessary bits. |
| 21:59 | I suspect there are quite a few like that. | |
| 22:03 | mib_kk1c73 joined #koha | |
| 22:04 | JDatTeTakere | Fantastic...I try out a few of the reports from the Koha Reports Library. It 'sometimes |
| 22:04 | It sometimes helps me to learn how queries are built. | |
| 22:37 | wizzyrea | JDatTeTakere: did you have another issue with your reports? |
| 22:47 | JDatTeTakere | Just trying to work out why the Issues report say our Rental Magazines haven't been out, when we know they have. |
| 22:47 | wizzyrea | ahh |
| 22:47 | rangi | which report are you using? |
| 22:48 | wizzyrea | haha I about typed that exact thing. Also, are you using the built in reports or a created sql one |
| 22:50 | rangi | i get 3688 issues of rental magazines in 2012 |
| 22:51 | JDatTeTakere | I'm using a Saved Report - the one that shows all of our issues. We run the same report each month. |
| 22:53 | wizzyrea | oh, can you paste it in? |
| 22:53 | paste.koha-community.org | |
| 22:56 | pastebot | "JDatTeTakere" at 127.0.0.1 pasted "Our monthly issues report - concerned that the data is incorrect. It's not showing MP issues." (8 lines) at http://paste.koha-community.org/334 |
| 22:56 | JDatTeTakere | Have done. On leave now for rest of day but will check my messages later. Thanks C and L. |
| 22:57 | wizzyrea | cool, is np :) |
| 22:57 | have a lovely afternoon! | |
| 22:59 | kathryn joined #koha | |
| 23:04 | trea joined #koha | |
| 23:05 | edveal left #koha | |
| 23:08 | AndyPT joined #koha | |
| 23:08 | AndyPT | Hi |
| 23:08 | wahanui | privet, AndyPT |
| 23:08 | AndyPT | Hello, wahanui |
| 23:08 | wahanui | hey, AndyPT |
| 23:08 | thd-away` joined #koha | |
| 23:09 | jcamins | wahanui is a bot. |
| 23:09 | AndyPT | Yep, the "hey" gave it away... |
| 23:09 | eythian | wahanui: jcamins is also a spoilsport |
| 23:09 | wahanui | okay, eythian. |
| 23:09 | AndyPT | I have a question |
| 23:09 | jcamins | Hey! |
| 23:09 | eythian | hey, jcamins |
| 23:09 | wahanui | 'scuse me while I cue up "Hail to the Chief!" |
| 23:09 | AndyPT | (are you all bots!?!??!) |
| 23:10 | eythian | yes. |
| 23:10 | AndyPT | Duh |
| 23:10 | rambutan | "someone needs to sponsor the tiny patch it would take to fix that stupid query issue." What query issue? |
| 23:10 | wizzyrea | the one that causes the sql reports to barf if a space is at the beginning of the quer |
| 23:10 | eythian | rambutan: if you have a space at the front of the SQL in a report, the report fails. |
| 23:10 | wizzyrea | query |
| 23:10 | * wizzyrea | thinks that the different way we answered that question says something about our personalities |
| 23:11 | wizzyrea | ^.^ |
| 23:11 | eythian | heh |
| 23:11 | rambutan | rambutan wonders how much tiny patches cost these days... |
| 23:11 | AndyPT | So, for anyone not a bot, I have a question: on Koha saved reports (SQL or guided), I'm trying to download them to CSV or TAB (bottom dropdown list), and any Unicode/UTF-8 character looks bad, because the export does not include a UTF-8 BOM.... |
| 23:11 | eythian | rambutan: not a great deal :) |
| 23:12 | AndyPT: the BOM shouldn't be required in UTF-8, I think | |
| 23:14 | In fact, I'll clarify that: the BOM is not required and is arguably detrimental in UTF-8 :) | |
| 23:14 | jcamins | eythian: it is if your text editor won't allow you to force the character set. But that's a problem with the editor not the file. |
| 23:15 | eythian | yeah. If there's something reasonably common that requires it, it might be worth implementing it anyway. |
| 23:16 | I have encountered it breaking things that should be unicode-aware though. But that may have been a dodgy parser I was using. | |
| 23:16 | cait | AndyPT: what problems are you having? I am using libreoffice / excel at work ant it works nicely for umlauts |
| 23:17 | and which version of Koha are you looking at? | |
| 23:21 | AndyPT | eythian and cait: I don't really care for the BOM (if I'm the one using it). The thing is, my librarian staff need to export the report to excel, and using CSV that's not working. Is there any plugin to add "download to Excel" format? |
| 23:22 | eythian and cait : I'm currently using 3.8 | |
| 23:22 | cait | excel is a bit stupid. |
| 23:22 | eythian | I don't have excel, but perhaps there's some setting for the default character set? Dollars to doughnuts it's coming is as latin-1 or something. |
| 23:22 | cait | the only way I managed to do it is like this: https://wiki.bsz-bw.de/lib/exe[…]s_exportieren.pdf |
| 23:23 | beware, it's german, but it has screenshots | |
| 23:24 | eythian: my bet too - you have to explicitly tell it to use unicode (utf-8) | |
| 23:24 | AndyPT | My users need excel... |
| 23:24 | cait | AndyPT: it works |
| 23:24 | it's just a matter of using the right settings | |
| 23:25 | AndyPT | I'm downloading it... |
| 23:25 | cait | choose tab separated |
| 23:25 | open excel | |
| 23:25 | import from text | |
| 23:25 | then make sure you choose utf-8 as encoding | |
| 23:26 | hit ok ok ok... and then it should be there | |
| 23:26 | AndyPT | Ehhhhhhhhhhhhhhhhhhhhhh.... This is really too much for my users... I need something "dumb proof"... |
| 23:26 | cait | you shoul dinstall libreoffice then. |
| 23:26 | wizzyrea | ^^ |
| 23:27 | jcamins | Yeah, LibreOffice is much easier. |
| 23:27 | AndyPT | Is there no option to add Excel export to the list (other than changing the source code, which I don't want to do until I upgrade to 3.10) ? |
| 23:27 | jcamins | No. |
| 23:27 | How would you get the Excel spreadsheet? | |
| 23:28 | (remember, Excel uses a proprietary closed-source file format) | |
| 23:28 | AndyPT | Well, a lot of applications export it |
| 23:28 | jcamins | There are libraries that have reverse-engineered it. |
| 23:28 | AndyPT | And Excel 2007++ uses OOXML, which is standard and open |
| 23:28 | rangi | bwahaha |
| 23:28 | eythian | hahahah |
| 23:28 | good one :) | |
| 23:28 | cait | lol |
| 23:28 | AndyPT | I'm fine with OOXML |
| 23:28 | rangi | best joke of 2013 |
| 23:29 | jcamins | rangi: it's a high bar. |
| 23:29 | * wizzyrea | is not sure which definition of open you are using |
| 23:29 | jcamins | ! |
| 23:29 | AndyPT | Yes, XLSX is simply XML inside a ZIP containter |
| 23:29 | jcamins | Anyway, I see no chance of any current Koha developer writing an Excel export into the system just because. |
| 23:29 | AndyPT | Creating an XLSX file is easy programming... |
| 23:29 | * eythian | challenges you to implement the "displaylikeoffice2001" attribute :) |
| 23:30 | AndyPT | ? |
| 23:30 | jcamins | You could commission a feature like that, though. |
| 23:30 | That's the great thing about open source. | |
| 23:30 | * wizzyrea | invokes wilw |
| 23:30 | wizzyrea | ;) |
| 23:32 | sup libsysguy | |
| 23:32 | AndyPT | Ok, so no known plugin to add any type of download formats other than CSV and TAB? |
| 23:32 | libsysguy | wizzyrea, not a lot |
| 23:32 | whats up with you | |
| 23:32 | wizzyrea | nope, no plugins for that. |
| 23:33 | eythian | it would be an easy patch to add the BOM if that would solve it. |
| 23:33 | AndyPT | Weird... I'm sure a lot of people must have needed it... |
| 23:33 | wizzyrea | naw, they just learn to work with CSV |
| 23:33 | or tab | |
| 23:33 | AndyPT | Yep, my solution is currently to add the BOM... |
| 23:33 | libsysguy | thats the weird thing about assumptions :p |
| 23:33 | AndyPT | :S |
| 23:33 | eythian | hey, anyone able to point me to a reference for the usmarc binary format. It's come to the point where I need to know how it works. |
| 23:34 | wizzyrea | ping gmcharlt ^^ |
| 23:34 | gmcharlt | AndyPT: well, writing something that uses Spreadsheet::WriteExcel::Big will get you XLS output (and Evergreen's reporter does that for "Excel" output) |
| 23:35 | eythian | ah, wikipedia has an OK breakdown. |
| 23:35 | wizzyrea | hehe well I was thinking about eythian's question actually |
| 23:35 | gmcharlt | eythian: I have the ISO standard in my posession, but ... it certainly isn't worth any amount of money |
| 23:35 | eythian | this marc data has no directory section, it's unparsable. |
| 23:36 | gmcharlt | wizzyrea: I'm multi-tasking ;) |
| 23:36 | wizzyrea | \o/ |
| 23:36 | eythian | gmcharlt: according to ISO it's worth CHF58,00. |
| 23:36 | they may be lying though. | |
| 23:36 | jcamins | eythian: ISO is not known for their ability to count to zero... |
| 23:36 | gmcharlt | eythian: trust me, it's not worth that much :) |
| 23:37 | even if one accepts ISO's business model, it's a poorly-written standard | |
| 23:37 | eythian | http://ebookbrowse.com/iso-270[…]08-pdf-d307980860 <-- *cough* |
| 23:37 | * gmcharlt | whistles innocently |
| 23:38 | wizzyrea | interesting: http://www.ftc.gov/opa/2013/01/google.shtm |
| 23:38 | eythian | hey, it's the second result on google :) |
| 23:38 | * wizzyrea | giggles |
| 23:38 | AndyPT | gmcharlt: Adding a BOM to it seems much simpler ;) |
| 23:38 | whistles innocently | |
| 23:39 | * wizzyrea | laughs |
| 23:39 | eythian | ah yes, microsoft has been claiming they are being unfairly treated by google and that they're finding it hard to compete. |
| 23:39 | I guess if anyone would know, it'd be them. | |
| 23:39 | wizzyrea | ikr :) |
| 23:41 | eythian | wow, 58,00fr for a 16 page document, of which the first 6 are boilerplate, so are the last 3. |
| 23:42 | rambutan | fr? |
| 23:42 | wahanui | rumour has it fr is the same in nb-NO and en |
| 23:42 | eythian | swiss francs, I can't remember the proper symbol |
| 23:43 | rambutan | ah, I was thinking (French) francs |
| 23:43 | jcamins | chf |
| 23:43 | dpavlin | thanks everybody and happy new year! Bug 9346 will unblock our acquisition migration to master, so I hope you will enjoy this new year present also :-) |
| 23:43 | huginn | 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=9346 critical, P5 - low, ---, koha-bugs, NEW , acqui/neworderempty.pl ignores exchange rates and destroys user data on page load |
| 23:46 | rambutan left #koha | |
| 23:53 | AndyPT joined #koha | |
| 23:56 | AndyPT | eythian + cait + gmcharlt : changing the source to add a new export type with BOM seems easy enough. I'll just do that ;) |
| 23:56 | eythian | it's probably something that's safe enough to upstream, too. |
| 23:57 | qu-bit_ joined #koha |
← Previous day | Today | Next day → | Search | Index