I want to create a powershell script where the log files are compressed according to its filename date.

Question

1.00/5 (1 vote)

See more:

I have found a script in this group about compressing a file according to the file modification date. But what I am looking for is to compress log files which are in .jrn format and the file name is like this ABCD20200710.jrn. And the compression must be done after the 90 days of the log generation. I mean 90 days after the file is generated according to the filename date. Also, I am just trying the scripting thing not a well good user. Please guide me.

What I have tried:

#get the list of files in the original folder
$rootFolder = "C:\MyFiles\Output"
$tempVariable = $rootFolder
$files = Get-ChildItem -Path $rootFolder 

#create a temporary folder using today's date
$tempFolderRoot = "C:\Temp_"
$date = Get-Date
$date = $date.ToString("yyyy-MM-dd")
$tempFinalFolder = "$tempFolderRoot$date"
New-Item -ItemType directory -Path $tempFinalFolder -Force

#decide how long back to go
$timespan = new-timespan -days 7

#move the files to a temporary location
foreach($file in $files)
{
	$fileLastModifieddate = $file.LastWriteTime
	if(((Get-Date) - $fileLastModifiedDate) -gt $timespan)
	{
		Move-Item "$rootFolder\$file" -destination $tempFinalFolder
	}
}

$CompressionToUse = [System.IO.Compression.CompressionLevel]::Optimal
$IncludeBaseFolder = $false
$zipTo = "{0}\Archive_{1}.zip" -f $rootFolder,$date

#add the files in the temporary location to a zip folder
[Reflection.Assembly]::LoadWithPartialName( "System.IO.Compression.FileSystem" )
[System.IO.Compression.ZipFile]::CreateFromDirectory($tempFinalFolder, $ZipTo, $CompressionToUse, $IncludeBaseFolder)

#Remove-Item $tempFinalFolder -RECURSE

Posted 13-Jul-20 20:10pm

AVT007

Updated 13-Jul-20 23:47pm

Add a Solution

Comments

Garth J Lancaster 14-Jul-20 2:32am

the format of you journal file - "ABCD20200710.jrn" - is there ALWAYS only 4 characters (for example, the 'ABCD') before the date ?

AVT007 14-Jul-20 3:55am

Yes. Its just 4 characters. Its a log file of an ATM machine.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Garth J Lancaster · Answer 1 · 2020-07-13T23:47:00

ok, look at the bold bits - I've left in the original code, commented out with '#'.. NB, all untested, just off the top of my head

#decide how long back to go
#$timespan = new-timespan -days 7
$timespan = new-timespan -days 90

#move the files to a temporary location
foreach($file in $files)
{
	#$fileLastModifieddate = $file.LastWriteTime
    $filenameFromPath = [System.IO.Path]::GetFileName($file)
    $dateFromFilename = $filenameFromPath.Substring(4,8)
    $fileCreateDate = [datetime]::parseexact($dateFromFilename, 'yyyyMMdd', $null)
	#if(((Get-Date) - $fileLastModifiedDate) -gt $timespan)
    if(((Get-Date) - $fileCreateDate) -gt $timespan)
	{

The '#' code etc can be removed when it's working, and those sequences of mine can be combined to some extent, but it makes it easier to show the why && what if I express them long-form first