# Export event data is a bit painful, and email addresses would be useful

**URL:** <https://meta.discourse.org/t/export-event-data-is-a-bit-painful-and-email-addresses-would-be-useful/242153>\
**Category:** UX\
**Tags:** events\
**Created:** [October 18, 2022, 1:06am UTC](https://meta.discourse.org/t/export-event-data-is-a-bit-painful-and-email-addresses-would-be-useful/242153 "2022-10-18T01:06:49Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![nathank](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/nathank/32/290039_2.png) [@nathank](https://meta.discourse.org/u/nathank)\
**Post date:** [October 18, 2022, 1:06am UTC](https://meta.discourse.org/t/export-event-data-is-a-bit-painful-and-email-addresses-would-be-useful/242153/1 "2022-10-18T01:06:49Z")

</div>

Using the [Creating and managing events](https://meta.discourse.org/t/discourse-event/149964) functionality, I find it quite cumbersome to download and use the ![image](https://global.discourse-cdn.com/meta/original/4X/a/7/1/a71858bf12a6311edb4e81f4c6eee35d2cf5e53f.png).

Currently it uses a similar mechanism to the User Export, giving you:

1. a zip file via a PM to those with edit privileges on that post
2. gives you these fields:  
`username	status	first_answered_at	last_updated_at`

### Suggestion 1

That a direct .csv download be provided from the modal

This would be much simpler from the user perspective

### Suggestion 2

That primary emails be reported in this download (or there be an option for this)

This would allow easy export of participants when needed for other purposes related to the event.

I’ve got a [Data Explorer](https://meta.discourse.org/t/32566?silent=true) query for this at the mo which works well enough, but requires a lot of fiddle to give event organisers (i.e. the OP) access to it:

```sql
-- [params]
-- int :post_id

WITH e AS (
  SELECT email, user_id
  FROM user_emails u
  WHERE u.primary = true
)

SELECT dpei.user_id, email, status, notified
FROM discourse_post_event_invitees dpei
JOIN e ON e.user_id = dpei.user_id
WHERE dpei.post_id = :post_id
ORDER BY status, email

```

---

_[View the full topic](https://meta.discourse.org/t/export-event-data-is-a-bit-painful-and-email-addresses-would-be-useful/242153)._