IRC log for #koha, 2012-04-01

All times shown according to UTC.

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

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary