Enfocus Community

freddyp wrote: ↑Tue Aug 13, 2019 9:20 am It is not difficult to do with a script. Here is a code snippet that shows how to decode from base64 and save the result to a file:

function jobArrived( s : Switch, job : Job )
{
var xml = new Document(job.getPath());
var base64String = xml.evalToString("/metadata/orders/order/InvoiceFile", null);
var decodedResult = new ByteArray( base64String, "FromBase64");
var decodedFilePath = job.createPathWithName( "file.pdf");
File.writeByteArray( decodedFilePath, decodedResult);
}

jan_suhr wrote: ↑Tue Aug 13, 2019 4:32 pm Yes, you need to pickup the XML to a dataset. Then you can call that dataset and set an XPath to the node where the base64 line is.


Jan

Padawan wrote: ↑Tue Aug 13, 2019 5:55 pm Most likely the XPath expression is incorrect. Would it be possible to share your XML file? Then we can tailor an example specific to the structure of your XML file.

Padawan wrote: ↑Wed Aug 14, 2019 1:16 pm Ok, I used the earlier mentioned code and created a flow with it, you can find it in the attached zip. The flow looks like this:




Basically:
- An XML Pickup to attach your xml file as metadata
- A script to extract the part of the xml which is the PDF and save it as a PDF. The output from this script is only the PDF.
There are some properties to make it adjustable: name of the XML dataset (this needs to match the one in the XML Pickup), Xpath expression which says the script where in the xml file the file is stored, and output file extension which does what it says.
- The output file is the PDF file with the XML as dataset, ready to be used.

This is the adjusted code:

Code: Select all

function jobArrived( s : Switch, job : Job )
{
	
	var ds = job.getDataset(s.getPropertyValue("datasetName"));
	var dsPath = ds.getPath();
	var xml = new Document(dsPath);
	var base64String = xml.evalToString(s.getPropertyValue("xpath"), null);
	var decodedResult = new ByteArray( base64String, "FromBase64");
	var filename = job.getNameProper() + "." + s.getPropertyValue("extension");
	var decodedFilePath = job.createPathWithName( filename);
	File.writeByteArray( decodedFilePath, decodedResult);
	job.sendToSingle(decodedFilePath);
	job.sendToNull(job.getPath());
}

Archive.zip