Skip to main content
M
MonishaRajendran
Inspiring
October 30, 2022
Answered

add the label value for the second column

  • October 30, 2022
  • 3 replies
  • 500 views

Hi,

I wanted to display the alphanumeric value in the dialog where I split the Listbox into two columns. For the first column I used to get the expected deals as used for the first column I used to display the values in the second column, but it display's only the last value. With this, I have attached the code I used. Thanks in advance

 

var MSIDvalue = [];
var InddMSIDValues = [];
var getXMLMSIDvalue = [];
var xmlTree = GetXMLFile();
var content = new XML(xmlTree);
var getXmlId =getAllAttributeValues ("MSID");
var myGroup = app.activeDocument;
var allPageItemsOfGroup = myGroup.allPageItems;
for(var n=0;n<allPageItemsOfGroup.length;n++){
var myObject = allPageItemsOfGroup[n].getElements()[0];
if(myObject.constructor.name === "TextFrame" )
{
var myFrame = app.activeDocument.textFrames;
var mySelectedXMLItem = myFrame[n].associatedXMLElement;
if(mySelectedXMLItem != null && mySelectedXMLItem.markupTag.name != null)
{
node_TBGUID = myFrame[n].associatedXMLElement.xmlAttributes.itemByName("MSID").value;
MSIDvalue.push(node_TBGUID);
}
}
}

var dlg = new Window( "dialog", "Modified Contents" );
// create list box with two titled columns
var list = dlg.add ('ListBox', [0, 0, 500, 550], '',
{numberOfColumns: 2, showHeaders: true,
columnTitles: ['Document Content', 'XML Content']});
// add an item for the first row, with the label value for the first column
var getMSIDvalue = MSIDvalue.toString().split(",");
for(var k = 0;k<getMSIDvalue.length;k++)
var item1 = list.add ('item', getMSIDvalue[k]);
// add the label value for the second column in that row.
var getXMLMSIDvalue = getXmlId.toString().split(",");
for(var l = 0;l<getXMLMSIDvalue.length;l++)
item1.subItems[0].text = getXMLMSIDvalue[l];


dlg.show();

// Read the XML file
function GetXMLFile()
{
myDoc = app.activeDocument;
myLinks = myDoc.links;
for (j = myLinks.length - 1; j >= 0; j--)
{
myName = myLinks[j].filePath;
var ext = myName.substring(myName.length-3,myName.length) ;
if (ext=="xml")
{
myXMLFile = File(myName);
var myResult = myXMLFile.open("r");
if(myResult == true)
{
var myXMLDefaults = myXMLFile.read();
myXMLFile.close();
var myXMLDefaults = new XML(myXMLDefaults);
return myXMLDefaults;
}
}//for
}
}

function getAllAttributeValues(attributeName){
var allAttributes = [];
var allNodes = content[0].xpath("//*[@"+attributeName+"]");
for(var i = 0; i < allNodes.length(); i++){
allAttributes.push(allNodes[i].attribute(attributeName).toString());
}
if(allAttributes.length > 0){
return allAttributes;
}
else{
return null;
}
}

This topic has been closed for replies.
Correct answer m1b

Hi @MonishaRajendran, does this help?

 

var dlg = new Window("dialog", "Modified Contents");

// create list box with two titled columns
var list = dlg.add('ListBox', [0, 0, 500, 550], '',
    {
        numberOfColumns: 2, showHeaders: true,
        columnTitles: ['Document Content', 'XML Content']
    });

// add an item for the first row, with the label value for the first column
var getMSIDvalue = MSIDvalue.toString().split(",");
var getXMLMSIDvalue = getXmlId.toString().split(",");
$/*debug*/.writeln('getMSIDvalue = ' + getMSIDvalue);
$/*debug*/.writeln('getXMLMSIDvalue = ' + getXMLMSIDvalue);

for (var k = 0; k < getMSIDvalue.length; k++) {

    var item1 = list.add('item', getMSIDvalue[k]);

    if (k < getXMLMSIDvalue.length)
        // add the label value for the second column in that row.
        item1.subItems[0].text = getXMLMSIDvalue[k];

}

dlg.show();

 

This is the dialog section. The problem here was that you were running through the entire "k" loop first, and then running through the "l" loop on the last item only.

But I suspect there are other problems, because (see the writelns in the code above) there are way more elements in the getXMLMSIDvalue array than the getMSIDvalue array. I suspect they won't match up.

Anyway, hope this moves you forward with your script.

- Mark

3 replies

E
Community Expert
Eugene TysonCommunity Expert
Community Expert
December 1, 2022

Hi @MonishaRajendran 

Was this resolved?

m1b
Community Expert
m1bCommunity ExpertCorrect answer
Community Expert
October 31, 2022

Hi @MonishaRajendran, does this help?

 

var dlg = new Window("dialog", "Modified Contents");

// create list box with two titled columns
var list = dlg.add('ListBox', [0, 0, 500, 550], '',
    {
        numberOfColumns: 2, showHeaders: true,
        columnTitles: ['Document Content', 'XML Content']
    });

// add an item for the first row, with the label value for the first column
var getMSIDvalue = MSIDvalue.toString().split(",");
var getXMLMSIDvalue = getXmlId.toString().split(",");
$/*debug*/.writeln('getMSIDvalue = ' + getMSIDvalue);
$/*debug*/.writeln('getXMLMSIDvalue = ' + getXMLMSIDvalue);

for (var k = 0; k < getMSIDvalue.length; k++) {

    var item1 = list.add('item', getMSIDvalue[k]);

    if (k < getXMLMSIDvalue.length)
        // add the label value for the second column in that row.
        item1.subItems[0].text = getXMLMSIDvalue[k];

}

dlg.show();

 

This is the dialog section. The problem here was that you were running through the entire "k" loop first, and then running through the "l" loop on the last item only.

But I suspect there are other problems, because (see the writelns in the code above) there are way more elements in the getXMLMSIDvalue array than the getMSIDvalue array. I suspect they won't match up.

Anyway, hope this moves you forward with your script.

- Mark

    m1b
    Community Expert
    m1bCommunity Expert
    Community Expert
    October 30, 2022

    Hi @MonishaRajendran, a cannot see the problem immediately. Could you please post a small sample indesign file with .xml linked file for us to test your script with?

    - Mark

    M
    MonishaRajendranAuthor
    Inspiring
    October 31, 2022

    Hi @m1b 

    I am including the XML file and the InDesign document as an attachment. By using the script, I was able to get the CDATA values from the XML. The value of each CDATA element is displayed in a dialog box. But for now I can't able to display the XML CDATA values.

     

    -Monisha
    rob day
    Community Expert
    rob dayCommunity Expert
    Community Expert
    October 31, 2022

    Hi @MonishaRajendran , If I trace getXmlID (which you are calling in the dialog) with your sample doc open it returns null:

     

    var MSIDvalue = [];
var InddMSIDValues = [];
var getXMLMSIDvalue = [];
var xmlTree = GetXMLFile();
var content = new XML(xmlTree);
var getXmlId =getAllAttributeValues ("MSID");


$.writeln(getXmlId) //returns null

     

     

     

    And if I check allAttributes.length in your getAllAttributeValues function it returns 0

     

    function getAllAttributeValues(attributeName){
    var allAttributes = [];
    var allNodes = content[0].xpath("//*[@"+attributeName+"]");
    for(var i = 0; i < allNodes.length(); i++){
        allAttributes.push(allNodes[i].attribute(attributeName).toString());
    }
    $.writeln(allAttributes.length) //returning 0
    if(allAttributes.length > 0){
        return allAttributes;
    }else{
        return null;
    }
}

     

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices