CODEWITHSUNDEEP
svn
Darshan Shah
Darshan Shah

Reputation: 71

Get list of changed files in svn in Excel Sheet

I Want to get a list of all changed files in svn first revision to last, I want to all changed file in excel sheet?

Upvotes: 0

Views: 918

Answers (2)

granadaCoder
granadaCoder

Reputation: 27842

You can run a svn diff and output to an xml file. Then run this basic xsl file against it.

Put this in a .bat file

set __SVNClient="C:\Program Files\CollabNet\Subversion Client\svn.exe"
set __svnBaseSVNSourceLocation=https://mySVNServer.com/MyRepository

%__SVNClient% diff --revision 333:HEAD "%__svnBaseSVNSourceLocation%"  --summarize --username %USERNAME% --xml >>svndiffexample.xml

set __svnBaseSVNSourceLocation=
set __SVNClient=

Then apply this xsl to the above xml.

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
    <xsl:output method="text" indent="yes"/>
    <xsl:template match="/">item,props,kind,path<xsl:text>&#10;</xsl:text>
        <xsl:for-each select="//diff/paths/path">
<xsl:value-of select="@item"/>,<xsl:value-of select="@props"/>,<xsl:value-of select="@kind"/>,<xsl:value-of select="."/>
            <xsl:text>&#10;</xsl:text>
        </xsl:for-each>
    </xsl:template>
</xsl:stylesheet>

and you'll get an output like this

item,props,kind,path
modified,none,file,https://mySVNServer.com/MyRepository/MyFile01.txt
modified,none,file,https://mySVNServer.com/MyRepository/ABCFolder/INC/MyFile01.inc
modified,none,file,https://mySVNServer.com/MyRepository/ABCFolder/Js/MyFile01.js
modified,none,file,https://mySVNServer.com/MyRepository/DEFFolder/MyFile01.pdf

Upvotes: 0

Mark Bramnik
Mark Bramnik

Reputation: 42431

Create a CSV file with your favorite svn client and open it in Excel. Excel reads CSV so that you don't really need to know internal excel format.

Upvotes: 1

Related Questions