export data in the form of a file using a workflow in adobe campaign V6

Avatar

Avatar

Senthil24

Avatar

Senthil24

Senthil24

23-05-2017

Hi,

There is a extract file activity in ACS which lets users export data from campaign to local machine in the form of csv or text  through  a workflow.

I have done the export of data from Adobe campaign directly but I wanted to know if there is a way to  automate this process using a workflow, so that the export can be taken in a timely fashion.

P.S: I am using a update list in my workflow and list is updated based on some segmentation/filtering criteria . After the update list I want to export the list data outside of campaign in a form of a file. 

 

Thanks

Senthil

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Vapsy

Employee

Avatar

Vapsy

Employee

Vapsy
Employee

23-05-2017

Hi Senthil,

After the update list, use a Read List activity to read its contents. 

Then feed the read list transition to Extract File activity to export the data in a CRV/TXT/XML format. Path for extraction can be defined for Campaign sFTP.

Regards,

Vipul

Answers (6)

Answers (6)

Avatar

Avatar

Vapsy

Employee

Avatar

Vapsy

Employee

Vapsy
Employee

25-05-2017

Hi Senthil,

If the instance is Adobe hosted sFTP path will be /sftp/<sftpUsername>/incoming/

There will not be a need for external account as sFTP folder are internally available to application server and while exporting the file you can give the path directly.

Regards,

Vipul

Avatar

Avatar

luellag75938743

Avatar

luellag75938743

luellag75938743

29-10-2019

It I want to store it on my local computer drive. what are the setting I should use under transfer file?

Avatar

Avatar

luellag75938743

Avatar

luellag75938743

luellag75938743

29-10-2019

trying to create a transfer file activity and used sftp as suggested. under the path  so I should write /sftp/<sftplisa@yahoo.com>/incoming/

Thanks username being email?

Avatar

Avatar

Senthil24

Avatar

Senthil24

Senthil24

25-05-2017

Vipul Raghav wrote...

Hi Senthil,

File is always extracted on server and automatic download to local machine is not possible out of the box.

Hence I suggested to extract the file on campaign sFTP server. 

You should be aware of the sFTP path of the instance. If not, if the instance is Adobe hosted, please contact Adobe support for exact path.

If the instance is hosted by you, ask the infrastructure admin for the path.

Regards,

Vipul

 

Thanks a  lot Vipul.

I have asked Adobe support for the setup of sftp server (that has to be done via external account configuration , I believe) and to share the path with me as well.

Regards

Senthil

Avatar

Avatar

Vapsy

Employee

Avatar

Vapsy

Employee

Vapsy
Employee

24-05-2017

Hi Senthil,

File is always extracted on server and automatic download to local machine is not possible out of the box.

Hence I suggested to extract the file on campaign sFTP server. 

You should be aware of the sFTP path of the instance. If not, if the instance is Adobe hosted, please contact Adobe support for exact path.

If the instance is hosted by you, ask the infrastructure admin for the path.

Regards,

Vipul

Avatar

Avatar

Senthil24

Avatar

Senthil24

Senthil24

24-05-2017

Vipul Raghav wrote...

Hi Senthil,

After the update list, use a Read List activity to read its contents. 

Then feed the read list transition to Extract File activity to export the data in a CRV/TXT/XML format. Path for extraction can be defined for Campaign sFTP.

Regards,

Vipul

 

Thanks for the help . pls enlighten us on setting up the Path for extraction in campaign. And for now,

If I don't want to send it to the server . Can I download the file in my local machine?