In [16]:

    

import csv, re


    

In [17]:

    

file = "data/inclusion.csv"


    

In [18]:

    

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


    

In [19]:

    

failed_saves = []


    

In [20]:

    

for x in datalist[1:]:
    if len(x) != 0:
        model = Inclusion.objects.get_or_create(inclusion_id=x[8],
                                             inclusion_type=x[2],
                                             inclusion_color=x[3],
                                             inclusion_form=x[4],
                                             inclusion_particle_size=x[5],
                                             inclusion_frequency=x[6],
                                             inclusion_hardness=x[7],)
    else:
        failed_saves.append(x)


    

In [21]:

    

print(failed_saves)


    

    




[]

In [25]:

    

for x in datalist[1:]:
    try:
        inclusion_model = Threedmodel.objects.get(model_id=x[0])
        inclusion_model.inclusion.add(Inclusion.objects.get(inclusion_id=x[8]))
    except:
        print('Error!', x)


    

    




Error! ['0', '1', 'Mica', '', 'Spherical', '0,03 cm', '1%', 'Hard', '62']
Error! ['0', '2', 'White', '5YR 8/1', 'Spherical', '0,1 cm', '1%', 'Medium', '111']
Error! ['0', '3', 'Black', '5YR 2.5/1', 'Spherical', '0,05 cm', '1%', 'Medium', '191']

In [ ]: