By doing a SHOW CREATE TABLE on wp_postmeta, I got the structure of that table which included this: PRIMARY KEY (`meta_id`), So the key that MySQL can do the ‘insert or update’ on is the meta_id, which you’re not providing. Therefore in your query, it will always be added as a new row. EDIT: The … Read more
Looks like you can use the Variable Repeater Mode (CSV) to import your data: If your repeating data is stored in a single column in your CSV file, and is separated by a separator character, use this option. Then create a custom PHP function that would break up each value into the title and ID … Read more
The easiest way is to use the Cache Image plugin, which ‘sideloads’ images in your posts that are from other domains. I’ve had mixed results, mainly because it seems to not work well for thousands of posts and images – if your site is smaller you may have better results.
finally i split my xml file with wxr splitter and did as http://www.rangerpretzel.com/content/view/20/1/ inform then import it .
Googling for “split wxr file” returned several results, including python script for splitting .wxr file GUI for splitting WXR files (OSX and Windows) .Net splitter for WXR files Haven’t tried any of these, but the comments look positive.
You can expect to lose your site stats. You can expect your site to be harder to find. You can expect to have greater freedom in terms of customization and possible features. You can expect to have to upgrade your WordPress version periodically. You can expect less users commenting, as WordPress.com uses a social networking … Read more
No, there isn’t. And unfortunately that’s because you’ve been using Blogger to do something it was never intended to do. I’m not saying this is a bad thing. Blogger (and WordPress) are built to handle an article format: One author publishes a large article Other writers create short-format comments Comments and replies are threaded together … Read more
I have recently had a lesson in serialized arrays from a friend and it all makes sense now! After working this out it finally worked on the import. Take this for example: a:1:{s:7:”address”;s:50:”52, St. Michaels Rd,Sheffield,S359YN”;} a:1: This is the array size, there is one piece of information in this array hense the 1. a:size:{key … Read more
I guess you want to modify these lines in the WordPress-Importer plugin: $post_exists = post_exists( $post[‘post_title’], ”, $post[‘post_date’] ); if ( $post_exists && get_post_type( $post_exists ) == $post[‘post_type’] ) { to add some post meta checks. I don’t see any hooks inside the function post_exists() that we could use. Remark: I don’t recommend editing plugin … Read more
If you have already created the database that you wish to import into and you have selected that database in PHPMyAdmin, but the import file is trying to create a new database, then you will see this error message. All you need to do is open up the SQL file in a text editor and … Read more