• search metdata group can not found files

  • OpenKM tiene muchas características interesantes, pero es necesario un proceso de configuración para mostrar todo su potencial.
OpenKM tiene muchas características interesantes, pero es necesario un proceso de configuración para mostrar todo su potencial.
Forum rules: Por favor, antes de preguntar algo consulta el wiki de documentación o utiliza la función de búsqueda del foro. Recuerda que no tenemos una bola de cristal ni poderes mentales, o sea que que para informar sobre un error es necesario que nos indiques tanto la versión de OpenKM que usas como la del navegador y sistema operativo. Para más información consulta Cómo informar de fallos de forma efectiva.
 #48171  by d313226
 
openkm version : 6.3
db : mysql 5.7
os : windows server 2016

I have created a metadata repository and added a metadata group to the file.
https://drive.google.com/file/d/1DdQQYV ... UE1Br/view

When I use metadata search to search for files, some metadata group values can find files, and some metadata group values can't find files.

https://drive.google.com/file/d/1OmupPl ... sp=sharing
https://drive.google.com/file/d/1lEmcns ... sp=sharing

Can anyone help me? Thank you
Code: Select all
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE property-groups PUBLIC "-//OpenKM//DTD Property Groups 2.0//EN"
                                 "http://www.openkm.com/dtd/property-groups-2.0.dtd">
<property-groups>
  <property-group label="產品資訊" name="okg:產品資訊">
    <select label="類型" name="okg:產品資訊.類型" type="simple">
      <option label="Server" value="Server"/>
      <option label="Storage" value="Storage" />
      <option label="Switch" value="Switch" />
      <option label="Firewall" value="Firewall" />
      <option label="Backup_Software" value="Backup_Software" />
      <option label="Hypervisor" value="Hypervisor" />
      <option label="Wireless" value="Wireless" />
      <option label="HCI" value="HCI" />
    </select>
    <select label="品牌" name="okg:產品資訊.品牌" type="simple">
      <option label="HPE" value="HPE"/>
      <option label="Dell" value="Dell"/>
      <option label="Dell_EMC" value="Dell_EMC" />
      <option label="FortiGate" value="FortiGate" />
      <option label="Palo_Alto" value="Palo_Alto" />
      <option label="Cisco" value="Cisco" />
      <option label="Aruba" value="Aruba" />
      <option label="ATI" value="ATI" />
      <option label="Nakivo" value="Nakivo" />
      <option label="Veeam" value="Veeam" />
      <option label="Acronis" value="Acronis" />
      <option label="Nutanix" value="Nutanix" />
      <option label="VMWare" value="VMWare" />
    </select>
    <input label="系列" name="okg:產品資訊.系列"/>
    <textarea label="備註" name="okg:產品資訊.備註"/>
  </property-group>

  <property-group label="文件資訊" name="okg:文件資訊">
    <select label="用途" name="okg:文件資訊.用途" type="simple">
    <option label="sales" value="sales"/>
    <option label="technology" value="technology"/>
    <option label="administration" value="administration"/>
    <option label="finance" value="finance"/>
    <option label="project" value="project"/>
  </select>
    <select label="類型" name="okg:文件資訊.類型" type="simple">
    <option label="授權說明" value="授權說明"/>
    <option label="產品簡介" value="產品簡介"/>
    <option label="報價單" value="報價單"/>
    <option label="招標文件" value="招標文件"/>
    <option label="網路架構圖" value="網路架構圖"/>
    <option label="虛擬平台架構圖" value="虛擬平台架構圖"/>
    <option label="價格表" value="價格表"/>
    <option label="報備單" value="報備單"/>
    <option label="專案合約" value="專案合約"/>
    <option label="公司簡介" value="公司簡介"/>
    <option label="工作計劃書" value="工作計劃書"/>
    <option label="虛擬平台基礎設定表" value="虛擬平台基礎設定表"/>
    <option label="儲存設備基礎設定表" value="儲存設備基礎設定表"/>
    <option label="維護報表" value="維護報表"/>
    <option label="服務建議書" value="服務建議書"/>
    <option label="POC報告" value="POC報告"/>
    <option label="教育訓練教材" value="教育訓練教材"/>
    <option label="驗收報告" value="驗收報告"/>
    <option label="問題修復" value="問題修復"/>
    <option label="使用手冊" value="使用手冊"/>
    <option label="QuickSpec" value="QuickSpec"/>
    <option label="安裝手冊" value="安裝手冊"/>
    </select>
  </property-group>
</property-groups>
 #48185  by jllort
 
The problem is you are using the name in chinese characters "okg:文件資訊.類型" -> several mistakes here:
1- the group should starting with okg, but the field into the group should starting with okp ( P not G )
2- okp:field_name is a key ( l like database unique id, should not use special characters here )
3- you can use chinese character in labels

Consider if you change the name of the field you will be lost the previous values. If you have a lot of files with this metadata field tell us and I will explain the steps for not losing the information after these kinds of changes.
 #48194  by d313226
 
jllort wrote: Thu Jun 13, 2019 6:15 pm The problem is you are using the name in chinese characters "okg:文件資訊.類型" -> several mistakes here:
1- the group should starting with okg, but the field into the group should starting with okp ( P not G )
2- okp:field_name is a key ( l like database unique id, should not use special characters here )
3- you can use chinese character in labels

Consider if you change the name of the field you will be lost the previous values. If you have a lot of files with this metadata field tell us and I will explain the steps for not losing the information after these kinds of changes.
The code I modified after the method you provided is as follows:
Code: Select all
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE property-groups PUBLIC "-//OpenKM//DTD Property Groups 2.0//EN"
                                 "http://www.openkm.com/dtd/property-groups-2.0.dtd">
