Parse KTR

pentaho.groovy

import groovy.io.FileType
import groovy.xml.*

def dirStr = "C:\\integration\\Pentaho\\Projects\\content\\public"
def dir = new File(dirStr)
def slurper = new XmlSlurper()
def connFileMap = [:]
File outputFile = new File("c:\\Users\\CMaggiul\\connections.csv")


dir.eachFileRecurse(FileType.FILES) { file ->

    xmlFile = file.path
    xmlFileName = file.name
    connList = []
    def csv = ""
    if( file.name.endsWith('ktr') ) {
        xml = new XmlParser().parse(xmlFile)
        csv += "${xmlFileName},${xmlFile}"
        xml.connection.each {
            connName = it.name.text()
            if( connName ) {
                csv += ",${connName}"
                connList.add( connName )
            }
            
        }
        
        outputFile.withWriterAppend{ out ->
            out.println csv
        }
        
        connFileMap.put(xmlFileName, connList)
        
    } else if ( file.name.endsWith('kjb') ) {
        // Do Nothing For Now
    }
}

print connFileMap