Топ-100
 
CerebroSQL

Master Data (MDM)

 

Description of the " Master-data (MDM) " table

Viewing data in tables is possible through the built-in  query editor for "SQLite" databases

The work in the mode with the central database is supported.
To configure the program to work in this mode, use the following instruction

Master data is a structured catalog of data stored in randomly constructed cards of pages created in the master.

MDM - allows you to structuredly store arbitrary information, descriptions of systems, networks, servers, databases, contacts, products, etc.

MDM supports work both with the local storage of the program and in the mode using a single repository. 

 
Launching the master data manager

 

In the main window of the program, click the " Master Data Management " button

CerebroSQL - run master data.jpg
CerebroSQL - master data show.jpg
 
Control buttons
CerebroSQL - master data control button.

Page creation wizard

Creating root entries for the object tree

Adding a node to a tree

Refresh object tree

Card creation

Refresh the structure of the current card and display the data

Card search

Moving a card to another node

Remove card / empty node

 

Creating a page for storing data

 

Launch the page creation wizard

cerebroSQL - show master create page.jpg
 
Control buttons
CerebroSQL - create page control button.

Create a new page

Create a directory

Add item to page

Move element to another node

Export / import page

Refresh the page list

Remove item from page

​​

  • Click the " Create new page " button

  • In the " Value " field, enter the name of the page

  • Close the catalog editor window

 
CerebroSQL - create new page.jpg
Adding an element to the created page

  • Select a page (element on a page) in the "Page structure" list

  • Expand the "Add new element" menu and select the required elements from the list  

CerebroSQL - add new element in page.jpg
 
Item parameters

To configure the parameters of an element:

  • Select an item in the tree

  • Press the button "Show and edit parameter

  • Save the entered parameters by clicking the "Save" button

 
SPLITTER
CerebroSQL - splitter parameter.jpg

It is an element consisting of 2 connected panels.

Align - the position of the element on the form.

  • Top - press the element to the top of the form

  • Left - push the element to the left edge of the form

  • Right - press the element to the right edge of the form

  • Botton - press the element to the bottom edge of the form

  • Client - the element takes up the entire space of the form

AlignWithMargin - padding along the edges of the element

RealTimeDrag - False, a mask is displayed showing the new position of the strip. True, the bar moves as you move the mouse.

HotSpotVisible - show button to resize panels

Percent - the percentage occupied by the first panel of the total width

Height - the height of the element

Width - the width of the element

LockBar - prohibit changing panels with the mouse using the resize button

Orientation - the orientation of the panels relative to each other.

 
GROUPBOX
CerebroSQL - groupbox parameter.jpg

Panel with additional decoration in the form of a frame around and a title

Align - the position of the element on the form.

  • Top - press the element to the top of the form

  • Left - push the element to the left edge of the form

  • Right - press the element to the right edge of the form

  • Botton - press the element to the bottom edge of the form

  • Client - the element takes up the entire space of the form

AlignWithMargin - padding along the edges of the element

Height - the height of the element

Width - the width of the element

Style name - element style name

Caption - title

Font size - font size

 
LABEL
CerebroSQL - label parameter.jpg

Text label

Align - the position of the element on the form.

  • Top - press the element to the top of the form

  • Left - push the element to the left edge of the form

  • Right - press the element to the right edge of the form

  • Botton - press the element to the bottom edge of the form

  • Client - the element takes up the entire space of the form

AlignWithMargin - padding along the edges of the element

Font size - font size

Layout - vertical arrangement of text on an element

  • Center - in the center

  • Top - press the text to the top

  • Bottom - press the text to the bottom

Caption - text

Style name - element style name

Height - the height of the element

Width - the width of the element

Aligenment - horizontal position of text on an element

  • Left - press the text to the left corner

  • Center - text in the center of the field

  • Right - press the text to the right corner

 
EDIT
CerebroSQL - edit parameter.jpg

Text input field

Align - the position of the element on the form.

  • Top - press the element to the top of the form

  • Left - push the element to the left edge of the form

  • Right - press the element to the right edge of the form

  • Botton - press the element to the bottom edge of the form

  • Client - the element takes up the entire space of the form

AlignWithMargin - padding along the edges of the element

Height - the height of the element

Width - the width of the element

Font size - font size

