' GoogleSitemap.vbs
' VERSION: 1.0
' AUTHOR: Brian Steinmeyer
' WEB:
' DATE: 4/1/2012
' COMMENTS: Traverse a local website root folder and generates a Google
' Sitemap .xml file based on the folder structure. Modify the variables
' in the settings section accordingly. The variables are explained below:
' conLocalRoot - Local Website Root Folder
' conSitemap - Google Sitemap XML file to output
' conDefaultChangeFreq - Default Change Frequency for Sitemap
' conDefaultPriority - Default Priority for Sitemap
' blnSortAtoZ - Option to sort the sitemap alphabetically
' arrValidFileExtension - list of Valid file extensions to include int he sitemap
' arrDefaultDocument - list of valid default document names which are not added to the sitemap
' arrExcludedFolder - List of folders to exclude from the sitemap
' arrExcludedFile - List of file names to exclude from the sitemap
Option Explicit
Const conLocalRoot = "C:\inetpub\wwwroot\"
Const conSitemap = "C:\inetpub\wwwroot\sitemap.xml"
Const conWebsiteFQDN = ""
Const conDefaultChangefreq = "monthly"
Const conDefaultPriority = "0.5"
Const blnSortAtoZ = False
Dim arrValidFileExtension: arrValidFileExtension = array("php","asp","aspx","htm","html","shtml")
Dim arrDefaultDocument: arrDefaultDocument = array("index.php","index.asp","index.aspx","index.htm","index.html","index.shtml")
Dim arrExcludedFolder: arrExcludedFolder = array("_includes","css","images")
Dim arrExcludedFile: arrExcludedFile = array("404.php")
' ------ END CONFIGURATION ------

'Validate Arrays
Dim blnValidFileExtensionIsArray: blnValidFileExtensionIsArray = False
Dim blnDefaultDocumentIsArray: blnDefaultDocumentIsArray = False
Dim blnExcludedFolderIsArray: blnExcludedFolderIsArray = False
Dim blnExcludedFileIsArray: blnExcludedFileIsArray = False
If IsArray(arrValidFileExtension) Then
    blnValidFileExtensionIsArray = True
End If
If IsArray(arrDefaultDocument) Then
    blnDefaultDocumentIsArray = True
End If
If IsArray(arrExcludedFolder) Then
    blnExcludedFolderIsArray = True
End If
If IsArray(arrExcludedFile) Then
    blnExcludedFileIsArray = True
End If

'Crawl Local Webroot Folder
Dim arrResults()
Call CrawlFolder(conLocalRoot, 0, arrResults)

'Optionally Sort Results Array - Maybe Move this
If blnSortAtoZ = True Then
    Call BubbleSort(arrResults)
End If

'Write Sitemap XML File

'End Script
Wscript.Echo "Finished"

Private Function CrawlFolder(FolderToCrawl, intFiles, ByRef arrFiles)

    'Start Crawling Folder
   Dim objFSO: Set objFSO = CreateObject("Scripting.FileSystemObject")
    Dim objFolder: Set objFolder = objFSO.GetFolder(FolderToCrawl) 
    Dim blnFolderIsExcluded: blnFolderIsExcluded = False

    'Check If We Should Exclude This Folder
    If blnExcludedFolderIsArray = True Then
        Dim strExcludedFolder
        For Each strExcludedFolder in arrExcludedFolder
            If StrComp(objFolder.Name,strExcludedFolder,1) = 0 Then
                blnFolderIsExcluded = True
            End If
    End If

    'Parse Files in Folder
   If blnFolderIsExcluded = False Then

        Dim objFiles: Set objFiles = objFolder.Files
        Dim objFile, strResult
        Dim strDefaultDocument, strValidFileExtension, strExcludedFile
        Dim blnFileIsExcluded, blnFileExtensionIsValid, blnDefaultDocument

        For Each objFile In objFiles

            blnFileIsExcluded = False
            blnFileExtensionIsValid = False
            blnDefaultDocument = False
            strResult = ""

            'Check If We Should Exclude This File
            If blnExcludedFileIsArray = True Then
                For Each strExcludedFile in arrExcludedFile
                    If StrComp(objFile.Name,strExcludedFile,1) = 0 Then
                        blnFileIsExcluded = True
                    End If
            End If

            'Check If We Should Exclude This File Extension
            If blnValidFileExtensionIsArray = True Then
                For Each strValidFileExtension in arrValidFileExtension
                    If StrComp(objFSO.GetExtensionName(objFile.Name),strValidFileExtension,1) = 0 Then
                        blnFileExtensionIsValid = True
                    End If
            End If             

            If blnFileIsExcluded = False AND blnFileExtensionIsValid = True Then
                strResult = objFile.Path
                ReDim Preserve arrFiles(intFiles)
                arrFiles(intFiles) = strResult
                intFiles = intFiles + 1
            End If

        'Crawl Subfolders
        Dim objSubFolder
        For Each objSubFolder In objFolder.SubFolders
            Call CrawlFolder(objSubFolder.Path, intFiles, arrResults)

    End If

    CrawlFolder = arrFiles

    Set objFSO = Nothing
    Set objFolder = Nothing
    Set objFiles = Nothing

