Detailed topic list for MasonSQL Web

global_autohandler GenericSelect_FIELD Method The drop down lists in the MasonSQL framework are implemented with select, htmlselect or divselect widgets, their i...

Handling Email and SMS Messages On this page: Messaging Procedure To send message the application must save the message information into the database with all of...

htmlselect.comp The HtmlSelect widget is an upgrade of the basic HTML select button. It is not buffered in contrast to the Select widget. Input Parameters: Html...

image.comp The image widget displays the base64 encoded string as an image. An image upload window pops up in edit mode on mouse click inside the image frame. On ...

Import data from XLS tables and others formats (XLS, JSON, ...) Preliminary * Now the framework permit to export data, but not to import and the exported tabl...

Base Component The input.comp is a father of all available widgets. On this page: Input Class The input.js contains definition of a base class which is used by t...

Input Widgets The Input widgets are a JavaScript widgets that provide means to input or display different types of data into or from the internal database. A typ...

sudo su # Locale settings update locale LC_ALL=it_IT.UTF 8 LANG=it_IT.UTF 8 locale gen dpkg reconfigure tzdata # Update packages apt get update apt get upgrade ...

Javascript Widgets Dojo Toolkit The MasonSQL framework currently uses the Dojo Toolkit version 1.9 which is an Ajax framework. See the public resources at http:/...

Deploy Let's Encrypt SSL certificates With the non profit certificate authority Let's Encrypt, it is possible to get free https certificates. Certificates expire...

library.comp Subroutines The library component is the MasonSQL root component which initializes logging, includes most essential Perl modules and provides a coupl...

Managing Groups An authorization mechanism in the MasonSQL framework is implemented with groups. Its a concept similar to Unix file system authorization although ...

Mason Configuration File The MasonSQL configuration file path /opt/masonsql/etc/apache2.masonsql.conf must be included in the application config file: Eg. /opt/de...

Mason Literature The Mason Book There is a great book about Mason, titled Embedding Perl in HTML with Mason, by Dave Rolsky and Ken Williams. The book's website ...

Message Forwarding The /opt/masonsql/bin/cronjobs file is forwarding authority for email messages and text messages in the queue.It reads the PerlSetVar variables...

MasonSQL 1.6.4 Nel documento viene descritta l'interfaccia per lo scambio dei dati per le classiche operazioni di Creazione(Create), Lettura(Retrieve), Aggiorname...

MasonSQL Support Matrix SVN Release Operating System Server Apache Mason Perl Perlbrew Perl Dojo masonsql/tags/1.9.1 Ubuntu 12.04 LTS (Preci...

Creating Table With Empty SQL File In this chapter we will create an example demo application for a small bakery shop, to this purpose we need to create some kind...

Creating Table With Simple SQL File In this chapter we will make the orders2.mql file and fill it up with a few simple methods. We will also add the table in the ...

number.comp The Number widget is used for input fields that should contain a numeric value. Additional restrictions on the numbers can be specified. Input Parame...

Il framework MasonSQL dispone di un generatore di report nei formati ODT e PDF. I dati da includere nel report vengono estratti dal database mediante delle query....

ODT Reportman Library ODT Reportman library produces a MasonSQL reports using an .odt files as templates. The template files are created with the LibreOffice's ap...

Queste istruzioni per l'installazione sono state verificate su Ubuntu Precise (12.04) e Ubuntu Trusty (14.04) con il downgrade ad Apache 2.2 These instructions fo...

ODT Reportman User's Guide In this guide it will be explained the usage of the ODT Report web form using an example report. In the example it will be described th...

Application to export POD documentation from SVN/GIT to Foswiki portal Introduction Leader.IT uses a Foswiki Web portal to manage documentations, also this docum...

Attention! Perlbrew deploy is necessary only on Ubutu 12.04! # Install Perlbrew apt get y update apt get y install perlbrew mkdir /opt/masonsql/perlbrew # Add P...

Permission.comp The Permission widget is used for allowing different types of authorizations to different groups of users for every function. Input Parameters: P...

MasonSql porting to Apache 2.4 The current (2016) version of MasonSQL is compatible with Apache 2.0 and 2.2 with part of it compatible with very old version 1.3....

Proprietary Classes On this page: Auth_AC::Auth_AC The MasonSQL Authentication library consists of two classes: * Auth_AC::AuthBasicHandler handles Session ba...

Connection is set normally: Here are the SSH Tunneling settings: Note that SSH Tunneling port number chosen by the remote machine admin.

radio.comp The Radio Button widget allows the user to choose from one of a predefined set of options. Input Parameters: Parameters Parameter Name Description...

Recoding optimizations 2018 ATTENTION: These changes (from svn version 534) are not compatible with older versions! Update Dojo Toolkit Update code to the most r...

Report Component The report.pdf component receives a command line parameters that are passed on to the Reportman or to the ODT Report library which in turn gener...

Report Manager Prints a report manager (.rep) file to a Adobe PDF file. Version: printreptopdf 2.9a Usage: printreptopdf Options stdin reportfilename outputfi...

Report Manager Use of Report Manager (Reportman in short) with MasonSQL is deprecated. Report Manager currently supports Wine version, Kylix version is deprecated...

GUI framework Examples with italian interface language. Gui Framework Difference Screenshot according to user role root user guest user ...

select.comp The Select widget is the simplest of the three available select widgets. The displayed selection is a result of the specified query. The selection is...

User Self Registration Management Self Registration Processing Initial Understanding Document * Initial Understanding Document Overview MasonSQL framewor...

Initial Understanding Document User Self Registration { border="1" cellpadding="2" Date Version Modified By Comments 09032016 Draft r.1.0 Main.Rajes...

Session Management to manage user connection from many workstation and mobiles. Preface MasonSQL framework uses authentication based on Cookie. If the user open...

span.comp The Text Span widget is used for grouping elements in a document without being itself visually changed. It also provides a way to add a hook to a part o...

report.pdf Revision $Revision: $ Description A component for generating MasonSQL reports in PDF or ODT format. Arguments B B B $ba...

MasonSQL::Report Revision $Revision: $ Description MasonSQL implementation of reporting. Included Libraries and Subroutines Library or Function Name ...

string.comp The String widget is used for input fields that contain a strings. The string length can be defined in the .mql file or preferably directly in the da...

Copy Paste features in MasonSQL TABLE form Preface In the MasonSQl form of type TABLE at the left, for each row, there is a flag used to select colums to delete ...

Testing MasonSQL Queries On this page: Running test_callRemote.html This test file /opt/masonsql/htdocs/test/test_callRemote.html is small enough to analyze it q...

time.comp The Time widget is used for setting the time. The time must be specified in HH:MM format. If the time is specified as value 01:02:33 the widget will d...

timestamp.comp The Timestamp widget is combination of date and time widgets. It is used when it is required both date and time. The date and time must be specifie...

Turning On Debugs * The application initialization file /opt/demo_masonsql/htdocs/init.application.comp is intended for enabling debugs and setting the debug l...