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

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

Ssb_94
Level 5
Level 5

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
wodnicki
Correct answer by
Community Advisor
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
Ssb_94
Level 5
Level 5

Folks, Any pointers please?

Regards,

Sri Bhargav

wodnicki
Correct answer by
Community Advisor
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

wodnicki
Community Advisor
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')

Ssb_94
Level 5
Level 5

Thank you wodnicki! Will try in this way

Regards,

Sri Bhargav

Ssb_94
Level 5
Level 5

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
Level 5
Level 5

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

wodnicki
Community Advisor
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