On 4/17/07, fritz <[EMAIL PROTECTED]> wrote:
In vain I've searched for information on exporting a blog on Wordpress to Roller. Does anyone have any pointers, hints, ideas that might be helpful? I've got full admin rights on both systems so even some queries to convert one to another would be fine.
Unfortunately, you're going to have to write some code. I'd suggest using Groovy (http://groovy.codehaus.org/) because it's so easy-to-use for SQL, XMLRC and can easily call Java APIs. Here are three possible approaches: 1) Use Groovy to SQL query Wordpress and write to Roller API 1.1) Take a look at the experimental Roller/Groovy scripts here: http://tinyurl.com/2l2no4 1.2) The README.txt explains how to use the scripts: http://tinyurl.com/2urbw6 1.3) Write a Groovy script to: 1.3.1) Query the Wordpress database via SQL via JDBC. 1.3.2) Call the groovy scripts to create users, blogs, entries and comments - createuser.gy - http://tinyurl.com/3cwy9j - createblog.gy - http://tinyurl.com/2wnc34 - createentry.gy - http://tinyurl.com/2trho9 - createcomment.gy - http://tinyurl.com/2jlwke 2) Use the MetaWeblog API to read entries from Wordpress an write them to Roller (you could use the ROME Propono BlogClient library to do that, or Groovy XMLRPC). The problem with that approach is that you won't get comments. 3) Query Wordpress via SQL and then use SQL to create entries, comments, etc. The problem with this approach is that you must have a full understanding of the Roller data model and you must get all the relationships right. Hope that helps. Check back if you have more questions, comments or want to share code. - Dave
