Adam's Google Sitemap Guide...

Want to just shoot the breeze? Forum 42 is the place!

Moderator: Moderators

Post Reply
Adam G
Posts: 212
Joined: Wed Aug 22, 2007 7:33 pm
Location: Olympia, WA
Contact:

Adam's Google Sitemap Guide...

Post by Adam G »

No, this wont be some boring documentary or a tutorial explaining every little detail. I'm just going to explain how to easily site map a couple thousands web pages in under an hour...manually.

Now, we will have some shortcuts, thank goodness. :) They were easy to come up with, after a little experimenting in excel and other programs.

You will need Notepad, or another form of text editor.
Microsoft Excel, though open office may suffice. (?)
A duplicate text remover of some kind, I used a trial of "Remove (Delete) Duplicate Lines & Words in Text Files Software", found
Here

I simply wanted to get indexed by Google faster on my Arcade website, I figured I would make it easy for them. I used no formatting on this, that is up for you to decide.
This is compiled and put together after I completed everything, so things may vary.


To start out, open Excel. We are going to make a template.
Take one snippet from your site map, I used this...

Code: Select all

 <url>
  <loc>http://thexarcade.com/</loc>
  <lastmod>2007-07-26</lastmod>
  <changefreq>weekly</changefreq>
  <priority>.9</priority>
 </url>
* Note: This was created by a Site map creator
Turn the code into something like this...

Code: Select all

<url><loc>http://thexarcade.com/</loc><lastmod>2007-07-26</lastmod><changefreq>weekly</changefreq><priority>.9</priority></url>
* Notice the single line.
In Excel, Copy/Paste your part of the code (into box A1), up to the URL, but not the URL itself.
Copy/paste the code after the URL into the C1 box.

Mine looks like this...
Image

Next, Copy/Paste that a few times. Remember, you only need to highlight the 3 cells.
Image

Okay, next we need to start getting those links. Not a fun job, by anyones standards.
I use Link Leecher
Now, enter your domain URL and let if grab some links, I recommend to "Output to Text File".
Copy and paste the collected links to an empty file in your favorite text editor.
Repeat this on pages it didn't reach. I had to do this over 80 times, once per game page and for random pages.

Now, copy/paste all of these links into the same file, three times! This is so you can freely use the Duplicate Text Remover.
Backup the file, if you feel the need to; I did.
Run the duplicate text editor and open the file, start it and wait.
When it's done, check the file to make sure everything is right. If you're like me and want to know how many links their are, open Microsoft Word, past them in, and click "Tools -> World Count..." Read the "lines", the number to the left is the number of links.

Now, Excel!
Remember our old template? Time to open it!

In Excel, copy/paste your template 5 times; repeat.
Once you have enough cells (Read the row numbers on the left), highlight all of columns B. Go to your text editor with all of the links. Copy/paste them into the B column of your Excel spreadsheet. Save this to back it up.
In a new text file, paste your site map code. Mine is like this, yours should be too...
Image
*Note: I would post the text code, but either there's a block on it or it keeps trying to parse in the code tags. >.< I'm assuming a block.

Highlight columns A, B, and C, all the way to the end of your text.
Copy/paste this text into the new text file, between both slices of code, save it as "some-sitemap-name-here.xml".

Congratulations, you are done!
After all that work, why not unwind with some free games on The X Arcade? If I need to remove this, mods do it for me or ask in a post/Pm and I will.

Questions or comments? Post them!

~Adam~
khaag
Senior Member
Posts: 2261
Joined: Sat Mar 18, 2006 7:54 pm

Post by khaag »

Why exactly are you creating an arcade website? Is it just for fun? Or are you actually doing this as a buisiness? Very professional site in design and by the looks of it, code as well! Good luck with it either way.

BTW, nice tutorial! :wink:
Adam G
Posts: 212
Joined: Wed Aug 22, 2007 7:33 pm
Location: Olympia, WA
Contact:

Post by Adam G »

khaag wrote:Why exactly are you creating an arcade website? Is it just for fun? Or are you actually doing this as a buisiness? Very professional site in design and by the looks of it, code as well! Good luck with it either way.

BTW, nice tutorial! :wink:
Lol, http://gamesitescript.com/ You're right, it is a professional site, made from a professional script. 8) Simple install and it's setup.
My friend and I made it for fun, hoping to make some cash in the possess. None yet, but we're still hoping...
Felino
Posts: 1010
Joined: Thu Jan 18, 2007 12:51 am
Location: Australia.

Post by Felino »

Ads = win. :D
Charlie wrote:I always wanted to try wall flips, but I'm too attached to my neck.
Image
Post Reply