Time Nick Message 22:41 jcamins_away eythian: great, thanks. 22:21 eythian http://www.mapstd.com/ 21:36 huginn eythian: The operation succeeded. 21:36 eythian @later tell hdl thanks :) 21:36 eythian jcamins_away: yes. They are regular scripts, so it's OK for them to depend on anything that Koha does. 21:25 cait night all :) 20:33 rangi heh 20:33 mtj bah, rangi bet me to the koha-list email 19:55 huginn rangi: The current temperature in Edinburgh, United Kingdom is 12.0°C (8:54 PM BST on April 01, 2012). Conditions: Mostly Cloudy. Humidity: 74%. Dew Point: 8.0°C. Pressure: 29.98 in 1015 hPa (Steady). 19:55 rangi @wunder Edinburgh,UK 19:51 Brooke I pick aeternal summer. 19:51 huginn cait: The current temperature in Taegerwilen, Taegerwilen, Germany is 4.1°C (9:49 PM CEST on April 01, 2012). Conditions: Clear. Humidity: 59%. Dew Point: -3.0°C. Windchill: 4.0°C. Pressure: 29.95 in 1014 hPa (Rising). 19:51 cait @wunder Konstanz 19:51 cait it's spring :) 19:51 cait nope 19:49 rangi It's Autumn 19:49 huginn rangi: The current temperature in Wellington, New Zealand is 13.0°C (7:00 AM NZST on April 02, 2012). Conditions: Clear. Humidity: 94%. Dew Point: 12.0°C. Pressure: 30.15 in 1021 hPa (Steady). 19:49 rangi @wunder nzwn 19:43 Brooke I'm close though, right? 19:42 gmcharlt many have tried to guess my origins, none have hit the mark 19:42 * Brooke suspects his mum was a jedi and his da was a ninja. 19:41 Brooke the force is strong in that one. 19:41 Brooke gmcharlt is part ninja 19:41 * Brooke comforts Rangi 19:41 rangi But gmcharlts comment was better 19:41 rangi Darn more ppl went for my koha release 19:37 Brooke o/ 19:26 cait still some left 19:26 cait oh right 19:26 jcamins_away cait: not here. 19:26 cait april 1st is over... 19:14 * jcamins_away laughs appreciatively. 17:47 mle hey cait 17:39 cait hi mle :) 17:39 mle ¬¬ 16:48 kmkale *with sql 16:48 kmkale with we cant solve this problem in a generic way though. it will be site specific. 16:46 kmkale worth a try 16:46 jcamins You're going to have to write a new Perl script anyway, why not use SQL? 16:45 kmkale kbarcode then. but would love to be able to solve this within koha 16:45 kmkale :( 16:44 jcamins Yeah, I think it can only be done with SQL. 16:44 jcamins Ah. 16:44 kmkale a client wants this. they have barcodes i described 16:43 huginn 04Bug http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7468 enhancement, P5 - low, ---, cnighswonger, NEW , Add label to batch by barcode range 16:43 kmkale trying to create barcode labels where the librarian can give a range. bug 7468 16:42 wahanui the first question is "What are you trying to do?" 16:42 jcamins the first question? 16:42 jcamins No. 16:41 kmkale pqf? 16:41 jcamins Not with CCL. 16:40 kmkale shame. 16:40 kmkale and no way of selecting a range of strings either. right? 16:39 jcamins No. 16:38 kmkale This works "select barcode from items where substring_index(barcode,'-',-1) between 1 and 5;" Is there a way to do this in ccl? 16:00 huginn kmkale: The current temperature in Mumbai, India is 30.0°C (9:10 PM IST on April 01, 2012). Conditions: Smoke. Humidity: 62%. Dew Point: 22.0°C. Pressure: 29.80 in 1009 hPa (Steady). 16:00 kmkale @weather Mumbai 12:38 kmkale will play around with it. 12:37 kmkale nah doesn't work 12:36 kmkale thats an idea 12:35 jcamins And then you also have to check for the itemtype. 12:35 jcamins SUBSTRING_INDEX(barcode, '-', -2) > numericbegin AND SUBSTRING_INDEX(barcode, '-', -2 < numericend 12:34 jcamins You could do some fancy SUBSTRING_INDEX stuff, though. 12:34 jcamins Yeah, you can't use strcmp with that. 12:34 kmkale using it utf8_general_ci 12:33 jcamins Oh boy. 12:33 kmkale sit-B-1 to sit-B-99999 the B is the item type so it varies like sit-CD-67 etc 12:33 jcamins http://dev.mysql.com/doc/refman/5.1/en/string-comparison-functions.html#function_strcmp 12:33 jcamins You may want to consider using COLLATE utf8_general_ci 12:32 jcamins What do the barcodes look like? 12:32 jcamins kmkale: hm. And you're sure that your query shouldn't be selecting almost everything? 12:32 kmkale jcamins: nah, switching gives 0 results 12:30 jcamins You may need to switch the -1 and 1. 12:30 kmkale jcamins: nope. that selected almost everything in the db 12:24 * kmkale is trying it out 12:23 kmkale been playing with it but haven't tried that exactly 12:23 kmkale yay.. 12:22 jcamins SELECT whatever FROM items WHERE STRCMP('barcodestart', barcode) = -1 AND STRCMP('barcodeend', barcode) = 1; 12:21 jcamins Yes. 12:20 jcamins *query 12:20 jcamins Eww. You could, but I think there's a way to do it in a queyr. 12:20 kmkale write a loop with strcmp? 12:19 jcamins kmkale: you could do it with MySQL, but I don't remember exactly how. 12:19 wahanui no cait is here 12:19 kmkale no cait 12:17 cait I think they do something on ranges of barcodes 12:17 cait kmkale: perhaps check the inventory or label module? 12:09 kmkale does mysql do range searches on strings? I know that between does not work. Tried it. 12:08 kmkale aahh jcamins thanks but then its no use :( 11:42 cait k 11:42 jcamins cait: no, Zebra doesn't do non-numeric range searching. 11:41 cait jcamins: what if the barcode is not numeric? will it still work? 11:40 jcamins Add barcode:n to record.abs. 11:40 jcamins You'd have to modify the Zebra config. 11:40 jcamins Ah. 11:39 kmkale bc=<barcode> works 11:39 kmkale like bc,ge=<barcode> and bc,le-<barcode> does not work 11:39 kmkale I am looking for a ccl query 11:38 jcamins_away kmkale: in circulation? 11:37 kmkale I am looking for a way to search a barcode range. Is it possible? 11:37 kmkale jcamins_away++ 11:32 cait :) 11:32 cait jcamins++ 11:32 cait yep :) 11:27 jcamins_away Woohoo! 11:26 jcamins_away I hadn't read the post yet. 11:26 jcamins_away Ah. 11:21 cait being number one in the sign-off statistics :) 11:15 jcamins_away What did I do? 08:03 kmkale Namaskaar rangi cait :) 07:25 cait jcamins++ 07:19 cait hi kmkale and rangi 07:19 rangi hi kmkale 07:16 kmkale Namaste #koha 06:18 cait hi #koha