Sitemap of pages generated via custom table data

Well technically there are 2 ways - one is to clone and modify site map xml web part. Second is to use custom response Web part and macro to get a data from custom table.

You must set up the proper mime response type i.e. application/xml

Here is a macro sample :

<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
{% GlobalObjects.CustomTables["customtable.SampleTable"].Items.ApplyTransformation("<url><loc>{#ItemUrl#}</loc> <lastmod>{#ItemLastModified#}</lastmod><changefreq>monthly</changefreq><priority>0.8</priority></url>") |(identity)GlobalAdministrator%}
</urlset> 

Hi Peter, thank you for your response. I tried using your second option, but I ran into some limitations. The url for these pages is created by combining columns in the table for example: /productNumber/productName-category.aspx

With the second approach how can I: 1. convert column data to string? 2. pull data from a column in a secondary table? (category is stored in a separate table) 3. only load table rows that are "active"? (this is controlled by a boolean checkbox)

Given all these requirements, I am now going to try method #1, which is to clone and modify the Sitemap webpart.

Hi Peter, here I am again, I've mode some progress but I'm still stuck. I've modified the Google XML Webpart, adding controls to select a query, a custom table, and a transformation. Now, the page succesfully loads as an xml page, and it is finding items in the table, but url portion created by information in the columns is empty.

What I get:

<url><loc>https://www.mysite.org/directory/en//--.aspx
      </loc><lastmod/>

The transformation I'm using for my items is:

<url>    
    <loc>https://www.mysite.org/directory/{%CMS.DocumentEngine.DocumentContext.CurrentDocumentCulture.CultureAlias|(identity)GlobalAdministrator%}</lastmod> 
</url>

The QUERY on the table is asking for:

SELECT ##TOPN## * FROM (Select  dbo.custom_MCHS_Physicians.NPI, 
                        dbo.custom_MCHS_Physicians.FullName, 
                        dbo.custom_MCHS_Physicians.FirstName, 
                        dbo.custom_MCHS_Physicians.LastName, 
                        dbo.custom_MCHS_Physicians.ActiveFlag,
                        dbo.custom_MCHS_Physicians.PSA

FROM  dbo.custom_MCHS_Physicians INNER JOIN
dbo.custom_MCHS_SpecToPhys ON dbo.custom_MCHS_Physicians.NPI = dbo.custom_MCHS_SpecToPhys.NPI
As T Where ##WHERE##

I'm not very familiar with queries and I'm copying from other components already used in the site, so I'm not certain what else is missing or what I need to correct so that the columns data load in the transformation.