Repository info (SVN) integration with Excel -


I am new in things like Kenda is posting for programming for the first time, It was also necessary that he was successful in Google. thank you for your patience :).

About my problem / goal: On our project, we have to take certain types of document management control. We have around 160 DOCX files (all files are already known), we will use SVN for version control. Those files will be saved in different folders (I will create the repository structure in the future), the folders will have one step work that we are currently in our project (we will have around 12 folders). When a step is done, then alias tag. Official release will be done. In each file, the MS Excel worksheet column will be in place such as: step, name, modification, tag, hyperlink ..

What do I do: macro which will search the file on the repository, Got it, tag (latest) .. write it in excel sheet and make that file hyperlink in another column.

Repository structure:

  • Trunk
    • System_Development
      • System_Requirements_Specifications.docx
      • System_Architecture_Description.docx
      • Software_Configuration_Management_Plan.docx < / Li>
      • ...
    • ...
  • Branches (probably will not be used yet, of course
  • Tag
      <
    • 1
      • System_Development
        • System_Requirements_Specifications.docx
        • System_Architecture_Description.docx
          • < Li> System_Safety_Plan.docx
        • ...
      • ...
    • Software plan
      • Software_Quality_Assurance_Plan.docx
      • Software_Configuration_Management_Plan.docx
        • < Li> ...

    I've already created a macro that does the exact thing, but the problem is very much How slow and why?

    I was using ShellAndWait ("cmd.exe / c svn list --verbose http: \\ localhost \ trunk" text.txt ") , that Get the folders in the trunk to parse the text file, then the checked files are in those folders (with other shell endwits for each folder), if they get similar numbers .. on

    As you see in the end, my code svn command was executed 13 times, so the file was found in the repository . With the SVN list -verbose I also get the amendment number. To execute it svn stands around 0.15-0.20 of a second for the command, so collecting my revision number lasts approximately 2 seconds. What is not a problem

    Getting a tag is a problem, because my folder has a folder, so in the end we may have approximately 40 or more SVN executions, which will slow down my tag function Will give

    I have no clue how to use the repository in any other way so that it is with svn.exe. I'm thinking of remotely accessing the repository and inquiring from the database or at any time I am researching that part.

    Hope you understand my problem, I have been benefitting all day for any more information! Thanks for your help!

svn An option to include all subfolders in the list is R-or --recursive, therefore, To organize your folder structure in such a way that all the required folders are the subfolders of the main folder, will reduce the number of calls required. Alternatively, you can use the --depth option to control the depth of the subfolders given below. Remove

svn help list from output: 

  -r [--recursive]: recursively descend, such as-deep = infinity --depth ARG: Threshold operation by Depth ARG ('empty', 'file', 'quick', or 'infinity')

I You can organize the project in such a way that trunk and branches are relatively high in folder structure and different steps are below it.


-

Comments

Post a Comment

Popular posts from this blog

Eclipse CDT variable colors in editor -

I hope this is a good question to ask here. This programming is related, so I thought it would be better than the superuser, so I am using the CDT C ++ Eclipse plugin. I know how the editor changes colors for some things But is there a way to do that all the variables are different colors? For example in KDEValue, it sets the local variables and square variables in different colors and bold square squares. Can I copy it to CDT? Eclips provides some level of color customization for text editor syntax You can see it on the following: There are many elements, including the Window> Preferences> C / C ++> Editor> Syntax color code that can be changed, assembly, Comments, Preprocessor and Doxian Under the code, it is possible to change the color of some variable types, such as global variables, local variable announcements, local variable references, and parameter variables. But I do not think the code is capable of changing the color of each variable declared....
Read more

AJAX doesn't send POST query -

$ (दस्तावेज़) .ready (function () {function ajaxselectrss (rssurlvar) {var ajaxRequest; // वेरिएबल जो अजाक्स को संभव बनाता है! कोशिश करें कि {// ओपेरा 8.0+, फ़ायरफ़ॉक्स, सफारी अजाक्स अनुरोध} = नया एक्सएमएलएचटीपीआरइवेस्ट ();} कैच (ई) {// इंटरनेट एक्सप्लोरर ब्राउज़र्स {ajaxRequest = new ActiveXObject ("Msxml2.XMLHTTP");} पकड़ो (ई) {try {ajaxRequest = new ActiveXObject ("Microsoft.XMLHTTP");} कैच (ई) {// कुछ गलत चेतावनी ("आपका ब्राउज़र तोड़ दिया!"); वापसी झूठी;}}} // एक बनाएं फ़ंक्शन जो सर्वर से भेजे गए डेटा प्राप्त करेंगे ajaxRequest.onreadystatechange = function () {if (ajaxRequest.readyState == 4) {var ajaxDisplay = document.getElementById ('news'); ajaxDisplay.innerHTML = ajaxRequest.responseText;}} / / Var rssurlvar = $ (this) .attr ("title"); var queryString = "rurl =" + rssurlvar; var urltofile = "rssget.php"; ajaxRequest.open ("पोस्ट", urltofile, सच); ajaxRequ Est.setRequestHeader ("सामग्री-प्र...
Read more

wpf - Custom Message Box Advice -

Well, I'm using a custom window box that comes with some custom control boxes that accompany the text The producers who are displayed are called. I have a defined event, which has been subscribed through the original class, it gets burnt when clicking on the button. However, I can not see how to use it effectively, I would like to return one yes, whether yes or not, but obviously my code will continue to execute, so this Below is some example code to clarify the problem that the method has subscibed by clicking on the button. Message box window Public partial class custom message box: window {public representative message messagebox object sender, event events e); Public event messagebox handler messagebox document; Public Customs Box () {Initial group (); } Public Customsbox (String Message) {InitializeComponent (); This.txtdescription.Text = Message; } Public Customsbox (String Message, String Title, String First BTNtext) {Initialization (); This.lbltitle.Content =...
Read more