Time Nick Message 00:29 jenkins_koha Project master_maria build #145: SUCCESS in 44 min: http://jenkins.koha-community.org/job/master_maria/145/ 00:29 jenkins_koha * Mirko Tietgen: Bug 9295: Introduce operator equal/ notequal to OAI set mapping instead of hardcoded 'equal' value. 00:29 jenkins_koha * Galen Charlton: Bug 9295: DBRev 3.13.00.025 00:29 jenkins_koha * Jonathan Druart: Bug 10602: Set default value for authority fields via the framework 00:29 jenkins_koha * Bernardo Gonzalez Kriegel: Bug 10602: (follow-up) to remove tabs 00:29 jenkins_koha * Galen Charlton: Bug 10602: DBrev 3.13.00.026 00:29 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9295 enhancement, P5 - low, ---, mirko, Pushed to Master , Introduce operator equal/ notequal to OAI set mapping instead of hardcoded 'equal' value 00:29 jenkins_koha * Chris Hall: bug 10365: change routing slips to use date published rather than planned date 00:29 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10602 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , Set a default value for authorities 00:29 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10365 enhancement, P5 - low, ---, chrish, Pushed to Master , Using published date on routing slips 01:07 jenkins_koha Yippie, build fixed! 01:07 jenkins_koha Project Koha_master build #1439: FIXED in 1 hr 37 min: http://jenkins.koha-community.org/job/Koha_master/1439/ 01:07 jenkins_koha * Jared Camins-Esakov: Bug 5202: merge authorities from the authority file and reservoir 01:07 jenkins_koha * Jared Camins-Esakov: Bug 5202: QA follow-up: quiet warnings 01:07 jenkins_koha * Jared Camins-Esakov: Bug 5202: QA follow-up 2 - fix overeager error message 01:07 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5202 new feature, P5 - low, ---, jcamins, Pushed to Master , Merge authority records 01:07 jenkins_koha * Jared Camins-Esakov: Bug 5202: (follow-up) Quiet warning 01:07 jenkins_koha * Jared Camins-Esakov: Bug 5202: QA follow-up - improve merge reference selection 01:07 jenkins_koha * Jared Camins-Esakov: Bug 5202: QA follow-up - correct license and POD errors 01:07 jenkins_koha * Galen Charlton: bug 5202: (follow-up) adjust for the move of the merge record Javascript 01:07 jenkins_koha * Galen Charlton: bug 5202: (follow-up) tweak display of merge action link on staged batch page 01:07 jenkins_koha * Fridolyn SOMERS: Bug 9282: improve auto-completion for authority record finder 01:07 jenkins_koha * Fridolyn SOMERS: Bug 9282: (follow-up) add authtypecode to authority auto-completion search 01:07 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9282 enhancement, P5 - low, ---, fridolyn.somers, Pushed to Master , authorities auto-completion in mainmainentry 01:07 jenkins_koha * Galen Charlton: Bug 9282: (follow-up) remove log noise caused by authorities/ysearch.pl 01:07 jenkins_koha * Mirko Tietgen: Bug 9295: Introduce operator equal/ notequal to OAI set mapping instead of hardcoded 'equal' value. 01:07 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9295 enhancement, P5 - low, ---, mirko, Pushed to Master , Introduce operator equal/ notequal to OAI set mapping instead of hardcoded 'equal' value 01:07 jenkins_koha * Galen Charlton: Bug 9295: DBRev 3.13.00.025 01:13 jenkins_koha Starting build #1441 for job Koha_master (previous build: FIXED) 01:58 kohan00b hi gang 02:01 kohan00b Can anyone advise on a problem with Koha sending emails? sendmail queue is empty and emails are successfully being sent to library admin on the same Google Apps domain as Koha, but none of our students with emails at other domains are getting the emails 02:02 eythian you'll have to have a look at the mail logs and see what is actually getting sent. 02:05 kohan00b eythian anything in particular I should look for? Nothing jumping out in mail.log 02:06 kohan00b mail.err is empty 02:07 eythian well there's basic questions you need to answer, like do the emails your expecting to get send actually get to your local mail server, and does your local mail server pass them on. 02:07 eythian Without that information, you can't go anywhere. 02:12 huginn New commit(s) kohagit: Bug 10240: DBRev 3.13.00.027 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=280b0df19da1270afdcf74a5c852221eec9b71c4> / Bug 10240: (follow-up) don't display patrons as lost or gone-no-address incorrectly <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=57848b642bd60d9aade05d1c5b66784e9de28698> / Bug 10240: (follow-up) correctly record fines and fix label <http://git.koha-community.org/gitwe 02:26 kohan00b eythian, it says the emails were sent to both the patron and cc'ed to the library account, but only the library account received it 02:26 eythian so the messages left the koha server and were passed along to google? 02:26 kohan00b mail.log for one of these msgs with [IPv6:2607:f8b0:4003:c02::1b], dsn=2.0.0, stat=Sent (OK 1381330459 nk8si4406091obb.76 - gsmtp) 02:27 kohan00b that's how I interpret stat=Sent and gsmtp 02:27 eythian if the message is being sent from Koha, there's nothing that Koha can do. 02:27 kohan00b and weirdly, that example the other email is also on the Google Apps domain 02:28 eythian Make sure that people check their spam folders, and that your from address and DNS is set up correctly to reduce the chance of it being flagged as spam. 02:28 kohan00b I've turned off the bcc function after noticing a couple of these errors: stat=Deferred: 451-4.3.0 Multiple destination domains per transaction is unsupported. 02:29 kohan00b Yeah, I just check that colleagues email - not in the spam folder either. 02:29 eythian you have something wrong in your configuration if you're seeing that. 02:30 kohan00b yup. bugger if I know what, though. 02:30 eythian or perhaps it's a google problem: http://productforums.google.com/forum/#!topic/gmail/PQLLTW1d3DM 02:33 eythian as to why they're not showing up, I don't know. If I were you, I'd stare at logs, send test messages from the server, etc. etc. 02:34 kohan00b eythian yup, that's looking like my day today 02:34 kohan00b Agreed Koha probably not responsible 02:45 jenkins_koha Project Koha_master build #1441: SUCCESS in 1 hr 33 min: http://jenkins.koha-community.org/job/Koha_master/1441/ 02:45 jenkins_koha * Jonathan Druart: Bug 10602: Set default value for authority fields via the framework 02:45 jenkins_koha * Bernardo Gonzalez Kriegel: Bug 10602: (follow-up) to remove tabs 02:45 jenkins_koha * Galen Charlton: Bug 10602: DBrev 3.13.00.026 02:45 jenkins_koha * Chris Hall: bug 10365: change routing slips to use date published rather than planned date 02:45 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10602 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , Set a default value for authorities 02:45 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10365 enhancement, P5 - low, ---, chrish, Pushed to Master , Using published date on routing slips 02:53 jenkins_koha Starting build #1442 for job Koha_master (previous build: SUCCESS) 03:02 jenkins_koha Starting build #146 for job master_maria (previous build: SUCCESS) 03:32 huginn New commit(s) kohagit: Bug 10853: DBrev 3.13.00.028 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=537068f96946831410cc17832724293f5b898e03> / Bug 10853: (follow-up) expand unit tests for C4::Csv <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=567e86d57578ed5209841b58a79092603ad2e828> / Bug 10853: All existing routing to get a CSV should return a MARC csv <http://git.koha-community.org/gitweb/?p=koha.git;a=commi 03:57 jenkins_koha Project master_maria build #146: UNSTABLE in 55 min: http://jenkins.koha-community.org/job/master_maria/146/ 03:57 jenkins_koha * Jared Camins-Esakov: Bug 10240: Offline circulation using HTML5 and IndexedDB 03:57 jenkins_koha * Jared Camins-Esakov: Bug 10240: QA follow-up 03:57 jenkins_koha * Jared Camins-Esakov: Bug 10240: (follow-up) don't delete transactions if auth fails 03:57 jenkins_koha * Jared Camins-Esakov: Bug 10240: (follow-up) fix display issues 03:57 jenkins_koha * Jared Camins-Esakov: Bug 10240: (follow-up) disable logout/set library 03:57 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10240 new feature, P5 - low, ---, jcamins, Pushed to Master , Offline circulation using HTML5 and IndexedDB 03:57 jenkins_koha * Jared Camins-Esakov: Bug 10240: (follow-up) warn when patron's card is expired 03:57 jenkins_koha * Jared Camins-Esakov: Bug 10240: (follow-up) make sure datepicker icons are available offline 03:57 jenkins_koha * Jared Camins-Esakov: Bug 10240: (follow-up) correctly record fines and fix label 03:57 jenkins_koha * Galen Charlton: Bug 10240: (follow-up) don't display patrons as lost or gone-no-address incorrectly 03:57 jenkins_koha * Galen Charlton: Bug 10240: DBRev 3.13.00.027 03:58 jenkins_koha Starting build #147 for job master_maria (previous build: UNSTABLE -- last SUCCESS #145 4 hr 13 min ago) 04:04 huginn New commit(s) kohagit: Bug 10854: DBrev 3.13.00.029 <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=728670f467484f8ec84aa4f9edebf1446f13b912> / Bug 10854: (follow-up) language tweaks <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=412995b52207b66b7e6994d433eca2038bee5686> / Bug 10854: (follow-up) Small changes to the template <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=21b54e7da7dafb90b62cdf0 04:29 jenkins_koha Project Koha_master build #1442: SUCCESS in 1 hr 36 min: http://jenkins.koha-community.org/job/Koha_master/1442/ 04:29 jenkins_koha * Jared Camins-Esakov: Bug 10240: Offline circulation using HTML5 and IndexedDB 04:29 jenkins_koha * Jared Camins-Esakov: Bug 10240: QA follow-up 04:29 jenkins_koha * Jared Camins-Esakov: Bug 10240: (follow-up) don't delete transactions if auth fails 04:29 jenkins_koha * Jared Camins-Esakov: Bug 10240: (follow-up) fix display issues 04:29 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10240 new feature, P5 - low, ---, jcamins, Pushed to Master , Offline circulation using HTML5 and IndexedDB 04:29 jenkins_koha * Jared Camins-Esakov: Bug 10240: (follow-up) disable logout/set library 04:29 jenkins_koha * Jared Camins-Esakov: Bug 10240: (follow-up) warn when patron's card is expired 04:29 jenkins_koha * Jared Camins-Esakov: Bug 10240: (follow-up) make sure datepicker icons are available offline 04:29 jenkins_koha * Jared Camins-Esakov: Bug 10240: (follow-up) correctly record fines and fix label 04:29 jenkins_koha * Galen Charlton: Bug 10240: (follow-up) don't display patrons as lost or gone-no-address incorrectly 04:29 jenkins_koha * Galen Charlton: Bug 10240: DBRev 3.13.00.027 04:29 jenkins_koha Starting build #1443 for job Koha_master (previous build: SUCCESS) 04:34 huginn New commit(s) kohagit: Bug 10689: add regression test <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=f17fab3ed9b4cef1bd8932376fbdc8733d899fab> / Bug 10689: make subscription public note appear when making a new order from a subscr... <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=4ce18e2a86b0af7548caaeaf26f7571d2244e35e> / Bug 10689: make public note appear in subscriptions search <http://git.koha-community.org 04:48 jenkins_koha Yippie, build fixed! 04:48 jenkins_koha Project master_maria build #147: FIXED in 49 min: http://jenkins.koha-community.org/job/master_maria/147/ 04:48 jenkins_koha * Jonathan Druart: Bug 10853: Add DB field export_format.type ('marc' or 'sql'). 04:48 jenkins_koha * Bernardo Gonzalez Kriegel: Bug 10853 - followup to correct tabs 04:48 jenkins_koha * Jonathan Druart: Bug 10853: All existing routing to get a CSV should return a MARC csv 04:48 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10853 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , Create CSV profiles with sql fields 04:48 jenkins_koha * Galen Charlton: Bug 10853: (follow-up) expand unit tests for C4::Csv 04:48 jenkins_koha * Galen Charlton: Bug 10853: DBrev 3.13.00.028 04:48 jenkins_koha * Jonathan Druart: Bug 10854: add ability to export serial claims using CSV profile. 04:48 jenkins_koha * Jonathan Druart: Bug 10854: (follow-up) Small changes to the template 04:48 jenkins_koha * Galen Charlton: Bug 10854: (follow-up) language tweaks 04:48 jenkins_koha * Galen Charlton: Bug 10854: DBrev 3.13.00.029 04:48 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10854 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , Choose a CSV profile for exporting serial claims 04:48 jenkins_koha Starting build #148 for job master_maria (previous build: FIXED) 05:06 dcook Does anyone know if there are plans to move Letters.pm from C4::Dates to Koha::DateUtils? 05:07 dcook I can't remember if I've seen bug reports about the formatting of dates in letters, but I'm sure that wizzyrea and I have at least talked about it... 05:11 cait hm there are a few tihnk 05:11 cait i think i saw one at least 05:11 cait and i think no explicit plans 05:12 cait bug 9084 05:12 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9084 enhancement, P5 - low, ---, mtj, Needs Signoff , Dates in notices should be formatted according to dateformat system preference 05:14 dcook You're amazing, cait :) 05:14 dcook cait++ 05:15 dcook That is precisely what I wanted 05:15 cait i only have a weird memory forbugs 05:16 dcook I would say a phenomenal memory 05:16 dcook :D 05:17 dcook Hmm, I'm not sure I necessarily agree with Mason's approach though 05:17 cait hm haven't taken a look at that one yet 05:18 dcook It'll certainly be handy when it goes through 05:36 jenkins_koha Project master_maria build #148: SUCCESS in 47 min: http://jenkins.koha-community.org/job/master_maria/148/ 05:36 jenkins_koha * Fridolyn SOMERS: Bug 10689: make public note appear in subscriptions search 05:36 jenkins_koha * Fridolyn SOMERS: Bug 10689: make subscription public note appear when making a new order from a subscription 05:36 jenkins_koha * Galen Charlton: Bug 10689: add regression test 05:36 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10689 minor, P5 - low, ---, fridolyn.somers, Pushed to Master , public note does not appear in subscriptions search 05:54 mtompset Greetings and Goodbye. Have a great day, #koha. 06:08 jenkins_koha Project Koha_master build #1443: SUCCESS in 1 hr 38 min: http://jenkins.koha-community.org/job/Koha_master/1443/ 06:08 jenkins_koha * Jonathan Druart: Bug 10853: Add DB field export_format.type ('marc' or 'sql'). 06:08 jenkins_koha * Bernardo Gonzalez Kriegel: Bug 10853 - followup to correct tabs 06:08 jenkins_koha * Jonathan Druart: Bug 10853: All existing routing to get a CSV should return a MARC csv 06:08 jenkins_koha * Galen Charlton: Bug 10853: (follow-up) expand unit tests for C4::Csv 06:08 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10853 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , Create CSV profiles with sql fields 06:08 jenkins_koha * Galen Charlton: Bug 10853: DBrev 3.13.00.028 06:08 jenkins_koha * Jonathan Druart: Bug 10854: add ability to export serial claims using CSV profile. 06:08 jenkins_koha * Jonathan Druart: Bug 10854: (follow-up) Small changes to the template 06:08 jenkins_koha * Galen Charlton: Bug 10854: (follow-up) language tweaks 06:08 jenkins_koha * Galen Charlton: Bug 10854: DBrev 3.13.00.029 06:08 jenkins_koha * Fridolyn SOMERS: Bug 10689: make public note appear in subscriptions search 06:08 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10854 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , Choose a CSV profile for exporting serial claims 06:08 jenkins_koha * Fridolyn SOMERS: Bug 10689: make subscription public note appear when making a new order from a subscription 06:08 jenkins_koha * Galen Charlton: Bug 10689: add regression test 06:08 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10689 minor, P5 - low, ---, fridolyn.somers, Pushed to Master , public note does not appear in subscriptions search 06:08 jenkins_koha Starting build #1444 for job Koha_master (previous build: SUCCESS) 06:20 * magnuse waves 06:24 dac Hey ya magnuse :) 06:26 magnuse hi dac 06:26 * magnuse cheers for bug 10240 06:26 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10240 new feature, P5 - low, ---, jcamins, Pushed to Master , Offline circulation using HTML5 and IndexedDB 06:26 dcook Sweet! 06:26 dcook I've been hoping that one would get through 06:26 * magnuse too 06:27 rangi now it i can circulate totally offline with my firefoxos phone 06:27 magnuse yay! 06:27 dcook :D 06:29 * dcook scans the office...hoping he's not forgetting anything 06:30 magnuse the only thing that bothers me is you have to remember to sync before you loose your internet connection... ;-) 06:30 magnuse or do you? will it work even if you have not synced? just remembering the actions that are made offline? 06:31 magnuse happy pizza day dcook! 06:31 dcook Pizza day? 06:31 dcook Hmm, I like this idea.. 06:31 magnuse friday? 06:31 wahanui friday is pizzaday! 06:32 magnuse w00t! 06:32 dcook Pizza and beer? 06:32 magnuse i'll skip the beer, but feel free! ;-) 06:32 dcook My wife's birthday party is tomorrow then I fly on Sunday O_O 06:33 dcook On that note, I should probably go and do something! (i.e. getting silicon to make a home-made cupcake tower) 06:33 dcook See you on IRC magnuse and see you on...Tuesday/Wednesday, rangi 06:33 dcook You too, cait 06:33 magnuse have fun dcook 06:35 cait :) 06:36 cait very exciting 06:36 * magnuse start researching plane tickets to argentina 06:36 magnuse s/start/starts/ 06:37 reiveune hello 06:37 wahanui niihau, reiveune 06:45 magnuse @wunder boo 06:45 huginn magnuse: The current temperature in Bodo Vi, Norway is 8.0°C (8:00 AM CEST on October 11, 2013). Conditions: Light Rain. Humidity: 90%. Dew Point: 7.0°C. Pressure: 30.05 in 1018 hPa (Rising). 06:45 magnuse @wunder marseille 06:45 huginn magnuse: The current temperature in Marseille, France is 9.0°C (8:30 AM CEST on October 11, 2013). Conditions: Clear. Humidity: 76%. Dew Point: 5.0°C. Pressure: 29.92 in 1013 hPa (Steady). 06:46 magnuse hah! ;-) 06:46 magnuse @wunder reno 06:46 huginn magnuse: Error: No such location could be found. 06:46 magnuse @wunder reno, usa 06:46 huginn magnuse: Error: No such location could be found. 06:46 magnuse @wunder reno, us 06:46 huginn magnuse: Error: No such location could be found. 06:46 alex_a hello 06:46 magnuse @wunder rno 06:46 huginn magnuse: The current temperature in Reno, Nevada is 12.0°C (10:55 PM PDT on October 10, 2013). Conditions: Clear. Humidity: 47%. Dew Point: 1.0°C. Pressure: 29.96 in 1014 hPa (Steady). 06:46 magnuse hiya alex_a 06:53 cait @wunder reno, nevada 06:54 huginn cait: The current temperature in MidTown, Reno, Nevada is 9.6°C (11:45 PM PDT on October 10, 2013). Conditions: Clear. Humidity: 47%. Dew Point: -1.0°C. Windchill: 10.0°C. Pressure: 29.96 in 1014 hPa (Steady). 06:54 cait @wunder Konstanz 06:54 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 4.1°C (8:50 AM CEST on October 11, 2013). Conditions: Light Rain. Humidity: 96%. Dew Point: 3.0°C. Windchill: 4.0°C. Pressure: 29.89 in 1012 hPa (Steady). 06:56 magnuse whoa, those are low temperatures all round 06:59 cait yah :( 06:59 magnuse i somehow thought reno would be summery 06:59 cait well it's warmer than here! 07:00 cait and maybe you can even see the sun outside 07:00 cait we haven't had that happening in 3 days i think 07:00 cait ok, bbl 07:34 kivilahtio is there any documentation about the reservation/hold constraints used in AddReserve? 07:36 kivilahtio or is it dead code? 07:42 jenkins_koha Project Koha_master build #1444: SUCCESS in 1 hr 34 min: http://jenkins.koha-community.org/job/Koha_master/1444/ 09:20 * kf waves 09:20 kivilahtio bye bye 11:19 kivilahtio Is the SIP module an external addition? I propably should extend the UseBranchTransferLimits checks there as well. Can I push patches to the SIP module using the Koha-community git origin? 11:20 kivilahtio the question stands about placing Holds. Generally I feel the need is for mobile applications communicating via SIP 11:20 kivilahtio not sure about SOPAC2 11:24 kf kivilahtio: the sip code you want to extend is in koha 11:24 kivilahtio kf: roger that 11:24 kf and it should already use the api... but you will wnt to check 11:24 kivilahtio kf: need to make test cases for that as well, and the ILSDI 11:24 kf i mean it should not be duplicating the code 11:24 kf but all shoudl be using the API 11:24 kivilahtio it takes me 2-3 times more time to make the test cases 11:24 kf but it's good to check 11:25 kivilahtio kf: Well if the SIP/ILS/Transaction/Hold.pm is included in the source code one could expect them to be used 11:25 kivilahtio but I'll run the tests and see where they hit 11:26 kf testing never hurts 11:26 kivilahtio kf: yeah I totally agree making unit tests is a great practice, especially regarding regression which sucks so badly 11:27 kivilahtio kf: But it is just hard work, especially with my field, where I need to prepare complex data for functionality tests 11:27 kivilahtio 7h for modifications to HoldsQueue modifications 11:27 kivilahtio unit tests 11:27 wahanui unit tests are required for all new routines in C4:: and Koha::. 11:28 kivilahtio but it is a good learning experience to Koha 11:36 mtompset Greetings, #koha. 11:50 kivilahtio Thanks you #Koha, c u next week! 12:07 mtompset Greetings, samueld meliss tcohen. :) 12:07 meliss greetings mtompset 12:07 samueld it's a joke :-) 12:08 mtompset What is a joke? 12:08 * mtompset looks confused. 12:09 samueld excuse but i don't understand what you have written, big headache 12:09 wahanui samueld: Feature not yet implemented 12:19 oleonard Hi #koha 12:19 magnuse hi oleonard 12:40 Shane-S where can i add custom CSS that is loaded into the login. I see it uses login.css, and I tried Staff Client > IntranetUserCSS that didn't make a change 12:44 tcohen morning #koha 12:44 tcohen last working day in cordoba for a couple of weeks! 12:45 kf oh 12:45 kf and yay :) 12:53 Shane-S Reading: http://www.myacpl.org/koha/?p=612 I see there is nothing like OPACUserCSS anyone know if that is a feature request? 12:54 kf Shane-S: sorry, i don#t understand your question 12:55 kf OpacUserCSS is an existing system preference in Koha 12:55 Shane-S kf: Sorry, to customize the staff login screen, there is no custom CSS option like OPAC or Intranet 12:55 kf there is intranetusercss 12:56 kf just search for css in adminsitration, there is a lot 12:56 Shane-S kf: doesn't see to affect the login screen for staff 12:56 kf but not a separate parameter like opacsmallimage - the koha logo on the staff screen says it's koha :) only very few want to custmize here 12:56 Shane-S I did #login{background-color: #80000;} and it had no effect 12:56 kf i don't know if the class is the same 12:56 kf you'd have to look at the source code. 12:56 kf if there is a #login 12:56 kf well 12:57 kf id="login2 12:58 Shane-S when I view source or inspect elements, I come to div#login 12:58 Shane-S and in the CSS #login, has that nice white BG with the border 12:59 Shane-S I will go make a custom CSS, as I have file system access, just felt it should be like OPAC and Intranet 12:59 Shane-S for the few users who want to make a quick simple change without a hack 13:00 Shane-S I eventually want to change the logo as well, so I will probably give it shot as well. 13:04 Shane-S bugs? 13:04 wahanui i think bugs is http://devopsreactions.tumblr.com/post/44776341195/bug-reports-after-a-new-release 13:04 Shane-S requests? 13:04 jcamins bugzilla? 13:04 wahanui it has been said that bugzilla is found at http://bugs.koha-community.org 13:04 Shane-S ty 13:16 mtompset Greetings, oleonard. 13:34 mtompset kf: I was noticing 10937... There was a comment on the bug report suggesting adding a Display in OPAC field. 13:34 kf bug 10937 13:34 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10937 enhancement, P5 - low, ---, philippe.blouin, ASSIGNED , Option to hide and group itemtypes from advanced search 13:35 kf yes, but it seems there feature doe smore 13:35 mtompset I was thinking perhaps OpacHiddenItems could be parsed to see if the item type is blocked? 13:36 kf i think what we wanted was different 13:36 kf better nto tie too much to opachiddenitems 13:36 mtompset True. 13:37 mtompset Particularly, since I like papa's idea of making visibility in OPAC part of the circulation rules. 13:59 tcohen kf: http://snag.gy/JXYP5.jpg 14:06 mtompset Now that's a nice use of diacritics. ;) 14:06 tcohen mtompset: what is nice is that it isn't double encoded ;) 14:07 mtompset YAY! Not double-encoded. I hate when that happens. 14:11 tcohen hmmmmmmm 14:11 tcohen when i create a new item type it doesn't show (master) 14:14 kf tcohen: doesn<#t show or is not saved? :( 14:14 tcohen neither 14:14 tcohen i assume i broke it, until someone confirms 14:14 kf take a look at your logs? 14:14 kf often they are quite telling when that happens 14:15 tcohen oh, my mistake 14:15 wahanui tcohen, your mistake is i'm not deleting the es-ES trnaslation on each iteration 14:15 tcohen heh 14:15 * mtompset laughs. 14:16 mtompset wahanui: forget my mistake 14:16 wahanui mtompset, I didn't have anything matching my mistake 14:16 mtompset wahanui: forget oh, my mistake 14:16 wahanui mtompset, I didn't have anything matching oh, my mistake 14:16 tcohen i'm using a 3.12 db on master 14:20 * mtompset cringes. 14:20 mtompset I hate when an idea is semantically simple, but implementationally difficult. 14:21 gaetan_B hello 14:21 wahanui bonjour, gaetan_B 14:22 tcohen hi gaetan_B 14:22 tcohen kf: http://snag.gy/oq8tP.jpg 14:26 mtompset Hmm... old idea. YAY! However, it would seem that the person who took the bug hasn't done anything with it, and I recall reading the osslabs no longer exists. 14:27 rambutan hi gaetan_B 14:27 rambutan hi mtompset 14:27 tcohen mtompset: what r u talking about? maybe a lag here 14:27 rambutan hi all 14:27 mtompset bug 7567 14:27 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7567 enhancement, P5 - low, ---, ebin.joseph, ASSIGNED , News by Library 14:27 mtompset The idea of branch filtered news. 14:27 tcohen interesting 14:28 wahanui interesting is sometimes good and sometimes bad 14:28 mtompset however, on the linked in group, I discovered that the osslabs is no longer in business. 14:28 tcohen another one: localized notices and letters 14:28 tcohen i'm looking for a sponsor to write it :-D 14:29 mtompset I think I shall take the bug for myself, and work on it. :) 14:30 oleonard Shane-S: Did you get your CSS question answered? 14:30 * oleonard was afk 14:31 Shane-S yeah, I just had to make a file like you said on the blog, I was submitted a bug as a feature request 14:31 Shane-S i /was/did 14:32 Shane-S I sited your blog and also the nice idea of bug 7424 14:32 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7424 enhancement, P5 - low, ---, gmcharlt, NEW , Koha should have a designated place for custom CSS 14:32 oleonard Shane-S: IntranetUserCSS system preference? 14:33 Shane-S oleonard: when I put it in there is didn't change the background color, http://whesstaff.npelem.com to see what I changed 14:33 Shane-S I added it to the custom CSS where it has /css/ then a text box, let me see if admin is still open 14:35 Shane-S so...intranetcolorstylesheet worked, but I had to create a CSS via SSH, IntranetUserCSS did not affect the login, I can try again to confirm if you want 14:36 Shane-S i should say specifically #login 14:36 oleonard I didn't realize IntranetUserCSS didn't affect the login page 14:43 Shane-S oleonard: I don't see it being imported anywhere in the source, as I still have a #login{background: #8000000;} in there 14:43 oleonard In where? 14:43 huginn New commit(s) kohagit: Bug 10820: display item status as lost if item is both lost and on loan <http://git.koha-community.org/gitweb/?p=koha.git;a=commitdiff;h=ffd625b88f87663c84a55b7b96e56a32b606e36d> 14:44 Shane-S oleonard: The staff login screen, which is pretty short code wise :) 14:45 oleonard I mean where did you put your custom CSS 14:46 jenkins_koha Starting build #149 for job master_maria (previous build: SUCCESS) 14:46 Shane-S intranetcolorstylesheet is where the above color change is 14:47 oleonard If you log in and look for that stylesheet in the source do you see it? 14:47 Shane-S my custom-login.css contains that gradient code, after I tested the same maroon code to verify custom css worked in intranetcolorstylesheet 14:48 Shane-S yes sir I do, hard coded in a <style> tag 14:48 Shane-S not present at the login though 14:48 oleonard You have a <style> tag in your custom CSS file, added via intranetcolorstylesh? 14:49 magnuse happy pizza day and have fun #koha! 14:49 jenkins_koha Starting build #1445 for job Koha_master (previous build: SUCCESS) 14:51 Shane-S oleonard: No, the source logged in show the IntranetUserCSS in a <style> tag, the file added to intranetcolorstylesheet is on both page...here: http://pastebin.com/MdpRRbHn 14:53 oleonard So neither the IntranetUserCSS nor intranetcolorstylesheet template variable is made available to the login page, so it doesn't know to include them. 14:53 oleonard That's definitely a bug. 14:53 oleonard Oh wait, the intranetcolorstylesheet one is 14:53 oleonard It's just being included before login.css, so it's being overridden. 14:54 oleonard That's a bug too 14:54 Shane-S Here if it helps: http://picpaste.com/staff_CSS-vDxOcVn8.png 14:55 Shane-S ignore the (modifed) I clicked in the field and hit space by accident and removed it 14:55 oleonard It's not your preference that is to blame Shane-S, it's Koha 14:59 Shane-S oleonard: Well the custom CSS file worked perfect, so intranetcolorstylesheet seems fine to me, but the IntranetUserCSS seems to be the issue, not sure about it location once on the staff screen, like you said, its higher up then the other CSS, thus being overwritten possibly 15:00 Shane-S but it would only be overwritten but the intranetcolorstylesheet once logged in, not sure about the login page itself 15:17 jcamins ccverg: as I mentioned, you're better off talking to someone not me if you want to see active engagement with Bountysource from Koha developers. 15:42 jenkins_koha Project master_maria build #149: SUCCESS in 56 min: http://jenkins.koha-community.org/job/master_maria/149/ 15:42 jenkins_koha Kyle M Hall: Bug 10820: display item status as lost if item is both lost and on loan 15:42 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10820 minor, P5 - low, ---, kyle, Pushed to Master , Lost items on search results don't jive with record details 15:50 reiveune bye 16:15 gaetan_B bye ! 16:16 * Oak waves 16:16 rambutan hi oak 16:16 Oak hello rambutan :) 16:17 rambutan how's it going? 16:17 Oak it's going... 16:17 Oak how about you? 16:18 Oak @wunder konstanz 16:18 huginn Oak: The current temperature in Konstanz, Germany is 8.0°C (6:00 PM CEST on October 11, 2013). Conditions: Rain. Humidity: 73%. Dew Point: 5.0°C. Pressure: 29.97 in 1015 hPa (Falling). 16:19 Oak time to go home kf, no? 16:21 kf last day before the trip 16:21 kf have to wrap some things up here first :) 16:21 kf but getting there 16:24 jenkins_koha Project Koha_master build #1445: UNSTABLE in 1 hr 35 min: http://jenkins.koha-community.org/job/Koha_master/1445/ 16:24 jenkins_koha Kyle M Hall: Bug 10820: display item status as lost if item is both lost and on loan 16:24 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10820 minor, P5 - low, ---, kyle, Pushed to Master , Lost items on search results don't jive with record details 16:37 Oak hm 16:38 Shane-S Is there a search to add new Z39.50 servers, or do you just use google and enter the details? 16:43 gmcharlt Shane-S: http://irspy.indexdata.com/ 16:43 Shane-S ty 16:47 jcamins Gosh, I feel so honored by that latest "bug." 16:48 oleonard Really? I think the honor is all gmcharlt's, it's assigned to him! 16:48 gmcharlt er, which one? 16:48 oleonard Bug 11041 16:48 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11041 enhancement, P5 - low, ---, gmcharlt, NEW , Hi, I am new and I have a question, you may help me! 17:16 tcohen @later tell rangi could we feed jenkins with a 3.12.x db for the 3.12.x branch? 17:16 huginn tcohen: The operation succeeded. 17:23 gmcharlt tcohen: I can help with that as well -- would you perhaps have a mysqldump of a suitable DB? 17:30 tcohen i'm not sure galen, i'm not used to the tests jenkins does besides those on t/ and xt/ 17:31 gmcharlt tcohen: that's mostly what jenkins does, so if you've got a small DB that the tests pass with (particularly t/db_dependent), that will work 17:49 rambutan tcohen: are you involved with this at all? http://www.cbamakerspace.com 17:50 tcohen nope 17:52 tcohen but i can try to approach them so they come to kohacon14 17:54 hasan hi there? 17:55 hasan I have access only at a "administration level" I can access to all Koha functions: Circulation, Patrons, Koha Administration, Tools, etc. And I want to delete all these branches: Midway Springfield Franklin Pleasant Valley Union Also, I want to delete "Koha admin" patron My question is: CAn I do this without compromise the database, or any functionallity of Koha? Thanks in advance. Hasan 18:03 tcohen bye #koha 18:04 oleonard hasan: Have you added or imported any data besides the sample data? 18:07 oleonard Others: Isn't there a script for resetting your database after importing sample data? 18:09 oleonard hasan: If you've installed Koha, tried it, and now want to start from scratch you could always drop the database and recreate it, going through the web installer again. 18:09 oleonard hasan: That is assuming you have *nothing* in that database you want to save. 18:10 jcamins hasan: the system user cannot be deleted, but it should also never be used. 18:10 jcamins (other than upgrades, of course) 18:23 hasan Hi again, I don't have any access to the server, only to the tools and the administative features 18:25 hasan user oleonard suggest that deleting the Midway, Franklin and otherdefault branches will cause problemes to the databse? 18:25 hasan I want to get it straight 18:26 oleonard hasan: Do you have data which references those branches? 18:26 oleonard hasan: Those are not "default branches," they're branches added with sample data 18:26 oleonard hasan: They're supposed to be loaded if you're just testing Koha 18:26 oleonard hasan: If you don't need them you can delete them. 18:27 hasan oleonard i dont have access to more than administrative features in the administrative interface 18:27 oleonard hasan: I understand 18:27 jcamins manual? 18:27 wahanui it has been said that manual is at http://www.koha-community.org/documentation 18:27 hasan my worry is if the databse will suffer 18:28 oleonard hasan: Koha won't let you delete the branches if there is data in the system which references them 18:28 hasan ok 18:28 hasan there is none 18:29 hasan in my work i have like 10 branches 18:29 hasan so the users are kind of confused what is "franklin" 18:29 hasan so i want to delete these branches 18:30 jcamins You should go ahead and do that, then. 18:30 hasan if there are no records or items on these "sample branches" then i can deleted them without compromise the data in other branches or the functionallity of the system? 18:30 oleonard Yes 18:31 hasan mmmm that is not what the provider tells me 18:31 hasan "provider" i mean the person who installed the software 18:31 rangi what version of koha are you running 18:31 hasan 3.08 18:31 rangi it should tell you in the about page 18:31 rangi the full number 18:32 rangi and that person is mistaken 18:32 hasan 3.08.00.000 18:32 rangi right, well for one, you should have been upgraded 18:32 hasan i guess but they make this complicated 18:33 rangi that is nearly 1.5 years old now, and has a known security issue 18:33 hasan every change is money, do you understand? 18:33 rangi yep, you should find a better provider then 18:33 hasan LOL 18:33 hasan how hard is it to upgrade? 18:35 rangi depends how they did the install 18:35 rangi but even in 3.8.0 you can still delete unused branches without breaking things 18:42 oleonard hasan: How long ago was Koha installed for you? 18:43 cait @wunder Konstanz 18:43 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 5.6°C (8:40 PM CEST on October 11, 2013). Conditions: Clear. Humidity: 90%. Dew Point: 4.0°C. Windchill: 6.0°C. Pressure: 29.98 in 1015 hPa (Steady). 18:46 oleonard rangi: What's the date for you when you depart? The 13th? 18:48 oleonard cait: I expect you, rangi, and paul_p to have found all the good places to eat by the time I get there okay? 18:48 cait ok 18:48 cait but you know we won't do repeats, right? ;) 18:49 oleonard Shoot. 18:51 rangi oleonard: i leave here on the 12th nz time, get there on the 12th reno time .. 1 min before i took off 18:51 cait 12th? 18:51 rangi sorry 13th 18:51 rangi hehe 18:51 cait you scared me! 18:51 rangi im late!!! 18:51 rangi but no, tomorrow 18:51 rangi http://www.renotownmall.org/ 18:51 rangi is right by the hotel 18:53 rangi and is an utterly awesome website! 18:53 cait ? 18:54 rangi it tells me nothing about what the reno town mall is 18:55 cait yeah, i got a little worried about that by now :) 18:55 cait but there is specialty sushi all over town :) 18:56 rangi no sushi for me 18:56 rangi its a desert 18:56 rangi thats been on a truck or a plane for a while :) 18:57 rangi (im just using this whole thing as an excuse to eat unhealthy super fried foods) 18:57 cait guess i will just claim you dragged me down with you 18:57 cait and made me eat it 18:57 Shane-S oleonard: maybe you can help me with some more CSS customizing, the admin bar, I have gotten everything to change color, except the gap between the left and right menu portions. Inspecting I am coming up with class="navbar-inner", so I included that in my class...but it is still that baby blue 18:58 Shane-S I will pastbin my CSS 18:59 jcamins cait: Sushi in Reno seems like a bad idea. 18:59 cait ok, i got it 18:59 jcamins rangi's right. It's a *desert*. 18:59 cait sad but okok 18:59 rangi oleonard: i think i could eat at a different place for each meal, and still have not left the hotel for 3 days 18:59 Shane-S http://pastebin.com/E5CrRfwm 19:00 rangi but there also seem to be quite a few in walking distance too 19:00 rangi if you are allowed to walk in reno 19:00 rangi i know they frowned on that malarkey in plano 19:00 rangi :) 19:00 oleonard Shane-S: Firebug tells me you want to set the background-color on .navbar-static-top .navbar-inner {} 19:01 oleonard rangi: Urban planners know better than you when it's okay to walk. 19:02 rangi :) 19:02 rangi @wunder reno nv 19:02 huginn rangi: The current temperature in MidTown, Reno, Nevada is 13.7°C (12:00 PM PDT on October 11, 2013). Conditions: Scattered Clouds. Humidity: 43%. Dew Point: 1.0°C. Pressure: 30.03 in 1017 hPa (Falling). 19:03 cait rangi: i saw lots of parking lots on google maps... so if I had to guess 19:03 rangi oleonard: my first mission is find a tmobile store 19:03 jcamins rangi: I'm thinking that walking is probably discouraged. 19:04 jcamins rangi: tcohen wants to go to Bestbuy. I think they sell TMobile SIM cards, too. 19:04 rangi i have a tmobile sim in my firefox phone, but i needs to put some datas on it 19:04 rangi oh cool 19:04 oleonard I wondered how you foreigners were going to handle that 19:04 rangi that'll work 19:04 jcamins But I'm not sure when tcohen is getting in. 19:04 cait hm tuesday 19:05 rangi if the wifi is good in the hotel, i wont need it until the trip to tahoe 19:05 rangi so that would be ok 19:05 rangi ill still have my other phone with my nz number on it too 19:07 Shane-S oleonard: that made it blue again, just picking .navbar-static-top, .navbar-inner 19:07 oleonard Shane-S: There is no comma between those two things 19:08 Shane-S oh, single combined class? okay let me try 19:09 Shane-S hmm...might have to see if they have FB for chrome, cause inspect element sucks 19:09 Shane-S ty that works 19:09 oleonard Shane-S: No, the Chrome inspector should do it just as well 19:15 rangi oh margo and tcohen are on the same flight it seems 19:15 cait :) 19:15 rangi and oleonard and rambutan land the same time too 19:23 Oak later guys 19:23 Oak oh and have a great KohaCon! 19:24 cait :) 19:32 oleonard cait: Will you try to get your phone working here? 19:32 cait i don't think so 19:33 cait i jus don't worry about phones so much i guess 19:33 Shane-S oleonard: should I put in a bug about an !important; tag causing a color change to not take effect? 19:34 Shane-S or should I check the order the files load? 19:34 oleonard Shane-S: Please describe. 19:36 Shane-S The thin green border under the search box, I copied that segment from element inspector, pasted it in my custom color file, and it shows my code above the staff-global.css with a line through the border: element. As it has !important; at the end 19:36 Shane-S I will pastebin the 2 codes 19:36 oleonard paste? 19:36 wahanui rumour has it paste is found at http://paste.koha-community.org 19:38 Shane-S http://picpaste.com/Capturekoha-ujlVDqRT.PNG photo of the color issue and document inspector 19:40 oleonard Yes, that would be a good thing to bug 19:40 pastebot "Shane-S" at 127.0.0.1 pasted "CSS color issue for line under search box" (18 lines) at http://paste.koha-community.org/244 20:04 rangi now, this is what i call fusion 20:04 rangi http://www.tripadvisor.com/Restaurant_Review-g45992-d3580688-Reviews-Pho_Noodle_and_donuts-Reno_Nevada.html 20:05 cait lol 20:06 oleonard I'm definitely game for that 20:06 cait :) 20:06 cait i wouldn't mind trying donuts 20:06 cait or vietnamese 20:09 rangi excellent :) 20:09 jcamins That first review makes me sad. Cuisine: Vietnamese. Review: "Chinese and donuts..." 20:10 rangi heh 20:10 rangi yeah 20:11 rangi asians .. its all the same ! 20:11 oleonard I probably won't be back here until Reno, so have a safe trip everyone! 20:12 cait you too :) 20:14 haxan hi all, can I delete the sample libraries (branches) Midway, Franklin, Union, Springfield and Pleasant Valley wihtout compromising the database or Koha? 20:15 rangi haxan: we are just going to give you the same answer as last time you asked 20:15 haxan :) 20:16 haxan The answer was "delete them" no problem 20:16 haxan ? 20:16 rangi yes 20:16 rangi http://irc.koha-community.org/koha/2013-10-11#i_1402614 20:17 haxan ok thanks 20:18 rangi the only way you could mess it up is if you were doing things inside the database itself, if you use koha, then you are fine 20:19 haxan koha interface you meant 20:20 haxan but yesterday I used "Batch item modification" 20:20 haxan to modify two items bar codes 20:21 haxan and this made the record invisible of these two items 20:21 haxan I could search for barcodes but if a search by the title it didn't appear 20:22 haxan what I did was to search for barcode in advanced search then I re-save the record, then I could see it again in searches 20:23 rangi you must have batch modified the wrong then, or there was a bug in your 1.5 year old version that has since been fixed 20:23 haxan yes I think it is a bug 20:23 rangi but either way, you can either back up the db, and try deleting, or not 20:24 rangi i have no idea what your provider has done 20:24 rangi so cant say anything with 100% certainty 20:24 haxan I can? I have access only to interface not to the server 20:25 haxan I cannot backup the database from the administrative interface? or I can? 20:25 rangi haxan: i really have nothing else to offer, when was your koha installed? 20:26 haxan I think two years ago 20:26 haxan can i backup the database from the tools? 20:27 rangi you can if it was installed using the packages 20:27 rangi but either way, there really isnt much more we can offer you, it sounds like you have problems with your provider not with Koha 20:28 haxan let me know if this irc is to talk freely about koha or it has some rules? perhaps i am not in the correct space 20:29 rangi it doesnt have any real rules 20:29 jcamins There's no other IRC channel for Koha. There's also no other answer for you. 20:29 rangi but unfortunately haxan we cant know exactly how your koha was installed 20:30 rangi if there are any local modifications 20:30 rangi or things like that 20:30 haxan Well, it is hard to know that there are solutions avaliable but I can't apply them because I have been denied access 20:30 haxan to the server 20:30 rangi but if it is a standard 3.8.0 with no changes then deleting an unused branch will not be a problem 20:31 rangi haxan: like i said, not a koha problem thats a problem between you and your vendor 20:31 rangi one we cant solve im afraid :( 20:31 haxan I meant not only this (delete a branch) but to fix bugs 20:31 rangi yes 20:32 rangi again, not really anything the Koha project can do anything about 20:32 haxan I wish I could upgrade koha, fix bugs, etc. but.... 20:32 haxan another issue... 20:32 wahanui another issue is I noticed wajasu's template contains the branchemail. and since I put "The Library" <mailto:thelibarary@thehost.org> the template substitution gobbled up the part in <> 20:33 jcamins wahanui: forget another issue 20:33 wahanui jcamins: I forgot another issue 20:33 haxan another issue... I was making a sql to reports by MARC number instead of biblio.title for example 20:34 haxan the title is not complete as it has subfields 20:34 rangi yes 20:34 haxan title:subtitle but the report in koha only retrieve 245$a 20:35 rangi yes search the MARC 20:35 jcamins sql reports library? 20:35 wahanui sql reports library is at http://wiki.koha-community.org/wiki/SQL_Reports_Library 20:36 rangi http://wiki.koha-community.org/wiki/SQL_Reports_Library#Title.2FSubtitle_List 20:37 haxan yes it was useful 20:37 haxan thanks 20:37 haxan I saw it yesterday 20:38 haxan I work with books, serials and archives 20:38 haxan I am trying to figure out to open a new search option to look for the series of archives 20:38 haxan any field of MARC suggested? 20:39 haxan The series of archives are different from the series of books, I guess I can't use field 490 20:40 haxan or 440 20:41 rangi probably a question for a cataloguer, i dont know 20:41 jcamins haxan: you have to make that decision for your library. 20:42 haxan I know 20:42 jcamins Or your cataloguer does. 20:42 haxan _I just ask for common MARC field used here 20:42 haxan not a big deal i guess 20:43 rangi im a developer so dont know the intricacies of MARC 20:43 jcamins You could look at something like DACS (Describing Archives: a Content Standard). 20:43 jcamins Or examples of how other libraries with similar collections do it. 20:43 rangi or maybe ask on somethign like AUTOCAT 20:43 rangi or the main koha lists 20:44 rangi my guess is there are some other koha libraries in the world doing it 20:44 haxan I thought there were librarians here 20:44 jcamins Not on the weekend. 20:45 rangi there are about 60 people logged in, and only probably 10 awake :) 20:45 rangi the mailing list has 3000 20:45 rangi so id ask on the mailing list for somethign like that 20:45 rangi brb 20:45 haxan you can help with a sql? 20:45 haxan just asking? 20:46 haxan I have this line: WHERE items.itype=<<Selecciona tipo de Ãtem|items.itype>> 20:47 haxan But I cant see the dropdown options for item type 20:47 haxan is this a problem with koha or the code is wrong? 20:47 cait it's itypes 20:47 cait not items.itype 20:49 haxan Do you have the same problem with items.itype??? 20:49 cait your code is wrong 20:49 cait look at the help file 20:49 haxan where is the help file? 20:49 bgk haxan: spanish version? 20:51 haxan I use the same code for: WHERE branchcode=<<Enter patrons library|branches>> 20:51 haxan and it works} 20:51 haxan so what is wrong? 20:51 jcamins haxan: your code is wrong. It should say "itypes" not "items.itype" in the <<>>s. 20:54 rangi WHERE items.itype=<<Selecciona tipo de Ãtem|itypes>> 20:54 rangi like that 20:55 haxan yes 20:56 haxan but wrong 20:56 haxan I found the answer is this: itemtype = <<Item Type|itemtypes>> 20:57 haxan itemtypes only works in my db 20:57 haxan developers 20:57 wahanui the brains that make Koha grow and get better. Give them cookies. Lots of cookies. And possibly beer. 20:58 haxan I guess why is itemtypes and not items.itype 20:59 rangi because the table is itemtypes 20:59 rangi items.itype is a column 20:59 rangi you could read the schema if you wanted 20:59 haxan exactly rangi branches and not branchname 21:00 rangi then why ask? 21:00 rangi if you knew :) 21:00 haxan I just figureit out 21:00 rangi cool 21:00 haxan it seems there is a tense atmosphere here 21:01 rangi im sorry you sense that, it is not intentional 21:01 rangi at least not from me, which is why the :) 21:01 haxan Well, I hope to come back soon, thanks 21:02 haxan bye 21:02 pianohacker [off] well that was interesting 21:02 rangi [off] takes all sorts, i think it was mostly language barrier 21:03 rangi [off] but also perhaps unrealistic expectations 21:04 rangi for me, it did reinforce the need for us to continue to be clear that Koha the project, is separate from how vendor x,y,z chose to implement/charge/support Koha 21:05 jcamins [off] I'm not sure I'm convinced that was all language. I mean, if you don't understand the answer to your question, you don't repeat the question, you ask for an explanation. 21:05 cait [off] yes 21:10 rambutan @seen wajasu 21:10 huginn rambutan: wajasu was last seen in #koha 11 weeks, 1 day, 18 hours, 11 minutes, and 38 seconds ago: <wajasu> it looks like the current strategy for giving the end users the ability to customize what is displayed is to put a span with a relevant class. 21:14 haxan hi guys again 21:14 haxan a question 21:14 wahanui hmmm... a question is "What is the meaning of life, the universe and everything?" 21:14 haxan ? 21:14 haxan the meaning of life? 21:15 magnuse never mind wahanui, it's just a bot trying to be smart 21:15 haxan wahanui wrote me 21:15 wahanui haxan: what? 21:15 jcamins wahanui: the meaning of life is 42 21:15 wahanui OK, jcamins. 21:15 jcamins the meaning of life? 21:15 wahanui i heard the meaning of life was 42 21:16 haxan what is 42? 21:17 magnuse haxan: just ignore wahanui. you had a question? 21:18 haxan can someone explain how to retrieve all branches in a report when I put this WHERE branchcode = <<bibliotecas|branches>> 21:18 haxan I can't see the option "All" 21:18 rangi thats not how sql works haxan 21:18 haxan wahanui I have an answers to you 21:18 wahanui haxan: sorry... 21:18 rangi if you want all, you just dont limit by branchcode 21:19 haxan ok i see 21:19 rangi make a separate report called all branches or something 21:19 rangi and then you have one, to limit by branch 21:19 rangi and one report to get you all 21:19 haxan but how it works when i do a an advanced search and the option "all" appears there 21:19 rangi thats not doing a simple sql search in the background 21:20 magnuse g'night #koha 21:20 haxan thanks rangi 21:20 rangi what all tells it to do is not add the branch limit to the query it generates 21:20 haxan but it is possible to do or not? 21:20 haxan with sql 21:21 rangi um 21:21 rangi 10:18 <@rangi> thats not how sql works haxan 21:21 rangi 10:18 <@rangi> if you want all, you just dont limit by branchcode 21:21 rangi 10:19 <@rangi> make a separate report called all branches or something 21:21 rangi 10:19 <@rangi> and then you have one, to limit by branch 21:21 rangi 10:19 <@rangi> and one report to get you all 21:21 haxan perhaps this would work? WHERE itemtype = <<Item Type|branchname>> OR WHERE itemtype = <<branchname>> 21:21 rangi no 21:21 rangi just dont limit it 21:23 rangi if you want all, you dont tell it to restrict 21:23 haxan WHERE branches.branchcode = <<bibliotecas |branches>> OR WHERE branchcode = <<branches>> 21:23 cait don't use WHERE.. just delete that part and make a new report 21:24 rangi i feel like you are maybe not reading our answers haxan ? 21:25 haxan i am reading 21:25 bag haxan: http://wiki.koha-community.org/wiki/SQL_Reports_Library try in there 21:25 haxan i read it 21:26 bag but like cait says - don't use the WHERE part… That is adding a limit (don't limit if you don't want to limit) 21:27 haxan yes i see 21:27 haxan what i thought i can do is to have a big report where i can select the report i want 21:27 haxan this is because many default reports in the system and the guided report don't work 21:28 rangi in newer versions of koha, you can sort the reports, or filter by area 21:29 haxan so for example see this 21:29 haxan SELECT * FROM branches LEFT JOIN borrowers ON (branches.branchcode = borrowers.branchcode) LEFT JOIN items ON (borrowers.branchcode = items.homebranch) LEFT JOIN biblioitems ON (items.biblionumber = biblioitems.biblionumber) LEFT JOIN biblio ON (biblioitems.biblionumber = biblio.biblionumber) WHERE items.itype= <<bibliotecas |itemtypes>> OR WHERE branchcode = <<bibliotecas|branches>> ORDER BY items.dateaccessioned 21:29 rangi that isn't valid sql 21:30 rangi you can't have 2 WHERE statements 21:31 haxan ok 21:31 haxan SELECT * FROM branches LEFT JOIN borrowers ON (branches.branchcode = borrowers.branchcode) LEFT JOIN items ON (borrowers.branchcode = items.homebranch) LEFT JOIN biblioitems ON (items.biblionumber = biblioitems.biblionumber) LEFT JOIN biblio ON (biblioitems.biblionumber = biblio.biblionumber) WHERE items.itype= <<bibliotecas |itemtypes>> OR branchcode = <<bibliotecas|branches>> ORDER BY items.dateaccessioned 21:31 rangi again not valid 21:31 rangi well it is, but it wont do what you want 21:31 haxan I can add dateaccessioned as another "and" to "where" 21:32 rangi perhaps get a book on sql? 21:34 rangi schema? 21:34 wahanui well, schema is tracked in git. or found at http://schema.koha-community.org 21:37 rangi jcamins: is it columbus day on monday? 21:38 bag rangi: yes it is 21:38 rangi hmm do things close for that? or just banks? 21:40 pianohacker and the federal government :P 21:40 rangi hehe 21:40 bag ha 21:40 bag pianohacker++ 21:45 rangi shops and everything will be open though eh? 21:48 * cait doesn't know 21:49 haxan This works for my db: 21:49 haxan SELECT items.barcode,branches.branchcode,items.itype,items.dateaccessioned FROM branches LEFT JOIN items ON (branches.branchcode = items.homebranch) LEFT JOIN biblioitems ON (items.biblionumber = biblioitems.biblionumber) LEFT JOIN biblio ON (biblioitems.biblionumber = biblio.biblionumber) WHERE branches.branchcode=<<bibliotecas|branches>> AND items.itype= <<selecciona items|itemtypes>> AND items.dateaccessioned BETWEEN <<desde (yyyymmdd)>> AND <<hasta (yyy 21:49 cait hm googleing for columbus day and shops there are lots of sales 21:49 rangi that works 21:50 haxan i can add more, this is a limited report but i can make it unlimited removing all << >> 21:50 haxan @rangi? 21:50 wahanui @rangi is there any specific right? btw i have set all the permission And i also have tired from kohaadmin. 21:50 huginn wahanui: I suck 21:50 wahanui huginn: sorry... 21:50 huginn haxan: I'll give you the answer as soon as RDA is ready 21:50 huginn wahanui: downloading the Perl source 21:50 wahanui huginn: excuse me? 21:50 huginn wahanui: My excuse for today is "failure of the flux capacitor" 21:50 wahanui ...but huginn's excuse for today is "LP0 is on fire"... 21:51 rangi heh the 2 bots just had an argument 21:51 haxan rangi did you see my sql? 21:51 haxan it works 21:51 wahanui But it also eats babies. 21:51 cait eythian++ 21:53 rangi haxan: i did 21:53 haxan the problems was borrowers 21:53 haxan it has nothing to do with the others 21:54 haxan it has the time variable 21:54 bag wow bot arguement that's great 21:54 haxan something like that 21:54 haxan when a user borrow a book then it created colums and tables about time 21:55 haxan it works with branches but not with catalog tables 21:56 haxan I guess this is called in koha cron jobs 22:12 cait good night all :) 22:14 mtompset Good night, cait. 22:14 mtompset Have a great day (24 hour period), #koha. 22:27 haxan the hour of my server is 30 minutes advanced 22:27 haxan it is 17:57 22:27 bag you are seeing the future 22:28 haxan but it is 17:27 22:28 bag I've got :28 22:28 haxan just changed 22:28 bag @later tell cait see you monday!!!! 22:28 huginn bag: The operation succeeded. 22:44 rambutan [off]the channel was, this afternoon, much more interesting that configuring mrtg 22:44 rambutan than 22:57 jcamins rambutan: yes. 22:57 rambutan it's the weekend! 22:57 jcamins rangi: that yes was for you.