I think what needs to be done, and have mentioned this before is an instal or set up script. I am awaiting these things to be done before I even attempt to implement this system. We also need to be sure that marc 21 is going in as well as out. keep up the good work folks! ed sharpe archivist for smecc
Subj:Re: [Koha] gripe Date:3/17/2002 8:49:45 PM US Mountain Standard Time From:<A HREF="mailto:chris@katipo.co.nz">chris@katipo.co.nz</A> To:<A HREF="mailto:lawgon@thenilgiris.com">lawgon@thenilgiris.com</A> CC:<A HREF="mailto:koha@lists.katipo.co.nz">koha@lists.katipo.co.nz</A> Sent from the Internet
hi all i have a major gripe: koha doesnt run out of the box. ok. it is open
On Mon, 2002-03-18 at 15:34, Kenneth Gonsalves wrote: source.
but atleast you could add something in your INSTALL file to tell us that certain tables have to be manually filled in to start. i downloaded the archive for this list and spent two days distilling it. found that certain hardworking people actually found out - on their own - that some things had to be done manually to start up. agreed that you have done great work. do you think that it will take that long to add a little thingie to the end of your INSTALL file to tell us what we have to do manually to get the system up and running.
Fair call, this is something we do need to tidy up.
one more gripe: you ask us to download from sourceforge. and then say 'ouch, those files are pretty old - try this link'. i personally think that you are doing opensource a disfavour. i'm from india. downloading is slow and expensive. please put your latest stuff where the
search engines point
The release on sourceforge is the latest release we have. There is no newer release. What I was pointing you at was the cvs archives, where you can check out the files that will be the 1.2.0 release. But there is no newer tarball, apart from the nightly cvs tarball that sourceforge makes automatically. Which isnt a release.
Sorry If there was a misunderstanding.
Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
all that is needed is a list of tables to be manually populated and a list of data to be put in. if we have this much, using webmin or phpadmin or even the command line, we can fill in the tables and get going. the install script can wait. pl do the needful kg On Monday 18 March 2002 10:09, COURYHOUSE@aol.com wrote:
I think what needs to be done, and have mentioned this before is an instal or set up script.
I am awaiting these things to be done before I even attempt to implement this system. We also need to be sure that marc 21 is going in as well as out. keep up the good work folks! ed sharpe archivist for smecc
On Tue, 2002-03-19 at 18:23, Kenneth Gonsalves wrote:
all that is needed is a list of tables to be manually populated and a list of data to be put in. if we have this much, using webmin or phpadmin or even the command line, we can fill in the tables and get going. the install script can wait. pl do the needful Off the top of my head. The itemtypes, categories and branches tables all need some data. Itemtypes so you can add items, categories for borrowers, and branches has the branch data. The data you need to enter will be specific to your library of course. These are all I can recall right now. When I get some free time ill endeavour to do an install from the tarball myself and test what tables need data. If you sent me your apache error logs that might help a lot.
There is a sample data file that you could look at to see what a sample database would look like. https://sourceforge.net/project/showfiles.php?group_id=16466&release_id=18105 It is pretty large tho. Chris
here is a list (taken fro the list archives) of tables to be manually administered: * aqbookfound * adbudget * branchcategories * branches * categories * currency * itemtypes * printers * stopwords * systempreferences * users what to put in them? kg On Tuesday 19 March 2002 12:11, you wrote:
On Tue, 2002-03-19 at 18:23, Kenneth Gonsalves wrote:
all that is needed is a list of tables to be manually populated and a list of data to be put in. if we have this much, using webmin or phpadmin or even the command line, we can fill in the tables and get going. the install script can wait. pl do the needful
Off the top of my head. The itemtypes, categories and branches tables all need some data. Itemtypes so you can add items, categories for borrowers, and branches has the branch data.
On Tue, 2002-03-19 at 19:54, Kenneth Gonsalves wrote:
here is a list (taken fro the list archives) of tables to be manually administered:
* aqbookfound * adbudget * branchcategories * branches * categories * currency * itemtypes * printers * stopwords * systempreferences * users what to put in them? kg All of them apart from systempreferences are going to be specific to your library.
Ill email you some sample data from each table off the list, which might help. Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
better than mailing the sample data off list, you could post it somewhere and give the link on list - this would put finis to this problem for all new users regards kg On Tuesday 19 March 2002 13:16, you wrote:
On Tue, 2002-03-19 at 19:54, Kenneth Gonsalves wrote:
here is a list (taken fro the list archives) of tables to be manually administered:
* aqbookfound * adbudget * branchcategories * branches * categories * currency * itemtypes * printers * stopwords * systempreferences * users what to put in them? kg
All of them apart from systempreferences are going to be specific to your library.
Ill email you some sample data from each table off the list, which might help.
Chris
On Tue, 2002-03-19 at 20:14, Kenneth Gonsalves wrote:
better than mailing the sample data off list, you could post it somewhere and give the link on list - this would put finis to this problem for all new users
Its all in the sample data file available at the sourceforge site https://sourceforge.net/project/showfiles.php?group_id=16466&release_id=18105 Which I assumed you hadnt wanted to download. Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
Chris et. al - I have been following this thread with interest - you may recall I'm the mug trying to port Koha over to NT. My 2c worth - I did download the sample-data and found it too large and unwieldy to be of any practical use. If anyone can contribue a smaller sample-data set from a *working* system, I for one would find that of great assistance. I also have really struggled to get the system working at all with the minimalist installation instructions. I found the duality of the scripts and c4 directories particularly difficult to understand and implement successfully on NT. I should emphasise that I'm only doing a platform port - I am leaving the database in MySql and the Code in Perl, having simply availed myself of the excellent Win32 engines available for both... Any assistance from anyone on the list who can provide better step-by-step installation instructions (including entries required in tables) would be very helpful. Thanks. Best Regards Andrew Hooper -----Original Message----- From: koha-admin@lists.katipo.co.nz [mailto:koha-admin@lists.katipo.co.nz] On Behalf Of Chris Cormack Sent: Tuesday, 19 March 2002 8:44 p.m. To: Kenneth Gonsalves Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] gripe On Tue, 2002-03-19 at 20:14, Kenneth Gonsalves wrote:
better than mailing the sample data off list, you could post it somewhere and give the link on list - this would put finis to this problem for all new users
Its all in the sample data file available at the sourceforge site https://sourceforge.net/project/showfiles.php?group_id=16466&release_id= 18105 Which I assumed you hadnt wanted to download. Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz _______________________________________________ Koha mailing list Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
On Tue, 2002-03-19 at 21:39, Andrew Hooper wrote:
Chris et. al - I have been following this thread with interest - you may recall I'm the mug trying to port Koha over to NT.
My 2c worth - I did download the sample-data and found it too large and unwieldy to be of any practical use. If anyone can contribue a smaller sample-data set from a *working* system, I for one would find that of great assistance.
Hi Andrew, I guess I can go threw the sample data and drop out all the tables that arent needed to be added manually. And make a smaller version for that purpose. I'll have a go at that in the weekend. Hopefully someone else might beat me to it.
I also have really struggled to get the system working at all with the minimalist installation instructions. I found the duality of the scripts and c4 directories particularly difficult to understand and implement successfully on NT. I should emphasise that I'm only doing a platform port - I am leaving the database in MySql and the Code in Perl, having simply availed myself of the excellent Win32 engines available for both...
Any assistance from anyone on the list who can provide better step-by-step installation instructions (including entries required in tables) would be very helpful. Thanks.
Sebastiaan Durand sebastiaan@famdurand.nu had gotten the system up and runing under Win2k and WinXP with lotus domino as the webserver. So perhaps he can help you out. Hope this is some help Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
INSERT INTO aqbookfund VALUES( '5', 'Young Adult Fiction', '3'); INSERT INTO aqbookfund VALUES( '4', 'Fiction', '2'); INSERT INTO aqbookfund VALUES( '2', 'Talking books', '4'); INSERT INTO aqbookfund VALUES( '13', 'Newspapers & journals', '4'); INSERT INTO aqbookfund VALUES( '10', 'Te Ao Maori', '1'); INSERT INTO aqbookfund VALUES( '15', 'CDs, CD Roms, Maps, etc', '4'); INSERT INTO aqbookfund VALUES( '9', 'Junior Fiction', '3'); INSERT INTO aqbookfund VALUES( '7', 'Junior Non-Fiction', '3'); INSERT INTO aqbookfund VALUES( '72', 'Creative NZ', '4'); INSERT INTO aqbookfund VALUES( '11', 'Reference', '1'); INSERT INTO aqbookfund VALUES( '12', 'Videos', '4'); INSERT INTO aqbookfund VALUES( '8', 'Junior Paperback', '3'); INSERT INTO aqbookfund VALUES( '73', 'Large Print Link-up', '2'); INSERT INTO aqbookfund VALUES( '3', 'Large Print', '2'); INSERT INTO aqbookfund VALUES( '71', 'Creative NZ NonFiction', '1'); INSERT INTO aqbookfund VALUES( '6', 'Picture Books', '3'); INSERT INTO aqbookfund VALUES( '14', 'Nga pukapuka Maori', '3'); INSERT INTO aqbookfund VALUES( '80', 'Donations, junior books', '5'); INSERT INTO aqbookfund VALUES( '81', 'Donations, adult books', '5'); INSERT INTO aqbookfund VALUES( '82', 'Donations, magazines', '5'); INSERT INTO aqbookfund VALUES( '83', 'Donations, non books', '5'); INSERT INTO aqbookfund VALUES( '91', 'Vertical File', '5'); INSERT INTO aqbookfund VALUES( '100', 'Loans', '6'); INSERT INTO aqbookfund VALUES( '1', 'Test', '1'); INSERT INTO aqbudget VALUES( '1', '1999-07-01', '2000-06-30', '39000.00'); INSERT INTO aqbudget VALUES( '5', '1999-07-01', '2000-06-30', '3000.00'); INSERT INTO aqbudget VALUES( '4', '1999-07-01', '2000-06-30', '28000.00'); INSERT INTO aqbudget VALUES( '2', '1999-07-01', '2000-06-30', '2000.00'); INSERT INTO aqbudget VALUES( '13', '1999-07-01', '2000-06-30', '13000.00'); INSERT INTO aqbudget VALUES( '10', '1999-07-01', '2000-06-30', '7000.00'); INSERT INTO aqbudget VALUES( '15', '1999-07-01', '2000-06-30', '4000.00'); INSERT INTO aqbudget VALUES( '9', '1999-07-01', '2000-06-30', '1000.00'); INSERT INTO aqbudget VALUES( '7', '1999-07-01', '2000-06-30', '12000.00'); INSERT INTO aqbudget VALUES( '72', '1999-07-01', '2000-06-30', '1000.00'); INSERT INTO aqbudget VALUES( '11', '1999-07-01', '2000-06-30', '9000.00'); INSERT INTO aqbudget VALUES( '12', '1999-07-01', '2000-06-30', '7000.00'); INSERT INTO aqbudget VALUES( '8', '1999-07-01', '2000-06-30', '4300.00'); INSERT INTO aqbudget VALUES( '73', '1999-07-01', '2000-06-30', '20000.00'); INSERT INTO aqbudget VALUES( '3', '1999-07-01', '2000-06-30', '10000.00'); INSERT INTO aqbudget VALUES( '71', '1999-07-01', '2000-06-30', '2000.00'); INSERT INTO aqbudget VALUES( '6', '1999-07-01', '2000-06-30', '10000.00'); INSERT INTO aqbudget VALUES( '14', '1999-07-01', '2000-06-30', '700.00'); INSERT INTO aqbudget VALUES( '80', '1999-07-01', '2000-06-30', '0.00'); INSERT INTO aqbudget VALUES( '81', '1999-07-01', '2000-06-30', '0.00'); INSERT INTO aqbudget VALUES( '82', '1999-07-01', '2000-06-30', '0.00'); INSERT INTO aqbudget VALUES( '83', '1999-07-01', '2000-06-30', '0.00'); INSERT INTO aqbudget VALUES( '91', '1999-07-01', '2000-06-30', '0.00'); INSERT INTO aqbudget VALUES( '100', '1999-07-01', '2000-06-30', '0.00'); INSERT INTO branches VALUES( 'C', 'Levin', '', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'F', 'Foxton', '', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'FM', 'Foxton Mending', '', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'FP', 'Foxton Permanent Colln.', '', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'I', 'Interloan', '', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'M', 'Mending', '', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'P', 'Processing', '', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'S', 'Shannon', '', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'SP', 'Shannon Permanent Colln.', '', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'T', 'Tokomaru', '', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'TR', 'Transit', '', NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO branches VALUES( 'D', 'District', NULL, NULL, NULL, NULL, NULL, NULL, NULL); INSERT INTO categories VALUES( 'I', 'Institution', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '0.000000'); INSERT INTO categories VALUES( 'W', 'Workers', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '0.000000'); INSERT INTO categories VALUES( 'A', 'Adult', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '1.000000'); INSERT INTO categories VALUES( 'B', 'Housebound', '5', '99', '0', 'E', '0', '0.000000', '0', '99', '0.000000'); INSERT INTO categories VALUES( 'E', 'Senior Citizen', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '1.000000'); INSERT INTO categories VALUES( 'F', 'Family', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '1.000000'); INSERT INTO categories VALUES( 'C', 'Child', '5', '16', '0', 'A', '0', '0.000000', '0', '99', '0.000000'); INSERT INTO categories VALUES( 'P', 'Privileged', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '0.000000'); INSERT INTO categories VALUES( 'L', 'Library', '5', '99', '0', 'A', '0', '0.000000', '0', '99', '0.000000'); INSERT INTO currency VALUES( 'NZD', '1.00000'); INSERT INTO currency VALUES( 'AUD', '0.60000'); INSERT INTO currency VALUES( 'USD', '0.49000'); INSERT INTO itemtypes VALUES( 'ART', 'Art Prints', '42', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'BCD', 'CD-ROM from book', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'CAS', 'Cassette', '14', '0', '1.0000'); INSERT INTO itemtypes VALUES( 'CD', 'Compact disc (WN)', '14', '1', '2.0000'); INSERT INTO itemtypes VALUES( 'F', 'Free Fiction', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'FJV', 'Junior free video', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'FVID', 'Adult free video', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'FYA', 'Young Adult Fiction', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'GWB', 'Get Well Bags', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'HCVF', 'Horowhenua Collection Vertical File', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'IL', 'Interloan', '22', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'JCF', 'Junior Castle Fiction', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'JCNF', 'Junior Castle Non-fictio', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'JF', 'Junior Fiction', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'JHC', 'Junior Horowhenua Collection VF', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'JIG', 'Jigsaw puzzle', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'JK', 'Junior Kermit ', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'JNF', 'Junior Non-Fiction', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'JPB', 'Junior Paperbacks', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'JPC', 'Junior Picture Book', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'JPER', 'Junior Periodical', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'JREF', 'Junior Reference', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'JVF', 'Junior Vertical File', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'JVID', 'Junior rental video', '7', '1', '3.0000'); INSERT INTO itemtypes VALUES( 'LP', 'Large Print', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'MAP', 'Maps', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'NF', 'Adult Non-fiction', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'NFLP', 'NonFiction LargePrint', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'NFYA', 'Young Adult Non Fiction', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'NGA', 'Nga Pukapuka', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'PAY', 'Pay Collection', '14', '1', '1.0000'); INSERT INTO itemtypes VALUES( 'PB', 'Pamphlet Box', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'PER', 'Periodicals Stand', '14', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'PHOT', 'Photograph', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'POS', 'Junior Posters', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'REF', 'Adult Reference Books', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'ROM', 'CD-Rom', '7', '1', '5.0000'); INSERT INTO itemtypes VALUES( 'STF', 'Stack Fiction', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'STJ', 'Stack Junior', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'STLP', 'Stack Large Print', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'STNF', 'Stack Non-fiction', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'TB', 'Talking Books', '14', '1', '2.0000'); INSERT INTO itemtypes VALUES( 'TREF', 'Taonga', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'VF', 'Vertical File', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'VID', 'Adult rental video', '7', '1', '3.0000'); INSERT INTO itemtypes VALUES( 'FTB', 'Free Talking Books', '21', '1', '0.0000'); INSERT INTO itemtypes VALUES( 'NLTB', 'National Library Talking Books', '21', '1', '2.0000'); INSERT INTO printers VALUES( 'Shannon Issues', 'shanlp', 'docket'); INSERT INTO printers VALUES( 'Levin Issues', 'leviss', 'docket'); INSERT INTO printers VALUES( 'Levin Returns', 'levret', 'docket'); INSERT INTO printers VALUES( 'Foxton Issue', 'foxlp', 'docket'); INSERT INTO printers VALUES( 'No Printer', 'nulllp', ''); INSERT INTO printers VALUES( 'Laser Printer', 'lp', ''); INSERT INTO stopwords VALUES( 'A'); INSERT INTO stopwords VALUES( 'AND'); INSERT INTO stopwords VALUES( 'ASSOC'); INSERT INTO stopwords VALUES( 'ASSOCIATES'); INSERT INTO stopwords VALUES( 'CO'); INSERT INTO stopwords VALUES( 'COMPANY'); INSERT INTO stopwords VALUES( 'CORP'); INSERT INTO stopwords VALUES( 'CORPORATION'); INSERT INTO stopwords VALUES( 'INC'); INSERT INTO stopwords VALUES( 'INCORPORATED'); INSERT INTO stopwords VALUES( 'LTD'); INSERT INTO stopwords VALUES( 'OF'); INSERT INTO stopwords VALUES( 'THE'); INSERT INTO stopwords VALUES( 'THIS'); INSERT INTO users VALUES( 'C', 'Levin', 'engido', '1'); INSERT INTO users VALUES( 'S', 'Shannon', 'xeyangu', '1'); INSERT INTO users VALUES( 'F', 'Foxton', 'thoochi', '1'); INSERT INTO users VALUES( 'T', 'Tokomaru', 'kadiesee', '1');
Many thanks for the replies, and for your kind contribution Paul. I'll forge ahead with this now! Cheers -----Original Message----- From: paul POULAIN [mailto:paul.poulain@free.fr] Sent: Wednesday, 20 March 2002 3:43 a.m. To: Chris Cormack Cc: Andrew Hooper; koha@lists.katipo.co.nz Subject: Re: [Koha] gripe + NT struggles Chris Cormack wrote: On Tue, 2002-03-19 at 21:39, Andrew Hooper wrote: Chris et. al - I have been following this thread with interest - you may recall I'm the mug trying to port Koha over to NT. My 2c worth - I did download the sample-data and found it too large and unwieldy to be of any practical use. If anyone can contribue a smaller sample-data set from a *working* system, I for one would find that of great assistance. Hi Andrew, I guess I can go threw the sample data and drop out all the tables that arent needed to be added manually. And make a smaller version for that purpose. I'll have a go at that in the weekend. Hopefully someone else might beat me to it. I've beated you it seems :-))))) You will find the sample datas in attachment, and I've commited it in CVS too (updater directory) -- Paul
participants (5)
-
Andrew Hooper -
Chris Cormack -
COURYHOUSE@aol.com -
Kenneth Gonsalves -
paul POULAIN