Google Sitemap

hongjun
hongjun used Ask the Experts™
on
Hi Experts,

I am looking for a Google Sitemap generator that is similar to XMLSiteMaps.Com http://www.xml-sitemaps.com/ . It is very good but then the free version limits to only 500 posts.

I have tried some other free sitemap generators but then none fit to my requirement

My basic requirement is it must return me the url of the post plus title of the post. XMLSiteMaps.Com gives me what I want. BTW, I am generating for a blogspot.com site.

hongjun
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Hi,

Have you tried creating your own Google Sitemap - they are very easy to create.  

Here is a guide:

https://www.google.com/webmasters/tools/docs/en/protocol.html

If you need more help please let me know and I will assist you.

Here is a live example: http://www.quest-recruiting.com/sitemap.xml

Here is some sitemap generaters: - have you tried these?

https://www.google.com/webmasters/tools/docs/en/sitemap-generator.html
http://www.sitemaps.org/
http://www.winappslist.com/websitepromotion/sitemappers.htm

Hope these help and if not please tell us your requirements...

Ellandrd
I shall have a look at http://www.quest-recruiting.com/sitemap.xml later. The page has reached maximum bandwidth limit.

My requirement is as posted in my question "My basic requirement is it must return me the url of the post plus title of the post"

hongjun
I have just checked http://www.quest-recruiting.com/sitemap.xml and it is not what I want.
I want something like this
http://www34.brinkster.com/hongjunwap/blog/sitemap.html

Where I have the title of my post generated and displayed as well.
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Remember "My basic requirement is it must return me the url of the post plus title of the post." is my basic requirement.

hongjun
>>Have you tried creating your own Google Sitemap - they are very easy to create

How do I?
I am using Xenu to generate sitemaps.
Check at http://home.snafu.de/tilman/xenulink.html
This is a very useful tool which I am using for:
- checking which links a spider would find, and which of them are broken,
- generating a HTML site map with html code for <a url>title</a> which allows you to have an htmlk map for your site
- generating a TXT sitemap from an html display of the correct html links.
NOTE: a txt sitemap is read OK by GYM, I am not sure what a XML sitemap REALLY brings more.

Commented:
>>Have you tried creating your own Google Sitemap - they are very easy to create

>>How do I?

Here is a guide:

https://www.google.com/webmasters/tools/docs/en/protocol.html

Ellandrd
Maybe I should include the link of the sitemap created by XMLSiteMaps.com
http://www34.brinkster.com/hongjunwap/blog/sitemap.html

I need something like this.

hongjun

Commented:
sorry i was away the yesterday so i will take a look now...

Commented:
ok my solution is too create a new sitemap each time a new post is added edited or removed.

i have created a sitemap similar to this for a recruitment website so for you, this could easily be done using PHP on the fly.  I assume all the posts are stored in a database and grouped by year then by month:

http://hongjun.blogspot.com/2006/11/got-myself-free-book.html

So the script would look like this:

<?php
//database connection string

$xml = '';
$xml .= '<?xml version="1.0" encoding="UTF-8"?>'."\n";
$xml .= '<urlset xmlns="http://www.google.com/schemas/sitemap/0.84" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.google.com/schemas/sitemap/0.84 http://www.google.com/schemas/sitemap/0.84/sitemap.xsd">'."\n";
$xml .= '      <url>'."\n";
$xml .= '            <loc>http://hongjun.blogspot.com/</loc>'."\n";
$xml .= '            <lastmod>2007-06-05</lastmod>'."\n";
$xml .= '            <changefreq>weekly</changefreq>'."\n";
$xml .= '            <priority>1.0</priority>'."\n";
$xml .= '      </url> '."\n";
$xml .= '      <url>'."\n";
$xml .= '            <loc>http://hongjun.blogspot.com/search?updated-max=2007-05-24T20%3A43%3A00%2B08%3A00</loc>'."\n";
$xml .= '            <lastmod>2006-06-05</lastmod>'."\n";
$xml .= '            <changefreq>monthly</changefreq>'."\n";
$xml .= '            <priority>0.9</priority>'."\n";
$xml .= '      </url>'."\n";

