Admin Email export

[gutterwall]

It would be really handy to the Root Server Admin, to be able to pull all emails and copy them so we could send out a email blast for updates to formats etc or inform them of updates of the root server functionality.

I have ran queries against the mysql to get it, but it's a hassle that should be a admin button or something.

[pjaudiomv]

this is possible but not easy to get the service body emails I believe you need to have the following setting set in your config $g_include_service_body_email_in_semantic = TRUE;
then you can just hit https://metrorichna.org/BMLT/main_server/client_interface/csv/?switcher=GetServiceBodies and if the email field is filled in it will return it.

To get individual email addresses from the meeting contact fields you must be authenticated, once you login you can hit
https://metrorichna.org/BMLT/main_server/client_interface/csv/?switcher=GetSearchResults&data_field_key=contact_email_1,contact_email_2,email_contact

I created a php gist here that will also perform that task https://gist.github.com/pjaudiomv/5f8dedb1f2c9c22dc1425052aabd7ea6

[pjaudiomv]

.... oh you want root server admins ... thats a different thing :(

[pjaudiomv]

yea there's no general like get_users semantic admin endpoint so I dont think that is possible and your right you would just have to write an sql query.

[pjaudiomv]

SELECT DISTINCT email_address_string from na_comdef_users; but yea that is far from ideal

[pjaudiomv]

yea I could see just being able to dump that whole table for the most part as a csv or something as a server admin would be pretty useful

[pjaudiomv]

this would get all user emails from db https://gist.github.com/pjaudiomv/5f8dedb1f2c9c22dc1425052aabd7ea6#gistcomment-3639473