- When looking for a document in NuGenesis LMS by keyword search (full text search), the search results do not include the expected documents
- At least one section in the documents contains the keyword
- The document sections contain Microsoft Word, Excel, or PowerPoint data
- NuGenesis 8 LMS
- NuGenesis 8 ELN
The document sections contain data in the Microsoft Office 2007+ file formats. NuGenesis LMS uses the Oracle Text option and its "AUTO_FILTER" technology to index the document contents. In Oracle 11.2, the AUTO_FILTER can index the Office 2007+ file formats, but LMS does not store these files in the database in that format. It stores the files in the OLE Compound Binary File format, and the filter cannot index the 2007+ files if they are inside Compound Binary files.
FIX or WORKAROUND
- If the section is available as a separate .docx, .xlsx, or .pptx file, attach that file to the LMS document section; LMS does not wrap the section attachments into OLE Compound Binary files, so the AUTO_FILTER can index the section attachments.
- If the section is not available as a separate file, open the section, save it to a file on disk, and then attach the file.
- If possible, save the file in the Office 2003 file format, and insert it into LMS documents via drag-and-drop.
- If the section was inserted via a section template, either modify the section template to use the 2003 file format or enable the "CF_TEXT" rendition:
- Click the LMS main menu > Administration > Section Management
- Select a section template. If it's approved, click the Modify button
- Select the Renditions tab
- Click the "Check OLE Renditions" button
- LMS displays the available renditions for the section template. Excel and Word offer a "CF_TEXT" rendition; choose this rendition for these section types
- Save and approve the section template
- LMS can index the CF_TEXT renditions, and the renditions are updated automatically as users edit the sections
This limitation is due to the limitations of the AUTO_FILTER technology in Oracle 11.2.
The attached SQL script can display the indexed search terms for a given LMS document.