For a couple of projects on which I work, I use Trello almost daily.
Some people find it the end-all, be-all of project management. I can’t say I agree with that statement, but it definitely helps streamline certain workflows (as far as I’m concerned).
But there’s one complaint that I have regarding the application: There’s no way to export the actual list of members for a given board (at least not at the time of this writing). Sure, you can export a board, but what happens when you want to contact all of the users?
There’s no way to export the actual list of members for a given board (at least not at the time of this writing). Sure, you can export a board, but what happens when you want to contact all of the users?
Sure, you can export a board, but what happens when you want to contact all of the users? I mean, I have a list of the users and their email addresses in a separate database, but Trello doesn’t allow me to export that data.
To export Trello board members, I put together a quick script that can run in the console of Chrome (maybe others, but I didn’t test). At the very least, it will return the names of the member so you can find them in your database, assuming you have one.
Export Trello Board Members
You can find the gist on GitHub (and I’ve shared it below). It’s public so it’s open to modifications, too.
My needs were simple:
- I needed the names returned in an array.
This is what I came up with to suit my needs:
I’ve tried to make it as clear as possible via comments, but this is how it works:
- The source looks for all of the elements with the
member-avatarclass name (as this contains their name and username).
- This generates an HTMLCollection so I convert it to an array.
- The script them loops through the array reading the user’s name and username from the
titleattribute stripped away the username portion.
- The user’s name is then added to an array that is returned when the function’s execution is completed.
From there, you can do as you wish with the resulting array.
To get this to work, load up the Trello board in your browser. Then, launch the console. After that, paste the contents of the gist into the console.
One done, type something such as
n = get_trello_names(); (and Chrome should autocomplete this for you).
At this point, you now have an array of all of the unique names for the members on the Trello board. You can obviously use this however you want.
I use it to locate the user’s email address in another domain. Your use may vary. And remember, this is a public gist so feel free to add comments, forget it, or whatever else.