Overview¶
Class tables represent flattened metadata for each M-Files class. They enable:
Reporting and analytics (join with corporate data).
Staging controlled updates back to M-Files.
Data quality remediation (normalization, enrichment, cleansing).
Controlled migration / consolidation scenarios.
Lays foundation for integration with other systems.
Operations with the class tables is built on the core metadata structures and synchronization procedures described in the Working with Metadata section.
Following is a list of the key building blocks for class table operations discussed in more detail in subsequent sections.
Key Building Blocks¶
Create Class Table: - spMFCreateTable - spMFCreateAllMFTables - spMFClassTableStats - spMFClassTableColumns - spMFDropAllClassTables
Update surface: - spMFUpdateTable - spMFUpdateTableinBatches - spMFUpdateTableWithLastModifiedDate - spMFUpdateItemByItem - spMFUpdateMFilesToMFSQL - spMFUpdateAllncludedInAppTables - spMFUpdateObjectChangeHistory - spMFAddCommentForObjects - spMFChangeClass - spMFDeleteObject - spMFDeleteObjectList - spMFUnDeleteObject - spMFGetMfilesLog - spMFGetObjectvers
File Handling: - spMFExportFiles - spMFExportFilesMultiClasses - spMFImportBlobFilesToMFiles - spMFUpdateExplorerFileToMFiles
Internal updates: - spMFTableAudit - spMFUpdateTableInternal - spMFUpdateSynchronizeError - spMFUpdateTable_ObjIDs_Grouped - spMFUpdateTable_ObjIDs_GetGroupedList - spMFGetDeletedObjects - spMFObjectTypeUpdateClassIndex
Logging and control: - spMFProcessBatch_Upsert - spMFProcessBatchDetail_Insert - spMFProcessBatch_Mail - spMFClassTableStats - spMFGetHistory - spMFGetProcedurePerformance - spMFLogError_EMail - spMFResultMessageForUI - spMFSendHTMLBodyEmail - spMFLogProcessSummaryForClassTable
Supporting functions / utilities: - fnMFObjectHyperlink - fnMFExcelObjectHyperlink - fnMFReplaceSpecialCharacter - spMFConvertTableToHtml - spMFCreatePublicSharedLink - spMFSearchForObject - spMFSearchForObjectbyPropertyValues - spMFSetup_Reporting