Hallo,
ich habe den Isemann Converter für Amazon runtergeladen, nur leider funktioniert er nicht richtig.
Wenn ich die Datei öffne, sieht sie so aus:
Amazon Datei: JTL Wawi Converter 1.0 * ====================================================================== * * Copyright (c) 2008 by Marc Isemann * SourceForge.net: Solunas Hotel Booking Engine * Marc Isemann Blog * * This program is free software. You can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License. ************************************************************************ */ error_reporting(0); $calc = 1; $base_dir = "/jtl-importer"; $uploaddir = $_SERVER["DOCUMENT_ROOT"].$base_dir.'/amazon_import/'; $uploadfile = $uploaddir. $_FILES['userfile']['name']; print "";
if (move_uploaded_file($_FILES['userfile']['tmp_name'], $uploadfile)) {
print "File is valid, and was successfully uploaded.";
print "Here's some more debugging info:\n";
print_r($_FILES);
}
print ""; print "
LOG:
"; require($_SERVER["DOCUMENT_ROOT"].$base_dir.'/smarty/libs/Smarty.class.php'); $smarty = new Smarty(); $smarty->template_dir = $_SERVER["DOCUMENT_ROOT"].$base_dir.'/smarty/templates'; $smarty->compile_dir = $_SERVER["DOCUMENT_ROOT"].$base_dir.'/smarty/templates_c'; $smarty->cache_dir = $_SERVER["DOCUMENT_ROOT"].$base_dir.'/smarty/ cache'; $smarty->config_dir = $_SERVER["DOCUMENT_ROOT"].$base_dir.'/smarty/configs'; $handle = fopen ($uploadfile,"r"); $row=0; while ( ($data = fgetcsv ($handle, 1000, "\t")) !== FALSE ) { if($row>0){ //Stamm $order[$data[0]]["ORDERID"] = $data[0]; $order[$data[0]]["PURCHASE_DATE"] = $data[2]; $order[$data[0]]["PAYMENT_DATE"] = $data[3]; $order[$data[0]]["TOTAL"] = $order[$data[0]]["TOTAL"] + $data[11] + $data[13]; $order[$data[0]][" SHIPPING"] = $order[$data[0]]["SHIPPING"] + $data[13]; //Kunde $order[$data[0]]["kunde"]["EMAIL"] = $data[4]; $order[$data[0]]["kunde"]["NAME"] = $data[18]; $order[$data[0]]["kunde"]["FON"] = $data[24]; if($data[20]!=""){ $order[$data[0]]["kunde"]["FIRMA"] = $data[19]; $order[$data[0]]["kunde"]["STRASSE"] = $data[20]; } else { $order[$data[0]]["kunde"]["FIRMA"] = ""; $order[$data[0]]["kunde"]["STRASSE"] = $data[19]; } $order[$data[0]]["kunde"]["PLZ"] = $data[24]; $order[$data[0]]["kunde"]["ORT"] = $data[22]; //Kunde LAND if($data[23] =="DE") $country="Deutschland"; if($data[23] == "AT") $country="Österreich"; $order[$data[0]]["kunde"]["LAND"] = $country; //schreibe artikelnummer in temp array $product[artikelnr] = $data[7]; $product[qty] = $data[9]; $product[price] = $data[11] / $data[9]; $product[name] = $data[8]; $product[shipping] = $data[13]; //Produkte $order[$data[0]]["produkte"][] = $product; } $row++; } $smarty->assign('ORDERS', $order); $output = $smarty->fetch($_SERVER["DOCUMENT_ROOT"].$base_dir.'/amazon_vorlage.xml'); $handle2 = fopen($_SERVER["DOCUMENT_ROOT"].$base_dir."/amazon_export/jtl_order_amazon.xml", "w"); if (fwrite($handle2, $output) === FALSE) { echo "Cannot write to file!"; exit; } else { echo "File jtl_order_amazon.xml geschrieben.
"; } fclose ($handle); ?>
Könnte mir jemand helfen wie ich richtig vorgehen sollte, damit ich den Converter richtig nutzen kann?
Ich danke im vorraus.
mfg
ich habe den Isemann Converter für Amazon runtergeladen, nur leider funktioniert er nicht richtig.
Wenn ich die Datei öffne, sieht sie so aus:
Amazon Datei: JTL Wawi Converter 1.0 * ====================================================================== * * Copyright (c) 2008 by Marc Isemann * SourceForge.net: Solunas Hotel Booking Engine * Marc Isemann Blog * * This program is free software. You can redistribute it and/or modify * it under the terms of the GNU General Public License as published by * the Free Software Foundation; either version 2 of the License. ************************************************************************ */ error_reporting(0); $calc = 1; $base_dir = "/jtl-importer"; $uploaddir = $_SERVER["DOCUMENT_ROOT"].$base_dir.'/amazon_import/'; $uploadfile = $uploaddir. $_FILES['userfile']['name']; print "";
if (move_uploaded_file($_FILES['userfile']['tmp_name'], $uploadfile)) {
print "File is valid, and was successfully uploaded.";
print "Here's some more debugging info:\n";
print_r($_FILES);
}
print ""; print "
LOG:
"; require($_SERVER["DOCUMENT_ROOT"].$base_dir.'/smarty/libs/Smarty.class.php'); $smarty = new Smarty(); $smarty->template_dir = $_SERVER["DOCUMENT_ROOT"].$base_dir.'/smarty/templates'; $smarty->compile_dir = $_SERVER["DOCUMENT_ROOT"].$base_dir.'/smarty/templates_c'; $smarty->cache_dir = $_SERVER["DOCUMENT_ROOT"].$base_dir.'/smarty/ cache'; $smarty->config_dir = $_SERVER["DOCUMENT_ROOT"].$base_dir.'/smarty/configs'; $handle = fopen ($uploadfile,"r"); $row=0; while ( ($data = fgetcsv ($handle, 1000, "\t")) !== FALSE ) { if($row>0){ //Stamm $order[$data[0]]["ORDERID"] = $data[0]; $order[$data[0]]["PURCHASE_DATE"] = $data[2]; $order[$data[0]]["PAYMENT_DATE"] = $data[3]; $order[$data[0]]["TOTAL"] = $order[$data[0]]["TOTAL"] + $data[11] + $data[13]; $order[$data[0]][" SHIPPING"] = $order[$data[0]]["SHIPPING"] + $data[13]; //Kunde $order[$data[0]]["kunde"]["EMAIL"] = $data[4]; $order[$data[0]]["kunde"]["NAME"] = $data[18]; $order[$data[0]]["kunde"]["FON"] = $data[24]; if($data[20]!=""){ $order[$data[0]]["kunde"]["FIRMA"] = $data[19]; $order[$data[0]]["kunde"]["STRASSE"] = $data[20]; } else { $order[$data[0]]["kunde"]["FIRMA"] = ""; $order[$data[0]]["kunde"]["STRASSE"] = $data[19]; } $order[$data[0]]["kunde"]["PLZ"] = $data[24]; $order[$data[0]]["kunde"]["ORT"] = $data[22]; //Kunde LAND if($data[23] =="DE") $country="Deutschland"; if($data[23] == "AT") $country="Österreich"; $order[$data[0]]["kunde"]["LAND"] = $country; //schreibe artikelnummer in temp array $product[artikelnr] = $data[7]; $product[qty] = $data[9]; $product[price] = $data[11] / $data[9]; $product[name] = $data[8]; $product[shipping] = $data[13]; //Produkte $order[$data[0]]["produkte"][] = $product; } $row++; } $smarty->assign('ORDERS', $order); $output = $smarty->fetch($_SERVER["DOCUMENT_ROOT"].$base_dir.'/amazon_vorlage.xml'); $handle2 = fopen($_SERVER["DOCUMENT_ROOT"].$base_dir."/amazon_export/jtl_order_amazon.xml", "w"); if (fwrite($handle2, $output) === FALSE) { echo "Cannot write to file!"; exit; } else { echo "File jtl_order_amazon.xml geschrieben.
"; } fclose ($handle); ?>
Könnte mir jemand helfen wie ich richtig vorgehen sollte, damit ich den Converter richtig nutzen kann?
Ich danke im vorraus.
mfg