XTK session write | Community
Skip to main content
shivaDT
shivaDT
New Participant
April 20, 2016
Solved

XTK session write

  • April 20, 2016
  • 13 replies
  • 17660 views

Hi Team ,

could you please advise ,if there is something wrong with the below script ..

I have tried to use it and its not working ...

please suggest ..

xtk.session.Write(<enrich4
xtkschema="temp:enrich4" _key="@id" id={responder.@id} > <Product2
description={secondArray[1]}/> <Product3
description={secondArray[2]}/></enrich4>);

regards

shiva

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by DimaKudryavtsev

Hi ShivaDT,

First, don't use xtk.session.Write for temporary schemas. Even if you manage it to work, it will be super slow.

If you need to modify flow data, export the file via data export comonent to the server HDD. By default the file will be stored in var/<Instance Name>/export folder. Use Javascript code to open the file, modify its lines and save it into another file. Use data load component to load the file back into the flow. Use another Javascript component to delete the file after it no longer required.

If you use CSV format, you will be able read the original file line by line, modify each line and store it back, so this solution will not consume large amount of memory.

My tests shows that this approach is about 100 times faster comparing with Write or WriteCollection functions. Adobe lacking library to parse or crease csv files, so you will have to build your own or adopt some existing one (Node.js module?)

Next, in your case, you don't have to do it at all. You can do your logic inside delivery template.

Lets asume, you targetData has element [Product/@description]

You can use following JSSP code to build up the lists

<%

     var allProducts =["FOOD","BINS & LINERS","BEVERAGES AND SWEETNERS","CATERING SUPPLIES","BATHROOM & KITCHEN PAPER","CLEANING CHEMICALS & EQUIPMENT","APPLIANCES"];

     var existingProducts = []

     for (var i in targetData.Product) {

          existingProducts.push(targetData.Product[i].description)

     }

     var newProducts = allProducts.filter(function(product) {

          for each (var existing in existingProducts) {

               if (existing == product) {

                    return false

               }

          }

          return true

     })

%>

Then just enumerate through the lists to produce required content

HI ShivaDT,

13 replies

DimaKudryavtsev
DimaKudryavtsevAccepted solution
New Participant
August 6, 2019

Hi ShivaDT,

First, don't use xtk.session.Write for temporary schemas. Even if you manage it to work, it will be super slow.

If you need to modify flow data, export the file via data export comonent to the server HDD. By default the file will be stored in var/<Instance Name>/export folder. Use Javascript code to open the file, modify its lines and save it into another file. Use data load component to load the file back into the flow. Use another Javascript component to delete the file after it no longer required.

If you use CSV format, you will be able read the original file line by line, modify each line and store it back, so this solution will not consume large amount of memory.

My tests shows that this approach is about 100 times faster comparing with Write or WriteCollection functions. Adobe lacking library to parse or crease csv files, so you will have to build your own or adopt some existing one (Node.js module?)

Next, in your case, you don't have to do it at all. You can do your logic inside delivery template.

Lets asume, you targetData has element [Product/@description]

You can use following JSSP code to build up the lists

<%

     var allProducts =["FOOD","BINS & LINERS","BEVERAGES AND SWEETNERS","CATERING SUPPLIES","BATHROOM & KITCHEN PAPER","CLEANING CHEMICALS & EQUIPMENT","APPLIANCES"];

     var existingProducts = []

     for (var i in targetData.Product) {

          existingProducts.push(targetData.Product[i].description)

     }

     var newProducts = allProducts.filter(function(product) {

          for each (var existing in existingProducts) {

               if (existing == product) {

                    return false

               }

          }

          return true

     })

%>

Then just enumerate through the lists to produce required content

HI ShivaDT,

Jyoti_Yadav
Jyoti_Yadav
New Participant
July 3, 2019

HI ShivaDT,

You can use below sql to update your temp data:

xtk.session.Write(<query xtkschema={vars.targetSchema} id={iId} _operation="update" />)

Thanks,

Jyoti

Marcel_Szimonisz
Marcel_Szimonisz
New Participant
June 18, 2018

Hello shivaDT, this is only to work with temp table within the workflow. you can load the group then do the change to its data in temp table and then load temp data back to the group. you can use save list activity. Or you can change data of group by the sqlExec but you need to find the group's internal name e.g grp13737291

queryDef on nms:group

Marcel

