def export(event_id): (_, event_id, holders, _, _) = TicketingManager.get_attendee_export_info(event_id=event_id) if event_id == 275: headers = ['Order#', 'Order Date', 'Status', 'First Name', 'Last Name', 'Email', 'Country', 'Occupation', 'Company/Instt', 'Gender', 'Expertise', 'Welcome Reception', 'Recruitment', 'Unesco Hackathon', 'Payment Type', 'Ticket Name', 'Ticket Price', 'Ticket Type'] fields = ('order_invoice', 'created_at', 'status', 'firstname', 'lastname', 'email', 'country', 'occupation', 'occupation_detail', 'gender', 'expertise', 'welcome_reception', 'recruitment', 'unesco_hackathon', 'paid_via', 'ticket_name', 'ticket_price', 'ticket_type') else: headers = ['Order#', 'Order Date', 'Status', 'First Name', 'Last Name', 'Email', 'Country', 'Payment Type', 'Ticket Name', 'Ticket Price', 'Ticket Type'] fields = ( 'order_invoice', 'created_at', 'status', 'firstname', 'lastname', 'email', 'country', 'paid_via', 'ticket_name', 'ticket_price', 'ticket_type') rows = [headers] for holder in holders: if holder['status'] != "deleted": columns = [] for f in fields: if type(holder.get(f, '')) == unicode: columns.append(str(holder.get(f, '').encode('utf-8'))) else: columns.append(str(holder.get(f, ''))) rows.append(columns) return rows
def export(event_id): (_, event_id, holders, _, _) = TicketingManager.get_attendee_export_info(event_id=event_id) headers = 'Order#,Order Date, Status, First Name, Last Name, Email, Country,' \ 'Payment Type, Ticket Name, Ticket Price, Ticket Type' fields = ('order_invoice', 'created_at', 'status', 'firstname', 'lastname', 'email', 'country', 'paid_via', 'ticket_name', 'ticket_price', 'ticket_type') rows = [headers] for holder in holders: if holder['status'] != "deleted": columns = (str(holder.get(f, '')) for f in fields) rows.append(','.join(columns)) csv_content = '\n'.join(rows) return csv_content
def export(event_id): (_, event_id, holders, _, _) = TicketingManager.get_attendee_export_info(event_id=event_id) headers = 'Order#,Order Date, Status, First Name, Last Name, Email, Country,' \ 'Payment Type, Ticket Name, Ticket Price, Ticket Type' fields = ('order_invoice', 'created_at', 'status', 'firstname', 'lastname', 'email', 'country', 'paid_via', 'ticket_name', 'ticket_price', 'ticket_type') rows = [headers] for holder in holders: if holder['status'] != "deleted": columns = [] for f in fields: if type(holder.get(f, '')) == unicode: columns.append(str(holder.get(f, '').encode('utf-8'))) else: columns.append(str(holder.get(f, ''))) rows.append(','.join(columns)) csv_content = '\n'.join(rows) return csv_content