Posted by Valter Bengtsson on July 25, 2010 at 6:33pm
Which is the easiest way to move 1500 articles from a Joomla 1.5-site to OpenPublish 2.1?
I know there is a module called "Joomla to Drupal", http://drupal.org/project/joomla
Would you recommend using that module with OpenPublish?
/Valter
Comments
Worked well for me but a couple of points worth mentioning...
I used that module to import around 2000 articles from 2 separate joomla sites.
Worked well apart from the joomla formatting was retained, so some double line paragraph spaces appeared when converted to drupal.
Also it converts joomla catagories to taxonomy terms. So watch out for that, if you have lots of categories in joomla.
Apart from that it worked much better than the other method I explored which was to pull all the content out of the db and then try to format before importing it.
It does the job very quickly. But worth running Calais over the content as a batch process to make sense of it all!
Good luck
Text is OK but what to do with images?
Thanks! It seems to be working well with text content, but I had no luck with images when I tested. Do you happen to know how to get the images moved to OpenPublish along with the text content?
Migrating Joomla1.5 to drupal6.19 easy, OP2.2 has issues
So I'm trying to move an existing Joomla1.5 news site to OP2.2. I saw that the joomla module said it needed to be used on a "fresh drupal install," so did that with drupal6.19 and worked great. Articles all came across, created taxonomies from the joomla categories, linked author information and broke the articles up into summary and body. Woohoo, that was easy. OP migration should be a piece of cake.
Did an import from the same joomla site in OP2.2 and it's a mess. Summaries were not split out, authors aren't stored, no taxonomies or anything else useful. Just a text grab into the Body of the article.
Any thoughts on what I can do differently, check or tweak so that an import with the joomla module into OP2.2 would be able to keep this information?
--Jason
The problem with Authors is
The problem with Authors is most likely related with the fact that Joomla module is probably trying to map it with Drupal users, while OpenPublish does not use Drupal users, rather - real Author content type.
There may be something we can do about it, but probably not in the immediate future.
.............................................
http://twitter.com/inadarei
'Patching' Joomla import module
I've begun updating the Joomla module that imports content into Drupal. It currently brings across the content and users but doesn't match them together. I plan to create options to import author node/node_revisions, index them to node/node_revisions and users (when possible).
I originally was doing it as three queries on the OpenPublish side, but realized there was no easy way to make sure create_by_alias values were getting copied into the author node "titles" so this would be the most useful (and community friendly) direction to go.
To make sure I'm not duplicating work or wasting my time, does anyone know of a completed work (module, patch, or simple instructions) that already does this or an effort underway to do this?
--Jason
I'm currently migrating our
I'm currently migrating our database from Joomla to OP. I'm not even bothering with this module though. From what I saw it was quick and easy, but just doesn't have the flexibility I need. Besides that it tries to map authors to Drupal users, I've got a lot of custom fields and CCK stuff that I need to convert. For instance, we have over four hundred articles that have slideshows, and how it's currently working in Joomla is some inline code that a Joomla component fetches from a picasa url and inserts into a smooth gallery. This is almost useless for me. What I have to do is manually parse this inline code, get the picasa album, and do something with the slideshows.
I have other similar problems (audio files come to mind), so I'm just writing all of my conversion code from scratch. I'm just using an empty php file and bootstrapping into Drupal so I can node_save() everything. There are plenty of good resources on doing this method (I'm not at my work computer or I'd link you). Also, the Migrate module does actually look promising (although I still think I need too much customization personally).
Be sure to update us on a solution that works for you! Good luck!
~Kevin
Articles,authors and slideshows
the Migrate and tableWizard modules are neat, but you're right in that it started to be a lot of steps and I wasn't sure if it was going to work all the way out.
I've probably got fifty or sixty slideshows using a joomla plugin that I've got to migrate as well, I'm hoping I can do some DB magic to identify them independently and tag them across into the new system.
I'd appreciate any links you can send me on this. I've really dug into the ones I've been able to find and there are still a lot of "step 1 : remove transmission" assuming that's an obvious set of operations.
Will make anything I can get working publicly available for distribution or general mocking,
--Jason
The resources I've used the
The resources I've used the most so far have been:
http://www.unleashed-technologies.com/blog/2010/07/16/drupal-6-inserting...
http://acquia.com/blog/migrating-drupal-way-part-i-creating-node
~Kevin