Can anyone assist with converting this output logfile into a csv? (robocopy)

Question

This is the log file I would like to be converted to csv.

------------------------------------------------------------------------------

               Total    Copied   Skipped  Mismatch    FAILED    Extras
    Dirs :         4         2         4         0         0         0
   Files :        17        10        17         0         0         0
   Bytes :    20.0 k      5.0k    15.0 k         0         0         0
   Times :   0:00:00   0:00:00                       0:00:00   0:00:00
   Ended : Wednesday, May 19, 2021 10:12:44 AM

The csv file can have columns like: size, date, source and destination. I will attach the code I have to get the log above. Thank you for any help!

$path = "C:\Powershell\robocopylog.txt"
If(!(test-path $path))
{
      New-Item -ItemType file -Force -Path $path
}
$Logfile = "C:\Powershell\robocopylog.txt"
Clear-Content "C:\Powershell\robocopylog.txt" -Force
$EmailFrom = "email@company.com"
$EmailTo = "myemail@company.com"
$EmailBody = "Robocopy completed successfully. See attached log file for details"
$EmailSubject = "Robocopy Summary"

$files = @("data")


for($i = 0; $i -lt $files.Count; $i++){
    robocopy "c:\powershell\[$i])" "c:\transferdata\[$i])" /Z /e /xx /W:5 /MAXAGE:2 /NFL /NDL /NJH /nc /np /unilog+:$Logfile
}

Send-MailMessage -To $EmailTo -from $EmailFrom -Subject $EmailSubject -Body $EmailBody -attachment $Logfile -smtpserver 192.168.249.211 -Port 25

Answer 1

On closer inspection, the code bares uncanny similarity to the previous questions I and others have pointed out:

1. Convert a robocopy log into a csv file
2. send email with only one line of robocopy summary

Now that I see the similarity, my answer is almost the same:

$path = "C:\Powershell\robocopylog.txt"
If(!(test-path $path)) {
      New-Item -ItemType file -Force -Path $path
}

$CsvFile   = "C:\PowerShell\RoboCsv.txt"
$Logfile   = "C:\Powershell\robocopylog.txt"
$EmailBody = [Collections.ArrayList]@("completed successfully. See attached log file & below summary","")

$EmailParams = @{
    From       = "email@company.com"
    To         = "myemail@company.com"
    Subject    = "Robocopy Summary"
    SMTPServer = '192.168.249.211' 
    Port       = 25
}

Clear-Content "C:\Powershell\robocopylog.txt" -Force

$Files = @("data")

ForEach( $File in $Files)
{
    
    $Source = "C:\$File"
    $Dest   = "C:\NEW TEST\folder\folder\$File"
    
    $Log = robocopy $Source $Dest /Z /e /xx /W:5 /MAXAGE:2 /NFL /NDL /NJH /NC /NP /UniLog+:$Logfile /tee

    $Date = ( ( $log -match "^\s+Ended.+" ) -split ":", 2 )[1].Trim()
    $Line = ( $Log -match "^\s+Bytes.+" ) -split "\s+"
        
    $Copy = $Line[5]
    $Mult = $Line[4]

    $Line = "Bytes Copied: $Copy $Mult on $Date"

    [Void]$EmailBody.Add($Line)

    # For Csv output:
    [Void]$CsvData.Add(
        [PSCustomObject]@{
            SizeCopied  = "$Copy $Mult"
            Date        = $Date
            Source      = $Source
            Destination = $Dest
        } )
}

$EmailBody = $EmailBody -join "`r`n"

Send-MailMessage @EmailParams -Body $EmailBody -Attachment $Logfile

# Output to CSVFile
$CsvData | Export-Csv -Path $CsvFile -NoTypeInformation 

I added splatting of the email parameters, and I adjusted the CSV output to include the multiplier. However, this is very similar.

I'm not really sure what you want the email body to look like. I'd rather not re-explain this on top of my previous lengthy explanations, please study the other answers and their surrounding discussions for that:

1. https://stackoverflow.com/a/67337515/4749264
2. https://stackoverflow.com/a/67341934/4749264

I'll reiterate this does appear to be an incorrect use of Robocopy, but that is covered in those other discussions.