Zip files from 1 folder and archive daily?

jeffgman · 2015-11-10T20:17:19.000Z

Thanks to Zach I can successfully zip files from multiple folders and archive daily with datestamp. I now tried to modify the code to zip files for only 1 folder and archive by using a datestamp. In theory this should be much simpler to accomplish, but I came to the conclusion I don’t know what I’m doing. lol

Help please?

edwineekelaers2 · 2015-11-10T21:24:33.000Z

Who’s Zach? Left the Magic 8bal at work so need a bit more info. In what’s the code written?

jeffgman · 2015-11-10T21:34:28.000Z

This thread shows the code I used for zipping multiple folders. I want to perform the same action for just 1 folder now.

Zip files from multiple folders daily? Programming & Development

Hi all, Can someone please help with a script which zip the contents (txt files) of multiple folders on a daily basis? Zip file name should be the current date/timestamp and all zip files reside in 1 archive folder? Or if you can recommend an application that handles this? Thanks!

zalittle · 2015-11-10T22:19:52.000Z

jeffgman:

Thanks to Zach I can successfully zip files from multiple folders and archive daily with datestamp. I now tried to modify the code to zip files for only 1 folder and archive by using a datestamp. In theory this should be much simpler to accomplish, but I came to the conclusion I don’t know what I’m doing. lol

Help please?

Couple things,

First, i’d check out the community guidelines and be sure that you are familiar with what the SpiceWorks community expects of its members.

Second, check out this thread, Asking Better Questions , it’ll help you get more direct answers, and spend less time explain, re-explaining, etc.

Last, can you show everyone the code that you have and tell us what you’ve tried (changed from the original) to accomplish your task? It is not clear what you want, looking at the original code, your question can mean 2 different things that I see. It could mean always archive 1 static folder located in a specific place, or it could mean archiving only the top level folders in a specific directory.

Note for the thread

The code he is talking about is written for AutoHotKey a scripting software.

jeffgman · 2015-11-11T13:12:37.000Z

My goal is to always archive 1 static folder located in a specific place. I have messed around with the code a bit and this is what I have now… which still doesn’t work.

#NoEnv  ; Recommended for performance and compatibility with future AutoHotkey releases.
; #Warn  ; Enable warnings to assist with detecting common errors.
SendMode Input  ; Recommended for new scripts due to its superior speed and reliability.
;SetWorkingDir %A_ScriptDir%  ; Ensures a consistent starting directory.
;Created By: Zach Little
;11/5/15
;Please see https://community.spiceworks.com/topic/1276602-zip-files-from-multiple-folders-daily?page=1#entry-5201072 for details information about the creation of this script
;Please leave the above lines in for credit

;Link to standalone 7zip:		http://www.7-zip.org/a/7z1510-extra.7z
;The only file in here that you need is 7za.exe, place this somewhere you know where it is.
;Modify the below line to the location of the downloaded 7za.exe file.
PathToEXE = C:\Program Files\7-Zip\7za.exe

;Location of Final Archive
FinalArchive = C:\temp2\%A_MM%-%A_DD%-%A_YYYY% %A_Hour%%A_Min%.zip

;Modify below to set the location of the folders to archive. These do not have to be on your desktop, I just used that for testing. You can replace %A_Desktop% with a network path such as '\\server1\directroy' or something like 'C:\directory\whatever'
;To Add more follow the format Below
;VARNAME = FOLDERLOCATION\FOLDER
Archive1 = C:\toplevel\process\subfolder1
;Archive2 = C:\toplevel\process\subfolder2
;Archive3 = %A_Desktop%\Folder3
;Archive4 = %A_Desktop%\Folder4

ZIP()
EXITAPP
return

