\n";
echo "".str_replace(","," | ",substr($keys,1,-1))." |
\n";
$first=false;
};
$vals=str_replace("',","'",substr($vals,9,-1));
echo " | ".str_replace("null,","null | ",$vals)." |
\n";
flush();
} else {
$newID=uniqid (rand());
$now = date('Y-m-d H:i').":1.$j";
$sql.= $keys."mtime)";
$sql.= $vals."'$now')";
$rc=$db->query($sql);
if (!$rc) echo "Fehler: ".$sql."\n";
$rs = $db->getAll("select cp_id,cp_name from contacts where mtime = '$now'");
$cp_id = $rs[0]["cp_id"];
echo "(".$rs[0]["cp_name"].":$cp_id)".count($extra).";";
if (count($extra)>0 and $cp_id) {
foreach ($extra as $fld=>$val) {
$rc = insertExtra("P",$cp_id,$fld,$val);
}
}
}
$j++;
};
$zeile=fgetcsv($f,1200,$trenner);
}
fclose($f);
echo $j." $file importiert.\n";} else {
?>
Kontakt-Adressimport für die ERP