PowerStore 2 and PowerMessenger

Hi
I am trying to integrate PowerMessenger into an existing PowerStore 2 site.

Obviously PowerStore 2 has registration pages and as its been up and running for over a year we have 1000 odd people registered.

Is it possible to get PowerMessenger to access the client details we have within PowerStore or does it need its own database.

If it needs its own database I presume we can import the contacts from the PowerStore database into PowerMessengers database using MySQL tools somehow.

I don't really want to strip out PowerStores registration system and integrate the PowerMessenger one as I don't think have the skill to do this.

Any help or pointers would be appreciated.

mark

using PHPMyAdmin or another MySQL GUI Tool, you could export the information from the Power Store users table to the power messenger users table.


if both power store and power mailer use the same databse, you could also use the following query:

INSERT INTO pm1_users (UserEmail,
                       UserPassword,
                       UserFirstName,
                       UserLastName,
                       UserCity,
                       UserState,
                       UserZip,
                       UserEmailVerified,
                       UserRegistrationDate,
                       UserVerificationCode,
                       UserIP,
                       UserPhone,
                       UserFax,
                       UserCountry,
                       UserAddress,
                       UserAddress2,
                       UserGroupID) 
(SELECT UserEmail,
        UserPassword,
        UserFirstName,
        UserLastName,
        UserCity,
        UserState,
        UserZip,
        UserEmailVerified,
        UserRegistrationDate,
        UserVerificationCode,
        UserIP,
        UserPhone,
        UserFax,
        UserCountry,
        UserAddress,
        UserAddress2,
        UserGroupID
FROM ps4_users)

if you already have users in the PowerMailer database though, this will not prevent duplicates