$queryXML = "SELECT title,year,month FROM tblBlogPost ORDER BY year,month";
$resultsXML = mysql_query($queryXML);
while($rows = mysql_fetch_array($resultsXML))
{
      $xml .= '      <url>'."\n";
      $xml .= '            <loc>http://hongjun.blogspot.com/'.strtolower($rows['year'].'/'.$rows['month'].'/'.$rows['title']).'.html</loc>'."\n";
      $xml .= '            <lastmod>'.date('Y-m-d').'</lastmod>'."\n";
      $xml .= '            <changefreq>weekly</changefreq>'."\n";
      $xml .= '            <priority>0.9</priority>'."\n";
      $xml .= '      </url>'."\n";
}

$xml .= '</urlset>'."\n";

$xmlfile = 'sitemap.xml';
$myfile = fopen($xmlfile,"w+");
fwrite($myfile,$xml);
fclose($myfile);    
?>

and the output of the sitemap structure would be as follows:

<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.google.com/schemas/sitemap/0.84" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.google.com/schemas/sitemap/0.84 http://www.google.com/schemas/sitemap/0.84/sitemap.xsd">
    <url>
        <loc>http://hongjun.blogspot.com/</loc>
        <lastmod>2006-06-05</lastmod>
        <changefreq>monthly</changefreq>
        <priority>0.9</priority>
    </url>
    <url>
<loc>http://hongjun.blogspot.com/search?updated-max=2007-05-24T20%3A43%3A00%2B08%3A00</loc>
        <lastmod>2006-06-05</lastmod>
        <changefreq>monthly</changefreq>
        <priority>0.9</priority>
    </url>
    <url>
        <loc>http://hongjun.blogspot.com/2007_06_01_archive.html</loc>
        <lastmod>2006-06-05</lastmod>
        <changefreq>monthly</changefreq>
        <priority>0.9</priority>
    </url>
    <url>
        <loc>http://hongjun.blogspot.com/2007_05_01_archive.html</loc>
        <lastmod>2006-06-05</lastmod>
        <changefreq>monthly</changefreq>
        <priority>0.9</priority>
    </url>
    <url>
        <loc>http://hongjun.blogspot.com/2007_04_01_archive.html</loc>
        <lastmod>2006-06-05</lastmod>
        <changefreq>monthly</changefreq>
        <priority>0.9</priority>
    </url>

....

    <url>
     <loc>http://hongjun.blogspot.com/2003/07/voice-recognition-sample-ok-since.html</loc>
        <lastmod>2006-06-05</lastmod>
        <changefreq>monthly</changefreq>
        <priority>0.9</priority>
    </url>
</urlset>

Ellandrd
They are not stored in a database.
Blogspot don't support download posts to a database.

hongjun

Commented:
so where are the posts stored then?
It is stored on the server.

In case you don't know, Blogger is a well-known free service owned by Google. I believe all blogspot posts are stored on Blogger's database server.
http://www.blogger.com


hongjun

Commented:
ok fair enough, but are they stored as XML file, TXT files or what?  the post must be stored in some type of file or database?
Users are not allowed to download posts in whatever format.
The logic is similar to you unable to download EE database in whatever format.

Have you used anything similar to a blog, forum, etc before? Are you able to download your posts?

hongjun
The 3 links do not lead me to my basic requirement.
Thanks for the effort anyway.

hongjun
Ellan, thx for these 3 great links!
Now I know I can create a sitemap for my blogspot blogs!

Commented:
fibo

;-)
This is not bad because it will do backup but just it don't have the labels.
http://www.codeplex.com/bloggerbackup

hongjun
The answers provided by the experts cover a large scope of answers and solutions to the initial question, and in fact more than was initially requested. Therefore points should not be refund, but allocated, eg with a split.
None of the links above is even close to my basic requirement in giving me the url of the post plus title of the post like what XMLSiteMaps is doing.
http://www34.brinkster.com/hongjunwap/blog/sitemap.html is generated by XMLSiteMaps.

hongjun
Commented:
Closed, 500 points refunded.
Vee_Mod
Community Support Moderator

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial