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

[Koha-win32] Koha 2.0.0pre2 is out for Windows (fwd)
by Pat Eyler 10 Jul '03

10 Jul '03

Good news for all of you windows based Koha users. -pate Pat Eyler Kaitiaki/manager migrant Linux sys admin the Koha project ruby, shell, and perl geek http://www.koha.org http://pate.eylerfamily.org ---------- Forwarded message ---------- Date: Thu, 10 Jul 2003 17:26:13 -0500 From: robweir(a)alum.drexel.edu To: koha-win32 Mail List <koha-win32(a)lists.sourceforge.net> Subject: [Koha-win32] Koha 2.0.0pre2 is out for Windows A Windows install package for Koha 2.0.0pre2 is now available. Visit the KohaOnWindows section of the Koha wiki at http://www.saas.nsw.edu.au/wiki/index.php?page=KohaOnWindows for download links and several pages of information and instructions for installing and running Koha on Windows. There is also a link for an updated install of Koha V1.2.3. Both of these installs now include the latest versions of all required Perl modules for both Active State Perl V5.6.x and V5.8.x. In addition, both installs have been tested and tweaked to run with either MySQL V3 or the new MySQL V4. Both installs include both a set of sample data and a set of blank data (these aren't perfect - they need some work). Note that you must download and install the Apache Webserver, MySQL database, and Active State Perl as pre-requisites before running these Koha installs, but that download links and full instructions are given at the above mentioned wiki pages. The V1.2.3 is a stable release, but lacks support for MARC. Koha 2.0.0pre2 is a test pre-release, meaning it still has some bugs and features that do not work. It is provided so you can start testing and preparing for a stable V2 release in the near future. I would welcome suggestions for how to improve these Windows install packages for future versions. I would also greatly appreciate if someone could contribute a better set of sample data to include in future installs. Or perhaps someone could clean up and fix up the current set of sample data and then send me a copy. Please address any suggestions or questions to koha-win32(a)lists.sourceforge.net Rob ------------------------------------------------------- This SF.Net email sponsored by: Parasoft Error proof Web apps, automate testing & more. Download & eval WebKing and get a free book. www.parasoft.com/bulletproofapps1 _______________________________________________ Koha-win32 mailing list Koha-win32(a)lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/koha-win32

1 0

koha help request please!
by Allyson Bright 10 Jul '03

10 Jul '03

Hello everyone- I apologize if this is the incorrect forum for requesting help with Koha, but I am just at my wit's end, I've tried for 2 straight days to fix just this one thing, and I just can't get it to work. I've tried reading all sorts of documentation, but am coming up with nothing. Here's the problem...I installed Koha on windows, with Apache, mysql, and perl. Everything is up and running just fine, got the graphics scheme changed, etc. All works and looks perfect, except one thing. The date format needs to be changed. I'm working at a small nonprofit organization in Iowa, and the metric date format dd/mm/yy is too confusing for the people we serve, just because they are not used to it (sorry if I sound like an irritating American here). I changed the date in system parameters, but that didn't do anything except change the database entry for dateformat. I went through the lines of code in every *.pl file and got rid of the "Slashifydate" command in every place it appeared, so the date now appears in the yyyy-mm-dd format, which is better, but still not what I'm going for. Plus, there are places that the date still appears as dd/mm/yy (such as the detail.pl screen for biblio details), despite this change. I really need it to show the dates in mm/dd/yy format, or at least get them all into yyyy-mm-dd, but what I really need is for them to show up as mm/dd/yy or mm/dd/yyyy. If there is any way you can help me with this, please reply asap. I'm just at the end of my rope, and the project deadline is coming up very soon. Also--I am a woman with very little to no programming experience. I've been reading "teach yourself perl" sporadically, but that's my only knowledge of the program. Programming isn't my specialty or even in my job description, it just happened that we had a need for koha, and since I'm the most technically literate of the bunch, I got the job. But I still know very little, so I need really exact instructions on how to fix this, what lines to change, etc. I'm sorry if that's a pain, but I just really don't know that much! I'm using Koha because I didn't know how to design a program like this from scratch, or even the databases. I'm learning a lot as I go, but still need a lot of help. Just this one last date formatting issue needs to be fixed, and after that, I should be all set. If you can be of any help, I would greatly appreciate it!! Thank you SOOO much! -Allyson Bright

1 0

Koha 2.0.0pre2 is out
by paul POULAIN 10 Jul '03

10 Jul '03

