OK, I am attempting to put together the necessary components for implementing Google Site Maps in WebGui.

Now that being said, I already have the SQL Report, and I have generated an SQL Report Template, that looks like this:

<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
<tmpl_loop rows_loop>
   <url>
      <loc>/<tmpl_var row.field.url.value></loc><br>
      <lastmod></lastmod><br>
   </url>
</tmpl_loop>
</urlset>

Which formats the data like this: 

http://www.SpamZapper.us/isps
1/19/2008
http://www.SpamZapper.us/home
1/17/2008
http://www.SpamZapper.us/configuration/web-manager
2/1/2008
http://www.SpamZapper.us/business
1/17/2008
 

But the rest of the text fields are missing.  How do I include the rest of the template on the output of the SQL Report? 

--- (Edited on 2/4/2008 2:43 pm [GMT-0500] by aewhale) ---

--- (Edited on 2/4/2008 2:43 pm [GMT-0500] by aewhale) ---