| Time |
Nick |
Message |
| 00:15 |
|
gmcharlt left #koha |
| 00:17 |
|
Nate left #koha |
| 00:24 |
|
biglego left #koha |
| 00:39 |
|
biglego joined #koha |
| 01:07 |
|
gmcharlt joined #koha |
| 01:36 |
|
IrmaCalyx left #koha |
| 01:40 |
|
user77 joined #koha |
| 01:41 |
|
user77 is now known as rhcl_home |
| 02:07 |
|
pianohackr|work left #koha |
| 02:09 |
|
richard is now known as rich-away |
| 02:20 |
chris_n |
@wunder 28334 |
| 02:20 |
munin |
chris_n: The current temperature in Erwin, North Carolina is -1.0�C (9:01 PM EST on February 16, 2010). Conditions: Clear. Humidity: 44%. Dew Point: -12.0�C. Windchill: -4.0�C. Pressure: 29.88 in 1012 hPa (Falling). |
| 02:23 |
chris |
@wunder wellington nz |
| 02:23 |
munin |
chris: The current temperature in Wellington, New Zealand is 17.0�C (3:00 PM NZDT on February 17, 2010). Conditions: Light Rain. Humidity: 94%. Dew Point: 16.0�C. Pressure: 29.98 in 1015 hPa (Steady). |
| 02:24 |
braedon|work |
@wunder tauranga nz |
| 02:24 |
munin |
braedon|work: The current temperature in Tauranga Aerodrome Aws, New Zealand is 23.0�C (1:00 PM NZDT on February 17, 2010). Conditions: . Humidity: 75%. Dew Point: 19.0�C. Pressure: 30.00 in 1016 hPa (Falling). |
| 02:28 |
chris_n |
it appears that Near Eastern University has several desirable features in their custom koha work |
| 02:28 |
|
location mapping, hourly loans |
| 02:28 |
chris |
tumer was always good about committing back, but i think they might still be on cvs |
| 02:29 |
|
im sure if someone emailed he would give them the code |
| 02:29 |
chris_n |
I wonder how impossible of a job it would be to merge them in |
| 02:29 |
|
I have |
| 02:29 |
chris |
cool |
| 02:29 |
chris_n |
I did it with the thought that it might be possible to at least merge in the features we want |
| 02:29 |
|
if not all of the work |
| 02:30 |
chris |
yep |
| 02:31 |
chris_n |
the git repo goes back pretty far does it not? |
| 02:31 |
|
1.2.x maybe? |
| 02:31 |
chris |
heck no |
| 02:31 |
|
only 2007 |
| 02:31 |
chris_n |
hmm |
| 02:31 |
chris |
well the repo goes back that far |
| 02:31 |
chris_n |
what is the tag 'version-1-2-1' |
| 02:31 |
chris |
cos we converted from cvs |
| 02:32 |
gmcharlt |
forward-porting would be a challenge - I'd rather see a de novo implementation of hourly loans unless Tumer has been keeping up with HEAD |
| 02:32 |
chris |
yeah |
| 02:32 |
|
hourly loans isnt actually that hard |
| 02:32 |
|
it needs a database change returndate needs to be a datetime |
| 02:32 |
chris_n |
the mapping stuff was my primary thought |
| 02:32 |
chris |
instead of a date |
| 02:32 |
|
chris_n: thats pretty localised |
| 02:33 |
|
im not sure it would be generalisable in an easy way |
| 02:33 |
gmcharlt |
that's ignoring the functionality consequences, which aren't nearly so trivial |
| 02:33 |
chris_n |
yeah, but the logic and techique might be useful |
| 02:33 |
chris |
gmcharlt: its pretty well defined tho, is this datetime greater than this datetime |
| 02:34 |
|
its not like having to do something with search, or cataloguing :) |
| 02:34 |
chris_n |
lol |
| 02:34 |
gmcharlt |
if the circ code were better organized, I might agree with you |
| 02:34 |
chris |
cant possibly be worse than Search.pm |
| 02:35 |
chris_n |
the mapping is animated gifs |
| 02:36 |
|
probably overlayed on the fly with a graphics module |
| 02:36 |
|
actually, it would probably not be too hard to impliment from scratch |
| 02:37 |
gmcharlt |
library mapping is much easier than hourly loans :) |
| 02:37 |
chris_n |
but in any case, the images would be very localized |
| 02:37 |
* chris_n |
imagines 'click here for the street view' |
| 02:38 |
gmcharlt |
the old LL RFC on hourly loans is still pretty comprehensive |
| 02:38 |
|
http://wiki.koha.org/doku.php?[…]c32_hourly_circ&s[]=hourly&s[]=loans |
| 02:38 |
chris |
yep |
| 02:38 |
|
its probably still all in someones brain too |
| 02:38 |
|
the actual implementation |
| 02:38 |
gmcharlt |
not saying that you'd have to address *all* of that, but there's definitely more to it than just changing issues.date_due to a timestamp |
| 02:39 |
chris_n |
did LL never impliment this even in LEK? |
| 02:39 |
chris |
they say its in LLEK |
| 02:39 |
|
brendan left #koha |
| 02:40 |
gmcharlt |
the whole list of things claimed to be in it: http://www.liblime.com/product[…]lek-release-notes |
| 02:40 |
chris_n |
Tumer's work looks nice |
| 02:41 |
|
mapping: http://library.neu.edu.tr/cgi-[…]=%20NEU%20Library[Cyprus%20Section]%20%282%29%3Cbr%3E |
| 02:41 |
chris |
heh you get a credit chris_n |
| 02:41 |
chris_n |
how so? |
| 02:41 |
chris |
Add Quick Spine Label Printer (Chris Nighswonger). |
| 02:41 |
|
thats why people thought it was you |
| 02:42 |
chris_n |
ah ha |
| 02:42 |
* gmcharlt |
pulls off the mask from chris_n to reveal Kyle? |
| 02:43 |
* chris_n |
is caught in the telephone booth :-) |
| 02:43 |
chris |
so yeah, LLEK has hourly loans apparently |
| 02:45 |
chris_n |
hmm: Performance enhancement: Do not embed item data in internally stored MARC data. |
| 02:46 |
chris |
yeah that we need for 3.4 |
| 02:46 |
|
it slows circ down something mental |
| 02:47 |
|
we can embed it there if we want, but not at the point of circulation, it could be done as a batch process, like the zebra indexing |
| 02:47 |
|
brendan joined #koha |
| 02:47 |
chris |
or we could just leave it out, and create it when needed (export or z3950 query etc) |
| 02:47 |
gmcharlt |
chris: I think there's any number of volunteers, myself included, lined up to work on that for 3.4 |
| 02:47 |
chris |
awesome |
| 02:48 |
gmcharlt |
and preferably, I'd leave it out entirely excpept for export and indexing |
| 02:48 |
chris |
*nod* |
| 02:49 |
|
as long as we do search right, so it knows to query the items table, then that would be fine |
| 02:51 |
ebegin |
gmcharlt, about the dependencies (sorry, I had to step out :) )... do you know which part of Makefile.PL look if they are installed? |
| 02:51 |
gmcharlt |
ebegin: it's part of what ExtUtils::MakeMaker handles |
| 02:52 |
chris_n |
gmcharlt: it seems one might be able to setup a target just to test for deps |
| 02:52 |
gmcharlt |
the list of dependencies is the PREREQ_PM list, of course |
| 02:52 |
|
chris_n: I'm not stopping you |
| 02:53 |
ebegin |
ok, and WriteMakeFile is a function of MakeMaker? |
| 02:53 |
chris |
make deps |
| 02:53 |
* chris_n |
adds it to his LIRO buffer |
| 02:53 |
chris_n |
last in, random out |
| 02:53 |
chris |
course you would have had to run perl Makefile.PL at least once for that to work though |
| 02:54 |
chris_n |
chris: right, but that's the idea |
| 02:54 |
gmcharlt |
which gives you the list of unmet deps, rendering make deps superfluous |
| 02:54 |
chris_n |
then you can verify remaining deps |
| 02:54 |
chris |
i guess you could use make deps if you forgot |
| 02:54 |
|
or it scrolled off your screen |
| 02:54 |
gmcharlt |
EU::MM doesn't create a deps target |
| 02:54 |
* chris_n |
has at times had problems with various version, along with forgetting |
| 02:55 |
chris |
i think taking about.pl |
| 02:55 |
chris_n |
of course constructing a small script would be easier probably |
| 02:55 |
chris |
abstracting the list of dependencies out |
| 02:55 |
chris_n |
about.pl is missing version #'s |
| 02:55 |
chris |
so that about.pl and what_perl_modules_am_i_missing.pl |
| 02:55 |
|
can use it |
| 02:55 |
gmcharlt |
Makefile.PL has the best list |
| 02:55 |
chris |
*nod* |
| 02:56 |
|
about.pl should use the same list as Makefile.PL |
| 02:56 |
chris_n |
maybe C4::Constants |
| 02:56 |
chris |
it should be maintained in one place |
| 02:56 |
gmcharlt |
chris_n: I don't like C4::Constants as the name, but certainly C4::Something |
| 02:57 |
chris_n |
the labels/pcards code uses several constants which would be nice to centralize |
| 02:57 |
gmcharlt |
whatever it's called, can also be used to track which modules are required for optional features |
| 02:57 |
chris |
*nod* |
| 02:57 |
chris_n |
true |
| 02:58 |
chris |
and lets put an export_list_in_html method in it |
| 02:58 |
ebegin |
What about create a simple function that tells you which dependencies are missing? This function could be called independently of the Makefile. There is something similar when installing druapl. |
| 02:58 |
chris |
so we can run that and put it somewhere |
| 02:58 |
|
each release |
| 02:59 |
gmcharlt |
ebegin: that woudl be part and parcel of what we're discussing |
| 02:59 |
|
but the last thing I want to see is Yet Another Separate List of Dependent Perl Modules |
| 03:00 |
chris |
yep it has to be used by all things |
| 03:00 |
gmcharlt |
while we're talking about this sort of housekeeping |
| 03:00 |
ebegin |
I agree that we must have a single list. |
| 03:00 |
gmcharlt |
one thing I'd like to do for 3.4 is rearrange the directories |
| 03:00 |
chris_n |
housekeeping++ |
| 03:00 |
gmcharlt |
at the very list, to stick the staff cgi directories under a top-level staff or intranet |
| 03:01 |
chris_n |
yup |
| 03:01 |
chris |
yep |
| 03:04 |
chris_n |
I'd like to implement Locale::Currency::Format to handle currency issues for 3.4 |
| 03:05 |
chris |
sounds better than the current hodgepodge |
| 03:07 |
chris_n |
it works pretty nice actually |
| 03:08 |
gmcharlt |
chris: would you have time to test and sign off on fredericd's new translation wrapper? |
| 03:09 |
chris |
ill give it a whirl tonight |
| 03:10 |
chris_n |
we could add a syspref for the ISO4217 currency identifier, keep track of the numbers, and convert them per the syspref for display. |
| 03:10 |
gmcharlt |
s/currency/currencies/ |
| 03:11 |
|
chris: thanks |
| 03:12 |
chris |
thats his trans branch eh? |
| 03:12 |
gmcharlt |
yep |
| 03:13 |
* chris |
sets up a remote and does the pull |
| 03:13 |
|
IrmaCalyx joined #koha |
| 03:13 |
chris |
didn't explode, so thats a good start |
| 03:14 |
gmcharlt |
only issue my eyeball has with it thus far is the "GPL 2.1" |
| 03:14 |
chris |
yeah it looks a lot cleaner, i like having all the code in a module |
| 03:16 |
|
IrmaCalyx left #koha |
| 03:20 |
chris |
trying a test translation |
| 03:22 |
|
bunch of warns .. but seems to be doing what it should |
| 03:23 |
|
rich-away is now known as richard |
| 03:23 |
chris |
perl -I ../../ translate create test-TEST |
| 03:23 |
|
and i end up with |
| 03:23 |
|
-rw-r--r-- 1 chrisc chrisc 293532 2010-02-17 16:20 test-TEST-i-opac-t-prog-v-3002000.po |
| 03:24 |
|
-rw-r--r-- 1 chrisc chrisc 2348870 2010-02-17 16:20 test-TEST-i-staff-t-prog-v-3002000.po |
| 03:24 |
|
-rw-r--r-- 1 chrisc chrisc 84010 2010-02-17 16:20 test-TEST-pref.po |
| 03:25 |
|
poedit tells me they are valid |
| 03:25 |
|
perl -I ../../ translate install test-TEST |
| 03:25 |
|
chrisc stuffdev:~/koha/misc/translator$ ls ../../koha-tmpl/opac-tmpl/prog/ |
| 03:25 |
|
en en-NZ famfamfam images itemtypeimg test-TEST |
| 03:25 |
|
so far so good |
| 03:27 |
|
./koha-tmpl/intranet-tmpl/prog/test-TEST/modules/admin/preferences/creators.pref |
| 03:27 |
|
seems to work just fine |
| 03:27 |
braedon|work |
random question, but does anyone know anything about managing launchpad ppa's? I'm setting up a ppa with all the perl dependencies not in the ubuntu repos, and i have hit a bit of a snag with one |
| 03:28 |
chris_n |
it would be nice to add some ajax to avoid full page refreshes in the staff client |
| 03:28 |
chris |
not me sorry braedon|work |
| 03:29 |
braedon|work |
i really don't have a clue what i am doing - making it up as i go with help from assorted guides and tools |
| 03:29 |
chris_n |
it might actually speed up circulation a bit |
| 03:30 |
chris |
yup |
| 03:31 |
|
Amit joined #koha |
| 03:31 |
Amit |
hi all |
| 03:31 |
chris_n |
heya Amit |
| 03:31 |
Amit |
heya chris_n |
| 03:32 |
chris |
hi Amit |
| 03:32 |
Amit |
hi chris |
| 03:37 |
|
walter joined #koha |
| 03:37 |
walter |
chris, you about? have a quick question about http://git.catalyst.net.nz/gw?[…]945fce8a2d4452d7a |
| 03:38 |
chris |
yep |
| 03:38 |
walter |
setting it up for a demo site and i'm not familiar where those files eventually end up on debian box |
| 03:38 |
|
i.e. i'm not a koha guy and don't know its usual filesystem layout |
| 03:39 |
chris |
youll want to do dev install |
| 03:39 |
walter |
hmm |
| 03:39 |
chris |
then it will be running out of hte git repo |
| 03:39 |
walter |
it's a running install already |
| 03:39 |
chris |
and you can cherry-pick that in |
| 03:39 |
walter |
yeah, i would normally... but these guys aren't a git shop quite yet |
| 03:39 |
chris |
ahh, well it will totally depend on where the person installing it decided to put the files |
| 03:39 |
|
try /usr/share/koha |
| 03:39 |
walter |
ok, cool |
| 03:40 |
|
looks like a winner for that |
| 03:40 |
|
think i can see where the opac stuff lives there |
| 03:40 |
chris |
cool |
| 03:40 |
walter |
but template lives? |
| 03:41 |
|
i.e. koha-tmpl/opac-tmpl/prog/en/modules/opac-results.tmpl |
| 03:41 |
chris |
is there a koha-tmpl dir there? or opac-tmpl? |
| 03:41 |
|
if you check the koha apache conf |
| 03:42 |
walter |
ls /usr/share/koha |
| 03:42 |
|
bin doc intranet lib man misc opac |
| 03:42 |
|
|
| 03:42 |
* walter |
checks |
| 03:42 |
chris |
check the docroot there |
| 03:42 |
|
that should have it |
| 03:43 |
walter |
htdocs, cool |
| 04:08 |
|
richard left #koha |
| 04:08 |
|
rhcl_home is now known as rhcl_home_sleep |
| 04:14 |
* chris_n |
messes with Finance::Quote which could make the exchange rate code in koha real-time |
| 04:14 |
chris_n |
it even grabs stock quote |
| 04:20 |
|
walter left #koha |
| 04:26 |
|
braedon|home joined #koha |
| 04:29 |
|
Amit left #koha |
| 04:32 |
|
braedon|home1 left #koha |
| 04:40 |
|
anasha joined #koha |
| 06:03 |
|
greenmang0 joined #koha |
| 07:00 |
|
Topic for #koha is now Discussion channel for the Koha ILS | Don't ask to ask, just ask |
| 07:12 |
Ropuch |
Morning #koha |
| 07:12 |
|
Hi chris_n |
| 07:13 |
|
..& chris_without_n |
| 07:13 |
|
;> |
| 07:13 |
chris |
:) |
| 07:27 |
wajasu |
i've staged and imported my marc records with 925 items. if i don't have a barcode, is there a script that will generate one for all items without one? |
| 07:29 |
Ropuch |
Hm |
| 07:30 |
|
magnus joined #koha |
| 07:31 |
Ropuch |
1. Grab the biggest existing barcode, assign it to variable, grab & update first record without barcode with variable, increase variable, grab another |
| 07:31 |
|
I think it can be done from sql |
| 07:32 |
brendan |
first patch for 3.4 signed off on? anyways that's cool |
| 07:32 |
chris |
it'll probably actually go into 3.2 |
| 07:33 |
brendan |
well almost then |
| 07:33 |
chris |
it makes the sysprefs translatable, and makes the templates translation work better |
| 07:33 |
brendan |
I'll save that comment for the first patch then |
| 07:33 |
chris |
:) |
| 07:33 |
brendan |
:) yes just reading through it -- pretty cool |
| 07:33 |
chris |
i won't actually sign off anything for 3.4 until we branch 3.2 |
| 07:34 |
brendan |
do we have a git.koha-community.org started yet? |
| 07:34 |
chris |
nope, but wouldnt be hard to do |
| 07:35 |
brendan |
would be cool to have all the developers switch there git.configs to that |
| 07:35 |
chris |
i can push to git.koha.org .. so we dont actually need it just yet |
| 07:36 |
|
unless that changes |
| 07:36 |
brendan |
I don't know the correct saying here |
| 07:36 |
|
something like in for a penny |
| 07:37 |
|
but, good call "so we dont actually need it just yet" |
| 07:38 |
|
laurence joined #koha |
| 07:49 |
|
Amit joined #koha |
| 07:58 |
|
francharb joined #koha |
| 08:02 |
|
paul_p joined #koha |
| 08:02 |
chris |
hi paul_p |
| 08:02 |
paul_p |
hi chris |
| 08:16 |
|
kf joined #koha |
| 08:16 |
kf |
good morning #koha |
| 08:17 |
chris |
hiya kf |
| 08:18 |
kf |
hi chris |
| 08:20 |
|
Kivutar joined #koha |
| 08:21 |
|
Amit left #koha |
| 08:35 |
|
Amit joined #koha |
| 08:44 |
|
davi joined #koha |
| 09:02 |
|
nicomo joined #koha |
| 09:50 |
kf |
ok, translation question - chris? still awake? |
| 09:54 |
gmcharlt |
greetings #koha |
| 09:56 |
kf |
@later tell chris many submit buttons (i.e. make payment, add credit, renew all, return all, add item, add & duplicate...) are still English in my translation, I cant find the text in pootle - is this a template problem or does pootle need an update? |
| 09:56 |
munin |
kf: The operation succeeded. |
| 09:56 |
kf |
good morning gmcharlt |
| 09:58 |
gmcharlt |
kf: translation glitch - the CGI scripts that consume some of those submit buttons currently rely on the exact English wording of the submit value |
| 09:59 |
kf |
sure? I thought we had them in German in an earlier version |
| 10:00 |
|
this is what my librarian told me too - she is unhappy that they are in enlgish now, after we did an update of the translation :( |
| 10:02 |
|
hm, how can that be fixed? perhaps I can work on it? |
| 10:08 |
Amit |
heya nicomo |
| 10:08 |
|
hi kf |
| 10:08 |
nicomo |
hi Amit |
| 10:09 |
gmcharlt |
kf: can you give me an example of a specific button? |
| 10:13 |
kf |
patron account: all buttons for fnies (credit, payment) all buttons in edit item |
| 10:15 |
|
additem.pl: buttons under form |
| 10:15 |
gmcharlt |
thanks |
| 10:17 |
kf |
and moremember.pl / circulation.pl : buttons under checkouts: return all, renew all, renew or return checked items |
| 10:18 |
|
I think there are more, but these are prominent places |
| 10:43 |
|
gmcharlt: write a bug report? I can add more examples there |
| 10:43 |
gmcharlt |
kf: please do |
| 10:43 |
kf |
ok |
| 10:49 |
|
gmcharlt: will do later, my colleague is updating our test installation now to latest head (we are only some patches behind but will look for examples when he is done) |
| 11:32 |
Ropuch |
Hello kf, gma |
| 11:32 |
|
gmcharlt ;> |
| 11:33 |
gmcharlt |
hi Ropuch |
| 11:33 |
Ropuch |
Is there a simple way to have items in label batch ordered by barcode? |
| 11:33 |
chris_n |
g'morning |
| 11:33 |
|
Ropuch: not atm |
| 11:33 |
gmcharlt |
Ropuch: amazing - all you have to do is ask a question about labels to make chris_n appear |
| 11:33 |
chris_n |
hehe |
| 11:34 |
Ropuch |
:)) |
| 11:34 |
chris_n |
Ropuch: some code could be added to order them that way |
| 11:35 |
|
if you'll open an enhancement bug for it, I'll look into it in the next few days |
| 11:37 |
Ropuch |
chris_n: we have enough bug for now I guess - I was hoping for "add ordered by barcode in X line of label-manager.pl" tip |
| 11:37 |
|
;> |
| 11:38 |
* chris_n |
looks |
| 11:41 |
chris_n |
Ropuch: as a hack you could add some code here: |
| 11:41 |
|
http://git.koha.org/cgi-bin/gi[…]a3ebe;hb=HEAD#l91 |
| 11:41 |
|
just after line 91 |
| 11:41 |
|
$items is a hashref |
| 11:43 |
|
arrayref rather |
| 11:43 |
|
to an array of hashes |
| 11:44 |
Ropuch |
Ok, I;m tryingm thanks for lightspeed response :) |
| 11:45 |
chris_n |
you can sort on the 'item_number' key of the hash |
| 11:45 |
|
iirc |
| 11:49 |
|
sorry Ropuch, here is where you want to be: |
| 11:49 |
|
http://git.koha.org/cgi-bin/gi[…]f5d5;hb=HEAD#l475 |
| 11:49 |
|
this line is where the barcode data is retrieved |
| 11:49 |
|
but that might be too late to do the sort |
| 11:50 |
|
so it may be better to do it at the point mentioned above with more code |
| 11:51 |
|
the long term solution is to add an item_sort method to C4::Creators::Batch |
| 11:51 |
Ropuch |
Huh |
| 11:52 |
|
I'll look into it after work |
| 11:52 |
chris_n |
the the method could be invoked at label generation time |
| 11:52 |
|
based on a checkbox in label-print.pl |
| 11:53 |
* chris_n |
wanders off to find breakfast |
| 12:00 |
|
Amit left #koha |
| 12:10 |
kf |
reboot |
| 12:10 |
|
kf left #koha |
| 12:30 |
hdl_laptop |
hi gmcharlt |
| 12:30 |
gmcharlt |
hi hdl_laptop |
| 12:30 |
hdl_laptop |
just saw your email on koha-devel |
| 12:33 |
gmcharlt |
yep |
| 12:33 |
hdl_laptop |
about translations, it is just the way it was before. |
| 12:33 |
|
not worse |
| 12:33 |
gmcharlt |
not really an excuse not to improve it if you're going to the trouble of changing it in the first palce |
| 12:34 |
hdl_laptop |
(and not better) |
| 12:35 |
|
I agree. But since ppl are more willing to be able to use a customized stylesheet rather than a stylesheet name adapted to languages, I thought this would be ok. |
| 12:36 |
|
I can revert that. |
| 12:37 |
gmcharlt |
in the short term, I don't think a revert is necessary unless you're out of time - a quick patch to update it to not need the full path, look for it relative to the active language, and have a fallback (to the default English stylsheet or to no XSLT at all) |
| 12:37 |
|
would do it |
| 12:37 |
hdl_laptop |
Note that the patch I sent for 3.2 uses XSLTResultsDisplay and XSLTDetailsDisplay as boolean and then uses "sub" system preferences for names |
| 12:38 |
gmcharlt |
that's a better way of doing it |
| 12:38 |
|
but if we do that for 3.2, either 3.0.x shoudl do exactly that |
| 12:38 |
|
or leave the sysprefs alone |
| 12:39 |
|
as the upgrade path of boolean -> free -> boolean + new sub sysprefs would be unwieldy for somebody going from 3.0.6 to 3.2.0 |
| 12:40 |
hdl_laptop |
mmm... |
| 12:40 |
|
no. |
| 12:40 |
|
OPACXSLResultsDisplay stay path or url |
| 12:41 |
|
(same as XSLOPACDisplay) |
| 12:41 |
|
But XSLResultsDisplay and XSLDetails desplay is Boolean. |
| 12:42 |
gmcharlt |
well, that's no good (the inconsistency) |
| 12:42 |
|
keeping the prefs as boolean, then adding four sub prefs seems better |
| 12:43 |
|
jwagner joined #koha |
| 12:44 |
hdl_laptop |
gmcharlt: ok |
| 12:48 |
gmcharlt |
hdl_laptop: thanks |
| 12:53 |
|
tomascohen joined #koha |
| 12:56 |
|
kf joined #koha |
| 12:58 |
|
collum joined #koha |
| 13:03 |
|
mib_r2h0c2 joined #koha |
| 13:09 |
|
owen joined #koha |
| 13:16 |
jwagner |
Good morning folks. |
| 13:16 |
|
@wunder 20817 |
| 13:16 |
munin |
jwagner: The current temperature in Langley Fork Park, McLean, Virginia is -1.6�C (8:13 AM EST on February 17, 2010). Conditions: Overcast. Humidity: 69%. Dew Point: -7.0�C. Windchill: -2.0�C. Pressure: 29.76 in 1007.7 hPa (Rising). |
| 13:20 |
kf |
hi jwagner |
| 13:20 |
|
@wunder Konstanz |
| 13:20 |
munin |
kf: The current temperature in Konstanz, Germany is 3.0�C (2:00 PM CET on February 17, 2010). Conditions: Mostly Cloudy. Humidity: 52%. Dew Point: -4.0�C. Pressure: 29.38 in 995 hPa (Falling). |
| 13:21 |
|
anasha left #koha |
| 13:22 |
jwagner |
Good morning, kf. You're warmer than we are, at least. In theory, things are supposed to warm up by the weekend.... |
| 13:23 |
kf |
snow it melting here - im happy about it :) |
| 13:23 |
Ropuch |
@wunder Wroclaw |
| 13:23 |
munin |
Ropuch: The current temperature in Wroclaw, Poland is -1.0�C (2:00 PM CET on February 17, 2010). Conditions: Mostly Cloudy. Humidity: 86%. Dew Point: -3.0�C. Windchill: -6.0�C. Pressure: 29.56 in 1001 hPa (Steady). |
| 13:24 |
jwagner |
I wish our snow would melt. Most of the major highways are still missing one lane, where all the snow got plowed. Since the roads aren't big enough in normal conditions to handle all the traffic, this means rush hour is REALLY a mess. |
| 13:28 |
|
biglego left #koha |
| 13:29 |
kf |
sounds bad, its not that bad here |
| 13:37 |
|
biglego joined #koha |
| 13:39 |
|
rhcl_home_sleep is now known as rhcl_home |
| 13:46 |
|
gmcharlt left #koha |
| 13:59 |
|
jdavidb joined #koha |
| 13:59 |
|
biglego left #koha |
| 14:01 |
|
gmcharlt joined #koha |
| 14:03 |
|
biglego joined #koha |
| 14:03 |
jdavidb |
Harrrrumph! |
| 14:05 |
jwagner |
That's my line. |
| 14:09 |
|
mib_r2h0c2 left #koha |
| 14:11 |
* owen |
looks for owen_ and owen__ to help him with his work load |
| 14:12 |
owen |
New dependency in HEAD? Locale::Currency::Format? |
| 14:12 |
|
gmcharlt is now known as owen___ |
| 14:12 |
owen___ |
here I am! |
| 14:12 |
|
owen___ is now known as gmcharlt |
| 14:13 |
owen |
gmcharlt you narrowly escaped the crack of my whip |
| 14:13 |
gmcharlt |
:) |
| 14:13 |
|
yep, a new dep |
| 14:13 |
owen |
Does Locale::Currency::Format have a Debian package? |
| 14:13 |
gmcharlt |
not atm |
| 14:13 |
jwagner |
Another new one? Is there a complete list somewhere of ALL the new ones? |
| 14:14 |
gmcharlt |
jwagner: they're being accumulated in bug 4151 and will be in release notes, etc. |
| 14:14 |
munin |
04Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=4151 blocker, P5, ---, gmcharltgmail.com, ASSIGNED, Document new perl modules for those upgrading |
| 14:15 |
jwagner |
Thanks, that will help. Is that Magick one in there? Didn't see it.... |
| 14:15 |
|
Never mind, it's there. Been a snake, it would have bit me. |
| 14:16 |
|
nengard joined #koha |
| 14:17 |
owen |
Good morning nengard |
| 14:18 |
nengard |
hiya owen |
| 14:18 |
|
biglego left #koha |
| 14:19 |
|
sekjal joined #koha |
| 14:28 |
|
Nate joined #koha |
| 14:29 |
|
Colin joined #koha |
| 14:29 |
|
greenmang0 left #koha |
| 14:32 |
sekjal |
I think my code and my database have gotten out of sync. Should Koha version 3.00.05.003 correspond to DB version 3.0100039? |
| 14:32 |
|
biglego joined #koha |
| 14:43 |
owen |
sekjal: I'm not sure if there's a correct way to check that, but I see that DB rev 3.00.00.039 was added to updatedateabase.pl on 2007-12-29 |
| 14:44 |
|
magnus is now known as magnus_away |
| 14:48 |
gmcharlt |
sekjal: are you trying to compare specific DBrevs between 3.0.x and 3.2.x ? |
| 14:48 |
sekjal |
googling "koha 3.01000039" I found one other library's error page that had it corresponding to code version 3.01.00.039 |
| 14:49 |
|
gmcharlt: I just upgraded my code from 3.0.3 to 3.0.5 |
| 14:50 |
|
now I'm getting all kinds of weird problems that remind me of the time I tried to maintain my own template (instead of using prog) between versions |
| 14:53 |
hdl_laptop |
have you updated your translations ? |
| 14:53 |
|
misc/translator |
| 14:54 |
|
./install-code.pl LANGUAGECODE |
| 14:57 |
sekjal |
hadn't done that, but just did, got no response... |
| 14:57 |
|
well, more accurately, the machine accepted my command and didn't give me any feedback |
| 14:58 |
|
rhcl_home left #koha |
| 15:02 |
ebegin |
How can I know where my perl modules are installed? It seems that I have a conflict (2 versions installed) for Compress::Raw::Zlib :( |
| 15:03 |
hilongo |
sekjal: after the upgrade, do your reserves/holds still work? |
| 15:17 |
sekjal |
hilongo: not really sure; haven't gotten reports from my people one way or the other |
| 15:19 |
hilongo |
sekjal: hmm.. I upgraded from 3.0.1 to 3.0.5 and reserves stopped working, reporting that none of the items were "available" for reserve .. I upgraded againt to 3.0.6 but to no use... |
| 15:20 |
* hilongo |
wonders if it is something wrong with the database update... |
| 15:20 |
|
Colin left #koha |
| 15:20 |
gmcharlt |
hdl_laptop: ^^ any ideas? |
| 15:24 |
hdl_laptop |
Should be working. |
| 15:25 |
wizzyrea_ |
bbs ,swtiching computers |
| 15:28 |
|
liz-nekls joined #koha |
| 15:29 |
|
liz-nekls is now known as wizzyra |
| 15:29 |
|
wizzyra is now known as wizzyrea |
| 15:30 |
chris_n |
wizzyrea: nick morphing indecision? ;) |
| 15:31 |
|
Colin joined #koha |
| 15:31 |
wizzyrea |
ha, more like butter fingers |
| 15:40 |
|
wizzyrea left #koha |
| 15:41 |
nahuel |
hilongo, did you defined hold policies ? |
| 15:41 |
kf |
bug Bug 4208 |
| 15:41 |
munin |
04Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=4208 critical, P1, ---, chrisbigballofwax.co.nz, NEW, Many submit buttons are not translatable in 3.2 |
| 15:41 |
nahuel |
hilongo, are your document issued ? |
| 15:42 |
jdavidb |
Hm....can anyone think of a better way to say this: |
| 15:42 |
|
SELECT issues.*,items.*,biblio.title FROM issues, items,biblio WHERE issues.itemnumber=items.itemnumber and issues.itemnumber=? and items.biblionumber=biblio.biblionumber |
| 15:43 |
|
Accounts.pm has an itty-bitty bug at 286, in that it's not getting the title, which is then referenced on line 309. That fix *works*, but is there a tidier way to say that? |
| 15:44 |
chris_n |
left join maybe? |
| 15:44 |
jdavidb |
possibly. Two left-handed JOINs is not something I've fiddled with much, but it should work. |
| 15:46 |
gmcharlt |
chris_n: I'd say a regular join, actually - no 'LEFT' need apply |
| 15:46 |
|
left joins are actually overused in C4 - properly speaking, they should be used only if you're not sure if there will be corresponding rows in the table that you're joining |
| 15:47 |
|
so in full |
| 15:48 |
jdavidb |
SELECT issues.*, items.*, biblio.title |
| 15:48 |
|
FROM issues |
| 15:48 |
|
JOIN items ON issues.itemnumber=items.itemnumber |
| 15:48 |
|
JOIN biblio ON items.biblionumber=biblio.biblionumber |
| 15:48 |
|
WHERE issues.itemnumber=? |
| 15:48 |
|
Like that, gmcharlt? |
| 15:49 |
|
Seems to work right, when I run it by hand! :) |
| 15:50 |
gmcharlt |
yes, that works; more compactly, can also do SELECT issues.*,items.*,biblio.title FROM issues, items,biblio JOIN issues USING (biblionumber, itemnumber); |
| 15:50 |
|
err, make that |
| 15:50 |
|
SELECT issues.*,items.*,biblio.title FROM issues JOIN items USING (itemnumber) JOIN biblio USING (biblionumber); |
| 15:51 |
jdavidb |
Sure 'nuf. that works nicely, too. I'll see if there's a bugzilla on this one, and submit a patch; I've checked, and HEAD-as-of-now still has this one. |
| 15:53 |
* jdavidb |
snorts |
| 15:54 |
jdavidb |
It has been a rough few months. I have already solved this one, and submitted the patch in November: Bug 3775 |
| 15:54 |
munin |
04Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=3775 normal, PATCH-Sent, ---, dbavousettptfs.com, ASSIGNED, Accounts::chargelostitem uses title, but title not available to it |
| 15:54 |
* jdavidb |
looks around for dead kitties. |
| 15:56 |
jdavidb |
Would you like me to resubmit that, with this more-elegant way of saying that SQL, gmcharlt? |
| 15:57 |
gmcharlt |
sure |
| 15:57 |
jdavidb |
Willdo! :) Have it to you shortly. :) |
| 16:00 |
nengard |
started documenting the OPAC - so no changing things around on me!! :) hehe |
| 16:02 |
* chris_n |
runs off to make misc small improvements on OPAC ;) |
| 16:07 |
hilongo |
nahuel: I tested with issued documents and on shelf documents... always the same ... hold policies are defined AFAIK ... I checked the tables with phpmyadmin and there are rules for my borrowertype with holdsallowed=2 and the same for itemtypes and branchcodes |
| 16:08 |
nahuel |
hilongo, a bit hard to debug by irc :) |
| 16:08 |
|
hilongo, are you a geek ? :) |
| 16:08 |
jdavidb |
i |
| 16:09 |
hilongo |
nahuel: haha .. not as geek as I would like :P |
| 16:09 |
nahuel |
hehe |
| 16:10 |
|
so you're not able to make some warn in the code ? |
| 16:10 |
hilongo |
nahuel: I have sent a mail to the list ... trying to explain my problem... with the error-log output and the contents of the various tables... had no response yet... so I think I'm the only one with this problem |
| 16:11 |
nahuel |
amha it's only a settings problem |
| 16:11 |
hilongo |
nahuel : I could ... just point me in the right direction :) |
| 16:11 |
nahuel |
in smart-rules.pl, how did you set hold policies in the bottom of the page |
| 16:12 |
|
afaik, "all item types" does not work |
| 16:12 |
|
you must make a rule by item type |
| 16:16 |
biglego |
Its a little off topic but it is related to my switching to koha. I'm writing a perl script that parses a log file. I'm trying to pull out some values with the following code. It prints the $stamp and the comma and newline character but it does not print the $itemlocation. I know its evaluating it but I'm clueless on how to get it to print the contents of the match. |
| 16:16 |
|
while (<IN>) { |
| 16:16 |
|
chomp; |
| 16:16 |
|
$stamp = substr $_, 0,19; # extract the time stamp field |
| 16:16 |
|
$itemlocation = $_ =~ m/^UT(.*?)^/; |
| 16:16 |
|
print "$stamp,$itemlocation\n"; |
| 16:16 |
|
} |
| 16:16 |
|
Ideas thoughts admonishments? |
| 16:18 |
hilongo |
nahuel: itemtype = IMP (this are printed books for us) hold policies = from any library |
| 16:19 |
sekjal |
anyone know where I can find which indexes are supposed to be on the koha.sessions table? |
| 16:19 |
* imp |
thinks: imps shall not be hold ;) |
| 16:19 |
kf |
hilongo: have you checked your maxreserves setting? (if its still there in your installation) |
| 16:21 |
hilongo |
kf: my maxreserves has a value of 10 |
| 16:22 |
jdavidb |
My new patch attached to Bug 3775, and send to the list, gmcharlt. Thanks! |
| 16:22 |
munin |
04Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=3775 normal, PATCH-Sent, ---, dbavousettptfs.com, ASSIGNED, Accounts::chargelostitem uses title, but title not available to it |
| 16:27 |
hilongo |
nahuel: take a look at this ... maybe you can figure out what's the problem http://pastebin.com/m675bb49b |
| 16:28 |
|
nengard left #koha |
| 16:28 |
gmcharlt |
jdavidb: Franken-kitty lives |
| 16:29 |
kf |
lol |
| 16:29 |
jdavidb |
I prefer killing bugs, not kitties. |
| 16:30 |
nahuel |
hilongo, ... like this I don't know... |
| 16:30 |
jdavidb |
gmcharlt++ ;I see it in HEAD already. w00t! |
| 16:34 |
hilongo |
nahuel: yep... I'm out of ideas too ... I'm one step from reinstalling from scratch |
| 16:36 |
wizzyrea_ |
zoinks, gmcharlt you've been busy! |
| 16:37 |
* jdavidb |
debates a Quote Add on wizzyrea saying "zoinks".. |
| 16:38 |
wizzyrea_ |
lol |
| 16:38 |
|
oh jdavidb you are back from the depths of the great snowstorm of 2010 |
| 16:39 |
jdavidb |
We have piles of snow as big as very large cars around here; some piles may, in fact, conceal cars. |
| 16:39 |
kf |
:) |
| 16:39 |
wizzyrea_ |
oh we need to update the sample news to point to the new documentation |
| 16:39 |
kf |
time to go home here - bye #koha :) |
| 16:39 |
wizzyrea_ |
bye cait |
| 16:39 |
|
:) |
| 16:40 |
kf |
pssst! ;) |
| 16:40 |
|
kf left #koha |
| 16:40 |
|
kf joined #koha |
| 16:41 |
|
kf left #koha |
| 16:41 |
wizzyrea_ |
that stuff is in installer/data right? |
| 16:41 |
gmcharlt |
@quote add jdavidb> I prefer killing bugs, not kitties. |
| 16:41 |
munin |
gmcharlt: The operation succeeded. Quote #57 added. |
| 16:41 |
gmcharlt |
@quote remove 57 |
| 16:41 |
munin |
gmcharlt: The operation succeeded. |
| 16:41 |
gmcharlt |
@quote add <jdavidb> I prefer killing bugs, not kitties. |
| 16:41 |
munin |
gmcharlt: The operation succeeded. Quote #58 added. |
| 16:41 |
jdavidb |
:) |
| 16:43 |
chris_n |
wizzyrea_: correct |
| 16:43 |
jdavidb |
@quote random |
| 16:43 |
munin |
jdavidb: Quote #32: "<wizzyrea> oh, things are not right in the world .... oh good, that makes me feel better. it's just the govt" (added by jdavidb at 09:56 AM, September 09, 2009) |
| 16:44 |
wizzyrea_ |
lol! |
| 16:44 |
|
I do not remember the context of that, but I'm sure it was funny |
| 16:45 |
jdavidb |
:) |
| 16:45 |
chris_n |
anyone using self-checkout? |
| 16:45 |
joetho_away |
@quote random |
| 16:45 |
munin |
joetho_away: Quote #43: "< Ropuch> Uh - beware of tea: it can burn your throat" (added by chris at 04:35 AM, October 30, 2009) |
| 16:45 |
chris_n |
lol |
| 16:45 |
|
@quote random |
| 16:45 |
munin |
chris_n: Quote #15: "<|Lupin|>ricardo: you are like the Portuguese Hitchcock!!" (added by wizzyrea at 10:58 AM, July 10, 2009) |
| 16:52 |
jdavidb |
@quote random |
| 16:52 |
munin |
jdavidb: Quote #27: "<jdavidb> ("A helicopter does not fly; it is a collection of quasi-unrelated parts moving in close formation, beating the sky into submission.")" (added by gmcharlt at 05:21 PM, August 22, 2009) |
| 16:56 |
wajasu |
i staged and imported about 16000 marc records with 925 items about 10 hours ago. Should I still be seeing manage-marc-import.pl running as a process? Its using 10% of the CPU time in top. I'm in a nozebra test installation. |
| 16:58 |
gmcharlt |
wajasu: 16,000 bibs with nonzebra? yeah, it could still be running; to check its proccess, you can go to the mysql prompt and do a count(*) on biblio; |
| 16:58 |
wajasu |
i'm on a fast i7 archlinux box. |
| 16:59 |
|
will check. |
| 17:02 |
jwagner |
chris_n, I'm catching up on things -- I've done a little bit with selfcheckout. What did you want to know/do? |
| 17:04 |
chris_n |
self-checkout seems to imply that one may scan the barcode to either checkout or return an item |
| 17:05 |
|
scanning an item already issued the requires keyboard/mouse intervention |
| 17:05 |
|
is this expected behavior or should an item issued and scanned be checked in automatically? |
| 17:09 |
wajasu |
my select count(*) from biblio; shows 24000 and its growing. select count(*) from items; shows 19000 and growing; What is going on? Shouldn't this all be done in less than a minute? |
| 17:11 |
gmcharlt |
wajasu: nozebra has some inefficiences when adding records one at a time, like happens in a staged bib import |
| 17:11 |
|
how many bibs do you have left to go? |
| 17:13 |
jwagner |
chris_n, I'm a little fuzzy on that area. I seem to remember that if you scan an item that you already have checked out, it will prompt you to renew or return. Not sure unless I set up a test. I may squeeze some time for that later if you want. |
| 17:14 |
chris_n |
jwagner: no need to test as that is how it works presently; it just seems a bit "hands-on" for returns |
| 17:14 |
|
ie. If I'm scanning an item already checked out to me, I am probably returning it |
| 17:14 |
jwagner |
I have never understood why the self-check allows returns anyway.... |
| 17:14 |
chris_n |
so why ask |
| 17:15 |
jwagner |
I would think it should only do renews. If you're returning, then put it in the bookdrop or in the "return" box or something. |
| 17:15 |
wizzyrea_ |
yea, returning seems like something a staff person would do |
| 17:15 |
wajasu |
i had staged, imported 2-3 times yesterday, and even shutdown the db because I had staged and then clicked import and had both batches running, so my numbers are off. |
| 17:15 |
chris_n |
wizzyrea_ jwager: so if a book is in the return box at the start of the workday the day after it is due, it is considered returned on time? |
| 17:16 |
wizzyrea_ |
our libraries use the drop box mode |
| 17:16 |
jwagner |
If you check it in using bookdrop mode -- that backs up the fines etc. to the day before. |
| 17:16 |
collum |
Yet. Most self-cko's have this option, I don't know why, but it is usually configurable. (checkin on/off) |
| 17:16 |
wizzyrea_ |
for that. They assume if it's in the drop box before start of business on the day after due, it's on time |
| 17:16 |
|
collum: I agree it's weird |
| 17:16 |
|
brb |
| 17:17 |
chris_n |
tnx, that helped |
| 17:18 |
gmcharlt |
chris_n: although I can imagine a use case - self-service points at corporate libraries |
| 17:18 |
wajasu |
is there a way to log and trace what statements are taking so long? |
| 17:18 |
wizzyrea_ |
...it ought to be a syspref!! |
| 17:19 |
* wizzyrea_ |
ducks |
| 17:19 |
|
wizzyrea_ is now known as wizzyrea |
| 17:19 |
* chris_n |
runs off screaming.... "Not another syspref!!!!" |
| 17:21 |
jwagner |
But I _LIKE_ sysprefs! They give the individual library so much more control over things, without having to locally customize code. |
| 17:22 |
wajasu |
i'm going to install a newer koha in a fresh chroot. mine is from last september. |
| 17:22 |
* chris_n |
groans... |
| 17:23 |
chris_n |
another LLEK question |
| 17:24 |
owen |
"limits to what we can change through LLEK" I thought the point was there weren't limits :P |
| 17:24 |
wizzyrea |
man, those people are up shit creek without a paddle |
| 17:24 |
|
seriously |
| 17:24 |
|
LL won't help them with community stuff, and the community won't help them with community stuff |
| 17:24 |
Ropuch |
heh |
| 17:24 |
wizzyrea |
(no lie, LL tells them it's community, go ask them)( |
| 17:24 |
wajasu |
i got items. i got biblios. what are authority records? what are they for? where/how should i get them? what value do they add? |
| 17:25 |
* collum |
went to get more coffee. |
| 17:25 |
collum |
I can see checkin on self-cko used in a school situation as well. |
| 17:25 |
wizzyrea |
just sayin, a little bit of... "well here's how we would fix it if you were on community" might go a long way |
| 17:26 |
|
because you don't want to alienate those people, they're in a bad place. |
| 17:26 |
|
and the welcoming arms of the community is a good place to be |
| 17:26 |
owen |
wizzyrea I think we're pretty good about doing that aren't we? |
| 17:26 |
Ropuch |
wajasu: http://www.loc.gov/marc/uma/ |
| 17:26 |
wizzyrea |
usually |
| 17:26 |
wajasu |
thanks. |
| 17:28 |
Ropuch |
I don't know details of their contracts, but if I were them, I would sue LL ;> |
| 17:28 |
|
Of course blaming community is easier |
| 17:28 |
wizzyrea |
of course it is. |
| 17:28 |
Ropuch |
Bad Koha! |
| 17:28 |
|
;> |
| 17:28 |
owen |
The trouble with the mailing list is that it's hit-or-miss for anyone, not just LL customers. |
| 17:28 |
wizzyrea |
true |
| 17:29 |
|
brendan left #koha |
| 17:29 |
wizzyrea |
i don't mean to get shouty |
| 17:31 |
* chris_n |
tries to answer kindly yet truthfully :) |
| 17:32 |
chris_n |
of course, I could give a bit of personal testimony, but resisted the urge |
| 17:33 |
wizzyrea |
chris_n: the people on LEK don't have the label creator yet, that I know of, and that's why it's all broken and stupid. |
| 17:34 |
|
Colin left #koha |
| 17:36 |
sekjal |
my database version and code version are out of sync (db ahead of code) |
| 17:37 |
wizzyrea |
!! |
| 17:37 |
sekjal |
should I try rolling back the database changes between where I am now and where I want to be (v3.00.05), or try to move forward to 3.2 alpha? |
| 17:38 |
chris_n |
sekjal: what db version? |
| 17:38 |
sekjal |
3.01.00.039 |
| 17:39 |
chris_n |
I'd move forward |
| 17:39 |
sekjal |
I think there would be fewer jagged edges riding 3.2 alpha than staying where we are |
| 17:39 |
chris_n |
that's probably true |
| 17:40 |
sekjal |
I'd just need to train up my colleagues on how to do frequent git pulls and upgrades to production |
| 17:40 |
|
since I won't be around to help them after this week ends |
| 17:41 |
|
brendan joined #koha |
| 17:41 |
|
wajasu left #koha |
| 17:41 |
jwagner |
sekjal, are you going somewhere??? |
| 17:42 |
chris_n |
sekjal: that's not hard |
| 17:42 |
sekjal |
my wife got a new job in Massachusetts, so we've moved too far away from NYC for me to continue as faculty at NYUHSL |
| 17:43 |
|
Kivutar left #koha |
| 17:43 |
chris_n |
and it could stop once 3.2 reached stable if they did not want to run bleeding edge code |
| 17:43 |
jwagner |
sekjal, I hope you're staying around Koha, at any rate! |
| 17:43 |
sekjal |
we desperately need the enhanced acquisitions, so I'm tempted. |
| 17:43 |
|
jwagner: yes, I'm staying in the community. I hope to be more involved, in fact |
| 17:44 |
|
s/hope/plan/ |
| 17:44 |
brendan |
sekjal++ |
| 17:44 |
sekjal |
s/plan/will/ |
| 17:44 |
jdavidb |
sekjal++ |
| 17:46 |
sekjal |
I've got most of the steps already on our wiki on how to do an upgrade. I should just make sure it's polished and detailed, and carried out regularly until 3.2 is stable |
| 17:47 |
jwagner |
Glad to hear it! |
| 17:49 |
chris_n |
sekjal: at some slight risk to stability, the git pull part could be automated with cron |
| 17:50 |
|
risk = if some bad bug suddenly appeared in HEAD |
| 17:50 |
brendan |
chris_n are you doing any such thing right now? |
| 17:50 |
chris_n |
contemplating it every day I have to pull for multiple dev branches and my production box |
| 17:50 |
brendan |
I guess I always watch my merge issues.. so I don't think I could do such a thing |
| 17:51 |
|
but maybe for the demo's - where it's just straight HEAD... that could be useful |
| 17:51 |
|
francharb left #koha |
| 17:51 |
* brendan |
ponders |
| 17:51 |
chris_n |
but if one were simply running on a strictly production clone, it should not be a problem |
| 17:51 |
|
except as noted |
| 17:52 |
|
the only other issue is db updates |
| 17:52 |
sekjal |
we have our test install (dev) pulling from git, and then our production install (prod) gets upgraded when we feel ready |
| 17:52 |
chris_n |
which require the web installer |
| 17:52 |
sekjal |
right |
| 17:52 |
chris_n |
but in reality that could be automated too with a separate script to call updatedatabase.pl |
| 17:53 |
sekjal |
I should have been more concerned when my upgrade from 3.0.3 to 3.0.5 didn't bring up the web installer. |
| 17:54 |
chris_n |
sekjal: was that on your dev install? |
| 17:54 |
sekjal |
prod |
| 17:54 |
chris_n |
do you pull your prod from your dev? |
| 17:55 |
sekjal |
yes, the dev install is from git, then we make to production |
| 17:55 |
chris_n |
so the mess up probably happened on the dev install |
| 17:55 |
chris |
i wonder if i should follow up chris_n and say, "what everyone is trying to say diplomatically is that because you are running a fork of Koha, not actual Koha, we have no idea what your code looks like, and that any change we make is at the mercy of your vendor who is openly hostile to the Koha community" |
| 17:56 |
wizzyrea |
not sure there's a nice way to say it. |
| 17:56 |
|
the truth hurts. |
| 17:56 |
chris_n |
sometimes the truth is raw |
| 17:56 |
|
<snap> |
| 17:56 |
wizzyrea |
JINX |
| 17:57 |
sekjal |
chris_n: the mistake is mine; I'm just not sure where I made it. perhaps when I thought I upgraded to 3.0.3, I was actually upgrading to 3.01.00.039 |
| 17:57 |
wizzyrea |
ok afk |
| 17:57 |
chris_n |
sekjal: I made the mistake of rebasing on the wrong branch once and had a similar db issue |
| 17:58 |
sekjal |
well, at least I'm running into all these problems while I still have time to throw at fixing them. |
| 17:59 |
|
if I can get them stabilized before I depart, and have documentation up on how to maintain, I think it'll all work out okay |
| 18:02 |
* chris_n |
has a nasty db issue atm |
| 18:03 |
|
schuster joined #koha |
| 18:03 |
chris_n |
some how my prod db tables are MyISAM rather tha InnoDB |
| 18:06 |
|
biglego left #koha |
| 18:06 |
|
laurence left #koha |
| 18:09 |
|
tomascohen left #koha |
| 18:09 |
chris |
done |
| 18:14 |
|
nicomo left #koha |
| 18:20 |
|
magnus_away left #koha |
| 18:28 |
jwagner |
owen, online? |
| 18:33 |
|
davi left #koha |
| 18:38 |
brendan |
@wunder 93117 |
| 18:38 |
munin |
brendan: The current temperature in Northwest Goleta, Goleta, California is 18.4�C (10:34 AM PST on February 17, 2010). Conditions: Clear. Humidity: 57%. Dew Point: 10.0�C. Pressure: 29.97 in 1014.8 hPa (Rising). |
| 18:43 |
jwagner |
@wunder bethesda, md |
| 18:43 |
munin |
jwagner: The current temperature in Langley Fork Park, McLean, Virginia is 1.3�C (1:40 PM EST on February 17, 2010). Conditions: Overcast. Humidity: 62%. Dew Point: -5.0�C. Windchill: 1.0�C. Pressure: 29.68 in 1005.0 hPa (Falling). |
| 19:04 |
|
liz-nekls joined #koha |
| 19:06 |
owen |
jwagner: Back, what's up? |
| 19:08 |
jwagner |
I had a jquery question for you, but I solved it myself. (Much gloating ensued -- it was something I didn't even know was possible) |
| 19:08 |
owen |
:D |
| 19:09 |
jwagner |
Got one other one for you, though. In patron add/edit screen, I did a jquery that turned off the data entry box for Street Number, but so far I haven't been able to turn off the label itself. Any ideas? |
| 19:10 |
owen |
$("#streetnumber").parent().remove(); |
| 19:10 |
|
takes care of them both |
| 19:11 |
|
Even more specifically: $("#entryform #streetnumber").parent().remove(); |
| 19:11 |
jwagner |
So it does. Genius! |
| 19:11 |
owen |
That limits the action to the patron entry form (in case that ID is used elsewhere in the staff client) |
| 19:12 |
jwagner |
owen++ |
| 19:12 |
chris_n |
@wunder 28334 |
| 19:12 |
munin |
chris_n: The current temperature in Erwin, North Carolina is 6.0�C (2:01 PM EST on February 17, 2010). Conditions: Scattered Clouds. Humidity: 23%. Dew Point: -14.0�C. Windchill: 3.0�C. Pressure: 29.78 in 1008 hPa (Steady). |
| 19:12 |
jwagner |
Thanks, owen. I'm trying to back out a lot of local screen changes & do them as jquery statements. The fewer actual code changes, the better! |
| 19:13 |
owen |
I'm no fan of setting up MARC frameworks, but it'd be neat if there were some kind of "patron framework" |
| 19:13 |
jwagner |
Yep. I'd love to be able to relabel/hide/whatever the various patron fields. |
| 19:14 |
jdavidb |
*perks up at owen's idea |
| 19:14 |
sekjal |
owen, jwagner: YES! I think that would make things much smoother in the long run |
| 19:14 |
gmcharlt |
heh - patron_frameworks++, but let's not do what Mandarin does and literally store the patron records as MARC records :) |
| 19:14 |
sekjal |
gmcharlt: egad! |
| 19:14 |
jwagner |
Somebody (hdl maybe?) had a patch that let you specify patron fields to omit from the edit screen, but I don't think it ever went anywhere. |
| 19:15 |
|
braedon|work left #koha |
| 19:15 |
|
braedon|work joined #koha |
| 19:15 |
jwagner |
This particular site had also relabeled some of the patron fields, but I got those done with a jquery OK. |
| 19:16 |
jdavidb |
I was piddling with the conceptual model of a data silo, with everything being kept in XML, then allowing the user to manipulate the DTD somehow. |
| 19:18 |
sekjal |
jdavidb: I've been thinking about that kinda thing, too |
| 19:19 |
jdavidb |
Let's mind-meld some time, sekjal; I see long-term possibilities for such a structure. |
| 19:20 |
sekjal |
jdavidb: absolutely. |
| 19:20 |
liz-nekls |
I nth the patron field hiding |
| 19:20 |
|
prefs |
| 19:20 |
|
liz-nekls is now known as wizzyrea_laptop |
| 19:20 |
wizzyrea_laptop |
we do it with jquery |
| 19:20 |
jdavidb |
Easy cases are things like biblios, items, borrowers, but I even extended my model to things like borrowing rules, serials predictions, and user privilege sets. |
| 19:20 |
* owen |
's staff complained after our recent upgrade about the addition of "country" to the patron entry form |
| 19:21 |
wizzyrea_laptop |
since everybody in our libraries uses javascript it works ok |
| 19:21 |
|
but patron frameworks would be win |
| 19:23 |
sekjal |
jdavidb: right, the Major Entities in the system are pretty easy to model with XML; the transactions between them could be, as well, but would need to be tested for efficiency vs. a relational model |
| 19:23 |
|
somethings fit better in a table, others in a tree |
| 19:23 |
|
but with the right forethought and indexing, I think it could work |
| 19:24 |
wizzyrea_laptop |
you know, I wonder if it would be better to hide the Alternate Data fields if they are empty |
| 19:24 |
|
in the patron details |
| 19:24 |
|
or click to expand |
| 19:25 |
jdavidb |
sekjal: Sure. I come at it from a mixed-type consortium background, and so a really flexible tree-based system of privilege and borrowing-rules management would be super-nice. For the XML, my thinking is some sort of native-XML db tool, like eXist, maybe. |
| 19:26 |
jwagner |
I had to do some MAJOR hacking on the patron add/edit page for one site -- government library which is forbidden to collect personal info such as home address. I ended up chopping out most of the data fields altogether. It would have been much easier to check off a bunch of boxes that say "don't display this field" |
| 19:26 |
sekjal |
jdavidb: we're on the same wavelength, I think. I was thinking Berkeley DB XML, but that's just because it was the one I used in grad school |
| 19:27 |
wizzyrea_laptop |
jwagner: agreed |
| 19:28 |
|
being able to change the text of the labels would be nice, but not a requirement, as well |
| 19:33 |
|
richard joined #koha |
| 19:33 |
richard |
hi |
| 19:33 |
* owen |
is confident that will be no trouble for jdavidb |
| 19:34 |
jdavidb |
heh. owen, my biggest problems revolve around the fact that I can only function for 20 hours a day, on the good days, and must necessarily sleep at least part of the other four, and that I am not psychic. |
| 19:35 |
jwagner |
That's what he says. Don't let him fool you.... |
| 19:35 |
* owen |
would kill for 20 good hours in his day, must settle for 16 or so |
| 19:36 |
* jwagner |
can usually only manage 8-10 |
| 19:36 |
jdavidb |
Most days, I have to settle for 12-14. Gettin' old. |
| 19:36 |
|
braedon|home1 joined #koha |
| 19:37 |
|
cait joined #koha |
| 19:40 |
|
mib_hr8i89 joined #koha |
| 19:44 |
|
braedon|home left #koha |
| 19:47 |
jwagner |
nengard doesn't seem to be online -- anyone else done any testing with latest head and acquisitions? Specifically suggestions? |
| 19:49 |
chris |
back, at work now |
| 19:49 |
owen |
I've done some testing of suggestions jwagner |
| 19:49 |
cait |
hi chris |
| 19:49 |
jwagner |
See Bug 4210 |
| 19:49 |
munin |
04Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=4210 minor, P5, ---, jwagnerptfs.com, ASSIGNED, Acquisitions suggestion templates have library name field, but data is not passed |
| 19:50 |
jwagner |
The bug itself is an old one -- we fixed it on one of our sites but apparently never submitted. In the process of doing the fix against current head, I found that the system didn't seem to want to email the suggestion responses (accept, reject, whatever). Have you gotten those? |
| 19:51 |
|
On an earlier code version, whenever I updated a pending suggestion, the email went right out. On current head, nada. |
| 19:51 |
cait |
jwagner: oh, never got a mail when working with suggestions |
| 19:52 |
jwagner |
Maybe I'm missing a syspref or something, but it should have worked. |
| 19:53 |
* owen |
accepts some suggestions, waits for an email |
| 19:54 |
jwagner |
suggestions don't seem to go through message queue, so I can't even see if they're hanging around in limbo. Just ...silence |
| 19:55 |
owen |
Yeah, I'm not getting anything. Other email functions have worked for me, like sending lists or carts |
| 19:55 |
jwagner |
And I verified manually (with jdavidb's help) that email is going out from this box. |
| 19:55 |
|
Sounds like a new bug? |
| 19:55 |
owen |
No errors in the Koha log |
| 19:56 |
jwagner |
And you got emails under earlier code on this box? |
| 19:59 |
owen |
I don't remember if it was this installation or a different one |
| 20:01 |
sekjal |
I'm playing with my test system (which is current with git.koha.org) and I'm having problems with the new Label Creator tool |
| 20:01 |
braedon|work |
gmcharlt: which version of Locale::Currency::Format? |
| 20:01 |
jwagner |
owen, I'll go ahead & open a bug report. Thanks for checking. |
| 20:02 |
wizzyrea_laptop |
sekjal: what problem? |
| 20:02 |
sekjal |
every time I try to work with the labels, either as Layout, Templates, Profiles or Batches, I get an error on label_manage.pl |
| 20:02 |
|
Can't use string ("-1") as an ARRAY ref while "strict refs" in use at /home/koha/koha_from_git/C4/Creators/Lib.pm line 537. |
| 20:02 |
gmcharlt |
braedon|work: 1.28 |
| 20:03 |
sekjal |
looking at Lib.pm, that's part of the html_table subroutine |
| 20:04 |
ebegin |
I'm facing a strange problem with my perl modules. It seems that the location where CPAN places packages is not the place where perl reads them... any idea? |
| 20:04 |
schuster |
I know this is a bit off topic, but anyone else having trouble with worldcat? |
| 20:05 |
braedon|work |
gmcharlt: ok. doesn't looks like it is in the ubuntu repos |
| 20:05 |
gmcharlt |
braedon|work: nor Debian AFAICT |
| 20:05 |
braedon|work |
gmcharlt: I will add it to my ppa |
| 20:05 |
jwagner |
owen, Bug 4211 |
| 20:05 |
munin |
04Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=4211 major, P2, ---, henridamienkoha-fr.org, NEW, Acquisitions actions on suggestions don't generate email |
| 20:06 |
chris_n |
sekjal: did you load any sample data? |
| 20:06 |
sekjal |
chris_n: not specifically. I had whatever profiles were in my system from before. |
| 20:06 |
|
do I need to populate the database with something to start? |
| 20:07 |
chris_n |
did upgradedatabase.pl run without incident? |
| 20:07 |
jwagner |
By the way... |
| 20:07 |
sekjal |
chris_n: yes |
| 20:07 |
jwagner |
jdavidb++ # for getting me an updated sandbox with current head! |
| 20:08 |
schuster |
jdavidb++ take care of her... come on... about time sheesh... ;) |
| 20:09 |
chris |
jdavidb++ |
| 20:09 |
jwagner |
schuster, not his fault (although don't tell him I said so!) We had to freeze our development boxes for a while, just getting them thawed out, so to speak. |
| 20:09 |
* jwagner |
asks jdavidb if he's happy with all the karma, since he was complaining yesterday :-) |
| 20:10 |
schuster |
Great start pushing those new enhancements our way!! |
| 20:10 |
jdavidb |
Very! |
| 20:10 |
chris_n |
jdavidb++ |
| 20:11 |
jwagner |
schuster, yes, getting an updated codeset is the first step on pushing out the new code :-) |
| 20:14 |
wizzyrea_laptop |
can't wait for the ptfs stuff |
| 20:15 |
* wizzyrea_laptop |
is stupid excited. |
| 20:16 |
jwagner |
Don't hold your breath -- it's going to take a while to get everything rebased & ready now. And there are several features that other folks have done parallel devel on, which beat us into head. We have some sorting out to do. |
| 20:16 |
|
But we are working on it.... |
| 20:18 |
schuster |
Tell jdavidb to hurry up... ;) |
| 20:18 |
* gmcharlt |
offers to officiate at the thumb-wrestling contest to sort out the parallel developments |
| 20:18 |
schuster |
The users are waiting... |
| 20:19 |
jwagner |
gmcharlt, we may call on you :-) On at least one of the parallel items, we have a little extra functionality than what's in head now, so we might just snip out that extra bit & submit. But I need to do a side-by-side look at everything to see where the problems are. |
| 20:19 |
chris |
i think jdavidb and jwagner could be cut some slack, i meant they have at least sent patches since march 2009 .... |
| 20:19 |
jwagner |
A few.... |
| 20:20 |
schuster |
Just have to prod them some all in jest... jdavidb knows that of me at least... ;) |
| 20:21 |
jwagner |
So do I :-) |
| 20:21 |
jdavidb |
:) |
| 20:21 |
owen |
Speaking of March 2009, when was the last time someone from LibLime answered questions on the mailing list? cfouts++ |
| 20:22 |
gmcharlt |
jest? JEST? /me was perfectly serious about the thumb-wrestling contest |
| 20:23 |
|
;) |
| 20:24 |
jwagner |
So long as it's not MY thumbs in question! |
| 20:25 |
|
I do still have a dozen or so features that aren't in bugzilla yet -- hope to get those entries created maybe tomorrow. |
| 20:25 |
|
But when we DO start sending out code, it's gonna hit hard. gmcharlt, be warned :-) |
| 20:27 |
owen |
gmcharlt is hoping chris will be the target by then! |
| 20:27 |
gmcharlt |
unwisely, I'm still going to be exposing myself as the the target for the cataloging and search parts of it :) |
| 20:29 |
chris |
:-) |
| 20:29 |
|
thats great to hear |
| 20:29 |
|
cos i hate those parts :-) |
| 20:30 |
|
nengard joined #koha |
| 20:30 |
nengard |
so i left the house at 11:30am for 1 dr appt that lasted 20 minutes - but I just got home now - at 3:30pm cause the Dr didn't see me on time and Philadelphia sucks!! |
| 20:31 |
chris |
hehe |
| 20:31 |
|
has good cheese steaks tho |
| 20:31 |
nengard |
chris - actually I had a chicken cheese steatk for lunch since I was there |
| 20:32 |
|
but still not worth the hassle |
| 20:33 |
|
unfortunatly my dr is THE doctor if you have this condition and I'm lucky enough to live only an hour away - but still!! |
| 20:34 |
jwagner |
nengard, see Bug 4211 -- have you run into that one? |
| 20:34 |
munin |
04Bug http://bugs.koha.org/cgi-bin/b[…]w_bug.cgi?id=4211 major, P2, ---, henridamienkoha-fr.org, NEW, Acquisitions actions on suggestions don't generate email |
| 20:34 |
nengard |
jwagner - i don't have email running on my test machine - so i can't test that one |
| 20:35 |
jwagner |
@later tell hdl_laptop see Bug 4211 -- can you test/verify? |
| 20:35 |
munin |
jwagner: The operation succeeded. |
| 20:35 |
hdl_laptop |
jwagner: will test |
| 20:36 |
jwagner |
Oh, I thought you were asleep by now :-) |
| 20:36 |
hdl_laptop |
I should ;) |
| 20:36 |
* chris_n |
hands hdl_laptop a pillow and blanket |
| 20:38 |
|
jdavidb left #koha |
| 20:43 |
|
Lee joined #koha |
| 20:44 |
Lee |
Chris are you around? |
| 20:44 |
chris |
heya lee, sup? |
| 20:44 |
wizzyrea_laptop |
hey lee |
| 20:45 |
Lee |
hey Liz |
| 20:45 |
|
I thought I would share my farewell to LL with you |
| 20:46 |
|
Sara was contacting our county saying their check was "LOST" and how could they get another issued |
| 20:46 |
owen |
Hi Lee |
| 20:46 |
chris |
orly? |
| 20:46 |
Lee |
Josh knew I was waiting to talk to PTFS |
| 20:46 |
wizzyrea_laptop |
lee! |
| 20:46 |
Lee |
hey owen |
| 20:47 |
gmcharlt |
hi Lee - and ouch! |
| 20:47 |
Lee |
I sent Sara an email saying that we were done screwing with them now that the merger failed |
| 20:47 |
wizzyrea_laptop |
you are hard core my friend |
| 20:47 |
Lee |
I sent "the letter" yesterday to Josh with our check and said "cash it and we are done" |
| 20:47 |
joetho_away |
you go girl |
| 20:47 |
brendan |
hi lee |
| 20:48 |
joetho_away |
did you get an attorney to look at your contract? |
| 20:48 |
Lee |
hey brendan and galen |
| 20:49 |
|
I haven't gotten a reply so I would guess that they will cash the check for 7K and we will just move on |
| 20:49 |
|
no |
| 20:49 |
|
he can get his attorney to look at it |
| 20:49 |
|
I think he'll take the money and be done with us |
| 20:50 |
brendan |
Lee++ |
| 20:50 |
chris_n |
Lee++ |
| 20:50 |
wizzyrea_laptop |
sucks that you lose the money |
| 20:50 |
Lee |
our contract said they would support our appliance install |
| 20:50 |
|
we have server logs |
| 20:51 |
|
they haven't bothered with us in 9 months |
| 20:51 |
|
no patches no updates no nothing |
| 20:51 |
chris |
yeah, thats fairly cut and dry for any lawyer worth his salt |
| 20:51 |
Lee |
I think so too |
| 20:52 |
ebegin |
chris++ it work! |
| 20:52 |
Lee |
So i guess we are free of LL (I hope) and it feels great |
| 20:52 |
chris |
ebegin: yay!! |
| 20:52 |
ebegin |
s/work/works |
| 20:53 |
Lee |
Just thought you all would appreciate the news |
| 20:53 |
chris |
thanks for sharing Lee :) |
| 20:53 |
Lee |
even tho we are a wee library |
| 20:54 |
|
On another topic- as soon as I confirm my flights...I would be happy to volunteer to help w/Kohacon |
| 20:54 |
chris |
montana++ |
| 20:54 |
|
sweet |
| 20:54 |
|
have you seen this page? |
| 20:54 |
Lee |
:) |
| 20:55 |
gmcharlt |
Lee++ |
| 20:55 |
sekjal |
Lee: very inspiring news |
| 20:55 |
chris |
http://kohacon.appspot.com/2010/travel/US.html |
| 20:56 |
|
any things you find out when booking your travel, would be great to add to that |
| 20:56 |
jwagner |
owen, still online? |
| 20:56 |
Lee |
okay will do...i have been looking at Orbitz they have some great deals |
| 20:56 |
joetho_away |
i practice speaking in Newzealandish with chris |
| 20:56 |
|
he is very patient |
| 20:56 |
owen |
jwagner: Yes |
| 20:57 |
jwagner |
opac.css controls the opac -- what's the stylesheet that controls the staff client? Or is it the same one? |
| 20:57 |
owen |
staff-global.css |
| 20:57 |
Lee |
just wanna say thanks again to the community for all the morale support |
| 20:58 |
jwagner |
thanks, owen. I thought I'd copied all the css files, but I bet this lives under intranet-tmpl tree, right? |
| 20:58 |
owen |
Yes |
| 20:58 |
Lee |
I'll let you all get back to work- Cheers and see you in NZ |
| 20:58 |
jwagner |
Thanks, & good night! |
| 20:59 |
|
jwagner left #koha |
| 21:00 |
|
Lee left #koha |
| 21:09 |
|
mib_hr8i89 left #koha |
| 21:10 |
cait |
can someone help me with git? Im working on translation of installer sql files and treid my first rebase to get the new notice templates. |
| 21:10 |
ebegin |
can Graphics::Magick be install using cpan? |
| 21:10 |
|
owen left #koha |
| 21:11 |
sekjal |
ebegin: I found not |
| 21:11 |
|
(just did it 5 minutes ago) |
| 21:11 |
ebegin |
:) |
| 21:11 |
sekjal |
ebegin: I used the debian package; not sure if that applies for your install or not |
| 21:12 |
ebegin |
sekjal, you installed it manually? |
| 21:12 |
sekjal |
apt-get install libgraphics-magick-perl |
| 21:14 |
ebegin |
I always wonder which way is the best. Using apt-get or downloading the source and ./configure + make + make install... |
| 21:14 |
chris |
apt-get |
| 21:14 |
|
because then you get the benefit of the debian security team |
| 21:15 |
sekjal |
I like apt-get because it's easier. I'm lazy |
| 21:15 |
ebegin |
hehe :) |
| 21:15 |
|
good point chris |
| 21:15 |
chris |
unless there is a compelling reason to do otherwise, using the debian package is easier and safer |
| 21:15 |
|
manual installs end up with unpatched modules that you forget about |
| 21:20 |
|
collum left #koha |
| 21:23 |
ebegin |
any suggestion of good mirror to use with debian lenny? |
| 21:24 |
|
(for apt-get) |
| 21:24 |
chris |
dunno for canada, the debian site should ahve a list of them |
| 21:24 |
|
or you could use apt-spy |
| 21:25 |
|
http://packages.debian.org/lenny/apt-spy |
| 21:26 |
ebegin |
I wasn't aware of apt-spy... thanks for that |
| 22:02 |
sekjal |
I'm looking to compare my test install's database structure against the latest kohastructure.sql. What mysqldump options should I use to get as similar an sql output as possible? |
| 22:03 |
cait |
good night #koha |
| 22:03 |
|
cait left #koha |
| 22:09 |
|
schuster left #koha |
| 22:29 |
chris |
sekjal: good question |
| 22:29 |
|
i dont have a good answer im afraid |
| 22:32 |
|
nengard left #koha |
| 22:34 |
sekjal |
did a dump with --no-data and --add-drop-tables, and it got pretty close. The order of the tables is different, though, since kohastructure.sql isn't completely alphabetical |
| 22:35 |
chris |
yeah, we should make it be |
| 22:35 |
|
maybe that can be a 3.4 thing |
| 22:37 |
sekjal |
would reordering the table definitions be trivial, or have implications? |
| 22:37 |
|
I would think it wouldn't matter, but I'm used to being wrong |
| 22:37 |
chris |
well, it makes diffs harder to read |
| 22:37 |
|
(as does any whitespace changes) |
| 22:38 |
|
if i wanted to see what changed between some version and some other one, moving stuff around makes that much harder to see |
| 22:39 |
sekjal |
right, so we'd be making it easier to compare to alphabetized mysqldumps, but that much harder to compare to previous versions of the file |
| 22:39 |
|
perhaps a quick script to alphabetize on demand, creating a kohastructureA-Z.sql |
| 22:42 |
gmcharlt |
sekjal: there's been some effort to keep the column names in the same order - note the add column ... after in various updatedatabase.pl DBrevs |
| 22:45 |
sekjal |
gmcharlt: and it seems to be working pretty well. Once I got the tables reordered from my dump to match the order in kohastructure.sql, a text diff was pretty easy to read |
| 22:46 |
|
as far as I can tell, there are no major differences in my DB structure from what it's supposed to be |
| 22:46 |
|
collum_ joined #koha |
| 22:47 |
gmcharlt |
sekjal: if you can write up your DB dump compare script into something to plop into xt/author, I'll be eternally grateful |
| 22:48 |
sekjal |
gmcharlt: I'll see what I can do. this week is a little hectic, with my departure from NYUHSL and Code4Lib prep, but I'll make sure it's on my list for after that |
| 22:48 |
wizzyrea_laptop |
is there circ data in the default data? |
| 22:48 |
|
and if I wanted to dump all circ data, which table would I empty |
| 22:48 |
|
and how :P |
| 22:49 |
gmcharlt |
wizzyrea_laptop: no |
| 22:49 |
wizzyrea_laptop |
because I'm not feeling plucky enough to figure it out at the moment |
| 22:49 |
gmcharlt |
issues, old_issues, reserves, old_reserves |
| 22:49 |
wizzyrea_laptop |
(don't worry, this is test data, nothing important) |
| 22:49 |
gmcharlt |
and accountlines |
| 22:49 |
|
will get you most of it |
| 22:50 |
|
and mysqldump would be the means |
| 22:50 |
|
or guided reports |
| 22:51 |
wizzyrea_laptop |
I want to clear it |
| 22:55 |
sekjal |
alright, time to head home for the night. get to see my wife for a little while, if only via webcam |
| 22:55 |
|
chobbs joined #koha |
| 22:56 |
chris |
ws 11 |
| 22:56 |
|
gah |
| 22:56 |
|
sekjal left #koha |
| 22:59 |
|
wizzyrea_laptop left #koha |
| 23:13 |
chris_n |
@later tell sekjal: I did a compare to day and can probably give you a good idea of what needs to be changed |
| 23:13 |
munin |
chris_n: The operation succeeded. |
| 23:13 |
moodaepo |
@wunder 56001 |
| 23:13 |
munin |
moodaepo: The current temperature in Mankato, Minnesota is -6.0�C (4:55 PM CST on February 17, 2010). Conditions: Clear. Humidity: 63%. Dew Point: -12.0�C. Windchill: -11.0�C. Pressure: 30.09 in 1019 hPa (Steady). |
| 23:13 |
collum_ |
Oh |
| 23:14 |
|
opac_search.pl doesn't have a license statement. |
| 23:14 |
gmcharlt |
@wunder 30071 |
| 23:14 |
munin |
gmcharlt: The current temperature in Historic District, Norcross, Georgia is 4.1�C (6:11 PM EST on February 17, 2010). Conditions: Clear. Humidity: 46%. Dew Point: -6.0�C. Windchill: 2.0�C. Pressure: 29.97 in 1014.8 hPa (Rising). |
| 23:14 |
collum_ |
just a note that says 'mostly copied from search.pl' |
| 23:14 |
|
Is that kosher? |
| 23:14 |
chris |
nope |
| 23:14 |
|
it needs a license statement |
| 23:14 |
|
if you could add that, that would be great |
| 23:14 |
collum_ |
will do |
| 23:15 |
chris |
make it copyright something sensible |
| 23:15 |
gmcharlt |
yep - in that case, safe to assume the standard |
| 23:15 |
chris |
like yourself :) |
| 23:15 |
collum_ |
OK |
| 23:16 |
gmcharlt |
just please don't blindly copy "Copyright 2000-2002 Katipo Communications" :) |
| 23:17 |
collum_ |
I'll try to refrain. |
| 23:17 |
gmcharlt |
and since opac-search.pl is truly a case of joint copyright, better make that 'Garry Collum and the Koha Dev Team', as a few other fies do |
| 23:24 |
braedon|work |
I have created a PPA with perl modules not available from the standard Ubuntu repositories |
| 23:25 |
gmcharlt |
cool |
| 23:25 |
|
bbiab |
| 23:25 |
braedon|work |
i don't really know what i am doing in that regard, but i just tested it, and they seem to be working, so if someone else wants to test it, it would be great |
| 23:25 |
|
the ppa is braedon-vickers/kohaperl |
| 23:26 |
|
gmcharlt left #koha |
| 23:26 |
braedon|work |
if people want it, perhaps we could create a koha project/team on launchpad, and copy them to a more official PPA there? |
| 23:35 |
|
In web installer: |
| 23:35 |
|
sample_notices.sql |
| 23:35 |
|
ERROR 1054 (42S22) at line 1: Unknown column 'biblio.title' in 'field list' |
| 23:36 |
|
can't find a bug - who is handling database changes/standard data import? |
| 23:41 |
brendan |
@wunder 93117 |
| 23:41 |
munin |
brendan: The current temperature in Northwest Goleta, Goleta, California is 19.6�C (3:34 PM PST on February 17, 2010). Conditions: Clear. Humidity: 46%. Dew Point: 8.0�C. Pressure: 29.90 in 1012.4 hPa (Falling). |
| 23:45 |
|
biglego joined #koha |
| 23:48 |
|
biglego left #koha |
