XML Sitemap not associated with pathauto url aliases

This question comes to us from our Facebook forum. It feels good to answer, because this is the first of many questions we'll be answering here on the site.

Some Help I need (XML Sitemap)

Omar Eduardo Fernández (MIT) wrote on Jan 8, 2008 at 5:52 PM.

So right now, I've been trying to fix an issue I have on my website. I imported everything I had from WordPress (posts, comments, categories/tags, etc), and then I installed the pathauto and the XML Sitemap modules. The problem I'm having is that XML Sitemap is producing a sitemap with every link in terms of nodes rather than the aliases my pages now have, and I would strongly prefer it to use the aliases. My NEW content is being included in the sitemap using aliases, but all the previously imported content is in the node format.

You can look at my sitemap if you're not sure what I mean, is http://omareduardo.com/sitemap.xml

Thanks for any help!
-Omar

I was looking at the database tables for XML sitemap. It stores a `pid`field in each row of the `xmlsitemap_node` table. It's likely that your links were added to the table and haven't been associated with their path and the entry in the `xmlsitemap_node` table. You could do this by hand, but there appears to be a function called drupal_lookup_path()
that accepts a few arguments.

http://api.drupal.org/api/function/drupal_lookup_path/5

Description

drupal_lookup_path($action, $path = '')
Given an alias, return its Drupal system URL if one exists. Given a Drupal system URL return one of its aliases if such a one exists. Otherwise, return FALSE.

Parameters

$action One of the following values:

• wipe: delete the alias cache.
• alias: return an alias for a given Drupal system path (if one exists).
• source: return the Drupal system URL for a path alias (if one exists).

$path The path to investigate for corresponding aliases or system URLs.

Return value

Either a Drupal system path, an aliased path, or FALSE if no path was found.