Next page button on admin / users list?

(bryanlarsen) #1

I’m trying to get the users list out of our forum to see if we get any conflicts if we turn on SSO.

We don’t have many users, so I thought the easiest way to do this would be to cut and paste the HTML table from /admin/users/list into Google Docs. That works great for the first 100 users, but there doesn’t seem to be a next page button. Is it supposed to be infinite scroll? If so it’s broken for me.

I can probably do this by doing a select on the database directly, but the lack of a next page button does feel like a bug to me.

(Kane York) #2

I believe that there’s no pages there because nobody’s really needed it yet.

And yes, you can try something like this:

$ cd /var/docker
$ ./launcher ssh app
Welcome to Discourse Docker

Use: rails, rake or discourse to execute commands in production
$ rails c
irb(main):001:0> User.all.each do |user|
irb(main):002:1*   puts user.username
irb(main):003:1*   nil
irb(main):004:1> end
=> nil
irb(main):005:0> u = User.last
=> #<User id: 10, username: "rikingtest5", created_at: "2014-03-25 15:46:00", updated_at: "2014-03-26 06:01:55", name: "Test Account 5", bio_raw: nil, ...>
irb(main):007:0> puts "#{u.username}\t#{}"
rikingtest5	ka**p****

I think you can probably figure out how to put that all together into a TSV file, right? :sunny:

(Allen - Watchman Monitoring) #3

I’ve had the same need in the Invites… I can see 90 entries, but have no way of viewing all or searching for expired invitations…

So, here’s my +1 for users list pagination

(bryanlarsen) #4

Actually, I used psql, which supports csv out of the box:

sudo su - postgres
psql discourse
copy users to '/tmp/users.csv' delimiter ',' csv header;