Enfocus Community

Code: Select all

	//open the original XML as an XML DOM	
	var origXML = new Document(origXMLPath);
	
	//get the folder and list of XML files contained in it (assuming this folder is coming into this script as a job input)
	var inFolder = new Dir(job.getPath());
	var fileList = inFolder.entryList("*.xml", Dir.Files, Dir.Name);
	
	//get the list of detail nodes from original XML file
	var detailList = origXML.evalToNodes("//details/detail", null);
	var isbn = "";
	var xmlFileName= "";
	var jobNumber = "";
	//for each node get the isbn number then search the folder of XML files for a node that matches that ISBN
	for (var i=0; i<detailList.length; i++){
		detailList.at(i).getAttribute("isbn");
		s.log(1, "Checking input XML files for matching isbn number of: " + isbn);
		for(var j=0; j<fileList.length; j++){
			if(fileList[i].indexOf(isbn) != -1){
				xmlFileName = fileList[i];
				break
			}
			//open one of the folder XML files as DOM
			folderXML = new Document(inFolder.path + "\\" + xmlFileName);
			jobNumber = folderXML.evalToString("//XPath/to/jobnumber", null);
			if(jobNumber != ""){
				s.log(1, "Found matching detail node with jobnumber value of: " + jobNumber);
				//add the jobnumber attribute to the original XML file
				detailList.at(i).addAttribute("jobnumber", null, jobNumber);
				jobNumber = "";
			}
		}
	}
	//save changes to original XML file
	origXML.save(orgXMLPath);

Code: Select all

isbn = detailList.at(i).getAttributeValue("isbn", null);

Code: Select all

// Is invoked each time a new job arrives in one of the input folders for the flow element.
// The newly arrived job is passed as the second parameter.
function jobArrived( s : Switch, job : Job )
{
//open the original XML as an XML DOM
var doc = job.getPath();
var origXML = new Document(doc);
//get the folder and list of XML files contained in it input)
var inFolder = new Dir("C:/Users/Enfocus.KY-SW1/Documents/FM_Parts");
var fileList = inFolder.entryList("*.xml", Dir.Files, Dir.Name);
s.log(1,fileList);

//get the list of detail nodes from original XML file
var detailList = origXML.evalToNodes("//metadata/orders/order/details/detail", null);
var isbn = "";
var xmlFileName= "";
var jobNumber = "";
s.log(2, "Made it here - 1");
var test= detailList.length;
s.log(2, test);

  //for each node get the isbn number then search the folder of XML files for a node that matches that ISBN
for (var i=0; i<detailList.length; i++){
var thenode = detailList.getItem(i);
var id = thenode.getAttributeValue("isbn",null);
s.log(3, id);
s.log(1, "Checking input XML files for matching isbn number of: " + id);

for(var j=0; j<fileList.length; j++)
	if(fileList[j].indexOf(id) != -1){
       xmlFileName = fileList[j]
					 break;
   } 


s.log(2, "Made it here - 2");
//open one of the folder XML files as DOM

folderXML = new Document(inFolder.path + "/" + xmlFileName);

jobNumber = folderXML.evalToString("//csv/field[1]", null);
s.log(2, jobNumber);
if(jobNumber != ""){
s.log(2, "Found matching detail node with jobnumber value of: " + jobNumber);
//add the jobnumber attribute to the original XML file
detailList.at(i).addAttribute("jobnumber", null, jobNumber);
jobNumber = "";}

}
//save changes to original XML file
origXML.save(job.getPath() );
job.sendToData(1, job.getPath() );
}

Code: Select all

// Is invoked each time a new job arrives in one of the input folders for the flow element.
// The newly arrived job is passed as the second parameter.
function jobArrived( s : Switch, job : Job ) {
	//open the original XML as an XML DOM
	var doc = job.getPath();
	var origXML = new Document(doc);
	//get the folder and list of XML files contained in it input
	var inFolder = new Dir("C:/Users/Enfocus.KY-SW1/Documents/FM_Parts");
	
	//get the list of detail nodes from original XML file
	var detailList = origXML.evalToNodes("//detail", null);
	var allFilesExist = true;
	var allJobNames = true;
	
	for (var i = 0; i < detailList.length; i += 1) {
		var currentNode = detailList.getItem(i);
		var isbnAttr = currentNode.getAttributeValue("isbn", null);
		
		var isbnFile = inFolder.entryList(isbnAttr + ".xml", Dir.Files, Dir.Name);
		
		if (isbnFile.length !== 0) {
			folderXML = new Document(inFolder.path + "/" + isbnFile);
			
			jobNumber = folderXML.evalToString("//csv/field[2]", null);
			
			if (jobNumber !== "") {
				s.log(2, "Found matching detail node with jobnumber value of: " + jobNumber);
				//add the jobnumber attribute to the original XML file
				detailList.at(i).addAttribute("jobnumber", null, jobNumber);
			} else {
				allJobNames = false;
				break;
			}
		} else {
			allFilesExist = false;
			break;
		}
	}
	
	if (allFilesExist && allJobNames) {
		//save changes to original XML file
		origXML.save(job.getPath());
		job.sendToData(1, job.getPath());
	} else {
		//send to error connection
		job.log(3, "Missing isbn XML file/Missing jobnumber");
		job.sendToData(3, job.getPath());
	}
}