Generic Import/Export

Discussion corner for Developers of Serendipity.
Post Reply
User avatar
onli
Regular
Posts: 2239
Joined: Tue Sep 09, 2008 10:04 pm
Contact:

Generic Import/Export

Post by onli » Tue Mar 29, 2016 2:35 am

I just moved my blog from one server to another. It was also a move from Mysql to sqlite. I used mysql2sqlite, https://gist.github.com/esperlu/943776, and that was a mistake: It did not set AUTOINCREMENT, which means my new installation after the import looked fine but could not actually save anything. I had to fix that manually.

Not sure whether I wrote that down here already, but it remembered me that I already had a plan to improve the import/export situation in serendipity. Currently, we have to my knowledge no proper way to export all entries with all comments with the original URL (or at least the id). We only have the full rss export, which does not contain comments and also just does not work well, as it times out. We should define a format to store that information (OPML?), let s9y export into it and write an importer that works with it. It should enable full import/export of entries and comments regardless of database.

We should then also write a plugin for Wordpress that can import and export that same format.

Does a format like this already exist? Does s9y already has such a function I'm just not aware of?

User avatar
garvinhicking
Core Developer
Posts: 30020
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Generic Import/Export

Post by garvinhicking » Tue Mar 29, 2016 12:00 pm

Hi!

I believe WP has created an extended RSS format with many (WP-specific) extensions to cover metadata such as this. We should research this and try to be as close and compatible to that, possibly adding our own scopes.

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

User avatar
onli
Regular
Posts: 2239
Joined: Tue Sep 09, 2008 10:04 pm
Contact:

Re: Generic Import/Export

Post by onli » Tue Mar 29, 2016 2:08 pm

Seems to be partly described in https://codex.wordpress.org/Tools_Export_Screen and http://devtidbits.com/2011/03/16/the-wo ... explained/. Nice. As much as I hate working with namespaced XML for that, we definitely should use an existing format and make sure interop works.

Post Reply