How Do You Create A Usable Sourcesafe Files Report?
• From VSS, navigate to the desired folder and run the files report (Tools | Files Report). Select ‘Recursive’ (only if you want all files from here down), ‘Include files’ and Report to: ‘Clipboard’. Click OK. • From a blank document in Word, paste the clipboard (Shift+Insert or Ctrl+V). • Do the following Search & Replaces exactly. 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}([ 0-9/]{7,8} {2,3}[0-9:ap]{5,6} {29,32})^l ([A-z.-_ ]{18,18}) {68,68} • Replace (All): • \2\1 • Copy entire contents and paste into a blank Excel spreadsheet. • Convert Text to Columns (Data | Text to Columns…), then: • Select Fixed Width, Click Next button • Set columns at 41 and 51, Click Next button • Optional: Set middle column to Date for data format, Click Finish button You should now size columns
