Saturday, July 26, 2008

Back ups continue

I have two documents folders from the Macbook 1 from 2007 backuped to DVD now and have started on a third folder.

The DVD drive in my eMac is still stuck closed

I have not been able to open the DVD drive of my eMac.

Tuesday, July 15, 2008

Backups continue

I managed to burn one DVD of the documents folder for my Macbook. I made six copies. I call this Macbook, Macbook 1. So this is a 2008 copy of the Documents folder. I also completed burning the 2007 desktops about 6 of them from various months of 2007 of the Macbook. I am now going to make 7 sets of 6 copies of DVD's each of the documents folders from 2007. I have seven folders on a USB hard drive. So this is the next back up run for the Macbook. I am burning these disks at 1 X speed with no errors.

Thursday, July 10, 2008

One of these computers I traded for works and is complete.

So I traded away my Sun Ulltra 5 and got two 1U servers, three mid sized towers and one Dell laptop in exchange. I also traded a Peavey Stereo EQ. The stereo EQ cost 99 dollars and was really a mistake as it was a monster and very old. When I can afford it I will buy a proper modern EQ for our music gear set up. So I was testing out these computers and one of the towers seems to be missing a hard drive. One of the towers is a Dell Pentium III 600 Mhz machine and it works and is complete. It has an 80 GB hard drive. I installed Debian 4.0 r3 on it and set it up for someone who I will donate it too.

For the servers I bought a Pentium M processor for one of them and got that in the mail, installed it and it starts up but does not post. The other 1U server is a Sun Fire v120 and for that I bought two hard drives 18 GB models 4177, the right hard drives with caddies. I am waiting for those to arrive in the mail. Other than that I have done no work on the servers. I need to learn more about operating servers.

The Dell laptop needs a power supply and is a Pentium II computer and has one USB port and a Modem.

Sunday, July 06, 2008

Back ups at present

I have backed up this blog and my studies blog now. I have not done more work on the bibliography though. I also have the Macbook desktops from 2007 backed up to DVD. Again I have 6 copies of this DVD. I now must move on to backing up the 2007 documents folders from the Macbook. I also have backed up the eMac to DVD but did not label the disks so need to go through a stack of DVD's and load them in the Macbook and then write in magic marker on each DVD what it contains and which copy it is.

Friday, July 04, 2008

I did not back up my studies blog but did start some bibliography work.

I did manually enter the few books from my studies blog from October 2003 into RefWorks and made a rich text bibliography in ASA style. There are a few more books from that month of the blog and a case or two and some newspaper articles. I also downloaded and started to use BibDesk. With BibDesk I manually cited the first two months of the blog. Those files got saved in my studies blogs back up folder on my eMac. But other than that I dropped my bibliography work after the last post.

Thursday, July 03, 2008

Back ups of this blog

Here is the path today. I was feeling guilty that I am not reading enough because I am borrowing about 40 books and instead of reading these I am cerfing the Internet. So I started to read some more of the O'Reilly book on PHP and MySQL. I read about MySQL and there is an example of SQL code for adding a book to a database. I get distracted and thought about making a database of all the books I have ever read. I then figured I could grab some books from my studies blog. I of course have to have all the posts to search. I then figured it is time to back up these blogger blogs. So I started with this one which is now five years old. I looked in my directories and found I have about two years of posts not copied and pasted into word processor files. So I have now copied all those approximately 24 months and now every month is copied and pasted from the web into a Microsoft word doc file.

Now I must to do the same for my studies and more studies blog then I can figure a way of scanning it for bibliographic cites. I typically used the McGill legal studies style for my citations. I have many choices now. I can do what the book recommends and use MySQL which is installed on my Macbook and on my Linux computer. I could also install MySQL on this eMac. Or it may in fact already be installed here. I could also use RefWorks but that depends on being a registered student at the university of Ottawa. I could use BibDesk and need to install that on this eMac. I could make a plain text file of the data or use Excel meaning use some tool not especially for books. I could also use Librarything.com. Some of these book specific tools will be able to share the files. So the only problem now is to back up the studies and more studies blog and then extract the citations. From there I will go to RefWorks then download for BibTex and then manually up load to librarything. Also I could use Refworks "Grab it" and may be capture the books right off the blog pages. I may try that now. I am also thinking now before I leap that I should keep a separate list of books that have appeared on my blog only. Once again by writing I have helped solve some problems.

