← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| 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 | 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 | you can only do it in mysql | |
| 12:44 | mysql 5.1 have some xpath function to parte fields content | |
| 12:44 | parse | |
| 12:45 | but don't know any production system that uses mysql 5.1 at the moment | |
| 12:45 | 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 | 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 | gmcharlt: I think my settings are right, but there is still something strange. | |
| 13:07 | 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 | 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 | gmcharlt: isn't it possible to set the terminal up so that the test becomes meaningful ? | |
| 13:11 | (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 | 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 | 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 | 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?[…]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 | 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 | on 2.2 i have been able to increase searching speed by about 30% btw. |
← Previous day | Today | Next day → | Search | Index