Shell Script

Today I had to create a report from an online database.
Below is the script used. It took about 5 to 6 hours to process the 48766 records on the database using the SSH - Secure SHell.

The SSH Secure Shell for Workstations Windows client (SSH2 client) is a program that allows secure network services over an insecure network.

The SSH Secure Shell for Workstations Windows client replaces other, insecure terminal applications, such as Telnet and FTP. It allows you to securely remote login to remote host computers, to execute commands safely in a remote computer, and to provide secure encrypted and authenticated communications between two untrusted hosts. X11 connections and arbitrary TCP/IP ports can also be forwarded over the secure channel.

It is a powerful guardian against the numerous security hazards that nowadays threaten network communications.

Here the script

#! /bin/bash
HERE=/var/www/html/cfl/utils
HOST=dbms.m1group.com.au
ME=DBMS
TEMPLATE=template1
DATA=/var/www/html/cfl
SCRIPT=dbms_gen.sql
BPD_DATA=${DATA}/export
FLSD_DATA=${DATA}/export
C21_DATA=${DATA}/export
HS_DATA=${DATA}/export
TR_TO_CSV=${DATA}/utils/tr_to_csv.pl
#
#

cd ${HERE}
# Make BPD and HS reports
#
# Generate BPD and HS mail out files
${TR_TO_CSV} ${BPD_DATA}/BPD`date -I`_all.csv -a --c BPD
#${TR_TO_CSV} ${FLSD_DATA}/FLSD`date -I`_all2.csv -a --c FLSD
#${TR_TO_CSV} ${C21_DATA}/C21`date -I`_all2.csv -a --c C21
#
# 2005/01/28 not used anymore HS no longer customer
#${TR_TO_CSV} ${HS_DATA}/HS_`date -I`_all2.csv -a --c HS
#

Restore Your Computer's Performance with Windows XP

I've been downloading heaps of different software/applications for uni and personal use... My computer has been performing very slow.

I've had to fix the performance of it. The following link is a basic guide to "Restore Your Computer's Performance with Windows XP"

Downloading tools / plug-ins Task

I recently downloaded the Free Google Pack.
It's quite good had -

1. Google Deasktop - with handy tools for search your computer quicker and great for finding new google gadets that match your interests etc...
2. Google Toolbar for IE - Great pop-up block and it give you search acces with google from any webpages....
3. Mozilla Firefox with google Toolbar
4.Norton Security Scan
5. Picasa - Photo organizer/editor etc...
6. Google Screensaver
7. Adobe Reader 8
8. Spyware Doctor

Opitional Software

Realplayer, Skype and GalleryPlayer HD Images...

If you have already got some of the software, which most user will It will only update the software if a newer version is avaiable:)
You can also just choose the software you want...

Boolean & Google is my favorite

My favorite search engine is google. Why well basically it is recognized as the best general web search engine and from reading/surfing the net it's said to be the biggest sarch engine. Here's a UC Berkeley university link: -

http://www.lib.berkeley.edu/TeachingLib/Guides/Internet/Google.html

I recommend reading this link its quite good:)

Internet Relay Chat (IRC)

The main dfference I can see is IRC is group based not individual based?

Messenger

Been using Windows Messenger all week communicating with my former IT manager who is now based in China.

This has been great as I have needed information, advise and assistance from him in using certain application for work.

The following are some of the advantages this application has been for me: -

- Cost effective
- Able to view when he has been online
- Cut n paste SQL queries and similar commands (CentOs/Linux)for him to view and make adjustments if needed?
- Able to invite other related people to the conversations if needed

Test your web page according to the W3C standards by going to their ‘validator’ page

This page is not Valid HTML 4.01 Frameset!

Below are the results of attempting to parse this document with
an SGML parser.

