Casey Wise

How to list directories only on the unix/linux command line

Casey Wise — Tue, 17 Apr 2012 14:10:44 +0000

Disturbingly, this was a difficult answer to find. I'm looking for the fastest most concise command to list out directories only. Here's what I found/came up with:

ls -d */

And then to list them vertically, throw a 1(numeral one) in your switches

ls -1d */

Protected: NW Dupes

Casey Wise — Tue, 17 Apr 2012 02:18:26 +0000

Graphic Work: Ambassadors For Rebuilding

Casey Wise — Thu, 26 Jan 2012 13:34:19 +0000

My brother is a fellow University of Akron employee and heads up the Ambassadors for Rebuilding program within the Construction Engineering Technology department. He and a bunch of able bodied and skilled students are headed to Nashville, TN this March to assist in the rebuilding of some underprivileged US veterans in the area all on a volunteer basis.

I was asked to help whip up a WordPress site and build some graphics. I was asked to come up with a logo and tshirt design. Below is the logo I came up with . I made use of Adobe Illustrator CS3, messing around with it's 3D capabilities for one of the first times. Very neat stuff!

University of Akron - Ambassadors For Rebuilding Logo

Site Work: icandothatdesign.com

Casey Wise — Thu, 26 Jan 2012 13:24:58 +0000

My wife got a message over facebook from one of her good childhood friends that saw our photography site and inquired about my web services. She is a graphic designer in the greater Washington DC area and was looking for a way to showcase her services + build an online portfolio of her work. We made use of WordPress and a premium theme that had some portfolio management built in to it. We did a bit of code (PHP & JavaScript) and styling customization. The theme author made use of Contact Form 7 to collect contact information on a standard form on this one. SEO was achieved with Google XML Sitemaps.

As a graphic designer, it was really fun to put my own experiences to work here to help bring this one up. The work was fun and quick on this one. I look forward to the ongoing curatorship of this site.

icandothatdesign.com

Graphic & Site Work: iControl Automation

Casey Wise — Thu, 26 Jan 2012 13:04:02 +0000

I am in the process of doing a s site for the folks over at iControl Automation. This is another WordPress site, making use of a premium them with some styling styling customization. We're plugging in form work with one of my favorite plugins, Contact Form 7 and SEO via Google XML Sitemaps.

They also asked for some graphical work, and we quickly (and I mean quick! 15 minutes) came up with this logo:

iControl Automation Corporate Logo

Standard PHP MySQL reporting

Casey Wise — Wed, 28 Dec 2011 22:34:15 +0000

This one here is pretty simple. 3 SQL queries report out data of certain cases and mails it out.


	
	
	Last 24 Hours of Employee Applications Snapshot
	
	
	
	
	Employee Applications 24hr Snapshot
	This report pulls the past 24 hours of employee applications submitted";

	// db connection string
	require("connst.php");

	// case whre data is lacking a position number
	$sql_pullFailedJobNumberCapture = "
		select
			b.web_form_id,
			DATE_FORMAT(b.submit_date, '%c/%e/%Y %I:%i %p') as 'submit_date',
			concat(a.first_name,' ',a.last_name) as 'name',
			a.email
		from
			web_form a
			inner join employee_application b
				on a.web_form_id = b.web_form_id
		where
			RIGHT(SUBSTRING(a.custom_fields,LOCATE('|Position Number', a.custom_fields),23),6) = ''
			and b.reported = 1
			and a.form_type = 'Job_App'
			and b.PositionNumber = ''
		order by
			a.web_form_id desc";

	// case where data is no older than 24 hours old
	$sql_pull24Hours="
		SELECT
			NOW() as 'now',
			NOW() - INTERVAL 1 DAY as '24hrsago',
			a.web_form_id,
			DATE_FORMAT(a.submit_date, '%W %m/%d/%Y %r') as 'submit_date',
			TIMEDIFF(now(),a.submit_date) as 'age',
			concat(a.first_name,' ',a.last_name) as 'name',
			concat(b.PositionNumber,' ',b.PositionTitle) as 'pos',
			b.reported
		FROM
			web_form a
			left outer join employee_application b
				on a.web_form_id = b.web_form_id
		WHERE
			a.submit_date >= NOW() - INTERVAL 1 DAY
			and a.form_type = 'Job_App'
		ORDER BY
			a.web_form_id desc";

	// case where submit_date capture failed
	$sql_pullNullRecordBottleNeckers = "
		select
			b.*
		from
			web_form b
		where
			b.web_form_id >= (select max(a.web_form_id) from employee_application a)
			and b.form_type = 'Job_App'
			and b.submit_date is null";

	$result = mysql_query($sql_pull24Hours);
	if (!$result)
	{
		echo 'Could not run pull24Hours query: ' . mysql_error();
		exit;
	} else {
		$rowCount = mysql_num_rows($result);

		$countReported = $countUnReported = $countUnMoved = 0;
		$out_unReported = $outUnMoved =  "";
		$loopCounter = 0;
		while ($row = mysql_fetch_array($result))
		{
			$rowClass = "";
			if($loopCounter%3==0)
			{
				$rowClass = ($rowClass == 'dark')?'light':'dark';
			}

			$web_form_id = $row['web_form_id'];
			$submit_date = $row['submit_date'];
			$name = $row['name'];
			$pos = $row['pos'];
			$age = $row['age'];
			$reported = $row['reported'];

			$applicationDetail = $web_form_id." ".$name." ".$pos." (".$age.")";
			if($reported!=1 && !$pos)
			{
				// just been collected data hasn't moved from wfr to ea
				$countUnMoved++;
				$countUnReported ++;
				$out_unReported .= "".$applicationDetail."";
				$outUnMoved .= "".$applicationDetail."";
			} elseif ($reported!=1 && $pos) {
				// moved from wfr to bu ea plugin hasn't fired
				$countUnReported ++;
				$out_unReported .= "".$applicationDetail."";
			} elseif ($reported && $pos) {
				// moved and reported
				$countReported++;
			}
			$loopCounter++;
		}

		$lineHeight = 60;

		if($rowCount == $countReported)
		{
			$out .= "".$rowCount." Applications Collected & Reported";
		} else {
			$out .= "".$rowCount." applicants' applications collected";
		}

		if($countUnReported>0)
		{
			$thisLineHeight = $lineHeight + (13.1*$countUnReported);
			$out .= "".$countUnReported." Applications Unreported to Job OwnersThis data has moved to HR's reporting tables, but the job owner hasn't been notified yet.  The employeeApplication plugin is responsible for this one.
".$out_unReported."";
		}

		if($countUnMoved>0)
		{
			$thisLineHeight = $lineHeight + (13.1*$countUnMoved);
			$out .= "
".$countUnMoved." Applications Yet To MoveThis is an application that's been submitted but hasn't been moved to HR's reporting tables and therefore unreported to the job owner as well.  The plugin responsible for this one is the webFormsReporter.
".$outUnMoved."";
		}
	}

	$result = mysql_query($sql_pullFailedJobNumberCapture);
	if (!$result)
	{
		echo 'Could not run pullFailedJobNumberCapture query: ' . mysql_error();
		exit;
	} else {
		$rowCount = mysql_num_rows($result);
		if($rowCount > 0)
		{
			$out .= "Found ".$rowCount." instance(s) where job identification criteria capture failed";
		}
		$loopCounter = 0;
		while ($row = mysql_fetch_array($result))
		{
			if($loopCounter%3==0)
			{
				$rowClass = ($rowClass == 'dark')?'light':'dark';
			}
			$web_form_id = $row['web_form_id'];
			$submit_date = $row['submit_date'];
			$name = $row['name'];
			$out .= "";
			$loopCounter++;
		}
		$out .= "ID Date Name
".$web_form_id." ".$submit_date." ".$name."";
	}

	/** Mon Aug  8 07:41:55 EDT 2011 - cmwise: Bottle Neckers - everytime the system goes down we see records get logged where the submit date and all custom fields are null
		* record deletions are required which at this time can only be executed by a sysadmin
		* by law, we're required to send these records to HR so they can keep them on file.  Gonna make a reporter to quickly create a CSV to send to Laura Srpay at HR
	*/

	$result = mysql_query($sql_pullNullRecordBottleNeckers);
	if (!$result)
	{
		echo 'Could not run pullNullRecordBottleNeckers query: '.mysql_error();
		exit;
	} else {
		$rowCount = mysql_num_rows($result);
		if($rowCount > 0)
		{
			$pluralIsAre = ($rowCount > 1)?"are":"is";
			$pluralRecords = ($rowCount > 1)?"s":"";
			$out .= "Found ".$rowCount." instance".$pluralRecords." where null records were created
				
					To get the employment apps flowing again, there ".$pluralIsAre." ".$rowCount." record".$pluralRecords." to be deleted
					By law, the WebTeam is required to remit any and all null records to HR prior to deletion
Create CSV to send to HR";
			$loopCounter = 0;
			$theseWebFormIDs = "";
			while ($row = mysql_fetch_array($result))
			{
				if($loopCounter%3==0)
				{
					$rowClass = ($rowClass == 'dark')?'light':'dark';
				}
				$web_form_id = $row['web_form_id'];
				$theseWebFormIDs .= $web_form_id.",";
			}
			$out .= "DELETE FROM web_form WHERE web_form_id in (".preg_replace('/,$/', '', $theseWebFormIDs).");";
		}
	}
	$out.="
