+1
Completed

Private user emails - private forums

Israelize 6 years ago in Usability & Interface • updated by Vladimir Mullagaliyev (co-founder) 6 years ago 13
Is there a way to download private user emails to a csv format (or any format?)

Answer

Answer
Completed
Hello Andrew.
We found a variant of the solution without the implementation of export. You need to narrow the size of the browser window so that all email addresses are lined up in one column. Then you can copy and paste all email addresses in Word, Excel, Notepad or other editor.
Started
We able to add API call that will allow you to get list of emails that has private forum access. It's will return data in json or xml format.
If this variant suitable for you we able to add it within 24hours.
I believe that should work. Does this mean I need to work through you to get the data every time? Perhaps I'm not clear on the "API call". Also, would this cost us extra?
Find our here our existing API that allow to get misc data.

No extra cost we just add another API call which will look like:

http://userecho.com/api/forums/[forum_id]/allowed_users_emails/ and will return users emails.
This is great. Thank you!
Or if this looks like very complicated. We can just add small button near email list in the web interface, that will return .CSV list.
I would prefer just a small button to get the .CSV list. We have other staff we want to add that are even less technical than I. Thank you.
Also, have you thought of an API to work with mail clients like MailChimp, etc.? Or do we have that option? In other words, to draw email data from MailChimp into the private forum?
Regarding MailChimp. Provide your main idea.

1) For example you have list of subscribers in MailChimp and you want to grant access to a private  forum to all of them.

2) You want to add all your UserEcho private forum users to a MailChimp newsletter list.

Or something else?
I was looking for a way to automate the import from mailchimp into UserEcho. But, copy and paste should work fine for now.
Answer
Completed
Hello Andrew.
We found a variant of the solution without the implementation of export. You need to narrow the size of the browser window so that all email addresses are lined up in one column. Then you can copy and paste all email addresses in Word, Excel, Notepad or other editor.
While true that I can copy and export, it is still pasted into one excel/spreadsheet block. The email values are not separated and end up being one very long string. I am using Chrome. Do you find that browsers make a difference?
I use FireFox. All works fine. But when I check it in Chrome I have the same problem. We will do export for you.
Actually, I got it to work in excel. Thank you.
But, moving forward, I do see it helpful to have both an import/export option with a CSV/excel for private forums.
We have implemented export to CSV. 
It contains all email addresses in a single column. 


Also we improved import mode:
Just paste comma or carriage return separated values in textarea and it will be imported.
Already existing addresses will be skipped.