Hello @George-CT5, There are two ways to do this depending on your end
goal : If the difference in content is just a greeting sentence you may
want to use a content block and do your JS conditions in it directly. If
the content difference is significant you should go with dynamic content
directly in your delivery by leveraging the segment codes in your split
activity : Hope this is clear enough.
The only way I can think of to controlling workflows outside the UI is
with REST API commands :
https://experienceleague.adobe.com/docs/campaign-standard/using/working-with-apis/managing-workflows/controlling-a-workflow.html?lang=en#working-with-apis
Hello @Shwetambra, You can use external signal activities for your need
and create the main workflow like this: Add external signal
configuration in each end activity with the workflow to trigger :Also
make sure the workflows to trigger are already started with external
signal activity blinking : More info on external signals :
https://experienceleague.adobe.com/docs/campaign-standard/using/managing-processes-and-data/execution-activities/external-signal.html?lang=en#configuration
Cheers.
I tested the new expression and sent an email and it's working. Please
delete and replace the personalisation field to take into acount the
changed formula. Also query your profile and send yourself and email to
check final result, I don't think you can see the result in profile
substitution preview since it's an additional data coming from the
workflow.
Hello @Darren_Bowers Thanks for the answer, I have been trying to
implement that, but still get the following error : -53sudo: a password
is required Can you please tell me if my CMD command is constructed
correctly : //instance.vars.fileToSend is the complete path to the file
extracted in the activity before var CMD = '"'+"sed -i
'1s/\xEF\xBB\xBF//' "+instance.vars.fileToSend+'"' logInfo('command
remove bom ===>'+CMD); var res =execCommand(CMD,true);
instance.vars.retour = res[0]; logInfo('Code...
In the additional data tab of your query add the expression as follows :
Then open your email delivery and replace the personalization field with
the @roundedRnwlPrice in additional data : Hope this is clear enough.
Hello @mmbb110 You can add an enrichement in your workflow and use the
Round function to limit the price to two decimals :
Round(@cusMembershipRnwlPrice, 2). You will then have to replace the
Personalization field in your email with the new defined one. Cheers.
Hello, I'm having an issue with a csv file extraction. The need is to
have it encoded in UTF8 but ACC adds the byte order mark at the begining
of the file. Any idea how to get simple UTF8 extraction or remove the
BOM please ? Thank you.
Hello @geethay15244378, You can only unsubscribe from two services using
an acquisition Landing Page.You will have to use two checkboxes html
field of type service and subscription, and select the service to
unsubscribe from for each. Hope this helps.
Hello @robayzma, I just tried reproducing the dynamic segment in a
query, I do have an SQL error.I think the reason is that the expression
$long(vars/@recCount) can't be applied here since there are no inbound
transition to the query. If your need is to have the segment named with
the count resulting from the query, you can add an enrichment after the
query and put your expression there : Outbound transition from the query
:Enrichment with dynamic segment code :Outbound transition from the
enric...
Bonjour @gbernardin, Voici un workflow fonctionnel répondant à votre
besoin : Charger votre fichierBranchementDéduplication sur l'IDRejoindre
les deux transition dans un enrichissementCréer une collection de
produits ayant pour Ensemble Principal La transition de dedup et comme
schema cible la transition de branchement : Nouvel enrichissement pour
garder 3 Produits parmi notre collection :continuer les étapes en
ajoutant si nécessaire des critères de filtres et/ou tri de ces trois
produits à gar...
@gbernardin J'ai un doute en voyant votre screenshot, vous êtes sur
Adobe Campaign Classic et non Standard non ? Si c'est le cas, vous devez
déplacer votre post.
Bonjour @gbernardin, Je viens de répondre à un besoin similaire sur le
post suivant :
https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-standard/combining-multiple-rows-into-1-row-from-imported-file/qaq-p/385734
Mais peut être que ton cas ici est plus simple.Est ce que tu peux
confirmer que tu n'a que deux doublons au maximum par ID identique dans
ton fichier ? Aussi, si j'ai bien compris, il n'y a que le montant total
à calculer pour le regroupement ? Peux tu partager un exemple e...
Hello, Here's a solution but you will need to know the maximum
duplicates possible in your file, and also have a field to correctly
order the records and concatenate your message in the right order. Load
your fileFork to two transitionsin first transition, add a deduplication
based on the Header1 Join the two transitions in an enrichment activity
wih the deduplication transition as the main set in an N card link In
the additional data tab add your new collection link and configure its
parameters...
Hello @rahulg1930481, You can add the expression RowId() in your
enrichment activity. There is btw an issue that needs to be corrected
when choosing RowID from the functions list, the parenthesis are
missing:
Hey @peterd54639079 Couple questions here to be able to help you with
this. In your full file, are there always only two duplicates to merge
?What should the Header 2 field look like when merged : Message
1+Message 2 ?If so, does the line with the lower row number always have
the start of the Message ?What is the final objective of this ? Updating
a table ? If so it may be easier to update twice directly rather than
trying to merge the data beforehand.Thanks.
Hello @stephanef891866, I had the same issue a while back and could not
make is work using your same logic, it seems like this is the expected
behaviour. The default getDate() value of your field will only be
populated if the profile is created via the create button in the UI
interface. But looking at your configuration you can do the following
workaround : I see that your landing page only allows for Profile
creation and not update. Thus, your registration date corresponds to the
@created field...
@mmbb110 You need to base your query on the subscription history
ressource not Profile : Conditions are : Then dedup on the temporary
ressource : This should work.
Hello @mmbb110, The explanation is simple : In your Audience Query, you
have the number of profiles who unsubscribed from the service. In the
Subscription history tab of your service, you can have multiple
unsubscription records for the same profile, thus the higher count. A
deduplication based on the email address will give you the same count as
your Audience query.
Hello Maximiliano, You have two options: You can add the ID of the
workflow directly in your extract file activity as part of the output
file title. Open the extract file activityClick on the pen Icon next to
the output file fieldClick on Insert personalization fieldChoose the
ID(name) fieldOr You can add the workflow ID as additional data in your
main query or enrichment using the expression: $(instance/@name) and add
it as an output column in your extract file activity.
Hello all,I stumbled upon this old thread and I need to do the exact
operation, computing the link of a landing page with the profile
parameter.Is this solution still working? I do the exact same thing but
can't seem to access my acquisition landing page.Did you have to encrypt
your Pkey?On another note, the LP URL link will be way to long and
complexe for a client to type in his browser, I'm looking for an
automated way to shorten the URLS. Looks like using the new external API
activity with bi...
Salut Pierre-Yves,Pour un besoin similaire, j'ai configuré la même Query
que toi. ça semble logique, mais j'ai pris le temps de comprendre
pourquoi ça ne fonctionne pas, avant de trouver une solution de
contournement que je partage volontiers en anglais :The aggregate
functions don't work with simple fields, only with collections :The
average profile age can be calculated by creating a Profile collection
using Additional data in the main query and the Enrichment activity :In
your main query add ...
Hi Amit_KumarMuch thanks for your help.Your answer helped me achieve
the following solution for my need :1. 4 Schedulers that will run
monthly on the 28/29/30/31 days of the month.2. Used my main query to
add lastday of the month as an additional data :@LastDayOfMonth =
DateOnly(SubMinutes(AddMonths(YearAndMonth(GetDate()), 1), 1))3. Check
>In split if @LastDayOfMonth = DateOnly(GetDate()) yes? proceeds to send
my delivery else end workflow
Hi,How should I configure my scheduler to make sure it's runing the last
day of every month, whether it's 30/31 days or 28/29 in February.Will 31
as an N-th day do the job ?Thank you.
