ansaurus

Question

Repository info (SVN) integration with Excel

Answer 1

A:

You can write an Java thing which can access the SVN repository via SVNKit directly without calling svn.exe and extract the information from there and write into Excel files via PIO framework. That could be build as a web application and create the information on the fly...

khmarbaise 2010-08-04 10:13:35

Answer 2

+1 A:

svn list has an option -R or --recursive to include all subfolders. So, organizing your folder structure in a way that all required folders are subfolders of a main folder would reduce the number of calls needed. Alternatively, you can use the --depth option to control the depth of subfolders to descend.

Extract from svn help list output:

  -R [--recursive]         : descend recursively, same as --depth=infinity
  --depth ARG              : limit operation by depth ARG ('empty', 'files',
                            'immediates', or 'infinity')

I. e. organize you project in a way that the trunk and branches are relatively high in the folder structure, and the different phases are below that.

Frank 2010-08-04 10:14:26

SVN commands don't include subfolders .. if so, prove me wrong please :) Reorganizing our repository is out of the question, not my decision! The problem started just because of new folder structure in the first place :(

krizajB 2010-08-04 10:56:51

@krizajB - I just checked: it is not the default but an option to recurse subdirectories: -R or --recursive. I will edit my answer accordingly.

Frank 2010-08-04 11:23:29

Thanks! I will try to work with this, really hope i find some use of this. I was looking at switches so hard i couldn't see the most important ones from a week of research :)

krizajB 2010-08-04 11:37:40

For those who might wonder how i did it. For revision gathering, i used svn command like that: GetCommandOutput("cmd.exe /c svn list -v -R http:/localhost/documents/trunk"), parsed that string into array and inserted useful info into my Excel Sheet.For tags i used a lot faster command: GetCommandOutput("cmd.exe /c svn list --depth infinity http:/localhost/documents/tags"), parsed string to get tag.Frank, thanks again!

krizajB 2010-08-05 12:39:58

Answer 3

A:

You can access the repository using the API for .NET. See this answer

You will probably need to use VSTO instead of VBA though.

renick 2010-08-04 10:18:19

ansaurus

tags:

views:

answers:

Repository info (SVN) integration with Excel

related questions