1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Exporting all blog URL links

Discussion in 'Blogging' started by Comic, Mar 29, 2012.

  1. Comic

    Comic Regular Member

    Joined:
    Jun 17, 2010
    Messages:
    287
    Likes Received:
    190
    Occupation:
    Marketing & SEO
    Location:
    Phoenix, AZ
    Home Page:
    Hey guys,

    Hoping someone here will know the answer to this. Is there a plugin that will allow me to export a list of all the URL's in wordpress?

    Thanks in advance.
     
  2. Sophomoric

    Sophomoric Junior Member

    Joined:
    Aug 4, 2011
    Messages:
    116
    Likes Received:
    9
    You could use scrapebox.
     
  3. dichotom

    dichotom Jr. VIP Jr. VIP

    Joined:
    Dec 9, 2008
    Messages:
    1,911
    Likes Received:
    544
    xml sitemap generator then use scrapebox to scrape it or notepad++ to clean it up, or you could use an online TEXT sitemap generator for a list of all your URL's line by line (there is usually an upper limit on how many the free ones will crawl though.
     
  4. webnise

    webnise Regular Member

    Joined:
    Dec 21, 2009
    Messages:
    296
    Likes Received:
    121
    Location:
    London
    write the following code in any php file (say links.php) and put it wp-content folder so that you can access it via http://www.yoursite.com/wp-content/links.php and it will show you all the links of your blog.

    Access this file via browser and save the file as TXT and import into Excel using Import from TXT, it will be '|' delimited.

    Code:
     [FONT=&quot]<?php[/FONT]
      
      [FONT=&quot]require_once('../wp-blog-header.php');[/FONT]
      [FONT=&quot]query_posts('&showposts=-1&order=ASC');[/FONT]
      
      [FONT=&quot]while (have_posts()) : the_post(); ?>[/FONT]
      
      [FONT=&quot]<?php the_permalink(); ?>|<?php the_title(); ?>|<?php the_tags(); ?>[/FONT]
      [FONT=&quot]<br />[/FONT]
      
      [FONT=&quot]<?php endwhile; ?>[/FONT]
      
     
    • Thanks Thanks x 1
  5. Comic

    Comic Regular Member

    Joined:
    Jun 17, 2010
    Messages:
    287
    Likes Received:
    190
    Occupation:
    Marketing & SEO
    Location:
    Phoenix, AZ
    Home Page:
    That worked great. I did make a change to the script so it just produces the URL and nothing else. I will work on this some more and try to perfect it some. Right now the result with the script below only returns the URL's ready to be copied. Thanks a ton for posting the script.

    Code:
     
    
    <Title> Link Sript</Title> 
    
    <?php
      
      require_once('../wp-blog-header.php');
      query_posts('&showposts=-1&order=ASC');
      
      while (have_posts()) : the_post(); ?>
      
      <?php the_permalink(); ?>
      <br />
      
      <?php endwhile; ?>
    
     
  6. webnise

    webnise Regular Member

    Joined:
    Dec 21, 2009
    Messages:
    296
    Likes Received:
    121
    Location:
    London
    Yes, you can add/remove any bits you don't want :)

    Glad to be of any help :)