Archive for the ‘Applications’ Category

Trace Watch iPhone Plugin (TWiPP)

22 Mar 2010 at 14:30

Terry Moore

iPhone, Mobile, Programming, Trace Watch

No Comment


Click here for the *UPDATED VERSION*

Ever since I have configured my website to use Google Analytics I have become a bit of a statistics nut.  I find myself checking every free moment I get and while I don’t get a lot of traffic it is always nice to see when someone does visit my site.

The other day I discovered another way to fill my website statistics fix by installing an application called Trace Watch.  Trace Watch is similar to Google Analytics but it gives you real time stats and a few alternate ways to see the data that I have not discovered with Google Analytics.

So I was out and about the other day doing shopping with my wife  and I decided to check my Trace Watch web stats from my iPhone.  While I could connect to the stats site it was a little cumbersome to see just the basic information that I craved; hit counts and visitor counts.  I though it would be nice if there was an iPhone app for this.  I did a few searches of Apple’s App Store which came up empty.  I then did some Google searches to see if there was any available plug-ins and it also came up empty.  So I decided to try my hand at writing one.

I knew that I didn’t want to download and install Apples SDK so I started to look for information about how to create web apps for the iPhone, which lead me to this: iUI.  Its a java-script/CSS library that mimics the iPhone look and behavior.  I also found the Trace Watch API documentation on their site.  So now that I had both pieces to the puzzle I was off and here is the outcome.

Installation is a snap and there isn’t any configuration changes that need to take place in either the plug-in or the Trace Watch application.  This app currently is only made to get some basic information from Trace Watch and will not be a complete iPhone GUI replacement for the main Trace Watch application.

Installation Instructions:

*UPDATED VERSION*

Step 1:

Download the plug-in zip file: Trace Watch iPhone Plugin (166)

Step 2:
Extract the zip file to a temporary directory

Step 3:
Upload the extract directory name “m” to the root of your Trace Watch installation folder (assuming /twatch)

Step 4:
Browse to this site via your iPhone:  http://<yoursite>/twatch/m

Here are some screen shots of the application:

TWIPP

Home Screen

TWIPP

Statistics Screen

EDIT: Both the misspelling of Visitors and the Average Page Views per Visitor has been fixed in the attached zip file.  I will update the screen shots soon

TWIPP

Breakdown of Hits per Hour

More features are coming soon but I wanted to get quick version 0.1 out to get people’s opinions and feedback to see if this was worth continue to pursue.  So please any feedback, good or bad, is appreciated. Either via email at motersho@gmail.com or as a comment on this page.

Also I have not tested this on any other mobile browser so I don’t know how it will behave but I have a feeling it will not work too well seeing that it doesn’t behave very well in Firefox.

Download: Trace Watch iPhone Plugin (129)

Update: (08/01/2010):
The latest version now support multiple websites.

Set Windows Applications to Always Be On Top

23 Nov 2009 at 19:48

Terry Moore

Ajax, Applications

No Comment

Here is an application that I wrote that will allow you to select a running application and keep the windows running on top of all of the other applications.   This has been tested on Windows XP/2003/7.  I assume that it will work on Vista.  There isn’t an installer just download the executable and run the application.  The application was written in AutoIT and I have included the source code.  It is release under the GPL v3 license.

Application: RunOnTop.exe (127)
Source: RunOnTop.exe Source (151)

Screen Shot of RunOnTop.exe

Screen Shot of RunOnTop.exe

How to: Manual Install of the Oracle dbConsole

12 Oct 2009 at 20:03

Terry Moore

How To, Oracle, Technical

No Comment

Here is how to manually install an Oracle database server’s dbConsole service on Windows. You will need to run %ORACLE_HOME%\bin\emca.bat.

First you have to set a couple of system environment variables

c:\>set ORACLE_HOME=c:\path\to\oracle\home
c:\>set ORACLE_SID=DB_SID

Next run the emca.bat file with the parameters -config dbcontrol db

c:\>emca.bat -config dbcontrol db

Next you will be asked a few configuration setting

STARTED EMCA at Oct 12, 2009 3:34:20 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Enter the following information:
Database SID: DB_SID
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user: Password for SYSMAN user: Password for SYSMAN user: Email address for notifications (optional):email@yourserver.com
Outgoing Mail (SMTP) server for notifications (optional):mail.yourserver.com

It will then ask you to verify the setting that you just entered

You have specified the following settings
Database ORACLE_HOME ................ C:\path\to\oracle\home
Database hostname ................ yourdbserver.com
Listener port number ................ 1521
Database SID ................ DB_SID
Email address for notifications ............... email@yourserver.com
Outgoing Mail (SMTP) server for notifications ...............mail.yourserver.com
-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: yes

Once you enter yes it will then display a bunch of log information. In this log will be the path to your Enterprise Management Console. ex. http://:1158/em

Enter the url in your browser and login. You are now all set. This will create the OracleDBConsole server and set it to start automatically.

A few notes. I didn’t know the password for my dbsnmp user account. So I attempted to login and Oracle told me that the account was locked. I then entered the following commands to unlock the account and to change the password.

c:\>sqlplus /nolog
sqlplus>conn sys as sysdba
Enter Password: sqlplus> ALTER USER dbsnmp ACCOUNT UNLOCK;
Account Unlocked
sqlplus>ALTER USER dbsnmp identified by ;
Password Changed.

Thats it.

Newer Entries →