# Adding two additional fields to user export

**URL:** https://meta.discourse.org/t/adding-two-additional-fields-to-user-export/33690
**Category:** Feature
**Created:** [September 24, 2015, 10:45am UTC](https://meta.discourse.org/t/adding-two-additional-fields-to-user-export/33690 "2015-09-24T10:45:51Z")
**Posts on this page:** 9
**Page:** 1

<div class="post-metadata">

### Author: ![alefattorini](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alefattorini/32/119928_2.png) [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [September 24, 2015, 10:45am UTC](https://meta.discourse.org/t/adding-two-additional-fields-to-user-export/33690/1 "2015-09-24T10:45:51Z")

</div>

I’m used to exporting users list for the statistic purpose, post\_count and read\_count are great but I miss two useful data:  
**Last seen date** and **last post date**

With such info I can:

- reach out members who aren’t around for a while (where are you ending up?)
- a good post count it’s valuable for a member but if your last post is months ago, this data loses its significance.

What about?

---

<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 24, 2015, 11:08am UTC](https://meta.discourse.org/t/adding-two-additional-fields-to-user-export/33690/2 "2015-09-24T11:08:33Z")

</div>

You can use the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) Plugin to do this.

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [September 24, 2015, 11:49am UTC](https://meta.discourse.org/t/adding-two-additional-fields-to-user-export/33690/3 "2015-09-24T11:49:57Z")

</div>

I support adding these fields to the default export @techapj

---

<div class="post-metadata">

### Author: ![alefattorini](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alefattorini/32/119928_2.png) [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [September 24, 2015, 12:18pm UTC](https://meta.discourse.org/t/adding-two-additional-fields-to-user-export/33690/4 "2015-09-24T12:18:10Z")

</div>

> [@codinghorror](#):
>
> I support adding these fields to the default export @techapj

Whoa I can’t ask for more than that 👍

---

<div class="post-metadata">

### Author: ![techAPJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/techapj/32/342990_2.png) [@techAPJ](https://meta.discourse.org/u/techAPJ)
#### Post date: [September 24, 2015, 12:18pm UTC](https://meta.discourse.org/t/adding-two-additional-fields-to-user-export/33690/5 "2015-09-24T12:18:45Z")

</div>

Last seen date (last\_seen\_at) and Last posted date (last\_posted\_at) are included in CSV file when User list is exported from `/admin/users/list/active`.

From where are you trying to export User list?

---

<div class="post-metadata">

### Author: ![alefattorini](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alefattorini/32/119928_2.png) [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [September 24, 2015, 12:24pm UTC](https://meta.discourse.org/t/adding-two-additional-fields-to-user-export/33690/6 "2015-09-24T12:24:37Z")

</div>

Yes, I’m on the same place. My current version is 1.4, did you have recently added it into 1.5?  
I have only these fields:

```
id	name	username	email	title	created_at	trust_level	approved	suspended_at	suspended_till	blocked	active	admin	moderator	ip_address	topics_entered	posts_read_count	time_read	topic_count	post_count	likes_given	likes_received	Country (custom user field)	Twitter (custom user field)	group_names

```

---

<div class="post-metadata">

### Author: ![techAPJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/techapj/32/342990_2.png) [@techAPJ](https://meta.discourse.org/u/techAPJ)
#### Post date: [September 24, 2015, 12:36pm UTC](https://meta.discourse.org/t/adding-two-additional-fields-to-user-export/33690/7 "2015-09-24T12:36:27Z")

</div>

Yes, more info was added in user list export on July 15, as per this commit:

> <https://github.com/discourse/discourse/commit/7a1694f1aca8701fc6e1bf6e0207b7ffd6cd08a4>

Update your instance, and enjoy the :discourse: 1.4 goodness! 😊

---

<div class="post-metadata">

### Author: ![alefattorini](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/alefattorini/32/119928_2.png) [@alefattorini](https://meta.discourse.org/u/alefattorini)
#### Post date: [September 24, 2015, 12:43pm UTC](https://meta.discourse.org/t/adding-two-additional-fields-to-user-export/33690/8 "2015-09-24T12:43:04Z")

</div>

Thanks! Therefore ignore my request, I didn’t know this thing. I’m gonna update soon!

---

<div class="post-metadata">

### Author: ![techAPJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/techapj/32/342990_2.png) [@techAPJ](https://meta.discourse.org/u/techAPJ)
#### Post date: [September 24, 2015, 12:44pm UTC](https://meta.discourse.org/t/adding-two-additional-fields-to-user-export/33690/9 "2015-09-24T12:44:02Z")

</div>


