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.
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.
Post Reply
d313226
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: Wed Jun 12, 2019 4:05 am

search metdata group can not found files

Post by d313226 » Wed Jun 12, 2019 4:34 am

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>

jllort
Moderator
Moderator
Posts: 10876
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: search metdata group can not found files

Post by jllort » 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.

d313226
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: Wed Jun 12, 2019 4:05 am

Re: search metdata group can not found files

Post by d313226 » Fri Jun 14, 2019 7:44 am

Thanks for your help. I will return the test results

d313226
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: Wed Jun 12, 2019 4:05 am

Re: search metdata group can not found files

Post by d313226 » Fri Jun 14, 2019 8:24 am

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

jllort
Moderator
Moderator
Posts: 10876
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: search metdata group can not found files

Post by jllort » 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"/>

d313226
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: Wed Jun 12, 2019 4:05 am

Re: search metdata group can not found files

Post by d313226 » Mon Jun 17, 2019 1:56 am

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

jllort
Moderator
Moderator
Posts: 10876
Joined: Fri Dec 21, 2007 11:23 am
Location: Sineu - ( Illes Balears ) - Spain
Contact:

Re: search metdata group can not found files

Post by jllort » Wed Jun 19, 2019 1:49 pm

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 ).

Post Reply