Solved

WXR Import Incomplete - Only First Post

Posted on 2011-03-03
9
1,641 Views
Last Modified: 2012-05-11
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

0
Comment
Question by:loyaliser
  • 6
  • 3
9 Comments
 
LVL 31

Expert Comment

by:gwkg
ID: 35029712
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');
0
 
LVL 1

Author Comment

by:loyaliser
ID: 35029790
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???
0
 
LVL 1

Author Comment

by:loyaliser
ID: 35029797
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...
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 1

Author Comment

by:loyaliser
ID: 35031595
Tried disabling all plugins, still no luck...
0
 
LVL 31

Expert Comment

by:gwkg
ID: 35031657
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.

0
 
LVL 1

Author Comment

by:loyaliser
ID: 35031764
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...
0
 
LVL 31

Accepted Solution

by:
gwkg earned 500 total points
ID: 35032304
Eureka!

I tried to import those items and had the same problem: Only the first item.

I switched the items around, same problem: only the first item.

I changed the first line in the file to

<xml version="1.0" encoding="UTF-8">

No problems :)
0
 
LVL 1

Author Comment

by:loyaliser
ID: 35033967
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.
0
 
LVL 1

Author Closing Comment

by:loyaliser
ID: 35040696
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!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Wordpress Horizontal Drop-Down Menu In this tutorial I will show you had to add a WordPress horizontal navigation menu to your theme. I have searched and searched for a good tutorial on creating a WordPress nav menu without adding a plug-in or us…
WordPress is constantly evolving, and with each evolution appears to get better and better.  One of the big drawbacks prior to version 3 was that there was no way to be able to set up a custom menu from the backend. The Old Way Adding menus is…
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question