# USER MANUAL
Database

General Information Table modes and table accesses Multi-user table access Exclusive table access Admin Mode Creating a database table Creating Database Table Link Pages Creating and deleting subordinate tables Data types in a table Description of the form of the table View table Browse Groups Go to number Going to a descendant table Going to the parent table Select (select) a row and column Hiding and showing columns | Calculating column amount Sort Fetching Table Rows View table properties Adding Rows Change Rows Column replacement Removing Rows Database table changes Changes to the table and list table Changes to table and list properties Column property changes Delete columns Insert columns Set, Cancel, Change Password View and select all parent rows in subordinate tables Charts Value Tables

1. ## General information

   - A site database is a set of tables belonging to external pages.
   - A page database is a set of tables belonging to an external page.
   - You can apply: just a table, 2 related tables, 3 related tables.
   - Communication in the tables is carried out according to the dynamic key (number in order) in the ratio of 1 to many.
   - The heading of the subordinate table is always the value of the columns. the parent table in which the "Template" field, the first character is the "+" character.
   Each table has the following functional:

   entry of table rows, changing table rows, deleting table rows, insert table rows, adding table rows, replacing data in rows of a table, hiding table columns, unhiding columns, change the default values, summarize numerical columns, sorting table rows, selection of table rows, | setting the group size, group navigation setting up a monopoly, cancel of monopoly, password setting, password reset, go to line, table printing, print table properties, add and remove buttons, editing the codes of the inserted buttons, table changes: changes to column properties: type, heading, default value, value conditions, notation; delete a column; insert a column.

   Database tables are created from a template by changing it using administrator commands.
   Each of the tables can be opened in the mode:
   1. administrator
   2. add and / or view.

   ##
   1. Table operating modes and table accesses

   ### Multi-user access to the table.

   This access, for all users, is established by opening the table from the site’s pages, clicking on the link to the table, however, many users can:
   1. browse tables,
   2. selection,
   3. sort
   4. view the properties of the table,
   5. print tables,
   6. add rows to the table with or without a password if no password has been set.

   ### Exclusive access to the table

   Multiuser access is canceled, and exclusive access is established, admin team “Establish a monopoly.”
   Multiuser access is restored by the “Cancel Monopoly” command in administrator mode.

   ### Admin Mode

   set by opening the table from the CMS. To open in this mode:
   1. On the site, click on the ENTER link.
   2. Enter your password.
   3. If logged in as an administrator, click the "Administrator" link.
   4. In the "List of Internal Pages" table, click the "Page Name" column in the row of the page in which the database is created or in which the table will be created.
   5. In the "Page Objects" table, click in the "Name" column to open the table.
   6. Exclusive access is required to perform the following tasks:
      1. in the table and in the list tables:
         1. deleting table rows,
         2. insert table rows,
         3. insert deletion change table columns
      2. in the list tables of list fields:
         1. deleting table rows,
         2. insert table rows,
         3. insert deletion change table columns
         4. editing table rows
         5. editing table buttons
   After the monopoly is established, access by all users except the administrator is blocked until the monopoly is canceled. If at this moment the user makes requests to the server, he will receive a message about blocking access. After performing the above work, the administrator cancels exclusive access.

   ##
   2. Creating a database table

   Tables are created as external pages of internal pages. They are created in the CMS, in the form of "Page Objects". To create tables:
   1. On the site, click on the ENTER link.
   2. Enter your password.
   3. If you are logged in as an administrator, click the "Administrator" link.
   4. In the "List of Internal Pages" table, click the "Page Name" column in the row of the page in which the database will be created.
   5. Click the “st1” button to insert a table on a page, “st2” to insert 2 related tables on a page, “st3” to insert 3 related tables on a page.
   6. Click the row of the created table, in 1 column.
   7. Change the name to the required one and click the "Change" button.
   8. Repeat the 3 preceding paragraphs as many times as there are tables on the selected inner page.
   9. To create tables on other internal pages, in the List of Internal Pages table, click the column for the following page and continue with p. "Click the" st1 "," st2 "," st3 "button."
   NOTES:
   1. Do not change the number of the table, it defines the table and its related pages of links.
   2. You can create a table as an external page, for this, in the "number" field, enter the number in the form of 0.00,000 [table serial number], the selected date and the entered number must not coincide with the date and the number that is already in the table row.

   ##
   3. Create link pages of the database table

   To set links to pages, they (these pages) must be created. They are created in the CMS, in the form of "Page Objects."
   To create link pages:
   1. On the site, click the ENTER link.
   2. Enter your password.
   3. If logged in as an administrator, click the "Administrator" link.
   4. In the List of Internal Pages table, click the Page Name column in the row of the page in which the database is created.
   5. In the "Page Objects" table, select the created database by clicking and click the "show" button.
   6. Form opens:
   7. Check the "template" checkbox if you want to add a page from a previously created template copying it.
   8. Click the + button.
   9. Click the line of the created page.
   10. Change the name to the required one and click the "Change" button.
   11. Repeat the 3 preceding paragraphs as many times as there will be link pages (rows in the base table).
   NOTES:
   1. Do not change the page number of the link; it determines whether the link belongs to the database table.
   2. You can convert the link page into an external page, for this in the "number" field enter the number without 0,00,000 and the symbol v, click the "Change" button.
   Sort by table.
   1. A table can be sorted by any column.
   2. To sort in ascending order, check the “Ascending” box.
   3. To sort in descending order, clear the “Ascending” checkbox.
   4. Click the header, in 1 row, the column by which you want to sort.
   5. To cancel sorting, click the selected column in the header (second click).
   Transition in the table.
   1. To go to the end of the table, click the down arrow button.
   2. To go to the beginning of the table, click the up arrow button.
   Selection in the table.
   1. Click the header, in line 2, the column by which you want to select.
   2. In the "filter" field, enter a list of selection contexts.
   3. A list of contexts, these are contexts separated by a "/" character.
   4. Rows are selected by matching contexts from the list with any part of the text of the selected column.
   5. Rows are selected for the number in order, according to the complete coincidence of the number values and the list of values.
   6. To select, click “Select”.
   7. To deselect, click Cancel.
   Print the table.
   1. To print the table, click the P button.
   2. Printing is subject to selection and sorting.

   ##
   4. Create and delete subordinate tables

   In the current version of the CMS, an unlimited number of subordinate lower-level tables can be created. This allows you to create a database with an improved structure.
   To create and / or delete subordinate tables:
   1. On the site, click the Enter.
   2. Enter your password.
   3. If logged in as an administrator, click the Administrator link.
   4. In the PAGE OBJECTS table, click the table to be modified and the table opens.
   5. Open the subordinate lower-level table by clicking on the "Go to child" button.
   6. Click the "A" button to open the admin commands.
   7. Set monopoly, if not set, by clicking on the Set Monopoly button.
   8. Click the "Change tables" button - a form will open:
   9. To delete a table, mark it in the X column.
   10. To add a table, on the last line, enter the table name.
   11. Click the "+" button to add the last line.
   12. To change the name of the table, click in the Name column and change the name.
   13. Click the Execute button to save your changes.
   14. The first table is not dropped!
   15. The first table at the first opening of the form has no name, please enter it!
   16. To close the form without saving changes, click the X button.

   ##
   5. Data types in the table

   The table may contain columns with the following types of data
   1. t - text (input of any characters except # is allowed, input of tags except < br > (from a new line) and & nbsp; (space) is prohibited;
   2. d - date (dates can be entered in a certain interval and in a specific format);
   3. i - an integer (input of integers is allowed, in a certain interval);
   4. $ - money (money can be entered with an accuracy of a penny, in a certain interval);
   5. L - list (combo box) (it is allowed to select and display the text value from 2 columns, from the list table);
   6. a - link (you can select a link to an external page from a variety of external internal pages, with certain requirements for page names or any page of a site.)
   Some Data Properties
   1. You can prevent data from changing in the column by placing the ^ character at the end of the header.
   2. You can set unique values by placing the ~ character at the end of the header.
   3. You can hide the table columns of the lookup field by placing the * character at the end of the header.
   4. You can enter values in 2 columns and only from the global data table, if at the end of the header put the symbol =.

   ##
   6. Table form description

   Fig. 1. The table form is open in multi-user access by clicking on the link on the site page.

   Fig. 1-1. The table form is opened in administrator mode in exclusive access by clicking by the link from the table of the “PAGE Objects” form

   #### The form consists of:

   - Table names.
   - Fixed row of column numbers.
   - of the table itself.
   - Message lines and replacements.
   - input fields.
   - control buttons.
   - Group volume selection switches.
   - Chart Switches.
   - Fields for entering the line number and buttons for the transition.
   - Information about the total number of lines and the number of lines displayed.

   ##
   7. View table

   - When opening a table, by default, a group of the last 10 rows entered is displayed.
   - If the table has columns with unique values, all rows are displayed.
   - The table is viewed in groups.
   - To change the number of rows in a group, click one of the “Rows in group” radio buttons and then one of the “To Group” buttons.

   ##
   8. Browse Groups

   - Click the radio switch with the desired group size.
   - Click one of the buttons: “1 group”, “last group”, “previous group”, “next group”.

   ##
   9. Go to the number

   - In the field per line, enter the line number to which you want to go.
   - Click the Go! button.
   To go to the line with contexts from the list of contexts
   - In the field to the left of the “To!” button, enter the transition contexts in the form of fragments of text through the separator /
   - Click the “To!” button.
   - A transition will be made from the row in which the selected column contains (in any part) context from the entered list of contexts.
   - Transitions are completed by issuing the message “End”.

   ##
   10. Go to child table

   If we work with related tables to go to the descendant (son, grandson).
   - In the parent table, click the row you want.
   - Click the "Subordinate Linked Table" button (to the left of the ENTER header).
     or just click an empty space in the last column of the page

   ##
   11. Go to parent table

   - Click the Parent Table button (to the left of the ENTER heading).

   ##
   12. Row and column selection

   Selecting a row and column is necessary to execute many commands.
   - To select a row and column, click the highlighted column in the highlighted row.
   - To select a column, click the corresponding input field.

   ##
   13. Hide and show columns

   For more convenient viewing of rows, hiding and showing columns is provided.
   - To hide the column, after selecting it, click Hide Column (H).
   - You can hide all columns except the checkmark column.
   - To display all columns, click Show All Columns (V).

   ##
   14. Column sum calculation

   - Click a numeric or monetary column.
   - Click the S button, the sum value appears in the column input field.

   ##
   15. Sorting

   - Sorting is performed on the rows of the group, taking into account the selection and hiding of columns.
   - Sort by one column.
   - To sort, highlight the sort column and click Sort Ascending or "Sort Descending."
   - To cancel the sort, click Cancel Sort.

   ##
   16. Table row selection

   - Selection is made over the lines of the group by clicking the "!" button or the "only" button.
   - Reverse selection is performed on the lines of the group by clicking the “!” button with an overline or the “except” button.
   - The selection is made on the server above all the lines when the “!!” button is clicked, and a group is formed.
   - The selection is made for all columns except "N pp" and "link".
   - Selection by list fields is performed not by field value, but by key.
   - The list of keys can be obtained by clicking on the corresponding condition field.
   - To include a value in the selection list, click the cell with that value and click the “+?” button.
   - To select, click the question mark button.
   - To deselect, click the crossed out question mark button.
   - The table list opens.
     Figure 3. A window for changing the value of the list box appears if you click the select box
   - In the “Selection” column, select the checkboxes in those rows, by the values of which you want to select and click the “In selection” button.
   1. A selection form will open, in the selection fields for which rows in the "Selection" column have been marked in the forms of list fields and the "In selection" button has been clicked lists to select are displayed.
      Fig. 2. The selection window appears if you click "Open the selection form"
   2. Enter the selection data in the selection fields and click the “Select” button.
   3. When entering into the list selection field, use the / symbol as a separator. The selection list can be set:
   4. To enter values on a selection of numerical fields, use the result in the calculator
   5. To enter an arithmetic expression or number in the input field, enter a number or expression.
      Click the expression field in the calculator.
      Click "=".
      Click the select box.
   6. To enter dates in the selection fields, click the date in the calendar and then click the selection field.
   7. To cancel the selection, click the “Cancel” button.
   8. To deselect a single column, click the row in the “Name” column.
   9. To clear the selection fields, click the "C" button.
   10. To close the selection form, click “X”.
   11. You can cancel the selection by clicking on the button with a crossed out question mark.

   ### Selection lists

   List of samples is a list of conditions for sampling.
   Each table has a selection list.
   Fig. 2-1. Selection List Controls
   Add a selection to the list
   1. Enter or change the selection conditions.
   2. Enter the name of the selection in the input field.
   3. To add to the end of the list, click “add”.
   4. To add before fetching: open the list, click the selection before which you want to add and click "insert before".
   5. To add after the selection: open the list, click the selection after which you want to add and click "insert after".
   Change a selection from a list
   1. Open the list, click on the selection you want to change.
   2. Change the selection conditions.
   3. Click edit.
   Removing a selection from the list
   1. To delete a selection: open the list, click on the selection you want to delete and click “delete”.
   2. To delete the entire list, click “erase”.
   Saving the selection list
   1. To save the changes to the selection list, click save.

   ##
   17. View table properties

   Fig. 2. The table properties window appears if you click button 1, ...

   ##
   18. Adding Rows

   Adding lines is available:
   - for admin,
   - for a user who knows the password,
   - for all users if the table password is not set or canceled.
   To add a table row:
   - Select the last row of the table and click the "Insert after" button, or click "Add to the end".
   - A row appears with the serial number “?” and column values equal to “default values”.
   - To temporarily change the default values, select the row of the value table you want to make default values and click the "d" button.
   - In the same way, you can move a table row.

   ##
   19. Row change

   Changing table rows is available:
   - for admin,
   - for a user who knows the password,
   - for all users if the table password is not set or canceled.
   For change:
   - Click the row of the table you want to change.
   - Click the input field:
   - if the input field: text, integer, money, date, edit the value;
   - if field: link, list, the corresponding list opens,
   - click the desired row of the table and click "Replace".
   - click the next row of the table you want to edit and edit it;
   - finish editing the last line by clicking on it.
   - Modified rows are marked with an “r” in the “r x” column.
   - to save changes to the server, after entering all the changes, or part of the changes, click "Save to server".
   It is recommended that you save your changes more often. If the text to be edited is large, you can edit it in a large window, for this click “Edit in a large window”, The following form will open.
   Fig. Large text editing window
   Edit the text and click “replace”, or simply close the form by clicking “cancel”.
   NOTE: The text is not allowed to enter tags, except for a tag with a new line (< br >).

   ### Copy columns

   Executed by the administrator in exclusive mode over the group, taking into account the selection.
   - in the “what’s changing” field, enter the number of the column to be copied,
   - in the field “for what we change”, enter the number of the column where you will copy,
   - columns must be of the same type,
   - click the copy column button,
   - click the save button.

   ### Fill Columns

   Executed by the administrator in exclusive mode over the group, taking into account the selection.
   1. For numeric columns (integer, money):
      - Filling with a single value
        - click a digital column,
        - in the “what are we changing” field, enter the value,
        - click the edit button.
      - Filling with a counter
        - click a digital column,
        - in the “what are we changing for” field, enter the value starting value counter and + or - sign, for example: 1 +, 100-,
        - click the edit button.
      - Change of values by the operation of adding reduction of multiplication and division
        - click a digital column,
        - in the field for "what is changing", enter the value value and the sign of the operation, for example: + 1, -20, * 0.01, / 30,
        - click the edit button.
   2. For date columns:
      - Filling with a single value
        - click the date column,
        - in the field “change what” enter the date value, for example: 01.12.2011,
        - click the edit button.
      - Filling with a counter
        - click the date column,
        - in the field “for what we change”, enter the stating date and the + sign, for example: 01/01/2016+,
        - click the edit button.
   3. For text columns:
      - Filling with a single value
        - click the column with texts,
        - in the “what are we changing” field, enter the date value, for example: Start,
        - click the edit button.
      - Adding a counter at the beginning of texts
        - click the column with texts,
        - in the field “for what we change”, enter the static value and the + or - sign, for example: 1 +, 500-,
        - click the edit button.
      - Add text at the beginning of texts
        - click the column with texts,
        - in the “what are we changing” field, enter the & sign and the text to be added, for example: &This is the beginning,
        - click the edit button.
      - Add text to the end of texts
        - click the column with texts,
        - in the “what are we changing” field, enter the added text & sign, for example: This is the end of &,
        - click the edit button.

   ##
   20. Column replacement

   - Click the column you want to replace.
   - In the “what are changing” field, enter the search text.
   - In the field “for what” we change, enter the replacement text.
   - Click the replace button.
   - Context substitution is performed for the first search context found.
   - No replacement is done for fields of type “a”.
   - Search and replace for a field of type “L” (list) is performed by key.

   ##
   21. Deleting table rows

   Removing lines of lines is available to the administrator, in exclusive mode:
   - Click to select a row in the table and check the “x” box.
   - Follow these steps with all deleted rows.
   - To mark all rows of the table for deletion, click the check / uncheck box.
   - To delete table rows on the server, click Save On Server.

   ##
   22. Database Table Changes

   All changes to the tables are performed in administrator mode, in exclusive access (except for password commands).

   1. #### Changes in the table and the list table:

      1. deleting lines: check the "x" box;
      2. insert table rows:
         - click to select the row of the table relative to which the insert will be,
         - click the "Paste in front of the selected" button if you want to paste to,
         - click the "Insert after highlighted" button if you want to paste after,
      3. editing rows in a table list, see the section "Editing a row",
      4. To save the changes to the server, after entering all the changes, or part of the changes, click “Save to server”.

   2. #### Changes to table and list properties:

      To execute the following commands, click the "Administrator Commands" button, the following window will open:
   3. Click the Set Monopoly button
   4. Click the “X”.
   5. Click the column that you will: change, delete, relative to which you will insert.
   6. Clicking the “Administrator Commands” button again will open the following window:

   7. #### Column Properties Changes

   8. Click "Change column."
   9. Change the properties by editing and selecting, and click "To save, click me."
   10. You can prevent data from changing in the column by placing the ^ character at the end of the header.
   11. You can hide the table columns of the lookup field by placing the * character at the end of the header.
   12. You can enter values in 2 columns and only from the global data table, if you put the = symbol at the end of the header.

   13. #### Delete columns

       Click the Admin Commands button, click “Delete Column”, the agreement window opens:
       To delete click “OK”, to cancel click “Cancel”.

   14. #### Insert columns

       - A column is always inserted to the right of the selected column.
       - Click the Admin Commands button,
       - Click "Insert Column", a window opens:
       - Change the properties by editing and selecting, and click "To save, click me."
   15. You can prevent data from changing in the column by placing the ^ character at the end of the header.
   16. You can hide the table columns of the lookup field by placing the * character at the end of the header.
   17. You can enter values in 2 columns and only from the global data table, if you put the = symbol at the end of the header.

   18. #### Set, Cancel, Change Password

       Click the Admin Commands button, Click "Save Password", the following window will open:
       - to set or change the password, enter the password and click “install”,
       - to cancel the password, click "remove",
       - to discard the intention to change the password, click cancel.

   19. #### View and select rows of all parents in subordinate tables

       - To get all the lines, click the "G" button.
       - To cancel all lines, click the "G" button.

   20. #### Graphs

       The data of any table can be presented in the form of graphs.
       To enable the display of charts, the following conditions must be met:
       - 2 column must contain numerical data, this data is accepted as X axis values and should not contain duplicate or identical values.
       - Graph data (Y axis), this is the data of numeric columns to the right of column 2.
       - The graph includes the values of the group, taking into account the selection.
       - To turn on the graphs display, click the “Graphs 1 or 2” switch.
       - To turn off the display of charts, click the “No charts” switch.
       - Click the red point on the graph to show the exact values.
       - To display the calculated intermediate values, click the line on the graph.
       - To go to the graph view, click on the column in the 1nd row of the table header.
       Fig. 1-2. The graph form is opened by clicking on the column number in the table in 1-column mode.

       Fig. 1-2. The graph form is opened by clicking on the column number in the table in 2 column mode.