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

SriBhargav94-go

27-04-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

wodnicki

MVP

29-04-2019

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

Answers (6)

Answers (6)

wodnicki

MVP

29-04-2019

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')

wodnicki

MVP

01-05-2019

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

SriBhargav94-go

30-04-2019

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