since ‎06-01-2020
WesleyXP
Level 1
Re: Identify workflow based on name of wkf tables WesleyXP - Adobe Campaign Classic
Hi Jon, Thank you for your reply and the confirmation. Do you know how Adobe Campaign handles negative workflow id's? As shown in the example, we cannot derive the workflow id from the wkf table name when it's - this is an assumption - negative. Is there a way how AC translates a negative id? Kind regards, Wesley
82
Views
0
Likes
0
Comments
Identify workflow based on name of wkf tables WesleyXP - Adobe Campaign Classic
Hi everyone, Our system engineer sometimes provides us with the names of the wkf-tables created by workflows causing trouble on the system.Usually it's possible to derive the workflow directly from these id's, but not always. Example 1The table with name wkf539349321_11438_1 is created by the workflow with primary key 539.349.321.This key is directly derived from the name. Example 2When we derive the primary key using the same method out of wkf3312884954_218_1 we get 3.312.884.954.However, the p...
110
Views
0
Likes
3
Answers and Comments
Named rights in Adobe Campaign Classic WesleyXP - Adobe Campaign Classic
Hi, We're trying to limit the number of operators with administrator clearance. However, it seems like lot's of functionalities actually require administrator rights, which isn't okay. Therefore we are wondering if we can create a specific named rights for the following two actions so that we can assign those two rights to the operator groups needing them, and thus preventing those operators from having access to everything:Offer validationPackage managementWe are aware package management is usu...
93
Views
0
Likes
1
Answers and Comments
Re: E-mail deliverability WesleyXP - Adobe Campaign Classic
Hi @InMo, We have this package already installed and are using the default reports. Sadly we don't have access to all mid-source information. We have created a manual report with daily figures and would now rather know how we should calculate the advised maximum. We always thought it was +20% of the maximum of the last 30 days, but in an Adobe webinar they stated "the average maximum of the last 3 to 6 months". So maybe someone know the best approach to calculate this figure as an "average maxim...
340
Views
0
Likes
0
Comments
E-mail deliverability WesleyXP - Adobe Campaign Classic
Dear, During a webinar from Adobe, we've learned that with respect to e-mail deliverability we should not exceed more than 20% above the average max volume over the last 3 to 6 months. We wonder how exactly we should calculate the average max volume of the last 3 to 6 months. Does this imply calculating the average of the maximum during a period of 1 month over the last 6 months. As in: calculate the max of the last 30 days, the max of 30 to 60 days ago, 60 to 90 days ago, etc. and to then calcu...
366
Views
0
Likes
3
Answers and Comments
Re: Write access on Hadoop/Hive WesleyXP - Adobe Campaign Classic
Dear Jon, Thanks for your reply. The matrix is really helpful! We found another one, but this one is way more clear. We already have the Hadoop connection in place and it's all working. We are rather exploring ways to improve the use of it, for which our technical guys need more insights. However, nobody seem to know the answers. Related to question- How can we achieve access to Hive/Hadoop through enrichments/split activities? We now know that you can access the data by adding data (cf. add dat...
3108
Views
0
Likes
0
Comments
Write access on Hadoop/Hive WesleyXP - Adobe Campaign Classic
Dear, We are currently investigation how we can setup write rights to Hive/Hadoop to store temporary results on Hive/Hadoop instead of in the SQL DB of AC.We also read it might be possible to use Hive/Hadoop tables in the enrichment / split activity, and not only in the RDBMS activity. We however have some questions related to this, maybe the community can help us:- Is it possible to store the result of an RDBMS activity on Hive instead of the SQL DB of Adobe Campaign?- What rights does AC need ...
3149
Views
0
Likes
2
Answers and Comments
Re: Multiple email addresses for one recipient WesleyXP - Adobe Campaign Classic
Dear @_Manoj_Kumar, Thank you for this tip! I've looked up the documentation about target mapping and found the option to create a new one.I guess it's just changing the e-mail field as shown below, to the new field that we create by extending the data schema of the recipients table. I guess there's no impact on the delivery logs and subscriptions?Or is there? Kind regards,Wesley
2634
Views
0
Likes
0
Comments
Multiple email addresses for one recipient WesleyXP - Adobe Campaign Classic
Hi everyone, We are in the situation where one recipient might have a personal and business e-mail address. When we contact that person for personal stuff, the e-mail should be send to his/her personal e-mail address. However, when we contact that person in relation to the company he/she is related to, the e-mail should be send to his/her business e-mail address. However, on the recipient level there's only one field available OOTB.Due to a specific setup we cannot just create a second recipient...
2673
Views
0
Likes
3
Answers and Comments
Re: SHA256 and SHA512 function returns wrong hash WesleyXP - Adobe Campaign Classic
Hi wodnicki, Based on new offline feedback we got, we concluded that Adobe Campaign is adding "N" in front of the string value before hashing it. It does this for each unicode string. The result is a different hash than expected. What Adobe Campain does: lower(convert(varchar(64), HashBytes('SHA2_256'), N'1ZZ1234'), 2)) What you would expect: lower(convert(varchar(64), HashBytes('SHA2_256'), '1ZZ1234'), 2)) This explains the difference between both hashes. Wesley
1356
Views
0
Likes
0
Answers
Re: SHA256 and SHA512 function returns wrong hash WesleyXP - Adobe Campaign Classic
Hi wodnicki, Thanks for your quick reply. I posted new insights about the problem as a separate answer. Wesley
1449
Views
0
Likes
0
Comments
SHA256 and SHA512 function returns wrong hash WesleyXP - Adobe Campaign Classic
Dear, We would like to hash certain data in our recipients table, but do notice that the returned hash isn't the right one when we use the SHA256 or SHA512 expression. For MD5 the returned result is however the right one.We've checked the conversion in numerous ways (cf. https://dencode.com/hash --> UTF8, UTF16, ... CRLF, LF, ...) and investigated a lot of deviations (capitals vs regular letter, spaces, ...) already. Example string: 1ZZ1234SHA256db33faa6dc66525db69058bd1b0b0a4257aa881218adc83581...
1969
Views
0
Likes
3
Answers and Comments
SHA256 and SHA512 functions returning wrong hash WesleyXP - Adobe Campaign Classic
Dear, We would like to hash certain data in our recipients table, but do notice that the returned hash isn't the right one when we use the SHA256 or SHA512 expression. For MD5 the returned result is however the right one.We've checked the conversion in numerous ways (cf. https://dencode.com/hash --> UTF8, UTF16, ... CRLF, LF, ...) and investigated a lot of deviations (capitals vs regular letter, spaces, ...) already. Example string: 1ZZ1234SHA256db33faa6dc66525db69058bd1b0b0a4257aa881218adc83581...
1525
Views
0
Likes
2
Answers and Comments