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.