Hard drives for the Sun but thats it for now.

I can not really afford to be buying a lot of parts for the Sun v120 right now. I may buy some hard drives for about 30$ today but that would be it. I am more interested in buying camera gear and groceries at the moment.

This is a DVD for sale right now on ebay.

X8082A 371-0736 8x DVD-ROM/24x CD-ROM Drive.

Tuesday, July 01, 2008

Swapping computers and parts with someone.

I put the Sun Ultra 5 up for sale for 120$. I have an offer to trade it for some other machines. One machine is a partial Sun fire v120 with Intel 866 Mhz chip and 198 MB PC 100 RAM. Another machine is 1 U rack server with 256 MB DDR but no chip (I did just buy a 1.8 Ghz Pentium M chip for this). Also a foxconn server board again for a Pentium M chip. A few older pentium II's and Penitum III's and one Pentium IV. These older computers are with partial cases and drives.

I researched the Sun Fire v120 and also the Foxconn board which he says is brand new. I will post some of my research later.

Sunday, June 22, 2008

Documenting some chart making in Open Office and Excel.

This post may be hard to follow but it is for myself to document my techniques and not loose them. If you learn from it you may find it useful for your spreadsheet work. It is also a way for me to practice for work and to push my spreadsheet abilities for data handeling.



I downloaded some data that was free. There were only 5 years covered. I have been using years as my X axis for the past two weeks. The data was divided by age groups and I only downloaded 5 year age bands from 45 to 89 and then 90 and over. It was for cause of death data and is published annually. These vital statistics are free for download. I have around 27 causes picked out. I had the data for both sexes and for men and for women. So for each year I had a column and for each age band and each of the 3 gender categories I had the 27 causes in rows. All in all about 750 rows of data.

I downloaded that data into a spreadsheet. I then created a new sheet in that workbook. Editorial Note: When one downloads data it seems the workbook has only the one sheet unlike when one creates a new workbook with three sheets. In the new sheet I copied totals for cause of death for the same age bands and the same gender categories but from all causes of death in Canada. This was copied from a separate download. These two sheets were then not changed and after this step; data were only copied out from these two download sheets. Then in a third sheet I made my own row labels for the genders and age bands matching the second sheet's row ordering. The labels from the database were lengthy and unreadable in the width of my spreadsheet window and the differences between the labels could not be viewed easily. Editorial note: the labels were so long not even a 30 inch monitor would display them completely I am guessing. These new labels were shorter and after much copy and pasting I had made all some 31 rows labels by age bands and gender categories. They were in the same row ordering as the downloaded deaths by all causes. I then made five year columns after these row labels in the first column and copied the totals deaths by all causes by years data to this sheet.

Then I went back to a copy of the death by specific causes download in separate workbook and saved a copy of that download as a text file or comma separated file. I then closed it and imported it. I imported the data as a text file. This is one of my data handling tricks that could also be done with regular expressions if one was using a programming or scripting language. The picking of the appropriate delimiters is the trick. I chose delimiters during the import that would cut the long row labels in this file so that the specific causes' names, age band's names and gender names, were all brought in to this new spreadsheet in separate columns. Actually I used three columns and then copied these labels into a new fourth sheet in my main workbook. The row order for the 750 rows was preserved.

I then went back to the first sheet in the main workbook with all the cause specific data and copied all the data but not the labels into the new fourth sheet. So sheet four was the same as sheet one, but I now had three columns for labels and the labels were short and readable on the screen. I then made new rows in sheet four at the top of the beginning of each specific gender category (both sexes, males, females) and the beginning of each age band (5 year age bands 45-89 and the age band 90 and over). So when for example, the data for both sexes, 45 to 49,and 27 rows of specific causes of death started in the sheet, a new row started the 27 rows for both sexes, 45 to 49 years old. Then going back to sheet three with the total causes of death by genders and age bands, I added two more columns between the labels and the yearly totals columns to make a proper column alignment with the three column labels in sheet four. Then one at a time, the new rows I had created in sheet four were pasted with the rows from the 31 age and gender specific death by all causes data and short labels for gender and age bands from the third sheet.

