Level 4

Solved

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

Forum|Forum|8 years ago
May 24, 2017
7 replies
5007 views

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

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 vraghav

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

vraghav

Accepted solution

Adobe Employee

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

S

Senthil24Author

Level 4

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?

vraghav

Adobe Employee

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

S

Senthil24Author

Level 4

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

vraghav

Adobe Employee

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