Skip to main content
Level 2
Nov 4, 2020 7:03 PM UTC
Solved

Batch upload of targetData into Additional Data tab in Seeds

Hello, I have a seed folder that I use for proofing dynamic content. We have multiple versions of "targetData" so I have a record in this folder for each version. I have no problem creating this folder via a list that I uploaded (which helps when there are more than just a few versions), but the problem I'm having is NOT being able to populate the "Additional data" tab (ie the targeting data) in batch mode. The data in this tab is in XML format so I'm trying to find a way to possibly do this via javascript? Hoping someone else has run into this and possibly has a solution. Thank you! Cindy

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
cmabruzzese0923Accepted solution
Level 2
Mar 23, 2022 3:04 PM UTC

Hello, 

 

Was there an example provided as I have the same issue to add seeds for a Direct Mail campaign that has over 20 additional fields. 

 


Hello - yes, we were able to get this to work. Using excel, I was able to create a csv containing the fields I needed (email, first name, label, internal name, and targetData) and load this csv into a LIST. I then used this list to populate a seed folder using Update Data activity. I could then use this seed folder for proofing.

 

The key is having the targetData field defined correctly. Example below.

 

<?xml version="1.0"?>

<seedMember>

<targetData smartFirstName="Cindy" smartFirstNameCaps="CINDY" />

</seedMember>

 

Thanks,

Cindy

 

10 replies

Jonathon_wodnicki
Community Advisor
Community Advisor
Nov 9, 2020 6:18 PM UTC

Hi,

 

The Additional data (targetData) field is XML, so can't be updated via Update activity and is harder to use in general.

Simple fix is modify the nms:seedMember schema to turn it into a real boy, i.e. <element name="targetData" xml="false"/> and continue as normal. May/may not blow up MTA.

More complicated fix is use js to set the mData col to wrapped xml from the file.

 

Thanks,

-Jon

 

 

 

Translate
Level 2
Nov 18, 2020 1:39 AM UTC
Hi Jon - have you done something like this before and perhaps have an example you could forward?
Translate
Sukrity_Wadhwa
Level 4
Nov 17, 2020 9:49 AM UTC

Hi @cmabruzzese0923,

Was the given solution helpful to resolve your query? Do let us know.

Thanks!

Translate
Sukrity Wadhwa
Level 2
Nov 18, 2020 1:18 AM UTC
Hi Sukrity ... I haven't been able to spend the time on testing js code yet ...
Translate