1000 recent changes in MasonSQL Web retrieved at 15:13 (GMT)

WebStatistics
Statistics for MasonSQL Web Month: Topic views: Topic saves: File uploads: Most popular topic views: Top contributors for topic save and uploads:...
HtmlselectComponent
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...
StringComponent
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...
OdtReport
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....
WebHome
The MasonSQL is a Mason based web application framework. In combination with the Linux platform, the Apache web server and Perl scripting language it forms a web ...
NewTableWithEmptyMqlFile
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...
DivselectComponent
divselect.comp The DivSelect widget is the most sophisticated of the three available select widgets. Its intended for showing more complex drop down lists. It has...
SelfRegistration
User Self Registration Management Self Registration Processing Initial Understanding Document * Initial Understanding Document Overview MasonSQL framewor...
SelfRegistrationIUD
Initial Understanding Document User Self Registration { border="1" cellpadding="2" Date Version Modified By Comments 09032016 Draft r.1.0 Main.Rajes...
OdtReportManagerInstallation
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...
MasonSqlCRUD
MasonSQL 1.6.3 Nel documento viene descritta l'interfaccia per lo scambio dei dati per le classiche operazioni di Creazione(Create), Lettura(Retrieve), Aggiorname...
LetsencryptSSL
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...
InstallingPackagesOnUbuntuPrecise
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 ...
ImportXlsData
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...
GlobalAutohandler
global_autohandler GenericSelect_FIELD Method The drop down lists in the MasonSQL framework are implemented with select, htmlselect or divselect widgets, their i...
EmailGateway
Il framework MasonSQL è dotato di un sistema di messaggistica per gli utenti con le seguenti modalità di inoltro: * visualizzazione dei messaggi nel portale we...
DeployUbuntuXenial
# apt get install cpanminus build essential Utilizzando mpm_event o mpm_worker abbiamo riscontrato degli errori nell'esecuzione e pertanto la configurazione con...
DeployUbuntuXenial2Bionic
Upgrade from Ubuntu Xenial VPS to Bionic On this page: Upgrade O.S. * https://linuxconfig.org/how to upgrade to ubuntu 18 04 lts bionic beaver Upgrade Postgr...
DeployUbuntuTrusty
Creata la VM con almeno 512M/RAM e 2Gbye di disco si procede con l'aggiornamento del sistema operativo e con l'installazione dei package. Create the VM with at le...
DeployUbuntuPrecise
Installazione Macchina Virtuale Install Virtual Machine wget http://download.proxmox.com/appliances/system/ubuntu 12.04 standard_12.04 1_amd64.tar.gz Creata la V...
DeployUbuntuPrecise2Xenial
Upgrade from Ubuntu Precise VPS to Xenial # E' importante sapere qual'e' la versione presente lsb_release a # La risposta sara' di questo tipo: # # No LSB modul...
DeployUbuntuBionic
Ubuntu 18_04 LTS (Bionic) # apt get y install cpanminus build essential Utilizzando mpm_event o mpm_worker abbiamo riscontrato degli errori nell'esecuzione e ...
CommonSelectParameters
Common Parameters Parameters common to select.comp, htmlselect.comp and divselect.comp widgets: Parameter Name Description Default Value id Select Com...
DbmsLibraryFatherChildMethods
FATHER, CHILD Methods The web page with a father and one or more children can be configured with a collection of methods: Method Name Desc...
DbmsLibraryXlsMethods
XLS Methods Method Name Description Default Contents xls Is the method that is called when user presses the XLS button.Its default behavior can be cha...
WebPreferences
MasonSQL Web Preferences The following settings are web preferences of the MasonSQL web. These preferences overwrite the site level preferences in . and ,...
AddingInheritance
Inheriting Table Properties In this chapter we will make the orders3.mql file which inherits properties from orders2.mql file. We will add the properties that we ...
WebNotify
* .MasonSQLGroup: *
RecodingOptimizations
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...
DatabaseHandling
Internal Database The MasonSQL component /opt/masonsql/htdocs/lib/dbms_library.comp makes SQL queries to internal PostgreSQL database 9.5 which conforms to SQL st...
DbmsLibraryInsertUpdateDeleteMethods
INSERT, UPDATE, DELETE Method Name Arguments Description Default Contents INSERT Insert a new record.The metod is cal...
DbmsLibrarySelectMethods
SELECT Method Name Arguments Description Default Contents Example Usage SELECT_FIELDS A list of fields to be inserted into table's select query....
FilesComponent
Files.comp The Files widget enables users to attach files to records in a table. Input Parameters: Parameters Parameter Name Description Default Value ...
FrameHtml
frame.html On this page: Input Parameters Input Parameter Description Default Value form Indicates which type of form will be di...
SelectComponent
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...
SessionManagement
Session Management to manage user connection from many workstation and mobiles. Preface MasonSQL framework uses authentication based on Cookie. If the user open...
TestingQueries
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...
DbmsLibrary_FieldMethods
_FIELD Methods As shown in the examples from previous chapters each field can also be uniquely configured. Here's the list of the FIELD methods: Method Name A...
UsingFields
Using Select and HtmlSelect Widgets We already have an example table with Commission ID and Employee ID fields pointing to their children tables which is not very...
UsingDivSelectField
Using DivSelect Widget On this page: Defining Children's Fields In this example we'll be adding the divselect widget to the employee field.The FIELDS_NOT_NULL co...
LibraryComponent
library.comp Subroutines The library component is the MasonSQL root component which initializes logging, includes most essential Perl modules and provides a coupl...
FormComponent
form.comp The Form widget provides possibility to use forms in a popup window. Input Parameters: Parameters Parameter Name Description Default Value id...
DataBindingClass
DisplayBinding Class On this page: Subroutines Function Name Parameter Name Valid Input Value Description printUrl() Joins the input argument...
NewTableWithSimpleSqlFile
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 ...
ManagingGroups
Managing Groups An authorization mechanism in the MasonSQL framework is implemented with groups. Its a concept similar to Unix file system authorization although ...
DbmsLibraryUniversalSubroutines
Universal Methods and Subroutines Method orSubroutine Name Parameter Name Valid Input Value orAttribute Value Description Default Value Find_Compone...
DbmsLibraryQuerySubroutines
Query Subroutines Name Arguments Description Array2UpdateSql() The subroutine is used for updating or inserting records sent by GUI in an array for...
DbmsLibraryPrePostPost_NoMethods
PRE, POST, POST_NO The hooks for these methods are available to be executed prior or after the INSERT, UPDATE or DELETE queries. The methods can generate a SQL co...
DbmsLibraryFieldsMethods
FIELDS Methods Some of the FIELDS methods were already encountered in previous chapters; Here's the complete list of the FIELDS methods: Method Name Descripti...
DbmsLibraryComponent
DBMS Library Component The dbms_library.comp provides database interface. Some of its methods are also used by frame.html. Its less complex methods are intended ...
Autohandlers
Autohandlers The autohandlers offer improved inherit mechanism. That means they might just as well be used as normal libraries. If we want to write a generalized ...
AddingChildFrame
Adding Child Frame In this example we will display a table together with one linking table. We will also do some improvements of the input fields. On this page: ...
DatabaseAccess
Access to PostgreSQL Database On this page: Setting Up pgAdmin With Tunneling It is convenient to use pgAdmin for the PostgreSQL database administration. After i...
Reportman
Report Manager Use of Report Manager (Reportman in short) with MasonSQL is deprecated. Report Manager currently supports Wine version, Kylix version is deprecated...
Perlbrew-deploy
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...
MasonConfiguration
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...
MasonSqlSupportMatrix
MasonSQL Support Matrix SVN Release Operating System Server Apache Mason Perl Perlbrew Perl Dojo masonsql/tags/1.9.1 Ubuntu 12.04 LTS (Preci...
ReportComponent
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...
OdtReportmanUsersGuide
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...
OdtReportLibrary
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...
DuplicatingApplication
Duplicating Application to New Server OS: Ubuntu 12.04 LTS (Precise Pangolin) in VPS (OpenVZ) In this example we will duplicate the https://gas devel.leader.it ...
DisplayBindingClass
DisplayBinding Class On this page: Subroutines Function Name Parameter Name Valid Input Value Description printSelected() Sets the dataBindin...
DbmsLibraryReportMethods
Report Methods The report methods are called when a browser makes a pdf query request (see Testing Queries). The query request is initiated with printSelected()...
DbmsLibraryFormsMethods
Forms Methods Forms Some of these methods are related to methods in frame.html. Method Name Parameter Name Description Default Value FORM_TYPE T...
FileComponent
file.comp The file widget contains the base64 encoded content of a file. An upload window pops up in edit mode on mouse click on the widget. On double click the c...
InputComponent
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...
TableCopyAndPaste
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 ...
PortingApache24
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....
DbmsLibraryAuxiliaryMethods
Auxiliary Methods Method Name Arguments Description Default Contents DELETE_IF_FIELD_EMPTY Contains a list of field names. Defines which fi...
NumberComponent
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...
ColorComponent
color.comp The color widget allows user to find a color. On this page: Parameters Parameter Name Description Default Value $value A color string whic...
InputWidgets
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...
SrcLibMasonSQLReportPm
MasonSQL::Report Revision $Revision: $ Description MasonSQL implementation of reporting. Included Libraries and Subroutines Library or Function Name ...
ImageComponent
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 ...
SrcHtdocsLibReportPdf
report.pdf Revision $Revision: $ Description A component for generating MasonSQL reports in PDF or ODT format. Arguments B B B $ba...
DbmsLibraryQueryMethods
Query Methods and Subroutines There's a general convention to use the PRE, POST and POST_NO methods for handling fields in the tables and INSERT, UPDATE and DELET...
DbmsLibraryFindMethods
FIND Methods Method Name Parameter Name Description Default Value FIND The method displays a find bar for filtering the records. The method can p...
DbmsLibraryReportSubroutines
Report Subroutines DBMS Library subroutines related to reporting. Subroutine Name Parameter Name Valid Input Value Description Array2report_idSql() ...
DbmsLibraryReportMethodsSubroutinesAndComponent
Report Methods, Subroutines and Component Report Component report.pdf Component
DbmsLibraryAuthorizationMethods
Authorization Methods and Subroutines SQL injection check Queries generated by the GUI are controlled by the server. Subroutines Subroutine Name Parameter ...
ButtonComponent
button.comp The Button widget is a graphical control element that provides to user a simple way to trigger an event. On this page: Parameters Parameter Name ...
MasonSqlBinCronJobs
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...
Codfisc_piComponent
codfisc_pi.comp This widget is used for personal fiscal and VAT identification codes used in Italy. Input Parameters: Parameters The widget checks the validity o...
TimestampComponent
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...
CheckboxComponent
checkbox.comp The Checkbox is commonly used when more than one option may need to be selected. Checking the box enables that option and unchecking it disables it....
PermissionComponent
Permission.comp The Permission widget is used for allowing different types of authorizations to different groups of users for every function. Input Parameters: P...
FCKeditorComponent
FCKeditor.comp FCKEditor is a browser based WYSIWYG content editor. This means the content being edited is a genuine graphical representation of the published con...
UrlComponent
url.comp The Url widget is used for opening URLs in a separate window or box area. Input Parameters: Parameters Parameter Name Description Default Value ...
TimeComponent
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...
SpanComponent
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...
RadioComponent
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...
DateComponent
date.comp The Date widget is used for displaying or setting a date. Input Parameters: Parameters The date must be specified in DD/MM/YYYY format. Parameter Nam...
POD2Foswiki
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...
MasonLiterature
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 ...
ReportManagerOptions
Report Manager Prints a report manager (.rep) file to a Adobe PDF file. Version: printreptopdf 2.9a Usage: printreptopdf Options stdin reportfilename outputfi...
ScreenShots
GUI framework Examples with italian interface language. Gui Framework Difference Screenshot according to user role root user guest user ...
BackupPC
Configure backup system to preserve database integrity The backup system copy every file in the server, but database files during backup can change and final re...
ConnectionString
Provider=MSDASQL.1;Persist Security Info=False;Mode=Read;Extended Properties="DRIVER={PostgreSQL Unicode};DATABASE=masonsql;SERVER=127.0.0.1;USER=report;PASSWORD=...
HandlingEmailAndSmsMessages
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...
UsingNumberField
Using Number Widget The number widget is input number widget, it is used for input fields that should contain a numeric value. You can set restrictions on the nu...
AdditionalTools
Additional Tools Print Server A print server utility is used for printing to a local printer in the raw mode, connected to user PC. The utility is in the /opt/ma...
PuttySettings
Connection is set normally: Here are the SSH Tunneling settings: Note that SSH Tunneling port number chosen by the remote machine admin.
TurningOnDebugs
Turning On Debugs * The application initialization file /opt/demo_masonsql/htdocs/init.application.comp is intended for enabling debugs and setting the debug l...
ProprietaryClasses
Proprietary Classes On this page: Auth_AC::Auth_AC The MasonSQL Authentication library consists of two classes: * Auth_AC::AuthBasicHandler handles Session ba...
JavaScript
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:/...
BrowseSVN
* SVN in pagina separata In caso di richiesta di autenticazione fornire login e password utilizzati nel Wiki
WebLeftBar
" warn="off"}% * ** * * * * * * * * * SVN Repository
WebAtom
Leader.IT's MasonSQL web
WebRss
" else="Leader.IT's MasonSQL web"}% /MasonSQL
Number of topics: 117

See also: rss-small RSS feed, recent changes with 50, 100, 200, 500, 1000 topics, all changes
Topic revision: r1 - 09 Jan 2009, ProjectContributor
This site is powered by FoswikiCopyright (©) Leader.IT - Italy P.I. IT01434390223 Privacy policy & use of cookies