Page 1 of 1

[Solved}Migrating users to CMSMS using FrontEndUsers

Posted: Sun Sep 19, 2010 5:47 pm
by EoinDubh
I am migrating an existing phpWebsite to CMSMS 1.82. There is some protected content so I have looked at the documentation for FrontEndUsers 1.12.2 ans calgut1000's documentation on Hiding Private Content. I have that working and have manually added a couple of users who can login and out and the restrictions are applied properly.

I extracted the userlist from the old database and formatted it per the FrontEndUsers admin link as such:

Code: Select all

##userid,username,password,email,full_name,groupname
, Pete, xxxxxxxx, xxxxxxxx@xxxxxxxx.net,Xxxx Xxxxxxxxx,Members
When I import it (I am using just one person until I get it working) it completes without error and if I check the database, the user is there. However the user cannot login and gets a "Login failed - Invalid username or password?" error.

There are 2 user properties defined, full_name and email. The cms_module_feusers_users table contains only 5 fields: id ,username ,password ,createdate and expires.

If I create a user manually from the FEU>Uuers tab, that user can login properly.

What am I missing here?

Re: Migrating users to CMSMS using FrontEndUsers

Posted: Mon Sep 20, 2010 12:05 pm
by michaelwalker
There are other tables holding (some of) the users' info.  Have a look in cms_module_feusers_properties and also cms_module_feusers_belongs to make sure your records have imported successfully and contrast one you imported with the entry(s) for the one you created manually.

Re: [Solved}Migrating users to CMSMS using FrontEndUsers

Posted: Sun Sep 26, 2010 7:11 pm
by EoinDubh
I ended up doing a dump from the suggested tables and creating a .csv file with the correct fields from the 3 tables in the above post from michaelwalker. I tried to import just 1 user and had to do a bit of tweaking but when I got it worked out, I was able to import all the users from the old site without issues. Thanks.