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