Rename Files based on rolling files present.

All replies

• 

  

  0

  Sign in to vote

  Please read this first: This forum is for scripting questions rather than script requests

  ---

  \_(ツ)_/

  Monday, May 29, 2017 7:17 PM
• 

  

  0

  Sign in to vote

  I suggest to try KrojamSoft BatchRename

  Tuesday, May 30, 2017 12:20 AM
• 

  

  0

  Sign in to vote

  Hi,

  Pre-written scripts could be found here:

  https://gallery.technet.microsoft.com/site/search?query=rename%20files&f%5B0%5D.Value=rename%20files&f%5B0%5D.Type=SearchText&ac=5

  Best regards,

  Andy

  ---

  Please remember to mark the replies as answers if they help.
  If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

  • Proposed as answer by Hello_2018 Monday, June 5, 2017 3:02 AM

  Tuesday, May 30, 2017 2:27 AM
• 

  

  0

  Sign in to vote

  Hey JRV I am new to PowerShell and was null about the proper portal to ask my question.
  

  My bad for inconvenience.

  Sunday, July 2, 2017 8:41 AM
• 

  

  0

  Sign in to vote

  So after trying in bits and pieces here is what I came up with. Please suggest optimization if required.

  
  

  ##Reading server paths from a file
  $filePaths = $var = Get-Content -Path '\\Server1\E$\RollingAudFile\Paths.txt'
  ##File pattern trying to look for
  $fileName = 'File234.deg'
  $items = @()
  $num
  ##log file
  $Logfile = "\\Server1\E$\RollingAudFile\Logs\RollingAudFile.log"
  
  ##Function to write application log
  Function LogWrite
  {
     Param ([string]$logstring)
     $Level = 'INFO'
     $Stamp = (Get-Date).toString("yyyy-MM-dd HH:mm:ss:fff")
  
     $Line = "$Stamp $Level $logstring"
  
     Add-content $Logfile -value $Line
  }
  ##Criteria for file renaming
  function Find-Date
  {
  Param ([string]$firstLine)
  
  $var = $firstLine.Substring(0,22)
  $var1 = $var.Replace("'", "")
  $date = $var1.Replace(",", " ")
  
      LogWrite "Oldest entry is from $date"
  
  return $date
  }
  ##String to Date conversion method
  function Convert-StringToDateTime
  {
      param
      (
  [Parameter(Mandatory = $true)]
          [String] $DateTimeStr
      )
  
  $DateTimeParts = $DateTimeStr -split ' '
  
  $DateParts = $DateTimeParts[0] -split '/|-|\.'
  
  $DateFormatParts = (Get-Culture).DateTimeFormat.ShortDatePattern -split '/|-|\.'
          $Month_Index = ($DateFormatParts | Select-String -Pattern 'M').LineNumber - 1
          $Day_Index = ($DateFormatParts | Select-String -Pattern 'd').LineNumber - 1
          $Year_Index = ($DateFormatParts | Select-String -Pattern 'y').LineNumber - 1
  
  $TimeParts = $DateTimeParts[1..$($DateTimeParts.Count - 1)]
  
  if (@($TimeParts).Count -eq 2)
  {
  $TimeFormatParts = (Get-Culture).DateTimeFormat.ShortTimePattern -split ' '
  
  $TT_Index = ($TimeFormatParts | Select-String -Pattern 't').LineNumber - 1
  $Time_Index = 1 - $TT_Index
  
  $Time = $TimeParts[$Time_Index,$TT_Index] -join ' '
  }
  else
  {
  $Time = $TimeParts
  }
  
  $DateTime = [DateTime] $($($DateParts[$Month_Index,$Day_Index,$Year_Index] -join '/') + ' ' + $Time)
  
      $curDate = Get-Date
      $TimeSpan =  $curDate - $DateTime
      $daysNum = $TimeSpan.TotalDays;
  
  return $daysNum
  }
  
  try
  {
  $(foreach($filePath in $filePaths)
  {
  $files = @()
                  LogWrite "Checking *.deg* file at $filePath"
  $items = Get-ChildItem $filePath
  
  $(foreach($item in $items)
  {
  $(if($item.Name -match $fileName)
  {
  $files += $item
  })            
  })
  $num = $files.Length
                  LogWrite "Total no of valid *.deg* files at $filePath are $num"
  $num--
  
  if((($files[0]).length -lt 1mb) -and (($files[0]).length -gt 0kb)) 
  {
  $file = $filePath + $files[0].Name
                          LogWrite "Size of $file is less than 1MB"
  $var = Get-Content -Path $file | Select-Object -First 1
  
  $date = Find-Date $var
  
  $daysNum = Convert-StringToDateTime $date
  
  if($daysNum -gt 14) 
  {
                                  LogWrite "PerfDeg file is $daysNum days old, Rolling of file is needed."
  $(if($num -lt 10)
  {
  rename-item -path $filePath\File234.deg -newname File234.deg0$num
  }
  else
  {
  rename-item -path $filePath\File234.deg -newname $fileName$num
  })
  New-Item $filePath\File234.deg -ItemType file
  
                  LogWrite 'Rolling file Completed'
              }
              else {LogWrite "PerfDeg file is $daysNum days old, Rolling of file is not needed."}
          }
          else {LogWrite "$files[0] file size is either empty file or more than 1MB so this is not a candidate."}
  })
  }
  Catch
  {
      $ErrorMessage = $_.Exception.Message
      $FailedItem = $_.Exception.ItemName
      LogWrite "Error at $FailedItem. The error message:  $ErrorMessage"
      Break
  }

                          
  

  • Edited by AASHU29 Sunday, July 2, 2017 9:06 AM

  Sunday, July 2, 2017 9:05 AM