Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to export the Subversion log to spreadsheet

Is there a way to export the Subversion log messages to a spreadsheet(excel, csv, etc.) format?

When copying from the Log Messages window in TortoiseSVN, it pastes text in the following format:

Revision: 174
Author: CARDINALHEALTH\enrique.colon
Date: Wednesday, July 11, 2012 9:37:02 AM
Message: CR #58514
----
Modified : /trunk/ob_progs/utility/connect_peek

I could create a script to reformat this to CSV, if necessary. But I really don't want to :(

like image 865
lamcro Avatar asked Jul 11 '12 15:07

lamcro


People also ask

Where are svn logs stored?

If you are running SVN over Apache (HTTP or HTTPS), you will want to look at Apache's log. By default going to be in /var/log/httpd . The red book has some good information on it.

How do I view svn file history?

To find information about the history of a file or directory, use the svn log command. svn log will provide you with a record of who made changes to a file or directory, at what revision it changed, the time and date of that revision, and, if it was provided, the log message that accompanied the commit.


1 Answers

  1. Use the following Subversion command to create an xml file out of the repository's log:

    svn log -v --xml > repository_log.xml

  2. Import the xml file into an Excel spreadsheet (not sure if it will work with LibreOffice/OpenOffice), e.g. from cmd:

    start excel repository_log.xml

  3. You can then save it as a spreadsheet.

That's it!

like image 91
lamcro Avatar answered Sep 21 '22 19:09

lamcro