Revision 6911a9c9
Von Holger Lindemann vor etwa 14 Jahren hinzugefügt
| lxo-import/contactB.php | ||
|---|---|---|
|
foreach ($zeile as $fld) {
|
||
|
$fld = strtolower(trim(strtr($fld,array("\""=>"","'"=>""))));
|
||
|
$in_fld[]=$fld;
|
||
|
if (substr($fld,0,2) == "x_") $kunde_fld[] = $fld;
|
||
|
}
|
||
|
$j=0;
|
||
|
$zeile=fgetcsv($f,2000,$trenner);
|
||
| ... | ... | |
|
$sql="insert into contacts ";
|
||
|
$keys="(";
|
||
|
$vals=" values (";
|
||
|
unset($extra);
|
||
|
$extra = array();
|
||
|
foreach($zeile as $data) {
|
||
|
$i++;
|
||
|
if (!in_array($in_fld[$i],$kunde_fld)) {
|
||
| ... | ... | |
|
} else if($in_fld[$i]=="cp_cv_id") {
|
||
|
continue;
|
||
|
}
|
||
|
if (substr($in_fld[$i],0,2)=="x_" && $data) {
|
||
|
$extra[substr($in_fld[$i],2)] = $data;
|
||
|
continue;
|
||
|
} else if ((substr($in_fld[$i],0,2)=="x_")) {
|
||
|
continue;
|
||
|
};
|
||
|
if ($in_fld[$i]==$file."number" && $data) {
|
||
|
if (!$id) {
|
||
|
$tmp=getFirma($data,$file);
|
||
| ... | ... | |
|
echo "<tr><td>".str_replace("null,","null</td><td>",$vals)."</td></tr>\n";
|
||
|
flush();
|
||
|
} else {
|
||
|
$sql.=substr($keys,0,-1).")";
|
||
|
$sql.=substr($vals,0,-1).")";
|
||
|
$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++;
|
||
|
};
|
||
| ... | ... | |
|
?>
|
||
|
<p class="listtop">Kontakt-Adressimport für die ERP</p>
|
||
|
<form name="import" method="post" enctype="multipart/form-data" action="contactB.php">
|
||
|
<input type="hidden" name="MAX_FILE_SIZE" value="300000">
|
||
|
<input type="hidden" name="MAX_FILE_SIZE" value="3000000">
|
||
|
<table>
|
||
|
<tr><td></td><td><input type="submit" name="ok" value="Hilfe"></td></tr>
|
||
|
<tr><td>Zieltabelle</td><td><input type="radio" name="ziel" value="customer" checked>customer <input type="radio" name="ziel" value="vendor">vendor</td></tr>
|
||
| lxo-import/import_lib.php | ||
|---|---|---|
|
$rs=$db->getAll($sql);
|
||
|
return $rs[0]["id"];
|
||
|
}
|
||
|
|
||
|
/**
|
||
|
* TODO: short description.
|
||
|
*
|
||
|
* @param mixed $tab
|
||
|
* @param object $own
|
||
|
* @param mixed $fld
|
||
|
* @param mixed $val
|
||
|
*
|
||
|
* @return TODO
|
||
|
*/
|
||
|
function insertExtra($tab,$own,$fld,$val) {
|
||
|
global $db;
|
||
|
$sql = "insert into extra_felder (fkey,fval,tab,owner) ";
|
||
|
$sql.= "values ('$fld','$val','$tab','$own')";
|
||
|
$rc = $db->query($sql);
|
||
|
return $rc;
|
||
|
}
|
||
|
function suchFirma($tab,$data) {
|
||
|
// gibt die Firma ?
|
||
|
global $db;
|
||
Auch abrufbar als: Unified diff
Extrafelder für Kontakte in CRM importieren