IRC log for #koha, 2012-04-01

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

All times shown according to UTC.

Time Nick Message
02:03 NateC joined #koha
02:08 NateC left #koha
03:35 jcamins_away joined #koha
06:17 cait joined #koha
06:17 cait hi #koha
07:15 kmkale joined #koha
07:15 kmkale Namaste #koha
07:18 rangi hi kmkale
07:19 cait hi kmkale and rangi
07:20 Topic for #koha is now Koha 7287.12.2 released
07:25 cait jcamins++
08:03 kmkale Namaskaar rangi cait :)
09:19 stuartyeates left #koha
11:15 jcamins_away What did I do?
11:21 cait being number one in the sign-off statistics :)
11:25 jcamins_away Ah.
11:26 I hadn't read the post yet.
11:26 Woohoo!
11:32 cait yep :)
11:32 jcamins++
11:32 :)
11:36 kmkale jcamins_away++
11:37 I am looking for a way to search a barcode range. Is it possible?
11:38 jcamins_away kmkale: in circulation?
11:38 kmkale I am looking for a ccl query
11:39 like bc,ge=<barcode> and bc,le-<barcode> does not work
11:39 bc=<barcode> works
11:39 jcamins Ah.
11:39 You'd have to modify the Zebra config.
11:40 Add barcode:n to record.abs.
11:40 cait jcamins: what if the barcode is not numeric? will it still work?
11:41 jcamins cait: no, Zebra doesn't do non-numeric range searching.
11:41 cait k
12:08 kmkale aahh jcamins thanks but then its no use :(
12:09 does mysql do range searches on strings? I know that between does not work. Tried it.
12:16 cait kmkale: perhaps check the inventory or label module?
12:17 I think they do something on ranges of barcodes
12:18 kmkale no cait
12:18 wahanui no cait is here
12:19 jcamins kmkale: you could do it with MySQL, but I don't remember exactly how.
12:19 kmkale write a loop with strcmp?
12:20 jcamins Eww. You could, but I think there's a way to do it in a queyr.
12:20 *query
12:20 Yes.
12:22 SELECT whatever FROM items WHERE STRCMP('barcodestart', barcode) = -1 AND STRCMP('barcodeend', barcode) = 1;
12:23 kmkale yay..
12:23 been playing with it but haven't tried that exactly
12:23 * kmkale is trying it out
12:29 kmkale jcamins: nope. that selected almost everything in the db
12:30 jcamins You may need to switch the -1 and 1.
12:31 kmkale jcamins: nah, switching gives 0 results
12:32 jcamins kmkale: hm. And you're sure that your query shouldn't be selecting almost everything?
12:32 What do the barcodes look like?
12:32 You may want to consider using COLLATE utf8_general_ci
12:33 http://dev.mysql.com/doc/refma[…]l#function_strcmp
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 Oh boy.
12:33 kmkale using it utf8_general_ci
12:33 jcamins Yeah, you can't use strcmp with that.
12:34 You could do some fancy SUBSTRING_INDEX stuff, though.
12:35 SUBSTRING_INDEX(barcode, '-', -2) > numericbegin AND SUBSTRING_INDEX(barcode, '-', -2 < numericend
12:35 And then you also have to check for the itemtype.
12:35 kmkale thats an idea
12:37 nah doesn't work
12:38 will play around with it.
13:36 kyleh_ joined #koha
15:57 kmkale joined #koha
15:59 kmkale @weather Mumbai
15:59 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:06 Soupermanito joined #koha
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:39 jcamins No.
16:39 kmkale and no way of selecting a range of strings either. right?
16:40 shame.
16:41 jcamins Not with CCL.
16:41 kmkale pqf?
16:41 jcamins No.
16:41 the first question?
16:41 wahanui the first question is "What are you trying to do?"
16:43 kmkale trying to create barcode labels where the librarian can give a range. bug 7468
16:43 huginn 04Bug http://bugs.koha-community.org[…]w_bug.cgi?id=7468 enhancement, P5 - low, ---, cnighswonger, NEW , Add label to batch by barcode range
16:43 kmkale a client wants this. they have barcodes i described
16:44 jcamins Ah.
16:44 Yeah, I think it can only be done with SQL.
16:44 kmkale :(
16:45 kbarcode then. but would love to be able to solve this within koha
16:45 jcamins You're going to have to write a new Perl script anyway, why not use SQL?
16:46 kmkale worth a try
16:47 with we cant solve this problem in a generic way though. it will be site specific.
16:48 *with sql
17:38 mle ¬¬
17:39 cait hi mle :)
17:47 mle hey cait
19:12 Topic for #koha is now oclc have decided to relicense all MARC records cc0
19:14 * jcamins_away laughs appreciatively.
19:25 cait april 1st is over...
19:26 jcamins_away cait: not here.
19:26 cait oh right
19:26 still some left
19:35 libsysguy joined #koha
19:36 Brooke joined #koha
19:36 Brooke o/
19:37 Topic for #koha is now "Gullible" is not in the dictionary.
19:40 rangi Darn more ppl went for my koha release
19:40 But gmcharlts comment was better
19:41 * Brooke comforts Rangi
19:41 Brooke gmcharlt is part ninja
19:41 the force is strong in that one.
19:41 * Brooke suspects his mum was a jedi and his da was a ninja.
19:42 gmcharlt many have tried to guess my origins, none have hit the mark
19:42 Brooke I'm close though, right?
19:48 rangi @wunder nzwn
19:48 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 It's Autumn
19:50 cait nope
19:50 it's spring :)
19:50 @wunder Konstanz
19:50 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:50 Brooke I pick aeternal summer.
19:55 rangi @wunder Edinburgh,UK
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).
20:33 mtj bah, rangi bet me to the koha-list email
20:33 rangi heh
20:34 kathryn joined #koha
21:24 cait night all :)
21:25 cait left #koha
21:35 eythian jcamins_away: yes. They are regular scripts, so it's OK for them to depend on anything that Koha does.
21:35 @later tell hdl thanks :)
21:35 huginn eythian: The operation succeeded.
22:21 eythian http://www.mapstd.com/
22:41 jcamins_away eythian: great, thanks.
23:20 sekjal joined #koha
23:21 sekjal left #koha
23:28 papa joined #koha

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

koha1