Nope. However, I can envision how you might go about it. I did a quick look on freshmeat.net and found this application: http://ola.sourceforge.net/ <http://ola.sourceforge.net/> which looks like it might suite your needs perfectly. No sense reinventing the wheel... When you say "open source" I'm taking a broad shot in the dark that you want to setup some sort of linux based web front end with a mysql or postgres backend? The first big issue your going to have to tackle is getting the data out of the existing database. I highly doubt that this proprietary software will let you do something like export your whole catalog to a comma delimited file. If it can, then you'd be all set. However, it probably should allow you to run a report of all the volumes you've got in your library. Either way, you'll need to get your data into some sort of normalized form that you could use to populate your new database. Hope this helps... Tim. -----Original Message----- From: brad [mailto:brad0002@ameritech.net] Sent: Saturday, May 29, 2004 1:03 AM To: wlug@mail.wlug.org Subject: [Wlug] any ideas? Our school uses commercial library automation software. We would like to convert the database to open source. Anyone have experience doing so? Thanks, Dbn0002@aol.com <mailto:Dbn0002@aol.com> Please send your reply to this email address.
My experience, exporting a commercial database can be tough.. Find out if your lucky enough to have a ODBC interface or something. or try and find where the database stores it's files and try to decipher :). Keller, Tim wrote:
Nope. However, I can envision how you might go about it.
I did a quick look on freshmeat.net and found this application: http://ola.sourceforge.net/ which looks like it might suite your needs perfectly. No sense reinventing the wheel...
When you say "open source" I'm taking a broad shot in the dark that you want to setup some sort of linux based web front end with a mysql or postgres backend?
The first big issue your going to have to tackle is getting the data out of the existing database. I highly doubt that this proprietary software will let you do something like export your whole catalog to a comma delimited file. If it can, then you'd be all set. However, it probably should allow you to run a report of all the volumes you've got in your library. Either way, you'll need to get your data into some sort of normalized form that you could use to populate your new database.
Hope this helps...
Tim.
-----Original Message----- *From:* brad [mailto:brad0002@ameritech.net] *Sent:* Saturday, May 29, 2004 1:03 AM *To:* wlug@mail.wlug.org *Subject:* [Wlug] any ideas?
Our school uses commercial library automation software. We would like to convert the database to open source. Anyone have experience doing so? Thanks, Dbn0002@aol.com <mailto:Dbn0002@aol.com> Please send your reply to this email address.
------------------------------------------------------------------------
_______________________________________________ Wlug mailing list Wlug@mail.wlug.org http://mail.wlug.org/mailman/listinfo/wlug
-- -- Karl Hiramoto karl at hiramoto dot org http://karl.hiramoto.org/ Mobile: 508.517.4819 Work: 978-425-2090
On Wed, Jun 02, 2004 at 04:00:05PM -0400, Keller, Tim wrote:
The first big issue your going to have to tackle is getting the data out of the existing database. I highly doubt that this proprietary software will let you do something like export your whole catalog to a comma delimited file. If it can, then you'd be all set. However, it probably should allow you to run a report of all the volumes you've got in your library. Either way, you'll need to get your data into some sort of normalized form that you could use to populate your new database.
Luckily, libraries tend to have their own standard data formats, like MARC: http://www.loc.gov/marc/
participants (3)
-
Charles R. Anderson -
Karl Hiramoto -
Keller, Tim