User data structure for import

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
6/19/2015 5:36:04 PM
Gravatar
Total Posts 5

User data structure for import

I am a developer and have experience with MSSQL server. I am looking for some documentation or just help with the user data structure. I am moving a user base from a joomla implementation to mojoportal and am willing to do a manual conversion I just need some guidance on exactly what is needed to make it work. I have looked through the structure and could guess but that is a time intensive trial and error process unless there is some info you could give me to help that be a little quicker. I am also using Site Membership Pro so that is also a piece I have to deal with. Any help you could give would be greatly appreciated. Thanks.

6/19/2015 5:50:29 PM
Gravatar
Total Posts 5

Re: User data structure for import

I should add that I am using version 2.4.0.3

6/20/2015 10:24:04 AM
Gravatar
Total Posts 18444

Re: User data structure for import

when a user is created a row is created in mp_Users table and the user is automatically added to the role "Authenticated Users" creating a row in mp_User roles table. So migrating form another system you would want to put data in those tables.

I don't know of a good way to migrate passwords from another system unless they are in clear text it is not likely that you will be able to migrate them so you would probably need to generate a random password and then the users will have to use password recovery to reset it (there is nothing built in to mojoPortal to globally reset user passwords so it would have to be done by the user either clicking the recover password link or if they enter the wrong password 3 times in a row it will auto redirect to password recovery). probably best if the site is configured for clear text passwords before migration, so you would have to generate random clear text passwords on import, then you could change to something else after migration.

use of site membership pro is not relevant to the problem of migrating data. smp doesn't care how the data was created, it only manages role memberships for existing user rows with a purchase history.

other than that I have no specific advice as I don't know anything about the data structure in joomla

You must sign in to post in the forums. This thread is closed to new posts.