Can you download a csv file on to my computer directly rather then through a SFTP?

[TakL]

Hi all,

would very much appreciate some help.

I am trying to extract out a table from my workflow and would ideally have it saved into a location in my computer such as Desktop etc.

is there any way we can do this? currently I currently using a SFTP and have to manually transferring (Filezilla).

I am trying to get an automated extraction of the csv file.

Tak

[david--garcia]

I don't think you can automate a file transfer from ACC to your local Desktop (given that your ACC instance is on some remote server and doesnt have the rights to access your machine), you can definately create a CRON job to automate file transfer with SFTP using a scripting language such as powershell/bash/cmd/shell (the script would have to connect then check if there is a file matching your pattern and then perform the file transfer.)

[David_Loyd · Accepted solution]

If your segmentation is pretty basic you can just go to the data tab on your data schema, do your filter there, then right click-> export. That will drop the data right onto your desktop. Data schema's can be found in Administration->Configuration->Data Schema

In a workflow you can also right click on the blinking blue line click display the target-> then right click in the data and click export. Do look at the bottom right corner where it tells you the count. Make sure you are viewing all your data. By default it just shows you the very first 200 rows.

Unless you are localhosting ACC, the ACC server will never see your desktop as an option to place files. It will always go through the SFTP. Look into the WGET option along with CRON jobs. https://www.howtoforge.com/using-wget-with-ftp-to-download-move-web-sites-recursively

[Sukrity_Wadhwa]

Hi @TakL,

Were you able to resolve this query with the help of any of the given solutions or do you still need more help here? Do let us know.
Thanks!