# Extracting email addresses for a group

**URL:** https://meta.discourse.org/t/extracting-email-addresses-for-a-group/33262
**Category:** Support
**Created:** [September 14, 2015, 9:54pm UTC](https://meta.discourse.org/t/extracting-email-addresses-for-a-group/33262 "2015-09-14T21:54:13Z")
**Posts on this page:** 13
**Page:** 1

<div class="post-metadata">

### Author: ![HAWK](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/hawk/32/86627_2.png) [@HAWK](https://meta.discourse.org/u/HAWK)
#### Post date: [September 14, 2015, 9:54pm UTC](https://meta.discourse.org/t/extracting-email-addresses-for-a-group/33262/1 "2015-09-14T21:54:13Z")

</div>

Is there any way that I can pull a list of email addresses for all members of a particular group?

---

<div class="post-metadata">

### Author: ![cpradio](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cpradio/32/4970_2.png) [@cpradio](https://meta.discourse.org/u/cpradio)
#### Post date: [September 14, 2015, 9:55pm UTC](https://meta.discourse.org/t/extracting-email-addresses-for-a-group/33262/2 "2015-09-14T21:55:20Z")

</div>

Would the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) Plugin do this? I really need to install that locally to see what can be done with it. (bbiab while I go do that before I forget)

---

<div class="post-metadata">

### Author: ![HAWK](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/hawk/32/86627_2.png) [@HAWK](https://meta.discourse.org/u/HAWK)
#### Post date: [September 14, 2015, 9:57pm UTC](https://meta.discourse.org/t/extracting-email-addresses-for-a-group/33262/3 "2015-09-14T21:57:08Z")

</div>

I need a way to do it without plugins. I’m on a hosted plan which limits which stops me from installing them.

---

<div class="post-metadata">

### Author: ![cpradio](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cpradio/32/4970_2.png) [@cpradio](https://meta.discourse.org/u/cpradio)
#### Post date: [September 14, 2015, 9:57pm UTC](https://meta.discourse.org/t/extracting-email-addresses-for-a-group/33262/4 "2015-09-14T21:57:45Z")

</div>

With Discourse? As they’ll install that one, it is supported by core.

> [@Discourse Data Explorer](https://meta.discourse.org/t/discourse-data-explorer/32566/1):
>
> If you’re on a hosted Discourse forum and the [data explorer](https://meta.discourse.org/t/32566?silent=true) doesn’t show up at /admin/plugins, email us at [team@discourse.org](mailto:team@discourse.org) to ask us to add it for you.
> 
> For self-hosted discourse forums, follow the Install A Plugin guide using [GitHub - discourse/discourse-data-explorer: SQL Queries for admins in Discourse · GitHub](https://github.com/discourse/discourse-data-explorer.git) .

---

<div class="post-metadata">

### Author: ![HAWK](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/hawk/32/86627_2.png) [@HAWK](https://meta.discourse.org/u/HAWK)
#### Post date: [September 14, 2015, 9:58pm UTC](https://meta.discourse.org/t/extracting-email-addresses-for-a-group/33262/5 "2015-09-14T21:58:17Z")

</div>

Ok, that’s good to know. (Yup, with Discourse).

---

<div class="post-metadata">

### Author: ![cpradio](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cpradio/32/4970_2.png) [@cpradio](https://meta.discourse.org/u/cpradio)
#### Post date: [September 14, 2015, 10:20pm UTC](https://meta.discourse.org/t/extracting-email-addresses-for-a-group/33262/6 "2015-09-14T22:20:35Z")

</div>

Okay, this is going in blind as for whatever reason, the plugin doesn’t produce a table of results for me (for any query), but this is my first stab at what you are looking for (I think).

[group-emails.dcquery.json](https://global.discourse-cdn.com/meta/original/3X/7/5/75427d7930622f8d14852c932736b8b4a66cf8f9.json) (606 Bytes)

---

<div class="post-metadata">

### Author: ![riking](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/riking/32/170938_2.png) [@riking](https://meta.discourse.org/u/riking)
#### Post date: [September 14, 2015, 10:24pm UTC](https://meta.discourse.org/t/extracting-email-addresses-for-a-group/33262/7 "2015-09-14T22:24:22Z")

</div>

It’s due to not keeping up with changes in core:

```plaintext
Uncaught Error: Could not find module `discourse/lib/avatar-template` imported from `discourse/plugins/discourse-data-explorer/discourse/components/query-result`

```

---

<div class="post-metadata">

### Author: ![cpradio](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cpradio/32/4970_2.png) [@cpradio](https://meta.discourse.org/u/cpradio)
#### Post date: [September 14, 2015, 10:28pm UTC](https://meta.discourse.org/t/extracting-email-addresses-for-a-group/33262/8 "2015-09-14T22:28:04Z")

</div>

I just grabbed latest, or are you saying that the plugin needs to be adjusted? (seems to be the plugin… based on the error)

---

<div class="post-metadata">

### Author: ![riking](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/riking/32/170938_2.png) [@riking](https://meta.discourse.org/u/riking)
#### Post date: [September 14, 2015, 10:37pm UTC](https://meta.discourse.org/t/extracting-email-addresses-for-a-group/33262/9 "2015-09-14T22:37:13Z")

</div>

OK, just fixed it, data-explorer will be fixed when you next update it 😉

---

<div class="post-metadata">

### Author: ![cpradio](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/cpradio/32/4970_2.png) [@cpradio](https://meta.discourse.org/u/cpradio)
#### Post date: [September 14, 2015, 10:37pm UTC](https://meta.discourse.org/t/extracting-email-addresses-for-a-group/33262/10 "2015-09-14T22:37:50Z")

</div>

Sweet, as I just commented out the avatar template usage to see if my query works and it does.

@HAWK, when you get the plugin, you can import my script above, here is a sample of the output

 ![](https://global.discourse-cdn.com/meta/original/3X/f/e/fe56bf7469c5c5c8f08b25fad640f7c94acae6de.png)

---

<div class="post-metadata">

### Author: ![HAWK](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/hawk/32/86627_2.png) [@HAWK](https://meta.discourse.org/u/HAWK)
#### Post date: [September 14, 2015, 10:50pm UTC](https://meta.discourse.org/t/extracting-email-addresses-for-a-group/33262/11 "2015-09-14T22:50:16Z")

</div>

Thanks Matt, you’re a star.

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [November 6, 2018, 11:53pm UTC](https://meta.discourse.org/t/extracting-email-addresses-for-a-group/33262/12 "2018-11-06T23:53:00Z")

</div>



---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [November 6, 2018, 11:53pm UTC](https://meta.discourse.org/t/extracting-email-addresses-for-a-group/33262/13 "2018-11-06T23:53:56Z")

</div>


