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
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

How to write Delivery and Exclusion Logs to the same file?

Avatar

Level 7

Hello Folks,

I am writing Delivery Logs to a file and exporting to a server location using Data Extraction activity.

Order of workflow activities: Scheduler -> Query -> Data Extraction -> Alert -> End

File Name is: Email_Stats_2019-04-27 004523.csv

1. I want to include Exclusion Logs in the same file, but since both are different entities can someone please help me on how can i achieve this?.

2. Also, how do we write data to a same file using Extraction Activity without overriding already existing data? I had ran workflow and it exported a file with some data, next time if i ran it should add new data to the existing file, instead of overriding old data.

Quick help is appreciated!

Regards,

Sri Bhargav

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

Update your workflow, adding a fork, 2nd query and union:

Scheduler -> Fork -> Query, Query -> Union -> Data Extraction -> Alert -> End

Union just set to all shared columns, should work.

Thanks,

-Jon

View solution in original post

7 Replies

Avatar

Correct answer by
Community Advisor

Hi,

Update your workflow, adding a fork, 2nd query and union:

Scheduler -> Fork -> Query, Query -> Union -> Data Extraction -> Alert -> End

Union just set to all shared columns, should work.

Thanks,

-Jon

Avatar

Community Advisor

For append instead of overwrite: write to a different file, then use a js activity to append one to the other- command in linux would be execCommand('cat path_to_new_file >> path_to_old_file')

Avatar

Level 7

Thanks wodnicki ! if first approach works. Then i may not need this, but surely will try this way out too

Regards,

Sri Bhargav

Avatar

Level 7

Hi Wodnicki,

I am able to export both in a single file using Data Extraction activity and flow what you mentioned.

I am trying using JS too. But facing some challenges. Can i have some reference please

Regards,

Sri Bhargav

Avatar

Community Advisor

Hi,

That shell call's for linux; if you're under Windows without wsl, use 'type' instead of cat:

execCommand('type path_to_new_file >> path_to_old_file')

The paths are what was set in the extract activity, for path_to_new_file you can use vars.filename.

Thanks,

-Jon

The ultimate experience is back.

Join us in Vegas to build skills, learn from the world's top brands, and be inspired.

Register Now