close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues


Importing existing names and emails from a CSV file

Thread began 9/26/2011 3:36 pm by Mac McCarthy | Last modified 9/27/2011 6:29 pm by Mac McCarthy | 1052 views | 2 replies |

Mac McCarthy

Importing existing names and emails from a CSV file

Hi Support

I have used your suggested (in a previous post) tutorial in import a csv file, which was very straight forward. This was OK importing one csv file into the database either replacing or merging with the existing data.

I now have a new client with a requirement to import approximately 1000 addresses into PowerMessenger and have them split into 4 groups.

These 4 groups receive different mailshots most of the time but occasionally they all receive the same mailshot.

I can see that this is straight forward in PowerMessenger to set up from scratch, as they register one at a time and then subscribe to each of the mailshot groups as required. They can even subscribe to one or all four, their choice.

My question is with a 1000 emails which already have a preference for the mailshot group in a csv file, how would I import them into the users table and preserve the preferences for mailshot groups?.

Thanks in advance for any advice.


Sign in to reply to this post

Jason ByrnesWebAssist

this will not be possible to accomplish in the csv import because of the database structure used for setting the groups that a user is subscribed to.

the database structure uses a user table to define the Users.

a groups table to define the mailing groups.

It then uses the pm1_groupsubscriptions to assign users to the groups they are subscribed to.

Sign in to reply to this post

Mac McCarthy

Thanks for the explanation Jason.

Sign in to reply to this post

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question





Ease of use


security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...