Thread

I use Serendipity (an excellent open-source software, http://www.s9y.org) to publish a blog, but I would like to integrate it with a forum and a wiki. So, EE seems to be an excellent choice.

So, I will use EE if I can import all my Serendipity blog (entries, categories, users and comments). Is it possible?

Thanks.

Not familiar with Serendipity but the most common way of importing from other blog/cms packages is to first export from them into a MoveableType format. Some packages have this feature builtin. Once in that format, EE has an import MT function.

Alas, there is no MT export in Serendipity…

Thanks.

See this thread for some suggestions.

Thanks a lot. I’ll give this a try.

I have tried the RSS to MT translator, but it doesn’t work: I only get file with titles and categories, but neither text nor comments.

Another idea? Thanks.

Well, you could try CSVGrab- that might work.  Or the data are in a mysql database- correct?  Could you just run some queries to output the data in MT format?

Hi Robin,

Thanks for your answer.

Or the data are in a mysql database- correct?  Could you just run some queries to output the data in MT format?

Can you give me an example?

By the way, wouldn’t it be useful for EE to have more importers? 😉

Well, MT is pretty standard (that’s why it was included)- but beyond that, it there isn’t much of a standardized import/export format. 

It’s hard for me to give examples of how to get it in MT format because I don’t know the table structure- so I don’t have any idea of the queries you’ll need to get the data out.  Check this page- it’s an overview of MT format.  Basically, you just need to get the data into this format- same spacing, dashes, etc- and save it as a text file.  But I don’t know the tool, so I’m not sure how you could go about it.  Pure php would do it- looping through query results- but without knowing the db structure, I couldn’t guess as to the queries.

Hi,

I’ve created a Serendipity to MT export script which I used to convert my blog to EE. It works great. Let me know if you want it 😊

- bjorn

Oh, nice addition, bjorn.  You might consider adding an entry to the Wiki- under the ‘Import’ category.  I’m sure others are going to find this useful!

Thanks Robin 😊

Yeah I will add it to the Wiki, I just have to set up my EE site first. I have some various tools I want to make available.

Anyhow, for those who need this script now you can find it here: http://www.skitx.com/s9y_mt_export.phps

It should be pretty self-explanatory (just edit the settings in the top)

- bjorn

FYI - I’ve published this script here now: Serendipity to ExpressionEngine convertor.

I also added it to the Migrating to EE wiki page.

- bjorn

Really nice job on this, bjornbjorn.  It’s much appreciated.