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