Hi all, Koha 2.0.0pre2 has just been released : http://sourceforge.net/projects/koha/ RELEASE NOTES ============= Bugfixes & some improvements (security & perf only) It has been placed in the "unstable tree" because there are still some bugs. But it's fully usable, and should not be modified a lot until a stable version is released. DB modifications : --------- None, but check that your systempreferences table is : CREATE TABLE systempreferences ( variable varchar(50) NOT NULL default '', value varchar(200) default NULL, explanation varchar(200) NOT NULL default '', options text, type varchar(20) default NULL, PRIMARY KEY (variable) ) PACK_KEYS=1; If you installed a 2.0.0pre1 from scratch, it should be ok. If your version was a 1.9.x, it should not be ok. SYSTEMPREFS : --------- In systempreferences, add a gist field. Used to calculate gst when ordering, in acquisition module. Enter 0.12 for 12% rate. IMPROVMENTS : --------- * checkmarc.pl : added a check on fields mapped to item marc tag (by Paul). * overdue books backported from 1.2.x (& templated) (by Chris) * some additionals check to verify a borrower can borrow a book (by Esiee) * MARC search (in intranet) : - dramaticaly improving the speed of a MARC search in case of a A OR B search (by Paul) - Users can search using more than 3 criterias (criterias are now added dynamically) (by Esiee) - Results can be displayed using 20,50 or 100 results per page. (by Esiee) - Added arrows and numbers to walk through the results (as in OPAC) (by Esiee) BUGS FIXED : --------- * 2 stupids & majors bug in MARC editor, due to too fast copy/paste. (fixed by Paul) * bug 479 : I have problem to assign a Sticky due date, it uses day date as year due date !!! (fixed by ?) * bug 471 : missing next / previous in itemtype admin page, in case there is more than 20 itemtypes (fixed by Paul) * bug 474 : alternate contact no more required (fixed by Paul) * bug 478 : value modification with single quote now works (in parameters section) (fixed by Paul) * bug 489 : poor file copying during install (fixed by MJR) * bug 526 : gst rate hardcoded. Moved to systempref (see SYSTEMPREFS chapter). (fixed by Paul) If supplier parameters are set to do it, the gst are now auto calculated with javascript. * bug 512 : bibliosubject table is not being populated (fixed by Paul) * bug 513 : marclinks: default mapping typo (fixed by Paul) * updatedatabase bugs : now, the updatedatabase script (located in scripts/updater) works and update your DB structure. note it only adds fields & tables. The MARC parameter tables won't be populated, neither the MARC-DB. (fixed by Paul) KNOWN BUGS : ------- * bug 510 : new doc needs to be integrated * bug 487 : upgrade problem from a previous version. If you install from scratch, it should be fine. * bug 515 : biblio.notes ignores Marclinks mapping durring import * bug 293 : Error Issuing Book - 1 in some specific cases * bug 523 : requests does not store dates in reserves table plus some other, less critical. -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

1 0

Catalogueentry table
by Lerenard Michel 09 Jul '03

09 Jul '03

Hi i'm currently trying to know what is the purpose of the catalogueentry table. I search in the koha files, and i found that only one file is referring to this table: there is a "sub" called OLDmodsubject in the Biblio.pm library. I don't understand the purpose of the function either... Are the table &function useful, or are they "relics" :) from previous version of Koha ? thanks

1 0

Catalogueentry table
by Lerenard Michel 09 Jul '03

09 Jul '03

Hi i'm currently trying to know what is the purpose of the catalogueentry table. I search in the koha files, and i found that only one file is referring to this table: there is a "sub" called OLDmodsubject in the Biblio.pm library. I don't understand the purpose of the function either... Are the table &function useful, or are they "relics" :) from previous version of Koha ? thanks

1 0

Re: [Koha-devel] Re: [important] copyrightdate is not loaded intobiblio table
by Stephen Hedges 08 Jul '03

08 Jul '03

Paul wrote: > In the MARC part of the DB, the complete 260c > field will be stored, of > course. So it's possible for the librarian to > find what you asked. > The numeric value is only for the koha-DB. This > one is used in opac > search (although it should be possible & easy to > add MARC search in opac > too), and in some lists. > For example, when you search for a book, the list > shows title, author, > copyrightdate & nb of items. > > with this explanation, do you change your mind & > agree with rosalie ? Ah, if only the Koha-DB was used to find the record, and the MARC-DB was used to display it -- then we'd have the best of both worlds. But if I have to choose one, I'd have to say that the "stripped" date -- just the date, no other information -- is the better thing to store in the Koha-DB. That makes searching and administration easier, and it's always possible to re- work templates later to pull additional information from the marc_subfield_table -- right? Stephen

1 0

Re: [important] copyrightdate is not loaded into biblio table
by Stephen Hedges 08 Jul '03

08 Jul '03

