Time Nick Message
11:01 owen Yes
10:59 kados so if you're available to work on that with me, that'd be fantastic :-)
10:59 owen Sounds good.
10:59 kados statuses and such
10:59 kados and implementing the stuff we talked about yesterday
10:59 kados but when I get back I'd like to start hammering away at testing on zoomkoha and zoomopac
10:58 kados I've got to spend about half an hour writing an email here in a sec (just had an interesting chat with a company who's looking for an ILS solution)
10:58 kados we're pretty close to golive as far as NPL's database goes
10:57 kados :-)
10:57 owen I'm just trying to decide what to fill it up with
10:56 kados owen: so your plate pretty full at the moment?
10:13 kados that will be updated tonight
10:13 kados I'm also working on a new framework for NPL
10:12 kados yea ... at least it works now
10:12 owen If it was completely broken anyway, maybe it's not a bad thing
10:11 kados I'll fix it today
10:10 kados and reverted rel_2_2 a bit too far back
10:10 kados I made a booboo :-)
10:10 kados right
10:10 owen What's the status of the MARC editor? You said you reverted to a working version but it lacks some of the recently added features?
10:10 kados (the one API that is different in dev_week)
10:10 kados to add the new search API
10:09 kados we need to make some changes to the templates too
10:09 kados so our job is to test the heck out of dev_week
10:09 owen Yeah, I think so.
10:08 kados make sense?
10:08 kados which will become 3.0 eventually
10:07 kados HEAD is using a completely different API
10:07 kados and we can release 2.4
10:07 kados (like acquisitions)
10:07 kados merge them in
10:07 kados then, we need to wait on paul to fix some bugs in rel_2_2
10:07 kados to make sure everything is working
10:07 kados basically, we just need to test it
10:07 kados so dev_week will become rel_2_4 and 2.4
10:06 kados dev_week is rel_2_2 with zebra ... ie, same API as rel_2_2
10:06 kados rel_2_2 is very close to 2.2.6
10:06 kados ok ... here's my plan
10:05 owen I'm not sure I understand where dev_week is in the grand scheme of things
10:05 kados yea
10:04 owen Encoding seems to be a problem for anyone who tries to do something out of the ordinary!
10:04 kados sweet
10:02 kados owen: how's it going?
10:02 kados owen: there are still a few manual synchs I'm working on
10:02 kados owen: we're all synched up :-)
10:02 kados hey owen
09:05 kyle brb, fire drill ; )
09:05 kyle excellent, thanks for the info.
09:04 kados yep
08:55 kyle just to make sure we're on the same page, you mean that any instance of NPL would then be replaced with Nelsonville Public Library?
08:54 kados just substitute branchcode for branchname
08:54 kados there should be a variable in the template called branchname
08:53 kyle kados: Thanks for the tip. Also, Cindy wanted to know how to change the instances of Branch Codes into Branch Names in the OPAC
08:53 btoumi ok ty and good night kados:
08:53 kados kyle: if you do, and the visibility flag for it is correct, it will show up in the item edit screen
08:52 kados kyle: in your Biblio Framework
08:52 kados kyle: you need to make sure you have a MARC mapping set up for the itemnotes field
08:52 kados kyle: if it is exposed in the framework it will show up in the item editor
08:51 kyle kados: I just found the notes field in the default template set, but koha never saves the note.
08:51 kados btoumi: but can't remember where :-) ... maybe google knows
08:51 kados btoumi: yes, I have :-)
08:50 kados kyle: if it is exposed in the framework it will show up in the item editor
08:43 kyle kados: I see there is a notes field in the items table, but I've looked through both the npl and default templates, and cannot find an area actually *add* a note to an item. Am I just not seeing it, or has nobody implemented it in any template set?
08:40 btoumi when i try to use catalogue menu and try to do a search
08:39 btoumi have u ever seen this message =>"Can't locate object method "_conn" via package "error""
08:37 btoumi ok i make u a promise it's the last question
08:37 kados i will be much more ok when this zebra project is completed
08:37 kados but other than that, yes :-)
08:37 kados well ... I'm very tired :-)
08:36 kados am I ok?
08:36 btoumi are u ok?
08:36 btoumi kados: another question for u
08:34 btoumi but i think there is a lot of work on this part
08:32 btoumi no problemo;=)
08:32 kados sorry :-)
08:32 btoumi ?
08:32 kados chris would be the one to ask ...
08:32 btoumi can u help me
08:32 kados right
08:31 btoumi and i want to know what is the different possible value for accounttype
08:31 kados fines are a mess IMO :-)
08:31 kados great!
08:31 btoumi i work on it now
08:31 kados sure
08:31 btoumi i have a question about fines
08:31 kados hehe
08:30 btoumi little sad for french football team but happy for koha team
08:30 kados as well as search :-)
08:30 kados add / edit / with biblio/items and circ is working :-)
08:30 kados so very happy :-)
08:30 kados pretty good, and you?
08:30 btoumi hi kados how are u?
08:30 kados btoumi: yep
08:29 btoumi kados: are u around?
08:28 btoumi sorry kados are u around?
08:28 btoumi kdaos are u around?
08:10 kados kyle: what's up?
08:10 kados kyle: sure am
08:05 kyle kados: are you around?
07:24 btoumi hi all
03:26 chris evening
19:32 kados thx
19:20 thd kados: I have committed the correction
19:19 thd kados: I missed a typo that hid 006. It is rarely used so it may not matter hugely. I corrected the problem before but Imagined that I had not created it.
18:54 kados thd: http://zoomkoha.liblime.com/cgi-bin/koha/acqui.simple/addbiblio.pl
18:53 thd kados: so the only code that works does not work?
18:53 kados but in dev-week the editor doesn't work at all ... the record doesn't even display :-)
18:53 kados it is
18:53 thd s/broken/very buggy/
18:52 thd kados: I thought that editing was specifically broken in rel_2_2
18:46 kados if I switch the codebase back to rel_2_2 I can edit MARC records again :(
18:00 thd apparently ;)
18:00 dewey thd: bugger all, i dunno
18:00 thd dewey: has your memory been wiped?
17:58 dewey thd: bugger all, i dunno
17:58 thd dewey: a bit?
17:57 dewey thd: wish i knew
17:57 thd dewey: shortly?
17:56 dewey no idea, thd
17:56 thd dewey: iab?
17:55 thd kados: I mostly see that you have extra columns for Zebra
17:55 kados bbiab
17:54 thd kados: I do not see any other data size differences
17:50 thd kados: maybe that is a clue. I know that data size errors have caused Koha to stop functioning when a value was arbitrarily truncated.
17:49 kados but that's unrelated to our current problem :-)
17:49 kados right
17:49 thd kados: I have `systempreferences.value` as TEXT
17:48 thd kados: the size you have for `systempreferences.value` as varchar (200) will lead to horrible problems with truncated values in the ISBD preference
17:47 kados no, no hidden there anymore
17:46 thd kados: `marc_tag_structure.hidden`
17:45 kados which extra hidden column?
17:45 kados ?
17:41 thd kados: I assume that you no longer have the extra hidden column as indicated by your MySQL dump.
17:39 thd rach: or sleep even?
17:38 thd rach: who can eat when some code is broken? :)
17:38 kados yep
17:38 thd kados: there are also three columns in a different order from previously but Koha code should be careful about naming the columns to be filled
17:37 kados rach: :-)
17:37 rach man you're a quick eater :-)
17:36 kados thd: yes, but bibliothesaurus.father isn't used in the marc editor that I'm aware of
17:35 thd kados: changing data types could be a problem especially if the old default is now invalid
17:35 kados thd: that doesn't seem related does it?
17:34 thd kados: `bibliothesaurus.father` was changed from char(80) NOT NULL default '' to bigint(20) NOT NULL default '0'
17:34 thd kados: only what I posted above
17:34 kados thd: find anything interesting? :-)
17:17 thd good night tumer
17:16 tumer goodnight all
17:16 kados (I hope)
17:15 kados I'll come back with a fresh mind
17:15 kados ok, I'm gonna take dinner
17:15 thd kados: `bibliothesaurus.father` was changed from char(80) NOT NULL default '' to bigint(20) NOT NULL default '0'
17:13 kados no change of course :-0
17:12 kados drop table if exists marc_biblio;
17:12 tumer marc editor does not rely on neither. No frameworkcode means default frameworkcode
17:10 tumer should not matter. In fact remove the whole table
17:10 kados tumer: should I remove it from marc_biblio?
17:09 tumer thd: it used to be in marc_biblio(deprecetaed) now in biblio
17:08 thd kados: you have a frameworkcode column in the biblio table
17:08 kados still no MARC editor :(
17:08 kados duplicates even
17:08 kados now there are no dupliantes
17:08 kados and imported thd's framework from rel_2_2
17:08 kados marc*structure
17:08 kados I deleted everything now
17:08 kados it's all in there
17:08 tumer you only have 952$b where is the rest
17:07 kados where is what?
17:07 tumer where is it?
17:06 kados 952
17:06 tumer where do they map items?
17:05 kados so that's got to be the problem
17:05 tumer kados thats not normal
17:05 kados no, both are blank
17:04 kados so one frameworkcode is null, the other is blank
17:04 kados | 952 | b | homebranch | homebranch | 0 | 0 | items.homebranch | 10 | branches | NULL | | | | 0 | 0 | | |
17:04 kados | 952 | b | homebranch | homebranch | 0 | 0 | items.homebranch | 10 | branches | | | NULL | NULL | NULL | NULL | | NULL |
17:04 tumer i thought they use 952
17:04 kados 952 b is there, but duplicated
17:03 kados ahh ... 952 doesn't exist
17:03 tumer so you do not have 952$a either
17:03 kados wtf!
17:03 kados Empty set (0.00 sec)
17:03 kados select kohafield from marc_subfield_structure where kohafield = 'items.onloan';
17:03 kados Rows matched: 0 Changed: 0 Warnings: 0
17:03 kados Query OK, 0 rows affected (0.00 sec)
17:03 kados tumer: UPDATE marc_subfield_structure set kohafield='items.onloan' where tagfield='952' and tagsubfield='a';
17:03 kados weird
17:00 tumer try: select kohafield from marc_subfield_structure where kohafield<>''
16:59 tumer duplicates unless have differnt frameworkcodes messes it up
16:59 tumer manually add it=> "UPDATE marc_subfeld_structure set kohafeld='items.onloan' where tagfeld='952' and tagsubfield='a'
16:58 kados and duplicates!
16:58 kados and some with values
16:57 kados gives a bunch of blanks
16:57 kados select kohafield from marc_subfield_structure where kohafield is not null;
16:56 kados who!
16:56 kados yea
16:55 tumer so you could not map it than /you meaning the code
16:55 kados tumer: no!
16:54 tumer select * from marc_subfield_structure where kohafield='items.onloan' -- does this work
16:53 tumer untill we resolve other issues
16:53 tumer empty frameworkname is no problem and at this stage more healthy
16:52 tumer if it is default (ususlly is) its empty
16:52 tumer biblio holds the name of the framework if it exsist for that specific biblio
16:52 tumer kados:its normal
16:51 kados morning rach
16:51 kados empty on rel_2_2 too
16:51 kados hmmm
16:51 rach morning
16:51 kados empty set
16:51 kados select frameworktext, frameworkcode from biblio_framework;
16:51 kados ha!
16:46 kados but I can't identify where the problem is
16:46 tumer is NPL dd so much different?
16:46 kados yes
16:45 tumer so upgrading path problrms?
16:44 kados tumer: so if i start with a stock rel_2_2 it works, but if I upgrade NPL it doesn't :(
16:36 kados tumer: now I attempt to upgrade a NPL database
16:36 kados tumer: it was working with a stock rel_2_2 db with some modifs
16:36 kados 108
16:36 kados select count(*) from marc_tag_structure where frameworkcode='';
16:34 tumer i thought up untill now your code was working with dev_week zebra serach, marc editor etc
16:32 tumer dev_week differs in biblio,pm some dtabase added columns and circ2.pm
16:32 kados but I can't find where :(
16:32 kados it must be npl database
16:31 kados yea
16:30 tumer dev_week addbiblio.pl templates are all the same as any rel_2 no changes
16:29 kados strange that there is no error
16:29 kados tumer: I wonder if it's the code in dev-week
16:29 kados tumer: I reverted and the editor still doesn't work
16:27 tumer ping me as i am deep under a zebra
16:24 tumer and thats get circ working on that
16:24 tumer in fact go as back as your editor was working
16:23 kados tumer: yes
16:23 thd kados: do you not need the devel-week columns?
16:23 tumer kados: can you revert to NPL framework?
16:22 kados that's all I saw
16:22 kados and new columns added in to work with dev-week
16:22 thd and ?
16:22 kados yes, like encoding
16:22 thd ?
16:22 thd kados: you had uninteresting differences
16:21 thd kados: yes but you have many do you not?
16:21 kados thd: I assume you have a rel_2_2 db to diff it with
16:20 kados thd: that's the one that is failing
16:20 kados thd: http://zoomopac.liblime.com/koha.sql
16:20 thd kados: leave that option out if it is incompatible with your MySQL install
16:19 thd kados: the -d or --no-data option exclude the data then you can diff the good version and the problem version DB structure.
16:19 kados so I need to remove that column from marc_subfields_structure?
16:19 kados thd: mysqldump: unknown option '--singletransacton'
16:18 tumer kados:biblio now holds the frameworkcode but they are still in marc_subfields_structure table
16:17 thd kados: mysqldump -d --allow-keywords --singletransacton [-h YourMySQLServername] -u YourKohaMySQLUsername -p YourKohaDatabasename > KohaNoDataBackup.sql
16:16 kados thd: it comes up blank
16:16 kados thd: well ... I can't use the editor
16:16 thd kados: are the frameworks messed up?
16:15 kados still no ideas for why the frameworks are messed up :(
15:55 kados brb
15:51 kados thd: doesn't look like any significant changes :(
15:44 kados thd: ok
15:44 thd kados: export the NPL SQL DB tables and column names without the data and do the same for rel_2_2 then run a diff on the output
15:44 kados tumer[A]: could that be related to the problem?
15:44 kados update koha.biblio,koha.marc_biblio set biblio.frameworkcode=marc_biblio.frameworkcode where marc_biblio.biblionumber=biblio.biblionumber;
15:44 kados tumer[A]: I ran:
15:42 kados in the log
15:42 kados tons of things like that
15:42 kados Q2 : select distinct m1.bibid from biblio,biblioitems,marc_biblio,marc_word as m1,marc_word as m2,marc_word as m3,marc_word as m4,marc_word as m5,marc_word as m6,marc_word as m7,marc_word as m8,marc_word as m9 where biblio.biblionumber=marc_biblio.biblionumber and biblio.biblionumber=biblioitems.biblionumber and m1.bibid=marc_biblio.bibid and (m1.bibid=m2.bibid and m1.bibid=m3.bibid and m1.bibid=m4.bibid and m1.bibid=m5.bibid and m1.bibid=m6.bibid and m1.bibid=m7.bib
15:42 thd kados: less verbose lines were easier to edit in vim
15:41 kados some strangeness happening
15:41 kados hmmm
15:40 thd kados: my framework code is not careful so to name the columns on each line. I discussed the issue with paul before I committed. He agreed that this was not a problem for the framework until a column is added in the future and then the framework would need updating in any case.
15:38 thd kados: extra columns should not be a problem really if the code is verbose enough to be careful about columns.
15:37 kados hehe
15:36 thd kados: The NPL SQL DB has legacy buggy crust from previous versions like extra columns where they are not used.
15:35 kados thd: back then frameworks were a mystery to us :-)
15:35 kados thd: yep, I remember that
15:35 thd kados: owen refused to make any changes in the NPL framework long before I had worked on a standard MARC 21 framework because previous template problems with editing the framework had caused corruption and were very difficult to undo.
15:35 kados could it be dev_week codebase?
15:34 kados so it can't be related to marc_tag_structure or marc_subfield_structure
15:33 kados works fine in stock rel_2_2
15:32 kados thd: something about this marc21 framework isn't sitting right with NPL's system
15:20 kados all are the same with another rel_2_2 db I have
15:20 kados | marc_tag_structure |
15:20 kados | marc_subfield_table |
15:20 kados | marc_subfield_structure |
15:20 kados | marc_breeding |
15:20 kados | marc_blob_subfield |
15:20 kados marc_biblio |
15:18 kados hehe
15:17 thd kados: arrrg? do you not have enough arguments?
15:16 kados arrrg!
15:13 thd wait a minute maybe I am misspelling it now. Or it was universally misspelt by LC.
15:11 thd 952 $a librarian's text
15:11 kados thd: where?
15:10 kados hehe
15:10 thd kados: yes :0
15:10 kados thd: did you?
15:10 kados thd: ?
15:10 thd kados: Koha refuses to work if I misspelt cancelled :0
15:07 kados DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at /koha/cvsrepos/22/koha/updater/updatedatabase line 1953.
15:07 kados DBD::mysql::db do failed: Can't DROP 'PRIMARY'; check that column/key exists at /koha/cvsrepos/22/koha/updater/updatedatabase line 1948.
15:07 kados DBD::mysql::st execute failed: Duplicate column name 'authtypecode' at /koha/cvsrepos/22/koha/updater/updatedatabase line 1920.
15:07 kados when I ran updatadatabase I got :
15:06 thd manually
15:06 thd kados: those were template problems for submitting a value
15:06 kados wow, this is really strange
15:06 kados didn't help
15:06 thd kados: I do not recall a problem with no OPAC text
15:05 thd kados: I believe we had a problem with no librarian text
15:05 tumer it shouldnot matter
15:05 kados thd: would that matter?
15:05 thd kados: 952 $a was set to tab 10 in my copy of the framework but the OPAC text was missing.
15:05 kados tumer: now you know why I wanted to start with a new database for NPL :-)
15:03 kados yea, seems like it :-)
15:03 tumer kados i think there is some confusion in you system with the new framework and all that
15:02 kados this is strange
15:02 kados it's completely blank!
15:02 kados no!
15:01 tumer kados does you marc editor work?
15:01 tumer so all looks good
15:00 kados subfield u
15:00 tumer mapped rather
15:00 kados grrr
15:00 tumer kados: where is itemnumber defined?
14:58 kados still not working
14:58 kados right
14:58 tumer all item fields have to be defined in tab 10 to be updated even if hidden. KOHA logic
14:58 thd oops
14:57 kados ahh
14:57 tumer it has to be managed in tab 10 may be hidden
14:57 kados not repeatable or mandatory
14:57 kados hidden is set to -1
14:57 kados managed in tab ignore
14:57 kados no text for OPAC
14:57 kados text for librarian is 'Invalid or canceled piece designation (canceled barcode) (similar to 876-8 $r)'
14:56 kados ahh
14:56 tumer no name= default=''
14:56 tumer kados:have you given it a name or what?
14:55 kados I'm using thd's framework with some modifications
14:55 tumer are you using a named framework or default?
14:54 kados still doesn't update zebra
14:54 kados sigh
14:53 kados you have to update the framework in the framework section
14:52 kados the koha2marc links script doesn't work anymore :(
14:52 tumer shoot
14:52 kados I found the problem
14:52 tumer ???
14:52 kados hmmm
14:51 kados owen: soon as I get circ working with zebra I'll update circulation.pl
14:50 tumer this one liner can go in anyversion of Circ2 and it should update MARC and zebra
14:49 kados right, it doesn't for me either :-)
14:49 tumer it does not update holding branch when transfered
14:49 kados blocker even :-)
14:49 kados which should be filed as a bug in my opinion
14:49 kados not even for branches I think
14:48 tumer rel2_2 does not update marc at all
14:48 kados because as currently written, koha's not updating the MARC properly if I understand, right?
14:48 tumer and thats only 4 lines of it in Circ2
14:48 kados it should be in rel_2_2 anyway, right?
14:47 kados ok
14:46 tumer wherever there is a db update just add that afterwards to your version and it should happily work
14:45 tumer in fact the only line you need is MARCmoditemonefield added to your version
14:45 kados ok
14:45 tumer you can merge it to your version
14:44 tumer yep very minor changes
14:44 kados as far as I know the API is the same, right tumer?
14:44 kados owen: we should just be able to run rel_2_2 circulation.pl
14:43 tumer so your db not in good shape?
14:43 owen This snippet in the dev_week circulation.pl tells me it's not ready for prime time: $picture = "http://cc.neu.edu.tr/stdpictures/".$borrower->{'cardnumber'}.".jpg";
14:43 kados but it's mapped!
14:43 kados sure enough, it's items.onloan
14:43 tumer warn to see what field name its trying to find
14:42 tumer and it works with all other fields
14:41 kados ie, nothing is found
14:41 kados so it's failing on "select tagfield,tagsubfield from marc_subfield_structure where kohafield=?"
14:41 kados tumer: another matter ... circulation.pl in dev_week is very different than in rel_2_2 ... is there anything special in there or can I just sync with rel_2_2?
14:39 tumer yep
14:39 kados tumer: warn inside that if isn't trigered
14:39 kados tumer: Biblio.pm line 859
14:39 kados tumer: if ( ( $tagfield, $tagsubfield ) = $sth->fetchrow ) {
14:38 tumer if status is being updated then you shuold look at some other problem not zebra
14:35 tumer zebra should trigger
14:35 kados :-)
14:35 cm hey. just peeking in. :)
14:35 kados strange
14:35 tumer should
14:35 kados hey cm
14:35 kados or throw an error
14:35 kados but it shoudl at least work for new items
14:35 kados and I didn't rebuildnonmarc
14:35 kados right
14:34 tumer 952$a was not used before?
14:33 tumer is it actually finding items.onloan i donno
14:33 kados nothing :-)
14:33 tumer so what else can I say
14:32 kados I followed it through to MARCaddbiblio
14:32 kados yep, I see that
14:32 tumer MARCmoditemonefield is in biblio.pm updates marc and zebra
14:31 kados items.onloan is mapped to 952$a
14:31 tumer kados: after that line MARCmoditemonefield will only update is items,onloan is mapped
14:31 thd tumer: and God is not telling? :)
14:30 tumer thd:god knows
14:30 tumer thd:gow knows
14:30 thd tumer: are your crashing problems unique to a MS Windows install of Zebra?
14:29 kados the warn is working
14:29 kados ok I was looking in the wrong log
14:29 kados yea, I'd do that
14:29 tumer ok back to your problem
14:29 tumer retsarted. I have to report this to ID
14:28 tumer yes zebra crashed again sayin some memory location cannot be raed application fault ......bla bla
14:27 kados :(
14:27 kados ahh, you mean your zebra crashed?
14:27 kados ?
14:26 tumer kadow wait zebra crashed
14:26 kados just not in zebra
14:25 kados :-)
14:25 kados and the status is updating
14:25 kados it is issuing
14:25 tumer thats the issuing script
14:25 tumer so not issuing?
14:25 kados tumer: the warn does not show up
14:24 thd s/assignments/assignments as standard MARC 21/
14:24 kados ok
14:24 tumer add a warn i mean
14:24 kados add a warn?
14:24 tumer before MARCmoditemonefield and see whether you are there
14:23 kados ok
14:23 tumer in circ2.pm add a line at 1057 after $sth->finish
14:23 thd kados: I tried to use the same subfield assignments as closely as I could given that some were already in use before my attempt to rationalise the remaining ones.
14:23 tumer yes you are right
14:22 kados tumer: am I correct that dev-week is supposed to update zebra with circulation data?
14:21 kados tumer: still zebra is not involved in issues or returns
14:20 thd s/map/correlate/
14:20 thd kados: I would really recommend using punctuation as opposed to changing the alphanumeric subfield assignments for 952. you otherwise would be interfering with the previous labour to map preexisting 952 and added usage to standard MARC 21 holdings. Temporary status is not standard in MARC so it should have the non-standard subfields :)
14:19 tumer i did not test my script though
14:19 kados ok
14:18 tumer i commited a patched vesrion of Circ2.pm that removed calendar dependency try that
14:18 kados tumer: running directly off a CVS repository
14:18 kados tumer: zoomopac is stock dev-week with only minor changes to searching soon to be committed
14:18 kados tumer: yes
14:18 tumer kados: are you using dev-week circulation
14:14 kados thd: if it's not fast enough, ID has promised to look into efficency options
14:13 kados thd: yes :-)
14:13 thd kados: Is NPL the live testing victim? :)
14:13 kados owen: still around?
14:13 kados thd: only testing can tell
14:13 kados thd: we hope so
14:13 thd kados: can that keep up with a heavy circulation volume?
14:12 kados thd: well we need to test to make sure it's fast enough anyway
14:12 kados thd: we're storing all the item fields (952) in MARC now ... at least theoretically :-)
14:11 thd kados: I thought my previous advocacy for storing status in MARC was mistaken on efficiency grounds.
14:11 kados thd: I don't understand the question
14:11 thd kados: are you using status in MARC only for migration?
14:08 tumer kados:repeatable_holidays is a complete new table was supposed to be there thats why its braking hang on
14:08 kados ok, statuses are working ... but I would feel much better if biblioitems.marc and zebra were up to date
14:05 kados maybe that's a bug?
14:05 kados I wonder if that's related
14:04 kados DBD::mysql::st fetchrow failed: fetch() without execute() at /koha/intranet/modules/C4/Calendar/Calendar.pm line 93.
14:04 kados DBD::mysql::st execute failed: Table 'koha.repeatable_holidays' doesn't exist at /koha/intranet/modules/C4/Calendar/Calendar.pm line 91.
14:04 tumer even if zebra does not work normal issues should work
14:03 kados but zebra didn't do anything
14:03 kados ok the item issued
14:03 kados but remember that NPL is a hybrid system :-)
14:03 kados coudl be
14:02 tumer or is it not?
14:02 tumer but thats standart koha field
14:01 kados ahh
14:01 tumer thats in issues table not items table
14:01 tumer date
14:00 kados tumer: what is the data type of the issue_date column?
14:00 thd kados: I thought my previous advocacy for storing status in MARC was mistaken on efficiency grounds.
13:59 kados see if that helps
13:59 kados right, ok I'll add it
13:59 tumer kados:table issues have a field called issue_date dont you have it
13:59 kados so issues aren't working
13:58 tumer holiday management was added to koha rel2_2 so it should work
13:58 tumer s/work/for/
13:57 tumer not work zebra to show an item when it is due
13:57 tumer no
13:57 kados and map it to MARC too?
13:57 kados tumer: I assume I need to add items.issue_date?
13:56 tumer i was away let me catch up
13:56 kados tumer: any ideas?
13:56 kados thd: yep
13:56 thd kados: I suspect that is why other systems also do not use capitals but there are quite a few punctuation marks
13:55 kados thd: unfortunately, mysql doesn't distinguish between A and a by default
13:55 kados DBD::mysql::st execute failed: Unknown column 'issue_date' in 'field list' at /koha/intranet/modules/C4/Circulation/Circ2.pm line 1056.
13:54 kados DBD::mysql::st fetchrow failed: fetch() without execute() at /koha/intranet/modules/C4/Calendar/Calendar.pm line 123.
13:54 kados DBD::mysql::st execute failed: Table 'koha.special_holidays' doesn't exist at /koha/intranet/modules/C4/Calendar/Calendar.pm line 121.
13:54 thd kados tumer: maybe capital A-Z would also work but I have not seen capitals used for other systems
13:54 kados DBD::mysql::st fetchrow failed: fetch() without execute() at /koha/intranet/modules/C4/Calendar/Calendar.pm line 113.
13:54 kados DBD::mysql::st execute failed: Table 'koha.special_holidays' doesn't exist at /koha/intranet/modules/C4/Calendar/Calendar.pm line 111.
13:54 kados DBD::mysql::st fetchrow failed: fetch() without execute() at /koha/intranet/modules/C4/Calendar/Calendar.pm line 103.
13:54 kados DBD::mysql::st execute failed: Table 'koha.repeatable_holidays' doesn't exist at /koha/intranet/modules/C4/Calendar/Calendar.pm line 101.
13:54 kados DBD::mysql::st fetchrow failed: fetch() without execute() at /koha/intranet/modules/C4/Calendar/Calendar.pm line 93.
13:54 kados DBD::mysql::st execute failed: Table 'koha.repeatable_holidays' doesn't exist at /koha/intranet/modules/C4/Calendar/Calendar.pm line 91.
13:54 kados tumer: I get some errors too:
13:53 thd kados tumer: when you run out of a-z 0-9 for subfield names you can do what RLIN and other systems do and use punctuation for subfield names.
13:53 kados tumer: the screen does not show the issue either
13:53 kados tumer: still, zebra is not called at all when issuing
13:53 kados tumer: ok, I mapped onloan to 952$a to test
13:51 kados got it
13:49 thd kados: look in the misc directory
13:49 kados ahh
13:49 thd kados: that is the one for a new koha install not for updating old ones
13:49 kados mysql -u -p koha < structure_def.sql
13:49 kados I am manually importing with
13:48 kados the structure_def.sql
13:48 thd kados: which script are you using?
13:48 kados meaning it doesn't overwrite the existing values
13:48 kados meaning it wasn' exported with the --add-drop-table option perhaps?
13:48 thd kados: what do you mean by clean up?
13:47 kados ERROR 1062 (23000) at line 43: Duplicate entry '090' for key 1
13:47 kados thd: ie, it gives me a warning:
13:47 kados thd: no values
13:47 kados thd: also, when I import this file, it doesn't clean up the old one
13:47 thd kados: does the column have any values in the marc_tag_structure table?
13:46 kados perhaps
13:46 thd kados: maybe it was added long ago in the wrong place accidentally
13:45 thd kados: it should be in both in many ways but now I am confused :)
13:45 tumer 952$4 use restrictions --NEU maps onloan to there if interested
13:45 kados so I should remove this column from NPL's db
13:45 thd kados: oh yes you are right
13:45 tumer hidden i have in subfield structure
13:44 kados thd: I thought it was in the subfield structure
13:44 kados thd: was that in the tag structure?
13:44 thd kados: yes hidden was the one we worked on all night a couple of months ago :)
13:44 kados thd: so why does the framework only have 7 fields listed instead of 8?
13:43 thd kados:: NPL has current database and there is something missing from your rel_2_2 database columns
13:43 kados is 'hidden' a valid column for marc_tag_structure?
13:42 kados so the one that's not working has 8 columns in the table
13:42 kados the second one is from a rel_2_2 database
13:41 kados the first paste is from the one that's not working
13:41 kados but ...
13:41 tumer excellent work thd
13:41 thd kados: your error is that you do not have enough columns in the table
13:40 kados excellent
13:40 tumer in the forthcoming version of koha all these restrictions gone
13:39 kados tumer: right
13:39 tumer so it has to be 952 0-9 a-z
13:38 tumer kados: it has to be inserted into an item field. onloan is an item field and KOHA demands they all be in one field!!!!
13:38 kados where did hidden come from?
13:38 kados | frameworkcode | char(4) | | PRI | | |
13:38 kados | authorised_value | char(10) | YES | | NULL | |
13:38 kados | mandatory | tinyint(4) | | | 0 | |
13:38 kados | repeatable | tinyint(4) | | | 0 | |
13:38 kados | libopac | char(255) | | | | |
13:38 kados | liblibrarian | char(255) | | | | |
13:38 kados | tagfield | char(3) | | PRI | | |
13:38 kados rel_2_2 has:
13:37 kados | hidden | tinyint(1) | YES | | NULL | |
13:37 kados | frameworkcode | char(4) | | PRI | | |
13:37 kados | authorised_value | char(10) | YES | | NULL | |
13:37 kados | mandatory | tinyint(4) | | | 0 | |
13:37 kados | repeatable | tinyint(4) | | | 0 | |
13:37 kados | libopac | char(255) | | | | |
13:37 kados | liblibrarian | char(255) | | | | |
13:37 kados | tagfield | char(3) | | PRI | | |
13:37 kados here is NPL's marc_tag_structure:
13:37 kados strange
13:36 thd kados: really, are there not enough or too many commas?
13:36 kados there are 8 columns in marc_tag_structure
13:36 kados looks like we're missing one value
13:35 kados thd: that's line 43
13:35 kados thd: INSERT INTO `marc_tag_structure` VALUES ('090', 'SYSTEM CONTROL NUMBERS (KOHA)', 'SYSTEM CONTROL NUMBERS (KOHA)', 1, 0, '', '');
13:34 thd oops: I did not verify before committing
13:33 kados ERROR 1136 (21S01) at line 43: Column count doesn't match value count at row 1
13:33 kados thd: also, I get an error on line 43:
13:33 kados thd: it is stored in the zebra now as well
13:32 thd kados: do you need it for migration?
13:32 thd kados: I thought that status would be stored in the SQL DB
13:31 kados thd: but there aren't any subfields left :-)
13:31 thd yes kados
13:31 kados thd: I need to figure out where to map the 'onloan' field
13:31 kados thd: looking at the latest marc21 framework in rel_2_2
13:31 kados thd: I could use some advise
13:30 tumer i go and check
13:30 kados tumer: no, dev-week
13:30 dewey head is head
13:30 tumer head?
13:30 kados tumer: in zebraplugin dir off of root
13:29 kados tumer: my record.abs is in cvs
13:28 tumer i mean with different attributes
13:28 kados tumer: plus I'm doing some mappings within a field for searching fixed fields
13:28 thd kados: if you use 082 $b you will not have a numeric sort unless you transform the number and pad it as tumer has done for LC numbers
13:28 kados tumer: more than 16 I think
13:27 tumer kados:how many fields do you index at record.abs
13:27 tumer s/kados/thd
13:27 kados hmmm
13:27 tumer kados: 050$b is the general cutter. At item level there are the extra bits of volume no etc that i use
13:25 thd tumer if you sort on 050 $b as well then you are sorting with the cutter ( item) number
13:25 tumer i precombine them properly padded to a different marc field
13:24 tumer thd: i sort on 050a and 050b togeetger
13:23 tumer opac does not use it
13:23 tumer thd:cutterextra i use in copuple of scripts but not all
13:22 kados :-)
13:22 tumer thd:oh thd i did not realise i was answering to kados
13:22 tumer any idea?
13:21 tumer i now have about 16 indexes and 5 sort field
13:21 tumer may be thats my problem
13:21 tumer that is slowing the updates very much
13:21 tumer kados: i am indexing almost every field of MARC21 to a different @attr now
13:20 tumer kados:some scripts do use it like inventory control
13:19 thd tumer: I mean do you use the cutter number in sorting?
13:19 tumer kados:i was not yet
13:19 tumer kados: the only major change i did is that i changed record.abs
13:18 thd tumer: do you use the item part of the call number in your LC call number sort?
13:16 kados sweet
13:16 tumer when i open them i will post it on server
13:16 tumer i have closed all the ports currenly to try and undertsand whats happening
13:15 kados and I'll try
13:15 kados tumer: or post them somewhere
13:15 tumer with zebraidx though no problem
13:15 kados tumer: send me the records
13:15 kados hmmm
13:14 tumer blank database-- bulkmarcimport 150k records never managed to finish it
13:14 kados just took forever
13:13 tumer it did lately
13:13 kados bulkmarcimport.pl breaks it?
13:13 kados wow
13:12 tumer ID moved to ver 2.0
13:12 tumer and even with bulk marcimport alone my zebra breaks now (ver 1.4.1)
13:12 kados if I have time this week I'll try to write a test suite for zebra
13:11 tumer bulkmacrimport is one
13:11 kados I have some threaded request code I wrote for evergreen
13:11 kados agreed
13:11 tumer we have to simulate differnt process trying it at the same time
13:11 tumer we have to be able to test it heavily
13:10 kados actually, I suppose that's what bulkmarcimport is
13:10 kados that pound the zebra server with updates
13:10 kados we need to write some test scripts
13:10 tumer etc etc
13:10 kados maybe it is a zebra bug
13:10 tumer error updating
13:10 kados hmmm
13:10 tumer or cannot connet
13:10 tumer or zebra server timedout
13:09 tumer all it says bibliserver not available
13:09 kados anything useful?
13:09 tumer it show me the server name and the error occured
13:09 kados ahh
13:09 tumer i have warn messages in biblio.pm
13:09 kados tumer: to alert you if koha ever sends a command to zebra with a different database name
13:08 tumer i have taken the zebra server to command line for the last hour trying to catch anything
13:08 kados tumer: you might want to throw some warn messages in
13:08 kados 1.3.36
13:08 tumer yes very difficult to reproduce
13:07 kados I'm running the latest 1.3 series
13:07 kados tumer: in a test environment
13:07 tumer which version of zebra you hane?
13:07 kados tumer: that's the kind of bug that's really difficult to reproduce
13:07 kados hehe
13:06 kados had a meeting this morning and I was like a zombie :-)
13:06 kados that is annoying
13:06 tumer i am having sleepless nights trying to understand zebra
13:06 kados wow ...
13:05 tumer and they are working 16hrs a day on as a summercamp project
13:04 kados hmmm
13:04 kados right
13:04 tumer only marc editing, currently thats all we are doing 40 cataloguers
13:04 kados what operations does it happen with?
13:04 kados yikes
13:03 kados or marc editing?
13:03 tumer its a nightmare surrently its doing it on production
13:03 kados like circ?
13:03 kados does it happen with a specific transaction type>
13:03 kados I haven't seen it personally
13:03 kados it's possible
13:03 tumer unless the handles get messed up is such a thing possible?
13:03 kados maybe a mistake in the perl somewhere
13:02 tumer yes mauoal you can but ib koha it should not
13:02 kados I did it manually a couple of times by mistake
13:01 tumer how can we do that in koha?
13:01 kados one time
13:01 kados it seems like it happens if you index with the wrong db name
13:01 tumer have been doing it 3 times today already
13:01 kados I've seen that message before
13:01 tumer and have to reindex again
13:00 tumer suddenly says database not available
13:00 kados what's it doing?
13:00 kados yea?
13:00 tumer i am having a big problem of zebra stopping for the last 2 nights
13:00 kados I need to genericize it and commit to dev-week
13:00 kados tumer: but it works perfectly :-)
12:59 tumer i noticed
12:59 kados tumer: it takes about 25+ hours to run in total :-)
12:59 kados tumer: I've got an auto-migrate script written
12:59 tumer dewey is straight sorting
12:59 kados right
12:59 tumer lc sorting requires lots of 000's padded
12:58 tumer and set zebra to sort on these fields
12:58 tumer so map their 080a and 080b to dewey and subclass
12:57 kados yea?
12:57 tumer by the way if its dewey sorting its different
12:56 kados so if they were mapped, would zebra update correctly?
12:56 kados ok
12:56 tumer not in dew_week
12:56 kados tumer: do you map 'itemlost, wthdrawn, issues, renewals, reserves, restricted,binding, etc?
12:56 tumer thats it
12:56 kados very slick
12:55 kados then by cutterextra
12:55 kados so you sort first by lcsort
12:55 kados I see
12:55 tumer those bits are kept at cutterextra
12:55 kados right
12:55 tumer like v.1 v.3 etc
12:54 tumer but then an item has some extra bits added to sorting
12:54 kados gotcha
12:54 tumer biblioitems
12:54 kados biblio table then
12:54 kados ahh
12:54 kados that's in the items table?
12:54 tumer this is at biblioagraphic level
12:54 kados ok
12:54 tumer we preprosees that and put them in a field i named lcsort
12:53 kados (dewey)
12:53 kados NPL uses 080a and 080b
12:53 kados 050a and 050b, got it
12:53 kados ok
12:53 kados tumer: do you map 'itemlost, wthdrawn, issues, renewals, reserves, restricted,binding, etc>
12:53 tumer in NEU we use LC so for LC sorting we use fields 050a and 050b
12:52 kados well I'd like to understand regardless :-)
12:52 tumer you probably wont need that
12:52 tumer cutterextra helps with sorting LC
12:51 kados tumer: what is it used for and how?
12:51 kados tumer: cutterextra for instance
12:51 tumer ok yhe field is called onloan
12:51 kados tumer: but I do need help understanding other fields you have mapped
12:51 kados tumer: no
12:51 tumer so you need walking how to do that
12:50 tumer any free subfield in framework would do
12:50 kados yes, they are
12:50 tumer if NPL is using 952 for holdings..
12:50 kados tumer: the mapping is in the framework?
12:50 kados tumer: could you walk through it for me?
12:49 kados ahh ... perhaps I didn't map
12:49 tumer is zebra giving any errors or its just you did not map onloan field anywhere
12:48 kados great, you already know :-)
12:48 tumer about circulation not updatong
12:48 kados tumer: at leat it doesn't use zebra
12:48 kados tumer: circ isn't working in dev-week
12:48 kados tumer: sure am
12:48 tumer kados:are you around?
12:35 kyle if you remove the unused leftover files that I haven't cleaned out, you'll find there are far fewer files used.
12:34 kyle And I still contend that my template set is actually *simpler* that the npl template set.
12:33 kyle I can't count the number of times I've looked at 'clever' code I wrote, and said 'what was I thinking!!?!?!, even wth comments ; )
12:32 kyle I'm not a fan of clever anyway, I believe in writing code that is obvious. When you are writing something for others to use, or even yourself later on, obvious trumps clever everytime in my book.
12:31 kyle Probably because my tabs overlap, and are not box shaped.
12:30 kyle yeah, I've seen that before. I tried it, but I can't remember why I passed on it.
12:30 kados and they 'slide' using some clever css trickery
12:29 kados (and the 'off' ones as well)
12:29 kados http://liblime.com/images/nav/norm_right_on.gif
12:29 kados http://liblime.com/images/nav/norm_left_on.gif
12:29 kados kyle: you've got two images:
12:28 kados kyle: it's very clever actually :-)
12:28 kados kyle: use the source, luke :-)
12:28 kyle how do they work?
12:27 kados kyle: just css
12:27 kados kyle: and the 'quicklinks' at the top are also done this way
12:27 kados kyle: the tabs you see for 'home' 'koha ils' 'open source' 'contact' are done as I describe
12:26 kyle it would have been extremely complex to make tabs with the tab image in the backgound that stretches to the width of the tab lable.
12:26 kados http://liblime.com/
12:26 kados kyle: for example:
12:26 kados kyle: so I still contend that given some time, I could create a duplicate of CCFLS's templates using just css :-)
12:26 kyle I tried that, no good.
12:26 kados kyle: now, we could do graphics as background images in css with the text in front
12:26 kyle kados: have any screenshots? ; )
12:25 kados kyle: but we discovered we couldn't translate graphics :-)
12:25 kados kyle: the original versions of Koha had lots of graphics too
12:25 kados kyle: there is some history here
12:25 kados yep ...
12:25 kyle the graphics are also very aptly named.
12:24 kyle owen: yes, there are quite a few graphics, but if you look at the code, it's actually quite simple, and very easy to understand.
12:24 owen CSS can present a lot of problems, particularly if you can't influence your organization's browser choice.
12:24 owen And my point was just that I would hate to have to keep track of all those graphics
12:23 kyle CSS is still to feature lacking.
12:23 kyle A tab style template *could* have been done with css, but it would not have the polished look.
12:23 kyle I find the colors to be garish, but it doesn't matter what my tastes are, they are designed to be more usable.
12:23 kados kyle: course, that's none of my business :-)
12:22 kados kyle: I contend that you could have done a layout.css and colors.css with backround images to acomplish the same look without modifying NPL templates at all :-)
12:22 kyle exactly.
12:22 kados function is based on user needs :-)
12:22 kados just like pretty much everything else in Koha :-)
12:21 kyle And as far as maintainence, all I did was make a few changes to the npl templates.
12:21 kyle So that's where that came from.
12:21 kyle The librarians were ready to cut a check just based on the way it looked.
12:20 kyle The style strongly inspired by another ILS that we were looking at as an alternative to koha.
12:20 owen :)
12:20 kyle I just noticed some comments on my templates ; )
12:18 kados so maybe one thing would be getting the interface to look nice on small resolutions
12:18 owen Yep.
12:18 kados and they have 800x600 resolution on their circ computer
12:18 kados I stopped briefly to show the new search to the plains librarians
12:18 kados owen: well ... several things
12:15 owen So what's up?
12:10 kados cool
12:08 owen I just have to switch gears, but yeah, I'm not too busy
12:05 kados owen: so ... are you generally busy today, or have some time to hack away on Koha?
12:04 kados ciao
12:03 kados :-)
12:03 shedges so I might as well leave gracefully...
12:03 shedges going to leave now -- go back to pushing budget numbers around, and when the laptop goes to sleep it sometimes looses the wireless network