def download_webex(self, REQUEST=None, RESPONSE=None):
"""exports the participants listing in a Webex-compatible CSV file"""
# This will be refactored to export to Skype, Webex will be shut
# down. Right now this method is not used.
header = [
'UUID', 'Name', 'Email', 'Company', 'JobTitle', 'URL', 'OffCntry',
'OffLocal', 'CellCntry', 'CellLocal', 'FaxCntry', 'FaxLocal',
'Address1', 'Address2', 'City', 'State/Province', 'Zip/Postal',
'Country', 'Time Zone', 'Language', 'Locale', 'UserName', 'Notes'
]
rows = []
participants = self.getAttendees()
for participant in participants:
part_info = self.getAttendeeInfo(participant)
participant_info = [
part_info['uid'], part_info['name'], part_info['email'],
part_info['organization'], part_info['role'], '',
part_info['phone'], '', '', '', '', '', '', '', '', '', '',
country_from_country_code.get(part_info['country'], ''), '',
'', '', part_info['uid'], ''
]
rows.append(participant_info)
filename = '%s_%s_%s.csv' % (self.getMeeting().getId(
), self.id, datetime.now().strftime("%Y-%m-%d_%H-%M-%S"))
RESPONSE.setHeader('Content-Type', 'text/csv')
RESPONSE.setHeader('Content-Disposition',
'attachment; filename=%s' % filename)
return generate_csv(header, rows)
def download_webex(self, REQUEST=None, RESPONSE=None):
"""exports the participants listing in a Webex-compatible CSV file"""
# This will be refactored to export to Skype, Webex will be shut
# down. Right now this method is not used.
header = ['UUID', 'Name', 'Email', 'Company', 'JobTitle', 'URL',
'OffCntry', 'OffLocal', 'CellCntry', 'CellLocal', 'FaxCntry',
'FaxLocal', 'Address1', 'Address2', 'City', 'State/Province',
'Zip/Postal', 'Country', 'Time Zone', 'Language', 'Locale',
'UserName', 'Notes']
rows = []
participants = self.getAttendees()
for participant in participants:
part_info = self.getAttendeeInfo(participant)
participant_info = [
part_info['uid'], part_info['name'], part_info['email'],
part_info['organization'], part_info['role'],
'', part_info['phone'], '', '', '', '', '', '', '', '', '', '',
country_from_country_code.get(part_info['country'], ''),
'', '', '', part_info['uid'], '']
rows.append(participant_info)
filename = '%s_%s_%s.csv' % (self.getMeeting().getId(), self.id,
datetime.now().strftime(
"%Y-%m-%d_%H-%M-%S"))
RESPONSE.setHeader('Content-Type', 'text/csv')
RESPONSE.setHeader('Content-Disposition', 'attachment; filename=%s'
% filename)
return generate_csv(header, rows)
def download(self, REQUEST=None, RESPONSE=None):
"""exports the participants listing in an excel file"""
assert self.rstk.we_provide('Excel export')
header = ['Name', 'User ID', 'Email', 'Organisation',
'Represented country', 'Reimbursed participation', 'Phone',
'Status', 'Last modified by',
'Reason for modification (when saved by an administrator)']
meeting = self.getMeeting()
survey = self.get_survey()
if meeting.survey_required and survey:
survey_questions = []
for question in self.get_survey_questions():
survey_question = getattr(survey, question[0])
if survey_question.meta_type == 'Naaya Radio Matrix Widget':
survey_questions.extend(survey_question.rows)
else:
survey_questions.append(question[1])
header.extend(survey_questions)
rows = []
participants = self.getAttendees()
for participant in participants:
part_info = self.getAttendeeInfo(participant)
participant_info = [
part_info['name'], part_info['uid'], part_info['email'],
part_info['organization'],
country_from_country_code.get(part_info['country'], ''),
part_info['reimbursed'], part_info['phone'], part_info['role'],
part_info['saved_by'], part_info['justification']]
if meeting.survey_required and survey:
survey_answers = []
for question in self.get_survey_questions():
survey_question = getattr(survey, question[0])
survey_answer = self.get_survey_answer(part_info['uid'],
question[0])
if survey_answer is None:
survey_answer = '-'
if isinstance(survey_answer, basestring):
survey_answers.append(survey_answer)
else:
survey_answers.extend(survey_answer)
participant_info.extend(survey_answers)
rows.append(participant_info)
filename = '%s_%s_%s.xls' % (self.getMeeting().getId(), self.id,
datetime.now().strftime(
"%Y-%m-%d_%H-%M-%S"))
RESPONSE.setHeader('Content-Type', 'application/vnd.ms-excel')
RESPONSE.setHeader('Content-Disposition', 'attachment; filename=%s'
% filename)
return generate_excel(header, rows)
def download(self, REQUEST=None, RESPONSE=None):
"""exports the participants listing in an excel file"""
assert self.rstk.we_provide('Excel export')
header = [
'Name', 'User ID', 'Email', 'Organisation', 'Represented country',
'Reimbursed participation', 'Phone', 'Status', 'Last modified by',
'Reason for modification (when saved by an administrator)'
]
meeting = self.getMeeting()
if meeting.survey_required and self.get_survey():
header.extend(
[question[1] for question in self.get_survey_questions()])
rows = []
participants = self.getAttendees()
for participant in participants:
part_info = self.getAttendeeInfo(participant)
participant_info = [
part_info['name'], part_info['uid'], part_info['email'],
part_info['organization'],
country_from_country_code.get(part_info['country'], ''),
part_info['reimbursed'], part_info['phone'], part_info['role'],
part_info['saved_by'], part_info['justification']
]
if meeting.survey_required and self.get_survey():
survey_answers = [
self.get_survey_answer(part_info['uid'], question[0])
or '-' for question in self.get_survey_questions()
]
participant_info.extend(survey_answers)
rows.append(participant_info)
filename = '%s_%s_%s.xls' % (self.getMeeting().getId(
), self.id, datetime.now().strftime("%Y-%m-%d_%H-%M-%S"))
RESPONSE.setHeader('Content-Type', 'application/vnd.ms-excel')
RESPONSE.setHeader('Content-Disposition',
'attachment; filename=%s' % filename)
return generate_excel(header, rows)
def get_country(self, country_code):
""" """
if country_code is None:
return '-'
return country_from_country_code.get(country_code, country_code)