nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Extracting metadata from xml

tytanix

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 then download the pdf and xml format. Is there a way to extract metadata directly from the field of the cv xml format?
I was thinking about an approach just like the one used for accessing to document properties (ex. document.properties["cm:doc"]

For example, this is one of the xml i was talking about:

<blockcode>
<?xml version='1.0' encoding='UTF-8'?>
<SkillsPassport xmlns="http://europass.cedefop.europa.eu/Europass" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://europass.cedefop.europa.eu/Europass http://europass.cedefop.europa.eu/xml/EuropassSchema_V3.0.1.xsd" locale="it">
   <DocumentInfo>
      <DocumentType>ECV</DocumentType>
      <CreationDate>2013-11-27T08:33:27.750Z</CreationDate>
      <LastUpdateDate>2013-11-27T08:42:29.610Z</LastUpdateDate>
      <XSDVersion>V3.0</XSDVersion>
      <Generator>EWA</Generator>
      <Comment>Europass CV</Comment>
   </DocumentInfo>
   <PrintingPreferences>

      <Document type="ECV">
         <Field name="LearnerInfo" show="true" order="Identification Headline WorkExperience Education Skills Achievement ReferenceTo"/>
         <Field name="LearnerInfo.Identification" show="true"/>
         <Field name="LearnerInfo.Identification.PersonName" show="true" order="Surname FirstName"/>
         <Field name="LearnerInfo.Identification.ContactInfo.Address" show="true" format="s, z m ©"/>
         <Field name="LearnerInfo.Identification.ContactInfo.Email" show="true"/>
         <Field name="LearnerInfo.Identification.ContactInfo.Telephone" show="true"/>
         <Field name="LearnerInfo.Identification.ContactInfo.Telephone[0]" show="true"/>
         <Field name="LearnerInfo.Identification.ContactInfo.Website" show="false"/>
         <Field name="LearnerInfo.Identification.ContactInfo.Website[0]" show="false"/>
         <Field name="LearnerInfo.Identification.ContactInfo.InstantMessaging" show="false"/>
         <Field name="LearnerInfo.Identification.ContactInfo.InstantMessaging[0]" show="false"/>
         <Field name="LearnerInfo.Identification.Demographics.Birthdate" show="true" format="numeric/long"/>
         <Field name="LearnerInfo.Identification.Demographics.Gender" show="true"/>
         <Field name="LearnerInfo.Identification.Demographics.Nationality" show="true"/>
         <Field name="LearnerInfo.Identification.Demographics.Nationality[0]" show="true"/>
         <Field name="LearnerInfo.Identification.Photo" show="false"/>
         <Field name="LearnerInfo.Headline" show="true"/>
         <Field name="LearnerInfo.WorkExperience" show="true"/>
         <Field name="LearnerInfo.WorkExperience[0]" show="true"/>
         <Field name="LearnerInfo.WorkExperience[0].Period" show="true" format="text/long"/>
         <Field name="LearnerInfo.WorkExperience[0].ReferenceTo" show="false"/>
         <Field name="LearnerInfo.WorkExperience[0].ReferenceTo[0]" show="false"/>
         <Field name="LearnerInfo.WorkExperience[0].Position" show="true"/>
         <Field name="LearnerInfo.WorkExperience[0].Activities" show="true"/>
         <Field name="LearnerInfo.WorkExperience[0].Employer" show="false"/>
         <Field name="LearnerInfo.WorkExperience[0].Employer.ContactInfo.Address" show="false" format="s, z m ©"/>
         <Field name="LearnerInfo.WorkExperience[0].Employer.ContactInfo.Website" show="false"/>
         <Field name="LearnerInfo.WorkExperience[0].Employer.Sector" show="false"/>
         <Field name="LearnerInfo.Education" show="true"/>
         <Field name="LearnerInfo.Education[0]" show="true"/>
         <Field name="LearnerInfo.Education[0].Period" show="true" format="text/long"/>
         <Field name="LearnerInfo.Education[0].ReferenceTo" show="false"/>
         <Field name="LearnerInfo.Education[0].ReferenceTo[0]" show="false"/>
         <Field name="LearnerInfo.Education[0].Title" show="true"/>
         <Field name="LearnerInfo.Education[0].Activities" show="true"/>
         <Field name="LearnerInfo.Education[0].Organisation" show="false"/>
         <Field name="LearnerInfo.Education[0].Organisation.ContactInfo.Address" show="false" format="s, z m ©"/>
         <Field name="LearnerInfo.Education[0].Organisation.ContactInfo.Website" show="false"/>
         <Field name="LearnerInfo.Education[0].Level" show="false"/>
         <Field name="LearnerInfo.Education[0].Field" show="false"/>
         <Field name="LearnerInfo.Skills" show="true"/>
         <Field name="LearnerInfo.Skills.Linguistic.MotherTongue" show="true"/>
         <Field name="LearnerInfo.Skills.Linguistic.MotherTongue[0]" show="true"/>
         <Field name="LearnerInfo.Skills.Linguistic.ForeignLanguage" show="true"/>
         <Field name="LearnerInfo.Skills.Linguistic.ForeignLanguage[0]" show="true"/>
         <Field name="LearnerInfo.Skills.Linguistic.ForeignLanguage[0].ReferenceTo" show="false"/>
         <Field name="LearnerInfo.Skills.Linguistic.ForeignLanguage[0].ReferenceTo[0]" show="false"/>
         <Field name="LearnerInfo.Skills.Linguistic.ForeignLanguage[0].Certificate" show="false"/>
         <Field name="LearnerInfo.Skills.Linguistic.ForeignLanguage[0].Certificate[0]" show="false"/>
         <Field name="LearnerInfo.Skills.Communication" show="true"/>
         <Field name="LearnerInfo.Skills.Communication.ReferenceTo" show="false"/>
         <Field name="LearnerInfo.Skills.Communication.ReferenceTo[0]" show="false"/>
         <Field name="LearnerInfo.Skills.Organisational" show="true"/>
         <Field name="LearnerInfo.Skills.Organisational.ReferenceTo" show="false"/>
         <Field name="LearnerInfo.Skills.Organisational.ReferenceTo[0]" show="false"/>
         <Field name="LearnerInfo.Skills.JobRelated" show="true"/>
         <Field name="LearnerInfo.Skills.JobRelated.ReferenceTo" show="false"/>
         <Field name="LearnerInfo.Skills.JobRelated.ReferenceTo[0]" show="false"/>
         <Field name="LearnerInfo.Skills.Computer" show="true"/>
         <Field name="LearnerInfo.Skills.Computer.ReferenceTo" show="false"/>
         <Field name="LearnerInfo.Skills.Computer.ReferenceTo[0]" show="false"/>
         <Field name="LearnerInfo.Skills.Driving" show="false"/>
         <Field name="LearnerInfo.Skills.Driving.ReferenceTo" show="false"/>
         <Field name="LearnerInfo.Skills.Driving.ReferenceTo[0]" show="false"/>
         <Field name="LearnerInfo.Skills.Other" show="false"/>
         <Field name="LearnerInfo.Skills.Other.ReferenceTo" show="false"/>
         <Field name="LearnerInfo.Skills.Other.ReferenceTo[0]" show="false"/>
         <Field name="LearnerInfo.Achievement" show="false"/>
         <Field name="LearnerInfo.Achievement[0]" show="false"/>
         <Field name="LearnerInfo.Achievement[0].ReferenceTo" show="false"/>
         <Field name="LearnerInfo.Achievement[0].ReferenceTo[0]" show="false"/>
         <Field name="LearnerInfo.ReferenceTo" show="false"/>
         <Field name="LearnerInfo.ReferenceTo[0]" show="false"/>
      </Document>

   </PrintingPreferences>

   <LearnerInfo>

      <Identification>

         <PersonName>
            <FirstName></FirstName>
            <Surname></Surname>
         </PersonName>

         <ContactInfo>
            <Address>
               <Contact>
                  <AddressLine></AddressLine>
                  <PostalCode></PostalCode>
                  <Municipality></Municipality>
                  <Country>
                     <Code></Code>
                     <Label></Label>
                  </Country>
               </Contact>
            </Address>

            <Email>
               <Contact></Contact>
            </Email>

            <TelephoneList>
               <Telephone>
                  <Contact></Contact>
                  <Use>
                     <Code></Code>
                     <Label></Label>
                  </Use>
               </Telephone>
            </TelephoneList>

         </ContactInfo>

         <Demographics>

            <Birthdate year="" month="" day=""/>

            <Gender>
               <Code></Code>
               <Label></Label>
            </Gender>

            <NationalityList>
               <Nationality>
                  <Code></Code>
                  <Label></Label>
               </Nationality>
            </NationalityList>

         </Demographics>

      </Identification>

      <Skills>

         <Linguistic>

            <ForeignLanguageList>

               <ForeignLanguage>

                  <Description>
                     <Code></Code>
                     <Label></Label>
                  </Description>

                  <ProficiencyLevel>
                     <Listening></Listening>
                     <Reading></Reading>
                     <SpokenInteraction></SpokenInteraction>
                     <SpokenProduction></SpokenProduction>
                     <Writing></Writing>
                  </ProficiencyLevel>

               </ForeignLanguage>

            </ForeignLanguageList>

         </Linguistic>

      </Skills>

   </LearnerInfo>

</SkillsPassport>
</blockcode>

So i would like to extract the data from xml fields and, if it's possible, call this xml in create document as template, edit xml fields in a form, save the values and then convert the populated xml to a pdf.

Find more posts tagged with

Comments

mitpatoliya

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.

tytanix

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?

mitpatoliya

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.

tytanix

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?

mitpatoliya

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

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

tytanix

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?

kaynezhang

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();
‍‍‍‍‍‍‍‍‍‍‍‍

vicmutish

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.

xml.txt.zip