WordPress.org

Support

Support » Requests and Feedback » Generate XLS report with the list of post (title, link, author, etc)

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

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator Jan Dembowski

    @jdembowski

    Brute Squad and Volunteer Moderator

    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

    Brute Squad and Volunteer Moderator

    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.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Generate XLS report with the list of post (title, link, author, etc)’ is closed to new replies.
Skip to toolbar