Solved

WXR Import Incomplete - Only First Post

Posted on 2011-03-03
9
1,653 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Why Off-Site Backups Are The Only Way To Go

You are probably backing up your data—but how and where? Ransomware is on the rise and there are variants that specifically target backups. Read on to discover why off-site is the way to go.

 
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

Did you use a default hosting installation of wordpress with the intention of it being your actual site?  Maybe you’ve installed it as a Blog to your current site and recently converted it to be the main site and do away with the old .htm pages.  An…
WordPress has made it easy to create scalable sites based on their powerful CMS, but as great as WordPress is, there are some SEO issues that haven’t been addressed out of the box.  Fortunately these problems can be solved with a few plugins.  The f…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

717 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