?
Solved

WXR Import Incomplete - Only First Post

Posted on 2011-03-03
9
Medium Priority
?
1,657 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
Are You Using the Best Web Development Editor?

The worlds of web hosting and web development are constantly evolving. Every year we see design trends change, coding standards adapt and new frameworks/CMS created. With such a quick pace of change it’s easy to get lost trying to keep up.

See if your editor made the list.

 
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 2000 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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

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…
If you are looking for plug-ins to add functions to your WordPress small business web site, take some time to read though this comprehensive list.  These are all the plugins I use for my customers WordPress web sites, as well as my own.  Be sure to …
The purpose of this video is to demonstrate how to make a WordPress Site faster and smaller in size by cleaning up the database. This will be demonstrated using a Windows 8 PC. Plugin WP Optimize will be used. Go to your WordPress login page. T…
The purpose of this video is to demonstrate how to prevent comment spam on a WordPress Website. This will be demonstrated using a Windows 8 PC. Plugin Akismet will be used. Go to your WordPress login page. This will look like the following: myw…

770 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