Re: [greenstone-users] (no subject) [Adding a database to greenstone]

From Debjani Saha
DateWed, 31 Oct 2007 23:06:26 -0700 (PDT)
Subject Re: [greenstone-users] (no subject) [Adding a database to greenstone]
In-Reply-To (4726959B-7030101-dlconsulting-com)
Dear Richard Managh,
Thanking you for your reply. I have seen FAO on the Internet  (1998) Greenstone collection where Phrases browser use AGROVOC thesaurus (attached). I want to do that for my greenstone collection with my thesaurus. Kindly let me know how to do this.

Richard Managh <> wrote:
Hi Debjani,

Debjani Saha wrote:
Dear Richard Managh,
Thanking you for your reply and help. My agrovoc database format is in mysql format. Mainly I would like to use it with Phind phrase browsing for searching. I had installed WAMP (Windows - Apache - MySQL- PHP5) in my c drive and  constructed the thesaurus taking agrovac from FAO. I have opened <GSDLHOME>/etc/packages/example.dbi. But I am not clear what next I have to do. Kindly help me.

From looking at the example.dbi it appears that you need to first full out the example.dbi file for your database, and to install the appropriate back end for mysql, so that perl can talk to your mysql database. These are perl packages you need to add to your perl installation. As part of filling out the example.dbi, you also need to decide what will become a record in your greenstone database, and create an sql query that will get your rows out of the database. These rows will then appear as documents in your collection. I have not needed to use DBPlug before, so am not familiar with exactly how it works. The plugin if configured to be included in your greenstone collection appears to  read a *.dbi file (created by you and put in your import directory for the collection) and based on that reads your mysql database and imports your database. I am not sure whether it would be easy to preserve the relationships inherant to relational databases in the built greenstone collection importing the data in this way.

I am not sure exactly what you are trying to achieve, but if you are creating a thesauraus to use with search queries in greenstone, I would probably add it as a semi external application, in its own browser window, perhaps a php application that navigated your mysql database. This little web application would be coupled to Greenstone in such a way that when you clicked something like "add keyword" in the separate window, your keyword would be added to greenstone's search box, using javascript.



--   DL Consulting  Greenstone Digital Library and Digitisation Specialists
greenstone-users mailing list

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around

Type: application/msword
Filename: attach.doc