WordPress.org

Ready to get started?Download WordPress

Forums

Generate XLS report with the list of post (title, link, author, etc) (4 posts)

  1. radians
    Member
    Posted 5 years ago #

    im looking for a plugin, script or similar to generate an xls file with the list of the post, links, author and all that stuff.

    Do you have someone? or do you know another solution???

    thanks in advance.

  2. 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.)

  3. radians
    Member
    Posted 5 years ago #

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

  4. 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.

Topic Closed

This topic has been closed to new replies.

About this Topic