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
Solved! Go to Solution.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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.
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.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
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.
Views
Replies
Total Likes
@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.
Views
Replies
Total Likes
Got it to work now. Thankyou so much
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies
Views
Likes
Replies