topic Re: I cannot see metadata values in Alfresco Archive

I cannot see metadata values

durdy48 — Mon, 03 Dec 2007 07:57:50 GMT

Hi. Why can i not see metadata values?When i add a OpenOffice's document with customs metadata defined by user to a space which has a rule with an custom aspects defined in my own model which is this:<?xml version="1.0" encoding="UTF-8"?><model xmlns:xsi="http://www.w3.org/2001/XMLSchema-in

Re: I cannot see metadata values

durdy48 — Mon, 03 Dec 2007 09:04:54 GMT

It would can be that values doesn't save on database, because i didn't find it.
So, what would be the cause for this?

Re: I cannot see metadata values

alf983 — Mon, 17 Dec 2007 11:53:16 GMT

Hi,
I have the same problem.
Are you solved?

Re: I cannot see metadata values

durdy48 — Mon, 17 Dec 2007 13:49:42 GMT

I believe that it exist a bug in alfresco-web-client.jar because i'm debugging source code and i can see that the mapping was doing very good but when it was added the new aspect , this didn't it .

Could you take a look to source code:

- AddContentDialog
- BaseContentWizard

in package org.alfresco.web.bean.content of alfresco-web-client.jar

the custom metadatas never are added to system alfresco.

Thanks!

Re: I cannot see metadata values

alf983 — Tue, 08 Jan 2008 12:03:27 GMT

hi durdy,

in the class SPOpenOfficeMetadataExtracter the qname is not declared.
With the method

putRawValue(KEY_CREATOR, docInfo.getCreator(), rawProperties);‍

the string KEY_CREATOR is a string not a qname.

With the deprecated method "trimPut" with the AbstractMetadataExtracter class you declared the qname and is ok.

How do you now?

Re: I cannot see metadata values

durdy48 — Wed, 09 Jan 2008 15:17:35 GMT

Hi alf983.

To resolve the problem that i've described i follow the next steps:

1. In SPOpenOfficeMetadataExtracter my code is:


public Map<String, Serializable> extractRaw(ContentReader reader) throws Throwable
    {
        Map<String, Serializable> rawProperties = newRawMap();
        
        //es.juntadeandalucia.ceh.dgsief.metadata.ODFMetaFileAnalyzer analyzer = new es.juntadeandalucia.ceh.dgsief.metadata.ODFMetaFileAnalyzer();
        ODFMetaFileAnalyzer analyzer = new ODFMetaFileAnalyzer();
        InputStream is = null;
        try
        {
            is = reader.getContentInputStream();
            // stream the document in
            //es.juntadeandalucia.ceh.dgsief.metadata.OpenDocumentMetadata docInfo = analyzer.analyzeZip(is);
            OpenDocumentMetadata docInfo = analyzer.analyzeZip(is);
            if (docInfo != null)
            {
                putRawValue(KEY_CREATION_DATE, docInfo.getCreationDate(), rawProperties);
                putRawValue(KEY_CREATOR, docInfo.getCreator(), rawProperties);
                putRawValue(KEY_DATE, docInfo.getDate(), rawProperties);
                putRawValue(KEY_DESCRIPTION, docInfo.getDescription(), rawProperties);
                putRawValue(KEY_GENERATOR, docInfo.getGenerator(), rawProperties);
                putRawValue(KEY_INITIAL_CREATOR, docInfo.getInitialCreator(), rawProperties);
                putRawValue(KEY_KEYWORD, docInfo.getKeyword(), rawProperties);
                putRawValue(KEY_LANGUAGE, docInfo.getLanguage(), rawProperties);
                putRawValue(KEY_PRINT_DATE, docInfo.getPrintDate(), rawProperties);
                putRawValue(KEY_PRINTED_BY, docInfo.getPrintedBy(), rawProperties);
                putRawValue(KEY_SUBJECT, docInfo.getSubject(), rawProperties);
                putRawValue(KEY_TITLE, docInfo.getTitle(), rawProperties);
                
                
                // Handle user-defined properties dynamically
                Map<String, Set<QName>> mapping = super.getMapping();
                Hashtable userDefinedProperties = docInfo.getUserDefined();
               // Extract those user properties for which there is a mapping
               for (String key : mapping.keySet())
               {
                   if (userDefinedProperties.containsKey(key))
                   {
                       Object value = userDefinedProperties.get(key);
                       if (value != null && value instanceof Serializable)
                       {
                           putRawValue(key, (Serializable) value, rawProperties);
                       }
                       if(docInfo.getDescription() == null){
                          docInfo.setDescription("");
                       }
                       docInfo.setDescription(docInfo.getDescription() + ";" + key + ";" + value.toString());
                   }
               }
               putRawValue(KEY_DESCRIPTION, docInfo.getDescription(), rawProperties);
            }
        }
        finally
        {
            if (is != null)
            {
                try { is.close(); } catch (IOException e) {}
            }
        }
        // Done
        return rawProperties;
    }‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I introduce all metadatas in "DESCRIPTION" with a character for separation (for example ";") and with a script (of javascript) extract later that metadatas take as reference the separator and insert in their property of my model.
And in my model i have a type with properties that are the metadatas

