Archive for August, 2012

Collaborative Mind Mapping, Brainstorm, Design, Create MindMeister.com

Thursday, August 30th, 2012

I’m an avid user of mind maps, and recently found a google chrome app, that also is an iPhone and Droid app which allows you to create and share Mind Maps.

I’ve used xFreeMind for a long time, along with so many others, however, MindMesiter.com, is far, far, far superior,.. it’s everywhere with me, it’s something I can share with clients or work with employees on.

Enjoy

Rosetta Stone, you are amazing,.

Tuesday, August 21st, 2012

Today begins the refresher course in Spanish of the Latin American variety. We are getting ready to go back to Mexico and what better to help in those tough negotiations than being able to speak the language.

Lesson 1: remember the basics.,..

I’ll check back later

CSV to mySQL Table

Monday, August 20th, 2012

Ok, so the other day I did a php script to export any table to csv,. well I was thinking it sure would be sweet to also be able to import from csv to any table.


function csv2talbe($sourceFile,$tableName,$maxLine=1000){
global $errors;
$fileHeadings = array();
$tableHeadings = array("fields","from","import","table");
if( ($handle = fopen("$sourceFile","r") ) !== false ){
    $columns = fgetcsv($handle, $maxLine, ",");
    foreach( $columns as $col ){
        $fileHeadings[] .= $col;
    }
    $qPrefix = "insert into $targetTable (" .join(",",$tableHeadings).")\n VALUES";
    while(( $data = fgetcsv($handle, $maxLine, ",")) !== false ){
        while( count($data) < count($columns) )
            array_push($data, NULL);
        $query = "$qPrefix (".join(",",quote_all_array($data)).");";
        mysql_query($query);
        if( mysql_error() != '' ){ 
            $errors = true;
            $error_txt .= "<p>" . mysql_error() . "</p>";
        }
    }
    fclose($handle);
}

if( $errors === false ){
    $q = mysql_query("truncate {table to be updated}");
    $q = mysql_query("insert into {table to be inserted} (dateUpdated,success,failure) values(curdate(),'Success','');
    if( mysql_error() != '' ){ 
        $errors = true;
        $error_txt .= "<p>" . mysql_error() . "</p>";
    } else { 
        $q = mysql_query("insert into {updatetable} (dateUpdated,success,failure) values(curdate(),'success','');
        if( mysql_error() != '' ){ 
            $errors = true;
            $error_txt .= "<p>" . mysql_error() . "</p>";
        }
    }
}

if( $errors === true ){
    mail("youremail@yourdomain.com","your name","subject","message . $error_txt");
} else { 
    mail("youremail@yourdomain.com","your name","subject","message success");
}

function quote_all_array($values){
    foreach($values as $key=>$value)
        if( is_array($value) )
            $values[$key] = quote_all_array($value);
        else
            $values[$key] = quote_all($value);
    return $values;
}

function quote_all($value){
    if( is_null($value))
        return "NULL";

    $value = "'" . mysql_real_escape_string($value) . "'"; 
    return $value;
}

// and that pretty much does it...

Export mySql Table to CSV using fputcsv and php

Friday, August 17th, 2012

This is a great little mysql table to csv script I use to create a backup file of any table within a db.


$headings = array();
$q = mysql_query("select * from {table_name} where {conditions} ); 
for( $f=0; $f<mysql_num_fields($q); $f++ ){
        $headings[] .= mysql_field_name($q,$f);
}
$tableFile = "/path/to/bak/files/" . "filename_" . date("ymd") . ".csv", 'w');
        while( $row = mysql_fetch_array( $q ) ){
                $vals = array();
                foreach( $headings as $h ){
                        $vals[] .= $row[($h)];
                }
                fputcsv($tableFile,$vals);
                unset($vals);
        }
fclose($tableFile);

Basically you just decide on the path, and the table to export, then you can set a nice crons sript to run it via php, or grab it from the web whenever you need.

New Chevy Volt – 3 to choose from

Thursday, August 16th, 2012

After cruising around the new Tyler Chevy Cadillac website, I have noticed that they have three Chevrolet Volt’s available, I thought these where sold out everywhere.

Looking for a Chevy Volt, take a look at Tyler http://www.TylerChevroletCadillac.com/chevrolet-volt.html

New and Used Chevy Cadillac in SW Michigan

Thursday, August 16th, 2012

Tyler Automotive has done more to help consumers in their area find the right vehicle.

They’ve worked hard to develop another website, this time for New Cadillac Cars trucks and suvs, along with Chevrolet Vehicles.

So if you need a new Chevy Spark, Volt or Corvette take a look at the beautiful new site http://www.tylerChevroletCadillac.com you will not be disappointed.

Chrysler Cars available in Niles, MI from Tyler Auto

Thursday, August 16th, 2012

Looking for a new chrysler, new dodge, new jeep or a used car, truck or suv; you’ve found the right place.

Recently I had the opportunity to work with Tyler Chrysler, Dodge, Jeep, Ram and I have to say they are a great dealership to work with.

There is a great selection of new and used vehicles, and they’ve just launched a new website.

Ann Arbor, Dunning Toyota

Tuesday, August 7th, 2012

Who can say how this all started, and when, but the feud goes back for generations.

For as long as I can remember, Dunning Toyota and I have been discussing the possibility of buying a car. Of course, I have since purchased a new Scion FR-S from Spartan Toyota in Lansing, MI but the feud continues.

Really I want to see this post on page one, but we will see where we can get. If you are looking for new or used cars including Used Toyota in Ann Arbor, or a New Toyota in Michigan then you should make the drive to Spartan Toyota in Lansing.