Moderator
Jan Dembowski
(@jdembowski)
Forum Moderator and Brute Squad
What are you trying to accomplish?
You can export your whole blog into WXR and import that file into Excel as an XML file.
But a medium size WXR file that WILL knock down Excel (make it unresponsive) and tie up your PC while it processes that file. Also Excel is not really a good tool for manipulating blog data (multiple tags, categories, comments, etc.)
yes it could be. I only need a list of the post, that include the post’s name and it’s url.
Any ideas? thanks!!!
Moderator
Jan Dembowski
(@jdembowski)
Forum Moderator and Brute Squad
Try this:
Create a text file in your wp-contents folder called “posts-urls.php” and put in these lines:
<?php
require_once('../wp-blog-header.php');
query_posts('&showposts=-1&order=ASC');
while (have_posts()) : the_post(); ?>
"<?php the_title(); ?>","<?php the_permalink(); ?>"
<br />
<?php endwhile; ?>
Save that file (it has to be in wp-content) and go to your blog’s URL/wp-content/posts-urls.php.
That will output the following:
“Post #1 title here”,”post #1 URL here”
“Post #2 title here”,”post #2 URL here”
“Post #3 title here”,”post #3 URL here”
…
“Post #n title here”,”post #n URL here”
This is a comma separated list of the post title and the post URL. The title and URLs are wrapped in quotation marks.
If you want to change the order, make ASC become DESC.