Live reporting";
	$to = "";
	$subject = "Emp App 24hr Snapshot";
	$message = $out;
	$headers  = 'MIME-Version: 1.0' . "\r\n";
	$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

	// Additional headers
	$headers .= 'To: Casey Sinister Wise , Eric Kreider , Laura Chocolate-Chip-Cookie-Makin Spray ' . "\r\n";
	$headers .= 'From: UA EmpApp 24hr Snapshot Report' . "\r\n";
	$mailResult = mail($to, $subject, $message, $headers);
?>

ID	Date	Name
".$web_form_id."	".$submit_date."	".$name."

PHP demos: iterate over XML with a MySQL recordset within

Casey Wise — Wed, 28 Dec 2011 21:57:52 +0000

This one starts out pulling a small db record set of buildings and reading an XML doucment of people. It then iterates over the XML document. Each person in the XML is associated with a respective building abbreviation. With the building abbreviation, we iterate over the pulled database records and pull the respective building information from it and move it in to variables. All of this is then reported out as a tab seperated value text file.

	entry as $entry)
	{
	  // reset the record pointer to the top of the recordset

		$ID = trim($entry['employeeID']);
		$URL = "http://www.uakron.edu/search/people_detail.dot?employeeNumber=".$ID;
		$Name_Last = trim($entry->lastName);
		$Name_First = trim($entry->firstName);
		$displayName = trim($entry->displayName);

		// the reason for the breaking below is because we only want the dept and title that come out first, that's considered the "default" dept/title
		foreach ($entry->department as $department)
		{
			$thisDept = $department['name'];
			foreach ($department->title as $title)
			{
				$thisTitle = $title;
				break;
			}
			break;
		}

		$Zip = trim($entry->zip);
		$xmlPhone = trim($entry->phone);
		$Phone = (empty($xmlPhone))?"":preg_replace('/^/','(',str_replace('/',')',$xmlPhone));
		$Email = trim($entry->email);
		$buildingRec = explode(" ",$entry->building);
		$thisBuildingAbbrev = $buildingRec[0];

		// Mon Jul 25 10:11:29 EDT 2011 some times there are buildings that have no room no, gotta test and make sure after the explode that there is a room
		$thisRoomNo = (sizeof($buildingRec)>1)?$buildingRec[1]:"";

		$thisBuildingName = $thisBuildingID = $thisLat = $thisLon = $office = $thisGeoCode ="";
		while ($row = mysql_fetch_array($result))
		{
			$abbreviation = $row['abbreviation'];
			$name = $row['name'];
			$buildingID = $row['buildingID'];
			$LAT = $row['LAT'];
			$LNG = $row['LNG'];
			if($abbreviation == $thisBuildingAbbrev)
			{
				$thisBuildingName = $name;
				$thisBuildingID = $buildingID;
				$thisLon = $LNG;
				$thisLat = $LAT;
				$thisGeoCode = ($LNG)?$LAT.",".$LNG:null;
				$office = $thisBuildingName." ".$thisRoomNo;
				break;
			}
		}

		mysql_data_seek($result ,0);

		$arrayToPush = array
		(
			"ID" => $ID,
			"displayName" => $displayName,
			"thisTitle" => $thisTitle,
			"thisDept" => $thisDept,
			"office" => $office,
			"Campus" => "",
			"Image" => "",
			"Street" => "",
			"City" => "",
			"State" => "",
			"Zip" => $Zip,
			"thisGeoCode" => $thisGeoCode,
			"Address" => "",
			"Phone" => $Phone,
			"WorkPhone" => "",
			"MobilePhone" => "",
			"HomePhone" => "",
			"Fax" => "",
			"Email" => $Email,
			"Notes" => "",
			"URL" => $URL,
			"NameLast" => $Name_Last
		);
		array_push($proxyArray, $arrayToPush);
	}

	foreach ($proxyArray as $key => $row)
	{
		$NameLast[$key]  = $row['NameLast'];
	}

	array_multisort($NameLast, SORT_ASC, $proxyArray);
	$lastID = "";

	for($i=1;$i

Rexel Mobile App Documentation

Casey Wise — Mon, 22 Aug 2011 22:21:32 +0000

Details about the Rexel mobile app here. Made first attempt making use of the PhoneGap framework. Built originally in Android. Due to a rush to market, I hand-ported to iOS as an XCode project.

Setting GMail as default email client Xubuntu 11.04

Casey Wise — Wed, 22 Jun 2011 18:34:54 +0000

I've abandoned machine-based email clients. So many reasons to do this, but the primary being that I spend my time on 5 different machines and I don't want to maintain 5 different email programs. I've decided that GMail is the way to go. Easy enough of a transition, I just stopped using, in my case, Mozilla Thunderbird. I now head over to gmail.com for all of my emailing needs. But what happens when I click on an email address? Typically machines are configured to open up an Outlook (or Thunderbird) email composition window when you click on an address like caseymwise@gmail.com. But my machine doesn't know about GMail, right? Not so much.

As I write this, I'm using Xubuntu 11.04. Ideally when I click on an email address, I'd like for a "mail compose" GMail window to open in the Chrome browser. I did a little snooping around and figured out how to get this done. A tip of the cap to this How To Geek article that got me pretty close. Here are the steps I took to put this in place.

Tell Xubuntu that GMail is your default mail client
1. Applications > Settings > Preferred Applications
2. Under Mail Reader, select Other then enter the following replacing casey with your username:
  /home/casey/open_mailto.sh %s
Grab this shell script, unzip and save in your home folder (/home/your username).
To make the script executable fire the following on the command line:
chmod u+x ~/open_mailto.sh
Click on an email address and see if you get a notification and a new GMail compose Chrome window.
1. Bonus: the first line of the shell script, sends a note to the (for us Mac users out there) a growl-like desktop notification saying "GMailing <>." If it doesn't work for you, it's available for free in the Ubuntu repositories with a quick:
  sudo apt-get install libnotify-bin

Protected: ACT Learning Site

Casey Wise — Mon, 13 Jun 2011 21:08:56 +0000

Casey Wise

How to list directories only on the unix/linux command line

Protected: NW Dupes

Graphic Work: Ambassadors For Rebuilding

Site Work: icandothatdesign.com

Graphic & Site Work: iControl Automation

Standard PHP MySQL reporting

Employee Applications 24hr Snapshot

This report pulls the past 24 hours of employee applications submitted

".$rowCount." Applications Collected & Reported

".$countUnReported." Applications Unreported to Job Owners
This data has moved to HR's reporting tables, but the job owner hasn't been notified yet. The employeeApplication plugin is responsible for this one.
".$out_unReported."

".$countUnMoved." Applications Yet To Move
This is an application that's been submitted but hasn't been moved to HR's reporting tables and therefore unreported to the job owner as well. The plugin responsible for this one is the webFormsReporter.
".$outUnMoved."

Found ".$rowCount." instance(s) where job identification criteria capture failed

Found ".$rowCount." instance".$pluralRecords." where null records were created

Live reporting

PHP demos: iterate over XML with a MySQL recordset within

Rexel Mobile App Documentation

Setting GMail as default email client Xubuntu 11.04

Protected: ACT Learning Site

Casey Wise

How to list directories only on the unix/linux command line

Protected: NW Dupes

Graphic Work: Ambassadors For Rebuilding

Site Work: icandothatdesign.com

Graphic & Site Work: iControl Automation

Standard PHP MySQL reporting

Employee Applications 24hr Snapshot

This report pulls the past 24 hours of employee applications submitted

".$rowCount." Applications Collected & Reported

".$countUnReported." Applications Unreported to Job OwnersThis data has moved to HR's reporting tables, but the job owner hasn't been notified yet. The employeeApplication plugin is responsible for this one.".$out_unReported."

".$countUnMoved." Applications Yet To MoveThis is an application that's been submitted but hasn't been moved to HR's reporting tables and therefore unreported to the job owner as well. The plugin responsible for this one is the webFormsReporter.".$outUnMoved."

Found ".$rowCount." instance(s) where job identification criteria capture failed

Found ".$rowCount." instance".$pluralRecords." where null records were created

Live reporting

PHP demos: iterate over XML with a MySQL recordset within

Rexel Mobile App Documentation

Setting GMail as default email client Xubuntu 11.04

Protected: ACT Learning Site

".$countUnReported." Applications Unreported to Job Owners
This data has moved to HR's reporting tables, but the job owner hasn't been notified yet. The employeeApplication plugin is responsible for this one.
".$out_unReported."

".$countUnMoved." Applications Yet To Move
This is an application that's been submitted but hasn't been moved to HR's reporting tables and therefore unreported to the job owner as well. The plugin responsible for this one is the webFormsReporter.
".$outUnMoved."