Migrating from drupal to liferay 6.2

[Melvin Williams, módosítva 10 év-val korábban]

We have a intranet solution based on drupal with mysql. I'm trying to migrate to liferay 6.2. In our intranet there are many articles. How can I import the contents into liferay. Extracting the data is not the problem. But I'm facing several problem inserting the data into liferays database wich runs on mysql. Could anyone advise me whats the best method to import the contents.

[Victor Zorin, módosítva 10 év-val korábban]

You cannot use DB to DB migration, must write a custom code. A couple of relevant links below:

Web site WEB CONTENT(e.g. html) migration to Liferay

How to use liferay for Larger Sites

Migrate foreign data

We've got code somewhere for migrating articles from WordPress database into Liferay (6.1), I probably can post it if can find...

[Melvin Williams, módosítva 10 év-val korábban]

Thanks for the links. I wrote a perl script that extracts the data from drupals DB and inserts it into liferay. But I think it messes with the primary keys. So I guess I must do with Java and the liferay API. What kind of project should I use for that hook, service builder or portlet?

[Ravi Kumar Gupta, módosítva 10 év-val korábban]

A simple portlet should do the job.

[Melvin Williams, módosítva 10 év-val korábban]

Is it sufficient to create the JournalArticle? Or do I have to create AssetEntries and JournalArticleResources too? What about the keys/ids how are they generated? Can I choose some arbitrary key seed and count up from there?

[Ravi Kumar Gupta, módosítva 10 év-val korábban]

CounterLocalServiceUtil.increment() will give you a new key everytime. And this key will never conflict with any liferay existing keys. You will need permissions as well. You can check the code in tomcat/webapps/root/html/portlet/asset* and Journal* for more info.

Also, go through the links shared by Victor. Those will help you to understand more about the process and problems.

[Melvin Williams, módosítva 10 év-val korábban]

Thanks a lot for the help. I will try to write a simple importer portlet.

[Melvin Williams, módosítva 10 év-val korábban]

I just found out that my perl script is working. The only thing I missed was updating the Counter table. Therefore liferay trying to increment ids createt duplicate keys. Now I updated the counter table after succesfull import and everything is working fine.

[Juan Gonzalez, módosítva 10 év-val korábban]

Hi Melvin,

it would be great if you can share that script, so others can do the same task successfully.