Hello all,I am trying to work out some kinks with my recurring emails.
Here is what I am trying to achieve. I have a scheduler on a workflow
for the population to pull in ticket purchasers and send them a
pre-event email. After the first send, I want to exclude the previous
batch of recipients and only send to net new people from the ticket
purchasers population. I don't believe I have set up the delivery
exclusion correctly because it has sent a duplicate delivery to the
initial population in a...
hi, no I still haven't. I am wondering if it's the sftp file because I
have confirmed all the sftp data columns are the same as the ACS fields.
Here is the latest error code: WDB-200001 SQL statement 'INSERT INTO
wkf50169430_244_1 (iRecTrnState, iPKey1, sPKey_1, fFld1952776435,
sFld1952841972, sFld1952841973, sFld1952841974, sFld1952841975,
sFld1952841976, sFld1952841977, sFld1952841978, sFld1952841979,
sFld1952841980, sFld1952841981, sFld1952841982, sFld1952841983,
Hey All,I am trying to work through an issue with an SFTP File
Processing Workflow. We are trying to grab the data from the SFTP from
our Shopify Customer Orders. In doing so I keep encountering errors in
the Insert/Update step & I am not sure where the disconnect is. The
Error is:PGS-220000 PostgreSQL error: ERROR: column w0.morderlineitemkey
does not exist LINE 1: ...N CusShopify C1 ON (C1.sOrderlineitemkey =
substr(W0.mOrderL... ^ HINT: Perhaps you meant to reference the column
hey @SatheeskannaK, So the issue with this solution is that some of the
data is scattered among the duplicate profiles. So I want to be able to
transfer all data from all dups to just one profile & delete the others.
But will this work?
Hey! After spending almost 2 days researching ACS Duplicate info I have
come to find that ACS does not currently have a direct function to merge
duplicate profiles. Is there any other workaround to merge duplicate
@johnwwilcoxmba thanks for the info! Did you do this workflow based off
upload profiles?? I am looking to merge profiles like you mentioned but
when we switched to ACS we kept everything in profiles & don't use
updates so I have tons of thousands of dups. I was hoping to do
something like this but pulling from profiles from our ACS.
Hey there! I have just run across an issue with our profiles. I have
recently created a Landing Page that subscribes a user to a specific
service however when an existing profile subscribes through this landing
page to the new service, it duplicates the profile rather than updating
the existing profile with the new subscription. Has this happened to
anyone or does anyone have some experience that would prevent
duplicates? Thanks, friends!