migrateCustomer.php

<?php

header('content-type: text/html; charset=utf-8');

$path = '';
require_once($path . '/app/Mage.php');
Mage::app()->setCurrentStore(Mage_Core_Model_App::ADMIN_STORE_ID);

$websiteId = 1;

$my_host = 'localhost';
$my_user = '';
$my_pass = '';
$my_db = '';
$my_customer_col = '';

/*
 *
 * +---------+--------------+------+-----+---------+-------+
 * | Field   | Type         | Null | Key | Default | Extra |
 * +---------+--------------+------+-----+---------+-------+
 * | oknr    | varchar(25)  | NO   |     | 0       |       |
 * | knr     | varchar(25)  | NO   | PRI | 0       |       |
 * | sID     | varchar(255) | NO   |     |         |       |
 * | uIP     | varchar(255) | NO   |     |         |       |
 * | rec70   | varchar(100) | NO   |     |         |       |
 * | ktype   | varchar(15)  | NO   |     |         |       |
 * | anrede  | varchar(12)  | NO   |     |         |       |
 * | name    | varchar(40)  | NO   |     |         |       |
 * | vname   | varchar(40)  | NO   |     |         |       |
 * | user    | varchar(20)  | NO   |     |         |       |
 * | userdir | varchar(255) | NO   |     |         |       |
 * | pw      | varchar(20)  | NO   |     |         |       |
 * | firma   | varchar(30)  | NO   |     |         |       |
 * | mail    | varchar(120) | NO   |     |         |       |
 * | adresse | varchar(120) | NO   |     |         |       |
 * | plz     | varchar(8)   | NO   |     |         |       |
 * | ort     | varchar(60)  | NO   |     |         |       |
 * | tel_m   | varchar(35)  | NO   |     |         |       |
 * | tel_f   | varchar(35)  | NO   |     |         |       |
 * | ustid   | varchar(15)  | NO   |     |         |       |
 * | FA_fax  | varchar(35)  | NO   |     |         |       |
 * | FA_web  | varchar(60)  | NO   |     |         |       |
 * | FA_gew  | varchar(100) | NO   |     |         |       |
 * | probe   | varchar(10)  | NO   |     |         |       |
 * | reg     | varchar(15)  | NO   |     |         |       |
 * | land    | varchar(40)  | NO   |     | 0       |       |
 * | newslt  | varchar(15)  | NO   |     |         |       |
 * +---------+--------------+------+-----+---------+-------+
 *
 */

if( !mysql_connect($my_host, $my_user, $my_pass) ) {
	die('Verbindung gescheitert! ' . mysql_error());
}

if ( !mysql_select_db($my_db) ) {
	die('Kann die Datenbank nicht auswählen! ' . mysql_error());
}

$query = "SELECT vname, name, pw, mail, firma, adresse, plz, ort, land, newslt FROM " . $my_customer_col;
$result = mysql_query($query);

if ( !$result ) {
	die('Ungültige Abfrage: ' . mysql_error());
}

while ( $old_user = mysql_fetch_assoc($result, MYSQL_NUM) ) {
	$vorname = $old_user['vname'];
	$nachname = $old_user['name'];
	$passwort = $old_user['pw'];
	$mail = $old_user['mail'];
	if ($old_user['firma'] != '')
		$firma = $old_user['firma'];
	$adresse = $old_user['adresse'];
	$plz = $old_user['plz'];
	$ort = $old_user['ort'];
	$land = $old_user['land']; 

	$customer = Mage::getModel('customer/customer');
	$customer->setWebsiteId($websiteId);
	$customer->loadByEmail($mail);
	
	if( !$customer->getId() ) {
		$customer->setEmail($mail);
		$customer->setFirstname($vorname);
		$customer->setLastname($nachname);
		$customer->setPassword($passwort);
	}
	
	try {
		$customer->setConfirmation(null);
		$customer->save();
	} catch (Exception $e) {
		Zend_Debug::dump($e->getMessage());
	}
	
	//$NewsletterSubcribtion = Mage::getModel('newsletter/subscriber');
	//$NewsletterSubcribtion->setStatus(1);
	//$NewsletterSubcribtion->subscribeCustomer($customer->getId());
	
	$_custom_address = array (
		'firstname' => $vorname,
		'lastname' => $nachname,
		'street' => array (
			'0' => $adresse,
			'1' => '',
		),
 
	'city' => $ort,
	'region_id' => '',
	'region' => '',
	'postcode' => $plz,
	'country_id' => '', 
	'telephone' => '',
);
	
	$customAddress = Mage::getModel('customer/address')
	$customAddress->setData($_custom_address)
			->setCustomerId($customer->getId())
			->setIsDefaultBilling('1')
			->setIsDefaultShipping('1')
			->setSaveInAddressBook('1');
 
	try {
		$customAddress->save();
	}
	catch (Exception $e) {
		Zend_Debug::dump($e->getMessage())
	}
	
?>