<property-groups>
  <property-group label="產品資訊" name="okg:prdutionInfo">
    <select label="類型" name="okp:prdutionInfo.type" type="simple">
      <option label="Server" value="Server"/>
      <option label="Storage" value="Storage" />
      <option label="Switch" value="Switch" />
      <option label="Firewall" value="Firewall" />
      <option label="Backup_Software" value="Backup_Software" />
      <option label="Hypervisor" value="Hypervisor" />
      <option label="Wireless" value="Wireless" />
      <option label="HCI" value="HCI" />
    </select>
    <select label="品牌" name="okp:prdutionInfo.brand" type="simple">
      <option label="HPE" value="HPE"/>
      <option label="Dell" value="Dell"/>
      <option label="Dell_EMC" value="Dell_EMC" />
      <option label="FortiGate" value="FortiGate" />
      <option label="Palo_Alto" value="Palo_Alto" />
      <option label="Cisco" value="Cisco" />
      <option label="Aruba" value="Aruba" />
      <option label="ATI" value="ATI" />
      <option label="Nakivo" value="Nakivo" />
      <option label="Veeam" value="Veeam" />
      <option label="Acronis" value="Acronis" />
      <option label="Nutanix" value="Nutanix" />
      <option label="VMWare" value="VMWare" />
    </select>
    <input label="系列" name="okp:prdutionInfo.series"/>
    <textarea label="備註" name="okp:prdutionInfo.note"/>
  </property-group>

  <property-group label="文件資訊" name="okg:documentinfo">
    <select label="用途" name="okp:documentinfo.use" type="simple">
    <option label="sales" value="sales"/>
    <option label="Technology" value="Technology"/>
    <option label="administration" value="administration"/>
    <option label="finance" value="finance"/>
    <option label="project" value="project"/>
  </select>
    <select label="類型" name="okp:documentinfo.type" type="simple">
    <option label="授權說明" value="授權說明"/>
    <option label="產品簡介" value="產品簡介"/>
    <option label="報價單" value="報價單"/>
    <option label="招標文件" value="招標文件"/>
    <option label="網路架構圖" value="網路架構圖"/>
    <option label="虛擬平台架構圖" value="虛擬平台架構圖"/>
    <option label="價格表" value="價格表"/>
    <option label="報備單" value="報備單"/>
    <option label="專案合約" value="專案合約"/>
    <option label="公司簡介" value="公司簡介"/>
    <option label="工作計劃書" value="工作計劃書"/>
    <option label="虛擬平台基礎設定表" value="虛擬平台基礎設定表"/>
    <option label="儲存設備基礎設定表" value="儲存設備基礎設定表"/>
    <option label="維護報表" value="維護報表"/>
    <option label="服務建議書" value="服務建議書"/>
    <option label="POC報告" value="POC報告"/>
    <option label="教育訓練教材" value="教育訓練教材"/>
    <option label="驗收報告" value="驗收報告"/>
    <option label="問題修復" value="問題修復"/>
    <option label="使用手冊" value="使用手冊"/>
    <option label="QuickSpec" value="QuickSpec"/>
    <option label="安裝手冊" value="安裝手冊"/>
    </select>
  </property-group>
</property-groups>
I restarted openkm service.
But the metadate group search still not found any files.

https://drive.google.com/open?id=15C0u_ ... 4pB8kdV-DC
https://drive.google.com/open?id=1TCjJc ... mwugZWk3ue
https://drive.google.com/open?id=1H-cOL ... jytK-kif_0
 #48208  by jllort
 
After applying the change you will not be able to find documents with previous metadata. You will be able to find only documents what you set metadata after applying the change.

Did you have a lot of documents with metadata ( previous you apply the change ). In this case, it will be necessary to apply a migration from the database ( that the step I prefer do not explain if you have few ... if you have few it is better you update manually ).

Also does not have much sense having value in Chinese, consider "value" as a database keys. I'm talking about this section:
Code: Select all
<option label="授權說明" value="授權說明"/>
I suggest use
Code: Select all
<option label="授權說明" value="00001"/>
or
Code: Select all
<option label="授權說明" value="StandardCharsetText"/>
 #48217  by d313226
 
jllort wrote: Sun Jun 16, 2019 8:48 am After applying the change you will not be able to find documents with previous metadata. You will be able to find only documents what you set metadata after applying the change.

Did you have a lot of documents with metadata ( previous you apply the change ). In this case, it will be necessary to apply a migration from the database ( that the step I prefer do not explain if you have few ... if you have few it is better you update manually ).

Also does not have much sense having value in Chinese, consider "value" as a database keys. I'm talking about this section:
Code: Select all
<option label="授權說明" value="授權說明"/>
I suggest use
Code: Select all
<option label="授權說明" value="00001"/>
or
Code: Select all
<option label="授權說明" value="StandardCharsetText"/>
I understand what you mean.
But I have rebuilt the attribute value of the file .
The normal values are also seen in the database.
I still can't find the file. Is there a log for file search?
https://drive.google.com/file/d/1KoXH3M ... sp=sharing
 #48228  by jllort
 
Go to administration > tools > rebuild indexes -> "rebuild the lucene index"
Anyway I can not believe after you have corrected the metadata group -> you set fields in a new document -> you are not able to find this document by this fields ( obviously fields what previously were wrong will not be found -> should correct database and rebuild indexes ).

About Us

OpenKM is part of the management software. A management software is a program that facilitates the accomplishment of administrative tasks. OpenKM is a document management system that allows you to manage business content and workflow in a more efficient way. Document managers guarantee data protection by establishing information security for business content.