def show(self):
self.template = 'admin/index'
client = gdata.spreadsheets.client.SpreadsheetsClient(source='Devfest-Website-v1')
access_token = gdata.gauth.AeLoad('spreadsheed_token')
feed = client.get_list_feed(self.settings.DOCSAPI_SPREADSHEET_ID,
self.settings.DOCSAPI_SPREADSHEET_WORKSHEET_ID,
auth_token=access_token)
if feed.entry:
for entry in feed.entry:
ev = entry.to_dict()
original_users = ev['organizerse-mailid'].split(',')
event_users = []
for user in original_users:
event_users.append(users.User(user.strip()))
event = Event()
event.user = event_users
event.location = "%s, %s" % (ev['city'], ev['country'])
event.gdg_chapters = [ev['gdgchaptername']]
event.subdomain = ev['preferredsubdomainfortheeventwebsite']
event.expected_participants = ev['expectednumberofparticipants']
event.kind_of_support = ev['whatkindofsupportyouexpectforthisevent']
event.approved = True
try:
event.start = datetime.strptime(ev['eventdate'], '%m/%d/%Y')
except:
pass
event.put()
