Welcome

boxes

I am doing a much-needed update to the site, and will be posting older content from the old site at first and other sundry stuff I find. Stay tuned for all new stuff in 2015! – jim

Percy Faith – Music of Christmas

R 2507190 1354735866 7793

A classic that was heard in stores over the holidays from the 1950’s on, Faith’s arrangements of holiday songs is the very definition of Christmas Music. Originally recorded in 1954, it was later re-recorded in stereo in 1959 and this is the version that most people now know, [with the poinsettia cover] although there is not too much difference in the versions. A few years later Faith released ‘Hallelujah’ which was later renamed ‘Music of Christmas Volume 2’. It is right up there with the first volume. In 1966 ‘Christmas Is…’ was released, and other than the title song, there is more of a pop sound to the recording, very good but not in the same league as the original..

Music of Christmas [1959]

Amazon

iTunes

Complete Music of Christmas [1954 MONO version / Hallelujah] Amazon

Christmas Is… AmazoniTunes

 

Faith59Faith 2

faith-chr2.jpgFaith 3

Setting up an SQL Database

I have a post on how to use an SQL database to display records on your webpage. Well, you have to have a database in the first place to be able to do this, so here are some tips on how to Set Up a mySQL database.

I am going to use an example of a database that I wanted to put online of my music collection. I wanted to display the Artist, Title, Label, and Year in a searchable table. The database has 800 to 1000’s of listings, depending on how I filtered the info, and that was just too much work to put on a webpage, much less have someone search for a particular artist. So I set up a mySQL database on my hosting service.

Now this sounds awful, but to do a basic database setup is not too bad. Mosts hosts offer mySQL with the phpmyadmin client to manage the database.  I will tell you the steps I went through to set up my database, so if you have a different host, these steps may be different.

0. I suggest you export a portion [or all] of your database or spreadsheet into a .csv text file with the records and fields you want. If you have the option to choose the order of the fields, put them in the order you want them displayed, it will make life easier. I exported data with the fields artist, title, label and year in that order. BTW the first record did not have the field names, but since I stuck with the same order everywhere, this was not an issue.

1. I created a new mySQL database, and this simply involved clicking the NEW DATABASE button in my mySQL Admin page. 1and1 assigned a database and user name for me, I just had to provide a password and then wait about 5 minutes for the DB [database] to be set up. When the DB was ready, I clicked the ‘Edit’ button to start setting up the database. Note: I am no expert on databases or SQL, and there may be an easier way to set up the database records by importing, but this way worked for me.

I clicked on the Operations tab and entered a table name: music and fields:4 and clicked ‘go':

settingupansqldatabase-sql1-2009-12-18-16-45-2009-12-18-16-45.jpg

I was sent to the page to set up my records. This is where your exported .csv file will come in handy. I created each field in the order I wanted to import them, entered a length and type then saved it. I left the other fields blank so that they would be the defaults. There was a radio button at the end to check ‘index’ which I did for the title field:

settingupansqldatabase-sql2-2009-12-18-16-45-2009-12-18-16-45.jpg

I ended up at the Structure page, and at the bottom was an option to Insert data from a text file into the table. I browsed for the .csv data file and entered the import correct info which is self-explanatory. I did change the Lines Terminated By to just \r . Hit ‘Submit’ and since the records are in the correct order with the fields, all should go well.

settingupansqldatabase-sql3-2009-12-18-16-45-2009-12-18-16-45.jpg

That should get your database table filled with data. One note, back at your mySQL management screen, there should be the info for the server, username and your password which you will need to use Rapidtable. Go to RapidTable Post.

Rapidweaver and RapidTable

Rapidweaver is a website authoring program for the Mac. I have learned a lot of advanced tricks and like to share some new things when I learn them, in a step-by-step format.

Suppose you have a database or spreadsheet with lots of records that you want to share on your website, but do not know the best way to go about it. FYI if you just want a simple table of the data to put on your page, there is a website that will convert a comma-delimited file to a simple table, at Textfixer.com.

Now there is a way to use a mySQL database on your site using RapidTable, although this means you have to be able to do some basic configurations, but nothing too hard.

First of all, the advantage of a database is that you can display a lot of records in a table that will break the data into a set number of lines, create links to additional pages, and have a simple search function for your users to sort the data. I am going to use an example of a database that I wanted to put online of my dance music collection. As a former dj, I have numerous records that have been entered into a database. I wanted to display the Artist, Title, Label, and Year in a searchable table. The database has 800 to 1000’s of listings, depending on how I filtered the info, and that was just too much work to put on a webpage, much less have someone search for a particular artist. So I set up a mySQL database on my hosting service: Go to Setting Up an SQL Database.

After setting up my database, I downloaded RapidTable and installed it into RapidWeaver [update 12-2014: No longer available at the original page, but is at Softpedia]. Restart RW, then select a new page using RapidTable. You are presented with a setup page for Server, Username, Password, Database Name and Table. The first four should be available from your mySQL admin page. Table: Now when you set up the database, you created a table, ‘music’ was from my example. FYI a database can have many tables. Enter the info and then go to the configuration tab. Under fields, enter the names of the fields you want to display, with commas and no spaces: artist,title,label,year [They can be in any order, and not all fields of the table have to be used, just make sure the names are exactly the same as when you created the table fields]. Under Table titles, enter what you want displayed at the top of each column in the same order as the listing above: Artist,Song Title,Label,Year Then enter the number of lines to display on each page, I chose 50.

The next tab is the Header page. You can enter text, but to get line breaks and size you will have to use HTML code. Do not worry about the CSS tab yet. Now, you have to publish your page to your webhost before you can see the results, which will look a little strange, but we will get to that shortly. First let’s see if everything is configured correctly. After publishing, this is what I got:

Table4 2009 12 18 17 41

Yeah! The data is there, but of course it looks strange. There is a post on the RapidTable page that explains how to fix this, but it confused me a little, so this is what you have to do:

Go to the CSS tab. DO NOT PANIC! It may look scary, but all is not lost. I suggest you copy the whole page and save the text to a file in case you have to restore it if you really mess things up :) The fifth full line is this:

th.rwt-header border: #004d9c 1px solid; padding: 4px; background: #add8e6; [I deleted the brackets so the html will not mess up my page]

You are going to change the th.rwt-header tag. You need to append each field of your table to this tag plus a dash, like this for artist, title, etc, then a space, a comma then the next field.

th.rwt-header-artist, th.rwt-header-title, th.rwt-header-label, th.rwt-header-year

Next, you are going to change the th.rwt-cell-0 and th.rwt-cell-1 tags in the same way. They are on the next lines just search for them. You need to append each field of your table to this tag plus a dash, for artist, title, etc, then a space, a comma then the next field, just like above. Here is a screenshot of my text with the relevant changed tags underlined. This is the only thing I added:

Table5 2009 12 18 17 41

Your page should now look correct with the alternate lines:

Table6 2009 12 18 17 41

If you know CSS you can change the colors of the lines, etc. Now one more thing. See the little V button to the left? Click it and you get a search box! You can search on one or more fields, and no wild cards are needed, ie DON will bring up Madonna and Donald, etc. Just enter your search text and hit ‘enter’. You may want to note that to your visitors, since it may not be obvious to them.

Hope this has been helpful! Good Luck!