10
Replies
Hi,
A possible approach:
//Main routine
var main = function() {
var m = $.os[0]=="M",
mFilter = function(f){return /\.xml/.test(f.name); },
wFilter= "XML Files: *.xml",
f,
xo, stories, n = 0, arr = [], book = <book/>, tmpFile = File(Folder.temp+"/temp.xml" ),
doc = app.properties.activeDocument;
//Exit if no documents open
if ( !doc ) {
alert("You need an open document" );
return;
}
//Let's select some XML File
f = File.openDialog( "Please choose XML file", m? mFilter : wFilter, false );
if ( !f ) return;
//Let's load a XML Object out of this file
f.encoding = "UTF-8";
f.open('r');
xo = XML( f.read() );
f.close();
//Let's grab the stories from teh xml object
stories = xo.xpath( "//*[@newStory]");
n = stories.length()
if ( !n ) {
alert("The xml file doesn't look valid");
return;
}
//Let's tunr our XML List into a standard array so we can call sort
while ( n-- ) {
arr
= stories ; }
//Let's sort array
arr.sort (idSort);
var n = arr.length;
i = 0;
//Let's recreate a new XML object
while ( i<n ) {
book.appendChild (arr);
i++;
}
//Let's write this new XML object to a temp file
tmpFile.encoding = "UTF-8";
tmpFile.open ( "w" );
tmpFile.write ( book.toXMLString() );
tmpFile.close();
//Let's place this file (might need to set xml import options at this stage)
doc.importXML ( tmpFile );
//let's remove our file
tmpFile.remove();
}
var idSort = function ( a, b ) {
var idA = a.@id;
var idB = b.@id;
var numA = !isNaN (String(idA));
var numB = !isNaN (String(idB));
var textA, textB, reg = /(^.+)(\d+)$/;
//If both attributes are numbers, let's do a natural sorting
if ( numA && numB ) {
return Number(a.@id) > Number(b.@id);
}
//if a is a number bt b isn't then we want the b string after the a number everytime
else if ( numA && !numB ) {
return false;
}
//If a is a string and b a number, the a string is passed after the b number
else if ( !numA && numB ) {
return true;
}
else {
//This one is trickier
textA = String(a.@id);
textB = String(b.@id);
numA = Number ( textA.replace ( reg, "$2") );
numB = Number ( textB.replace ( reg, "$2") );
//If a & b are indexed strings (such as appx1, appx2
//We do a natural sort on the index
if ( textA.replace ( reg, "$1" ) == textB.replace ( reg, "$1" ) ) {
return numA > numB;
}
//otherwise we do a negative sorting so Worksheets come first to appx.
//But this logic may need to be reviewed after all.
else {
return textA < textB;
}
}
}
//Go tigers…
main();
var doc = app.activeDocument;
var root = doc.xmlElements[0];
var xes = root.evaluateXPathExpression ( "//*[@newStory]") ;
var sortFn = function(a,b){
return a.id>b.id;
}
xes.sort(sortFn);
var i = 0; n = xes.length;
while ( i<n ) {
$.writeln( "i:"+xes.xmlAttributes.itemByName ( "id").value );
i++;
}
AdChoices