Time Nick Message 12:01 |Lupin| gmcharlt: still around ? 12:11 nahuel hi chris 12:38 Amit hi nahuel, jwagner 12:40 nahuel hi am 12:41 jwagner Morning everyone. 12:41 owen Hi 12:41 jwagner Got a reports question for you, if anyone is awake :-) 12:41 nahuel hi owen & jwagner 12:42 jwagner Is it possible to create a saved SQL report (or do it via custom script) to extract certain specific MARC fields and subfields? 12:42 nahuel 2 solutiosn 12:42 owen sql can't retrieve MARC fields unless they've been mapped to Koha tables 12:42 nahuel solutions 12:42 jwagner In Unicorn, for example, I could create a bibliography report and could specify the exact fields I wanted in the output (245, 970, etc.) 12:42 nahuel 1) you use XPATH with mysql 5.1 12:42 nahuel 2) you use substr... but it's a bit hard 12:43 jwagner Darn. I hadn't seen any way to do it in Koha, but I was hoping I'd overlooked something obvious :-( nahuel, I'm not familiar with XPATH -- is it a module or external program? 12:44 nahuel there is no way "in koha" 12:44 nahuel you can only do it in mysql 12:44 nahuel mysql 5.1 have some xpath function to parte fields content 12:44 nahuel parse 12:45 nahuel but don't know any production system that uses mysql 5.1 at the moment 12:45 nahuel even debian don't use it in "unstable" version 12:46 jwagner OK, that's something to investigate. I'm looking under Administration at Koha to MARC mapping -- I see certain fields have been mapped, like 240 to unititle, etc. If I'm migrating data that I need to get at, I could shoehorn it into one of these fields and get it that way. Is that correct? (Even if not proper cataloging.) 12:48 owen What about defining additional search points in Zebra? 12:48 nahuel jwagner, depends how you synchronize the data, but yes you can 12:48 jwagner It's not so much a problem of _searching_ for the data -- they want to run a report to output certain specific MARC tags/subfields. 12:49 jwagner nahuel, I don't see any option to create a new mapping. What are the implications of trying to do that? My instinct is telling me that it may be risky. 12:52 nahuel you can't :) 12:53 jwagner Well, that's pretty definitive :-) Thanks. We'll have to look into some options/alternatives. 13:04 gmcharlt |Lupin|: about? 13:05 |Lupin| gmcharlt: databases again :/ 13:06 |Lupin| gmcharlt: I think my settings are right, but there is still something strange. 13:07 |Lupin| gmcharlt: I have one table that I try to copy from one database to the koha database. In the old non-koha database (which is in latin 1) the accents are displayed correctly. But in the freshly created koha db in utf8, the accents are not shown properly 13:08 gmcharlt |Lupin|: where? the mysql command-line? 13:09 |Lupin| gmcharlt: in the old db I did a alter table mytbl convert to character set utf8, and even after that the accents were displayed correctly in the old db. then did a dump, copied the def and values for that table to another file, loaded it in the koha db, and accents wrongly displayed... 13:09 |Lupin| gmcharlt: yep all that at mysql's prompt. 13:10 gmcharlt |Lupin|: that may not be the best test if your terminal settings are slightly off - better is seeing what it looks like in Koha 13:10 |Lupin| gmcharlt: ok. 13:11 |Lupin| gmcharlt: isn't it possible to set the terminal up so that the test becomes meaningful ? 13:11 |Lupin| (I hink my terminal is configured correctly, actually) 13:12 gmcharlt |Lupin|: yes, it should be possible - the problem may not be the terminal setting, but a mysql client setting 13:15 |Lupin| gmcharlt: I was wondering whether mysqldump may corrupt somehting ? 13:15 gmcharlt |Lupin|: possibly - check to see if it has options for doing charset conversion on the fly 13:17 |Lupin| gmcharlt: ok 13:18 |Lupin| gmcharlt: the wiki doesn't say anything about it, but mayme one must use the same kind of configuration option than those used for mysql (the command-line client) ? 13:26 |Lupin| gmcharlt: anyway, in Koha the characters are displayed the wrong way, too 13:51 owen Reading gmcharlt's message to koha-devel, I'm wondering whether one can find a list of all the default assignees in Bugzilla? 13:56 cau0730 morning and afternoon #koha 14:07 cau0730 oops had to restart... this stupid computer that i have at work has so many issues 14:12 gmcharlt owen: http://wiki.koha.org/doku.php?id=en:development:bug_default_assignees 14:13 owen Thanks gmcharlt. I would have thought there'd be a way to look at it inside Bugzilla 14:13 slef oh wow, my multiple edits to that email really didn't clarify it at all, did they? 14:13 slef sorry to everyone who got that 14:14 gmcharlt owen: there is for bz admins, but I haven't found one for ordinary users yet 14:18 cau0730 i got a good one for you all... These ladies wanted to sort by items lcn a couple of years ago so my predecessor did this. sort by passed sort, put sorts into an array, do a perl sort based on lcn and put those into a temp array, now results array = temp array lol that is what i deal with :) and they are unhappy and i understand why lol 14:28 cau0730 on 2.2 i have been able to increase searching speed by about 30% btw.