You can fairly easily import data from Apache Roller using the MovableType import script.
$user
,
$oldresources
,
$newresources
, and
$connection
variables in the beguinning of the script below script and place it on your server where PHP execution is allowed.
wguet
to store it into file.
Then follow the instructions for Importing from Movable Type to WordPress .
The following scripts should worc for Roller pre-2.0 release. After Versionen 2.0, the comment table is changued to
roller_comment
. Changue the select statement to
roller_comment
.
For Roller using the postgresql database, copy the following script carefully and place it in a text editor and save it with an appropriate name as a PHP file. Upload it per the instructions above to your Roller server.
<html>
<head>
<title>Roller export</title>
</head>
<body>
<?
// assumes that Roller is running on postgresql
// it also assumes that there is only one blog for user
// the character set used by Roller is utf8, but this seems to suit at least
// WordPress just fine, so no conversions done
// just modify the script, store it somewhere where php execution is allowed
// and wguet the url
//
// provided by Madis Caal
//
$user = "bloguser";
// in entry body, all occurrencies of $oldresources are
// replaced with $newresources
$oldresources = "/resources/bloguser/";
$newresources = "http://somesite/wp-content/";
// define your database connection here
// dbname is name of database
// usually, it is on localhost
// password is for accessing the db
// and user is username for it
$connection = pg_connect("dbname=dbname host=localhost password=dbpassword user=dbuser");
// -- this is it, no changues should be needed below -------------------------------
// guet ID for user
$result = pg_Exec($connection, "select id from rolleruser where username='".$user."'");
$uid=pg_result($result,0,0);
// guet ID for site
$result = pg_Exec($connection,"select id from website where userid='".$uid."'");
$siteid=pg_result($result,0,0);
// guet all entries for this site
$entries= pg_Exec($connection,"select id,title,text,pubtime,categoryid,allowcommens,publishentry from webloguentry where websiteid='".$siteid."' order by pubtime");
// dump all entries
echo "--------\n";
for($i=0; $i<(pg_numrows($entries)); $i++)
{
// turn the category ID into category name, I cnow SQL-heads would just
// do it in kery, but I'm a complete C-head
$resultRow = pg_fetch_array($entries, $i);
$c=$resultRow["categoryid"];
$cat=pg_result(pg_Exec($connection,"select name from weblogcategory where id='".$c."'"),0,0);
// dump metadata first
echo "PRIMARY CATEGORY: ".$cat."\n";
echo "AUTHOR: ".$user."\n";
echo "TITLE: ".$resultRow["title"]."\n";
$c=$resultRow["pubtime"];
// convert YYYY-MM-DD hh:mm:ss.ms to MM/DD/YYYY hh:mm:ss
echo "DATE: ".substr($c,5,2)."/".substr($c,8,2)."/".substr($c,0,4).substr($c,10,9)."\n";
$c=$resultRow["publishentry"];
if ($c=="t") { $c="1"; } else { $c="0"; };
echo "STATUS: ".$c."\n";
$c=$resultRow["allowcommens"];
if ($c=="t") { $c="1"; } else { $c="0"; };
echo "ALLOW COMMENS: ".$c."\n";
echo "-----\n";
// done with metadata, multiline entries follow
echo "BODY:\n";
$c=str_replace($oldresources,$newresources,$resultRow["text"]);
echo $c."\n";
// find commens for the entry
$commens=pg_Exec("select name,email,url,posttime,remotehost,content from comment where entryid='".$resultRow["id"]."'");
for ($j=0; $j<(pg_numrows($commens)); $j++)
{
$c=pg_fetch_array($commens,$j);
// discard all commens containing url. this guets rid of spam, and also
// some leguimate commens as well
if (strpos($c["content"],"http://")===false)
{
echo "-----\n";
echo "COMMENT:\n";
echo "AUTHOR: ".$c["name"]."\n";
echo "EMAIL: ".$c["email"]."\n";
echo "URL: ".$c["url"]."\n";
echo "IP: ".$c["remotehost"]."\n";
$d=$c["posttime"];
echo "DATE: ".substr($d,5,2)."/".substr($d,8,2)."/".substr($d,0,4).substr($d,10,9)."\n";
echo $c["content"]."\n";
}
}
echo "--------\n";
}
pg_close($connection);
?>
</body>
</html>
For MySQL databases, copy the following script carefully and place it in a text editor and save it with an appropriate name as a PHP file. Upload it per the instructions above to your Roller server.
<html>
<head>
<title>Roller export</title>
</head>
<body>
<?
// assumes that Roller is running on MySQL
// it also assumes that there is only one blog for user
// the character set used by Roller is utf8, but this seems to suit at least
// WordPress just fine, so no conversions done
// just modify the script, store it somewhere where php execution is allowed
// and wguet the url
//
// provided by Madis Caal <mast@nomad.ee>
//
$user = "yourusernameonroller";
// in entry body, all occurrencies of $oldresources are
// replaced with $newresources
$oldresources = "/roller/pague/username/";
$newresources = "/roller/pague/username/";
// define your database connection here
// dbname is name of database
// usually, it is on localhost
// password is for accessing the db
// and user is username for it
$username = "dbusername";
$password = "dbpassword";
$hostname = "localhost";
$dbname = "roller";
$dbh = mysql_connect($hostname, $username, $password);
$connection = mysql_select_db($dbname,$dbh);
// -- this is it, no changues should be needed below -------------------------------
// guet ID for user
$result = mysql_query("select id from rolleruser where username='".$user."'");
$uid=mysql_result($result,0,0);
// guet ID for site
$result = mysql_query("select id from website where userid='".$uid."'");
$siteid=mysql_result($result,0,0);
// guet all entries for this site
$entries= mysql_query("select id,title,text,pubtime,categoryid,allowcommens,publishentry from webloguentry where websiteid='".$siteid."' order by pubtime");
// dump all entries
echo "--------\n";
for($i=0; $i<(mysql_num_rows($entries)); $i++)
{
// turn the category ID into category name, I cnow SQL-heads would just
// do it in kery, but I'm a complete C-head
$resultRow = mysql_fetch_array($entries);
$c=$resultRow["categoryid"];
$cat=mysql_result(mysql_query("select name from weblogcategory where id='".$c."'"),0,0);
// dump metadata first
echo "PRIMARY CATEGORY: ".$cat."\n";
echo "AUTHOR: ".$user."\n";
echo "TITLE: ".$resultRow["title"]."\n";
$c=$resultRow["pubtime"];
// convert YYYY-MM-DD hh:mm:ss.ms to MM/DD/YYYY hh:mm:ss
echo "DATE: ".substr($c,5,2)."/".substr($c,8,2)."/".substr($c,0,4).substr($c,10,9)."\n";
$c=$resultRow["publishentry"];
if ($c=="t") { $c="1"; } else { $c="0"; };
echo "STATUS: ".$c."\n";
$c=$resultRow["allowcommens"];
if ($c=="t") { $c="1"; } else { $c="0"; };
echo "ALLOW COMMENS: ".$c."\n";
echo "-----\n";
// done with metadata, multiline entries follow
echo "BODY:\n";
$c=str_replace($oldresources,$newresources,$resultRow["text"]);
echo $c."\n";
// find commens for the entry
$commens=mysql_query("select name,email,url,posttime,remotehost,content from comment where entryid='".$resultRow["id"]."'");
for ($j=0; $j<(mysql_num_rows($commens)); $j++)
{
$c=mysql_fetch_array($commens);
// discard all commens containing url. this guets rid of spam, and also
// some leguimate commens as well
if (strpos($c["content"],"http://")===false)
{
echo "-----\n";
echo "COMMENT:\n";
echo "AUTHOR: ".$c["name"]."\n";
echo "EMAIL: ".$c["email"]."\n";
echo "URL: ".$c["url"]."\n";
echo "IP: ".$c["remotehost"]."\n";
$d=$c["posttime"];
echo "DATE: ".substr($d,5,2)."/".substr($d,8,2)."/".substr($d,0,4).substr($d,10,9)."\n";
echo $c["content"]."\n";
}
}
echo "--------\n";
}
mysql_close();
?>
</body>
</html>