How to export the Subversion log to spreadsheet

xml svn logging tortoisesvn spreadsheet
lamcro picture lamcro · Jul 11, 2012 · Viewed 31.9k times · Source

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 :(

Answer

lamcro picture lamcro · Jul 12, 2013

  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!

Related questions

PHP exec() not returning error message in output

I am trying to get certain output for svn command in XML format. Output is ok when I type valid parameters. However, when I type in wrong password, output does not show error message. This is the PHP code: exec(…

Read More
How do I comment out a block of tags in XML?

How do I comment out a block of tags in XML? I.e. How can I comment out <staticText> and everything inside it, in the code below? <detail> <band height="20"> <staticText> <…

Read More
Text editor to open big (giant, huge, large) text files

I mean 100+ MB big; such text files can push the envelope of editors. I need to look through a large XML file, but cannot if the editor is buggy. Any suggestions?

Read More