How To Extract Member Info

I want to email my members using a external mailing system. How do I extract their info.

Bare min. I guess all I need is email address, but Username name would be nice as well

Run this sql on your DB
SELECT `NickName`, `Email` FROM `Profiles`

Then Export it as an CSV or Excel file

Thanks, havent tried it yet but your help is always spot on.

Is there a way to Import members from my previous site to D7?

If your previous site is a D6.1.6 site, You can attempt to use the Migration Tool that is included with D7.

Im coming from a previous platform.

I have a CVS file saved.

If you are coming from another CMS program, Im sure the profile tables will not match so you will not be able to do a straight import. You would have to write a script that matches the current profile table scheme.

write a script? uh oh! lol

Thats out of the question but thank

There are plenty of people here in the forums or in the market that could right a script for a reasonable price.

The other option is to it manually, export the boonex table to a csv and copy and paste the matching fields from your table into the boonex one.

Then import most likely your members will have to request a password reset but it could work.

I've managed to import over 7000 members from an (not) Able Dating Site to Dolphin 7.

It is not hard once you know what you are doing, but it can be tedious writing the SQL to make it work. And testing everything to be sure it is working is time consuming.

Im new to most of this so I honestly did not follow what you said! lol

If anyone is able to assist me in transferring the members, I can pay.

Thanks, Chris from Sn@tfu

* bump *