Difference between revisions of "Knowledge:Utilities"
From OpenKM Documentation
| Line 31: | Line 31: | ||
<source lang="sql"> | <source lang="sql"> | ||
update OKM_NODE_DOCUMENT set NDC_TEXT_EXTRACTED='F' where NBS_UUID in (select NBS_UUID from OKM_NODE_BASE where NBS_PARENT='folder-uuid'); | update OKM_NODE_DOCUMENT set NDC_TEXT_EXTRACTED='F' where NBS_UUID in (select NBS_UUID from OKM_NODE_BASE where NBS_PARENT='folder-uuid'); | ||
| + | </source> | ||
| + | |||
| + | == List missing datastore document == | ||
| + | <source lang="java"> | ||
| + | import com.openkm.module.db.stuff.*; | ||
| + | import com.openkm.dao.bean.*; | ||
| + | import com.openkm.dao.*; | ||
| + | |||
| + | for (NodeDocumentVersion ndv : NodeDocumentVersionDAO.getInstance().findAll()) { | ||
| + | File file = FsDataStore.resolveFile(ndv.getUuid()); | ||
| + | |||
| + | if (!file.exists()) { | ||
| + | print("Missing file: " + file); | ||
| + | } | ||
| + | } | ||
</source> | </source> | ||
Revision as of 12:43, 8 October 2012
Contents
Show text extracted from document
HQL
select nd.uuid, nd.textExtracted, nd.text from NodeDocument nd where nd.uuid='document-uuid';
SQL
select NBS_UUID, NDC_TEXT_EXTRACTED, NDC_TEXT from OKM_NODE_DOCUMENT where NBS_UUID='document-uuid';
Show text extracted of folder children documents
SQL
select NBS_UUID, NDC_TEXT_EXTRACTED, NDC_TEXT from OKM_NODE_DOCUMENT where NBS_UUID in (select NBS_UUID from OKM_NODE_BASE where NBS_PARENT='folder-uuid');
Force document text extraction
HQL
update NodeDocument nd set nd.textExtracted=false where nd.uuid='document-uuid';
SQL
update OKM_NODE_DOCUMENT set NDC_TEXT_EXTRACTED='F' where NBS_UUID='document-uuid';
Force document text extraction of folder children documents
SQL
update OKM_NODE_DOCUMENT set NDC_TEXT_EXTRACTED='F' where NBS_UUID in (select NBS_UUID from OKM_NODE_BASE where NBS_PARENT='folder-uuid');
List missing datastore document
import com.openkm.module.db.stuff.*;
import com.openkm.dao.bean.*;
import com.openkm.dao.*;
for (NodeDocumentVersion ndv : NodeDocumentVersionDAO.getInstance().findAll()) {
File file = FsDataStore.resolveFile(ndv.getUuid());
if (!file.exists()) {
print("Missing file: " + file);
}
}
