- Koha-devel - lists.koha-community.org

tropheesdulibre.org competition results.
by paul POULAIN 25 May '03

25 May '03

Hi Guys, I'm back from Soissons, Tropheesdulibre. I'm sure you're interested to know who wins. So, here is the answer... In Game category, it's VegaStrike. In General Public category, it's Weasel Reader In Accessibility, it's Gok, In Educational, it's Gcompris In TodoManagement, it's Dolibarr, In Application Agencies. Hmm... let me remember... I think I forget... One minut, there was 3 candidates : Localis, from Mose, mm... no, that was not him. A nice guy anyway. CPS... ah, yes, i remember this guy. But I don't remember seeing it winning anything. Koha. Was Koha the winner ? Let me think a little second. hmmmm.... Ah, that's it, I remember : yes, Koha wins. :-D :-D Note : I just arrived at home. Some more information tomorrow morning for me (GMT+2) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

Marc Table Description
by Lerenard Michel 22 May '03

22 May '03

hi We are finishing to convert an old database and we are currently trying to fill the marc table. I am currently having problem with two fields of the marc_word table: tagorder subfieldorder I have the idea that the two fields contain the number of the field and subfield entered when adding a biblio/item. The tagnumber tells if the tag is the first asked , or the second, and so on, in the form. The subfield number indicates if the field is the first field or the second (and so on) of the tag. For example, if i need to enter five fields to add a biblio : (215a,215b,400a,801a,995f, for example) each field will have a tag number, from 1 to 4 (1,1,2,3,4), and a subfield number, respectively 1,2,1,1,1. I hope you will understand, it is not that easy to explain ! :) My question is : do Koha need those fields (for researches or something else ) , or can i leave them empty ? Thanks in advance Michel LERENARD

1 0

Inter Library Loan meeting
by Pat Eyler 21 May '03

21 May '03

the log from the meeting is at: http://www.haz.cmsd.bc.ca/cgi-bin/kohalog.pl?date=21May03&firstline=282&las… it looks like a good start. if you're interested, i'd recommend taking a look at the logs and jumping in. -pate

1 0

table biblioanalysis
by paul POULAIN 21 May '03

21 May '03

Could katipo confirm that the table biblioanalysis is useless and can be dropped ? -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

4 4

IMPORTANT : migration tool arrived in CVS
by paul POULAIN 21 May '03

21 May '03

Hi everybody, The NEW bulkmarcimport script everybody was waiting for just arrived in CVS. It will be released with 1.9.3 (probably today ?) It's located (in CVS tree) at $koharoot/misc/bulkmarcimport.pl It loads an iso2709 file into the ACTIVE Database. My 1st tests on sample files shows it works quite fine. Feel free to try it. How it works ? enter ./bulkmarcimport in a console, and look. Note : i'm proud, because it's less than 100 lines long => 99 lines !!! Note to *NPL* : i didn't test this on the file you send to me, as my MARC parameters are UNIMARC at the moment. I release the 1.9.3, then I test it. It would be nice to you if you sended me you marc_tag_structure and marc_subfield_structure tables to have a working USMARC. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

2 2

ZOOM
by MJ Ray 21 May '03

21 May '03

My associate Mike Taylor just told me of http://zoom.z3950.org/ which I think may be useful to koha. How do we currently talk z3950? Do we use this at all? -- MJR http://mjr.towers.org.uk/ IM: slef(a)jabber.at This is my home web site. This for Jabber Messaging. How's my writing? Let me know via any of my contact details.

3 2

Specific keyword table ?
by Jerome Vizcaino 21 May '03

21 May '03

Hello Our team at the local library asked us if it was possible to enter specific keywords for every biblio entry. My question is : is there a keyword field and (if any) where is it located ? Thx Jerome

2 1

Re: little question
by paul POULAIN 21 May '03

21 May '03

Silvia H M wrote: > Hi Paul, > > I would like to know which field of what table from the database in koha > stores the number (amount) of items of a same book? > I mean, for example If I have 3 books with the same title, author, > isbn, etc. > where should I look it for? > > Regards, > > Silvia Hernandez Hi Silvia, 1st of all, you should ask this on koha-devel ml, the answer may be instersting for other. 2nd, you should avoid "little question" in the title. As I don't know you, it's exactly the kind of mail that is junk/spam and goes directly to trash. Anyway, the answer is : The number of item is stored nowhere. You can find it with a small sql request : select count(*) from items where biblionumber=? (or isbn=?, or title=? and author=?, or ...) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

1.9.3 now or next week ?
by paul POULAIN 20 May '03

20 May '03

Hi, I can release 1.9.3 now. It will include : * z3950 search and import during biblio editing. * many, many bugfixes. and it will be the official feature freeze for 2.0 Or... I can wait a week to release it and have : * more bugfixes * a bulkmarcimport that works on MARC data (not the breeding farm import, the import for migration) (thanks to ron Wickersham that works on this) * maybe a bulkmarcimport for CSV datas (thanks to Esiee if they can send it to me). What do you prefer as users/testers ? Note : it could not include non-root install patch (from MJR) -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

4 7

Other marcformats - danmarc2
by Árni Loftsson 20 May '03

20 May '03

Hi. I am testing out Koha but I can't test on real data because it only has marc21 and unimarc. Here in denmark we use the danmarc2 marcformat which has some varations to the other 2. For example ISBN is field 021 in danmarc2 and 020 in marc21. If I want koha to understand danmarc2 what would it take. Is there some kind of definitiontable I can go to and edit or do I have to make changes in databasestructure etc. Árni Loftsson Librarian/Systemadministrator Skanderborg Public Library Denmark

2 1