Hi, Paul - You asked for opinions about the copyrightdate: > So, we have 2 solutions (both being easy to code) > : > * modify the DB structure to have a char, and > copyrightdate would be : > "c1968, reedited 1985, something else 1995" in my > sample. (con : Maybe a > little too many info for OPAC ?) > * modify the import tool to extract the 1st > "date" in the string (mean, > the 1st time where 4 digits are found) : "1968" > in my sample. (con : > risk to choose a date that is not really a > copyrightdate) > > Which solution do readers of this list prefer ? My first reaction is that there's no such thing as too much information, even in an OPAC, which would indicate that your first solution is the best. However, what about searching? For example, if I want to find books about space stations published since 1993, can I do that if the copyrightdate column contains "c1993" or "reedited 1993?" Stephen

3 2

Systempreferences.pl
by Jerome Vizcaino 08 Jul '03

08 Jul '03

Hi all Since the last update of systempreferences from CVS, my system preferences page does display anything. Reading the logs I've seen that the script now supports droplists for some values. Is there anything that needs to be changed apart from the koha files (some part of the db for example) so that the file works correctly ? Thanks Jerome

5 8

[important] copyrightdate is not loaded into biblio table
by paul POULAIN 07 Jul '03

07 Jul '03

Hi Stephen, & koha-devel. for everybody : this mail is about import of copyrightdate into Koha. You can see the initial bug at http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=514 Stephen pointed that copyrightdate was not loaded into Koha-db when importing MARC records (note that the 260c was imported into MARC-DB. The problem was that it was not transfered to koha-db (the DB that is used in many places where MARC is not interesting, like opac for example). I thought it was a spydus problem, but I was wrong. 260c in MARC21 contains "dates". It means it can contain : "copyright 1968, reedited 1985, something-else 1995". (see http://www.loc.gov/marc/bibliographic/ecbdimpr.html#mrcb260) The problem for importing is that copyrightdate is a *NUMBER* in koha-db. and "c1968, reedited 1985, something else 1995" is not really a number :-( So, we have 2 solutions (both being easy to code) : * modify the DB structure to have a char, and copyrightdate would be : "c1968, reedited 1985, something else 1995" in my sample. (con : Maybe a little too many info for OPAC ?) * modify the import tool to extract the 1st "date" in the string (mean, the 1st time where 4 digits are found) : "1968" in my sample. (con : risk to choose a date that is not really a copyrightdate) Which solution do readers of this list prefer ? Stephen Hedges wrote: >Paul - > >The beginning "c" stands for "copyright." That's standard MARC21 cataloguing. > >(This time we _did_ follow the rules!) It's not a Sypdus problem, it's a >MARC21 problem -- and therefore a Koha problem. > >Stephen > > >>http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=514 >> >>In the sample you sended me, I see : >> >>260 0 _a[Mankato, Minn.] : >> _bThe Child's World, >> _cc1993. >>So, the date in 260$c is : c1993. >>which is not a date isn't it :-) >>(note that it seems that EVERY date have a c at >>beginning and . at the end. >>Sometimes, it's even worst : >>260 0 _aSouth Yarmouth, MA : >> _bJohn Curley & Associates, >> _cc1926,1954. >>In samples here : >>http://www.loc.gov/marc/bibliographic/ecbdimpr.htm >>l#mrcb260 >>I read : >>260 ##$aNew York, N.Y. :$bElsevier,$c1984. >> >>260 ##$a[S.l.] :$bInsight Press,$c1981. >>The ending . is OK (and should be accepted by >>Koha. >>The beginning c is a spydus creation. >> >>I mark the bug invalid. >> >> -- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)

2 1

2.0 release meeting *CHANGE*
by Pat Eyler 07 Jul '03

07 Jul '03

Hello everyone, With a 2.0.0 release rapidly approaching, and a bunch of bugs needing to be found, reported, prioritized, and fixed, we're going to institute a weekly irc meeting to help handle the load. We'll meet every Wednesday at 1800 UTC in the #koha channel at irc.katipo.co.nz -- Anyone is welcome to attend, please bring your bug reports. We're making this change to help make the meeting more accessible to Paul (the 2.0 release manager), and our other European developers. I know this is very hard on the Katipans, if it proves to be too much of a hassle, we might try to alternate weeks or something. (Here are a couple of conversions follow) UTC France Seattle New Zealand Wed 18:00 Wed 20:00 Wed 11:00 Thu 06:00 (Please feel free to translate and/or forward this message to other mailing lists as appropriate.) -pate Pat Eyler Kaitiaki/manager migrant Linux sys admin the Koha project ruby, shell, and perl geek http://www.koha.org http://pate.eylerfamily.org

2 2