[module] Convert Joomla! 1.0 to Drupal 6

.

I need a detailed explaination of how to migrate from joomla to drupal .
step by step procedure or any reference website ids are needed plz reply me

Hi. It`s a good module and works fine! I`ve imported all of my contents to Drupal succesfully. But there are a little problem with it that it creates one and only vocabulary "Topics" and puts all sections and categories as terms. We`ll I guess you`re aware of it :-) I have about 50 sections/categories and 3600 articles. It`s a big mess managing such many entries in Drupal admin! ... I also tried out another module http://drupal.org/project/joomla - But I also have some problems with this too (I`ve just posted Issue here http://drupal.org/node/272268 ). This module does that what I need: correct copy of sections/categories structure. Is it possible to make some changes to your module also to do so instead of creating single vocabulary "Topics"?

p.s.didn`t expect that migrating will be such problematic! I`m in Joomla jale :-)

I can't download the file.
Could someone upload it to a other server?

-edit- got it

Thank you for your module. I tried it with mambo 4.5 and drupal 6.3. It works as expected with my encoding latin1_swedish_ci.

Now i just have to go back to the admin area to learn how to use Drupal :)

Hi,
I receive the following error message:
Fatal error: Call to undefined function content_clear_type_cache() in /modules/joomla2drupal/joomla2drupal.module on line 887
I am running drupal 6.3
Any ideas?

Hi there,

I have successfully used your module to import the content from a Joomla site into a Drupal site. My question: is there a way to keep the menu information generated in Joomla and bring this into menu_links in Drupal, or do we have to recreate the entire menu structure?

Thanks in advance for your help.

The module works, but there's a problem with the password due to the differences in encrypting methods between Joomla (from 1.0.13) and Drupal.

In fact Drupal only uses MD5 while Joomla now uses a function that generate the md5 of the password, appends to this a string of 16 random charcaters, re-encode this 48 characters (32 for MD5 + 16 for random string) and print the new encrypted md5 string plus the random string in the users table of the database.

Something like xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:xxxxxxxxxxxxxxxx

So the first 32 charaters before ":" are not the simple md5 of the password given by the user.

The only thing to do is request a new password.

:)

Hi jcsio

Thanks for making this available -- it was very helpful in getting me going. However, in the current version of the code it only converts the first 100 users and first 100 content items. Fix is very easy -- in joomla2drupal.module lines 288 and 293, the divisors should be 100 not 1000, since you do 100 items at a time.

-- trampgeek

I hacked the module to accept community builder profile fields as such:

1. Add your custom fields to the profile fields section:

// Create profile fields
    $query = "INSERT INTO {profile_fields} (fid, title, name, explanation, category, page, type, weight, required, register, visibility, autocomplete, options) VALUES (%d, '%s', '%s', '%s', '%s', '%s', '%s', %d, %d, %d, %d, %d, '%s')";
    db_query($query, 1, 'Fullname', 'profile_fullname', 'Your fullname', 'Personal information', '', 'textfield', 0, 0, 0, 2, 0, '');
    db_query($query, 2, 'Address', 'profile_address', 'Your Address', 'Personal information', '', 'textfield', 1, 0, 0, 2, 0, '');
    db_query($query, 3, 'City', 'profile_city', 'Your City', 'Personal information', '', 'textfield', 2, 0, 0, 2, 0, '');
    db_query($query, 4, 'State', 'profile_state', 'Your State', 'Personal information', '', 'textfield', 3, 0, 0, 2, 0, '');
    db_query($query, 5, 'Postal Code', 'profile_postalcode', 'Your Postal Code', 'Personal information', '', 'textfield', 4, 0, 0, 2, 0, '');
    db_query($query, 6, 'Phone', 'profile_phone', 'Your Phone', 'Personal information', '', 'textfield', 5, 0, 0, 2, 0, '');

2. Change the query in the import_users function:

$result = db_query_range("SELECT u.*, c.cb_streetaddress as address, c.cb_state as state, c.cb_zip as zip, c.cb_phone as phone FROM %susers u, jos_comprofiler c where c.id=u.id ORDER BY u.id", $_joomla2drupal_vars['config']['Joomla']['db_prefix'], $start, 100);

