def secret_import(file_name):
from secret.models import Secret
from comment.models import DiscussionComment, Proposal
# imports data
data = import_csv(file_name)
count = 0
# creates for each data point
for row in data:
#try:
if len(row) > 1:
try:
s = Secret()
s.id = clean(row[0])
# data item 2 need to load into comments
s.title = clean(row[2])
s.location = clean(row[3])
s.url = clean(row[4])
comment = DiscussionComment.objects.get(pk=clean(row[1]))
s.created_by = comment.created_by
s.created_at = datetime.datetime.now()
s.updated_at = datetime.datetime.now()
s.save()
p = Proposal()
p.discussion_comment = comment
p.secret = s
p.save()
except:
print row[0]
