topic Re: I have a document uploaded to a folder along an XML file. in Alfresco Forum

I have a document uploaded to a folder along an XML file.

nimbus1958 — Tue, 16 Oct 2018 08:51:46 GMT

I need to parse that XML to add metadata to the document via javascript. I just cannot find a way to extract the value from that XML. Any idea would be welcomed.Thanks.Pablo

Re: I have a document uploaded to a folder along an XML file.

angelborroy — Wed, 17 Oct 2018 07:31:56 GMT

From Repository JavaScript API, this should work:

var docXml = new XML(document.content);‍

Re: I have a document uploaded to a folder along an XML file.

nimbus1958 — Wed, 17 Oct 2018 07:53:50 GMT

Thanks Angel,

I got that far and it works but my problem is retrieving a value within the XML.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<DocumentSet>
<Document>
<FileName>Brief - Lettre_4umqrm82l5ay.pdf</FileName>
<FilePath>\\alfresco\alfresco\MailRoom\Brief - Lettre_4umqrm82l5ay.pdf</FilePath>
<Confidentiality>3-Organisation</Confidentiality>
<Departement>CUAC</Departement>
<Domein___Domaine>DC</Domein___Domaine>
<Info_type>Brief - Lettre</Info_type>
<Medewerker___Collaborateur>Alain Terrieur</Medewerker___Collaborateur>
<Status___Statut>5 - Overgedragen - Transféré</Status___Statut>
</Document>
</DocumentSet>

I just can't seem to get the <Info_type> Value!

Frustrating!

Re: I have a document uploaded to a folder along an XML file.

angelborroy — Wed, 17 Oct 2018 09:36:23 GMT

This should work:

docXml.DocumentSet‍.Document.Info_type‍‍

Re: I have a document uploaded to a folder along an XML file.

nimbus1958 — Wed, 17 Oct 2018 10:09:34 GMT

Angel, That is what I thought also but ... no luck!

This is taken to its most basic, following your advice and documentation!

var docXml = new XML(document.content);
var infoType = docXml.DocumentSet.Document.Info_type;
document.properties.title = infoType;
document.save();

Drowing in frustration!

Thanks for your help!

Re: I have a document uploaded to a folder along an XML file.

angelborroy — Wed, 17 Oct 2018 12:59:22 GMT

This works...

var docString = document.content;

if (docString.startsWith("<?xml")) {
     docString = docString.split("\n").slice(1).join("\n")
}

var docXml = new XML(docString);

var infoType = docXml.DocumentSet.Document.Info_type;

logger.log(docXml.Document.Info_type);‍‍‍‍‍‍‍‍‍‍‍

... you can change / improve it, as it's a quick PoC.

Re: I have a document uploaded to a folder along an XML file.

nimbus1958 — Wed, 17 Oct 2018 13:24:34 GMT

Thanks Angel but I have no results. I even tried to change the name of the document but nothing. It is as if the variable was not populated.

I will give it a shot tomorrow on another Alfresco instance in the office and follow your proposition. I’ll let you know the results.

I really appreciate your time and help.

Re: I have a document uploaded to a folder along an XML file.

angelborroy — Wed, 17 Oct 2018 13:45:58 GMT

It looks like I included a bad sample.

IMO, the main problem is that you have to omit "DocumentSet" when recovering values from XML.

This doesn't work...

docXml.DocumentSet.Document.Info_type

... but this works

docXml.Document.Info_type

Re: I have a document uploaded to a folder along an XML file.

nimbus1958 — Thu, 18 Oct 2018 04:51:57 GMT

Thanks Angel, It works!

Big thanks for your help!