ZIP()
{
;If you add more folders above, please be sure to add the 2 template lines below and update the VARNAME to what you listed above! Be sure to remove the ; at the begininning of your new lines.
;RunWait %PathToExe% a %FinalAchive% %VARNAME%
;Sleep 5000
Run %PathToExe% a %FinalArchive% %Archive1%
;Sleep 5000
;RunWait %PathToExe% a %FinalArchive% %Archive2%
;Sleep 5000
;RunWait %PathToExe% a %FinalArchive% %Archive3%
;Sleep 5000
;RunWait %PathToExe% a %FinalArchive% %Archive4%
}

zalittle · 2015-11-11T13:51:39.000Z

jeffgman:

My goal is to always archive 1 static folder located in a specific place. I have messed around with the code a bit and this is what I have now… which still doesn’t work.

#NoEnv  ; Recommended for performance and compatibility with future AutoHotkey releases.
; #Warn  ; Enable warnings to assist with detecting common errors.
SendMode Input  ; Recommended for new scripts due to its superior speed and reliability.
;SetWorkingDir %A_ScriptDir%  ; Ensures a consistent starting directory.
;Created By: Zach Little
;11/5/15
;Please see https://community.spiceworks.com/topic/1276602-zip-files-from-multiple-folders-daily?page=1#entry-5201072 for details information about the creation of this script
;Please leave the above lines in for credit

;Link to standalone 7zip:		http://www.7-zip.org/a/7z1510-extra.7z
;The only file in here that you need is 7za.exe, place this somewhere you know where it is.
;Modify the below line to the location of the downloaded 7za.exe file.
PathToEXE = C:\Program Files\7-Zip\7za.exe

;Location of Final Archive
FinalArchive = C:\temp2\%A_MM%-%A_DD%-%A_YYYY% %A_Hour%%A_Min%.zip

;Modify below to set the location of the folders to archive. These do not have to be on your desktop, I just used that for testing. You can replace %A_Desktop% with a network path such as '\\server1\directroy' or something like 'C:\directory\whatever'
;To Add more follow the format Below
;VARNAME = FOLDERLOCATION\FOLDER
Archive1 = C:\toplevel\process\subfolder1
;Archive2 = C:\toplevel\process\subfolder2
;Archive3 = %A_Desktop%\Folder3
;Archive4 = %A_Desktop%\Folder4

ZIP()
EXITAPP
return

ZIP()
{
;If you add more folders above, please be sure to add the 2 template lines below and update the VARNAME to what you listed above! Be sure to remove the ; at the begininning of your new lines.
;RunWait %PathToExe% a %FinalAchive% %VARNAME%
;Sleep 5000
Run %PathToExe% a %FinalArchive% %Archive1%
;Sleep 5000
;RunWait %PathToExe% a %FinalArchive% %Archive2%
;Sleep 5000
;RunWait %PathToExe% a %FinalArchive% %Archive3%
;Sleep 5000
;RunWait %PathToExe% a %FinalArchive% %Archive4%
}

The only error I am getting is in the

Run %PathToEXE% a %FinalArchive% %Archive1%

If I change

PathToEXE = C:\Program Files\7-Zip\7za.exe

To

PathToEXE = C:\Program Files\7-Zip

And then change the run to say

Run %PathToEXE%\7za.exe

It works. Give that a try.

Edit
Had double slashes in the code.

jeffgman · 2015-11-11T14:13:17.000Z

When I make the code change I get the following error:

zalittle · 2015-11-11T14:16:47.000Z

On line 36 you didn’t specify your archive or what it is archiving, sorry I wasn’t clear in the last post, i was just modifying the beginning of the run command, not the entire line.

Line 36 should read

Run, %PathToEXE%\7za.exe a %FinalArchive% %Archive1%

jeffgman · 2015-11-11T14:28:51.000Z

That makes sense. But I’m still getting an error. I wasn’t sure if the comma after “Run” was ok, but it errors with or without it. It is the correct path to 7zip.

davidr4 · 2015-11-11T14:30:47.000Z

I’m not sure what AutoHotKey is, but this can be down with a 10 line powershell command

$folder = "C:\folder\folder";  # variable for the folder that gets zipped
$zip = "C:\folder\folder.zip";  #Path to ZIP file

