MS4BI HELP 2019

by MS4script
01-Introduction
Preface & Copyright
Getting started
Demos Simple
02- Declarations
Structure
Type
03- Instructions
Conditions if,do,while..
String functions Str..()
Get + Include functions Get, Include..
Date-Time Day, Time, Year.
Display
Call
Formulas Complex
04- Database
Connector Ado, Odbc, Dsn, SAP, Ms4
Connect DB Create, delete
Import DataSource Import, Consolidation
Administration Admin, User
05- Sql-Query
Sql
Query Form : BTS,SHOW
Grid option
06- Charts
Forms Show, 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.
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 Special
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
14- Cloud.
Account Open
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
     

BASIC HELP : MS4BI by MS4script 2019 version 1

Chapter 14 : CLOUD

KEYWORD : MYCLOUD_ACCOUNT_OPEN

Definition

The OPEN function: opens a feed between your PC and your CLOUD account.
All the MS4BI objects used when running the MS4scripts (charts, reports, dashboards, menus...) will automatically be transferred to your CLOUD account In a Master directory : HOME followed by the date and time => HOME/Date/Time
Warning: account identification is implicit and identified when an MS4BI SERVER & CLOUD professional licence is purchased.

Syntax

 	 	
 			MyCloud_Account_Open();
  	
	

Example

 		   
BEGIN
MyCloud_Account_Open();
...
  
END ;
	
	

KEYWORD : MYCLOUD_ACCOUNT_CONNECT

Definition

The CONNECT function: connects to the Cloud account via MS4SCRIPT for viewing & managing charts, reports & dashboards

Syntax

 		 
	
			MyCloud_Account_Connect();
 	
	

Example

 		   
BEGIN
MyCloud_Account_Open();
...
MyCloud_Account_Connect();

END ;

	

Remarks

MyCloud_Account_Open() is MANDATORY !

KEYWORD : MYCLOUD_ACCOUNT_UPLOADINPROGRESS

Definition

The UPLOADINPROGRESS function enables all charts, reports & dashboards to be uploaded from the PC to the Cloud account when the MS4script is run.

Syntax

 		 
			MyCloud_Account_UploadInProgress();
 	
	

Example

 		   

BEGIN
MyCloud_Account_Open();
   MyCloud_Account_UploadInProgress();
   
	 ConnectDB{Ms4DB}(LEnvDemoExcelDB); 
	FormShow :	DrawPIE , title :" Business 2011 by  EMPLOYEE " , ANGLE :120 , 
	TYPE : $STANDARD, FORMAT: "$"  use View  ("[ms4EmplTotalBusiness2011]");
  
  MyCloud_Account_Connect();
END ;	
	

Remarks

MyCloud_Account_Open() is MANDATORY!

KEYWORD : MYCLOUD_ACCOUNT_UPLOAD

Definition

The UPLOAD function: used to transfer a file to the Cloud account when the MS4script is run.

Syntax

 		 
MyCloud_Account_Upload ("-your PC file" or string : "to a new Filename" or string) return TRUE(1) or FALSE(0);
 	
	

Example

 		   
BEGIN
MyCloud_Account_Open();
MyCloud_Account_setCurrentDirectory($HOME);  

END ;

BEGIN
  
display "Please wait : CLOUD upload from PC to website ";		
	 
  	 MyCloud_Account_UpLoad("analysisScenarii.xls":VarUpload ) return (iReturn );
 		 if (iReturn = TRUE)
			 then
				MsgBox : Title "MS4BI CLOUD   "
				Message : "   Upload Ok for : ",VarUpload
				Button : Mb_OK 
				Icon : MB_ICONASTERISK   ;
			 Else
				MsgBox : Title "MS4BI CLOUD "
				Message : "  UpLoad Not Ok"
				Button : Mb_OK 
				Icon :  MB_ICONHAND   ;

			End_if ;  
			   
END ;	

Remarks

MyCloud_Account_Open() is MANDATORY !

KEYWORD : MYCLOUD_ACCOUNT_DOWNLOAD

