Populate a personalisation field which is not available in the DB into email | Community
Skip to main content
B
binhr47192046
Level 2
July 26, 2017
Solved

Populate a personalisation field which is not available in the DB into email

  • July 26, 2017
  • 6 replies
  • 3282 views

Hi there,

I would like to populate a personalisation field (say account balance) into my email template. Unfortunately this account balance field is not available yet in the database (Recipients). Just checking is there a way to populate this account balance into the email template via the list instead of adding a new account balance field into database ?

Thanks and Regards,

    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 _nkur

    You need use a data loading (file) activity to load the data in your workflow transaction. Once it is in your workflow transaction data you can use tragetData to use in email for example below

    <%= targetData.firstName %>

    Hope it help, if you need help with Data loading file activity let me know.

    Regards,

    Ankur A.

    6 replies

    florentlb
    florentlb
    Level 10
    July 26, 2017

    Hi,

    Where is this information available today?

    • Is it possible to compute it using other fields already present in the database?
    • Is it available in an external file?

    Using workflows, you should be able to compute it and enrich the recipients data (without having the filed existing in the database). This field would then be available in the personalization fields of the delivery as a "target data". Here is an example: Synchronizing audiences

    Let me know if that could do.

    Florent

    B
    binhr47192046Author
    Level 2
    July 27, 2017

    Thanks for the answer Florent. the field is in an external file.

    Regards.

    _nkur
    _nkurAccepted solution
    Level 2
    July 27, 2017

    You need use a data loading (file) activity to load the data in your workflow transaction. Once it is in your workflow transaction data you can use tragetData to use in email for example below

    <%= targetData.firstName %>

    Hope it help, if you need help with Data loading file activity let me know.

    Regards,

    Ankur A.

    noogi1207
    noogi1207
    August 1, 2017

    In v6, in a workflow, using a regular delivery template that is set to default editing mode, I have never had issues personalizing data after an external data load and enrichment.

    However, when I switch the editing mode to DCE, I can only access data from my recipients tables, regardless of any enrichments. Is there a work-around for this?

    florentlb
    florentlb
    Level 10
    August 11, 2017

    Hi,

    This seems surprising, you should still be able to see a Target Data node containing the additional data. Can you share your server and console build numbers?

    Florent

    vraghav
    Adobe Employee
    vraghavAdobe Employee
    Adobe Employee
    August 11, 2017

    Hi,

    It is a known issue with the DCE. You will not be able to see the targetData section in the personalization helper menu.

    Workaround is to open the source tab of the editor, locate the point in HTML where you wish to add the targetData personalization and then use the same menu at top to now reach targetData personalization.

    Hope it helps.

    Regards,
    Vipul

      Terms & ConditionsAccessibility statement

      Loading footer...