0

I am trying to set up a .bat script to zip specific files in a folder. The input to this script is the folder name.

My current .bat file looks like this.

REM Takes DATE as input param
if "%1"=="" (
  echo Provide DATE as an argument ex. 20230425
  exit /b 1
) else (
  set DATA_DATE=%1
  echo Accepted.
)

REM Zip all data
Compress-Archive .\data\%DATA_DATE%\p* -f test.zip

When I execute this script with .\collect_data.bat 20230504, it fails at the Compress-Archive line with the following error.

'Compress-Archive' is not recognized as an internal or external command,
operable program or batch file.

Weirdly when I remove the Compress-Archive line, and run the command in sequence it runs fine.

.\collect_data.bat 20230504; Compress-Archive .\data\20230504\p* -f test.zip

Does anyone how to make the Compress-Archive line run in the .bat file? Any thoughts/ideas would be appreciated?

Using PSVersion: 5.1.19041.2673

BoomBoxBoy
  • 1,770
  • 1
  • 5
  • 23
  • 1
    Does Compress-Archive work from PS? PS uses for path the environment variable PSModulePath, while cmd uses the environmental variable PATH. – jdweng May 09 '23 at 15:28
  • 1
    `cmd.exe` does not understand `Compress-Archive`.PowerShell does. Use PowerShell to run it. `powershell.exe -NoProfile -NoLogo -Command "Compress-Archive -Path .\data\%DATA_DATE%\p* -Force -DestinationPath test.zip"` – lit May 09 '23 at 15:31
  • 1
    `Compress-Archive` is PowerShell function => you can't call it from `cmd` (nor from a `.bat` script) directly. In a `.bat` file, use `PowerShell -command "& {Compress-Archive .\data\%DATA_DATE%\p* -f test.zip}"`… – JosefZ May 09 '23 at 15:32
  • Thank you all for the comments. These 2 solutions worked great. – BoomBoxBoy May 09 '23 at 15:35

1 Answers1

1

A .bat file does not work like PowerShell, PS scripts are followed by .ps1 extensions. To use PowerShell in your batch file you need call it with the command line :

powershell -Command "<#your command here#>"

And in your case :

powershell -Command "Compress-Archive .\data\%DATA_DATE%\p* -f test.zip"

PS : change the extension of your script to .cmd its newer than .bat and better (don't know all the reason but I'm sure it will prevent future problems)

Feel free to ask any other questions !

Thomas MONTIGNY
  • 132
  • 10