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