spMFSetup_Reporting

Signature

EXEC dbo.spMFSetup_Reporting
    @Classes = N'Customer, Purchase Invoice',
    @Debug = 0;

Returns

INT: 1 on success; -1 on error.

Parameters

@Classes

  • Type: NVARCHAR(MAX)

  • Required: Yes

  • Description: Comma-delimited class names to include (e.g., ‘Customer, Purchase Invoice’).

@Debug

  • Type: SMALLINT

  • Required: No (default = 0)

  • Description: Debug level.

Purpose

Custom script to prepare database for reporting

Additional Info

The following will be automatically executed in sequence

  • test Connection

  • Update Metadata structure

  • create class tables

  • create all related lookups

  • create menu items in Context menu

On completion login to vault and action update reporting data to update class tables from M-Files to SQL

Alternatively use spMFUpdateTable to pull records into class table

Warnings

The procedure is useful to create a limited number of classes for reporting (max 10) at a time.

Examples

EXEC [spMFSetup_Reporting] @Classes = 'Customer, Drawing'
                            ,@Debug = 0   -- int

SELECT * FROM MFContextMenu

Changelog

Date

Author

Description

2022-05-25

LC

Change approach to only update selected tables

2022-03-17

LC

add additional automated functionality

2022-01-26

Lc

Fix valuelist creation

2019-09-27

LC

Adjust to setup context menu group for access

2019-05-17

LC

Set security for menu to MFSQLConnector group

2019-04-10

LC

Adjust to allow for context menu configuration in different languages

2019-01-31

LC

Fix bug for spmfDropandUpdateTable parameter

2018-11-12

LC

Create procedure