End Function

Private Sub WriteSiteMap(arrSites)

    Dim objFSO: Set objFSO = CreateObject("Scripting.FileSystemObject")
    If objFSO.FileExists(conSitemap) Then
        Dim strPath, strUrl, objNodeLoc, objNodeLastmod
        Dim xmlDoc: Set xmlDoc = CreateObject("Microsoft.XMLDOM")
        xmlDoc.preserveWhiteSpace = False
        xmlDoc.Async = False
        Dim arrAppend()
        Dim intAppend: intAppend = 0
        If xmlDoc.Load(conSitemap) Then
            For Each strPath in arrSites
                strUrl = ConvertLocalPathToUrl(strPath)
                Set objNodeLoc = xmlDoc.selectSingleNode("/urlset/url " & "[loc = '" & strUrl & "']")
                If Not objNodeLoc Is Nothing then
                    'Found a Match Update the Date
                    Set objNodeLastmod = xmlDoc.selectSingleNode("/urlset/url " & "[loc = '" & strURL & "']/lastmod")
                    If Not objNodeLastmod Is Nothing Then  
                        objNodeLastmod.Text = GetDate(objFSO.GetFile(strPath).DateLastModified)
                    End If
                    xmlDoc.Save conSitemap
                    'Append URL to sitemap.xml
                    Dim objRoot: Set objRoot = xmlDoc.documentElement
                    Dim objRecord: Set objRecord = xmlDoc.createElement("url")
                    'objRecord.setAttribute "xmlns", "")
                    objRoot.appendChild objRecord
                    Dim objFieldValue
                    Set objFieldValue = xmlDoc.createElement("loc")
                    objFieldValue.Text = strUrl
                    objRecord.appendChild objFieldValue
                    'Last Modified
                    Set objFieldValue = xmlDoc.createElement("lastmod")
                    objFieldValue.Text = GetDate(objFSO.GetFile(strPath).DateLastModified)
                    objRecord.appendChild objFieldValue
                    'Change Frequency
                    Set objFieldValue = xmlDoc.createElement("lastmod")
                    objFieldValue.Text = conDefaultChangefreq
                    objRecord.appendChild objFieldValue
                    Set objFieldValue = xmlDoc.createElement("lastmod")
                    objFieldValue.Text = conDefaultPriority
                    objRecord.appendChild objFieldValue                
                    'Save Sitemap.xml
                    xmlDoc.Save conSitemap
                End If
            Wscript.Echo "Error Loading sitemap.xml Or sitemap.xml is NOT valid XML"
        End If
        'Cheap Hack to Cleanup Appends
        Set xmlDoc = Nothing
        Dim objTextFile: Set objTextFile = objFSO.OpenTextFile(conSitemap, 1)
        Dim strText: strText = objTextFile.ReadAll
        strText = Replace(strText," xmlns=" & chr(34) & chr(34),"")
        Set objTextFile = objFSO.OpenTextFile(conSitemap, 2)
        objTextFile.Write strText
        'Make New Sitemap File
        Call Logger(conSitemap,"<?xml version=" & chr(34) & "1.0" & chr(34) & " encoding=" & chr(34) & "UTF-8" & chr(34) & "?>",True)
        Call Logger(conSitemap,"<urlset xmlns=" & chr(34) & "" & chr(34) & ">",False)
        Dim strLoc
        For Each strLoc in arrSites
            Call Logger(conSitemap,vbTab & "<url>",False)
            Call Logger(conSitemap,vbTab & vbTab & "<loc>" & ConvertLocalPathToUrl(strLoc) & "</loc>",False)
            Call Logger(conSitemap,vbTab & vbTab & "<lastmod>" & GetDate(objFSO.GetFile(strLoc).DateLastModified) & "</lastmod>",False)
            Call Logger(conSitemap,vbTab & vbTab & "<changefreq>" & conDefaultChangefreq & "</changefreq>",False)
            Call Logger(conSitemap,vbTab & vbTab & "<priority>" & conDefaultPriority & "</priority>",False)
            Call Logger(conSitemap,vbTab & "</url>",False)
        Call Logger(conSitemap,"</urlset>",False)
    End If

    Set objFSO = Nothing

