Where to see data exported using Data Extraction/Export component of a workflow.lly | Community
Skip to main content
jyotiyadav3
jyotiyadav3
Level 2
February 11, 2016
Solved

Where to see data exported using Data Extraction/Export component of a workflow.lly

  • February 11, 2016
  • 5 replies
  • 7371 views

Hi,

I am creating a workflow, where I want to export a list of data. I have used Data Extraction component and the workflow ran successfully but I was not able to see any file being exported. May be, I am looking at wrong place. Can anyone help me where exactly I can find the exported file?

Thanks,

Jyoti

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by DonMaté

    Hi jyotiyadav3‌,

    In the Data Extracton (file) workflow object under the file name field you would have provided a file name (for example "<filename>.txt") and also setup the fields to be extracted using the "Edit the file format" link right under this.

    Now upon running this, the extraction is done directly to a dedicated folder on the server. The path to this for example on a windows server installation is "C:\Program Files (x86)\Adobe\Adobe Campaign v6\var\<instancename>\export". The quivalent on a Linux server would be "/usr/local/neolane/nl6/var/<instancename>/export".

    Example below:

    Workflow and settings in the Data Extraction (File)

    Folder on the server:

    5 replies

    DonMaté
    DonMatéAccepted solution
    Level 2
    February 22, 2016

    Hi jyotiyadav3‌,

    In the Data Extracton (file) workflow object under the file name field you would have provided a file name (for example "<filename>.txt") and also setup the fields to be extracted using the "Edit the file format" link right under this.

    Now upon running this, the extraction is done directly to a dedicated folder on the server. The path to this for example on a windows server installation is "C:\Program Files (x86)\Adobe\Adobe Campaign v6\var\<instancename>\export". The quivalent on a Linux server would be "/usr/local/neolane/nl6/var/<instancename>/export".

    Example below:

    Workflow and settings in the Data Extraction (File)

    Folder on the server:

      Linda_Stinson
      Adobe Employee
      Linda_StinsonAdobe Employee
      Adobe Employee
      March 4, 2016

      To add to what Donald stated, unlike the Data loading (file) activity, which can push a local file to the server, you don't have the option with Data extraction to download the file to your local machine. You would need to set up FTP or have direct access to the server.

      J
      jt_joma
      October 21, 2016

      Hi,

      I am trying to do something similar and send the exported data via an email (Delivery Template) using the calculated attachment option 'File name is computed during delivery of each message'.

      Would there be a way to programmatically get the path to this exported file so I can set it as an option using: setOption('myFIleAttachment', <path_to_file>)

      and then being able to retrieve it from the Delivery using <%@ include option='myFIleAttachment' %>

      I hate hard coding things. But this is what I have so far:

      vars.filename = '/usr/local/neolane/nl6/var/' + getOption('NmsTracking_Instance') + '/export/Data_Extract_' + formatDate(new Date(), "%4Y-%2M-%2D") + '.csv';

      setOption('myFIleAttachment', vars.filename);

      Thanks,

      Justin.

      S
      Senthil24
      Level 4
      May 24, 2017

      Hi Linda,

      Does it have to be a server ? What needs to be done if we do want to download it in our local machine?

      Thanks

      Senthil

      vraghav
      Adobe Employee
      vraghavAdobe Employee
      Adobe Employee
      May 24, 2017

      Hi Senthil,

      You will have to export it on the sFTP server. There is no direct way to export and download it on local machine.

      Regards,
      Vipul

        Terms & ConditionsAccessibility statement

        Loading footer...