← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| 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 | How was your time in the states? | |
| 18:56 | chris | ohh, cool, vacation? |
| 18:57 | it was great thanks | |
| 18:58 | 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/b[…]ow_bug.cgi?id=854 |
| 19:17 | chris | yep thats it |
| 19:18 | 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 | HLT will want to use them | |
| 19:19 | that priv thing may well bite in other places also | |
| 19:20 | (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 | cos its setting the mysql permissions slightly wrong | |
| 19:22 | you can manually fix it by jumping into the mysql db | |
| 19:23 | and running update db set Lock_tables_priv='Y' where user='yourkohauser'; | |
| 19:23 | then mysqladmin reload | |
| 19:24 | and the permissions will be fixed | |
| 19:24 | otherwise it will take a new install | |
| 19:24 | (if that makes sense) | |
| 20:27 | tungsten | hi |
| 20:47 | hi | |
| 21:16 | rach | hi |
| 21:20 | tungsten | still strugling with item count zero |
| 21:21 | could it be a difference from microlif and marc21? | |
| 21:22 | if I ener manually everything works fine | |
| 21:22 | 2.0.1 item count zero in opac | |
| 21:31 | rach | so if you look in the intranet, you get an item |
| 21:32 | but if you look in the opac you don't? | |
| 21:39 | tungsten | no items all zero |
| 21:40 | 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 | 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 | yes I know a little mysql | |
| 21:44 | 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 | use koha | |
| 21:44 | chris | yep |
| 21:44 | then | |
| 21:45 | select itemtype from biblioitems limit 5; | |
| 21:45 | tungsten | empty set |
| 21:46 | marc-check ran fine | |
| 21:46 | chris | hmm so you have no biblioitems at all |
| 21:46 | 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 | 3 records three null | |
| 21:49 | 3 records loaded three null reported | |
| 21:49 | chris | right |
| 21:49 | there the problem | |
| 21:49 | for some reason itemtype isnt being set | |
| 21:50 | what does | |
| 21:50 | select * from itemtypes; | |
| 21:50 | 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 | its not getting set in the db tho | |
| 21:51 | does | |
| 21:51 | select * from itemtypes; | |
| 21:51 | tungsten | BOOK book 0 0 0.0000 |
| 21:51 | chris | right |
| 21:52 | can we try this | |
| 21:52 | select * from items; | |
| 21:52 | tungsten | I set my itemtype to BOOK |
| 21:52 | chris | you should get 3 items |
| 21:52 | if so | |
| 21:52 | then if we go | |
| 21:52 | update biblioitems set itemtype='BOOK'; | |
| 21:53 | tungsten | empty set for items |
| 21:53 | chris | ahh |
| 21:53 | 2 problems then, its not setting the itemtype, and its not adding items | |
| 21:54 | so something is broken in bulkmarcimport | |
| 21:55 | 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 | do you know if the marc data has item data attached? | |
| 21:57 | like barcode etc | |
| 21:57 | tungsten | not specially |
| 21:58 | yes in 852 holdings | |
| 21:58 | 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 | is that an address like http://bugs.koha.org? | |
| 22:01 | chris | thats right |
| 22:01 | tungsten | thanks |
| 22:18 | 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 | I see that you reported the bug thanks | |
| 22:19 | 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 | so export->import wont work | |
| 22:21 | tungsten | no the biblio and holdings 952 are all their |
| 22:21 | 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 | 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 | (good morning for me...) | |
| 05:52 | rach | yes good morning to you :-) |
← Previous day | Today | Next day → | Search | Index