CharCase - text case

  • normal - text in any case

  • upper - uppercase text

  • lower - lowercase text

TextHint - hint for entering text. The tooltip is displayed in an empty field

NumberOnly - the field contains only numbers

Style name - element style name

 
PAGE CONTROL
CerebroSQL - page control parameter.jpg

Pages panel - initially empty, pages are created separately

Align - the position of the element on the form.

  • Top - press the element to the top of the form

  • Left - push the element to the left edge of the form

  • Right - press the element to the right edge of the form

  • Botton - press the element to the bottom edge of the form

  • Client - the element takes up the entire space of the form

AlignWithMargin - padding along the edges of the element

TabHeight - page header height

Font size - font size

Width - the width of the element

Height - the height of the element

Style name - element style name

 
PAGE
CerebroSQL - page parameter.jpg

Page for the " Page control "

Caption - page title

 
RADIOGROUP
CerebroSQL - radiogroup parameter.jpg

An element that allows you to select one of the values

Align - the position of the element on the form.

  • Top - press the element to the top of the form

  • Left - push the element to the left edge of the form

  • Right - press the element to the right edge of the form

  • Botton - press the element to the bottom edge of the form

  • Client - the element takes up the entire space of the form

AlignWithMargin - padding along the edges of the element

Columns - the number of columns

Caption - title

WordWrap - output text to multiple lines

Style name - element style name

Font size - font size

Height - the height of the element

Width - the width of the element

" Content " block - values ​​for the element

Using query - values ​​for the element are generated by a SQL query

If Using query is not set, a list of values ​​must be specified in the field. One value per line

 
PANEL
CerebroSQL - panel parameter.jpg

Item for storing other items

Align - the position of the element on the form.

  • Top - press the element to the top of the form

  • Left - push the element to the left edge of the form

  • Right - press the element to the right edge of the form

  • Botton - press the element to the bottom edge of the form

  • Client - the element takes up the entire space of the form

AlignWithMargin - padding along the edges of the element

Height - the height of the element

Width - the width of the element

Style name - element style name

 
COMBOBOX
CerebroSQL - combobox parameter.jpg

Drop-down list

Align - the position of the element on the form.

  • Top - press the element to the top of the form

  • Left - push the element to the left edge of the form

  • Right - press the element to the right edge of the form

  • Botton - press the element to the bottom edge of the form

  • Client - the element takes up the entire space of the form

AlignWithMargin - padding along the edges of the element

DropDownCount - the number of lines in the visible part of the drop-down list

Height - the height of the element

Width - the width of the element

Style name - element style name

Style - the style of the element

  • DropDown - allow value input

  • DropDownList - no values ​​entered

Block " Default data "

List - a list of values. One value per line

SQL - query to get a list of values

Previously introduced - the values ​​previously entered into this field. Works with Style = DropDown

 
RICHEDIT
CerebroSQL - richedit parameter.jpg

Multiline text box

Align - the position of the element on the form.

  • Top - press the element to the top of the form

  • Left - push the element to the left edge of the form

  • Right - press the element to the right edge of the form

  • Botton - press the element to the bottom edge of the form

  • Client - the element takes up the entire space of the form

AlignWithMargin - padding along the edges of the element

ScrollBar - scroll bars

  • None - do not show the scrollbar

  • Both - horizontal and vertical scroll bar

  • Horizontal - only horizontal scrollbar

  • Vertical - only vertical scrollbar

PlainText - which format RichEdit works with. False - RTF format, True - plain text

Style name - element style name

WantTabs - can I enter a tab character

WordWrap - wrap text for long lines

Font size - font size

Width - the width of the element

Height - the height of the element

 
Arrangement of elements

A number of elements (panel, groupbox, splitter, page) can serve as parent elements for other elements.

The number of nesting elements is not limited.

 
Moving items

Created elements can be moved both within the current parent object and to another level.

Moving items at the current level

  • Select an item in the tree

  • Press the "Element up" button to move up or "Element down" to move down

 

The position of the element on the level depends on its position when creating the page

Moving an item to another level

  • Select an item in the tree

  • Press the "Move element" button

  • In the window that opens, in the tree, select a new location for the element

  • Press the "Move" button

CerebroSQL - move element.jpg
 
Removing an item

