Re: [greenstone-users] Creating DL from existing MS Access Database - Newbie questions

From John R. McPherson
DateFri, 11 Aug 2006 07:46:21 +1200
Subject Re: [greenstone-users] Creating DL from existing MS Access Database - Newbie questions
In-Reply-To (006501c6bcab$86ec4b20$5c016c0a-hq-prl-ab-ca)
On Thu, Aug 10, 2006 at 12:33:51PM -0600, Michael Silver wrote:
> Hello,
> This is a very newbie-esque cry for help. Any pointers or explanations are
> welcome and appreciated.

> What I have is a collection of records in a relational database. The
> database is natively stored in Paradox format in a fairly old and less than
> wonderful application custom developed for the library. I usually produce a
> catalogue by importing those records into MS Access, and then using Access
> to format and print.
> What I want is for each record in the database to become a unique record in
> Greenstone. The metadata is all in the database, but I'm not sure what the
> best way to get it into GSDL is going to be.

greenstone has a "DBPlug" import plugin, for slurping records wholesale
from a RDBMS. This uses perl's "DBI" (database-independent interface)
modules, which has backends for a wide variety of database systems such
as mysql, postgres, ms-sql, and generic ODBC, as well as non-RDBMS sources
such as CSV, excel files, and ldap.

You may be able to use this - either via an ODBC connector, or by exporting
your access data into CSV format and then using DBI's csv backend.
However, greenstone's DB import plugin has really only been developed
and tested on Linux, although I've had a report of at least one persons
uccessfully using it on windows without major modifications
If you go this route, you may need to spend a bit of time fiddling
around to make it work (although we'd be prepared to help, and would
like to make the code more robust for other people to use).

Hope this helps
John McPherson