End Sub

Private Function ConvertLocalPathToUrl(strPath)

    'Check If File is Default Document
    Dim objFSO: Set objFSO = CreateObject("Scripting.FileSystemObject")
    Dim strDefaultDocument
    Dim blnDefaultDocument: blnDefaultDocument = False
    If blnDefaultDocumentIsArray = True Then
        For Each strDefaultDocument in arrDefaultDocument
            If StrComp(objFSO.GetFileName(strPath),strDefaultDocument,1) = 0 Then
                blnDefaultDocument = True
            End If
    End If

    'Return Results
    Dim strResult: strResult = ""
    strResult = Replace(strPath,conLocalRoot,conWebsiteFQDN,1,1,1)
    strResult = Replace(strResult,"\","/")
    If blnDefaultDocument = True Then
        strResult = Replace(strResult,objFSO.GetFileName(strPath),"")
    End If

    ConvertLocalPathToUrl = strResult

    Set objFSO = Nothing

End Function

Private Function BubbleSort(ByRef arrValues)

    Dim j, k, Temp
    For j = 0 To UBound(arrValues) - 1
        For k = j + 1 To UBound(arrValues)
            If (arrValues(j) > arrValues(k)) Then
                Temp = arrValues(j)
                arrValues(j) = arrValues(k)
                arrValues(k) = Temp
            End If

    BubbleSort = arrValues

End Function

Private Function GetDate(strDate)

    'Ensure Valid Date
    If Not IsDate(strDate) Then
        strDate = Date
    End If

    Dim strYear: strYear = Year(strDate)
    Dim strMonth: strMonth = Month(strDate)
    Dim strDay: strDay = Day(strDate)
    If strMonth < 10 Then
        strMonth = 0 & strMonth
    End If
    If strDay < 10 Then
        strDay = 0 & strDay
    End If

    GetDate = strYear & "-" & strMonth & "-" & strDay

End Function

Private Sub Logger(fileName, logMessage, blnNewLog)

    On Error Resume Next

    Const ForReading = 1, ForWriting = 2, ForAppending = 8
    Dim objFSO: Set objFSO = CreateObject("Scripting.FileSystemObject")
    Dim scriptPath: scriptPath = Left(WScript.ScriptFullName,InstrRev(WScript.ScriptFullName,"\"))
    Dim logName
    If InStr(1,fileName,"\",1) > 0 Then
        logName = fileName
        If objFSO.DriveExists(objFSO.GetDriveName(logName)) Then
            If StrComp(objFSO.GetExtensionName(logName), "", 1) = 0 Then
                If Not objFSO.FolderExists(logName) Then
                    If objFSO.FolderExists(objFSO.GetParentFolderName(logName)) Then
                        objFSO.CreateFolder logName 'Create Folder In Current Path
                        Exit Sub
                        Call Logger(objFSO.GetParentFolderName(logName), logMessage, blnNewLog) 'Recurse Creating Parent Folder
                        Call Logger(logName, logMessage, blnNewLog) 'Recurse Creating Current Folder
                        Exit Sub
                    End If
                End If
                If Not objFSO.FileExists(logName) Then
                    If Not objFSO.FolderExists(objFSO.GetParentFolderName(logName)) Then
                        Call Logger(objFSO.GetParentFolderName(logName), logMessage, blnNewLog)  'Recurse Creating Parent Folder
                        Call Logger(logName, logMessage, blnNewLog)  'Recurse Creating Current Folder
                    End If
                End If
            End If
        End If
        logName = scriptPath & fileName
    End If
    Dim logFile
    If blnNewLog = True Then
        Set logFile = objFSO.CreateTextFile(logName, True)
        If objFSO.FileExists(logName) Then
            Set logFile = objFSO.OpenTextFile(logName, ForAppending, True)
            Set logFile = objFSO.CreateTextFile(logName, True)
        End If
    End If
    logFile.WriteLine logMessage
    Set objFSO = Nothing

    On Error Goto 0



Leave a Reply

Your email address will not be published. Required fields are marked *