| 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: 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 |
|
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. |
