How to write Delivery and Exclusion Logs to the same file? | Adobe Higher Education
Skip to main content
S
SurabattulaSr
Level 6
April 27, 2019
Respondido

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

  • April 27, 2019
  • 7 respostas
  • 3684 Visualizações

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

    Este tópico foi fechado para respostas.
    Melhor resposta por Jonathon_wodnicki

    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

    7 Respostas

    S
    SurabattulaSrAutor
    Level 6
    April 29, 2019

    Folks, Any pointers please?

    Regards,

    Sri Bhargav

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorResposta
    Community Advisor
    April 29, 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

      Jonathon_wodnicki
      Community Advisor
      Jonathon_wodnickiCommunity Advisor
      Community Advisor
      April 29, 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')

        S
        SurabattulaSrAutor
        Level 6
        April 30, 2019

        Thank you wodnicki! Will try in this way

        Regards,

        Sri Bhargav

          S
          SurabattulaSrAutor
          Level 6
          April 30, 2019

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

          Regards,

          Sri Bhargav

            S
            SurabattulaSrAutor
            Level 6
            May 1, 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

            Jonathon_wodnicki
            Community Advisor
            Jonathon_wodnickiCommunity Advisor
            Community Advisor
            May 1, 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

            Termos e condiçõesAccessibility statement

            Loading footer...