Time Nick Message 18:44 chris hi tim 18:46 tim hi chris 18:51 chris hows life in iowa? 18:56 tim Not bad. Been in Canada till last night. 18:56 tim How was your time in the states? 18:56 chris ohh, cool, vacation? 18:57 chris it was great thanks 18:58 chris the northwest is really pretty, washington and oregon state along the coast are beautiful 18:59 tim Visiting relatives. First time outa this country for me. 18:59 chris where abouts in canada ? ive only been to toronto 19:03 tim Saskatchewan. I think I spelled it right. A small town about half way between Regina and Saskatoon. 19:04 chris ahh yes, on the plains eh? I hear it can get pretty cold there in winter 19:04 tim Yeah. It wasn't too bad yet, but not as good as I'd like at times. 19:16 owen chris, it sound like you were talking last night about the same issue I bugged yesterday: http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=854 19:17 chris yep thats it 19:18 chris its the lock tables privilege 19:19 owen I wasn't even sure if those pages were still in use, but I guess they'd have to be if people can turn MARC off. 19:19 chris yep 19:19 chris HLT will want to use them 19:19 chris that priv thing may well bite in other places also 19:20 chris (since turning the MARC off only means u dont have to see it when ur acquisitioning, it still puts all the stuff in the MARC tables anyway) 19:21 owen I was curious to see how the marc record looked when an item got added in non-marc mode. 19:21 chris i can find you one if you want 19:21 owen No, I'll just wait for a fix. 19:22 chris right the fix will be to Install.pm 19:22 chris cos its setting the mysql permissions slightly wrong 19:22 chris you can manually fix it by jumping into the mysql db 19:23 chris and running update db set Lock_tables_priv='Y' where user='yourkohauser'; 19:23 chris then mysqladmin reload 19:24 chris and the permissions will be fixed 19:24 chris otherwise it will take a new install 19:24 chris (if that makes sense) 20:27 tungsten hi 20:47 tungsten hi 21:16 rach hi 21:20 tungsten still strugling with item count zero 21:21 tungsten could it be a difference from microlif and marc21? 21:22 tungsten if I ener manually everything works fine 21:22 tungsten 2.0.1 item count zero in opac 21:31 rach so if you look in the intranet, you get an item 21:32 rach but if you look in the opac you don't? 21:39 tungsten no items all zero 21:40 tungsten zero through out 21:40 chris and if you look in the database, in the biblioitems table, they all have an itemtype set? 21:41 chris do you know how to get into mysql from the commmand line? 21:42 tungsten I getting ready to bulk import on a fresh install 21:43 tungsten yes I know a little mysql 21:44 tungsten should I look at something now before I install 21:44 chris yes please 21:44 tungsten I'm at the mysql prompt as root now 21:44 tungsten use koha 21:44 chris yep 21:44 chris then 21:45 chris select itemtype from biblioitems limit 5; 21:45 tungsten empty set 21:46 tungsten marc-check ran fine 21:46 chris hmm so you have no biblioitems at all 21:46 chris can you try a bulk import 21:46 tungsten no data loaded yet 21:46 chris and then try the select again 21:47 tungsten a couple of records will do? 21:48 tungsten 3 records three null 21:49 tungsten 3 records loaded three null reported 21:49 chris right 21:49 chris there the problem 21:49 chris for some reason itemtype isnt being set 21:50 chris what does 21:50 chris select * from itemtypes; 21:50 chris give you 21:50 tungsten I pulled these three records off the original install they do have tag 90 subfild c and d 21:50 chris yep 21:51 chris its not getting set in the db tho 21:51 chris does 21:51 chris select * from itemtypes; 21:51 tungsten BOOK book 0 0 0.0000 21:51 chris right 21:52 chris can we try this 21:52 chris select * from items; 21:52 tungsten I set my itemtype to BOOK 21:52 chris you should get 3 items 21:52 chris if so 21:52 chris then if we go 21:52 chris update biblioitems set itemtype='BOOK'; 21:53 tungsten empty set for items 21:53 chris ahh 21:53 chris 2 problems then, its not setting the itemtype, and its not adding items 21:54 chris so something is broken in bulkmarcimport 21:55 chris i know nothing about how bulkmarcimport works, so i wouldnt know where to start fixing it, if you report it as a bug and bugs.koha.org hopefully someone who knows about it will work on it 21:55 tungsten is this common error 21:56 chris im not sure 21:57 chris do you know if the marc data has item data attached? 21:57 chris like barcode etc 21:57 tungsten not specially 21:58 tungsten yes in 852 holdings 21:58 tungsten I have changed it to 952 to match koha import same thing no count 21:58 chris and that is mapped to items.barcode? 21:59 tungsten is there a diff in microlif and marc21 21:59 chris im afraid im at the end of my suggestions, i know very little about MARC 21:59 tungsten yes 22:00 tungsten is that an address like http://bugs.koha.org? 22:01 chris thats right 22:01 tungsten thanks 22:18 tungsten the really interesting thing is I took the record I made manually which shows item count and did an export and then a bulmarcimport same prob no item count 22:19 tungsten I see that you reported the bug thanks 22:19 tungsten the really interesting thing is I took the record I made manually which shows item count and did an export and then a bulmarcimport of that record which I know works same prob no item count 22:20 chris well thats expected behaviour, the export doesnt export the item data, only the bibliographical data 22:20 chris so export->import wont work 22:21 tungsten no the biblio and holdings 952 are all their 22:21 tungsten the export extract the whole reocd 22:21 chris Note : the items are NOT exported by this tool 22:23 tungsten I have the xml I'm looking at it 22:23 chris yep im reading the comments in the code 22:23 tungsten it has all the local holding info stored in 952 22:24 chris it must be missing some information still im guessing 22:25 tungsten thanks again you are very patient 22:26 chris no problem .. i wouldnt expect and export->import to work .. but if you got full marc records from another library system, then that import should work 22:27 chris the export is so you can share bibliographical data with other libraries, ie they can use it as a starting point for their catalogue 22:28 tungsten g2g 05:51 rach hello & good night paul 05:51 paul good night to you rach 05:52 paul (good morning for me...) 05:52 rach yes good morning to you :-)