IRC log for #koha, 2009-07-29

All times shown according to UTC.

Time S 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:[…]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.  

| Channels | #koha index | Today | | Search | Google Search | Plain-Text | plain, newest first | summary