maurizio_coro
maurizio_coro
New Participant
June 18, 2018

Hi everyone, can I use

sqlExec("UPDATE " + vars.tableName + " SET sEmail='"+ doStuff(item) +"' where iId=" + item.@id);

to update groups and lists? Or to insert data?

jamesb97473021
jamesb97473021
New Participant
June 15, 2018

Hi,

I can confirm that I have never been able to get xtk.session.Write to change the temporary workflow data, we have always had to use sqlExec as marcel.gent.86 describes.

The following two queries should do the same but only the second actually updates the temporary workflow data:

Doesn't work

Does work

It would be great if Adobe could explain why xtk.session.Write doesn't update the data. Is there a step we are missing?

S
srikanthr646926
New Participant
May 2, 2018

Thanks Very Much

Marcel_Szimonisz
Marcel_Szimonisz
New Participant
April 27, 2018

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(

         <queryDef schema={vars.targetSchema} operation="select">

          <select>

            <node expr="@id"/>

            <node expr="@email"/>

          </select>

         </queryDef>);

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.

Result --

Marcel

S
srikanthr646926
New Participant
March 26, 2018

@vipul

Can you please help with this

S
srikanthr646926
New Participant
March 26, 2018

Is it resolved? I am looking for a similar thing

var schemaName = vars.targetSchema.substring(vars.targetSchema.indexOf(":") + 1);

logInfo("Schem name = " +schemaName);

var formatString = function(str) {
   
       blah blah blh......................

    return str;
}

var query = xtk.queryDef.create(
         <queryDef schema={vars.targetSchema} operation="select">
          <select>
            <node expr="@Label"/>
            <node expr="@FullName"/>
            <node expr="@lineNum"/>
          </select>
         </queryDef>);
  
var resultSet = query.ExecuteQuery();
for each (var row in resultSet.enrich5)
{
instance.vars.Label=formatString(row.@Label);
//logInfo(formatString(resultSet.enrich5.@Label));
xtk.session.Write(<query _operation="update" _key="@lineNum" Label= {formatString(row.@Label)}  xtkschema={vars.targetSchema}/>);

}

shivaDT
shivaDTAuthor
New Participant
May 3, 2016

Below is the JS i have written ..

var query = xtk.queryDef.create( 

    <queryDef schema="temp:enrich4" operation="select">   

    <select>     

   <node alias="@d1"  expr="[Product1/@Description]"/>

   <node alias="@d2" expr="[Product2/@Description]"/>

   <node alias="@d3" expr="[Product3/@Description]"/>

   <node expr="@id"/>

    </select>    

  </queryDef>)

var responders  = query.ExecuteQuery();

for each (var responder in responders.enrich4){ 

    //logInfo(responder);

  var firstArray=["FOOD","BINS & LINERS","BEVERAGES AND SWEETNERS","CATERING SUPPLIES","BATHROOM & KITCHEN PAPER","CLEANING CHEMICALS & EQUIPMENT","APPLIANCES"];

    var secondArray = [];

    var numOne = responder.@d1;   

    var numTwo = responder.@d2;

    var numThree = responder.@d3;

    secondArray.push(numOne);  

    if (numTwo!=""){

    secondArray.push(numTwo);

  }

    if (numThree!=""){

    secondArray.push(numThree);

  }

  for (var i = 0; i < firstArray.length; i++) {

    var isPresent=false;

    for(var j=0;j< secondArray.length;j++)

    {

      if(secondArray[j] == firstArray[i] )

        isPresent= true;

    }

  

    if(isPresent==false)

    secondArray.push(firstArray[i]);

  }

  for(var j=0;j< secondArray.length;j++)

  { 

     document.writeln(secondArray[j]);

  }

   

   var des1 = secondArray[1];

   var des2 = secondArray[2];

  

   xtk.session.Write(<enrich4 xtkschema="temp:enrich4" _key="@id" id={responder.@id} > <Product2 description={secondArray[1]}/> <Product3 description={secondArray[2]}/></enrich4>);

   

    logInfo("id:"+ responder.@id);

  logInfo("secondArray[1]:"+ secondArray[1]);

  logInfo("responder.Product2.Description:" +des1);

  logInfo("secondArray[2]:" +secondArray[2]);

    logInfo("responder.Product3.Description:" +des2);

    

}

Show more replies
Terms & ConditionsAccessibility statement

Loading footer...