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 :(
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.
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.
Use the following Subversion command to create an xml file out of the repository's log:
svn log -v --xml > repository_log.xml
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
You can then save it as a spreadsheet.
That's it!
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With