Page 1 of 1

Player roster

Posted: Fri Jan 22, 2021 9:25 am
by Goodshoe
With my members' permission, I would like to publish a roster of all the players on my site. We have 40 or so players. I want to publish the usernames, real names, email, and possibly mobile phone numbers (entered as a custom field when player registers).
Is there a way to export this information into a table or CSV file?
I tried to simply copy and paste the information from the HTML table from the admin screen, but the result looked petty bad and was hard to format.
Thank you!
Scott Goodman

Re: Player roster

Posted: Fri Jan 22, 2021 10:40 am
by Kent Briggs
Use the Export button on the Accounts tab in the Windows interface. That will create a text file of JSON objects. Go to a JSON to CSV converter web site like this one:

https://json-csv.com/

Upload your JSON file, click convert, download your CSV file.

You may want to manually delete the first header line of the JSON file (using a plain text editor) before uploading to get a cleaner output file. The header line looks like this:

Code: Select all

{"FileType":"AccountSettings","Version":"6.27"}