How to automate a csv file export from a work to my computer hard drive ? | Community
Skip to main content
A
Anonymous
June 4, 2020
Solved

How to automate a csv file export from a work to my computer hard drive ?

  • June 4, 2020
  • 4 replies
  • 6720 views

Hi all,

 

I would like to automate an export of a csv file generated from a workflow to a folder in my computer hard drive. I’ve already created the data loading activity and exported into my computer, however to avoid to export it manually every day I would like to automate that task,  I don’t how to set up the transfer file activity.

Can someone please explain me how to do it ?

is there’s another way to do this I am also open to suggestions.

 

thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by InMo

Hi @17379115,

You can use 'Data Extraction' activity to create and export files automatically on SFTP. If you don't have access to SFTP then there is one a way to access the exported file, which is to send it to yourself as an attachment of an email delivery(if file doesn't contain sensitive data). It is always better and best practice to have an SFTP access if you want to access files, and avoid accessing files over email.

 

Regards,

4 replies

Anita_punmiya
Anita_punmiya
Level 5
June 5, 2020

Hi @17379115 

 

Please refer this link for setting up automated exports of CSV files.

 

https://docs.adobe.com/content/help/en/campaign-classic/using/automating-with-workflows/event-activities/file-transfer.html

 

Regards,
Anita

 

 

A
Anonymous
June 5, 2020

Hi Anita,

thanks your answer. I know the steps how to do it manually. I’m looking to automate it but not via an sFTP but just to export it automatically into a folder in my computer hard drive. 
Regards

I
InMoAccepted solution
Level 3
June 5, 2020

Hi @17379115,

You can use 'Data Extraction' activity to create and export files automatically on SFTP. If you don't have access to SFTP then there is one a way to access the exported file, which is to send it to yourself as an attachment of an email delivery(if file doesn't contain sensitive data). It is always better and best practice to have an SFTP access if you want to access files, and avoid accessing files over email.

 

Regards,

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity Advisor
Community Advisor
June 5, 2020

Hello @17379115 ,

 

The only way i see is to add the Delivery after your data extraction activity. That way you will have the daily updated file pushed ton your emails.

 

There is no direct way to drop file on your Hard drive.

 

Thanks,

Manoj     Find me on LinkedIn
Targetmania
Targetmania
June 7, 2020

Hi Terry,

I understand that your files you want to load is big in size, otherwise you will be attached to your email.

 

Your question depends on your work environment.
It is more simple when you are 'on premise', your IT support and you control the environment.
If you are in cloud, you have to go through an SFTP

 

'on premise' basic solution, commonly your Adobe Campaign server can access to a shared directory.

 

The idea is to share and map your computer.

 

On your computer folder, where you see you hard drive.
On Windows :
You can right click and add network location.
You do the same on Adobe Campaign Server.

 

Then in Adobe Campaign workflow, you can add folder you want to deposit your files \\shareFolder\specificFolder

 

Best Regards,
Alexandre Planchot

A
Anonymous
June 16, 2020

Hi Alexandre,

 

Thanks for your explanation. I actually used to be able to export a file via a file loading activity by using a network drive starting with //

because I don’t have anymore network drives, I just wanted to know if I need to recreate one or if there’s a way to export the file a google drive ?

Terms & ConditionsAccessibility statement

Loading footer...