Definition

The DOWNLOAD function: used to transfer a file from the Cloud account to the PC when the MS4script is run.

Syntax

 		 
MyCloud_Account_Download ("-your CLOUD ACCOUNT File " or string   : "to new PC filename " or string) return TRUE(1) or FALSE(0);
 	
	

Example

 
TEXT : VarUpload  :=  "ExampleFileMycloud.xls";
integer :  TRUE := 1, FALSE := 0,   
BEGIN
 MyCloud_Account_Open();
MyCloud_Account_setCurrentDirectory($HOME); ** HOME      Standard MS4BI Cloud : HOME/Date/Time

END ;

BEGIN
 
display "Please wait : Downloading from myCLOUD to Computer ";		
	integer : iReturn ;
  	 MyCloud_Account_DownLoad(VarUpload :"analysisScenarii_DownLoad.xls") return (iReturn );
 		 if (iReturn = FALSE)
			  Then
				MsgBox : Title "MS4BI My CLOUD Account  "
				Message : "   Download Ok for : ",VarUpload
				Button : Mb_OK 
				Icon : MB_ICONASTERISK   ;
			 Else
				MsgBox : Title "MS4BI My CLOUD Account  "
				Message : "  DownLoad Not Ok : File not found or already exists on the PC .."
				Button : Mb_OK 
				Icon :  MB_ICONHAND   ;

			End_if ;  
			    
			   
END ;

 

Remarks

MyCloud_Account_Open() is MANDATORY!

KEYWORD : MYCLOUD_ACCOUNT_CREATEDIRECTORY

Definition

The CREATEDIRECTORY function is used to create a specific directory in the Cloud account via MS4SCRIPT, sending charts, reports & dashboard directly.

Syntax

 		  	
	
MyCloud_Account_CreateDirectory("your DirectoryName-" or string) return TRUE(1) or FALSE(0);
 	
	

Example

 		   
text : NewDirectoryShowDemo := "MyWorkShop-20190526";
BEGIN
 integer : iReturn ;
 MyCloud_Account_Open();
 MyCloud_Account_setCurrentDirectory($HOME); ** HOME      Standard MS4BI Cloud : HOME/Date/Time
 MyCloud_Account_CreateDirectory(NewDirectoryShowDemo)return (iReturn);  
  if(iReturn  = 1)
 then
	Display " CreateDirectory Dir OK   ";
 else
	Display " CreateDirectory Dir not OK  ";
 End_if ;
END ;	
	

Remarks

Open the feed: MyCloud_Account_Open() is MANDATORY!
Position yourself before creating your directory: MyCloud_Account_setCurrentDirectory($HOME); $HOME = your CLOUD account HOME directory

KEYWORD : MYCLOUD_ACCOUNT_DELETEDIRECTORY

Definition

The DELETEDIRECTORY function is used to delete a given directory on the Cloud account using MS4SCRIPT.

Syntax

 		  	
	
MyCloud_Account_DeleteDirectory("your DirectoryName-" or string) return TRUE(1) or FALSE(0);
 	
	

Example

 		   
BEGIN
 MyCloud_Account_Open();
 MyCloud_Account_setCurrentDirectory($HOME); ** HOME      Standard MS4BI Cloud : HOME/Date/Time
 MyCloud_Account_CreateDirectory("CreateDir1"); 
 MyCloud_Account_CreateDirectory("CreateDir2");
 MyCloud_Account_CreateDirectory("CreateDir3");
END ;
integer : iReturn ;
BEGIN
**  delete directory 2
 

MyCloud_Account_DeleteDirectory("CreateDir2") return (iReturn);  
  if(iReturn  = 1)
 then
	Display " Delete Dir OK   ";
 else
	Display " Delete Dir not OK  ";
 End_if ;
 Display "ENTER.............";
 enter ;
END ;

MyCloud_Account_Connect();
	

Remarks

Open the feed : MyCloud_Account_Open() is MANDATORY!
Position yourself before deleting your directory : MyCloud_Account_setCurrentDirectory($HOME); $HOME = your CLOUD account directory.

