f = open('/Users/dimitriosalikaniotis/Sites/llc/llc_site/llc/utils/sessions.txt')
f2 = open('/Users/dimitriosalikaniotis/Sites/llc/llc_site/llc/utils/paper_sessions.txt')
d = {}
for i, s in enumerate(f2, 1):
    d[i] = map(int, s.strip().split('\t'))

for line in f:
    s = Session()
    newline = map(int, line.strip().split('\t'))
    day = newline[1]
    month = newline[2]
    year = newline[3]
    loc = newline[4]
    date = datetime.date(year=year, month=month, day=day)
    s.day = date
    s.location = Location.objects.get(pk=loc)
    s.save()
    for i, (k, v) in enumerate(d.iteritems(), 1):
        if s.pk in v:
            s.paper.add(Paper.objects.get(pk=i))
    s.save()
    
f.close()

## ratings

f = open('/Users/dimitriosalikaniotis/Sites/llc/llc_site/llc/utils/ratings.txt')

for line in f:
    r = Rating()
    try: