asked on

WXR Import Incomplete - Only First Post

Importing the following WXR XML file and it is importing only the first post and not all the others (have included the first three to see if anything is different)... Thank you for any help.

<?xml version="1.0" encoding="UTF-8" ?>
<!-- This is a WordPress eXtended RSS file generated by WordPress as an export of your site. -->
<!-- It contains information about your site's posts, pages, comments, categories, and other content. -->
<!-- You may use this file to transfer that content from one site to another. -->
<!-- This file is not intended to serve as a complete backup of your site. -->
<!-- To import this information into a WordPress site follow these steps: -->
<!-- 1. Log in to that site as an administrator. -->
<!-- 2. Go to Tools: Import in the WordPress admin panel. -->
<!-- 3. Install the "WordPress" importer from the list. -->
<!-- 4. Activate & Run Importer. -->
<!-- 5. Upload this file using the form provided on that page. -->
<!-- 6. You will first be asked to map the authors in this export file to users -->
<!--    on the site. For each author, you may choose to map to an -->
<!--    existing user on the site or to create a new user. -->
<!-- 7. WordPress will then import each of the posts, pages, comments, categories, etc. -->
<!--    contained in this file into your site. -->
<!-- generator="WordPress/3.1" created="2011-03-02 14:17" -->
<rss version="2.0"
	xmlns:excerpt="http://wordpress.org/export/1.1/excerpt/"
	xmlns:content="http://purl.org/rss/1.0/modules/content/"
	xmlns:wfw="http://wellformedweb.org/CommentAPI/"
	xmlns:dc="http://purl.org/dc/elements/1.1/"
	xmlns:wp="http://wordpress.org/export/1.1/"
>
<channel>
	<title>MYBLOGSITE</title>
	<link>http://www.MYBLOGSITE.com</link>
	<description>some description</description>
	<pubDate>Wed, 02 Mar 2011 14:17:42 +0000</pubDate>
	<language>en</language>
	<wp:wxr_version>1.1</wp:wxr_version>
	<wp:base_site_url>http://www.MYBLOGSITE.com</wp:base_site_url>
	<wp:base_blog_url>http://www.MYBLOGSITE.com</wp:base_blog_url>
	<wp:author><wp:author_id>1</wp:author_id><wp:author_login>admin</wp:author_login><wp:author_email>MYBLOGSITE@MYBLOGSITE.com</wp:author_email><wp:author_display_name><![CDATA[MYBLOGSITE]]></wp:author_display_name><wp:author_first_name><![CDATA[]]></wp:author_first_name><wp:author_last_name><![CDATA[]]></wp:author_last_name></wp:author>
	<generator>http://wordpress.org/?v=3.1</generator>
	<item>
		<title>Customizing a Magic Trackpad using BetterTouchTool</title>
		<link>http://www.MYBLOGSITE.com/2011/01/29/customizing-a-magic-trackpad-using-bettertouchtool/</link>
		<pubDate>Sat, 29 Jan 2011 23:24:00 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		<guid isPermaLink="false">http://www.MYBLOGSITE.com/2011/01/29/customizing-a-magic-trackpad-using-bettertouchtool</guid>
		<description></description>
		<content:encoded><![CDATA[

      <img src="http://www.MYBLOGSITE.com/wp-content/uploads/2011/02/httpwwwblogcdnc_mzmvl.jpg" />
via <a href="http://www.tuaw.com/2011/01/19/customizing-a-magic-trackpad-using-bettertouchtool/">tuaw.com</a>

  ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_date>2011-01-29 23:24:00</wp:post_date>
		<wp:post_date_gmt>2011-01-29 23:24:00</wp:post_date_gmt>
		<wp:comment_status>open</wp:comment_status>
		<wp:ping_status>open</wp:ping_status>
		<wp:post_name>customizing-a-magic-trackpad-using-bettertouchtool</wp:post_name>
		<wp:status>publish</wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type>post</wp:post_type>
		<wp:post_password></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
		<category domain="post_tag" nicename="apple"><![CDATA[Apple]]></category>
		<category domain="category" nicename="technology"><![CDATA[Technology]]></category>
	</item>
	<item>
		<title>How to Crack Just About Any Mac App (and How to Prevent It)</title>
		<link>http://www.MYBLOGSITE.com/2011/01/29/how-to-crack-just-about-any-mac-app-and-how-to-prevent-it/</link>
		<pubDate>Sat, 29 Jan 2011 23:24:00 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		<guid isPermaLink="false">http://www.MYBLOGSITE.com/2011/01/29/how-to-crack-just-about-any-mac-app-and-how-to-prevent-it</guid>
		<description></description>
		<content:encoded><![CDATA[

      <img src="http://www.MYBLOGSITE.com/wp-content/uploads/2011/02/httpcachegawker_fefis.jpg" />
via <a href="http://lifehacker.com/5736101/how-to-crack-just-about-any-mac-app-and-how-to-prevent-it?utm_source=feedburner">lifehacker.com</a>

  ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_date>2011-01-29 23:24:00</wp:post_date>
		<wp:post_date_gmt>2011-01-29 23:24:00</wp:post_date_gmt>
		<wp:comment_status>open</wp:comment_status>
		<wp:ping_status>open</wp:ping_status>
		<wp:post_name>how-to-crack-just-about-any-mac-app-and-how-to-prevent-it</wp:post_name>
		<wp:status>publish</wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type>post</wp:post_type>
		<wp:post_password></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
		<category domain="post_tag" nicename="apple"><![CDATA[Apple]]></category>
		<category domain="category" nicename="technology"><![CDATA[Technology]]></category>
	</item>
	<item>
		<title>I, Cringely » Blog Archive » No white smoke yet in Cupertino - Cringely on technology</title>
		<link>http://www.MYBLOGSITE.com/2011/01/29/i-cringely-%c2%bb-blog-archive-%c2%bb-no-white-smoke-yet-in-cupertino-cringely-on-technology/</link>
		<pubDate>Sat, 29 Jan 2011 23:23:00 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		<guid isPermaLink="false">http://www.MYBLOGSITE.com/2011/01/29/i-cringely-%c2%bb-blog-archive-%c2%bb-no-white-smoke-yet-in-cupertino-cringely-on-technology</guid>
		<description></description>
		<content:encoded><![CDATA[

      <embed pluginspage=&quot;http://www.adobe.com/go/getflashplayer&quot; allowfullscreen=&quot;true&quot; src=&quot;http://www.cringely.com/wp-content/plugins/powerpress/FlowPlayerClassic.swf&quot; wmode=&quot;transparent&quot; allowscriptaccess=&quot;always&quot; type=&quot;application/x-shockwave-flash&quot; height=&quot;24&quot; flashvars=&quot;config={&quot;autoPlay&quot;:false,&quot;autoBuffering&quot;:false,&quot;initialScale&quot;:&quot;scale&quot;,&quot;showFullScreenButton&quot;:false,&quot;showMenu&quot;:false,&quot;videoFile&quot;:&quot;<a href="http://www.cringely.com/podcast/20110118.mp3">http://www.cringely.com/podcast/20110118.mp3</a>&quot;,&quot;loop&quot;:false,&quot;autoRewind&quot;:true}" quality="high" />via <a href="http://www.cringely.com/2011/01/no-white-smoke-yet-in-cupertino/?utm_source=feedburner">cringely.com</a>

  ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_date>2011-01-29 23:23:00</wp:post_date>
		<wp:post_date_gmt>2011-01-29 23:23:00</wp:post_date_gmt>
		<wp:comment_status>open</wp:comment_status>
		<wp:ping_status>open</wp:ping_status>
		<wp:post_name>i-cringely-%c2%bb-blog-archive-%c2%bb-no-white-smoke-yet-in-cupertino-cringely-on-technology</wp:post_name>
		<wp:status>publish</wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type>post</wp:post_type>
		<wp:post_password></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
		<category domain="post_tag" nicename="apple"><![CDATA[Apple]]></category>
		<category domain="category" nicename="technology"><![CDATA[Technology]]></category>
	</item>
	<item>
		<title>Messy Mac Address Book? You need Contacts Cleaner</title>
		<link>http://www.MYBLOGSITE.com/2011/01/29/messy-mac-address-book-you-need-contacts-cleaner/</link>
		<pubDate>Sat, 29 Jan 2011 23:23:00 +0000</pubDate>
		<dc:creator>admin</dc:creator>
		<guid isPermaLink="false">http://www.MYBLOGSITE.com/2011/01/29/messy-mac-address-book-you-need-contacts-cleaner</guid>
		<description></description>
		<content:encoded><![CDATA[

      <img src="http://www.MYBLOGSITE.com/wp-content/uploads/2011/02/httpthenextwebc_yidbg.png" />
via <a href="http://thenextweb.com/apple/2011/01/17/messy-mac-address-book-you-need-contacts-cleaner/?utm_source=feedburner">thenextweb.com</a>

  ]]></content:encoded>
		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
		<wp:post_date>2011-01-29 23:23:00</wp:post_date>
		<wp:post_date_gmt>2011-01-29 23:23:00</wp:post_date_gmt>
		<wp:comment_status>open</wp:comment_status>
		<wp:ping_status>open</wp:ping_status>
		<wp:post_name>messy-mac-address-book-you-need-contacts-cleaner</wp:post_name>
		<wp:status>publish</wp:status>
		<wp:post_parent>0</wp:post_parent>
		<wp:menu_order>0</wp:menu_order>
		<wp:post_type>post</wp:post_type>
		<wp:post_password></wp:post_password>
		<wp:is_sticky>0</wp:is_sticky>
		<category domain="post_tag" nicename="apple"><![CDATA[Apple]]></category>
		<category domain="category" nicename="technology"><![CDATA[Technology]]></category>
	</item>

Open in new window

gwkg

How big is the file?

If you refresh your browser and click resend, does it add another entry or still just the first one only?

You can try adding this to your wp-config.php file

define('WP_MEMORY_LIMIT', '64M');

loyaliser

ASKER

Refreshing after the load completes and confirms it is done, I get an error saying import file not found - I guess because it completed successfully it deletes the import file from wp-content folder.

wp-config already "pumped" up on memory/file size limit to 128MB

File size is 1.3MB total.

Have several plugins installed not sure if impacting this upload: addthis, batch category, optimizer, disable revisions, maintenance mode etc.

Perhaps try to disable all plugins???

loyaliser

ASKER

One other question, is there a way to enable error logging, or view log files that tell me what went wrong? I have the Error Reporting plugin, but not telling me anything...

loyaliser

ASKER

Tried disabling all plugins, still no luck...

gwkg

define('WP_DEBUG', true);

Yes, disabling all plugins is a good idea just to make sure you are not wasting your time debugging a plugin conflict.

The problem with importing often lies in the hosting, (server timeouts, etc). One way around this is importing to site setup on localhost and then moving the database.

loyaliser

ASKER

DEBUG mode returns nothing useful...

The weird thing is that it doesnt seem like timeout issue, because after the last confirmation page to upload, it completes like in 15 seconds and says All Done...

I go check and it only shows 1 post loaded, none of the others at all...

Any other solution; like to create a large SQL script from the XML that I can run against the MySQL DB directly? That would even be better...

ASKER CERTIFIED SOLUTION

gwkg

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

loyaliser

ASKER

Hmmm... Removing the question marks not doing anything for me.

Any way I tried to upload to wordpress.com free accounts, and it works, but it does not map the posts to the categories and tags.

I think the WP free accounts are running a version older than 3.1 - so what I am thinking is to get it uploaded then, then export from their site, then import the file into my hosted site.

Trouble is the categories and tags are not mapping so this is gonna be a mess... Any ideas why not mapping? They are setup and configured in the admin correctly, but some reason not picking it up in the post <item> section.

loyaliser

ASKER

Ended up working, however it did not create the media post entries, only the posts, even though I checked the box to create media post entries...

So now gotta figure out if there is a SQL script or plugin to mass-create media post entries for my 700 posts, AND create the multiple image sizes in the upload folder...

Thanks again!