WordPress.org

1. davekat
   Member
   Posted 1 year ago #

   I would like to output a csv text file of all of the http urls of my site/sites and import them into a spreadsheet to get a better look at all of my urls on the site.
   is there a plugin that will do this? I have been searching for something but to no avail.
   example...
   url , title of page

   "http://mysite.com/home/","Home"
   "http://mysite.com/this-page/,"This Page"
   "http://mysite.com/this-page/with-another-page/","With Another Page..."
   "http://mysite.com/this-page/what-another-page/","What, Another Page?"
   "http://mysite.com/next-page/read-this/","Read This"
   "http://mysite.com/another-page-typed-in/","Another Page typed in"
   "http://mysite.com/page-i-dont-know/","Page I Don't Know"
   "http://mysite.com/lions-tigers-bears/bears/","Lions, Tigers, Bears"
   "http://mysite.com/rabbit","Rabbit"
   "http://mysite.com/squirrel","Squirrels Are Nuts" (I might change the permalink but keep the title)

   Is there a quick way or instruction on how to write a php plugin for this?
   Davekat

2. jonradio
   Member
   Posted 1 year ago #

   A quick and dirty way to do this would be to backup the database, download it to your hard drive, extract the .sql file with something like 7-Zip, then use an editor like NotePad++ (or even NotePad, ugh!) to Find Next for "http" and examine each link visually.

3. davekat
   Member
   Posted 1 year ago #

   a little bit dirty, but doable in a pinch.
   I would like to do this pretty much every day for a project for updates. What I need is to upload it into a plugin called wp-tables-reloaded. That would be an import as a csv file. I really need a plugin to do the dirty work for me.
   I need something that I can do quickly on a daily basis.
   but... I like your thinkin though...

   Nee more ideas or a plugin
   Thanks
   Davekat.

4. dogfriendlyaccommodation
   Member
   Posted 1 year ago #

   You could connect mysql directly to excel. It takes a little configuring to setup but once it's done it is just a matter of a quick refresh every day.

   Instructions for WinXP

   download the odbc driver from dev.mysql.com/downloads/connector/odbc and install

   go to Control Panel - admin tools - data sources(odbc) - user dsn

   Click add then pick the mysql driver you just installed. Add your user and DB information.

   Go into excel (2003) and pick Data - Import External Data - Import data. Connect to new data source and pick odbc data source and the dsn you just setup. Follow the instructions to save the query and then insert the data into the sheet.

   To refresh it every day just select a cell within the data you imported and click Data - Refresh Data

   Hope this helps. Not sure about other versions, but it shows you this is possible - and could be useful for other things too.

   Vicky

5. davekat
   Member
   Posted 1 year ago #

   I'll Have to try this. Sounds like a challenge for me.
   Thanks
   Davekat

6. jonradio
   Member
   Posted 1 year ago #

   dog... has a good clean solution for you. Most Windows-based spreadsheet and database programs have a similar ODBC (Open DataBase Connector) capability.

   I mention database programs since they might have the edge for programming power, though spreadsheets generally offer a VisualBasic kind of language for things that you can't do in formulas.

Topic Closed

This topic has been closed to new replies.