3. Insert the Community Builder profile fields into profile_values:

db_query("INSERT INTO {profile_values} (fid, uid, value) VALUES (%d, %d, '%s')", 1, $created_user->uid, $user['name']);
db_query("INSERT INTO {profile_values} (fid, uid, value) VALUES (%d, %d, '%s')", 2, $created_user->uid, $user['address']);
db_query("INSERT INTO {profile_values} (fid, uid, value) VALUES (%d, %d, '%s')", 3, $created_user->uid, $user['city']);
db_query("INSERT INTO {profile_values} (fid, uid, value) VALUES (%d, %d, '%s')", 4, $created_user->uid, $user['state']);
db_query("INSERT INTO {profile_values} (fid, uid, value) VALUES (%d, %d, '%s')", 5, $created_user->uid, $user['zip']);
 db_query("INSERT INTO {profile_values} (fid, uid, value) VALUES (%d, %d, '%s')", 6, $created_user->uid, $user['phone']);

4. Yeah, it's a little ugly, but you'll only be using this module once, eh? Sweep the dirt under the rug.

hello

I tried to use this module to convert my joomla articles to drupal, but I have problem.
This module only migrates 100 first records from joomla content table and in drupal node table I can see only 100 migrated articles.
So how can I change it? I do it on my local server so maybe it is a problem with a local server. But I don't know how and what to change in the code or config files

Any idea?

hi jisio, thanks for this module i already import from joomla with content over 20.000 article and it work great. i change the code so i can import all article. i successfully import all the article but i got problem when import comment, it doesnt insert in table comment. in my joomla database the comment is over 90000 rows. when import article to my drupal it's take 8 hours to complete the import.

i think it would be better for someone that under development sites using drupal like me, if the module that can import data or without truncate the table and rewrite existing data, i think it will reduce time if i want to import newest article in my joomla database. because when under migration to drupal, user from my joomla insert article over 50 article a day. if user can only import the newest article i think it will help someone and it will less consumtion time.

thanx... for this module...:D

Is there anyway to use a SQL dump file for the conversion rather than having to put in Joomla site db access info?

I got the clear cache function error (noted by someone else) when I did try with db connection. But, I would prefer to run a conversion without involving the live Joomla site.

I can build the theme, menus, and users (there are only 6) from scratch in Drupal, but there is a lot of content in Joomla.

This worked so well i can't believe it.

A very sincere thank you.

Subscribing!!

You just saved me a few weeks and several millimeters off my teeth!!

Hi jcisio,

First of all I'd like to thank you for all your work on this module. It will save myself and many others a huge headache.

Are you still actively developing this module? If so, would you consider setting up the module as an official drupal.org contrib module? I plan on adding some features to this module and this would make it easy to share this work with others. If you do not have time or interest in doing this, would you mind if I did? I would of course give you full credit as the module creator.

Thanks,

Malc

edited.

This module doesn`t work in this current version (which you can download from TS post) unfortunately. I tried it with current Drupal 6.19, also downgraded to Drupal 6.2 to try again...
Then I decided to try previous version of module (I remember it worked fine then) and yes, it works!
I can`t see any improvments in current version of module... except it just not working :-)

So my advises:

1. If you want just to import your Joomla site content to Drupal, try this module http://drupal.org/project/joomla
It works fine! It`s quick...

2. Only if you want to import your comments as well then you`ll have to try this module. It works (in previous version as I stated above). I tried it yesterday - it took about 10 hours to import about 6 000 articles + comments.

p.s. If somebody need to download previous version of jcisio`s module make request here...

problem : after a migration, visitor cannot access to node though having permission on "content access".

explanation : nothing's done in table node_access

general solution :
in phpMyAdmin / SQL :
INSERT INTO node_access VALUES (0, 0, 'all', 1, 0, 0) ;
don't forget the prefix ;-)

original french post : http://drupalfr.org/forum/support/support-general/1779-acces-refuse-mess...