IRC log for #koha, 2013-10-11

← Previous day | Today | Next day → | Search | Index

All times shown according to UTC.

Time Nick Message
00:03 tcohen joined #koha
00:29 jenkins_koha Project master_maria build #145: SUCCESS in 44 min: http://jenkins.koha-community.[…]master_maria/145/
00:29 * Mirko Tietgen: Bug 9295: Introduce operator equal/ notequal to OAI set mapping instead of hardcoded 'equal' value.
00:29 * Galen Charlton: Bug 9295: DBRev 3.13.00.025
00:29 * Jonathan Druart: Bug 10602: Set default value for authority fields via the framework
00:29 * Bernardo Gonzalez Kriegel: Bug 10602: (follow-up) to remove tabs
00:29 * Galen Charlton: Bug 10602: DBrev 3.13.00.026
00:29 huginn 04Bug http://bugs.koha-community.org[…]w_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[…]_bug.cgi?id=10602 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , Set a default value for authorities
00:29 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=10365 enhancement, P5 - low, ---, chrish, Pushed to Master , Using published date on routing slips
00:38 dcook joined #koha
00:51 ccverg joined #koha
01:07 jenkins_koha Yippie, build fixed!
01:07 Project Koha_master build #1439: FIXED in 1 hr 37 min: http://jenkins.koha-community.[…]Koha_master/1439/
01:07 * Jared Camins-Esakov: Bug 5202: merge authorities from the authority file and reservoir
01:07 * Jared Camins-Esakov: Bug 5202: QA follow-up: quiet warnings
01:07 * Jared Camins-Esakov: Bug 5202: QA follow-up 2 - fix overeager error message
01:07 * Jared Camins-Esakov: Bug 5202: (follow-up) Quiet warning
01:07 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=5202 new feature, P5 - low, ---, jcamins, Pushed to Master , Merge authority records
01:07 jenkins_koha * Jared Camins-Esakov: Bug 5202: QA follow-up - improve merge reference selection
01:07 * Jared Camins-Esakov: Bug 5202: QA follow-up - correct license and POD errors
01:07 * Galen Charlton: bug 5202: (follow-up) adjust for the move of the merge record Javascript
01:07 * Galen Charlton: bug 5202: (follow-up) tweak display of merge action link on staged batch page
01:07 * Fridolyn SOMERS: Bug 9282: improve auto-completion for authority record finder
01:07 * Fridolyn SOMERS: Bug 9282: (follow-up) add authtypecode to authority  auto-completion search
01:07 huginn 04Bug http://bugs.koha-community.org[…]w_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 * 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[…]w_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:12 jenkins_koha joined #koha
01:13 jenkins_koha Starting build #1441 for job Koha_master (previous build: FIXED)
01:36 ccverg joined #koha
01:57 kohan00b joined #koha
01:58 kohan00b hi gang
02:01 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 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 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/[…]5c852221eec9b71c4> / Bug 10240: (follow-up) don't display patrons as lost or gone-no-address incorrectly <http://git.koha-community.org/[…]c5b66784e9de28698> / 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:26 tcohen joined #koha
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 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.co[…]gmail/PQLLTW1d3DM
02:33 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 Agreed Koha probably not responsible
02:37 ccverg joined #koha
02:45 jenkins_koha Project Koha_master build #1441: SUCCESS in 1 hr 33 min: http://jenkins.koha-community.[…]Koha_master/1441/
02:45 * Jonathan Druart: Bug 10602: Set default value for authority fields via the framework
02:45 * Bernardo Gonzalez Kriegel: Bug 10602: (follow-up) to remove tabs
02:45 * Galen Charlton: Bug 10602: DBrev 3.13.00.026
02:45 * Chris Hall: bug 10365: change routing slips to use date published rather than planned date
02:45 huginn 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=10602 enhancement, P5 - low, ---, jonathan.druart, Pushed to Master , Set a default value for authorities
02:45 04Bug http://bugs.koha-community.org[…]_bug.cgi?id=10365 enhancement, P5 - low, ---, chrish, Pushed to Master , Using published date on routing slips
02:47 jenkins_koha joined #koha
02:53 jenkins_koha Starting build #1442 for job Koha_master (previous build: SUCCESS)
03:02 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/[…]32724293f5b898e03> / Bug 10853: (follow-up) expand unit tests for C4::Csv <http://git.koha-community.org/[…]8a79092603ad2e828> / Bug 10853: All existing routing to get a CSV should return a MARC csv <http://git.koha-community.org/[…]=koha.git;a=commi
03:38 ccverg joined #koha
03:57 jenkins_koha Project master_maria build #146: UNSTABLE in 55 min: http://jenkins.koha-community.[…]master_maria/146/
03:57 * Jared Camins-Esakov: Bug 10240: Offline circulation using HTML5 and IndexedDB
03:57 * Jared Camins-Esakov: Bug 10240: QA follow-up
03:57 * Jared Camins-Esakov: Bug 10240: (follow-up) don't delete transactions if auth fails
03:57 * Jared Camins-Esakov: Bug 10240: (follow-up) fix display issues
03:57 * Jared Camins-Esakov: Bug 10240: (follow-up) disable logout/set library
03:57 huginn 04Bug http://bugs.koha-community.org[…]_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 * Jared Camins-Esakov: Bug 10240: (follow-up) make sure datepicker icons are available offline
03:57 * Jared Camins-Esakov: Bug 10240: (follow-up) correctly record fines and fix label
03:57 * Galen Charlton: Bug 10240: (follow-up) don't display patrons as lost or gone-no-address incorrectly
03:57 * Galen Charlton: Bug 10240: DBRev 3.13.00.027
03:58 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/[…]9edebf1446f13b912> / Bug 10854: (follow-up) language tweaks <http://git.koha-community.org/[…]433eca2038bee5686> / Bug 10854: (follow-up) Small changes to the template <http://git.koha-community.org/[…]7da7dafb90b62cdf0
04:29 jenkins_koha Project Koha_master build #1442: SUCCESS in 1 hr 36 min: http://jenkins.koha-community.[…]Koha_master/1442/
04:29 * Jared Camins-Esakov: Bug 10240: Offline circulation using HTML5 and IndexedDB
04:29 * Jared Camins-Esakov: Bug 10240: QA follow-up
04:29 * Jared Camins-Esakov: Bug 10240: (follow-up) don't delete transactions if auth fails
04:29 * Jared Camins-Esakov: Bug 10240: (follow-up) fix display issues
04:29 huginn 04Bug http://bugs.koha-community.org[…]_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 * Jared Camins-Esakov: Bug 10240: (follow-up) warn when patron's card is expired
04:29 * Jared Camins-Esakov: Bug 10240: (follow-up) make sure datepicker icons are available offline
04:29 * Jared Camins-Esakov: Bug 10240: (follow-up) correctly record fines and fix label
04:29 * Galen Charlton: Bug 10240: (follow-up) don't display patrons as lost or gone-no-address incorrectly
04:29 * Galen Charlton: Bug 10240: DBRev 3.13.00.027
04:29 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/[…]76fbdc8733d899fab> / Bug 10689: make subscription public note appear when making a new order from a subscr... <http://git.koha-community.org/[…]f26f7571d2244e35e> / Bug 10689: make public note appear in subscriptions search <http://git.koha-community.org
04:38 ccverg joined #koha
04:46 cait joined #koha
04:48 jenkins_koha Yippie, build fixed!
04:48 Project master_maria build #147: FIXED in 49 min: http://jenkins.koha-community.[…]master_maria/147/
04:48 * Jonathan Druart: Bug 10853: Add DB field export_format.type ('marc' or 'sql').
04:48 * Bernardo Gonzalez Kriegel: Bug 10853 - followup to correct tabs
04:48 * 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[…]_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 * Galen Charlton: Bug 10853: DBrev 3.13.00.028
04:48 * Jonathan Druart: Bug 10854: add ability to export serial claims using CSV profile.
04:48 * Jonathan Druart: Bug 10854: (follow-up) Small changes to the template
04:48 * Galen Charlton: Bug 10854: (follow-up) language tweaks
04:48 * Galen Charlton: Bug 10854: DBrev 3.13.00.029
04:48 huginn 04Bug http://bugs.koha-community.org[…]_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 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:08 ccverg joined #koha
05:11 cait hm there are a few  tihnk
05:11 i think i saw one at least
05:11 and i think no explicit plans
05:12 bug 9084
05:12 huginn 04Bug http://bugs.koha-community.org[…]w_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 cait++
05:15 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 :D
05:17 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.[…]master_maria/148/
05:36 * Fridolyn SOMERS: Bug 10689: make public note appear in subscriptions search
05:36 * Fridolyn SOMERS: Bug 10689: make subscription public note appear when making a new order from a subscription
05:36 * Galen Charlton: Bug 10689: add regression test
05:36 huginn 04Bug http://bugs.koha-community.org[…]_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.[…]Koha_master/1443/
06:08 * Jonathan Druart: Bug 10853: Add DB field export_format.type ('marc' or 'sql').
06:08 * Bernardo Gonzalez Kriegel: Bug 10853 - followup to correct tabs
06:08 * Jonathan Druart: Bug 10853: All existing routing to get a CSV should return a MARC csv
06:08 * Galen Charlton: Bug 10853: (follow-up) expand unit tests for C4::Csv
06:08 huginn 04Bug http://bugs.koha-community.org[…]_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 * Jonathan Druart: Bug 10854: add ability to export serial claims using CSV profile.
06:08 * Jonathan Druart: Bug 10854: (follow-up) Small changes to the template
06:08 * Galen Charlton: Bug 10854: (follow-up) language tweaks
06:08 * Galen Charlton: Bug 10854: DBrev 3.13.00.029
06:08 * Fridolyn SOMERS: Bug 10689: make public note appear in subscriptions search
06:08 huginn 04Bug http://bugs.koha-community.org[…]_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 * Galen Charlton: Bug 10689: add regression test
06:08 huginn 04Bug http://bugs.koha-community.org[…]_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:09 ccverg joined #koha
06:20 * magnuse waves
06:24 dac joined #koha
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[…]_bug.cgi?id=10240 new feature, P5 - low, ---, jcamins, Pushed to Master , Offline circulation using HTML5 and IndexedDB
06:26 dcook Sweet!
06:26 I've been hoping that one would get through
06:26 * magnuse too
06:27 dac left #koha
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 or do you? will it work even if you have not synced? just remembering the actions that are made offline?
06:31 happy pizza day dcook!
06:31 dcook Pizza day?
06:31 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 On that note, I should probably go and do something! (i.e. getting silicon to make a home-made cupcake tower)
06:33 See you on IRC magnuse and see you on...Tuesday/Wednesday, rangi
06:33 You too, cait
06:33 magnuse have fun dcook
06:34 dcook left #koha
06:35 cait :)
06:36 very exciting
06:36 * magnuse start researching plane tickets to argentina
06:36 magnuse s/start/starts/
06:37 reiveune joined #koha
06:37 reiveune hello
06:37 wahanui niihau, reiveune
06:45 alex_a joined #koha
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 @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:50 sophie_m joined #koha
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 and maybe you can even see the sun outside
07:00 we haven't had that happening in 3 days i think
07:00 ok, bbl
07:00 cait left #koha
07:09 lds joined #koha
07:10 ccverg joined #koha
07:34 kivilahtio is there any documentation about the reservation/hold constraints used in AddReserve?
07:36 or is it dead code?
07:42 jenkins_koha Project Koha_master build #1444: SUCCESS in 1 hr 34 min: http://jenkins.koha-community.[…]Koha_master/1444/
07:58 paul_p joined #koha
08:04 samueld joined #koha
08:10 ccverg joined #koha
08:23 laurence joined #koha
08:52 busla joined #koha
08:56 Viktor joined #koha
09:20 kf joined #koha
09:20 * kf waves
09:20 kivilahtio bye bye
09:45 lds joined #koha
10:12 ccverg joined #koha
10:36 Viktor joined #koha
11:09 Viktor joined #koha
11:19 busla joined #koha
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 the question stands about placing Holds. Generally I feel the need is for mobile applications communicating via SIP
11:20 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 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 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 kf: But it is just hard work, especially with my field, where I need to prepare complex data for functionality tests
11:27 7h for modifications to HoldsQueue modifications
11:27 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:31 Viktor joined #koha
11:31 jwagner joined #koha
11:36 mtompset joined #koha
11:36 mtompset Greetings, #koha.
11:40 samueld joined #koha
11:50 kivilahtio Thanks you #Koha, c u next week!
11:52 meliss joined #koha
11:54 tcohen joined #koha
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:11 busla joined #koha
12:13 ccverg joined #koha
12:16 oleonard joined #koha
12:19 oleonard Hi #koha
12:19 magnuse hi oleonard
12:20 Shane-S joined #koha
12:36 ebegin joined #koha
12:38 tcohen joined #koha
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:41 tcohen joined #koha
12:44 tcohen morning #koha
12:44 last working day in cordoba for a couple of weeks!
12:45 kf oh
12:45 and yay :)
12:49 edveal joined #koha
12:53 talljoy joined #koha
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 collum joined #koha
12:54 kf Shane-S: sorry, i don#t understand your question
12:55 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 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 you'd have to look at the source code.
12:56 if there is a #login
12:57 well
12:57 id="login2
12:57 chris_n joined #koha
12:58 Shane-S when I view source or inspect elements, I come to div#login
12:58 and in the CSS #login, has that nice white BG with the border
12:59 I will go make a custom CSS, as I have file system access, just felt it should be like OPAC and Intranet
12:59 for the few users who want to make a quick simple change without a hack
13:00 I eventually want to change the logo as well, so I will probably give it shot as well.
13:03 Dyrcona joined #koha
13:04 Shane-S bugs?
13:04 wahanui i think bugs is http://devopsreactions.tumblr.[…]ter-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:05 drnoe_away joined #koha
13:13 ccverg joined #koha
13:16 paul_p joined #koha
13:16 mtompset Greetings, oleonard.
13:23 SherryS joined #koha
13:33 maximep joined #koha
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[…]_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 better nto tie too much to opachiddenitems
13:36 mtompset True.
13:37 Particularly, since I like papa's idea of making visibility in OPAC part of the circulation rules.
13:41 NateC joined #koha
13:47 meliss joined #koha
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 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 i assume i broke it, until someone confirms
14:14 kf take a look at your logs?
14:14 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:16 rambutan joined #koha
14:20 * mtompset cringes.
14:20 mtompset I hate when an idea is semantically simple, but implementationally difficult.
14:20 gaetan_B joined #koha
14:21 gaetan_B hello
14:21 wahanui bonjour, gaetan_B
14:22 tcohen hi gaetan_B
14:22 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 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[…]w_bug.cgi?id=7567 enhancement, P5 - low, ---, ebin.joseph, ASSIGNED , News by Library
14:27 mtompset The idea of branch filtered news.
14:28 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 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 i /was/did
14:32 I sited your blog and also the nice idea of bug 7424
14:32 huginn 04Bug http://bugs.koha-community.org[…]w_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 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 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 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/[…]b96e56a32b606e36d>
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 yes sir I do, hard coded in a <style> tag
14:48 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 That's definitely a bug.
14:53 Oh wait, the intranetcolorstylesheet one is
14:53 It's just being included before login.css, so it's being overridden.
14:54 That's a bug too
14:54 Shane-S Here if it helps: http://picpaste.com/staff_CSS-vDxOcVn8.png
14:55 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 but it would only be overwritten but the intranetcolorstylesheet once logged in, not sure about the login page itself
15:15 ccverg joined #koha
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:22 tcohen joined #koha
15:27 bgkriegel joined #koha
15:30 alex_a left #koha
15:42 jenkins_koha Project master_maria build #149: SUCCESS in 56 min: http://jenkins.koha-community.[…]master_maria/149/
15:42 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[…]_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
15:50 reiveune left #koha
16:05 laurence left #koha
16:07 NateC left #koha
16:09 SherryS left #koha
16:15 gaetan_B bye !
16:16 Oak joined #koha
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 how about you?
16:18 @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 have to wrap some things up here first :)
16:21 but getting there
16:24 jenkins_koha Project Koha_master build #1445: UNSTABLE in 1 hr 35 min: http://jenkins.koha-community.[…]Koha_master/1445/
16:24 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[…]_bug.cgi?id=10820 minor, P5 - low, ---, kyle, Pushed to Master , Lost items on search results don't jive with record details
16:28 paul_p joined #koha
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:41 khall joined #koha
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 ccverg joined #koha
16:48 gmcharlt er, which one?
16:48 oleonard Bug 11041
16:48 huginn 04Bug http://bugs.koha-community.org[…]_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:27 ccverg joined #koha
17:28 rambutan joined #koha
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:36 kf left #koha
17:49 rambutan tcohen: are you involved with this at all? http://www.cbamakerspace.com
17:50 tcohen nope
17:52 but i can try to approach them so they come to kohacon14
17:54 hasan joined #koha
17:54 hasan hi there?
17:55 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
17:59 ccverg left #koha
18:03 tcohen bye #koha
18:04 oleonard hasan: Have you added or imported any data besides the sample data?
18:07 Others: Isn't there a script for resetting your database after importing sample data?
18:08 bgk joined #koha
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 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 (other than upgrades, of course)
18:11 Topic for #koha is now Welcome to #koha this channel is for discussion of the Koha project and software http://koha-community.org. Next general IRC meeting 9th November, 02:00 UTC
18:17 cait joined #koha
18:23 hasan Hi again, I don't have any access to the server, only to the tools and the administative features
18:25 user oleonard suggest that deleting the Midway, Franklin and otherdefault branches will cause problemes to the databse?
18:25 I want to get it straight
18:26 oleonard hasan: Do you have data which references those branches?
18:26 hasan: Those are not "default branches," they're branches added with sample data
18:26 hasan: They're supposed to be loaded if you're just testing Koha
18:26 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 there is none
18:29 in my work i have like 10 branches
18:29 so the users are kind of confused what is "franklin"
18:29 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 "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 the full number
18:32 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 how hard is it to upgrade?
18:35 rangi depends how they did the install
18:35 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 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 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 hehe
18:51 cait you scared me!
18:51 rangi im late!!!
18:51 but no, tomorrow
18:51 http://www.renotownmall.org/
18:51 is right by the hotel
18:53 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 but there is specialty sushi all over town :)
18:56 rangi no sushi for me
18:56 its a desert
18:56 thats been on a truck or a plane for a while :)
18:57 (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 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 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 if you are allowed to walk in reno
19:00 i know they frowned on that malarkey in plano
19:00 :)
19:00 oleonard Shane-S: Firebug tells me you want to set the background-color on .navbar-static-top .navbar-inner {}
19:01 rangi: Urban planners know better than you when it's okay to walk.
19:02 rangi :)
19:02 @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 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 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 so that would be ok
19:05 busla joined #koha
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 hmm...might have to see if they have FB for chrome, cause inspect element sucks
19:09 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:20 rambutan joined #koha
19:23 Oak later guys
19:23 Oak joined #koha
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 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 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 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
19:46 pianohacker joined #koha
19:52 meliss joined #koha
20:04 rangi now, this is what i call fusion
20:04 http://www.tripadvisor.com/Res[…]-Reno_Nevada.html
20:05 cait lol
20:06 oleonard I'm definitely game for that
20:06 cait :)
20:06 i wouldn't mind trying donuts
20:06 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 yeah
20:11 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:13 haxan joined #koha
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 The answer was "delete them" no problem
20:16 ?
20:16 rangi yes
20:16 http://irc.koha-community.org/[…]3-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 but yesterday I used "Batch item modification"
20:20 to modify two items bar codes
20:21 and this made the record invisible of these two items
20:21 I could search for barcodes but if a search by the title it didn't appear
20:22 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 i have no idea what your provider has done
20:24 so cant say anything with 100% certainty
20:24 haxan I can? I have access only to interface not to the server
20:24 meliss joined #koha
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 can i backup the database from the tools?
20:27 rangi you can if it was installed using the packages
20:27 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 if there are any local modifications
20:30 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 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 haxan: like i said, not a koha problem thats a problem between you and your vendor
20:31 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 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 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 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[…]L_Reports_Library
20:36 rangi http://wiki.koha-community.org[…]rts_Library#Title.2FSubtitle_List
20:37 haxan yes it was useful
20:37 thanks
20:37 I saw it yesterday
20:38 I work with books, serials and archives
20:38 I am trying to figure out to open a new search option to look for the series of archives
20:38 any field of MARC suggested?
20:39 The series of archives are different from the series of books, I guess I can't use field 490
20:40 or 440
20:41 rangi probably a question for a cataloguer, i dont know
20:42 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 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 Or examples of how other libraries with similar collections do it.
20:43 rangi or maybe ask on somethign like AUTOCAT
20:43 or the main koha lists
20:44 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 the mailing list has 3000
20:45 so id ask on the mailing list for somethign like that
20:45 brb
20:45 haxan you can help with a sql?
20:45 just asking?
20:46 I have this line: WHERE  items.itype=<<Selecciona tipo de ítem|items.itype>>
20:47 But I cant see the dropdown options for item type
20:47 is this a problem with koha or the code is wrong?
20:47 cait it's itypes
20:47 not items.itype
20:49 haxan Do you have the same problem with items.itype???
20:49 cait your code is wrong
20:49 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 and it works}
20:51 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 like that
20:55 haxan yes
20:56 but wrong
20:56 I found the answer is this: itemtype = <<Item Type|itemtypes>>
20:57 itemtypes only works in my db
20:57 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 items.itype is a column
20:59 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 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 at least not from me, which is why the :)
21:01 haxan Well, I hope to come back soon, thanks
21:02 bye
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: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 joined #koha
21:14 haxan hi guys again
21:14 a question
21:14 wahanui hmmm... a question is "What is the meaning of life, the universe and everything?"
21:14 haxan ?
21:14 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 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 and then you have one, to limit by branch
21:19 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 with sql
21:21 rangi um
21:21 10:18 <@rangi> thats not how sql works haxan
21:21 10:18 <@rangi> if you want all, you just dont limit by branchcode
21:21 10:19 <@rangi> make a separate report called all branches or something
21:21 10:19 <@rangi> and then you have one, to limit by branch
21:21 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 maximep left #koha
21:21 rangi no
21:21 just dont limit it
21:23 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[…]L_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 what i thought i can do is to have a big report where i can select the report i want
21:27 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 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 you can't have 2 WHERE statements
21:31 haxan ok
21:31 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 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 schema?
21:34 wahanui well, schema is tracked in git. or found at http://schema.koha-community.org
21:35 drnoe left #koha
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 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 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 @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 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 it works
21:51 wahanui But it also eats babies.
21:52 cait eythian++
21:53 rangi haxan: i did
21:53 haxan the problems was borrowers
21:53 it has nothing to do with the others
21:54 it has the time variable
21:54 bag wow bot arguement that's great
21:54 haxan something like that
21:54 when a user borrow a book then it created colums and tables about time
21:55 it works with branches but not with catalog tables
21:56 I guess this is called in koha cron jobs
22:07 haxan joined #koha
22:12 cait good night all :)
22:14 mtompset Good night, cait.
22:14 Have a great day (24 hour period), #koha.
22:17 cait left #koha
22:27 haxan the hour of my server is 30 minutes advanced
22:27 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 pato joined #koha
22:44 rambutan than
22:57 jcamins rambutan: yes.
22:57 rambutan it's the weekend!
22:57 rambutan left #koha
22:57 jcamins rangi: that yes was for you.
23:45 bgk joined #koha

← Previous day | Today | Next day → | Search | Index

koha1