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

Re: Reports engine
by robweir＠alum.drexel.edu 11 Jul '03

11 Jul '03

Hi Pierre, You might want to take a look at another open source project - http://reportman.sourceforge.net/. I've used it successfully for generating reports against Koha's MySQL database. It even does barcodes. I think the above project is similar to Crystal Reports or ReportSmith that Trevor mentions. I run it as a totally separate program from Koha, connect to the Koha database and generate my report. I'm not sure what rssKoha is. If what you are suggesting would integrate into Koha, I think that would be a better approach. Rob

1 0

Thanks for help everyone!
by Allyson Bright 11 Jul '03

11 Jul '03

I was running 1.2.3, and it didn't work. I upgraded today to 2.0.0.pre2, and this problem (along with a few others, to my great joy), is solved! Thanks for your help! -Allyson -----Original Message----- From: robweir(a)alum.drexel.edu [mailto:robweir@alum.drexel.edu] Sent: Thursday, July 10, 2003 6:11 PM To: koha-win32(a)lists.sourceforge.net; Allyson Bright Subject: Re: [Koha-win32] koha help request please! Hi Allyson, Which version of Koha? I just tried it in the latest test release (V2.0.0pre2) and was able to switch to a US date format by changing dateformat from "metric" to "us" (lower case) under system preferences. When I try the same thing in V1.2.3, it does not appear to work. I'll wait to hear which version you are testing before going further. Rob ----- Original Message ----- From: Allyson Bright To: 'koha-devel(a)lists.sourceforge.net' <mailto:'koha-devel(a)lists.sourceforge.net'> ; 'koha-win32(a)lists.sourceforge.net' <mailto:'koha-win32(a)lists.sourceforge.net'> Sent: Thursday, July 10, 2003 4:55 PM Subject: [Koha-win32] koha help request please! 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

more info....RE: koha help request please!
by Allyson Bright 10 Jul '03

10 Jul '03

Hi again- I am not sure if my subscription processed correctly or not, because I didn't receive a copy back of my e-mail requesting help, or any other emails from the list. If you could reply to me directly at allyson(a)unitedwayjc.org <mailto:allyson@unitedwayjc.org> , that would help greatly. Thanks! -Allyson -----Original Message----- From: Allyson Bright Sent: Thursday, July 10, 2003 4:55 PM To: 'koha-devel(a)lists.sourceforge.net'; 'koha-win32(a)lists.sourceforge.net' Subject: koha help request please! 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

2 1

[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 07 Jul '03

07 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