1. 
   Error
   Line 4,
   column 29:
   required attribute "TYPE" not specified
   .
   

   <script language="javascript">

   
   
   
   
   

   
   The attribute given above is required for an element that you've used,
   but you have omitted it. For instance, in most HTML and XHTML document
   types the "type" attribute is required on the "script" element and the
   "alt" attribute is required for the "img" element.
   

   
   

   
   Typical values for type are
   type="text/css" for <style>
   and type="text/javascript" for <script>.
   

   
   
   
   

   
   href="feedback.html?uri=http%3A%2F%2Fwebct.curtin.edu.au%2F305033_a%2Fstudent_pres%2FGroup05%2Findex.html;errmsg_id=127#errormsg"
   title="Suggest improvements on this error message through our feedback channels"
   >✉
   

   
   
   



2. 
   Error
   Line 48,
   column 32:
   required attribute "TYPE" not specified
   .
   

   <script language="JavaScript1.4">

   
   
   
   
   

   
   href="feedback.html?uri=http%3A%2F%2Fwebct.curtin.edu.au%2F305033_a%2Fstudent_pres%2FGroup05%2Findex.html;errmsg_id=127#errormsg"
   title="Suggest improvements on this error message through our feedback channels"
   >✉
   

   
   
   



3. 
   Error
   Line 63,
   column 6:
   end tag for "HEAD" which is not finished
   .
   

   </head>

   
   
   
   
   

   
   Most likely, You nested tags and closed them in the wrong order. For
   example <p><em>...</p> is not acceptable, as <em>
   must be closed before <p>. Acceptable nesting is:
   <p><em>...</em></p>
   

   
   

   
   Another possibility is that you used an element which requires
   a child element that you did not include. Hence the parent element
   is "not finished", not complete. For instance, <head> generally
   requires a <title>, lists (ul, ol, dl) require list items (li,
   or dt, dd), and so on.
   

   
   
   
   

   
   href="feedback.html?uri=http%3A%2F%2Fwebct.curtin.edu.au%2F305033_a%2Fstudent_pres%2FGroup05%2Findex.html;errmsg_id=73#errormsg"
   title="Suggest improvements on this error message through our feedback channels"
   >✉
   

   
   
   



4. 
   Error
   Line 64,
   column 5:
   document type does not allow element "BODY" here
   .
   

   <body>

   
   
   
   
   

   
   The element named above was found in a context where it is not allowed.
   This could mean that you have incorrectly nested elements -- such as a
   "style" element in the "body" section instead of inside "head" -- or
   two elements that overlap (which is not allowed).
   

   
   

   
   One common cause for this error is the use of XHTML syntax in HTML
   documents. Due to HTML's rules of implicitly closed elements, this error
   can create cascading effects. For instance, using XHTML's "self-closing"
   tags for "meta" and "link" in the "head" section of a HTML document may
   cause the parser to infer the end of the "head" section and the
   beginning of the "body" section (where "link" and "meta" are not
   allowed; hence the reported error).
   

   
   
   
   

   
   href="feedback.html?uri=http%3A%2F%2Fwebct.curtin.edu.au%2F305033_a%2Fstudent_pres%2FGroup05%2Findex.html;errmsg_id=64#errormsg"
   title="Suggest improvements on this error message through our feedback channels"
   >✉
   

   
   
   



5. 
   Error
   Line 65,
   column 29:
   required attribute "TYPE" not specified
   .
   

   <script language="javascript">

   
   
   
   
   

   
   href="feedback.html?uri=http%3A%2F%2Fwebct.curtin.edu.au%2F305033_a%2Fstudent_pres%2FGroup05%2Findex.html;errmsg_id=127#errormsg"
   title="Suggest improvements on this error message through our feedback channels"
   >✉
   

   
   
   



6. 
   Error
   Line 70,
   column 6:
   end tag for "HTML" which is not finished
   .
   

   </html>

   
   
   
   
   

   
   href="feedback.html?uri=http%3A%2F%2Fwebct.curtin.edu.au%2F305033_a%2Fstudent_pres%2FGroup05%2Findex.html;errmsg_id=73#errormsg"
   title="Suggest improvements on this error message through our feedback channels"
   >✉