agreement_poc.py

import os
import json
from projects.models import Project
from django.contrib.auth.models import User
from django.core.exceptions import ValidationError

"""
For data structure:
[
  {
    "id1": 77,
    "id2": "",
    "id3": "",
    "id4": "",
    "id5": "",
    "id7": "",
    "id8": "",
    "18F Project POC Email": "john.smith"
  },
  {
    "id1": 44,
    "id2": "",
    "id3": "",
    "id4": "",
    "id5": "",
    "id7": "",
    "id8": "",
    "18F Project POC Email": "christopher.smith"
  },
]

"""

data = json.loads(open('agreement_poc.json', 'r').read())

fields = 'id4', 'id7', 'id3', 'id1', 'id2', 'id8','id5'

field_list = list()

for i in fields:
    field_list.append(i)

for obj in data:
    for field in field_list:
        if obj[field]:
            try:
                project = Project.objects.get(id=obj[field])
            except Project.DoesNotExist:
                 ValidationError("Project does not exist.")
            if project:
                try:
                    project_lead = User.objects.get(username=obj['18F Project POC Email'].strip())
                    project.project_lead = project_lead
                    project.save()
                except User.DoesNotExist:
                    raise ValidationError("{0} does not exist.".format(obj['18F Project POC Email']))