Upload CSV file into Adobe campaign Recipients | Community
Skip to main content
C
ChanuteJo
Level 3
May 15, 2024
Solved

Upload CSV file into Adobe campaign Recipients

  • May 15, 2024
  • 2 replies
  • 1684 views

Hi,

 

I would like to load a CSV File into Adobe Campaign so that I have an updated Recipients lists. The Fields are as follows :Firstname, Lastname, Date Of Birth, Email. How do I upload the whole CSV file into Adobe Campaign Classic so that these CSV file can are available in Recipients. Any guidance or screenshot would be greatly appreciated.

best,
Sching

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 ParthaSarathy

Hi @chanutejo ,

In data loading activity > click here to change the file format and configure the date format for Date of birth field matching to your CSV file date format mm-dd-yy and run the workflow.

2 replies

LakshmiPravallika
Community Advisor
LakshmiPravallikaCommunity Advisor
Community Advisor
May 15, 2024

Hi @chanutejo ,

 

Sample WF for Data load from CSV File to recipients Schema in Adobe Classic Campaign can be configured as shown below:

 

 

 

The File Collector activity picks the file from SFTP Marketing Server and it can be stored in Archived folder and the next Data loading activity is used to load the data in the file to the Workflow Temp Table with the configured Data types in it. Next comes the Enrichment activity which is used to add additional fields if any required and not present in the file. Later Please use the Update Data activity to Insert/Update the data into the Recipients schema and it can be done based on Reconciliation keys.

 

Hope this helps.

 

Regards,

Pravallika.

    C
    ChanuteJoAuthor
    Level 3
    May 15, 2024

    Hi,

    Thankyou I have successfully updated CSV data and are able to add it into the Recipients. However, I have been unable to get the Date of Birth to be uploaded or displayed. Could you please guide into how I could resolve that? Here is my workflows and configurations.

    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity AdvisorAccepted solution
    Community Advisor
    May 15, 2024

    Hi @chanutejo ,

    In data loading activity > click here to change the file format and configure the date format for Date of birth field matching to your CSV file date format mm-dd-yy and run the workflow.

    ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    C
    ChanuteJoAuthor
    Level 3
    May 15, 2024

    Hi, 
    As I looked in the Recipients the formats are mm/dd/yyyy in which I have configured both in the CSV file and in the " click here to change the file format" and nothing is showing. I have included the screenshot as follows.

    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity Advisor
    Community Advisor
    May 15, 2024

    @chanutejo , In CSV file the format of DOB is mm-dd-yy, but you have defined date format as mm/dd/yyyy. So data loading activity was unable to identify it. Change the date format to mm-dd-yy in data loading activity and re run the workflow.

    ~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    Terms & ConditionsAccessibility statement

    Loading footer...