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

[Ssb_94]

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

[Ssb_94]

Folks, Any pointers please?

Regards,

Sri Bhargav

[Jonathon_wodnicki · Accepted solution]

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

[Jonathon_wodnicki]

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

[Ssb_94]

Thank you wodnicki! Will try in this way

Regards,

Sri Bhargav

[Ssb_94]

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

Regards,

Sri Bhargav

[Ssb_94]

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

[Jonathon_wodnicki]

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