Upload CSV file into Adobe campaign Recipients

[ChanuteJo]

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

[LakshmiPravallika]

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.

[ChanuteJo]

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 · Accepted solution]

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.

[ChanuteJo]

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]

@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.

[ChanuteJo]

Got it to work now. Thankyou so much