userReader = csv.reader(open(sys.argv[1], 'r'))
for row in userReader:
try:
for i in range(0, len(row)):
if row[i] == "\\N":
row[i] = None
id = row[0]
uin = row[4]
netid = row[1]
date_joined = row[5]
first_name = row[2]
last_name = row[3]
left_uiuc = row[6]
status = row[7]
m = Member(uin=uin,
username=netid,
status=status,
date_joined=date_joined,
left_uiuc=left_uiuc)
m.id = id
m.first_name = first_name
m.last_name = last_name
if netid:
m.email = netid + "@illinois.edu"
m.save()
except Exception as inst:
print "Error importing %s" % row
print inst
pass
setup_environ(settings)
import csv
from intranet.models import Member
userReader = csv.reader(open(sys.argv[1],'r'))
for row in userReader:
try:
for i in range(0,len(row)):
if row[i] == "\\N":
row[i] = None
id = row[0]
uin = row[4]
netid = row[1]
date_joined = row[5]
first_name = row[2]
last_name = row[3]
left_uiuc = row[6]
status = row[7]
m = Member(uin=uin,username=netid,status=status,date_joined=date_joined,left_uiuc=left_uiuc)
m.id = id
m.first_name = first_name
m.last_name = last_name
if netid:
m.email = netid + "@illinois.edu"
m.save()
except Exception as inst:
print "Error importing %s" % row
print inst
pass
