Can I Export My Permalinks and URL to a text or CSV file?

  • PetLvr

    (@petlvr)


    17 years, 3 months ago

    Hi. I’ve got almost 2400 posts in one of my blogs, covering around 75 categories. As you know, it’s cumbersome browsing the MANAGE files, EDITing and reSAVEing them.

    So .. what I would like to do is this: Export all the permalink URL’s into a file that I can easily manipulate and sort (like excel) and delete the duds .. then create a new page in my wordpress blog for only that one topical category. Although I might have 75 categories, I think if I narrowed it down to about 25 pages of related topics it would work for my blog well.

    As an example. http://PetLvr.com/blog/ … I want to create a page related to potty training. If I just use the search feature, I won’t get all of the files. I will have to manually browse every URL every month in MANAGE. However, when I do browse the name – I can instantly remember if that article is about potty training, regardless if those search terms are there.

    If I can get an export of the URLS .. then it’s a matter of sort, data, copy and paste and I’m finished. Without an export, it’s like a 2-month project.

    Any ideas? Are there any plugins for that? /// THANKS – HART

Viewing 1 replies (of 1 total)
  • Thread Starter PetLvr

    (@petlvr)

    17 years, 3 months ago

    As a second thought or option .. I went into my myPhpAdmin and viewed MySQL database (4.1.22) and noticed .. that inside the “wp_posts” table .. there are two columns .. “post_name” and “guid” // which are the title and the permalink.

    Is there a way to somehow export or download this only? I’ve tried my normal backup routine and only selected the wp_posts table but there’s too much content inside.

    Just a thought.

Viewing 1 replies (of 1 total)
  • The topic ‘Can I Export My Permalinks and URL to a text or CSV file?’ is closed to new replies.