The Serendipity Handbook

You can now read the (german) handbook here: PDF - https://github.com/s9y/Book (LaTeX source).

Forum-Information

Before posting about errors, make sure that the answer cannot already be found in our FAQ or by searching this forum!
Posting is restricted to registered users (registering is free and simple!) due to recent spam attacks. When having trouble with this board, contact garvin(-at)s9y(-dot)org.

Board index Development Migration from Wordpress (and others) to Serendipity

Discussion corner for Developers of Serendipity.
User avatar
u1amo01
Regular
 
Posts: 176
Joined: Fri Sep 28, 2007 3:55 pm
Location: Haßloch, Germany

Postby u1amo01 » Thu Oct 18, 2007 4:06 pm

Looks like import from the new version WordPress 2.3 doesn't work properly. The categories were not imported. IMHO because the structure of the tables has changed.
WordPress 2.3 introduces our new taxonomy schema. This new schema replaces the categories, post2cat, and link2cat tables with three new tables that are more flexible.


See WordPress 2.3 Taxonomy Schema for details.

[edit]
Comments are imported correctly, but the counter at each posting shows "0 comments"

:-(

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

Postby garvinhicking » Thu Oct 18, 2007 5:52 pm

Hi!

Do you maybe have an example dump of the taxonomy table so that I can see how it actually looks like? We only can import categories, not the tags (at least for now, because that would require the freetag plugin integration with the importer).

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
u1amo01
Regular
 
Posts: 176
Joined: Fri Sep 28, 2007 3:55 pm
Location: Haßloch, Germany

Postby u1amo01 » Thu Oct 18, 2007 6:45 pm

Hmm, if you tell me how to do this - I'm not an phpMyAdmin expert, sorry.

A dump of wp_term_taxonomy, right?

When I go to "Exportieren", there is the following marked by default:

export as: SQL

SQL-Optionen:

Struktur:
AUTO_INCREMENT-Wert hinzufügen
Tabellen- und Feldnamen in einfachen Anführungszeichen

Daten:
Hexadezimalschreibweise für Binärfelder verwenden

Is this ok? And should I send it by mail? (not the whole table for sure ;-))

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

Postby garvinhicking » Thu Oct 18, 2007 7:46 pm

Hi!

It should be three tables: wp_term_taxonomy, wp_term_relationships and wp_term.

Your PMA options would be fine, you need to both check "Struktur" and "Daten" so that everything is contained in the dump file. You can send it via mail to me, blog at garv dot in.

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
u1amo01
Regular
 
Posts: 176
Joined: Fri Sep 28, 2007 3:55 pm
Location: Haßloch, Germany

Postby u1amo01 » Thu Oct 18, 2007 8:50 pm

Mail sent.

BTW, WordPress also offers to export Data as XML in a so called "WordPress eXtended RSS / WXR" to exchange content between two WordPress-Blogs. Maybe this could also be a way to import to s9y?

Cheers,
Klaus

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

Postby garvinhicking » Thu Oct 18, 2007 10:12 pm

Hi!

It surely would, but I'm quite sure it's some amount of work to be done. Maybe some volunteer steps up to check it out? It would be nice if s9y could also export its data in this WXR format. Maybe a good projects for Google Summer of Code. :)

I'll check out your mail and see what I can do!

Best 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/

Previous


Return to Development

Who is online

Users browsing this forum: Google [Bot] and 2 guests