Sunday, January 16, 2011

Analog Update III

I finished importing Dave Baranyi's MS Excel data into MS Access.  Over 15,600 stories were imported from Analog, Galaxy, Worlds of If, Fantastic, and the Magazine of Fantasy and Science Fiction.  This was quite a bit of data entry work on the part of Dave Baranyi.

Please be aware that the data was imported from MS Excel into MS Access through a "dumb" program.  There is little in the way of error detection and correction.  I have fixed a few (very few) glaring errors, but there are many more. Besides the errors, there is quite a bit of missing data.  Specifically, the covers images.  There are over 2,000 cover images that would have to be added. With over 15,600 stories, it's going to be excruciatingly difficult to weed out the "bad" data.

If you are a regular longtime reader of Analog or another SF magazine and wish to have a copy please email your address. I will have to (snail) mail the database on a CD, assuming that there aren't too many requests. The database is just over 82 Megabytes in size. You will need MS Access and you will need to tell me what version of MS Access you have. Familiarity with Access would also be recommended, since the user interface is sparse with minimal user protection for making dumb mistakes.  If you find errors and missing data - I would be interested in fixing them. Please email me. If you send any corrections or additions, please provide a copy of the table of contents.

THE FUTURE: In theory, I will be working on making this database available through "Open Office" (using BASE) and "MySQL", so I do not intend to make further MS Access program updates. Still need to fix errors and add missing data though! So send in any corrections or missing data with photocopies of the table of contents.

Progress on developing a LINUX version has been much much slower than anticipated.  At least having an MS Access version permits data maintenance and allows others to use the database in the interim.

A SIDE NOTE: The Internet Speculative Fiction Database has a more in-depth database of information.  To a degree what I am doing is duplicative. Hopefully there is sufficient differentiation to justify this project.  Any thoughts?

SAMPLE IMAGES:  Below is the image of the main screen. (Click on the image for a better view.)

Below is the image when you select a specific magazine, such as Analog.

Below are two additional images. Double clicking on an authors name will show all stories written by the author; no matter the magazine. In this case, the stories of Harry Turtledove for both Analog and the Magazine of Fantasy and Science Fiction.

You can also do an author or story search. In this case the string "Chandler" was used as an author search term. Again, it will display results for all magazines.

No comments: