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.

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

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

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');