Topic: Importing users into miaCMS with CB and SMF

I have been doing some research into Mambo and its future. miaCMS looks like it is my most promising option when I do move from Mambo. The one thing that concerns me is the SMF licensing issue and Community Builder supporting future versions of miaCMS. It seems like there are no current issues I just worry about the future since my intent is to find one CMS to stay with.

I posted this on the Community Builder forums but have not received any responses as of yet.  Will CBjuice work with miaCMS? Hopefully someone here can help me out. Thanks.

I am in the process of converting an old asp driven site to Mambo 4.6.5 and CB 1.2 with SMF forums 1.1.7. My dilemma is with importing existing data into custom fields. I have searched this forum as well as many others but cannot find a definitive answer so hopefully someone here can help me out. I have found some but it is either for older versions of Mambo or for Joomla.

I have two access databases, one for a forum (which I can successfully convert to SMF) and one for a crew list for a US Navy ship. Both databases have overlapping data meaning that some forum users are also listed in the crew list but not all. There are about 940 entries in the crew list and 313 members in the forum.

I can get all of the forum members imported into SMF and then sync them with Mambo and CB but I am not sure how to go about importing the crew list database. The crew list does not have a password field but has last name, first name, middle initial, email, and 7 other fields that I need to import into custom fields in CB. I am not all that familiar with PHP or MySql but can either create a CSV file or convert the access database to MySql.

I would like to import all of these users, have random passwords generated, and email the users their new information. It looks like CBjuice could possibly do this but I believe that it is only for Joomla. I do not want to use Joomla because of the SMF bridge licensing issue. I realize that I will have some manual editing to do but do not want to manually create all of these accounts.

Hopefully someone here can point me in the right direction. Thank you.

Re: Importing users into miaCMS with CB and SMF

Let me tackle the licensing question for you. As far as the MiaCMS team is concerned there is no licensing issue.  MiaCMS is released under the GPL, always has been, and always will be.  We acknowledge all past and present contributors to both Mambo and MiaCMS for their fantastic efforts in helping build this platform.  Anyone is free to utilize and develop against MiaCMS as they see fit as long as they comply with the terms of the GPL.  We are more than happy and willing to work with any 3rd party developer wishing to developer for the MiaCMS extensions platform.  Most all Mambo 4.6.x and Joomla 1.0.x extensions extensions will work perfectly fine in MiaCMS without any modifications.  Some will require changes, but typically those changes are fairly minor.   That is how things stand today, but these three platforms continue to diverge from one another with each release so eventually 3rd party developers will most likely have to maintain separate versions of their extensions for each CMS and/or target only specific ones.  It is unlikely that extensions will continue to work across all three platforms equally as can already be seen in Joomla 1.5.x.

We have worked with the Community Builder team to make sure CB works with MiaCMS and we are happy to continue doing so.  We have offered our support to SMF as well, but up to this point they have not developed a version for MiaCMS specifically.  That being said a number of users have reported that the Mambo bridge works just fine in MiaCMS as is.

http://brilaps.com
http://opensourcepenguin.net

Re: Importing users into miaCMS with CB and SMF

Thanks for the reply cauld. After reading this post http://forum.miacms.org/viewtopic.php?id=57 it seems like there is some kind of (perceived) problem about miaCMS' license by SMF. Hopefully that can be rectified in the future. It seems that the current Mambo bridge will work to bridge SMF and miaCMS but I am not sure what the future will bring.

As for my import issue... does anyone have any suggestions???

Re: Importing users into miaCMS with CB and SMF

Snipe wrote:

Thanks for the reply cauld. After reading this post http://forum.miacms.org/viewtopic.php?id=57 it seems like there is some kind of (perceived) problem about miaCMS' license by SMF. Hopefully that can be rectified in the future.

No problem.  Like I said, from our standpoint there is no issue.  How they interpret the license is up to them.

http://brilaps.com
http://opensourcepenguin.net

Re: Importing users into miaCMS with CB and SMF

Any ideas about my importing question?