from users.models import *
import sys
up = UserProfile.objects.all()
print up.count()
header = "Name, User Type, Email, Phone, City, Country, TimeZone, Created Date\n"
fname = "/tmp/user_data.csv"
with open(fname, 'w') as FW:
FW.write(header)
for each in up:
try:
name = each.name
name = name.encode('utf-8').strip()
dts = each.created_date
dts = dts.strftime("%d %b %Y") #dts.strftime("%b %d %Y %I:%M %p")
str1 = "%s,%s,%s,%s,%s,%s,%s,%s\n" % (str(name), str(each.usertype), str(each.email_id), str(each.phone), str(each.city), str(each.country), str(each.timezone), str(dts))
#print str1
FW.write(str1)
except Exception, e:
print '---- Error: ' + str(e)
print fname
Output:
Name, User Type, Email, Phone, City, Country, TimeZone, Created Date
User2,Student,user2@abc.com,None,Bangalore,IN,Asia/Kolkata,16 Mar 2018
User3,Student,user3@gmail.com,None,Pune,IN,Asia/Kolkata,28 Mar 2018
....
import sys
up = UserProfile.objects.all()
print up.count()
header = "Name, User Type, Email, Phone, City, Country, TimeZone, Created Date\n"
fname = "/tmp/user_data.csv"
with open(fname, 'w') as FW:
FW.write(header)
for each in up:
try:
name = each.name
name = name.encode('utf-8').strip()
dts = each.created_date
dts = dts.strftime("%d %b %Y") #dts.strftime("%b %d %Y %I:%M %p")
str1 = "%s,%s,%s,%s,%s,%s,%s,%s\n" % (str(name), str(each.usertype), str(each.email_id), str(each.phone), str(each.city), str(each.country), str(each.timezone), str(dts))
#print str1
FW.write(str1)
except Exception, e:
print '---- Error: ' + str(e)
print fname
Output:
Name, User Type, Email, Phone, City, Country, TimeZone, Created Date
User2,Student,user2@abc.com,None,Bangalore,IN,Asia/Kolkata,16 Mar 2018
User3,Student,user3@gmail.com,None,Pune,IN,Asia/Kolkata,28 Mar 2018
....
No comments:
Post a Comment