Sunday, December 26, 2010

Analog Update II

I've taken a breather from trying to develop an Analog database in "Open Office", made a quick (well really not so quick) MS Access version of the database.  Prior posts on my slow progress here.  Still faced with a steep learning curve for Open Office's database "Base".  Haven't even gotten to MySQL or PHP yet.  The MS Access version has been updated through the March 2011 edition, except for the March 20011 cover art.

If you have MS Access, I can provide a copy of the database.  Leave a message on the Analog readers forum. You would need to specify what version of MS Access that you have. The data was imported from an Excel spreadsheet developed by Dave Baranyi through the use of a dumb program. That means no error detection or correction. Obviously there will be data correction issues.  If you find any errors let me know. (I tend to have a lot of typos.)

Additionally, there are over 900 issues of Analog.  Consequently a lot of data is "missing", such as cover art, editorials, and the alternate view simply because the data has not yet been entered.  Gets boring entering data.  There is also the issue of the availability of old issues to verify the data.  Overtime, this data can be slowly added to the database.

Below is the opening screen. To the right there are a set of buttons that allow you provide a variety of search and editing tasks. (Click on the images to see them better.)

When you double click on an author, all stories written by that author Pop-Up.  In this case Richard Lovett.  The thirteenth name down.

You can also search for a story or an author based on a partial string. In the picture below, all stories that have the string "solar" in their title are displayed.

One thing to realize, is that much of the information is already available on the Internet, so pursuing a standalone database, as I am doing, is somewhat duplicative. Below is an image from the Internet Speculative Fiction Database.

If someone has the ability to provide a central download site that would be beneficial.  Then everyone would have access to the most recent version. In theory, I won't be pursing upgrading the database in MS Access except for adding new data. Learning Base has been frustratingly slow. Also I have not even gotten to MySQL yet.  At least the MS Access version will serve as a temporary solution.  In the meantime I hope that you will be able to enjoy and utilize the MS Access version.

No comments: