In [1]:

    

import csv, re


    

In [2]:

    

file = "data/regions_provinces_import.csv"


    

In [3]:

    

with open(file, 'r', encoding ='utf-8') as data:
    reader = csv.reader(data)
    datalist = list(reader)


    

In [4]:

    

failed_saves = []
c = 0
for x in datalist[1:]:
    class_name = "DC_"+x[5]
    string = """{}({}="{}",{}="{}",{} = {}.objects.get(name="{}") )""".format(x[0], x[1], x[2], x[3], x[4], x[5],class_name, x[6])
    print(string)
    try:
        eval(string).save()
        c = c+1
    except:
        failed_saves.append(string)
print(len(datalist))
print("saved {} entries".format(c))
print("list of failed saves:", failed_saves)


    

    




DC_region(name="Turkish Thrace",original_name="Türkisch Thrakien",country = DC_country.objects.get(name="Turkey") )
DC_region(name="Western Anatolia",original_name="Westanatolien",country = DC_country.objects.get(name="Turkey") )
DC_region(name="Southeastern Anatolia",original_name="Südostanatolien",country = DC_country.objects.get(name="Turkey") )
DC_region(name="Eastern Anatolia",original_name="Ostanatolien",country = DC_country.objects.get(name="Turkey") )
DC_region(name="Central Anatolia",original_name="Zentralanatolien",country = DC_country.objects.get(name="Turkey") )
DC_region(name="Eastern Aegean",original_name="Ostägäis",country = DC_country.objects.get(name="Greece") )
DC_region(name="Crete",original_name="Kreta",country = DC_country.objects.get(name="Greece") )
DC_region(name="Cyclades",original_name="Kykladen",country = DC_country.objects.get(name="Greece") )
DC_region(name="Central Greece",original_name="Zentralgriechenland",country = DC_country.objects.get(name="Greece") )
DC_region(name="Epirus - Northwestern Greece",original_name="Epirus - Nordwestgriechenland",country = DC_country.objects.get(name="Greece") )
DC_region(name="Ionian Islands",original_name="Ionische Inseln",country = DC_country.objects.get(name="Greece") )
DC_region(name="Western Macedonia",original_name="Westmakedonien",country = DC_country.objects.get(name="Greece") )
DC_region(name="Central Macedonia",original_name="Zentralmakedonien",country = DC_country.objects.get(name="Greece") )
DC_region(name="Eastern Macedonia",original_name="Ostmakedonien",country = DC_country.objects.get(name="Greece") )
DC_region(name="Peloponnese",original_name="Peloponnes",country = DC_country.objects.get(name="Greece") )
DC_region(name="Thessaly",original_name="Thessalien",country = DC_country.objects.get(name="Greece") )
DC_region(name="Thrace",original_name="Thrakien",country = DC_country.objects.get(name="Greece") )
DC_region(name="Western Greece",original_name="Westgriechenland",country = DC_country.objects.get(name="Greece") )
DC_province(name="Antalya",original_name="Antalya",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Burdur",original_name="Burdur",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Isparta",original_name="Isparta",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Afyon",original_name="Afyonkarahisar",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Aydin",original_name="Aydın",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Denizli",original_name="Denizli",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Izmir",original_name="İzmir",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Kutahya",original_name="Kütahya",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Manisa",original_name="Manisa",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Mugla",original_name="Muğla",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Usak",original_name="Uşak",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Balikesir",original_name="Balıkesir",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Bilecik",original_name="Bilecik",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Bursa",original_name="Bursa",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Canakkale",original_name="Çanakkale",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Yalova",original_name="Yalova",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Kocaeli",original_name="Kocaeli",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Sakarya",original_name="Sakarya",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Istanbul",original_name="İstanbul",region = DC_region.objects.get(name="Western Anatolia") )
DC_province(name="Kirklareli",original_name="Kırklareli",region = DC_region.objects.get(name="Turkish Thrace") )
DC_province(name="Tekirdag",original_name="Tekirdağ",region = DC_region.objects.get(name="Turkish Thrace") )
DC_province(name="Edirne",original_name="Edirne",region = DC_region.objects.get(name="Turkish Thrace") )
DC_province(name="Adiyaman",original_name="Adıyaman",region = DC_region.objects.get(name="Southeastern Anatolia") )
DC_province(name="Batman",original_name="Batman",region = DC_region.objects.get(name="Southeastern Anatolia") )
DC_province(name="Diyarbakir",original_name="Diyarbakır",region = DC_region.objects.get(name="Southeastern Anatolia") )
DC_province(name="Gaziantep",original_name="Gaziantep",region = DC_region.objects.get(name="Southeastern Anatolia") )
DC_province(name="Kilis",original_name="Kilis",region = DC_region.objects.get(name="Southeastern Anatolia") )
DC_province(name="Mardin",original_name="Mardin",region = DC_region.objects.get(name="Southeastern Anatolia") )
DC_province(name="Sanliurfa",original_name="Şanlıurfa",region = DC_region.objects.get(name="Southeastern Anatolia") )
DC_province(name="Siirt",original_name="Siirt",region = DC_region.objects.get(name="Southeastern Anatolia") )
DC_province(name="Sirnak",original_name="Şırnak",region = DC_region.objects.get(name="Southeastern Anatolia") )
DC_province(name="Agri",original_name="Ağrı",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Ardahan",original_name="Ardahan",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Bingol",original_name="Bingöl",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Bitlis",original_name="Bitlis",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Elazig",original_name="Elazığ",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Erzincan",original_name="Erzincan",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Erzurum",original_name="Erzurum",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Hakkari",original_name="Hakkari",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Igdir",original_name="Iğdır",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Kars",original_name="Kars",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Malatya",original_name="Malatya",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Mus",original_name="Muş",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Tunceli",original_name="Tunceli",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Van",original_name="Van",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Artvin",original_name="Artvin",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Rize",original_name="Rize",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Bayburt",original_name="Bayburt",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Trabzon",original_name="Trabzon",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Gumushane",original_name="Gümüşhane",region = DC_region.objects.get(name="Eastern Anatolia") )
DC_province(name="Aksaray",original_name="Aksaray",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Ankara",original_name="Ankara",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Cankiri",original_name="Çankırı",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Eskisehir",original_name="Eskişehir",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Karaman",original_name="Karaman",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Kayseri",original_name="Kayseri",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Kirikkale",original_name="Kırıkkale",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Kirsehir",original_name="Kırşehir",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Konya",original_name="Konya",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Nevsehir",original_name="Nevşehir",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Nigde",original_name="Niğde",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Sivas",original_name="Sivas",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Yozgat",original_name="Yozgat",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Hatay",original_name="Hatay",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Kahramanmaras",original_name="Kahramanmaraş",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Osmaniye",original_name="Osmaniye",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Mersin",original_name="Mersin",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Adana",original_name="Adana",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Amasya",original_name="Amasya",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Bartin",original_name="Bartın",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Bolu",original_name="Bolu",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Corum",original_name="Çorum",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Duzce",original_name="Düzce",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Giresun",original_name="Giresun",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Karabuk",original_name="Karabük",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Kastamonu",original_name="Kastamonu",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Ordu",original_name="Ordu",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Samsun",original_name="Samsun",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Sinop",original_name="Sinop",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Tokat",original_name="Tokat",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Zonguldak",original_name="Zonguldak",region = DC_region.objects.get(name="Central Anatolia") )
DC_province(name="Dodecanese",original_name="Δωδεκανήσος",region = DC_region.objects.get(name="Eastern Aegean") )
DC_province(name="Samos –  Ikaria",original_name="Σάμος - Ικαρία",region = DC_region.objects.get(name="Eastern Aegean") )
DC_province(name="Chios",original_name="Χίος",region = DC_region.objects.get(name="Eastern Aegean") )
DC_province(name="Lesbos",original_name="Λέσβος",region = DC_region.objects.get(name="Eastern Aegean") )
DC_province(name="Karditsa",original_name="Καρδίτσα",region = DC_region.objects.get(name="Thessaly") )
DC_province(name="Larissa",original_name="Λάρισα",region = DC_region.objects.get(name="Thessaly") )
DC_province(name="Magnesia",original_name="Μαγνησία",region = DC_region.objects.get(name="Thessaly") )
DC_province(name="Northern Sporades",original_name="Βόρειες Σποράδες",region = DC_region.objects.get(name="Thessaly") )
DC_province(name="Trikala",original_name="Τρίκαλα",region = DC_region.objects.get(name="Thessaly") )
DC_province(name="Messenia",original_name="Μεσσηνία",region = DC_region.objects.get(name="Peloponnese") )
DC_province(name="Achaea",original_name="Αχαΐα",region = DC_region.objects.get(name="Peloponnese") )
DC_province(name="Arcadia",original_name="Αρκαδία",region = DC_region.objects.get(name="Peloponnese") )
DC_province(name="Argolid",original_name="Αργολίδα",region = DC_region.objects.get(name="Peloponnese") )
DC_province(name="Corinthia",original_name="Κορινθία",region = DC_region.objects.get(name="Peloponnese") )
DC_province(name="Eleia",original_name="Ηλεία",region = DC_region.objects.get(name="Peloponnese") )
DC_province(name="Laconia",original_name="Λακωνία",region = DC_region.objects.get(name="Peloponnese") )
DC_province(name="Cyclades",original_name="Κυκλάδες",region = DC_region.objects.get(name="Cyclades") )
DC_province(name="Athens",original_name="Αθήνα",region = DC_region.objects.get(name="Central Greece") )
DC_province(name="Boiotia",original_name="Βοιωτία",region = DC_region.objects.get(name="Central Greece") )
DC_province(name="East Attica",original_name="Ανατολική Αττική",region = DC_region.objects.get(name="Central Greece") )
DC_province(name="Euboia",original_name="Εύβοια",region = DC_region.objects.get(name="Central Greece") )
DC_province(name="West Attica",original_name="Δυτική Αττική",region = DC_region.objects.get(name="Central Greece") )
DC_province(name="Saronic Gulf",original_name="Σαρονικός Κόλπος",region = DC_region.objects.get(name="Central Greece") )
DC_province(name="Piraeus",original_name="Πειραιάς",region = DC_region.objects.get(name="Central Greece") )
DC_province(name="Phokis",original_name="Φωκίδα",region = DC_region.objects.get(name="Central Greece") )
DC_province(name="Phthiotis ",original_name="Φθιώτιδα",region = DC_region.objects.get(name="Central Greece") )
DC_province(name="Evrytania",original_name="Ευρυτανία",region = DC_region.objects.get(name="Central Greece") )
DC_province(name="Ioannina",original_name="Ιωάννίνα",region = DC_region.objects.get(name="Epirus - Northwestern Greece") )
DC_province(name="Preveza",original_name="Πρέβεζα",region = DC_region.objects.get(name="Epirus - Northwestern Greece") )
DC_province(name="Thesprotia",original_name="Θεσπρωτία",region = DC_region.objects.get(name="Epirus - Northwestern Greece") )
DC_province(name="Arta",original_name="Άρτα",region = DC_region.objects.get(name="Epirus - Northwestern Greece") )
DC_province(name="Lefkada",original_name="Λευκάδα",region = DC_region.objects.get(name="Ionian Islands") )
DC_province(name="Kerkyra",original_name="Κέρκυρα",region = DC_region.objects.get(name="Ionian Islands") )
DC_province(name="Kefallonia",original_name="Κεφαλληνιά",region = DC_region.objects.get(name="Ionian Islands") )
DC_province(name="Kythera",original_name="Κύθηρα",region = DC_region.objects.get(name="Ionian Islands") )
DC_province(name="Zakynthos",original_name="Ζάκυνθος",region = DC_region.objects.get(name="Ionian Islands") )
DC_province(name="Rethymnon",original_name="Ρέθυμνον",region = DC_region.objects.get(name="Crete") )
DC_province(name="Central Crete (Heraklio)",original_name="Ηράκλειο",region = DC_region.objects.get(name="Crete") )
DC_province(name="Chania",original_name="Χανιά",region = DC_region.objects.get(name="Crete") )
DC_province(name="Lasithi",original_name="Λασίθι",region = DC_region.objects.get(name="Crete") )
DC_province(name="Florina",original_name="Φλώρινα",region = DC_region.objects.get(name="Western Macedonia") )
DC_province(name="Grevena",original_name="Γρεβενά",region = DC_region.objects.get(name="Western Macedonia") )
DC_province(name="Imathia",original_name="Ημαθία",region = DC_region.objects.get(name="Western Macedonia") )
DC_province(name="Kastoria",original_name="Καστοριά",region = DC_region.objects.get(name="Western Macedonia") )
DC_province(name="Pieria",original_name="Πιερία",region = DC_region.objects.get(name="Western Macedonia") )
DC_province(name="Kozani",original_name="Κοζάνη",region = DC_region.objects.get(name="Western Macedonia") )
DC_province(name="Kilkis",original_name="Κιλκίς",region = DC_region.objects.get(name="Central Macedonia") )
DC_province(name="Pella ",original_name="Πέλλα",region = DC_region.objects.get(name="Central Macedonia") )
DC_province(name="Thessaloniki, surroundings",original_name="Θεσσαλονίκη",region = DC_region.objects.get(name="Central Macedonia") )
DC_province(name="City of Thessaloniki",original_name="Πόλη Θεσσαλονίκης",region = DC_region.objects.get(name="Central Macedonia") )
DC_province(name="Mount Athos",original_name="Άγιος Όρος",region = DC_region.objects.get(name="Central Macedonia") )
DC_province(name="Chalkidiki",original_name="Χαλκιδική",region = DC_region.objects.get(name="Central Macedonia") )
DC_province(name="Serres",original_name="Σέρρες",region = DC_region.objects.get(name="Eastern Macedonia") )
DC_province(name="Drama",original_name="Δράμα",region = DC_region.objects.get(name="Eastern Macedonia") )
DC_province(name="Kavalla",original_name="Καβάλα",region = DC_region.objects.get(name="Thrace") )
DC_province(name="Thasos",original_name="Θάσος",region = DC_region.objects.get(name="Thrace") )
DC_province(name="Evros",original_name="Έβρος",region = DC_region.objects.get(name="Thrace") )
DC_province(name="Xanthi",original_name="Χάνθη",region = DC_region.objects.get(name="Thrace") )
DC_province(name="Rhodope",original_name="Ροδόπη",region = DC_region.objects.get(name="Thrace") )
DC_province(name="Aetolia",original_name="Αιτωλία",region = DC_region.objects.get(name="Western Greece") )
DC_province(name="Acarnania",original_name="Ακαρνανία",region = DC_region.objects.get(name="Western Greece") )
161
saved 160 entries
list of failed saves: []

In [ ]: