Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

MarcelSzimonisz
Community profile MarcelSzimonisz Community Advisor
MarTech Consulatant
Prague
36 BADGES
Community Advisor

Community Advisor

Learn more
Joined the community 04-05-2016 1:06:21 AM
Offline
Top badges earned by MarcelSzimonisz
Customize the badges you want to showcase on your profile
Re: How to build a button to open a delivery
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello,Yes you need to grab that link and try to create your own In your case the link is:view/operation?id=137113479&backview=%7B"view"%3A"campaign"%2C"params"%3A%7B%7D%7D&__universe=campaign&__securitytoken=@fHFNc8zQEhVv3Pis0fOAUafCXt2mCg==this part you do not need to view page:&backview=%7B"view"%3A"campaign"%2C"params"%3A%7B%7D%7D&__universe=campaign&__securitytoken=@fHFNc8zQEhVv3Pis0fOAUafCXt2mCg==so the link would be simple as:your_server_url/view/operation?id=<%= your_campaign_id %>same ap...

Views

462

Likes

0

Replies

0
Re: getElementById
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello, if are you trying to change email content before personalization you can use regular expressions eg.var html = delivery.content.html.source;var regex = new RegExp("","ig");var regex2 = newRegExp("(.*?)<\/div>","ig");html.replace(regex,'add_your_html');html.replace(regex2,'add_your_html');delivery.content.html.source = html;OR you can try to amend html with XML E4X extension look it up in jsapi (have not tried).Marcel

Views

831

Like

1

Replies

0
Re: How to build a button to open a delivery
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello,You can do transitions in the report to the next page or any other transition in which you display information you want--page activity---- create transitions you want---- ceate link object---- enable transiotion you wantORyou can directly use OOTB or custom report URLsI have not tried this option whether you can compute URL string with context (ctx) variablesORYou can create your own HTML pagesWhere links will open another OOTB/ custom reportORyou can do all above in JSSP pages (have not t...

Views

461

Likes

0

Replies

0
Re: XTK session write
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello all,you might try sqlExec() function to do the job. I think write and write collecion are not to be used with temp tables. (At least i tried to do the same as below)----var query = xtk.queryDef.create( );var res = query.ExecuteQuery();function doStuff(item){ return 'stuff_done';}for each (var item in res) sqlExec("UPDATE " + vars.tableName + " SET sEmail='"+ doStuff(item) +"' where iId=" + item.@id);---You just need to find your column names in SQL by exploring targeting dimension.Res...

Views

3.5K

Likes

0

Replies

0
Re: Removing additional function from xtk:funcList
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Classic
Hello,I want to remove these additional functions I have added to xtk:funcList by following Adding additional SQL functions tutorial. I want to know the approach in case of fallback Best regards,Marcel

Views

759

Likes

0

Replies

0
Re: UNIQUE Recipient Counts - when Grouped by "Something" - Using QueryDef
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello,i can sketch one posible solution for you function onlyUnique(value, index, self) { return self.indexOf(value) === index;}var res = select unique recipient ids belonging to that surveyvar possibleAnswers = [];for each (var item in res){ resOldestAnswer = select very first recipient annswer by given id res.@answer = resOldestAnswer.@answer; res.@eventDate = resOldestAnswer.@answer; possibleAnswers.push(res.@answer.toString());}//get unique anwers if you know them you can populate array manu...

Views

8.1K

Likes

0

Replies

0
Re: UNIQUE Recipient Counts - when Grouped by "Something" - Using QueryDef
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello,Ok then select all answers for Tottenham and loop over all results and keep only oldest answer per recipient id. You can delete row you do not need by row.delete in your loop condition based on eventDateor you can try usiing sqlSelect() command by selecting somthing similar at this link Finding the Oldest/Youngest Records Within a Group var res = sqlSelect("publicUrl,@sstringValue:string", "select sstringValue from XtkOption where sname='XtkFileRes_PublicUrl'")logInfo(res.publicUrl.@sstrin...

Views

8.1K

Likes

0

Replies

0
Re: Removing additional function from xtk:funcList
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Classic
Hello,Thank you for the answer. But i have added additional function to that list by following the docu.. but i have no idea how to remove additional functions just delete the additional funct list from the xtk:funcList?Marcel

Views

716

Likes

0

Replies

0
Re: UNIQUE Recipient Counts - when Grouped by "Something" - Using QueryDef
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello,sorry for being late You need to select recipients of that survey then dedup them by recip ID to get unique recipients then add enrichment to add "Data linked to the filtering dimension" chose to retrieve very first answer of given survey. Then in the same enrichment "edit additional data" select your answer field and check group by and add recip id to count it. I do not have any surveys data but this should work (hopefully)Marcel

Views

8.1K

Likes

0

Replies

2
Re: Adding data to a delivery icon from a javascript Icon
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello karanv22355550​,Adobe instance vars and vars can hold string values only.If you want to store objects in them you can use built in JSON.stringify()var myObject = {["obj1":"value1"]};var myArray = [1,2,3];//convert object to stringinstance.vars.myObject = JSON.stringify(myObject);instance.vars.myArray = JSON.stringify(mymArray);/at any other place in the same worfklow //convert string to objectvar myObject = JSON.parse(instance.vars.myObject);var myArray = JSON.parse(instance.vars.myArray);...

Views

1.7K

Likes

0

Replies

0
Removing additional function from xtk:funcList
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Classic
Hello All,I know how to add and change functions to - func list. But how do we delete them if needed?Do I have to run procedure to remove these from DB or is there any way how to do it from the rich client?Or just remove lines i want in the xtk:funcList?Adding additional SQL functions Thank you,Marcel

Views

1.7K

Likes

0

Replies

5
Re: xtk:funcList could not be loaded
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello Amit,it happened 2 times since last september. So it is just really occasional.Marcel

Views

1.4K

Likes

0

Replies

0
Re: xtk:funcList could not be loaded
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello Amit,it is all OOTB. after restart it is fine again. can it be some error in loading like the file is not fully loaded and this there is this syntax error Marcel

Views

1.4K

Like

1

Replies

2
xtk:funcList could not be loaded
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello,can anybody shed light into this error (high level) and if it can be prevented?ODBC error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared. SQLState: 37000SQL statement 'SELECT E0.sNamespace, E0.sName, E0.sEntitySchema, E0.sImg, E0.sMd5, E0.sLabel, E0.iCreatedById, E0.iModifiedById, E0.tsCreated, E0.tsLastModified, IsNull(E0.sLabel, '') + ? + IsNull(E0.sNamespace, '') + ?, neolane..IsMemoNull(E0.mData), E0.mData FROM XtkEntity E0 WHERE' could not be...

Views

1.7K

Like

1

Replies

4
Re: calling a java variable in delivery or Alert
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello,You can't use instance variables directly in the delivery see this thread Use of variable in continuous delivery, how to do ?Why not use "alert" activity for internal monitoring? Plus you can use instance variables in the alert activity Marcel

Views

2.2K

Like

1

Replies

1
Re: Use of variable in continuous delivery, how to do ?
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello Andy,thats adobe's stuff you can ignore that error or move the js code to the delivery itself. But why you use delivery activity and not alert activity?Marcel

Views

3.6K

Like

1

Replies

0
Re: Use of variable in continuous delivery, how to do ?
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello Andy,i did not mention this (i did not know this.. see comment from celine) that instance variables can hold strings only. If you have queried target population in JS and saved results in instance vars you need make XML from it again in the delivery.var items = new XML(instance.vars.items);PS: also I have found that vars.targetSchema will refer to activity name.. which is very useful when having multiple queries in the pipeline (works only with query and readGroup!)schema={vars.targetSchem...

Views

3.6K

Like

1

Replies

0
Where to find all sysFilter possibilities?
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello All,Where can I find all possible functions I can use and what is their meaning in the sysFilter condition enableIf attribute e.g. hasNamedRight(''), EVal(''), $(homeDir),$(loginId)... In documentation you can find only one, hasNamedRight(Basically I need something as hasNamedRight for to use with groups --> hasGroup('group_name')? [EDIT] I had to create another named right and add it to the group.Also can I use "hasNamedRight(some_right1)=false or hasNamedRight(some_right2)=false" in enab...

Views

1.1K

Like

1

Replies

1
Re: How to split clickers for multiple delivers
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello Ruby,you can do it in the split (you need to have query activity before ofc) by adding subsets with filtering condition for as many deliveries as ou want:OpenersClickersor Or you can query each delivery separatelly openersclickersBr,Marcel

Views

488

Like

1

Replies

0
Re: queryDef on nms:group
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello Vipul,the table rcpGrpRel is empty in our installation. this is only being populated when targeting dimension is exatly the recipient type, right?I need to query group (list) which has additional data to targeting dimension. I have foung the sqlSelect() which is working var res = sqlSelect("document,@field:string:255", "select sField from grp110315177");for each (var item in res.document) logError(item.@field);BR,Marcel

Views

927

Likes

0

Replies

0
queryDef on nms:group
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello,Does anybody know how to get data of nms:group from JS using queryDef or any other method available?Marcel

Views

1.5K

Likes

0

Replies

2
Re: Use of variable in continuous delivery, how to do ?
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello David,You probably have solved this but I would try to remove proofs from the query --> FCP == "1" as the logs for these are purged. (I thnk they are deleted after you execute the campaign for real)Marcel

Views

3.7K

Likes

0

Replies

0
Re: How to read variable (xml) from workflowEvent
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
just found out query does not initialize the vars.targetSchema.. so far readGroup it is doing and enrichment that i have used and they work

Views

5.9K

Likes

0

Replies

0
Re: How to read variable (xml) from workflowEvent
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello Kaushal,-why you need to use xtkQuerDef? You can access current workflow instance, event,task ... variables by eg typing instance.vars.CELL_OFFSET... what ever is created by developer or by any activity, event automatically.-why targetSchema is undefined? because i presume your only activity in wf is javascript activity you need to have any of query activities--> read group, query, rdbms, file import ... to have this variable initialized in vars.tergetSchemaWithout query activity you get u...

Views

5.9K

Likes

2

Replies

1
Re: How to read variable (xml) from workflowEvent
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello Kaushal,You can consider them as global variables which can be used not only by downstreem activities but anywhere in in the wf instance see more below:JavaScript scripts and templates How to use an instance variable in a workflow Split activityPS:- you can also pass them from one runtime to another of the same wf Marcel

Views

5.9K

Likes

0

Replies

3
Re: Is it Possible to do a right Join In Enrichment Activity?
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
yes exclusion is also a solution Marcel

Views

3.6K

Likes

0

Replies

0
Re: I want to see the exact delivery that a recipient has received.
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello,what about sending proofs or seeds if you just want to know if personalization is working?Marcel

Views

12.3K

Likes

0

Replies

1
Re: Is it Possible to do a right Join In Enrichment Activity?
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello,Only I can think of is to query anything from second table in right join and then change dimension to first table in the right join select.Marcel

Views

3.6K

Likes

0

Replies

1
Re: How to read variable (xml) from workflowEvent
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello,You can access them by instance.vars. ...instance.vars.CELL_OFFSETMarcel

Views

5.9K

Likes

0

Replies

5
Re: I want to Upload images to Public resources every morning. Is it possible to automate this process.
Avatar
Contributor 2
Community Advisor
MarcelSzimonisz
Community Advisor

Likes

116 likes

Total Posts

248 posts

Correct reply

61 solutions
Top badges earned
Contributor 2
Ignite 20
Give Back 200
Give Back 100
Ignite 10
View profile
MarcelSzimonisz
- Adobe Campaign Standard
Hello Vipul,yes thats good question you will need to publish images to all frontal servers as it would be done automatically when you are uploading resource via adobe. Thank you for pointing this out. I think the one who wants this to be automated will figure it out somehow or I suppose it can be done differently at all.Marcel

Views

3.4K

Likes

0

Replies

1