Dhruva Mishra · Jul 15, 2022 go to post

I found that we are on Window and that is the reason above given command is not working for me. can you help, how can we convert this into windows executable command?

Dhruva Mishra · Jul 15, 2022 go to post

Hi Guys,
In the existing solution, following command is written for Unix/Linux.
set cmd ="cd "_fileDirectory_" && find . -type f | xargs zip .."_ext_xlsxFile
But I found that our cache is installed on Windows machine.

Can anyone help to convert this command to work in window executable form ?

Dhruva Mishra · Jul 15, 2022 go to post

Yes, I have tried $ZF(-1 with other commands like mkdir and dir. It is working as expected and actions are done. So I think, we don't have issue with $ZF(-1).
But This might be a catch, I am not sure whether Xargs and Zip are installed or not. Currently we are using Unix/Aix machine, Could you please let me know how to install Xargs and Zip?

Dhruva Mishra · Jul 15, 2022 go to post

No, $ZF(-1) is returning 1 which is unsuccessful for following line.  
set cmd ="cd "_fileDirectory_" && find . -type f | xargs zip .."_ext_xlsxFile
Is there any other way for doing the same what this command is doing?

Dhruva Mishra · Jul 15, 2022 go to post

Actually  I have executed this only the cache prompt and do not have facility to access linux/unix directly. but I executed this command separately with $ZF(-1,cmd), there also it is not executing successfully and returning 1.  

Dhruva Mishra · Jul 14, 2022 go to post

Hi Guys,

I have been trying this solution and it is working fine till the Sheet creation in the temporary folder.

But when we convert file Xlsx file with following command executing with $ZF(-1,cmd), it's not creating Xlsx file.
set cmd ="cd "_fileDirectory_" && find . -type f | xargs zip .."_ext_xlsxFile
could you please advise?

Thanks