function chkKdId($data)
{
// gibt es die Nummer schon?
global $db, $file, $test;
$sql = "select * from {$file} where " . $file . "number = '{$data}'";
$rs = $db->getAll($sql);
if ($rs[0][$file . "number"] == $data) {
// ja, eine neue holen
return getKdId();
} else {
return $data;
}
}
} else {
if ($in_fld[$i] == "contact") {
if ($anrede) {
$vals .= "'{$anrede} {$data}',";
} else {
$vals .= "'{$data}',";
}
} else {
$vals .= "'" . $data . "',";
}
}
$i++;
}
if (!$number) {
$keys .= $file . "number,";
$vals .= "'" . getKdId() . "',";
}
if ($keys != "(") {
if ($test) {
if ($first) {
echo "<table border='1'>\n";
echo "<tr><th>" . str_replace(",", "</th><th>", substr($keys, 1, -1)) . "</th></tr>\n";
$first = false;
}
$vals = str_replace("',", "'</td><td>", substr($vals, 9, -1));
echo "<tr><td>" . str_replace("null,", "null</td><td>", $vals) . "</td></tr>\n";
//echo "Import $j<br>\n";
flush();
} else {
$sql .= $keys . "taxzone_id,import)";
$sql .= $vals . "0,{$nun})";
