MS4BI®

MS4BI HELP 2022

by MS4script
01-Introduction
Preface & Copyright
Getting started
Informations + Cmd/param Server
Demos Simple
02- Declarations
Structure
Type
03- Instructions
Conditions if,do,while..
Char/Text functions Char or Text..()
Get + Include functions Get, Include..
String functions String# (hashtag)
Date-Time Day, Time, Year.
Display
Call
Formulas Complex
04- Database
Connector Ado, Odbc, Dsn, SAP, Ms4
DB Connect Create, delete
Import DataSource Import, Consolidation
Administration Admin, User
05- Sql-Query
Sql
Query Form : BTS,Plus
Grid option
06- Charts
Forms Plus, Win, Image, Excel, Morris...
Pie Std, Donut, 3D...
Bar Std, Stack, Line, Area, Plot
Radar
QrCode, Gauge
Step, Stock...
,Google,Leaflet... GeoMap
,Gantt,Timeline,Org.
DrawWindow [web]
07- Dashboard
Form tab, no tab
Responsive UI
08- Report
Report Hierarchy
Report Design
09- Filters
Dialogue + Call
10- Menus
Menu Design
Menu Frameset
Menu Custom
11-UI : Responsive
Tables Responsive,Frame,position
List Group
Text
Panel Header, body, Footer
Button Button, Progress Bar
Icon & Button
Collapse Group, Panel
Notifications
12- Encryption
Encrypt
Decrypt
13- Windows
Dialogue
Picture, Frame, Button..
MsgBox
Grid

Designer

00-OverView
01-Transaction
02-Setting
05-Import
10-Formula
15-Report-Part1
16-Report-Part2
20-Query-Part1
21-Query-Part2
25-Report-Query-Style
30-QrCodeImage
31-Windows
32-Frame
40-TabStrip
50-Collapse
60-BeginForm
63-Input-SubmitBox
70-Input-Select
71-Input-Insert
72-Input-Update
73-Input-Delete
75-Input-Query
77-ListComBo
81-Button-Link
82-Button-DataList
86-Sticky-Label
91-Insert-PhpJsHtml
92-Insert-MS4script
15- Css, html, Php, js.
Insert Native language Begin_sw..End_Sw
16-Install + tools.
Installation & Configuration This Menu
Generate Native... Php, Html, js..
Code Generator Ms4 Script
MarkDown Ms4 Script
Source Code Menu Help This Menu
written with ms4script

MS4BI for Windows & Internet : Dynamic SQL & Query & Data & Charts
Reports, UI & Excel Consolidation..

HELP 2022 : Chapter 16 : INSTALLATION and TOOLS

MS4BI - Ultra Light, Ultra Simple, Ultra Agile, Responsive

ULTRA SIMPLE INSTALLATION:



6 essential steps:

1 -Presentation

2 -Select the destination driver

3 -Accept the agreement

4 -Select the ADO manager

5 -Check Start Demo (optional)

6 -Demo

note: Sentinel: Security and licence : Mandatory



Installation step 1: Presentation

Installation step 2: Driver

Installation step 3: Agreement

Important: YES : I accept agreement

Installation step 4: Microsoft Data Access 32bit-ADO

Important:This download will install a set of components that can be used to facilitate transfer of data between Microsoft Office System files and non-Microsoft Office applications MS4BI : Import Excel (xls,xlsx), ADO (Access,Dbf,Txt,csv,SqlServer......):
See : \MandragorePlanete\MS4BI\zDriversADO

Installation step 5: Start Demo!

Installation step 6: Demo + MS4BI Designer


Minimum Configuration

    WINDOWS

  • Windows XP to Windows 11 Version 32/64 bits
  • Windows Server 2008, 2012
  • 120 Mb disk space
  • 4-8 Gb RAM
  • Graphic: 1366x768
  • Screen: 15"
  • Microsoft: ADO, ODBC AccessDataBase Engine 32bits, Sqlite3, MySql, SqlServer, Oracle
  • SGDB MS4DB
  • MS4BI® and Ms4script® language x86 Windows: integrates with other languages:html, javascript, php, css..

Optimum Configuration :

    WINDOWS

  • Windows XP to Windows 11 Version 32/64 bits
  • Windows Server 2008,2012
  • 120 Mb disk space
  • 16-32 Gb RAM
  • Graphic: 1920x1080
  • Screen: 15/17"
  • Microsoft: ADO, ODBC AccessDataBase Engine 32bits, Sqlite3, MySql, SqlServer, Oracle
  • SGDB MS4DB
  • MS4BI® and Ms4script® language x86 Windows: integrates with other languages:html, javascript, php, css..

PHP Server + Database

  • PHP Windows x86 , version 7.2.11 Oct 2018
  • SQLITE3 PHP x86 , version SQLite version 3.20.1
  • SQLITE3 x86 Windows , version SQLite version 3.36 nov 2021

Web Navigator

  • Chrome
  • Edge
  • FireFox
  • Safari
  • others..




Interested in joining us? contact@mgplanete.com
The Mg Planete team


Copyright 2022 by Mandragore Planete

the official sites :
mgplanete.com
getms4bi.com
demos.ms4bi.com
help.ms4bi.com
ms4script.com

Download

official site :
getms4bi.com

Our purpose : Keep it simple !


written with ms4script
  • help 01.010.2022.8

MS4BI in 5 minutes