Alfresco TEngine Excel Metadata Extractor
by Angel Borroy
Community
Custom Alfresco Transform Engine that extracts metadata from Excel files and maps it to Alfresco residual properties, compatible with ACS 25.x Community and Enterprise.
About
Transforms Excel files (application/vnd.ms-excel and related mimetypes) to alfresco-metadata-extract using configurable extraction rules.
- Extracts rows from a named worksheet and maps them to the Alfresco residual property
rows - Accessible from server-side JavaScript via
document.properties["{}rows"] - Rules configured in
ExcelMetadataExtractor_configuration.properties(target sheet, anchor header) - Deployable as a local T-Engine (Community:
localTransform.excel.url) or async T-Engine (Enterprise: queueexcel-engine-queue) - Trigger via Alfresco Share folder rules: Items are created or enter this folder → Mimetype is Microsoft Excel → Extract common metadata fields