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.