How to read a flat file and extract a flat file using Adobe campaign tool | Community
Skip to main content
B
Bhaskar_Reddy_B
August 7, 2015
Solved

How to read a flat file and extract a flat file using Adobe campaign tool

  • August 7, 2015
  • 2 replies
  • 2616 views

Hi ,

I am new to Adobe and was googling to learn more about this tool but was not successful so reaching out to community.

I have a requirement for my client where in we have to load ~30 different inbound flat files to Adobe and extract 10 different outbound flat files using Neolane Adobe campaign tool.

Can you please guide me on how to achieve this.

Thanks,

Bhaskar

    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 Linda_Stinson

    Hi Bhaskar,

      We teach an Administration training course that includes a lesson on uploading files. The general approach is to:

    FTP files to/from the application server.

    Use a File collector to monitor the directory containing the files.

    Use a Data loading (file) activity to read the file and format/map data values as needed. For more complex data transformations, use an Enrichment activity.

    You can also use the Enrichment to reconcile and pull in a targeting dimension if the file refers to records that already exist in Adobe Campaign.

    Deduplicate as necessary.

    Data update activity is used to insert/update records.

    For the reverse process, use a Query to pull the data of interest and use a Data extraction (file) activity to write it to a file on the server.

    Again you will need to rely on FTP to transfer the file.

    Linda

    2 replies

    Linda_Stinson
    Adobe Employee
    Linda_StinsonAdobe EmployeeAccepted solution
    Adobe Employee
    August 8, 2015

    Hi Bhaskar,

      We teach an Administration training course that includes a lesson on uploading files. The general approach is to:

    FTP files to/from the application server.

    Use a File collector to monitor the directory containing the files.

    Use a Data loading (file) activity to read the file and format/map data values as needed. For more complex data transformations, use an Enrichment activity.

    You can also use the Enrichment to reconcile and pull in a targeting dimension if the file refers to records that already exist in Adobe Campaign.

    Deduplicate as necessary.

    Data update activity is used to insert/update records.

    For the reverse process, use a Query to pull the data of interest and use a Data extraction (file) activity to write it to a file on the server.

    Again you will need to rely on FTP to transfer the file.

    Linda

      Linda_Stinson
      Adobe Employee
      Linda_StinsonAdobe Employee
      Adobe Employee
      August 8, 2015

      All of the above takes place inside of a technical workflow - which is nothing more than a workflow outside of a Campaign.

      Once you have it working, you can schedule execution in the workflow itself or post an event to the workflow (Using a External signal activity to receive the event) to initiate processing.

      Terms & ConditionsAccessibility statement

      Loading footer...