If (Test-Path -Path $Zip)
{
Remove-Item $zip;  #deletes previous version of zip
}

Add-Type -Assembly "System.IO.Compression.FileSystem" ;
[System.IO.Compression.ZipFile]::CreateFromDirectory($folder, $zip) ;

zalittle · 2015-11-11T14:31:02.000Z

Try changing it to:

Run, C:\Program Files\7-zip\7za.exe a %FinalArchive% %Archive1%

jeffgman · 2015-11-11T14:45:56.000Z

Thanks davidr4. I started using Auto Hot Key with a another script so I’d like to be consistent.

Zach - I didn’t get an error this time, but no output file. So, I decided to remove all variables and put the direct path and it does work. However, file extension is “.7z” unlike the original script you wrote for zipping multiple folders which have “.zip” file extension. I specified .zip in the code. What do you think?

Run, C:\Program Files\7-zip\7za.exe a C:\temp2\%A_MM%-%A_DD%-%A_YYYY% %A_Hour%%A_Min%.zip C:\toplevel\process\subfolder1

zalittle · 2015-11-11T14:48:43.000Z

Run, C:\Program Files\7-zip\7za.exe a "C:\temp2\%A_MM%-%A_DD%-%A_YYYY% %A_Hour%%A_Min%.zip" "C:\toplevel\process\subfolder1"

See if that works, just put "s in to hopefully alleviate an issue that may be occuring because of the space in the path.

jeffgman · 2015-11-11T14:54:59.000Z

That did the trick. Thank you!

edwineekelaers2 · 2015-11-12T08:47:21.000Z

Use the powershell Luke … Oh no OP’s not Luke… Still . Go for powershell as powershell 5 seems to have some built in cmndlets to archive files

Read here

jeffgman · 2015-11-13T13:49:21.000Z

I actually changed the AutoHotKey script and it works perfectly. See below.

#NoEnv  ; Recommended for performance and compatibility with future AutoHotkey releases.
; #Warn  ; Enable warnings to assist with detecting common errors.
SendMode Input  ; Recommended for new scripts due to its superior speed and reliability.
;SetWorkingDir %A_ScriptDir%  ; Ensures a consistent starting directory.
;Originally created By: Zach Little. Has since been modified.
;11/5/15
;Please see https://community.spiceworks.com/topic/1276602-zip-files-from-multiple-folders-daily?page=1#entry-5201072 for details information about the creation of this script
;Please leave the above lines in for credit
;Link to standalone 7zip:		http://www.7-zip.org/a/7z1510-extra.7z
;The only file in here that you need is 7za.exe, place this somewhere you know where it is.
;Modify the below line to the location of the downloaded 7za.exe file.
PathToEXE = C:\Program Files\7-Zip\7za.exe
ZIP()
EXITAPP
return
ZIP()
{
;Source folder of files to zip
SourcePath = C:\TEST\OUTBOUND\ARCHIVE\
;Zip file name prefix
ZipPrefix = Prefix1
;Zip file location
ZipPath = C:\TEST\OUTBOUND\ARCHIVE\ZIP
{
;Rename file extension
FileMove, %SourcePath%\*.*, %SourcePath%\*.bak
;Add files with new extension to source folder
Loop, Files, %SourcePath%\*.bak,df
{
Run C:\Program Files\7-Zip\7za.exe a "%ZipPath%\%ZipPrefix%_%A_YYYY%%A_MM%%A_DD%_%A_Hour%%A_Min%.zip" %A_LoopFileLongPath%,,hide
process, wait, 7za.exe ; Make sure it's running first
process, waitclose, 7za.exe ; wait's for 7za.exe to close first instead of RunWait checking for 7za.exe to close
filedelete, %A_LoopFileLongPath%
}
}
}
F4::
ExitApp
Return

edwineekelaers2 · 2015-11-13T17:49:48.000Z

if the OP runs Powershell 5 then he can use a powershell cmndlet to zip files. It’s called compress-archive