QuickStart Basics Main Editor Control MQL Script Versioning & Deployment SQL Database | Extract Transform and Load Remote access | Extract Transform and Load Others | Extract Transform and Load Enterprise Service Bus All execution methods | Service Oriented Architecture User and right | Service Oriented Architecture Group and right | Service Oriented Architecture Web Application Framework Data Quality Machine learning Clustering Job / CRON /Scheduler Sequence Global parameters System Backup/Restauration Install server with H2 Database Install server with MySQL8/MariaDB Database Start the server Start the editor Show the server stop ID, and stop the server in command line Stop the server with OS command Change the admin developer password Change the system and admin web password Configure the parameter SERVER_NAME Configure the parameter SERVER_MODE Comment Management Variable environments Basic data types Basic statement Basic operator Create a script Method: post get put delete exe conf app Update/Merge a script Delete a script Use 'Execute' method to execute a script (synchronous) Use 'Include' method to execute a script (synchronous) Use 'Call' method to execute a script (synchronous) All scripts are automatically REST APIs Function 'mode' to switch to a good environment Show input/output Show the MQL history Show DEVEL (development) tab Show CONNECT (add connections) tab Show ADMIN (server administration) tab Show the connected MentDB Server Show maintenance mode Show the help command line Show the server version Show the complete server identity Show the ai firstname Show the ai lastname Show a remote directory list by selection Load a remote file by selection Use full screen (input/output) Add a new MQL input Clear input/output Close all outputs in same time Change the font size History recall Cut/Copy/Paste Undo/Redo Show log files Download remote files (from the current directory) Upload local file (to the current directory) Show the current download/upload directory Eval selected MQL only (Execute portions of codes) Show MQL/TEXT differences Show all MentDB processes Show all H2/MySQL processes Show all shortcuts Show the legal notice Show MQL samples Reconnect the editor after a timeout Switch to another MentDB Server with one Editor Refresh remote MentDB Server list Browse scripts Create your first script Edit a script (by double click) Edit a script (by name selection) Copy one script Copy many scripts Rename one script Rename many scripts Show users granted to a script Show group granted to a script Grant a group to one script Ungrant a group to one script Grant a group to many scripts Ungrant a group to many scripts Show update history for a script Add job to a script Delete one script Delete many scripts Execute a script (result in input/output) Execute immediate a script Copy the execution 'Execute' source code (into the clipboard) for a specific script Copy the execution 'Stack' source code (into the clipboard) for a specific script Copy the execution 'Include' source code (into the clipboard) for a specific script Copy the execution 'Call' source code (into the clipboard) for a specific script Copy the execution 'Concat' source code (into the clipboard) for a specific script Commit a MQL Script Check commit for a script group Commit script group Show all commits for a specific group Check or deploy MQL scripts Generate ETL script Create a new database connection Ping a database Generate MQL to SELECT on a database Generate MQL to INSERT/UPDATE/DELETE/ALTER on a database Executer a SQL transaction Get a single value from a SQL table Get a single row in JSON format from a SQL table Generate MQL to PARSE_AND_ACTION on table Manage remote block on a remote SQL table Encode SQL value (against SQL injection) Show all tables from a database Generate MQL to COUNT on table Generate MQL to SELECT on table Generate MQL to import data from a remote database to a local database Show table description Show table data Generate MQL to ETL_DB_TO_DB on table Generate MQL to ETL_CSV_TO_DB on table Generate Web-Service to SELECT on table Generate Web-Service to INSERT on table Generate Web-Service to UPDATE on table Generate Web-Service to DELETE on table Generate MQL to EXPORT a table into multiple format (csv/xml/json...) Generate SQL to CREATE a table on table Get the database connection configuration Update a database connection Delete a database connection Create a remote CIFS connection Add a folder into a CIFS connection List a folder from a CIFS connection Delete a folder from a CIFS connection Update a remote CIFS connection Delete a remote CIFS connection Create a remote FTP connection Generate MQL to DOWNLOAD files from a remote FTP connection Generate MQL to UPLOAD files to a remote FTP connection Add a folder into a FTP connection List a folder from a FTP connection Delete a folder from a FTP connection Update a remote FTP connection Delete a remote FTP connection Create a remote sFTP connection Generate MQL to DOWNLOAD files from a remote sFTP connection Generate MQL to UPLOAD files to a remote sFTP connection Add a folder into a sFTP connection List a folder from a sFTP connection Delete a folder from a sFTP connection Update a remote sFTP connection Delete a remote sFTP connection Create a remote FTPs connection Generate MQL to DOWNLOAD files from a remote FTPs connection Generate MQL to UPLOAD files to a remote FTPs connection Add a folder into a FTPs connection List a folder from a FTPs connection Delete a folder from a FTPs connection Update a remote FTPs connection Delete a remote FTPs connection Create a remote SSH connection Add a folder into a SSH connection List a folder from a SSH connection Delete a folder from a SSH connection Update a remote SSH connection Delete a remote SSH connection Create an IMAP connection (to download mail) Generate MQL to DOWNLOAD mails/attachements from an IMAP connection UPDATE an IMAP connection Delete an IMAP connection Create a POP3 connection (to download mail) Generate MQL to DOWNLOAD mails/attachements from a POP3 connection UPDATE a POP3 connection Delete a POP3 connection Create a SMTP connection (to send mail) UPDATE a SMTP connection Delete a SMTP connection Create a MentDB Server connection Update a MentDB Server connection Generate MQL to EXECUTE MQL thought tunnel functions Generate MQL to EXECUTE HOT MQL thought tunnel functions Delete a MentDB Server connection All functions Parse a CSV file and integrate row into a SQL Database Read a SQL Database and write a CSV file Parse a HTML document and get data Parse a JSON Array file and integrate row into a SQL Database Read a SQL Database and write a JSON Array file Parse a JSON Object file and integrate row into a SQL Database Read a SQL Database and write a JSON Object file Parse a XML file and integrate row into a SQL Database Read a SQL Database and write a XML file Excel(X) to SQL Database SQL Database to Excel(X) Parse a regular text file and integrate row into a SQL Database Read a SQL Database and write a regular text file Parse a no-regular text file and integrate row into a SQL Database Read a SQL Database and write a no-regular text file Read a text file Write a text file Append a text file Copy a binary file to local (by tab of byte) Copy a text file to local (line by line) Copy a remote binary file to local (from MentDB Server) Copy a remote text file to local (from MentDB Server) Copy binary file to remote (to MentDB Server) Copy text file to remote (to MentDB Server) Watch a directory and execute a MQL script when the directory change (insert/update/delete... a file) Parse a multivalued string Call secure or not external REST API (methode POST/PUT/DELETE/GET) without JSON body Call secure or not external REST API (methode POST/PUT) with JSON body Call secure or not external SOAP API MongoDB: Basic usage Show all mail to send/error SSH: SCP from/to Generate a Word(X) document from a template (replace tags from the template) PDF: generate a PDF from a HTML page PDF: compress image into a PDF if possible Show a process by PID Show the stack lines Show the stack processes Show the stack logs Set MQL delay on a stack process Set the priority for a script into the stack Set the max number of threads for a script into the stack Coming soon...Configure the script to log for the stack Coming soon...Priority for a script into the stack Coming soon...Max number of threads for a script into the stack Coming soon...Use 'Stack' method to execute a script (asynchronous) Coming soon...File logs (log trace : rolling + 30Mb by default) Coming soon...Logs in database (log write) Coming soon...Processes and logs tables (stack_*..., logs) Coming soon...Insert logs in parent script Coming soon...Insert logs in child script Coming soon...Find processes Coming soon...Find process logs Coming soon...Stack access Coming soon...Install 'Supervision' application Coming soon...Find logs in Supervision Coming soon...Find business logs (key, value) Coming soon...Use 'Execute' method to execute a script (synchronous) Coming soon...Use 'Call' method to execute a script (synchronous) Coming soon...Use 'Include' method to execute a script (synchronous) Coming soon...Use 'Stack' method to execute a script (Asynchronous) Coming soon...Use 'Tunnel' method to execute a script (synchronous) Coming soon...Use 'CRON-JOB' method to execute a script (synchronous) Coming soon...Use 'Cluster' method to execute a script (synchronous) Coming soon...Use 'MQL throught WEB Application' method to execute a script (synchronous) Coming soon...Use 'Eval function' method to execute a script (synchronous) Coming soon...Parallel Calculation Coming soon...Use 'Auto-REST API' method to execute a script (synchronous) - Quick APIsation Coming soon...Web portal API access Create a new user Delete a user Coming soon...Default Restricted User Get all current MentDB sessions Get the current MentDB session id Get all current Web-Socket sessions (bot) Show user groups for a user Show user scripts for a user Grant a group to a user Ungrant a group to a user Update a user password (except admin) Grant group 'api-mql' to a user Grant group 'api-ai' to a user Grant group 'api-rest' to a user Ungrant group 'api-mql' to a user Ungrant group 'api-ai' to a user Ungrant group 'api-rest' to a user Create a new group Delete a group Show a group object Show users for a group Show scripts for a group Grant a user to a group Grant a script to a group Grant many scripts to a group Ungrant a user to a group Ungrant a script to a group Ungrant many scripts to a group Generate CRUD application Show all WEB applications Create a WEB application Show virtual hosts for a specific WEB application Add virtual host to a WEB application Delete virtual host from a WEB application Restart the WEB server into MentDB Server Coming soon...Web portal access Coming soon...Restarting the Web Server Coming soon...Create an application Coming soon...SAJAX Tech: Ajax server side without WS (Callback) Coming soon...JSON environment of a Web application Coming soon...Default User: admin and system Coming soon...Generated JSP and files Coming soon...Generated MQL scripts (Organization of scripts) Coming soon...Table organization Coming soon...Router script Coming soon...Change the menu of your web application Coming soon...Adding new web pages Coming soon...Return SQL result on a page Coming soon...Parameter passing between Web pages Coming soon...Navigation between pages Coming soon...Add HTML code directly to a page Coming soon...Addition of HTML code on 'onload' event Coming soon...SCRUD Generator Coming soon...Add a form to perform MQL Coming soon...Add a button to perform MQL Coming soon...Display of a modal form or not Coming soon...Displaying a form by clicking a button Coming soon...Adding charts to your web applications Coming soon...Add virtual hosts Coming soon...Detect badly formatted data on an SQL database Coming soon...Extend Quality Manager Algorithms Coming soon...Recover the offending elements Coming soon...Polynomial function Coming soon...Use the simple linear regression Coming soon...Use the multiple regression Coming soon...Simple data clustering Coming soon...Calculates 'heuristic' (shortest route...) Coming soon...Training a Bayesian network Coming soon...Training a N-Bayesian network Coming soon...Deep Learning on CSV file (feed forward) Coming soon...Using the NNTrainer application Coming soon...Create and train a chatbot Coming soon...Product search with its description Coming soon...Get variables from string Coming soon...Configure a cluster agent Coming soon...Configure a cluster node Coming soon...Add nodes to the cluster Coming soon...Configure the signals from the nodes to the agent (in CPU or 50/50 balance mode) Coming soon...Run a command in the cluster Coming soon...Run a command in the cluster in HOT (not reconnect if already connected) Coming soon...Eject a node on error and consult the list of nodes Coming soon...Reinject a node into the cluster Coming soon...Cut a CSV file into chunks and entrust the processing of each chunk to the different cluster nodes Coming soon...Trigger CRON/JOB in the cluster Add a new job to script Get the global scheduler status Start the global scheduler Stop the global scheduler Restart the global scheduler Edit a job Delete a job Activate a job Desactivate a job Add sequence Update sequence Delete sequence Add global parameters Update global parameters Delete global parameters Coming soon...Access to the OS Coming soon...The server.conf configuration file Coming soon...Metric and Session Coming soon...Reloading the server.conf file Coming soon...Kill MentDB session Coming soon...Kill background process Coming soon...Parameter management Coming soon...Sequence management Export scripts to reload into another MentDB Server Export all MQL script and MQL delay from a group to backup Import all MQL script and MQL delay from a backup to group Make a complete backup Restaure a complete backup