Magento: Origins

 
<?php
 
/**********************************************
// import CMS pages script
// for Magento 1.5.x
// input - CSV file
 
// this is doing some direct mysql queries as nothing is available via dataflow / api
**********************************************/
 
// database information
mysql_connect('localhost','root','');
mysql_select_db('');
 
if(mysql_error()){die(mysql_error());}
 
// up the memory depending about 
ini_set('memory_limit', '32M');
 
/**
 * Class to import CMS pages
 *
 * @category    Mage
 * @package     Magento Import Scripts
 * @author      Douglas Radburn @ Branded3 (http://www.branded3.com)
 */
class MagentoCMSImport {
 
	public function __construct($filename)
	{
		// set the filename of the CSV we're going to import
		$this->filename = $filename;
		// set the prefix for the database
		$this->prefix = 'dq_';
	}
 
	/**
	 * Parse CSV file
	 * @return none
	 */
	public function readInput()
	{
		if($file = fopen($this->filename, 'r'))
		{
			while (($line = fgetcsv($file)) !== FALSE)
			{
				$count++;
				list($title, $content, $meta_keywords, $meta_description) = $line;
 
				$data['title'] = $title;
				$data['root_template'] = 'one_column';
				$data['meta_keywords'] = $meta_keywords;
				$data['meta_description'] = $meta_description;
				$data['identifier'] = $this->seoSafe($title);
				$data['content'] = $content;
 
				$this->createCMS($data);
				sleep(0.5);
			}
		}
		else
		{
			die('A file was specified, but the file could not be opened.');
		}
	}
	// end of readInput
 
	/**
	 * Create a new CMS entry in the database
	 *
	 * @param array $data
	 * @return none
	 */
	private function createCMS($data)
	{		
 
		$sql = "INSERT INTO " . $this->prefix . "cms_page SET
		title = '" . addslashes($data['title']) . "',
		root_template = '" . $data['root_template'] . "',
		meta_keywords = '" . addslashes($data['meta_keywords']) . "',
		meta_description = '" . addslashes($data['meta_description']) . "',
		identifier = '" . $data['identifier'] . "',
		content = '" . addslashes($data['content']) . "',
		creation_time = NOW(),
		update_time = NOW()";
 
 
		try {
			mysql_query($sql) or die('Sorry, an error occured doing some sql. ' . mysql_error() . ' ' . $sql);
			$id = mysql_insert_id();
			mysql_query("INSERT INTO " . $this->prefix . "cms_page_store SET 
						page_id = '" . $id . "',
						store_id = '0'") or die(mysql_error());
			}
		catch (Exception $e) {
			echo '<p>Sorry, error occured while trying to save the attribute "' . $label . '" Error: '.$e->getMessage().'</p>';
		}
	}
 
	/**
	*
	* seoSafe() takes a string and returns a URL-safe version of it
	*
	* @param string $str The string to clean
	* return string Cleaned string
	*/
	function seoSafe($str) { 
 
		$str = strtolower($str);
 
		$allowed_chars = array("a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p",
		"q","r","s","t","u","v","w","x","y","z","1","2","3","4","5","6","7","8","9","0","-","_", ".");
 
		$len = strlen($str);
 
		$new_str = "";
 
		// we'll allow spaces, but replace them with - so we know what we're doing
		$str = str_replace(" ", "-", $str);
 
		for($i=0; $i<=$len-1; $i++) { 
			if(in_array($str[$i], $allowed_chars)) {
				$new_str.= $str[$i];
			}
		}
 
		return $new_str;
 
	}
 
}
 
 
 
$filename = './import_cms.csv';
 
if($filename != '')
{
	// magento import categories
	$MagentoCMS = new MagentoCMSImport($filename);
	// go read the file, and import all the pages
	$MagentoCMS->readInput();
}
else
{
	echo 'No filename has been suggested.  Please enter a filename.';
}
?>