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

From Richard Managh
DateTue, 30 Oct 2007 15:23:23 +1300
Subject Re: [greenstone-users] (no subject) [Adding a database to greenstone]
In-Reply-To (626323-56881-qm-web62407-mail-re1-yahoo-com)
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