Attach file to approval email or provide a link to do...

[DimaKudryavtsev]

Hi

I have a bit of an unusual request.

We need to perform a manual step in some of our campaigns. AC will select the list of the customers, then this list has to be given to an operator and workflow should be paused until the operation is completed.

I was planning Export the list as a file using Export activity and then attach the list to Approval activity and send the file. However, it seems that Approval activity does not have that option. I tested multiple ways to do it, none of them works. Even if I manage to transfer the file name to the activity, it cannot be attached because the process will actually happen on the mid-sourcing server and the file is exported on our marketing instance.

Next, I attempted to provide a link to download the file. I used xtk:fileRes to generate the resource, but it did not work either. It seems that xtk:fileRes can only generate image resource and does not work with CSV.

What other option do I have? Is there any way to generate a link to download the CSV file from marketing instance?

Thanks 

Dima

[_Manoj_Kumar_]

Hello @DimaKudryavtsev,

Here is a workaround to achieve the same thing.

Add a delivery activity before the approval step and attach the file in the delivery. This delivery will be sent to the same operator and then you can add the approval step to hold your workflow until it is approved or declined.

Thanks,

Manoj

[DimaKudryavtsev]

I want to avoid sending two deliveries if possible. There going to be multiple workflows like that and having two deliveries can become very messi.

[DimaKudryavtsev]

I'm thinking to create my own web app to handle this use case.

[isahore · Accepted solution]

Hi @DimaKudryavtsev,

Of course you can add an attachment to your approval activities in your workflows.

Just create a new technical delivery template, this time with a calculated attachment, pointing to the file which is generated so it can be attached in there.

If you are using a "data extraction" activity to generate the file, then by default the file is located in the "export/" directory on your sever. So in the attachment section of your delivery template, you can specify it like this:

You can then use this template in your approval activity.

Let me know if that helps.

Regards,

Ishan

[Sukrity_Wadhwa]

Hi @DimaKudryavtsev,

Were you able to resolve this query with any of the given solutions? Do let us know.

Thanks!

[DimitrisChatzos]

Hello,

This approach is not working as Adobe gives the below error.

[isahore]

Hi @DimitrisChatzos,

From the error I can see that you are executing your deliveries through a mid-sourcing server.

To attach files to a mid-sourcing delivery in Adobe Campaign, you need to configure an external account with FTP access, create a workflow with a "File Transfer" activity, and then within your delivery activity, use a script to reference the file in the email attachments section (similar to the solution provided), essentially treating the file as a dynamic attachment sourced from the external server.

Ensure your mid-sourcing server is properly configured to handle file transfers and access the external FTP server.

Hope that helps.

BR,

Ishan