"; echo "Feldname => Bedeutung
"; foreach($shiptos as $key=>$val) { echo "$key => $val
"; } exit(0); }; if (!$_SESSION["db"]) { $conffile="../config/authentication.pl"; if (!is_file($conffile)) { ende(4); } } require ("import_lib.php"); if (!anmelden()) ende(5); /* get DB instance */ $db=$_SESSION["db"]; //new myDB($login); $crm=checkCRM(); if ($_POST["ok"] == "Import") { $test=$_POST["test"]; $shipto_fld = array_keys($shiptos); $shipto=$shiptos; $nun=time(); clearstatcache (); $trenner=($_POST["trenner"])?$_POST["trenner"]:","; if (!empty($_FILES["Datei"]["name"])) { $file=$_POST["ziel"]; if (!move_uploaded_file($_FILES["Datei"]["tmp_name"],$file."_shipto.csv")) { $file=false; echo "Upload von ".$_FILES["Datei"]["name"]." fehlerhaft. (".$_FILES["Datei"]["error"].")
"; } } else if (is_file($_POST["ziel"]."_shipto.csv")) { $file=$_POST["ziel"]; } else { $file=false; } if (!$file) ende (2); if (!file_exists($file."_shipto.csv")) ende(5); $employee=chkUsr($_SESSION["employee"]); if (!$employee) ende(4); if (!$db->chkcol($file)) ende(6); $f=fopen($file."_shipto.csv","r"); $zeile=fgetcsv($f,1000,$trenner); $first=true; foreach ($zeile as $fld) { $fld = strtolower(trim(strtr($fld,array("\""=>"","'"=>"")))); $in_fld[]=$fld; } $j=0; $prenumber=$_POST["prenumber"]; $zeile=fgetcsv($f,1000,$trenner); while (!feof($f)){ $i=-1; $firma=""; $name=false; $id=false; $sql="insert into shipto "; $keys="("; $vals=" values ("; foreach($zeile as $data) { $i++; if (!in_array($in_fld[$i],$shipto_fld)) { continue; } $data=addslashes(trim($data)); if ($in_fld[$i]=="trans_id" && $data) { $data=chkKdId($data); if (!$id) $id = $data; continue; } else if ($in_fld[$i]=="trans_id") { continue; } if ($in_fld[$i]==$file."number" && $data) { $tmp=getFirma($data,$file); if ($id<>$tmp) $id=$tmp; continue; } else if ($in_fld[$i]==$file."number") { continue; } if ($in_fld[$i]=="firma") { if ($id) continue; $data=suchFirma($file,$firma); if ($data) { $id=$data["cp_cv_id"]; } continue; } $keys.=$in_fld[$i].","; if ($data==false or empty($data) or !$data) { $vals.="null,"; } else { if (in_array($in_fld[$i],array("cp_fax","cp_phone1","cp_phone2"))) { $data=$prenumber.$data; } else if ($in_fld[$i]=="cp_country" && $data) { $data=mkland($data); } if ($in_fld[$i]=="cp_name") $name=true; $vals.="'".$data."',"; // bei jedem gefuellten Datenfeld erhoehen $val_count++; } } // if (!$name) { // $zeile=fgetcsv($f,1000,$trenner); // continue; // } if ($keys<>"(" && $id) { $vals.=$id.",'CT'"; $keys.="trans_id,module"; if ($test) { if ($first) { echo "\n"; echo "\n"; $first=false; }; $vals=str_replace("',","'\n"; flush(); } else { $sql.=$keys.")"; $sql.=$vals.")"; $rc=$db->query($sql); if (!$rc) echo "Fehler: ".$sql."\n"; } $j++; } else { echo $keys."
"; echo $vals."
"; }; $zeile=fgetcsv($f,1000,$trenner); } fclose($f); echo $j." $file importiert.\n";} else { ?>

Lieferanschriftimport für die ERP

".str_replace(",","",substr($keys,1,-1))."
",$vals); echo "
".str_replace("null,","null",$vals)."
Zieltabellecustomer vendor
Trennzeichen
Telefonvorwahl
Testja
Daten