email = line.get("EMAIL"), telefon = line["TELE1"], fax = line.get("FAX"), mobile = line.get("FUNK"), ) person.save() #print person elif gruppe == 2: pprint(line) firma = Firma( name1 = line["NAME1"], name2 = line["NAME2"], strasse = line["STRASSE"], plz = int(line["PLZ"]), ort = ort, internet = line.get("INTERNET"), email = line.get("EMAIL"), telefon = line["TELE1"], fax = line.get("FAX"), mobile = line.get("FUNK"), ) firma.save() continue print "-"*79 print "gruppe:", gruppe, type(gruppe) print n print line["NAME1"] print "-"*79
def get_kunden_obj(self, line): if line['spezielle Adresszeile']: daten = line['spezielle Adresszeile'].split("\n") self.stdout.write("*" * 79) self.stdout.write("\n") for no, l in enumerate(daten): self.stdout.write("%s %s\n" % (no, l)) plz, ort_name = daten[4].split(" ", 1) self.stdout.write("*" * 79) self.stdout.write("\n") ort = Ort(name=ort_name, land="Frankreich") ort.save() reversion.revision.comment = "KRB import" firma = Firma( name1=daten[0], strasse=daten[2], strassen_zusatz=daten[3], plz=int(plz), ort=ort, ) firma.save() reversion.revision.comment = "KRB import" person = Person( vorname="Thorsten", nachname="Beitzel", geschlecht="M", ) person.save() reversion.revision.comment = "KRB import" return person, firma orts_name = line["Ort"] if orts_name: ort, created = Ort.objects.get_or_create(name=orts_name) if created and self.verbosity >= 3: self.stdout.write("Ort erstellt: %s\n" % ort) elif self.verbosity >= 3: self.stdout.write("Vorhanden Ort genutzt: %s\n" % ort) else: ort = None try: person = Person.objects.get( vorname=line["Vorname"], nachname=line["Name"], ) except Person.DoesNotExist: plz = line.get("PLZ") if plz == "": plz = None person = Person( vorname=line["Vorname"], nachname=line["Name"], geschlecht=line["G."], strasse=line["Strasse"], plz=plz, ort=ort, email=line["Email"], telefon=line["Telefon"], #mobile = ) # add_message(person, "KRB import") person.save() reversion.revision.comment = "KRB import" if line["Firma"] != "": firma, created = Firma.objects.get_or_create( name1=line["Firma"], defaults={ "name2": line["Volle Firmenbezeichnung"], "internet": line["Homepage"], "email": line["Email"], "strasse": line["Strasse"], "telefon": line["Telefon"], "fax": line["Fax"], #"strassen_zusatz"=daten[3], "plz": int(line["PLZ"]), "ort": ort, } ) if created: self.stdout.write("neue Firma erstellt: %s\n" % firma) else: self.stdout.write("Vorhandene Firma genutzt: %s\n" % firma) firma.save() createtime = datetime.strptime(line["Eintritt"], "%d.%m.%y") firma.createtime = createtime firma.save() else: firma = None return person, firma