KEYWORD : MYCLOUD_ACCOUNT_DELETEFILE

Definition

The DELETEFILE function is used to delete a file on the Cloud account via MS4SCRIPT

syntax

 		  	
	
MyCloud_Account_DeleteFile("your Filename-" or string) return TRUE(1) or FALSE(0);
 	
	

Example

 		   
TEXT : VarUpload  :=  "ExampleUploadFile.xls";
integer : iReturn ,TRUE := 1, FALSE := 0,
 BEGIN
 MyCloud_Account_Open();
MyCloud_Account_setCurrentDirectory($HOME); ** HOME      Standard MS4BI Cloud : HOME/Date/Time

END ;

BEGIN
  
  	 MyCloud_Account_DeleteFile(VarUpload ) return (iReturn );
 		 if (iReturn = TRUE)
			 then
				MsgBox : Title "MS4BI My CLOUD Account  "
				Message : "  Delete File Ok : ",VarUpload
				Button : Mb_OK 
				Icon : MB_ICONASTERISK   ;
			 Else
				MsgBox : Title "MS4BI My CLOUD Account  "
				Message : "  Delete File Not Ok : not found"
				Button : Mb_OK 
				Icon :  MB_ICONHAND   ;

			End_if ;  
			    
			   
END ;
	

Remarks

Open the feed : MyCloud_Account_Open() is MANDATORY!
Position yourself before deleting the file : MyCloud_Account_setCurrentDirectory($HOME); $HOME = your CLOUD account HOME directory.

KEY WORD : MYCLOUD_ACCOUNT_RENAMEFILE

Definition

The RENAMEFILE function is used to rename a file on the Cloud account via MS4SCRIPT

Syntax

 		  	
	
MyCloud_Account_RenameFile("your SourceFileName  -" or string :" your RenamedFileName -" or string ) return TRUE(1) or FALSE(0);
 	
	

Example

 		   
TEXT : VarUpload  :=  "ExampleUploadFile.xls";
integer : iReturn ,TRUE := 1, FALSE := 0,
 
BEGIN
MyCloud_Account_Open();
MyCloud_Account_setCurrentDirectory($HOME); ** HOME      Standard MS4BI Cloud : HOME/Date/Time

END ;

BEGIN
 
  	 MyCloud_Account_RenameFile(VarUpload :"RENAME_ExampleUploadFile.xls") return (iReturn );
 		 if (iReturn = TRUE)
			 then
				MsgBox : Title "MS4BI My CLOUD Account  "
				Message : "  Rename File Ok : ",VarUpload
				Button : Mb_OK 
				Icon : MB_ICONASTERISK   ;
			 Else
				MsgBox : Title "MS4BI My CLOUD Account  "
				Message : "  Rename File Not Ok : not found"
				Button : Mb_OK 
				Icon :  MB_ICONHAND   ;

			End_if ;  
			    
			   
END ;
	

Remarks

Open the feed : MyCloud_Account_Open() is MANDATORY !
Position yourself before renaming the file: MyCloud_Account_setCurrentDirectory($HOME); $HOME = CLOUD account HOME directory.

Prerequisites

CLOUD functions are only available with a professional MS4BI SERVER & CLOUD licence.

Remarks

All examples: driver:\MondaySoftware\MS4BI\02-DEMO-DESKTOP-BI-EXCELandSTANDARD\11-CLOUD



Interested in our project? contact@monday-software.com
The Monday Software team


Copyright 2020 by Monday Software

the official sites :
www.monday-software.com
www.ms4bi.com
demos.ms4bi.com
getms4bi.com
getms4bifree.com
cloud.ms4bi.com
cloud.testing.ms4bi.com
www.ms4script.com

Our purpose : Keep it simple !


written with ms4script
  • MS4BI v.01.0027.01.2020
  • MS4BIRE v.01.0021.10.2019
  • MS4SCRIPT v.01.0027.01.2020
  • help 06/2019

MS4BI in 5 minutes