since ‎30-05-2017
‎06-01-2020
Jean-Serge_Biro
MVP
Re: Enumerations in Reports
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Jaspreet,Enumeration format is unfortunately here for xtk:enum (itemized lists, node Administration>Platform>Enumerations (itemized lists) not for sysEnum (enumerations defined in schema, XML source schema).And yes, you pointed out a limitation of Adobe Campaign for such report, with sysEnum values.The only solution for sysEnum, as far as I know, is to add the label corresponding to the value of sysEnum for each line, in the context for each line retrieved by your query.So it means a bit of J...

Views

644

Like

1

Replies

0
Re: Deleted deliveries
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Tip: display Advanced fields by clicking on the icon on bottom right of the panel.

Views

946

Likes

0

Replies

0
Re: Deleted deliveries
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Harshal,Please see below a screenshot but for AC 6.1.1 French version (hereinafter the Delivery list configuration, but you can do it in Schema Data tab also, or in Query activity on dimension Delivery, etc).Type deleteStatus in search bar for displaying it in bold.Hope this helps.RegardsJS

Views

940

Likes

0

Replies

0
Re: Dynamic coding with multiple values
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Jael,IN operator is for SQL query where clause.For Javascript use either operator || (OR) or switch statement to be more concise than your syntax, repeating the test in case of same action targeted. But of course your syntax works fine as well...RegardsJ-Serge

Views

2.0K

Likes

0

Replies

0
Re: XTK-170024 The temporary 'temp:enrich' schema is not defined in the current context.
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Krishna,Please, first of all, you should always put an End activity in all your workflows. Otherwise, the cleanup batch process (see technical workflow documentation) can't do the cleansing operations as it should and the temporary data remains a while.With the interim population checkbox activated, you would be able to see the result set, after an execution. Please add the End activity, relaunch it and confirm it. Many thanks.RegardsJ-Serge

Views

1.3K

Likes

0

Replies

0
Re: Creating query expressions using regex
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hello Jael,Please might you explain why you intend to use regex for SQL queries instead standard SQL possibilities?Usually regex is used in script languages (Javascript, JSSP for Adobe Campaign).In SQL depending on field type you have these choices:1. [numeric field] between operator in where clause, with query activity it doesn't exist so you must replace it by 2 clauses, one for superior or equal and the other one for inferior or equal; or if your query is not made through Query activity but b...

Views

1.4K

Like

1

Replies

2
Re: How to pick up current DELIVERY id in a DELIVERY report workflow
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Salvatore,Besides of what Amit suggested, filter by context (which is a powerful mean for filtering data) from interactive input flow, even with the standard query you should not have issue to select/filter the records targeted with the method you took.Debugging reports is sometimes tedious task, so I recommend you to add some Javascript activity between each other activity (page, query) and writes some logInfo in the JS activity. In addition of Debug mode and examining XML context, it greatl...

Views

1.5K

Likes

0

Replies

6
Re: Deleted deliveries
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Classic
Hi Harshalt,Even though you could use the linked folder of the delivery, I strongly suggest you to use instead the deleteStatus "boolean" of the delivery (not a true boolean, butPlease read also this documentation, because some of the logical deleted deliveries are really deleted after some conditions filled, by the cleanup nightly process (usually at 4 am):https://docs.campaign.adobe.com/doc/AC/en/PRO_Data_processing_Database_cleanup_workflow.html#Cleanup_of_deliveries_to_be_deleted_or_recycled...

Views

956

Like

1

Replies

0
Re: Dropdown form data from database
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hello Sakadam,You should use input element with type="linkList" attribute, for sophisticated list display (it allows multiple columns, buttons to show or hide, etc).Otherwise, for simple enumeration list, you can use type="list".Details of all attributes are given in JSAPI documentation.Regards.J-Serge

Views

442

Likes

0

Replies

0
Re: How to receive all deliveries that are sent out globally from one instance?
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Suzanne,I think you should use the standard seed control list mechanism; but in order that nobody would forget to include your seed email address, you should include it in the default delivery templates, and in addition add a typology rule to check that the delivery seed list includes your email address, or even better, add automatically your address in the delivery seed list automatically through the typology rule. Of course your typology rule must be called by all typologies used by the del...

Views

407

Likes

2

Replies

0
Re: Editing Forms: Is there a type for insert a line break?
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Robert,If you need real blank line, no choice, you need to use containers to manage the disposition. For instance:Use padding-top attribute (or padding-bottom) to add pixels above (below) the container.Other attributes are described in the JSAPI documentation.Some other attributes are not described in the documentation and you can find out in the forms code...Regards.J-Serge

Views

757

Like

1

Replies

0
Re: Editing Forms: Is there a type for insert a line break?
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hello Robert,You should ask to the Adobe Campaign support team to give you the JSAPI.chm documentation file (windows help file). It is however subject to license so it depends on contract with Adobe, see your Adobe contact/support team.In the meanwhile, use this:orPlease enter your name here.RegardsJ-Serge

Views

757

Like

1

Replies

1
Re: Make campaign ID (primary key) start at least from 10000
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Salvatore & Adhiyan,Actually there are 2 main cases:1. sequence managed by the RDBMS (database) itself2. sequence managed by Adobe Campaign (autopk=true)Of course I used to use both depending on context.But you must take care that you must not alter the sequence value targeted with instruction given by Adhiyan (Oracle syntax, but similar ones in other RDBMS) for sequences managed by Adobe Campaign. So please have a look in your targeted schema, if the column to update is autopk=true, then use...

Views

9.8K

Like

1

Replies

3
Re: Make campaign ID (primary key) start at least from 10000
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Please have also a look on xtkNewId (and GetNewIds):https://docs.campaign.adobe.com/doc/AC/en/browseAC.html https://docs.campaign.adobe.com/doc/AC/en/PRO_Database_maintenance_Application_objects.html

Views

9.8K

Likes

0

Replies

0
Re: Make campaign ID (primary key) start at least from 10000
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Salvatore,Please may you explain a bit more why you must force the ID values in your import job, instead of letting Adobe Campaign import system increment automatically the primary key value of the targeted standard objects?And will you import the data with Adobe Campaign tools (workflow activity or manually with Import model treatment)? Or with the help of an external ETL (Extract / Transform / Load) tool ?Some standard Adobe Campaign tables (schemas) use autopk=true so it increments automat...

Views

9.8K

Like

1

Replies

1
Re: Embed campaign forms via JavaScript
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Dimitri,Please may you describe a bit more your requirement and your Adobe Campaign version as well (ACS or AC v6.x.y/v7.0)?ACS and AC v6/v7 have different possibilities including API, please confirm your environment.Do you mean including Adobe Campaign webApp (standard or microsites) through html iframe object?Or do you intend to display Adobe Campaign forms (XML forms) needing AC authentication and an operator account?Or rather, as far as I guess from your request, do you want to develop yo...

Views

637

Likes

0

Replies

0
Re: Substring function
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Jael,Please don't duplicate entries, see reply there:Substring function RegardsJS

Views

1.0K

Like

1

Replies

2
Re: differentiating campaign reports based on target profile location
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Richa,Do you use Adobe Campaign classic (v6/v7) version or standard ACS ?I don't know at all ACS.And I notice today this information about ACS, Dynamic Reporting with Profile Data:https://forums.adobe.com/thread/2384514But if it is in Adobe Campaign v6/v7, you should have a look on these standard reports:deliveryFeedbackstatisticsPerDeliverydeliveryStatisticsOne good way to learn and experiment is to duplicate these reports for your own namespace schema and so, you can modify them and adapt t...

Views

324

Likes

0

Replies

0
Re: List of functions
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Jael,The only documentation is:https://docs.campaign.adobe.com/doc/AC/en/PTF_Creating_queries_Methodology.html These SQL functions are written in the database underlying language code, and you can find them all in the Adobe Campaign folder node:Administration>Settings>SQL Script.Select your own Database system (mySql, Postgres, SQL Server, Oracle, etc) to see how the functions listed are written in the underlying DB engine language (T-SQL for SQL Server, PL/SQL for Oracle, etc). And one very ...

Views

896

Likes

2

Replies

1
Re: Substring function
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Jael,The only documentation is:https://docs.campaign.adobe.com/doc/AC/en/PTF_Creating_queries_Methodology.html These SQL functions are written in the database underlying language code, and you can find them all in the Adobe Campaign folder node:Administration>Settings>SQL Script.Select your own Database system (mySql, Postgres, SQL Server, Oracle, etc) to see how the functions listed are written in the underlying DB engine language (T-SQL for SQL Server, PL/SQL for Oracle, etc). And one very ...

Views

1.4K

Likes

0

Replies

0
Re: differentiating campaign reports based on target profile location
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Richa,Do you use Adobe Campaign classic (v6/v7) version or standard ACS ?Are the reports for company use or the contacts targeted themselves.Are profiles the Contacts from nms:recipients so the city code could be used for displaying and sending reports attached to their deliveries based on their data (either the nms:recipient or the cube generated from nms:recipient data, xtk:olapCube) ?Or are the city information taken from the nms:operators schema (I guess not) ? Regarding your use case, ma...

Views

296

Likes

0

Replies

0
Re: Differentiating reports based on user login
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi Richa,If you are using Adobe Campaign classic version (v6/v7), users must be Adobe Campaign users (operators).You can set Privileges restriction in the Display tab of your report, based on specific operators or operator groups (better use):RegardsJ-Serge

Views

425

Likes

0

Replies

0
Re: Append to ALL the href urls of a delivery template the MD5 function of the recipient email
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Sorry I don't remember where it is described in the documentation, I let you find out in it.Regards.J-Serge

Views

474

Likes

0

Replies

0
Re: How to receive all deliveries that are sent out globally from one instance?
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hello Suzanne,Please may you clarify your requirement?why don't you want to add your email address in Seed addresses list (nms:seedAddress) that are added automatically to all deliveries sent? If you want to "automate" the filling of the Delivery target options (Seed address/ Adresses de contrôle), you should add them in the blank Delivery template in your nmsDeliveryModel (internal name) default folder.If you proceed by duplicating older deliveraries that don't have such Seed addresses defined,...

Views

434

Likes

0

Replies

0
Re: Append to ALL the href urls of a delivery template the MD5 function of the recipient email
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Buon giorno Salvatore,I used to use MD5 encoding as you do, in many Query or query-like activities, most of time by selecting extraction field email such as:Md5Digest([recipient/@email]).I find this very easy.So I don't understand why this method doesn't fit your need in Delivery personalisation. When it must be done in Javascript, you can use directly the JSAPI function: digestStrMd5(string), it works fine too.Regarding the window DOM object, you are right, you can't use it in the AC Javascript...

Views

477

Likes

0

Replies

0
Re: replace function
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
It is a Javascript function, so it can't be used in a Query activity directly.You must develop your Replacement SQL function by coding either replacement by no space (as Amit and Vipul gave) if you intend to "normalize" the strings by deleting all special characters (replace by nothing), or replacing to equivalent ANSI characters.For instance in French, "è" character can be either encoded (ISO encoding entity %E8) or replaced by "similar" (but not equivalent char) "e".Same for space: encode it a...

Views

2.0K

Likes

0

Replies

0
Re: replace function
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Hi vendimb,Apparently you would not have taken into account my recommandation (my post on 14th Spe) about URL encoding and different special characters that appear frequently in people names... So I strongly suggest you to improve the SQL function VIPreplace in order to replace these special characters as well.RegardsJ-Serge

Views

1.7K

Like

1

Replies

0
GDPR - Adobe Campaign compliance and tools
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Dear all,Please, may you share your concerns about Adobe Campaign compliance to GDPR law?European Union law that will apply on May 2018 and have impacts on all software editors and customers, all around the world actually (penalty up to 4% of companies worldwide turnover): http://www.eugdpr.org/ I would like to know, for both Adobe editor and its Adobe Campaign customers, how are managed the GDPR fulfillment project, either for AC functionalities required or existing ones that must evolve, or fo...

Views

12.1K

Likes

6

Replies

23
Re: To Read a variable in Delivery activity - Adobe Campaign
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
2 more things:I failed to use directly delivery.output.fileName in Delivery script tab, but someone could probably optimize my solution by using delivery.output.fileName directly, instead passing the vars.calculatedFilename value defined in the JS activity to the delivery thanks to the Delivery variable defined.If you have already defined some variables in your delivery, please note that the variables order is important, so adapt it accordingly in the Javascript code (_var[0] for 1st variable de...

Views

2.1K

Likes

3

Replies

0
Re: To Read a variable in Delivery activity - Adobe Campaign
Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
- Adobe Campaign Standard
Small correction:delivery.variables._var[0].stringValue = vars.calculatedFilename;

Views

2.2K

Likes

2

Replies

0