Adding two additional fields to user export


(Alessio Fattorini) #1

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?


(cpradio) #2

You can use the Data Explorer Plugin to do this.


(Jeff Atwood) #3

I support adding these fields to the default export @techapj


(Alessio Fattorini) #4

Whoa I can’t ask for more than that :+1:


(Arpit Jalan) #5

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?


(Alessio Fattorini) #6

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

(Arpit Jalan) #7

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! :blush:


(Alessio Fattorini) #8

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


(Arpit Jalan) #9