spMFSynchronizeClasses

Signature

EXEC dbo.spMFSynchronizeClasses
    @VaultSettings = N'<settings>',
    @Debug = 0,
    @Out = NULL OUTPUT,
    @IsUpdate = 0,
    @ProcessBatch_ID = NULL OUTPUT;

Returns

INT: 1 on success; -1 on error.

Parameters

@VaultSettings

• Type: NVARCHAR(4000)

• Required: Yes

• Description: Vault settings (e.g., from fnMFVaultSettings()).

@Debug

• Type: SMALLINT

• Required: No (default = 0)

• Description: Debug level. - 1 = Standard Debug Mode - 101 = Advanced Debug Mode

@Out

• Type: NVARCHAR(MAX)

• Required: No (OUTPUT)

• Description: XML result.

@IsUpdate

• Type: SMALLINT

• Required: No (default = 0)

• Description: When set to 1, push updates from SQL to M-Files.

@ProcessBatch_ID

• Type: INT

• Required: No (OUTPUT)

• Description: References the ID of the ProcessBatch logging table.

Purpose

Internal procedure to synchronize classes Used by spMFSynchronizeMetadata and spMFSynchronizeSpecificMetadata

Changelog

Date	Author	Description
2024-06-05	LC	add processbatch_id for logging
2019-08-30	JC	Added documentation
2018-04-04	DEV2	Added Module validation code
2017-12-3	LC	Prevent MFID -100 assignements to be included in update
2017-09-11	LC	Resolve issue with constraints
2016-09-26	DevTeam2	Removed vault settings and pass them as comma separate string in @VaultSettings parameter.
2015-10-01	DevTeam2	Create proc