WordPress.org

Forums

Fix Textpattern import (26 posts)

  1. Stephanie Leary
    Member
    Posted 10 years ago #

    Those of us who use Textpattern are pretty much trapped there until someone figures out why the import script no longer works. I've been tinkering with it, but the problem appears to lie in the guts of WP itself and not the importer.

    Help!

  2. nickstenning
    Member
    Posted 10 years ago #

    bababbabababbaba BUMP.

    Please guys. It's probably just a simple problem, and it's causing so many of us so much hell. I do use nightlies so GO FOR IT :)

    Regards,
    Nick

  3. Stephanie Leary
    Member
    Posted 10 years ago #

    Actually it's not a simple problem -- the database structure has changed (the post2cat table has been added; not sure what else) since this importer was created and it just plain don't work.

    I got fed up and rewrote it. Mine is ugly as hell, but it WORKS... at least on my install. :)

    Caveats: I had only one author in both blogs. I cleaned out all the default categories and sample posts & comments in WP before importing. (In phpmyadmin, I emptied the following tables: wp_categories, wp_comments, wp_linkcategories, wp_links, wp_post2cat, wp_posts. If you have stuff already entered in WP, do back up before trying this.)

    My importer missed the very last post to TXP, but it handles posts, comments, categories, links, and link categories... so I didn't mind copying the one post. :)

    If you'd like to try it, download http://sillybean.net/tools/import_textpattern2.zip. Unzip, fill in db info for BOTH databases, upload, and fire away.

  4. Stephanie Leary
    Member
    Posted 10 years ago #

    Addendum: TXP has "root" categories for both posts and links (part of its hierarchy). You can delete these from WP after the import.

  5. Stephanie Leary
    Member
    Posted 10 years ago #

    Addendum #2: At the moment, this will import only the first category assigned to the TXP post.

    Sorry for the many afterthoughts; clearly those sql queries have swiss-cheesed my brain.

  6. nickstenning
    Member
    Posted 10 years ago #

    Thanks very much for that. It works - that's what matters!

  7. krisb
    Member
    Posted 10 years ago #

    With the exception of some links categories being switched around (not a big deal), seems to have worked perfectly, from TXP RC1 to the WP 1.5 Gamma (Jan. 30 build).

    Thanks!

  8. Stephanie Leary
    Member
    Posted 10 years ago #

    Excellent news! I haven't tried anything past 1.2 yet.

  9. hanni
    Volunteer Moderator
    Posted 10 years ago #

    Dude! You saved me ;)

    Cheers.

  10. sakamuyo
    Member
    Posted 10 years ago #

    link categories had to be reset & post categories were munged, but it got the posts & comments copied over, which was the important part. Thanks!

  11. Stephanie Leary
    Member
    Posted 10 years ago #

    Sorry to hear about the categories. I could use some examples besides my own site, if anyone wants to back up their old TXP database and send me the zip of the SQL dump. Email to steph at sillybean dot net if you're so inclined.

  12. rozim
    Member
    Posted 10 years ago #

    Has anyone addressed redirecting old TXP links to new WP ones.
    The script above works well for me butI try to keep around my TXP install in a different directory than my WP one -- so any legacy links continue to work - but one problem is old RSS links will get the old, wrong, stale, RSS feed from Textpattern.

    If you update the top level index.php in the Textpattern tree with this code then it'll redirect to WP. The 2 lines with Location:... have to change to refer to the URLs of your WP install.


    $atom = $_GET[ “atom�];
    if ( $atom == 1)
    {
    header( “Location: http://www.searchmorph.com/wp/feed/atom/“);
    exit( 0);
    }
    $rss = $_GET[ “rss�];
    if ( $rss == 1)
    {
    header( “Location: http://www.searchmorph.com/wp/feed/rss/“);
    exit( 0);
    }

    I wrote this up here:


    http://www.tropo.com/dave/blog/2005/06/07/when-moving-from-textpattern-to-wordpress-dont-forget-to-redirect-your-rss-feeds/

  13. Joni
    Member
    Posted 9 years ago #

    I have decided to switch my web design site from TXP to WP due to the many new features (not the least of which is Pages) that this latest incarnation of WP offers. I decided on TXP for that site over a year ago, so you can see the developmental paths that both programs have taken that leads me to this crossroads.

    I'll be doing that this weekend using the above script. Wish me luck. And I'll post back here once the dust settles.

  14. skennedy1217
    Member
    Posted 9 years ago #

    Sillybean, I'm trying your import script and it keeps dying with the message "Couldn't get categories." Any ideas?

  15. skennedy1217
    Member
    Posted 9 years ago #

    I should also add that the original textpattern import results in multiple SQL errors, but I appear to have all the database information correctly in place.

  16. skennedy1217
    Member
    Posted 9 years ago #

    *Bump*

    In all seriousness, while I like WP over TXP, I have found the user community over there to be much more helpful and supportive. Are there not enough developers on this forum, or are there simply too many threads to keep up with?

    I'm 99.9% postive that I have the correct db info in the import-textpattern.php and import-textpattern2.php files. However, both result in errors (which happen to corrput part of the db). I'm running the latest version of WP and version 1.01rc1 of Textpattern.

  17. Joni
    Member
    Posted 9 years ago #

    Hmm, that's odd. I migrated my web design site http://webjones.org from TextPattern last weekend using the import-textpattern.php file that shipped with WP 1.5.2 (whatever the version was right before this last big upgrade). And I had been using TextPattern 1.0rc1. The only problem I had was in my new WP install, I had forgotten to set up my categories, so they all got dumped into "General," but this was good because it forced me to clean up a bit. All the posts and comments came over just fine, but I noticed that the dates were off quite a bit. But since I was cleaning house anyway, I just fixed each one of those as I went.

    I wouldn't mind knowing why the dates were off kilter in the import, tho.

  18. skennedy1217
    Member
    Posted 9 years ago #

    jonimueller, mabye I need to upgrade WP and get the latest import-textpattern.php file? I am running 1.5.1.3 version.

  19. greatbananas
    Member
    Posted 9 years ago #

    I just tried importing posts from 4.0.1 Textpattern to 1.5.2 and it does not work.

  20. skennedy1217
    Member
    Posted 9 years ago #

    Yeah, the last time I tried it kept screwing up my install, so I finally quit and just started creating new content going forward. As a last recourse, if I ever get the time, I'll manually move the content using PHP MyAdmin...but it'd sure be nice if they could fix the import.

  21. darrepac
    Member
    Posted 9 years ago #

    I am in the same situation : I want to jump to WP from 4.0.1 Txp version... Seems the script doesn't work for this ( see comments above). Can we hope to have an update of the script?

  22. Stephanie Leary
    Member
    Posted 9 years ago #

    I wrote this for TXP 1.x, so I'm not at all surprised that it's broken now. The good news is that there's a new import script in the WP 2.0 beta... which, if I'm not mistaken, you can grab from the nightly build page.

  23. futurosity
    Member
    Posted 9 years ago #

    Anyone having success importing from Textpattern 4.0.3 into WordPress 2.0.1? The included importer doesn't seem to work and sillybean's link goes to a blank page.

    Thanks!

  24. futurosity
    Member
    Posted 9 years ago #

    I got this to work by first moving my Textpattern tables into the WordPress database, then importing. Also, I used the import script from Technosailor; not sure if this made a difference or not.

  25. adb
    Member
    Posted 9 years ago #

    I'd like to move textpattern posts to my wordpress blog, but the import feature is not working. Do I need to move the tp tables to the wordpress database? If so, how can I do this? Please help. Thanks.

  26. djahughes
    Member
    Posted 9 years ago #

    How do I import my TXP tables into WP?

    The TXP import seems to only half work. It 'times out 'when importing posts with only some posts being imported with a weird date order applied.

    Thanks!

Topic Closed

This topic has been closed to new replies.

About this Topic