close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues


Importing to the database

Thread began 5/12/2011 9:15 am by drayschermerhorn146715 | Last modified 5/12/2011 2:37 pm by Jason Byrnes | 863 views | 3 replies |


Importing to the database

I read through the previous posts on importing email addresses and didn't find the walk-through mentioned, so I've started this thread to get specific information about importing to the database.

First, what is the minimum amount of data that needs to be imported to get a working list of email addresses?

Can I import simply UserID, UserEmail, UserFirstName, and UserLastName? This would mean that there is no password assigned. Is this workable?

This approach leaves empty some fields that might be important to PowerMessenger - UserRegistrationDate, UserVerificationCode, among others - so I want to be sure the system won't get confused.

Secondly, what about other tables in the database? Do I also need to import something into groupsubscriptions and usergroups? And if so, specifically what?


Sign in to reply to this post

Jason ByrnesWebAssist

there is no one answer to this question.

the minimum _database_ requirement would be an email address.
But you need to take into consideration the mailing audience settings.

If you set the audience to use the users first name and it is empty, that user wont be in the audience.

you also need to take into account the email you configure, and what user tokens you are using.

also, if you leave the password column blank, the user will not be able to login to change any of their settings or to opt out of the mailing, opt in to new mailings that you offer.

to just send a mailing, you only need the email address, but other parts of the whole application need other aspects of the database to have values in order to function.

Sign in to reply to this post


I guess I need to clarify what I mean.

I obviously want to use the system the way it is intended to be used. Since PM does not include an import function, I want to import a mailing list. But that mailing list will not include all of the fields in the users table. So, for example, it will not include UserEmailVerified.

If this field is empty, will PM still function, or do I have to put in a dummy value?

I will want the imported email addresses to belong to an audience. Can I assign them to an audience later, in the admin function, or should I input some value in the audience field when I import the data?

Basically, I'm looking for some guidance in importing a mailing list. I can't find any info in the forum, and the documentation is lacking. The alternative is for me to input the user information for each of the people via the add user function.

But even though I want the minimum info to be name, email and password, the add user screen insists on all of the other information. This isn't a feasible way to get started.


Sign in to reply to this post

Jason ByrnesWebAssist

Again, there is no one answer for this question.

In the settings panel, there is the option to include Email Verification or not, If verification is enabled and you do not include a value for verification on the import, the user will be able to click a button to have the verification email sent to them. If you dont enable verification, then it wont matter.

You configure the audiences when you configure the mailing.

The audience can be set to use any of the users table column values.

It could be set to send to all users whose first name is a specific value for example. your import will need to include any columns that you plan to use in the audience settings.

Your asking for specific details on a very hazy subject, I just cant give you the specifics you are asking for.

the required columns depend on you. It all depends on how you are going to configure the mailings to work.

the best advice I can give you is to register a couple of users and play with the mailings.

Get familiar with how the registration process works, how configuring the audiences works, and how sending out a mailing works, I pretty confident that once you work with it a little bit, it will become clear to you what data will need to be included in the import for the way you are setting the mailings up.

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...