Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - How to export the memberlist to a spreadsheet
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

How to export the memberlist to a spreadsheet
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
KillerKellerjr View Drop Down
Newbie
Newbie


Joined: 28 May 2008
Location: USA - Nebraska
Status: Offline
Points: 16 		Post Options Post Options   Thanks (0) Thanks(0)   Quote KillerKellerjr Quote  Post ReplyReply Direct Link To This Post Topic: How to export the memberlist to a spreadsheet
    Posted: 01 July 2008 at 2:52pm
I am looking for a easy way to export the Memberlist possibly by Group allowing me to make sure everyone in my department has signed up for our forum.  I have a few department heads that want to make sure everyone signs up.

Also is there a way to allow Admin to change what forums individuals are subscribed to?  Once again the department heads want to make sure everyone gets emails when a post is made to a subforum to which their group belongs to.

Thanks
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 01 July 2008 at 2:58pm
There is not a built in method to export members to a spreadsheet. However, depending on the type of database used you may find tools online that can export database tables to a spreadsheet.

As the forum admin, if you click on a members profile you will see a button at the bottom to edit that members profile. Clicking the Edit Profile button for a member takes you to their member control panel, from here you can select the subscription tab to see what forums that member is subscribed to.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
KillerKellerjr View Drop Down
Newbie
Newbie


Joined: 28 May 2008
Location: USA - Nebraska
Status: Offline
Points: 16 		Post Options Post Options   Thanks (0) Thanks(0)   Quote KillerKellerjr Quote  Post ReplyReply Direct Link To This Post Posted: 01 July 2008 at 3:06pm
I will look in the code for the table name etc and see if I can perform a query to export into a spreadsheet.

I was able to find that feature but it only allows me to view and delete not add, that portion is missing at the bottom.  I would think as an Admin I could have that privilege to add seeing as I could delete them.

Thanks again for the info Bruce!
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 01 July 2008 at 3:19pm
The reason why you can not subscribe people to email notification is that under anti-spam laws it is illegal. The user has to subscribe themselves to receiving such communication.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
KillerKellerjr View Drop Down
Newbie
Newbie


Joined: 28 May 2008
Location: USA - Nebraska
Status: Offline
Points: 16 		Post Options Post Options   Thanks (0) Thanks(0)   Quote KillerKellerjr Quote  Post ReplyReply Direct Link To This Post Posted: 01 July 2008 at 4:01pm
Originally posted by WebWiz-Bruce WebWiz-Bruce wrote:

The reason why you can not subscribe people to email notification is that under anti-spam laws it is illegal. The user has to subscribe themselves to receiving such communication.


That I understand from a public perspective for public forums but since this is all internal, from my companies perspective it would be nice to have that feature.
Back to Top
elvis711 View Drop Down
Newbie
Newbie
Avatar

Joined: 02 July 2008
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote elvis711 Quote  Post ReplyReply Direct Link To This Post Posted: 24 July 2008 at 9:40pm
I agree with Killer- being able to make the subscription for my members would be very beneficial.  We also are strictly internal and use it to publish outage/disruption information to our internal end users.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.