Recently I installed drupal to replace an existing site running mambo.
Something was out of date and the site was hacked.
After trying to restore the site for a few minutes, I just gave up and forwarded the site to the drupal install.
The database is intact.. so its just a matter of importing a few relevant tables.
I had a few questions after reading
> http://drupal.org/node/80195
> 3. In this guide I assume you have a forum in your Joomla site. Drupal has built-in Forum Discussion then you don't need to install additional module
I was using simpleboard 1.1. How can I import the threads?
A lot of very important content is held here, although converting this information is a lower priority than converting the content / users tables over.
> 1. Joomla only supports single Section/Category
> First, you must transfer all Joomla-Sections to Drupal-Categories
There is a lot of important content saved from the mambo site, however it is not well categorized.
All existing content can be assigned to a default category.
No category info needs to be imported, Im looking forward to assigning multiple categories to much of the content.
> Introtext vs Teaser..
I didnt follow this. I want is to make sure that -all- content is saved.
What method do I use here?
> I assume you use Joomlaboard forum for Joomla. In Drupal, forum is built-in, then you only need enable it on administer-module then show it on certain front page section using administer-blocks. You must transfer Parent-Forum Category of Joomlaboard to Drupal-Forum Container and Child-Forum Category to Drupal-Forum Category. Again, I am using SQLyog to transfer the entire forum contents, SQLyog is very easy because its GUI.
Im using simpleboard. How can I convert the forum over ?
> Usually better to install Drupal in a folder such as domainname.com/drupal, so you can still access both website during this migrating.
Yes, unless your site has been recently hacked. : )
The last note is exactly why I am in need of help. I was planning on learning a little more about a few of these items before applying it. Both sites were functional until yesterday. Please help me move forward into this new drupal site.
In real life, I am actually a coldfusion programmer and am donating this time to my little brother who is studying to be a missionary.. his site has some amazing content on it and its a really good cause to help out with. Im in a little over my head here, but Im going full on until its working.
Thanks for any feedback on this conversion!
www.surfpurpose.com - see the site as the conversion progresses.
Comments
Narrowing it down..
I have spent a good amount analyzing the data & have trimmed the mambo database down to 14 tables.
Some of them just have a few tidbits of info about the users.
My current plan is to work in this order
( There is exactly 100 registered users, so I am going to reconcile 3 or 4 tables into a master list using excel or similar app )
1. Piece together User data. There is exactly 100 registered users, so I am going to reconcile 3 or 4 tables into a master list using excel or similar app, and mambo is storing things like who is a moderator in all types of places.
2. Learn more about drupals db schema & Match column names
3. Import User data
**** Passwords question here **** They both are generating the same length hashes. Is there -any- chance that the password will not have to be reset and essentially "remain the same" .. (Im doubtful but one can hope)
4. Work on content items
5. Forum - which will require analysis of 4-5 tables. No problem, there is only 1200 rows in that. Not too bad considering how big it could have been.
All in all, its now looking very approachable.
Any tips here would be greatly appreciated!!
Re: Node Import & User Import
I don't know of any automated scripts to take care of this directly, but I would point you to the Node Import and User Import modules. i have used the Node Import module and the User Import module appears to have the type of functionality you are looking for. They both accept CSV files and should make it much easier for you to import the information without having to do so much matching of Drupal db schema/names etc.
I'm not as familiar with how Mambo (I played around with it a little awhile ago before moving over to Drupal but have forgotten most of my experience with it) handles moderators etc, but recommend setting up separate roles in Drupal prior to importing your users (perhaps something as simple as a moderator role). There is already a authenticated user role with Drupal by default so you will only need to create a role for individuals that you will be given additional privileges too.
Anyway, hopefully pointing you to those modules helps (perhaps you already knew about them :) )
Here are the links right to their project pages:
http://drupal.org/project/user_import - for users
http://drupal.org/project/node_import - for content
One note about node import is that it hasn't been converted to work with Drupal 5.x yet. If you are planning on rolling out a 5.x site here is a couple of hints about how to use node import while still having a 5.x site:
http://drupal.org/handbook/modules/node_import#comment-199212
Sounds very good..
> the Node Import and User Import modules
These sound very promising .. you just presented a target for me to aim at. I think Im just dangerous enough in phpmyadmin now to get them far enough, sort a few things in the spreadsheets and csv them into the aforementioned import features.
Thanks for the advice !
> One note about node import is that it hasn't been converted to work with Drupal 5.x yet.
Doh.. just when I thought this was going to get simpler, Im running 5.1
Did you manage to convert
Did you manage to convert your forum? I could really need some help with this. Can't find any solution or guide in the web.
...
No, I never did get the forum back imported.
Plan to just dump the threads text format / chronological order... just to save some of them.
The thing was, just converting the schemas, I didnt have time to write a script to upgrade it.
I was told a simple way in
I was told a simple way in another forum, it worked perfectly.
I installed phpBB2 and converted my joomlaboard ( there is a converter existing).
Then I installed drupal 4.7, imported from phpBB2 (again there is a converter for this), and finally I updated to drupal 5.1. Everything worked great, even the Users were imported and all threads and posts were perfectly assigned.
With the JB2phpBB2 converter I had to play around a bit but finally it worked.
Joomlaboard to phpBB convertor
Hope it hwill help you too.