topic Re: Extracting metadata from xml in Alfresco Archive

Extracting metadata from xml

tytanix — Wed, 27 Nov 2013 10:39:09 GMT

Good morning!In this days i've extended my alfresco in various way with great results. Now i have to scout the metadata extraction.In my system i have to store curricula of a business employees. This cv are created from https://europass.cedefop.europa.eu. The employee has to create his own cv and th

Re: Extracting metadata from xml

mitpatoliya — Wed, 27 Nov 2013 12:37:31 GMT

Best way to achieve this is create your custom metadata extractor which will be called when any of your CV gets uploaded.
You extractor will parse the xml and extract metadata from xml content using XML parser provided by java.Then those values can be mapped to common properties.

Re: Extracting metadata from xml

tytanix — Wed, 27 Nov 2013 12:55:00 GMT

Thank you! It's a good thing to know that i can do what i want. I'll try to find out how to do this. If you have any clue just to give me a start point you will be very helpfull, or even if you know some links to understand how to achieve that.

Just for best understanding, i will upload an xml cv as a normal document (with my custom type) i'll parse the content of the document to the extractor and then the extractor will return the values specified in each tag of the parsed xml, is that right?

Re: Extracting metadata from xml

mitpatoliya — Fri, 29 Nov 2013 14:29:16 GMT

Yes, you can change the extension of all your xml files to something like ".cvfile"
then bind your custom metadata extractor with this new filetype.
thats the way to go.

Re: Extracting metadata from xml

tytanix — Mon, 02 Dec 2013 08:26:56 GMT

Thank you very much for your help! A last question, i've found that i'have to implement a java class for my extractor, but i can't find out where to deploy that java. In which path should i put my java extractor?

Re: Extracting metadata from xml

mitpatoliya — Mon, 02 Dec 2013 10:18:03 GMT

you can create jar after compiling your java classes and put it under alfresco installation

<TOMCAT_HOME>/Webapps/alfresco/WEB-INF/lib

Re: Extracting metadata from xml

tytanix — Mon, 02 Dec 2013 16:38:00 GMT

This is my script to extract metadata from the earlier xml.

<blockcode>
function main()
{


   var fileContent = document.content;
   var xml = new XML(fileContent);



      logger.log("#### XML CONTENT ##### " + xml);

   var firstName = xml.SkillsPassport.LearnerInfo.Identification.PersonName.FirstName;
      logger.log("#### FIRST NAME #### " + firstName);


}

main();
</blockcode>

Unfortunately, firstName results empty while var xml contains the content of my xml curriculum. Is my approach wrong?

Re: Extracting metadata from xml

kaynezhang — Tue, 03 Dec 2013 12:08:33 GMT

in ECMAScript for XML if you write like this

 var xml = new XML(fileContent);‍

object xml stands for SkillsPassport element,So if you want to get a person's first name you should write it like this


function main()
{
   var fileContent = document.content;
   var xml = new XML(fileContent);
   logger.log("#### XML CONTENT  #####  " + xml);
   var firstName = xml.LearnerInfo.Identification.PersonName.FirstName;
        logger.log("#### FIRST NAME ####  " + firstName);
}
 
main();
‍‍‍‍‍‍‍‍‍‍‍‍

and make sure your logging is enabled ,if not you can write it like this


function main()
{
   var fileContent = document.content;
   var xml = new XML(fileContent);
   logger.getSystem().out("#### XML CONTENT  #####  " + xml);
   var firstName = xml.LearnerInfo.Identification.PersonName.FirstName;
        logger.getSystem().out("#### FIRST NAME ####  " + firstName);
}
 
main();
‍‍‍‍‍‍‍‍‍‍‍‍

Re: Extracting metadata from xml

vicmutish — Thu, 03 Apr 2014 11:01:00 GMT

I am very new to alfresco. I am scanning so many document using kodak capture pro and am facing the problem on how to read and index the document metadata of each image. attached is a sample xml file. I have created custom aspects bt i dont know how to index this information.
Kindly give me seggestion on where to start.