{"id":1272,"date":"2007-10-09T12:28:22","date_gmt":"2007-10-09T19:28:22","guid":{"rendered":"https:\/\/blogs.plm.automation.siemens.com\/t5\/Polarion-Blog\/Microsoft-Office-and-Subversion-Part-1\/ba-p\/380590"},"modified":"2026-03-26T05:36:24","modified_gmt":"2026-03-26T09:36:24","slug":"microsoft-office-and-subversion-part-1","status":"publish","type":"post","link":"https:\/\/blogs.sw.siemens.com\/polarion\/microsoft-office-and-subversion-part-1\/","title":{"rendered":"Microsoft Office and Subversion (Part 1)"},"content":{"rendered":"<p><H2>Prerequisites<\/H2><br \/>\n<UL><br \/>\n\t<LI>Good knowledge about Microsoft Windows and Windows Explorer<\/LI><br \/>\n\t<LI>Intermediate to good knowledge about Microsoft Office<\/LI><br \/>\n\t<LI>Access to an existing Subversion server instance with <A href=\"http:\/\/svnbook.red-bean.com\/nightly\/en\/svn.webdav.autoversioning.html\" rel=\"nofollow noopener noreferrer\">Autoversioning Commit<\/A> enabled<\/LI><br \/>\n\t<LI>Optional: TortoiseSVN has been installed on your computer<\/LI><br \/>\n<\/UL><br \/>\n<H2>General<\/H2><br \/>\nSubversion is the perfect storage for Microsoft  Office documents<br \/>\n<UL><br \/>\n\t<LI>Accessing your storage runs either through http (https) or through nice Windows Explorer extension TortoiseSVN<\/LI><br \/>\n\t<LI>Binary formats are handled very well and efficiently<\/LI><br \/>\n\t<LI>Triggers released by your activities on Subversion allow defined and controlled way to disseminate information about changes<\/LI><br \/>\n\t<LI>Each document or the folder containing these documents keeps arbitrary number of properties to store meta data about your document<\/LI><br \/>\n\t<LI>Version numbers of your document could be projected directly into your document<\/LI><br \/>\n<\/UL><br \/>\nIn the subsequent blogs we will have a look on each of these topics more in detail.<br \/>\nWith this blog we have a look how you work with Microsoft Office and Subversion.<br \/>\n<H2><SPAN>Accessing Your Subversion Instance<P><\/P><\/SPAN><\/H2><br \/>\n<H3><SPAN>\u201cStraight\u201d<\/SPAN><\/H3><br \/>\n<SPAN>This way to work with documents located in a Subversion repository is the easiest one you can imagine.<P><br \/>\n<\/P>Just drop a URL into the open file dialogue which starts with \u201chttp:\/\/&#8230;\u201d pointing you directly to a document in Subversion and start your work.<P><br \/>\n<\/P><\/SPAN>Each save will generate a new revision in Subversion. Please use this option sparsely especially if you are working in a network where bandwidth is a valuable resource.<\/p>\n<p><A href=\"http:\/\/community.plm.automation.siemens.com\/legacyfs\/online\/siemensplm_blogs\/2007\/10\/lookmaanurl.gif\" title=\"lookmaanurl.gif\" rel=\"nofollow noopener noreferrer\"><IMG src=\"http:\/\/community.plm.automation.siemens.com\/legacyfs\/online\/siemensplm_blogs\/2007\/10\/lookmaanurl.gif\" alt=\"lookmaanurl.gif\" \/><\/A><br \/>\n<H3><SPAN>Check In\/Out<P><\/P><\/SPAN><\/H3><br \/>\n<P class=\"MsoNormal\"><SPAN>By using TortoiseSVN you keep local copies on your desktop or laptop computer. If you are often offline or prefer workplaces outside office, this is your choice. Before you start please ask your project manager or system administrator for URL of your project.<SPAN> <\/SPAN><P><\/P><\/SPAN><\/P><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\"><SPAN>Also make sure that you have installed TortoiseSVN on your computer. You can check this briefly by right clicking in the Microsoft Windows\u2019 Desktop.<P> <\/P>See context menu on the right hand side highlighting the two menu entries to check presence of TortoiseSVN.<\/SPAN><\/P><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\"><A href=\"http:\/\/community.plm.automation.siemens.com\/legacyfs\/online\/siemensplm_blogs\/2007\/10\/svnmenu.gif\" title=\"svnmenu.gif\" rel=\"nofollow noopener noreferrer\"><IMG src=\"http:\/\/community.plm.automation.siemens.com\/legacyfs\/online\/siemensplm_blogs\/2007\/10\/svnmenu.gif\" alt=\"svnmenu.gif\" \/><\/A><\/P><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\">&nbsp;<\/P><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\"><SPAN>Now browse to a folder where you like to put your documents into downloaded from your Subversion server and right-click on the folder which should be empty. Select \u201cSVN Checkout\u2026\u201d and enter rhe URL provided by your system administrator or project manager identifying the location of your documents in the Subversion repository.<P> <\/P><\/SPAN>Now Subversion uploads all data into the selected destination on your local hard disc and you are ready to start your work.<\/P><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\"><A href=\"http:\/\/community.plm.automation.siemens.com\/legacyfs\/online\/siemensplm_blogs\/2007\/10\/svncheckout.gif\" title=\"svncheckout.gif\" rel=\"nofollow noopener noreferrer\"><IMG src=\"http:\/\/community.plm.automation.siemens.com\/legacyfs\/online\/siemensplm_blogs\/2007\/10\/svncheckout.gif\" alt=\"svncheckout.gif\" \/><\/A><\/P><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\">&nbsp;<\/P><\/p>\n<p><H2>Preparing Your Documents for Exposure of Subversion<\/H2><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\"><SPAN>Select all your documents in your local workspace. Right-click and select \u201cProperties\u201d in the bottom of the context menu.<P><\/P> Select the \u201cSubversion\u201d tab.<P> <\/P>Now you see a lot of data related to Subversion.<P> <\/P>For the moment we are only interested in the button in the bottom labeled \u201cProperties\u201d.<P> <\/P>That is next stop of our journey. Click on it and you see a dialogue which let you add some meta data for your document.<\/SPAN><br \/>\n<A href=\"http:\/\/community.plm.automation.siemens.com\/legacyfs\/online\/siemensplm_blogs\/2007\/10\/svnproperties.gif\" title=\"svnproperties.gif\" rel=\"nofollow noopener noreferrer\"><IMG src=\"http:\/\/community.plm.automation.siemens.com\/legacyfs\/online\/siemensplm_blogs\/2007\/10\/svnproperties.gif\" alt=\"svnproperties.gif\" \/><\/A><br \/>\n<\/P><P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\">&nbsp;<\/P><br \/>\n<P class=\"MsoNormal\"><SPAN>With the help of this dialogue box we add Subversion meta data to selected documents. This could be any kind of tag\/value combination.<P><\/P><\/SPAN><\/P><br \/>\n<P class=\"MsoNormal\"><SPAN>Subversion itself uses special keywords which let you influence Subversion\u2019s behavior on the server or locally. If your organization is considering Subversion as document repository use these Subversion properties to store additional data which should not be kept in the document itself. In a later blog we will show to expose such kind arbitrary data in your Microsoft Office documents.<P><\/P><\/SPAN><\/P><br \/>\n<P class=\"MsoNormal\"><EM><SPAN>Now let us move on and prepare us for the next part of this blog.<\/SPAN><\/EM><\/P><br \/>\n<P class=\"MsoNormal\">&nbsp;<\/P><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\"><SPAN>In the properties dialogue click on \u201cAdd\u2026\u201d button opening a windows which let you add your tag\/value keys. TortoiseSVN offers some of the special keywords in the drop-down menu. Please select \u201csvn:keywords\u201d, that is the name of the property.<P><\/P><\/SPAN><\/P><\/p>\n<p><P class=\"MsoNormal\"><SPAN>Now enter the property value as shown in the screen-shot, \u201cDate Revision Author\u201d. The sequence of these keywords is irrelevant.<P><br \/>\n<\/P>Confirm and close all dialogues by pressing OK.<\/SPAN><br \/>\n<\/P><P class=\"MsoNormal\"><A href=\"http:\/\/community.plm.automation.siemens.com\/legacyfs\/online\/siemensplm_blogs\/2007\/10\/svneditproperties.gif\" title=\"svneditproperties.gif\" rel=\"nofollow noopener noreferrer\"><IMG src=\"http:\/\/community.plm.automation.siemens.com\/legacyfs\/online\/siemensplm_blogs\/2007\/10\/svneditproperties.gif\" alt=\"svneditproperties.gif\" \/><\/A><\/P><br \/>\n<P class=\"MsoNormal\">&nbsp;<\/P><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\">&nbsp;<\/P><br \/>\n<P class=\"MsoNormal\"><SPAN>In the subsequent step you will learn how to write your changes back into the server. Another time you right-click on your working directory or if you like on single files and select the menu item \u201cCommit\u2026\u201d.<P><\/P><\/SPAN><\/P><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\"><SPAN>Commit writes all changes back to the Subversion repository. If the transaction could not be performed Subversion\u2019s repository reverts the full transaction and does not keep the server in an unpredictable state. <P><\/P><\/SPAN><\/P><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\"><SPAN><P><\/P>A successful commit will be acknowledged by Subversion by returning a \u201cRevision\u201d number. This revision number let you identify the status of your data in the timeline of your work.<P><\/P><\/SPAN><\/P><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\"><SPAN><P><\/P>Numbers like this are pretty hard to remember. Subversion also allows attaching a message to each commit. This is your log or audit trail to review changes.<P><\/P><\/SPAN><\/P><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\">&nbsp;<\/P><br \/>\n <A href=\"http:\/\/community.plm.automation.siemens.com\/legacyfs\/online\/siemensplm_blogs\/2007\/10\/svncommit.gif\" title=\"svncommit.gif\" rel=\"nofollow noopener noreferrer\"><IMG src=\"http:\/\/community.plm.automation.siemens.com\/legacyfs\/online\/siemensplm_blogs\/2007\/10\/svncommit.gif\" alt=\"svncommit.gif\" \/><\/A><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\"><SPAN>The upcoming dialogue shows status information during data transmission back the server. <P><\/P>If the transaction succeeds, you will see message similar to the one in the screen-shot<\/SPAN><\/P><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\"><SPAN>.<\/SPAN><A href=\"http:\/\/community.plm.automation.siemens.com\/legacyfs\/online\/siemensplm_blogs\/2007\/10\/svncommitfisished.gif\" title=\"svncommitfisished.gif\" rel=\"nofollow noopener noreferrer\"><IMG src=\"http:\/\/community.plm.automation.siemens.com\/legacyfs\/online\/siemensplm_blogs\/2007\/10\/svncommitfisished.gif\" alt=\"svncommitfisished.gif\" \/><\/A><\/P><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\">&nbsp;<\/P><br \/>\n<P class=\"MsoNormal\"><SPAN>Now stay tuned for the next part in this blog series when we pull in the Subversion revision meta data, like author, revision number, commit message or date into the document each time when we commit our changes.<P><\/P><\/SPAN><\/P><br \/>\nBest Wishes<br \/>\nRobert<br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\">&nbsp;<\/P><br \/>\n<P class=\"MsoNormal\" style=\"margin-bottom: 0.0001pt\">&nbsp;<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Prerequisites <\/p>\n<p>\t Good knowledge about Microsoft Windows and Windows Explorer<br \/>\n\t Intermediate to good knowledge about Microsoft Office<br \/>\n\t Access to an existing Subversion server instance with Autove&#8230;<\/p>\n","protected":false},"author":68985,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spanish_translation":"","french_translation":"","german_translation":"","italian_translation":"","polish_translation":"","japanese_translation":"","chinese_translation":"","footnotes":""},"categories":[1],"tags":[],"industry":[],"product":[],"coauthors":[],"class_list":["post-1272","post","type-post","status-publish","format-standard","hentry","category-news"],"_links":{"self":[{"href":"https:\/\/blogs.sw.siemens.com\/polarion\/wp-json\/wp\/v2\/posts\/1272","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.sw.siemens.com\/polarion\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.sw.siemens.com\/polarion\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.sw.siemens.com\/polarion\/wp-json\/wp\/v2\/users\/68985"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.sw.siemens.com\/polarion\/wp-json\/wp\/v2\/comments?post=1272"}],"version-history":[{"count":1,"href":"https:\/\/blogs.sw.siemens.com\/polarion\/wp-json\/wp\/v2\/posts\/1272\/revisions"}],"predecessor-version":[{"id":1273,"href":"https:\/\/blogs.sw.siemens.com\/polarion\/wp-json\/wp\/v2\/posts\/1272\/revisions\/1273"}],"wp:attachment":[{"href":"https:\/\/blogs.sw.siemens.com\/polarion\/wp-json\/wp\/v2\/media?parent=1272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.sw.siemens.com\/polarion\/wp-json\/wp\/v2\/categories?post=1272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.sw.siemens.com\/polarion\/wp-json\/wp\/v2\/tags?post=1272"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/blogs.sw.siemens.com\/polarion\/wp-json\/wp\/v2\/industry?post=1272"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/blogs.sw.siemens.com\/polarion\/wp-json\/wp\/v2\/product?post=1272"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/blogs.sw.siemens.com\/polarion\/wp-json\/wp\/v2\/coauthors?post=1272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}