← 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