To remove an item:

  • Select an item in the tree

  • Press the "Delete element" button

Important: the removal of elements is performed in cascade, i.e. both the selected element and all its child objects are deleted.

 
Creating lookup tables

A number of page elements support retrieving data using SQL queries. 

The data for these queries can be formatted in the form of reference tables.

To create a dictionary table, start the dictionary creation wizard by clicking the "Create or edit the library tables" button

 
Directory creation wizard
CerebroSQL - reference books.jpg
Creating a table
  • Press the button "Create new reference book"

  • In the "Tablename" field, enter a new name for the lookup

  • Enter a comment in the "Comment" field (optional)

  • Add columns

  • In the "Column name" field, enter the name of the column

  • Select the data type from the "Column data type" drop-down list

  • Click the "Add column" button

  • Save the table by clicking the "Save" button

Important : The table will not be created until you click the "Save" button

The program does not support deleting columns in the created table.

Adding columns is possible after creating the table

  • Select a table in the "List table

  • Press the "Edit" button

  • Add columns

  • Save by clicking the "Save" button 

 
Adding an entry
  • Select a table in the "List table"

  • Press the "New" button

  • Fill in the fields in the "Edit data" block

  • Two fields ( id and create_dttm ) are not allowed to be edited, they are displayed for informational purposes.

  • Save the record by clicking the "Save" button

Important: in the "Edit data" block, the columns are displayed in the reverse order in relation to the table structure

Changing a record
  • Select a table in the "List table"

  • Select a table record in the "Table data" list

  • Change the value of the field in the "Edit data" block

  • Two fields ( id and create_dttm ) are not allowed to be edited, they are displayed for informational purposes.

  • Save the record by clicking the "Save" button

Delete entry

  • Select a table in the "List table"

  • Select a table record in the "Table data" list

  • Press the "Del" button

CerebroSQL - edit data reference book.jpg
 
Deleting a lookup table
  • Select the reference table in the "List table"

  • Press the " Delete reference boock " button

 

Export/import page

CerebroSQL - start export page master.jp
 
Exporting a page

In the "Page configurator" window in the "Page structure" tree, select a page

  • Expand the "Export/import page" menu

  • Select "Export page

  • If it is necessary to unload the reference tables as well, select them in the "Library" list by setting the checkboxes

  • Press the " Export " button 

  • The log of the operation will be displayed in the  "Log" field 

  • The export file will be created in the directory .\Config\export\<Card name>.crd

The export file is a SQLite database with a password of 221122 and aes-256 encryption algorithm

CerebroSQL - export card.jpg
 
Importing a page
  • Expand the "Export/import page" menu

  • Select "Import page

  • In the "Container" field, specify the full path to the export file

  • If you need to import a card with a new name, then indicate it in the "New card name" field

  • If a card previously created in the same database is imported, then set the "Generate new ID element" radio button 

  • Select the data loading mode in the "Type load card" block

    • Create new - create a new card

    • Replace exists - to recreate an existing card. The data saved in the card is not deleted earlier, only the card metadata is replaced

    • Add new element - add new elements to an existing card

  • Select the method of loading reference tables in the "Type load library" block

    • Load new - load only new directories

    • Drop and create - pre-execute the command to delete imported directories into the storage

  • Press the " Import " button

  • The data loading log will be displayed in the "Log" field

CerebroSQL - import card.jpg
 

Master data

CerebroSQL - master-data.jpg
 
Creating tree nodes
  • Click the " Create node " button

  • In the " Value " field, enter the name of the node

  • Save the value in the directory by clicking the " Save " button

 
Tree formation
  • Select a node in the tree for which you want to add a child object

  • Clicked the " Add node " button

  • Select an entry from the " Parent list "

  • Click the " Insert children " button

CerebroSQL - add node.jpg
 
Create a card
  • Fill in the fields of the card. Mandatory field " Page name (tree view) "

  • In the " Tree the object " tree, select the node in which you want to create a record

  • Expand the " Add new page " menu

  • Select the card to fill out

CerebroSQL - create new card.jpg
CerebroSQL - creating new card data.jpg
 
Editing a Saved Card
  • Open the card for viewing (by selecting it in the tree or find it through the search)

  • Press the " Edit page " button

  • Make changes to the page

  • Save changes