<?php
 
$file1 = "/home/mywebsite/public_html/tools/import.txt"; 
$lines = file($file1);
$businesses = array();
 
// loop through csv and collect/filter data
foreach($lines as $line)
{
   $result = explode("\t", $line);
   array_shift($result);
    $name = trim($result[0], '"');
    $name = ucwords(strtolower($name));    
    $website = $result[10];
    $email = $result[9];
 
    $businesses[] = array(
    'name'=>$name, 
    'contact_name'=>ucwords(strtolower($result[2] . ' ' .$result[1])), 
    'street_address'=>trim($result[3], '"'), 
    'city'=>trim($result[4]), 
    'state'=>trim($result[5]),
    'zip'=>trim($result[6]),
    'phone'=>trim($result[7]),
    'fax'=>trim($result[8]), 
    'website'=>strtolower(trim($website)), 
    'email'=>trim($email)
    );
}  
 
?>
 
<pre>
<?php
  // don't want the first row of the csv. 
  array_shift($businesses);
 
  // get the parent page, where you want to create the new pages
  $parentpage = Page::getByPath('/builders');
 
  // get the type of page you want the new ones to be 
  $collection_type = CollectionType::getByHandle('listing');
 
  foreach($businesses as $b) {
 
    $data['name'] = $b['name'];   
    $data['cDescription'] = $b['description'];
 
    $newpage = $parentpage->add($collection_type, $data);
    $newpage->setAttribute('contact_name',$b['contact_name']);
    $newpage->setAttribute('street_address',$b['street_address']);
    $newpage->setAttribute('city',$b['city']);
    $newpage->setAttribute('state',$b['state']);
    $newpage->setAttribute('zip',$b['zip']);
    $newpage->setAttribute('phone',$b['phone']);
    $newpage->setAttribute('fax',$b['fax']);
    $newpage->setAttribute('website',$b['website']);
    $newpage->setAttribute('email',$b['email']);
 
    // just outputting each set of data to see what was parsed
     print_r($b);
 
  }
?>
</pre>