.csv file to .zip file format conversion | Community
Skip to main content
AnkitaV3131
Level 2
May 3, 2024
Solved

.csv file to .zip file format conversion

Hello Team,

 

 

I'm looking to convert a single .csv file into a .zip format and then transfer it to SFTP. Could you please assist me with this?

 

 

Thank you.

 

 

Regards, Ankita Vishe

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
LakshmiPravallika
LakshmiPravallikaAccepted solution
New Participant
May 3, 2024

Hi @ankitav3131 ,

 

You can use the below Command to convert .csv file generated using Data Extraction activity to .zip file

 

Please run this command using Java script activity.

 

execCommand('zip -r -j '+vars.directorypathZipFileIsPlaced+' '+vars.filename+'');

 

Here vars.filename refers to the .CSV File generated.

 

Regards,

Pravallika.

 

View reply

9 replies

Sukrity_Wadhwa
Sukrity_Wadhwa
Employee
May 16, 2024

Hi @ankitav3131,

Were you able to resolve this query with the help of the given solutions or do you still need more help here? Do let us know. In case the given solutions were helpful, then kindly choose the one that helped you the most as the 'Correct Reply'.
Thanks!

Translate
Sukrity Wadhwa
Tanmoy7
New Participant
May 16, 2024

I have generated one .csv file and now trying to convert it to zip file and I am using the below script for that but it is giving error (BAS-010076 Cannot execute command 'zip -r -j \\12.34.56\\ABC\test.zip \\12.34.56\\ABC\test.csv' (err=2, the system cannot find the file specified.) . Can anyone help with this?

vars.filename = "\\\\12.34.56\\ABC\\test.csv";[This is the file I already generated through data extraction activity]
vars.directorypathZipFileIsPlaced = "\\\\12.34.56\\ABC\\test.zip";

execCommand('zip -r -j '+vars.directorypathZipFileIsPlaced+' '+vars.filename+'');

I tried with vars.filename = "test.csv"; as well but it didn't work.

Translate
Sukrity_Wadhwa
Sukrity_Wadhwa
Employee
May 23, 2024

Hi @akshayanand & @lakshmipravallika, 
Can you help @tanmoy7 further with this query or shall this be reported to internal SME's? Do let me know.

Thanks!

Translate
Sukrity Wadhwa
LakshmiPravallika
LakshmiPravallikaAccepted solution
New Participant
May 3, 2024

Hi @ankitav3131 ,

 

You can use the below Command to convert .csv file generated using Data Extraction activity to .zip file

 

Please run this command using Java script activity.

 

execCommand('zip -r -j '+vars.directorypathZipFileIsPlaced+' '+vars.filename+'');

 

Here vars.filename refers to the .CSV File generated.

 

Regards,

Pravallika.

 

Translate
    AnkitaV3131Author
    Level 2
    May 7, 2024

    Hi Pravallika,

    Thanks for your response!!

    Can you just help me with the "vars.directorypathZipFileIsPlaced". What will be the value for this or what will in place of this?

    Regards,
    Ankita Vishe

    Translate
    AkshayAnand
    AkshayAnand
    New Participant
    May 7, 2024

    Hi @ankitav3131 

     

    As Lakshmi has mentioned, "vars.directorypathZipFileIsPlaced" is the directory path where you want to create/place the zipped file created from the .CSV file.

     

    For reference, please see the following link.

     

    Regards

    Akshay

    Translate
      Terms & ConditionsAccessibility statement

      Loading footer...