I was now ready to calculate some results. I created formulas for counts for specific causes over total causes and then made this number a percent. I used the real number for the total but for the specific cause count I used a cell reference. I then filled down the columns into the 27 specific causes effecting the calculation for all five years and all 27 causes for the first set of data which was 45 to 49 both sexes. This was the only data I worked through today. I still had these 27 cause specific rows by 5 years columns of data highlighted after the fill so I then used format cells to change all the numbers to percents with 6 decimal places.

I then charted all non-zero rows basically following the charting techniques in Excel I have learned at work but I did it in Open Office. Somethings are done differently in Open Office charts. I then also did a counts chart that matched the percents charts but makes no reference to total deaths. After a long break, I spent some time formating the charts for printing and printed the two charts out.

I then saved and closed all the workbooks. I thought it would be a good idea and relaxing and good for my intellectual health to document all my work so I have posted this notes.

Wednesday, June 11, 2008

I used Disk Utility to Seven Pass erase a USB key.

I am giving a small 256 MB USB key to a coworker. I copied all the files off of it this morning and then did a seven pass erase of the key. I will now bring it to work for her.

I am getting some old SLR lenses

I am very tempted this past year to buy a Digital SLR camera. I have gone about buying old SLR non digital lenses this week. I may have over spent on these.

Hard drive space on the Sun Machine.

I think I ran out of hard drive space on the Sun Machine. I am not using it much so will wait to upgrade the hard drive. The memory I bought for it is may be the wrong type. I have updated a few items now. That was all I did with it last time it was on. I have learned to turn it off now properly.

Sunday, June 08, 2008

Sun machine

I am just launching Update Manager on my Sun machine, Crystal-Sun-1. I turned off the machine last time and it might have been during updates so I may have incomplete updates.

Friday, May 30, 2008

Friday, May 09, 2008

The eMac2 finder is working again.

The fix worked. I had run out of hard drive space but after deleting the two most recent burn folders I have some 8 GB of space back on the eMac2 and the finder is working again.

Thursday, May 08, 2008

The eMac2 is having troubles but fixes are being attempted and emergency critical backups have begun for right now in case of further failure.

I was making some backups on the eMac2 using backup files from the 2006 user folder on one of the USB drives. Then a DVD being used as media failed to eject. Then the finder would not respond. The computer has been like this for almost two weeks, without a finder. So the thoughts of backing up the present files were quickly brushed aside as the finder could not be used.

I did think last night to access the folders remotely using the Macbook1. So slowly late last night I have been copying the email folder and mail download folder off of the eMac2. I have shut off the email and the plan is to use the email software on the Macbook now.

Speaking of changing email software, I did loose a little email for about 1 hour's worth of incoming email on the Linux machine when I thought of switching to Linux for a main email computer. But I should learn to copy Mac Mail to Linux and also to Thunderbird email software on Vista. I still do not have a way of transferring email between operating systems other than Netscape email. I am hoping Thunderbird can do this too as Netscape is now closed as a company. This reminds me I need to access Netscape downloads and download some historical copies of the browser.

After my back up I will try to read all this email in the IBM under both Linux and also Vista. If this works I will try to load all the email into Solaris but I doubt there is room on the old Solaris box

I am also remotely deleting the last folder made on the eMac2 which was the burn folder for the backup I was trying to make. I am hoping that when this burn folder is deleted the finder will work again. If this does work out this way the situation will be less critical.

The only follow up may be simply increases the backup frequency for the eMac in future. I guess I would also stop burning disks on the eMac2 and try to avoid a similar problem in the future. I may also continue to follow through on switching some main computer tasks off of the eMac2 and onto a different but newer computer.

I can also just look up how to manually eject the DVD and that may solve the problem too.

Sunday, April 27, 2008

Still burning backup DVD's from the 2006 state of the Macbook1.

The eMac DVD drive is not opening so I switched to Macbook for backups and then turned off the virus software and the Macbook is doing fine burning the DVD's of the 2006 end of year files that were on the Macbook1. These are copied off the USB drive they were stored on by LaCie Backup software which backed up the user folder then in 2006.

The email from 2006 is all backed up now to six DVD's and properly labeled. The whole user folder is not being backed up to a number of separate DVD's and I am not sure how many DVD's I will need to split the user folder into. So far I have the folders and files decided for two DVD's and the first disk is now burned to six identical copies. The backups continue.