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