Beispiel #1
0
def import_durs_fo(filename):
    with open(filename) as f:
        lines = f.readlines()

    for line in lines:
        davcna_stevilka = line[2:9]
        ime_priimek = line[11:72].strip()
        if settings.DEBUG:
            print("ime priimek: |%s|" % (ime_priimek))

        __naslov = line[72:184].split(',')
        naslov = __naslov[0].strip()
        if settings.DEBUG:
            print("naslov: |%s|" % (naslov))

        postna_stevilka = ""
        posta = ""

        if naslov != "":
            postna_stevilka = regex.findall(r'\d+', __naslov[-1])

            if len(postna_stevilka) > 0:
                postna_stevilka = postna_stevilka[0]
                posta = __naslov[1].replace(postna_stevilka, "").strip()

                if settings.DEBUG:
                    print("posta: |%s|" % (posta))
                    print("postna stevilka: |%s|" % (postna_stevilka))

        try:
            contact_registry = ContactRegistry.objects.get(vat=davcna_stevilka)
            contact_registry.first_name = ime_priimek.split(" ")[0]
            contact_registry.last_name = ime_priimek.split(" ")[1]
            contact_registry.street_address = naslov.decode("utf-8", "replace")
            contact_registry.postcode = postna_stevilka
            contact_registry.city = posta
            contact_registry.country = "SI"
            contact_registry.vat = davcna_stevilka
            contact_registry.save()
        except ContactRegistry.DoesNotExist:
            contact_registry = ContactRegistry(
                type=g.CONTACT_TYPES[0][0],
                first_name=ime_priimek.split(" ")[0],
                last_name=ime_priimek.split(" ")[1],
                street_address=naslov.decode("utf-8", "replace"),
                postcode=postna_stevilka,
                city=posta,
                country="SI",
                vat=davcna_stevilka
            )
            contact_registry.save()
Beispiel #2
0
def import_durs_po(filename):
    with open(filename) as f:
        lines = f.readlines()

    for line in lines:
        davcni_zavezanec = line[0:3]
        if "*" in davcni_zavezanec:
            davcni_zavezanec = "yes"
        else:
            davcni_zavezanec = "no"

        if settings.DEBUG:
            print("davcni zavezanec: |%s|" % (davcni_zavezanec))

        davcna_stevilka = line[4:11]
        if settings.DEBUG:
            print("davcna stevilka: |%s|" % (davcna_stevilka))

        maticna_stevilka = line[13:22]
        if settings.DEBUG:
            print("maticna stevilka: |%s|" % (maticna_stevilka))

        dejavnost = line[35:41]
        if settings.DEBUG:
            print("dejavnost: |%s|" % (dejavnost))

        podjetje = line[42:143].strip()
        if settings.DEBUG:
            print("podjetje: |%s|" % (podjetje.decode("utf-8", "replace")))

        __naslov = line[144:257].strip().split(',')
        naslov = __naslov[0].strip()
        if settings.DEBUG:
            print("naslov: |%s|" % (naslov))

        postna_stevilka = ""
        posta = ""

        if naslov != "":
            postna_stevilka = regex.findall(r'\d+', __naslov[-1])

            if len(postna_stevilka) > 0:
                postna_stevilka = postna_stevilka[0]
                posta = __naslov[1].replace(postna_stevilka, "").strip()

                if settings.DEBUG:
                    print("postna stevilka: |%s|" % (postna_stevilka))
                    print("posta: |%s|" % (posta))

        additional_info = {
            'maticna_stevilka': maticna_stevilka,
            'dejavnost': dejavnost
        }

        try:
            contact_registry = ContactRegistry.objects.get(vat=davcna_stevilka)
            contact_registry.company_name = podjetje.decode("utf-8", "replace")
            contact_registry.street_address = naslov.decode("utf-8", "replace")
            contact_registry.postcode = postna_stevilka
            contact_registry.city = posta
            contact_registry.country = "SI"
            contact_registry.vat = davcna_stevilka
            contact_registry.tax_payer = davcni_zavezanec
            contact_registry.additional_info = json.dumps(additional_info)
            contact_registry.save()
        except ContactRegistry.DoesNotExist:
            contact_registry = ContactRegistry(
                type=g.CONTACT_TYPES[0][1],
                company_name=podjetje.decode("utf-8", "replace"),
                street_address=naslov.decode("utf-8", "replace"),
                postcode=postna_stevilka,
                city=posta,
                country="SI",
                vat=davcna_stevilka,
                tax_payer = davcni_zavezanec,
                additional_info=json.dumps(additional_info),
            )
            contact_registry.save()
Beispiel #3
0
def import_durs_dej(filename):
    with open(filename) as f:
        lines = f.readlines()

    for line in lines:
        davcna_stevilka = line[0:8]
        if settings.DEBUG:
            print("davcna stevilka: |%s|" % (davcna_stevilka))

        maticna_stevilka = line[9:19]
        if settings.DEBUG:
            print("maticna stevilka: |%s|" % (maticna_stevilka))

        dejavnost = line[20:26]
        if settings.DEBUG:
            print("dejavnost: |%s|" % (dejavnost))

        podjetje = line[27:128].strip()
        if settings.DEBUG:
            print("podjetje: |%s|" % (podjetje.decode("utf-8", "replace")))

        __naslov = line[129:242].strip().split(',')
        naslov = __naslov[0].strip()
        if settings.DEBUG:
            print("naslov: |%s|" % (naslov))

        postna_stevilka = ""
        posta = ""

        if naslov != "":
            postna_stevilka = regex.findall(r'\d+', __naslov[-1])

            if len(postna_stevilka) > 0:
                postna_stevilka = postna_stevilka[0]
                posta = __naslov[1].replace(postna_stevilka, "").strip()

                if settings.DEBUG:
                    print("postna stevilka: |%s|" % (postna_stevilka))
                    print("posta: |%s|" % (posta))

        additional_info = {
            'maticna_stevilka': maticna_stevilka,
            'dejavnost': dejavnost
        }

        try:
            contact_registry = ContactRegistry.objects.get(vat=davcna_stevilka)
            contact_registry.company_name = podjetje.decode("utf-8", "replace")
            contact_registry.street_address = naslov.decode("utf-8", "replace")
            contact_registry.postcode = postna_stevilka
            contact_registry.city = posta
            contact_registry.country = "SI"
            contact_registry.vat = davcna_stevilka
            contact_registry.additional_info = json.dumps(additional_info)
            contact_registry.save()
        except ContactRegistry.DoesNotExist:
            contact_registry = ContactRegistry(
                type=g.CONTACT_TYPES[0][1],
                company_name=podjetje.decode("utf-8", "replace"),
                postcode=postna_stevilka,
                street_address=naslov.decode("utf-8", "replace"),
                city=posta,
                country="SI",
                vat=davcna_stevilka,
                additional_info=json.dumps(additional_info)
            )
            contact_registry.save()