Hi,Use a Data loading (file) activity in a workflow, then set the delivery to use External file target mapping.Alternatively, split and dedupe the file itself using csvkit or similar.Thanks,-Jon

Hi,Sessions are tracked in xtksessioninfo.Thanks,-Jon

Hi,If the images there are checkboxes, it's just set the values in delivery metadata, read them in a control typology rule, compose the message from there. If they're inside a web control, you can have js copy them to the clipboard, then have marketers paste into the content. If they're intended to ...

Hi,<%= cryptString(memberId)%>Thanks,-Jon

You write a script to read the schemas written for the tables, then draw out the ERD from them.You can also use an off-the-shelf ERD generator and manually draw in all the relationships; I only mention the above due to the complexity of the ootb db, ~300 tables, 500 joins. Some people find that kind...

Hi,Recipient id's, not email addresses. From the small number it's likely some recipients were naturally deleted and later recreated, though you should still check your ETL jobs to make sure they're upserting recipients and not doing anything off-spec. This will sound unorthodox, but to fix the exis...

Hi,This is the closest you'll get:https://docs.campaign.adobe.com/doc/AC6.1/en/technicalResources/IMG/datamodel_diagram.pngI've gotten this request a number of times now, it should be straightforward to write a script to generate an ERD from Campaign's schemas, just never had the time/budget.Thanks,...

That was tongue-in-cheek, don't schedule restarts. Were you able to find the leaking module with that command?

Hi,The discrepancy is due to the inner join there, with trackinglog having recipient id's that aren't in recipient.If you remove the first name and email fields the result should be 316140.Thanks,-Jon

Hi,That's literally what that code says.Campaign's expressions are an abstracted sql that are translated directly or run as db functions, for compatibility across db's.Here 'iif' translates to 'case-when-then-else-end'.Adobe Campaign Classic is primarily a data management tool, it would be a good in...