How to Create a Usable Sourcesafe Files Report

Step-by-Step Guide

1. 1

   Step 1: From VSS

   Select 'Recursive' (only if you want all files from here down), 'Include files' and Report to: 'Clipboard'.
   
   Click OK.
2. 2

   Step 2: navigate to the desired folder and run the files report (Tools | Files Report).

   , Note:
   The 1st doesn't use wildcards, the 2nd does.
   
   Both use 'Replace All'.
   
   None of these Search & Replaces have a space at the end.
   
   Find: ^p Replace (All): ^l Find (with wildcards) (note: the 1st character is a space
   - before the {18,):  {18,18}({7,8} {2,3}{5,6} {29,32})^l ({18,18}) {68,68} Replace (All): \2\1 ,,,
3. 3

   Step 3: From a blank document in Word

4. 4

   Step 4: paste the clipboard (Shift+Insert or Ctrl+V).

5. 5

   Step 5: Do the following Search & Replaces exactly.

6. 6

   Step 6: Copy entire contents and paste into a blank Excel spreadsheet.

7. 7

   Step 7: Convert Text to Columns (Data | Text to Columns...)

8. 8

   Step 8: then: Select Fixed Width

9. 9

   Step 9: Click Next button Set columns at 41 and 51

10. 10

    Step 10: Click Next button Optional: Set middle column to Date for data format

11. 11

    Step 11: Click Finish button

12. 12

    Step 12: You should now size columns

13. 13

    Step 13: and format to you liking.

Detailed Guide

About the Author