By HollywoodChicago.com on

I have a sitemap with all of my terms and links to them here: http://www.hollywoodchicago.com/sitemap

From that sitemap, for example, Johnny Depp's dedicated term page is here: http://www.hollywoodchicago.com/taxonomy/term/786/all

I need an Excel spreadsheet that has the following for all of my terms and links to them:

Term Link
Johnny Depp http://www.hollywoodchicago.com/news/johnny-depp
Nightmare on Elm Street http://www.hollywoodchicago.com/news/nightmare-on-elm-street

Is there an easy/automatic way to create that in Excel? Please tell me I can do this from the database somehow or something so I don't have to do this manually. I have thousands of terms. Thank you!

~ Adam Fendelman
Founder/Publisher
HollywoodChicago.com

Comments

palwakeup’s picture

palwakeup commented

I'm not sure it's correct syntax but it shows how at least.

$('a').each(function () {
href = $(this).attr("href");
name = $(this).text();
print href, name;
}
);

anybody confirms this?