In the space where i add the documents i have created a rule with two actions: one for specialyse content to my type and two execute a script which i comment before

i'm Sorry for my bad bad english but i expect help you something

Re: I cannot see metadata values

alf983 — Thu, 10 Jan 2008 16:00:21 GMT

hi durdy,
is it possible to get a filename that i upload with this class?

Re: I cannot see metadata values

durdy48 — Fri, 11 Jan 2008 11:30:27 GMT

Hi,
yes, it's possible because one of the field is the filename

Bye

Re: I cannot see metadata values

alf983 — Mon, 14 Jan 2008 13:24:35 GMT

Which is the field?

Re: I cannot see metadata values

durdy48 — Fri, 18 Jan 2008 12:13:24 GMT

Hi,

All metadatas are in DESCRIPTION and with javascript you must extract the values because there is a character ";" to separate them.
My javascript file is:


var descripcion = document.properties["cm:description"];
 
function result() 
{   
   if(descripcion == null){
      descripcion = "";
   }
   var array = descripcion.split(";");
   for(i=0;i<array.length;i++){
      if(array[i] == 'Area'){
      document.properties["sp:area"] = array[i+1];
   }else if(array[i] == 'Asunto'){
      document.properties["sp:asunto"] = array[i+1];
   }else if(array[i] == 'Autor'){
      document.properties["sp:autor"] = array[i+1];
   }else if(array[i] == 'Categoria'){
      document.properties["sp:categoria"] = array[i+1];
   }else if(array[i] == 'ComGenerales'){
      document.properties["sp:comgenerales"] = array[i+1];
   }else if(array[i] == 'DirigidoA'){
      document.properties["sp:dirigidoa"] = array[i+1];
   }else if(array[i] == 'Dueno'){
      document.properties["sp:dueno"] = array[i+1];
   }else if(array[i] == 'FormatoDoc'){
      document.properties["sp:formatodoc"] = array[i+1];
   }else if(array[i] == 'IdLengua'){
      document.properties["sp:idversion"] = array[i+1];
   }else if(array[i] == 'IdVersion'){
      document.properties["sp:idversion"] = array[i+1];
   }else if(array[i] == 'Localizacion'){
      document.properties["sp:localizacion"] = array[i+1];
   }else if(array[i] == 'NivelDeSeguridad'){
      document.properties["sp:niveldeseguridad"] = array[i+1];
   }else if(array[i] == 'PalabrasClaves'){
      document.properties["sp:palabrasclaves"] = array[i+1];
   }else if(array[i] == 'ProcedeDe'){
      document.properties["sp:procedede"] = array[i+1];
   }else if(array[i] == 'Proyecto'){
      document.properties["sp:proyecto"] = array[i+1];
   }else if(array[i] == 'Resumen'){
      document.properties["sp:resumen"] = array[i+1];
   }else if(array[i] == 'SO'){
      document.properties["sp:so"] = array[i+1];
   }else if(array[i] == 'SoftCreacion'){
      document.properties["sp:softcreacion"] = array[i+1];
   }else if(array[i] == 'SubArea'){
      document.properties["sp:subarea"] = array[i+1];
   }else if(array[i] == 'SubCategoria'){
      document.properties["sp:subcategoria"] = array[i+1];
   }else if(array[i] == 'SubProyecto'){
      document.properties["sp:subproyecto"] = array[i+1];
   }else if(array[i] == 'TipoDoc'){
      document.properties["sp:tipodoc"] = array[i+1];
   }else if(array[i] == 'Titulo'){
      document.properties["sp:titulo"] = array[i+1];
   }else if(array[i] == 'VerSO'){
      document.properties["sp:verso"] = array[i+1];
   }else if(array[i] == 'VerSoftCreacion'){
      document.properties["sp:versoftcreacion"] = array[i+1];
   }else if(array[i] == 'Consejeria'){
      document.properties["sp:consejeria"] = array[i+1];
   }else if(array[i] == 'DG'){
      document.properties["sp:dg"] = array[i+1];
   }else if(array[i] == 'Servicio'){
      document.properties["sp:servicio"] = array[i+1];
   }else if(array[i] == 'Revision'){
      document.properties["sp:revision"] = array[i+1];
   }else if(array[i] == 'Clasificacion'){
      document.properties["sp:clasificacion"] = array[i+1];
   }else{
      
   }
   }
      document.properties["cm:description"] = '';
   document.save();
} 
result();‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

You must create a rule for execute this script when add a document in a concrete space

Bye

Re: I cannot see metadata values

shmoula — Fri, 28 Mar 2008 08:40:48 GMT

Hi! Im solving corresponding problem, any progress here, please? I really dont want to use ughly item;item;item;… parsing solution. Many thanks!

Re: I cannot see metadata values

shmoula — Tue, 10 Jun 2008 21:21:49 GMT

Hi!
Still no patch or any usable solution? Im going crazy with this :evil: :cry:

EDIT:
Got it, thanks to this post: http://forums.alfresco.com/viewtopic.php?p=22694#p22694
But it still isnt a best solution, why i must apply this rule? Why it doesnt "just work"? :roll: