Monday, August 3, 2015

The Multi-Year Science Fiction Magazine Database Extravaganza Endlessly Continues

I now have a rudimentary version of a Science Fiction Magazine Database that works through your (internet) browser. The benefit of this approach is that it works on your home computer and/or LAN, does not require specialized database software such as Base or MS Access, and (at some future point) will be internet ready. However, it does require that you have MySQL and Apache (LAMP/WAMP) operating on a computer. There is still much work to be done.

Opening Screen
The image above is the opening (main) screen.  From the opening screen one can do an author or story search. Additionally, one can display all magazine issues or filter by magazine.

Eventually, subsequent screens (as you can see below) will need to be redesigned to remove the Galaxy cover as it tends to be distracting in subsequent screens.

Note: The "Author" field contains a hyper-link. Clicking on it will display all stories written by that author.

Listing of Each Magazine Issue in the Database

My apologies to those reading other magazines. I have just been tracking Analog. The image below displays some of the F&SF magazines that have already been entered. Please be assured that this database can handle all magazines.

Note: The "Magazine Name" field contains a hyper-link. Clicking on it will display all stories for that particular issue.

Filtered Issue List

Selection of an Author

Display of all Stories Written by the Author Selected

Selection of a Magazine Issue

Display the Contents of the Selected Issue

Listing of All Stories Having "Pluto" in Their Title
Note: In the screen above there are hyper-links for both the author and magazine issue. Consequently, one can lookup either the author stories or the contents of the magazine issue.

This project still needs a lot of work. For example, I have not yet gotten around to developing editing screens. Turns out editing is much more complicated than simple data retrieval. Editing, when it is done, has been done through phpMyAdmin which works directly with MySQL.

Additionally, it seems that I will need to learn JavaScript for certain actions. Drat, yet another programming language to learn!!!

This project is essentially for my self edification. A more extensive and complete source of information is located at the Internet Speculative Fiction Database (ISFDB).

I anticipate that this browser based approach will be the final rendition in the development of this database. But then one should never say never. Eventually, I intend to complete it. But don't hold your breath.

Should you have any comments, please leave them.

Saturday, February 28, 2015

Backing-up MS Window Files to Linux on a Dual Boot Computer

Backing up files is one of those onerous tasks that has to be done if you want to preserve your data. Currently, I am running a computer using Linux (Ubuntu) with the capability to boot into MS Window 7.
I assume that many people will have a similar configuration and a need to preserve their MS Windows files. This narrative will review one approach for automatically accomplishing that task.

While most of my work is in Linux, I still have occasional need to boot into MS Windows and modify files that need to be saved. Yes, MS Windows has a backup program that can save your work. The problem, I have never gotten that backup program to function reliably. Next, my duration on MS Windows tends to be very short which circumvents the automatic scheduling of backups. Finally, the stored data is in a proprietary format and is not portable. Consequently I sought out an open source solution from the Linux environment that would accomplish and automatic backup.

As a quick aside, the back-up media that I am using is a Western Digital 2T USB hard drive that is attached to a USB port on my router. This configuration was chosen based on the premise that one should not use the same drive to backup your data. You would lose both your data and the backup should the drive fail.

When operating in Linux, there are a variety of back-up programs. Currently I am using sbackup. I have liked sbackup, but it has proven to be finicky. In this case, it appeared that sbackup was backing-up the MS Windows files. But that turned out not to be the case. The apparent "simple" solution failed. Time for Plan "B".

Plan "B" involved creating a "windows_backup" directory in my Linux home directory, using the Linux copy command, and employing anacron to schedule the backup.

The \etc\anacrontab entry to implement the backup script (program) is below.  
 1      20      window_backup    nice  bash /home/steve/ShellScripts/
Essentially the syntax above says to run the script (program) found in the file  "" once per-day 20 minutes after the computer boots into Linux (Ubuntu). Anacron manual page. The script below copies the MS Windows files into my Linux home directory and places them in the "windows_backup" directory. Sbackup successfully stores the files onto the Western Digital USB hard drive. No manual intervention required. Yea.
# Executed from /etc/anacrontab

cp -f -R -L "/media/windows/Users/Stephen/My Documents/Access" /home/steve/windows_backup/
cp -f -R -L "/media/windows/Users/Stephen/My Documents/My Garmin" /home/steve/windows_backup/
cp -f -R -L "/media/windows/Users/Stephen/My Documents/POI_Data_Files" /home/steve/windows_backup/

chown -f -R steve:backup /home/steve/windows_backup

As a conclusionary note, sbackup is only one of many Linux based programs to backup files. I am not that familiar with the other backup programs. Please do not consider my use of sbackup as an indication that it is the backup program that is to be used. You may wish to do your own search. Other Linux based backup programs may be able to successfully copy files from an MS Windows partition without the Plan "B" option noted above.

Tuesday, January 27, 2015

Intuit - A Despicable Company

Once again Intuit has demonstrated that is a despicable company out to screw its customer base. Prior Intuit Despicable posts here.

