X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=lxo-import%2Fimport_lib.php;h=72f3ae39de2930d0737c557937edf0c85f2dc44d;hb=84bed7a655edfe816ad2a04b5549b6bd6a968c79;hp=89ca76f20ba17b4577f31d77e29594f814481a0c;hpb=c25cb4622b88c268878dc814d4b8487584315fe7;p=kivitendo-erp.git

diff --git a/lxo-import/import_lib.php b/lxo-import/import_lib.php
index 89ca76f20..72f3ae39d 100644
--- a/lxo-import/import_lib.php
+++ b/lxo-import/import_lib.php
@@ -31,19 +31,21 @@ $address = array(
 	"customernumber" => "Kundennummer",
 	"vendornumber" => "Lieferantennummer",
 	"taxnumber" => "Steuernummer",
+	"ustid" => "Umsatzsteuer-ID",
 	"account_number" => "Kontonummer",
 	"bank_code" => "Bankleitzahl",
 	"bank" => "Bankname",
 	"branche" => "Branche",
-	"language" => "Sprache (de,en,fr)",
+	//"language" => "Sprache (de,en,fr)",
 	"sw" => "Stichwort",
-	"creditlimit" => "Kreditlimit (nnnnnn.nn)",
+	"creditlimit" => "Kreditlimit (nnnnnn.nn)"); /*,
 	"hierarchie" => "Hierarchie",
 	"potenzial" => "Potenzial",
         "ar" => "Debitorenkonto",
         "ap" => "Kreditorenkonto",
         "matchcode" => "Matchcode",
-	"customernumber2" => "Kundennummer 2");
+	"customernumber2" => "Kundennummer 2"); 
+	Kundenspezifisch */
         
 $shiptos = array(
 	"shiptoname" => "Firmenname",
@@ -64,41 +66,57 @@ $parts = array(
 	"partnumber" => "Artikelnummer",
 	"description" => "Artikeltext",
 	"unit" => "Einheit",
-	"weight" => "Gewicht (kg)",
+	"weight" => "Gewicht in Benutzerdefinition",
 	"onhand" => "Lagerbestand",
 	"notes" => "Beschreibung",
 	"makemodel" => "Hersteller",
 	"model" => "Modellbezeichnung",
-	"income_accno_id" => "Erlöskonto",
-	"expense_accno_id" => "Konto Umsatzkosten",
 	"bin" => "Lagerort",
 	"image" => "Pfad/Dateiname",
 	"drawing" => "Pfad/Dateiname",
 	"microfiche" => "Pfad/Dateiname",
-	"partsgroup_id" => "Name Warengruppe",
 	"listprice" => "Listenpreis",
 	"sellprice" => "Verkaufspreis",
 	"lastcost" => "letzter EK",
-	"art" => "Ware/Dienstleistung (*/d)");
+	"art" => "Ware/Dienstleistung (*/d), muß vor den Konten kommen",
+	"inventory_accno" => "Bestandskonto",
+	"income_accno" => "Erlöskonto",
+	"expense_accno" => "Konto Umsatzkosten",
+	"obsolete" => "Gesperrt (Y/N)",
+	"lastcost" => "letzer EK-Preis",
+	"rop" => "Mindestbestand",
+	"shop" => "Shopartikel (Y/N)",
+	"assembly" => "Stückliste (Y/N); wird noch nicht unterstützt",
+	"partsgroup" => "Warengruppenbezeichnung",
+	//"income_accno_0" => "?Nummer? für Erlöse Inland",
+	//"income_accno_1" => "?Nummer? für Erlöse EG",
+	//"income_accno_3" => "?Nummer? für Erlöse Ausland",
+	);
 	
 $contactscrm = array(
 	"customernumber" => "Kundennummer",
 	"vendornumber" => "Lieferantennummer",
 	"cp_cv_id" => "FirmenID in der db",
 	"firma" => "Firmenname",
+	"cp_abteilung" => "Abteilung",
+	"cp_position" => "Position/Hierarchie",
 	"cp_greeting" => "Anrede",
 	"cp_title" => "Titel",
 	"cp_givenname" => "Vorname",
-	"cp_greeting" => "Anrede",
 	"cp_name" => "Nachname",
 	"cp_email" => "eMail",
 	"cp_phone1" => "Telefon 1",
 	"cp_phone2" => "Telefon 2",
+	"cp_mobile1" => "Mobiltelefon 1",
+	"cp_mobile2" => "Mobiltelefon 2",
+	"cp_homepage" => "Homepage",
 	"cp_street" => "Strasse",
+	"cp_country" => "Land",
 	"cp_zipcode" => "PLZ",
 	"cp_city" => "Ort",
+	"cp_privatphone" => "Privattelefon",
+	"cp_privatemail" => "private eMail",
 	"cp_notes" => "Bemerkungen",
-	"cp_country" => "Land",
 	"cp_stichwort1" => "Stichwort(e)",
 	"katalog" => "Katalog",
 	"inhaber" => "Inhaber",
@@ -118,6 +136,11 @@ $contacts = array(
 	"cp_email" => "eMail",
 	"cp_phone1" => "Telefon 1",
 	"cp_phone2" => "Telefon 2",
+	"cp_mobile1" => "Mobiltelefon 1",
+	"cp_mobile2" => "Mobiltelefon 2",
+	"cp_privatphone" => "Privattelefon",
+	"cp_privatemail" => "private eMail",
+	"cp_homepage" => "Homepage",
 	"katalog" => "Katalog",
 	"inhaber" => "Inhaber",
 	"contact_id" => "Kontakt ID"
@@ -251,6 +274,12 @@ global $db;
 	}
 }
 
+function getAllBG($db) {
+	$sql  = "select * from buchungsgruppen order by description";
+	$rs=$db->getAll($sql);
+	return $rs;
+}
+
 class myDB extends DB {
 // Datenbankklasse