I have an instance where I save an Excel file into a folder with a long file path. I then use the "Zip/Unzip" activity to zip the Excel file and, while the operation is successful, the zip file name contains every single folder in the path which makes the name too long (the file doesn't open) and e…

You may have to share your automation job task definitions, because I cannot reproduce. Or should say, I created a quick 2=-step automation job that does a Select-to-File (from SQL Server to create an Excel File) and that file is fed to the next step which Zips the file with a simple name. See sna…

Hi I'm using zip tool too, but works fine, even with long paths... Is there any blanks in folder names ? Have you try to reach the receive folder from the button ? Have you try to quote the entire path ?

You can try to make it in two steps, start with archiving in a local short path, then use "move file" to put it in the right place...

In the "Select to File" activity, under the "Export to file" area, I have "\a\b\c#Excel_Report_Name#.xlsx" which is set automatically from the "Export options" window. Once I click on the "Export options" button, a new dialog window opens up and I'm asked for the "File Name and Path". I use the f…

Any ideas about why my setup above (using variable names for files) produces a long filename when it's zipped? Both, the zip file and the Excel file are created Ok with their normal name and placed correctly in the specified directory. It's only that the zip file contains the Excel file which now …

Hi Gary, I think you might be misunderstanding the issue (which I share), or maybe I am! If you open your "SimpleName.zip" in explorer, I think it will contain nested folders including "Shared Folders", "Dell host", "Gary_Data", and finally "Automates", and the ExportDimChannel.xlsx will be inside…

Ah, I see. I don't believe Quest exposes an option in Toad's Zip task to mask or eliminate the folder path of the zipped file. One alternative is to use your own zip utility, assuming there is an option to change/hide the folder path of the zipped file/s, and then call the zip utility via Toad's c…

Zip/Unzip activity produces file name too lenghty

Toad Data Point & Toad Intelligence Central

dan July 2, 2020, 8:51pm 9

Hi Jabs,
Have you tried checking Use relative paths in Automation settings?

Topic		Replies	Views
Toad Data Point 5.2.1.299 - Automation - ZIP File includes the entire folder structure Toad Data Point & Toad Intelligence Central	12	980	November 10, 2021
Automation zip unexpected behavior Toad Data Point & Toad Intelligence Central	3	789	April 1, 2020
Zip but no UnZip activity Toad Data Point & Toad Intelligence Central	4	1355	May 20, 2014
Automation - Zip Files Toad Data Point & Toad Intelligence Central	1	436	October 23, 2009
Creating a dynamic named zip file using Automation Designer Toad for Oracle & DevOps Toolkit	4	1160	January 30, 2014

Zip/Unzip activity produces file name too lenghty

Related topics