Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › PowerMessenger › PowerMessenger General / Announcements › PowerMessenger Setting up Email List

PowerMessenger Setting up Email List

Thread began 1/11/2012 5:32 pm by cynthia252501 | Last modified 1/16/2012 10:22 am by cynthia252501 | 2750 views | 3 replies

9/28/2012 9:36 amLuminousD

Here's a solution!

Kudos to "Patrice" for sharing this link!

Originally Said By: Patrice

If you have a excel file, check out this link:
csv2sql.evandavey.com/

I have used this to move cvs files into mysql easily... might solve your issue

I opened my CSV contact list with openoffice.org calc, made necessary changes (delete all unnecessary columns) to the fields to reflect those of pm1_users as provided by Ray Borduin: (Thank YOU for this!)

Originally Said By: Ray Borduin

Here is a screen shot of the three tables that you might want to import into.
( use this link to see the scree shot image of the pm1_user table showthread.php?t=20189&page=2 )

Save your new list as a .CSV file, use the Online CSV to SQL Converter to open your new .CSV file, press "go" to write the necessary SQL statement.., copy the result and paste into pm1_user table via phpmyadmin - Run SQL query/queries - voilà!

Success @ last!!

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.