CLR and internal procedures

Procedures and functions used by Connector

The following list of procedures and functions are used by the Connector to call the assemblies or called by another procedure. These procedures are divided into those that is specifically related to the use of the assemblies, and those that is called by other procedures.

The CLR procedures process the SQL procedure calls into M-Files. These procedures do not have any scope for user modifications. Issues with or suggestions for improvement can be raised with MFSQL Connector Support.

Procedure/Function	General use
spMFGetClass	CLR procedure used to get class details from M‑Files
spMFGetLoginAccounts	CLR procedure used to get login accounts from M‑Files
spMFGetObjectType	CLR procedure used to get object types from M‑Files
spMFGetProperty	CLR procedure used to get properties from M‑Files
spMFGetUserAccounts	CLR procedure used to get user accounts from M‑Files
spMFGetValueList	CLR procedure used to get value lists from M‑Files
spMFGetWorkFlow	CLR procedure used to get workflows from M‑Files
spMFGetWorkFlowState	CLR procedure used to get workflow states from M‑Files
spMFInsertClass	Insert class details into MFClass
spMFInsertClassProperty	Insert class property details into MFClassProperty
spMFInsertLoginAccount	Insert login account details into MFLoginAccount
spMFInsertObjectType	Insert object type details into MFObjectType
spMFInsertProperty	Insert property details into MFProperty
spMFInsertUserAccount	Insert user account details into MFUserAccount
spMFInsertValueList	Insert value list details into MFValueList
spMFInsertValueListItems	Insert value list items into MFValueListItems
spMFInsertWorkflow	Insert workflow details into MFWorkflow
spMFInsertWorkflowState	Insert workflow state details into MFWorkflowState
spMFSearchForObjectByPropertyValuesInternal	Search for an object in M‑Files using property id and value
spMFSearchForObjectInternal	Search for objects in M‑Files
spMFSynchronizeClasses	Synchronize MFClass with M‑Files
spMFSynchronizeLoginAccount	Synchronize MFLoginAccount with M‑Files
spMFSynchronizeObjectType	Synchronize MFObjectType with M‑Files
spMFSynchronizeProperties	Synchronize MFProperty with M‑Files
spMFSynchronizeValueList	Synchronize MFValueList with M‑Files
spMFSynchronizeUserAccount	Synchronize MFUserAccount with M‑Files
spMFSynchronizeValueListItems	Synchronize MFValueListItems with M‑Files
spMFSynchronizeWorkflow	Synchronize MFWorkflow with M‑Files
spMFSynchronizeWorkflowsStates	Synchronize MFWorkflowState with M‑Files
spMFUpdateTableInternal	Insert/update object details in a class table
spMFUpdateClass	Update class metadata table
spMFLogError_EMail	Send exception details by email
fnMFParseDelimitedString	Convert key/value pairs to table data
fnMFSplitString	Split comma‑separated values to table data
fnMFCapitalizeFirstLetter	Capitalize the first letter of each word
fnMFReplaceSpecialCharacter	Remove special characters from strings
tMFOnError_SendEmail	Send email if an error is inserted into MFLog
spMFCreateClassTableSynchronizeTrigger	Create the class table synchronization trigger
spMFGetObjVers	Call the CLR procedure spMFGetObjVersInternal
spMFGetMissingObjectIds	Get objids of missing objects
spMFGetObjectVersInternal	Get object versions of a class
cardconf.InitializeRules	Create rules for card configuration routines
cardconf.spMFCardPropertiesJson	Produce JSON for properties
cardconf.spMFCardPropertiesUpsert	Update card configuration properties
cardconf.spMFMetadatacardJson	Produce metadata card JSON
spMFGetContextMenu	Vault application access to context menu
spMFGetMFilesAssemblyVersion	Get M‑Files version for assembly
spMFGetMFilesLatestVersion	Get latest M‑Files version
spMFGetMFilesLogInternal	Get XML for event logs
spMFInsertUserMessage	Insert user message into table
spMFLogProcessSummaryForClassTable	Produce process summary for a table
script.CreateDeleteHistoryJob	Installation script to create agent for deleting log records
spMFGetAction / spMFGetProcessStatus / spMFTableControlLog / spMFGetFilesInternal / spMFUpdateLastExecutedB / spMFUpdateCurrentUserIDForAction / spMfGetProcessStatus / spMFGetContextMenuID	Vault application helpers and control/logging procedures