[greenstone-users] Simple database

From Stephen DeGabrielle
DateTue, 28 Jun 2005 16:08:25 +0930
Subject [greenstone-users] Simple database
Hi,

This may seem like a dumb question but how do I import a simple table of records?

- I foolishly tried ExcelPlug - not realising that that wold make two very nice html pages (Duh!)

My example consists of four columns; 'Title' , 'Source' , 'Date Journal Info' , 'Subject'

I have it as a (pair) of Excel tables (just because I have 90k records and Excel maxes out at 64k rows)

Any Ideas?

Stephen De Gabrielle

---


Example data 

a singel record; (4 fields)
"$15000 History award"    NT NEWS    29(152): 6 AUG 1980; 2    NORTHERN TERRITORY HISTORY AWARDS
Note that the  "29(152): 6 AUG 1980; 2"  is the Date Journal Info field.

the first few (note that this is sorted - not all titles are quoted - but many do start with a non-alpha character

----
Title    Source    Date Journal Info    Subject
"$15000 History award"    NT NEWS    29(152): 6 AUG 1980; 2    NORTHERN TERRITORY HISTORY AWARDS
"$l000 better off' on first homes    NT NEWS    30(169): 27 AUG 1981; 3    HOUSING
"A great concern" Chief    NT NEWS    28(9): 20 FEB 1979; 9    YOUTH EMPLOYMENT
"All up" Air Mail: Darwin agitation    NORTHERN STANDARD    (3): 10 JAN 1939; 6D    WESTON, J.
"All up" Air Mail: Darwin agitation    NORTHERN STANDARD    (3): 10 JAN 1939; 6D    AIR MAIL SERVICE
"Allocate more to road funds"'    NT NEWS    38(152): 3 AUG 1989; 2    FEDERAL AID TO TRANSPORTATION
"ALP Leadership Rift"    NT NEWS    29(153): 7 AUG 1980; 1    AUSTRALIAN LABOR PARTY NORTHERN TERRITORY BRANCH
"ALP Leadership Rift"    NT NEWS    29(153): 7 AUG 1980; 1    AUSTRALIAN LABOR PARTY NORTHERN TERRITORY BRANCH
"Bonanza future" for Northern Territory    NT NEWS    29(151); 5 AUG 1980; 3    NORTHERN TERRITORY DEVELOPMENT CORPORATION
"Bonson Bites Back" by Jane Sullivan. V Bonson wins 1980 title    NT NEWS    29(149): 1 AUG 1980; 2    BAREFOOT MUDCRAB TYING CHAMPIONSHIP
"Brainwashing charge"    NT NEWS    28(21): 8 MAR 1979; 8    NORTHERN LAND COUNCIL
"Calling all artists"    NT NEWS    7 AUG 1980; 2    CALTEX ART AWARDS
"Cheap stunt" over trees - Bob Tormey    NT NEWS    29(47): 2 APR 1980; 2    KEEP AUSTRALIA BEAUTIFUL COUNCIL
"College fears domination" - Fred McCue "Empire building by        bureaucrats"    NT NEWS    29(150): 2 AUG 1980; 2    DARWIN COMMUNITY COLLEGE
"Crash car 'turned in air'"    NT NEWS    29(153): 7 AUG 1980; 2    KETONEN, SEPPO
"Crowd copped it again"    NT NEWS    29(151): 5 AUG 1980; 7    FANNIE BAY RACECOURSE
"Dalgety's duck has retired"    NT NEWS    29(154): 8 AUG 1980; 7    LILLERCRAPP, DOUG
"Darwin lagging in Airways growth"    NT NEWS    29(150): 2 AUG 1980; 3    AIR TRANSPORT
"Darwin's history on show"    NT NEWS    29(153): 7 AUG 1980; 10    NATIONAL TRUST OF AUSTRALIA NORTHERN TERRITORY DIVISION
"Do away with water meters"    NT NEWS    29(149): 1 AUG 1980; 1    WATER
"Do away with water meters"    NT NEWS    29(149): 1 AUG 1980; 1    BROWN, GEORGE