Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerMessenger › PowerMessenger General / Announcements › Use PM with existing user DB?

Use PM with existing user DB?

Thread began 8/13/2011 8:27 am by Sally | Last modified 9/30/2011 9:21 am by a2d | 1739 views | 4 replies |

8/13/2011 8:27 am | #1 Sally

Use PM with existing user DB?

I already have a SQL db with user names and email address' that I use to send out emails using CSS Form Builder. If I get PM for some of the other cool features, is it possible to modify it so that it will use the DB I already have as I don't want to create a second registration and user DB.

Thanks.

8/15/2011 7:24 am | #2 Jason ByrnesWebAssist

you would need to export the data using PHPMyAdmin or another MySQL GUI tool, then import it to the Power Messenger user table.

9/02/2011 10:05 am | #3 a2d

Can you expand on this

I have an excel spreadsheet with a few thousand email addresses I have collected over the years and would like to be able to add them to the database without having to add them one at a time. Are you able to provide quick details for me to upload the emails to the database without having to go through adding them 1 at a time.

I have limited experience using MySQL and have logged in the my PHPMyAdmin before, but if told where to look and what to do that would be helpful. Thanks in advance for your replies.

Thanks,
Ernie

9/02/2011 10:22 am | #4 Jason ByrnesWebAssist

I found this video tutorial on you tube that goes through the basics of importing excel data to a MySQL database:
watch?v=diEwQk4uY14

9/30/2011 9:21 am | #5 a2d

Thanks, I will give it a try soon and let you know

How it works for me.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.