In this case, it was recently revealed that some of the standard features included with TurboTax Deluxe have been disappeared. As in removed without informing the customer that these features where no longer available. I had just bought TurboTax Deluxe. Neither the box nor the installation process disclosed that Intuit had downgraded TurboTax Deluxe. Today, I received the following notice.

The prostration by Mr. Goodarzi that: "Intuit has a long history of doing right by our customers, ..." is utter bunk.  I also note that others have seen this misleading slight of hand. Intuit gets greedy, nearly doubles price of TurboTax. Intuit Strips TurboTax Deluxe of Support for Key Tax Forms.

Even more incredulous is the duplicitous gobbledygook statement that: "Here's why we made the change. Over the years, we have worked hard to make it easy for you to choose the TurboTax product that is right for you and your unique tax situation. We want that choice to be clear and confidence inspiring. However, as new online and mobile technologies emerged, our products, and the tax scope and features they included, began to differ, leading to customer confusion. These differences also impeded our ability to introduce new innovations across our entire product line." Mr. Goodarzi seems to believe that Intuit customers are both confused and stupid.

Mr. Goodarzi goes on to state: "But good intent must be matched with great execution, and that is where we let you down. We have heard from many of you that you were surprised when you discovered the change. No one likes this kind of a surprise, so we are taking immediate action to make things right and help you through this transition year." Obviously the "surprise" was trying to pull a fast one on the customer. Well, there are two simple actions that Intuit could have done that would be customer friendly assuming that Intuit was actually ethical.

  1. Restore the features that were secretly removed though an on-line update.
  2. Allow the customer to upgrade to the Premier version for free.

Instead of a simple pro-customer solution Mr. Goodarzi proposes a "bait and switch" style solution where the customer must now pay an additional fee to upgrade to then get $25 back. Intuit apparently has difficulty with the concept of ethical behaviour. Getting your $25 refund. Also review this web-page: More information about the $25 cash back offer. Technologically, both Quicken and TurboTax are excellent products. The problem is that the marketing arm of Intuit is despicable.

Update:  I actually ended up getting a $35 dollar refund after complaining that the on-line upgrade cost more than the offered $25 refund. So Intuit gets  a +1 positive point. Hopefully, next year there will not be a repeat of this year's snafu.

Saturday, November 1, 2014

America: Imagine the World Without Her - A Movie Review

Overall, a good movie. A major plus of this movie is the perspective of D'Souza, who immigrated to the US from India. As such, like Tocqueville, D'Souza presents an "outside" viewpoint.

The movie does have its faults. It spends too much time reviewing the progressive left's distortion and vilification of US history before finally getting around to refuting those erroneous contentions. One could say that that is a positive for the sake of analysis. Nevertheless, one is left waiting for the "punch line". D'Souza, took an inordinate amount of time before finally geting around to mentioning that other cultures have been just as villainous as the US in various regards. Read the Wikipedia review.

One of D'Souza shortcomings, as an apologist for the US, in this film was ignoring Reagan's transgressions. D'Souza took great interest in hyping Reagan's famous quote: "Government is not the solution to our problem, government is the problem." as a supposed positive message. The problem of course, those were just empty words uttered for the sake of the sound byte. Reagan was unsuccessful in reducing the scope of government.

Rotten Tomatoes had an interesting breakdown concerning the responses to the movie. Eight percent of the critics gave the move a positive review. Which means 92% lambasted the film. Of the audience reviews, the positive percentage was 87%. It appears that the critics were not sympathetic to the conservative message. (I will agree that there were some non-political structural problems with the film.) Those who were motivated to the see the movie were probably conservative so the movie naturally appealed to them. In conclusion, the movie should be seen by all since it analyzes the US within the context of world history.

Finally - Science Fiction Magazine Database Ported to Linux

Finally, I have the Science Fiction magazine database working under Linux (Ubuntu 14.04 and LibreOffice Now I no longer need MS Access for maintaining the database. Completing it has proven to have been more complicated and taken a lot longer than expected. Steep learning curve. Prior posts on this topic.

I do not anticipate embellishing the current rendition, even though it is quite rudimentary.  The next phase will be learning PHP, HTML, and CSS so that the magazine database can be accessed through a web browser. Another multi-year extravaganza?

This project is pretty much a learning experience effort. Much of the data can be readily found on "The Internet Speculative Fiction Database". I would not have been able put this project together without the assistance provide by the "Access2Base" website and the volunteers at the "Apache Open Office Forum". Thank-you.

The Main Form

"Show Author Stories" button pressed.
When the "Show Author Stories" button is pressed, all stories associated with that author are displayed, even if in magazines other than Analog.

"Find an Author" button pressed.
When the button "Find an Author" is pressed, you can initiate a search to display all stories associated with authors possessing the search string.

"Find a Story" button pressed.

When the button "Find a Story" is pressed, all stories containing the search string will be displayed.

"Add an Author" button pressed.

Occasionally, stories have more than one author. The form above allows traditional authors to be assigned to a story.