Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Export Data using Workflow

gnals12
Level 2
Level 2

Hi,

 

I want to set up a schedule job that queries table 'A' and send the result output to email address first.last@dummycompany.com as txt file or csv.

Is possible to do this kind of activity using workflow in ACC?

 

Thanks!

1 Accepted Solution
Manoj_Kumar_
Correct answer by
Community Advisor
Community Advisor

Hello @gnals12 

 

You can use the query activity to pull the data from Table A. Then use the data extraction activity to create a CSV file and finally, you can attach that exported file to delivery.

 

These two links will guide on how to do the data extraction and configure attachment for the delivery.

How to use data extraction activity: https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/action-acti...

 

Steps on how to attach a calculated file: https://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/sending-emails/attac...

 

 

View solution in original post

8 Replies
Manoj_Kumar_
Correct answer by
Community Advisor
Community Advisor

Hello @gnals12 

 

You can use the query activity to pull the data from Table A. Then use the data extraction activity to create a CSV file and finally, you can attach that exported file to delivery.

 

These two links will guide on how to do the data extraction and configure attachment for the delivery.

How to use data extraction activity: https://experienceleague.adobe.com/docs/campaign-classic/using/automating-with-workflows/action-acti...

 

Steps on how to attach a calculated file: https://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/sending-emails/attac...

 

 

View solution in original post

gnals12
Level 2
Level 2

Hi Manoj, I have couple questions. Can this be done in one workflow?  what action do I need to do it?

Thanks!

Manoj_Kumar_
Community Advisor
Community Advisor
Yes, you can use the scheduler activity to run the workflow on daily basis. Just add scheduler activity in the workflow and configure it to run according to your requirements then add query activity, data extraction and delivery activity
Manoj_Kumar_
Community Advisor
Community Advisor
Posted the steps in a different thread. Don't know how to post images in comments.
gnals12
Level 2
Level 2

gnals12_0-1620413901009.png

I am still struggling how to connect 'Data extraction' to 'Delivery'

 

I want to attach the file that was created in 'Data extraction' to the email delivery.

Manoj_Kumar_
Community Advisor
Community Advisor

Hello @gnals12 

 

Follow these steps to get the uploaded file URL: (double click on point 3)

_Manoj_Kumar_0-1620416000180.png

 

Once you have the file path Open the delivery and go to attachment and follow these steps: Click on the highlighted area

_Manoj_Kumar_1-1620416136117.png

 

Let me know if that helps

 

 

gnals12
Level 2
Level 2
Hi Manoj, Thanks for detail explanations! Unfortunately, I still have the error message in 'Delivery' action that says "The schema for recipients specified in the transition ('nms:broadLogRcp') is not compatible with the schema defined in the delivery template ('nms:recipient'). They should be identical."
Manoj_Kumar_
Community Advisor
Community Advisor
Open the delivery click on to and then select defined in the database and then select your profile from the recipients table.