 |
 |
There are tools that let you use Filemaker as a sort of front end to MySQL http://www.filemaker.com/support/technologies/mysql.html You could export the MS Accses into csv then import into Filemaker. Edward Iglesias On Tue, Jun 26, 2012 at 5:03 PM, Paul Butler (pbutler3) <[log in to unmask]>wrote: > Hi All, > In the last week the library has been approached by two different > departments across campus that have small databases, one FileMaker Pro and > one MS Access, that they would like to make available online. The > interfaces would be nothing fancy, with a backend that allows for > adding/updating/deleting resources. > > I've had a chance to look at the FileMaker Pro data. Not the worst I have > seen, it needs normalized, but the data itself is fairly uniform and would > map easily enough to Dublin Core. So far just text, though they say > perhaps, someday, they might want images. I have yet to see the MS Access > data. > > I've worked on various personal/school projects using SQL, PHP, HTML, CSS, > and various repositories/CMS. For personal use and fun I've thrown > together a few LAMPs using VMWare, but nothing production. > > I would prefer not to build too much from scratch. I don't think I > want/need a full blown repository for either (though I help admin ours and > it is due for a complete hardware/software overhaul later this summer< > http://archive.umw.edu/>. I am thinking of transitioning it to more of an > IR with disparate content.) > > So, what would you do or have you done? I want something nimble. I would > love to build it once and then duplicate it. I get the sense once I start > helping folks other departments will come forward. > > I am thinking of tossing together a virtualized LAMP, secure it, build the > bones of a site, and then clone the thing and put the data for each project > in its own copy onto a webserver. > > Is there a better/easier way? Am I doomed to a life of pain and suffering > (besides that due to being a librarian)? Have a LAMP distro with a CMS to > suggest? Any suggestions are welcomed. > > Cheers, Paul > +-+-+-+-+-+-+-+-+-+-+-+-+ > Paul R Butler > Assistant Systems Librarian > Simpson Library > University of Mary Washington > 1801 College Avenue > Fredericksburg, VA 22401 > 540.654.1756 > libraries.umw.edu > > Sent from the mighty Dell Vostro 230. >