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

Other suggestions to clean DB...
by paul POULAIN 05 Mar '02

05 Mar '02

3 3

admin scripts I've just uploaded on CVS
by paul POULAIN 05 Mar '02

05 Mar '02

Don't use those scripts before I've released the DB patch. Because of index problem, they will not work properly. -- Paul

1 0

CVS: koha-html/intranet-html/admin index.html,NONE,1.1
by Paul POULAIN 05 Mar '02

05 Mar '02

Update of /cvsroot/koha/koha-html/intranet-html/admin In directory usw-pr-cvs1:/tmp/cvs-serv19927/admin Added Files: index.html Log Message: index to manage admin scripts --- NEW FILE --- <html>  <meta http-equiv=Content-Type content="text/thml; charset=iso-8859-1"> <title>WELCOME TO THE KOHA ADMIN PAGE</title> <body BGCOLOR="#99cc33" text="black" alink="#663366" leftmargin=0 topmargin=0 marginheight=0 marginwidth=0 > <center> <FONT SIZE=6><em>Koha admin page</em></FONT><br><br><br> <table> <th bgcolor='#FFFFFF'>Table</th><th bgcolor='#FFFFFF'>Meaning</th> <tr><td><li><a href=/cgi-bin/koha/admin/branches.pl>libraries branches</a></li></td><td>the differents branches you manage with this koha server</td></tr> <tr><td><li><a href=/cgi-bin/koha/admin/aqbudget.pl>budget</a></li></td><td>the budgets allowed to differents book funds.</td></tr> <tr><td><li><a href=/cgi-bin/koha/admin/aqbookfund.pl>book funds</a></li></td><td>the differents book funds.</td></tr> <tr><td><li><a href=/cgi-bin/koha/admin/categorie.pl>categories</a></li></td><td>the differents types of borrowers.</td></tr> <tr><td><li><a href=/cgi-bin/koha/admin/itemtypes.pl>Item types</a></li></td><td>the supports of an item.</td></tr> <tr><td><li><a href=/cgi-bin/koha/admin/currency.pl>Currencies</a></li></td><td>Currencies of booksellers.</td></tr> <tr><td><li><a href=/cgi-bin/koha/admin/printers.pl>Printers</a></li></td><td>Printers (UNIX paths).</td></tr> <tr><td><li><a href=/cgi-bin/koha/admin/stopwords.pl>stopwords</a></li></td><td>Words deleted during searches</td></tr> <tr><td><li><a href=/cgi-bin/koha/admin/systempreferences.pl>systempreferences</a></li></td><td>System preferences</td></tr> <tr><td><li><a href=/cgi-bin/koha/admin/aqbooksellers.pl>aqbooksellers</a></li></td><td>Book sellers</td></tr> </table> </center> </body> </html>

1 0

CVS: koha-html/intranet-html/admin - New directory
by Paul POULAIN 05 Mar '02

05 Mar '02

Update of /cvsroot/koha/koha-html/intranet-html/admin In directory usw-pr-cvs1:/tmp/cvs-serv19523/admin Log Message: Directory /cvsroot/koha/koha-html/intranet-html/admin added to the repository

1 0

me again : cvs problem...
by paul POULAIN 05 Mar '02

05 Mar '02

I try to upload on cvs my work, and I have the following problem : export is OK cvs -z3 -d:ext:tipaul@cvs.koha.sourceforge.net:/cvsroot/koha co koha seems OK (check and upload the koha directory) Then I try to add an "admin" directory in which are all my script. So I try : cvs add admin or cvs add koha/admin both answers "add" requires write access to the repository. What am i doing wrong ? Note : I'm a newbie at CVS, but have the o'reilly book ;-)) -- Paul

2 1

Also...
by Nicholas Rosasco 04 Mar '02

04 Mar '02

Idly, besides MARC features, do we want to do a feature-request list, while you all are in the process of polishing and intergrating the MARC and other items? I see the traffic on the various DB reorg/changes and am curious to know what else is on various wish lists. Since the faq is basically done, I can handle tracking that... Nick

3 7

about budgets (aqbudget/aqbookfund and aqorderbreakdown tables)
by paul POULAIN 02 Mar '02

02 Mar '02

aqbudget is connected to aqbookfund to exprim how much budget we can spend every year. In aqbudget there is a startdate/enddate, so I think this table is supposed to contain a record for every book fund and every year. But in the sample table there is only one year datas. More important, aqorderbreakdown describes books bought. this table points only to aqbookfundid, so I conclude I have no way to find which year this order mus be related to. So I conclude multi-year budgets are not managed by koha. Am I right ? If yes, so we could merge aqbudget and aqbookfund, or at least, in my admin tool, i could merge them on screens. Note : This afternoon is the most important rugby match of the year for europe : France-England. I try to work while looking at this match, but i'm not sure I will be very productive ;-)))) -- Paul

2 1

what are biblio, biblioitems and items tables
by paul POULAIN 01 Mar '02

01 Mar '02

I can't understand what means the 3 tables biblio biblioitems and items. A biblio contains the datas for a book we can have, or not have in our library. It contains the fact that such a document EXISTS. An item is a data to explain that we POSSESS a biblio, where, since when, at which costs... But what's the hell is a biblioitem ? Where is it used ? How could be a definition constraint with biblio/item be writen if mySQL supported them ? Thank's -- Paul

2 3

whops... (reverse engeneering again)
by paul POULAIN 01 Mar '02

01 Mar '02

forget to add the doc... here it is Note it's done with openOffice.org and saved as html -- Paul

2 1

reverse engeneering on DB...
by paul POULAIN 01 Mar '02

01 Mar '02

I try to understand very well how the 1.1 version of koha works (the exact structure of the DB). I wrote a few words for every table. I will enhance the doc in the future, as I understand better everything. By the way, a few tables remains un-understandable to me, so if someone could lighten me ;-) Last word : many tables seems useless, so if you confirm they are, I could add a "drop table" to my SQL patch. Bye -- Paul

1 0