Subscription - NET Genium Update

Current Full Version | Current Test Version | NET Genium Update Terms of Service

September 19, 2024 (version 24.209)

• New server function TRIM(string text, string trimchars), TRIMSTART(string text, string trimchars) a  TRIMEND(string text, string trimchars)
• New option for default values of database controls “Only when manually changing a value in another control”, used in conjunction with the “Fill in the default value every before the record is saved to the database” option

August 6, 2024 (version 24.174)

• New server function ATTACHMENTSIZE(int file)
• New server function FORMATNUMBERINWORDS(double number)

June 17, 2024 (version 24.150)

• Ability to display the value of the textbox in the script in a spacious input field on a new tab after double-clicking on the textbox
• Ability to display a link to open a record from the DataGrid in the TextArea control

June 11, 2024 (version 24.147)

• Option to set thousands separation in the edit form for the TextBox control with the Double or Currency data type
• Automatic separation of thousands in the edit form for the AutoSum control
• New server function PRINTCOLUMNS(int[] cids) designed to limit the list of loaded columns when printing to a print template

January 28, 2024 (version 24.022)

• New server function SCHEDULESCRIPT(int button, int id) designed to schedule a script on a button in an edit form and a specific record

January 4, 2024 (version 24.002)

• New NET Genium version numbering by release year and version order within that year
• New VAT rates
• The new address of the ARES service

December 9, 2023 (Version 9.987)

• New control Kanban

December 1, 2023 (Version 9.972)

• New server function SCHEDULEPORTLETS()

October 10, 2023 (Version 9.925)

• Measuring memory consumption by database queries

October 12, 2022 (Version 9.532)

• Optimized behavior of controls and loading their content using ajax
• Ending support for pop-ups

August 11, 2022 (version 9.485)

• Changing the behavior of the #noreply# variable - it now returns the e-mail address of the default sender of all messages if it is defined in the NET Genium settings, otherwise the e-mail address “noreply@name_net_genium.cz”

May 18, 2022 (Version 9.331)

• Ability to zoom and scroll images in the preview of image file attachments

August 26, 2021 (Version 9.061)

• New DELETEDATA() server function

April 22, 2021 (Version 8.968)

• New Wiki datatype for TextArea control

March 25, 2021 (Version 8.921)

• New server functions SETCOOKIE() and GETCOOKIE()

March 22, 2021 (Version 8.911)

• New server functions TIME2MINUTES(), TIME2SECONDS(), MINUTES2TIME() and SECONDS2TIME()

March 7, 2021 (Version 8.867)

• Help integration in all dialogs in admin mode

March 1, 2021 (Version 8.858)

• Definition of the data type of the RichTextBox control - HTML or HTML in paragraphs
• New options to remove formatting in RichTextBox - remove formatting (selection), simple formatting (all) and plain text (all)

February 13, 2021 (Version 8.838)

• Option to define the maximum number of retrieved records in database query properties
• Possibility to set the RichTextBox in the edit form as hidden

January 30, 2021 (version 8.813)

• New way of aggregating data in database query settings - grouping by date, hour and minute
• New NOBACKGROUND, WEBFORM and LEFTALIGNMENT server functions

January 5, 2021 (version 8.774)

• New DATE(), MONTH() and YEAR() server functions
• Removed “United Kingdom” from “NETGenium.Finance.EU.MemberStates” collection

December 21, 2020 (Version 8.755)

• New variable #useridentity#

December 10, 2020 (Version 8.736)

• Option to mark and mass delete individual records in the view table, if mass changes are enabled in the view table settings
• Option to activate marking of records in the view table right when the view table is displayed, without the need to use the “Mark records...” icon in the view table header

December 2, 2020 (Version 8.717)

• Option to set default data sorting in view tables

November 26, 2020 (Version 8.704)

• Unifying the appearance of read-only controls
• Option to mark individual records in the viewing table that will be assigned a value using the “Assign a value...” filter function
• Option to save a template with a compound condition to multiple users

November 4, 2020 (Version 8.669)

• New server function ATTACHMENTVIDEO(int file, int maxwidth, int maxheight)
• New javascript function button_Enable() and button_Disable()
• New variable #passwordlength#
• New sp_who report, which for the MSSQL database displays a list of open connections to the database, including the last query executed within the given connection

October 24, 2020 (Version 8.650)

• Extended data conversion options between TextArea and RichTextBox (newline transitions, HTML code vs. plain text)
• Option to export the entire database using the SqlBackup.exe utility
  • into one ZIP archive that contains all database tables
  • into a single ZIP archive that contains database tables with a small amount of data, and into separate XML files that contain database tables with a large amount of data

September 24, 2020 (Version 8.616)

• Ability to encrypt values stored in the database for TextArea and RichTextBox controls

August 18, 2020 (Version 8.596)

• New server function FORMATTABLE()

August 12, 2020 (Version 8.583)

• New server function RESETDATAGRIDSETTINGS(int query)
• Print preview icon for RichTextBox controls

August 9, 2020 (Version 8.578)

• Option to filter reports by date from-to

July 31, 2020 (version 8.566)

• New server function REMOVEWHITESPACES(string value)
• New picker for entering time in “HH:mm:ss” format
• Option to enable sending of forgotten passwords in NET Genium settings
• Ability to edit NET Genium settings for all users with administrator privileges
• Implementation of “(mlb)” and “(array)” command into database query conditions

July 8, 2020 (Version 8.552)

• New server function FORMATTIME2(double seconds)
• New server function SUBSTRACTDATES2(DateTime date1, DateTime date2)

July 2, 2020 (version 8.544)

• New server function ATTACHMENTIMG(int file)
• New server function CREATEATTACHMENTTEST(string code, string type, int width, int height, bool label)

July 1, 2020 (version 8.543)

• Improved change tracking
  • In the case of string data types, the possibility to recognize in the history the value change to an empty string or to a NULL database value
  • For numeric or date data types, the possibility to recognize a value change to a NULL database value in the history
• Expanded options for exporting data from view tables - possibility to disable the evaluation of external functions
• Possibility to set the HTML control as priority - in the editing form, the HTML code will be displayed before the editing form itself, and other form controls will be hidden
• Improved display of browsing pages on a mobile device
• New server function CREATEATTACHMENT(string code, string type, int width, int height, bool label)

June 16, 2020 (Version 8.517)

• New SQLQUERY() server function
• New server function LOWRESOLUTION()
• Option to select multiple records at once in the picker
• Extended options for exporting data from view tables
  • Option to remove HTML tags
  • Option to remove text values of foreign keys
• Switch to vector icons

May 6, 2020 (Version 8.454)

• New server function DISABLEAUTOFILL()

May 5, 2020 (Version 8.444)

• Option to export/import user settings of datagrids

April 15, 2020 (Version 8.420)

• Ability to set the first day of the week for the Calendar control
• Option to enter time in HH:mm:ss format into Date text boxes
• New javascript function controls_Join
• Design optimization on mobile devices

March 9, 2020 (Version 8.356)

• Saving passwords in the database using the SHA256 method

February 28, 2020 (Version 8.347)

• Setting the default communication via TLS version 1.2
• Storing sync packages directly in the database instead of on disk in the Synchro directory
• New javascript function jsMeasureMinutes
• New report with a list of VAT rates used
• Updated Aspose.Cells.dll library to version 20.1.0

January 20, 2020 (Version 8.318)

• Option to set File and Image controls as hidden
• New #help# variable used to display help across the entire application - a summary of all help for application groups, applications, categories, view pages, edit forms and RichText controls, marked as “Help”

October 11, 2019 (Version 8.158)

• New data type Time (hh:mm:ss) used in textboxes
• Ability to call external functions via NETGeniumConnection

October 8, 2019 (Version 8.155)

• Logging of all outgoing emails to the SMTP.log file
• Ability to create a scheduled task for ResendEmlFiles.exe and Update.exe from Setup.exe

August 22, 2019 (Version 8.084)

• Firebird 3 database server support

July 11, 2019 (Version 8.035)

• Speed optimization
• Ability to log speed to the console
• Whispering the names of the controls

November 11, 2018 (version 7.820)

• Ability to search for a specific date using the date picker in the Planner control
• Ability to quickly select the year and month in the date picker by clicking on the name of the month

August 24, 2018 (Version 7.710)

• Ability to insert an image from the clipboard using the CTRL+V key into the Image control
• Option to automatically remove all/excess spaces for TextBox control
• Ability to set the height of the Button control
• Ability to set proxy and TLS 1.2 for synchronization between NET Genium instances
• Possibility to open a record in a new window directly from the details in the viewing table
• Ability to display a shortened version of the URL in the TextBox control
• Expanded the maximum number of displayed columns for the History control to 300

June 19, 2018 (version 7.600)

• Option to set the Picker for the MultiListBox control
• Expanding the number of script variables to 78
• Ability to make mass changes directly from the DataGrid for TextArea and RichTextBox controls that are in commenting mode
• Option to run OnBeforeSave/OnAfterSave before saving the record to the database for controls that have mass changes enabled directly from the DataGrid
• New CREATETEXTATTACHMENT and CREATEZIPATTACHMENT script functions

May 11, 2018 (version 7.541)

• New data type Large Integer (Long) for the TextBox control
• Ability to set the column width for the TextBox control in the DataGrid
• Ability to display a link to open a record from the DataGrid in the TextBox control
• Ability to display a link with text on the ForeignKey control
• Extended options for text formatting in the RichTextBox control and the ability to edit text using the external Froala editor
• Possibility to set two visual styles of the Button
• Possibility to set three visual styles of the CheckBox

December 1, 2017 (version 7.354)

• Voice input in every edit form in Chrome
• Option to set integer alignment in TextBox control
• Expanded sorting option in MultiListBox control - move item all the way up and move item all the way down
• Possibility to set a list of IP addresses in the portal settings from which it is possible to log in to NET Genium

September 19, 2017 (version 7.230)

• Brand new NET Genium design - the ability to set icons to application groups and applications
• Integrated CodeMirror into the TextArea control for writing XML, HTML, JavaScript, and C# source code
• IntelliSense in the dialog box for setting the source code of JavaScript and HTML controls
• User-defined decimal format in TextBox control using {0.00}% syntax
• Floating toolbar on RichTextBox control

February 22, 2016 (version 6.509)

• Redesign of NET Genium - new icons and improved appearance and behavior of controls
• Support for full-fledged work in the Internet browser Microsoft Edge
• Termination of WebDAV support - online editing of file attachments

March 19, 2015 (version 6.140)

• Increased buttons and spaces between controls when accessing via mobile devices
• Possibility to hide the data source in the DataGrid when opening the editing form and thereby speed up the loading of the form - the data will then be displayed only after clicking on the icon intended for displaying the data

February 10, 2015 (version 6.105)

• Removal of automatic focus of the first control element on the page when accessed via a mobile device
• Ability to display a dictionary of used application group names directly from the application group settings dialog
• Ability to display a dictionary of used application names directly from the application settings dialog
• Ability to display a dictionary of used category names directly from the category settings dialog
• Option to display a dictionary of used browsing page names directly from the browsing page settings dialog
• Option to display a dictionary of used edit form names directly from the edit form settings dialog
• Ability to display a dictionary of used control element names directly from the control settings dialog
• Possibility to choose a specific directory to which the MS SQL Server database will be restored during the database restoration process using the SqlBackup.exe program

December 12, 2014 (version 6.074)

• Displaying the date of the last change in the portal and recording the changes made
• Quick display of the contents of the “stables_lock” and “sngscript_processing” database tables in the portal tools under the “Database tables (locks)” option, with the option of quickly deleting the record (unblocking the lock)
• Ability to set internal help to application group, application, category and viewing page
• Option to display the dictionary of messages used in the “alert” and “confirm” functions directly from the “JavaScript” control element on the “Administration” tab
• Option to display the dictionary of used picker tooltips directly from the picker settings
• Possibility to display the dictionary of used interrupt texts and messages in the functions “TEFUIG” and “TESUIG” directly from the script designer
• Possibility to set a multi-line TextBox

October 2, 2014 (Version 5.995)

• Option to use the following variables in a compound condition: #day#, #monday#, #month#, #now#, #sunday#, #today#, #year#

September 29, 2014 (version 5.993)

• Option to save complex view table conditions in templates

September 17, 2014 (version 5.979)

• Print template usage statistics available from the portal settings on the Print Templates tab
• Option to enable/disable portal usage logging directly from the portal settings on the Others tab
• In the tools, the option to run the Collect Garbage Collector method to free up unused memory
• Ability to show underprivileged database controls in tools - those referenced by JavaScript controls with lower privileges than the database controls themselves
• Automatic help grouping of pinned controls, which is now the default when creating a new edit form
• Extended options for setting rights to edit records in the editing form
• Support for using In-Memory tables in SQL Server 2014
• In the tools, the option to display a report that shows the row size of the database tables
• Extension of print templates by ODS and ODT format (OpenOffice)
• Possibility of mass setting rights to control elements in the form and on the viewing page
• Enabling mass changes in DataGrid and LiteDataGrid now applies to both filters and controls displayed in a mass-able table
• Newly, neither DataGrid nor LiteDataGrid have mass changes enabled by default
• “Save and continue editing” button in HTML and JavaScript control settings

February 27, 2014 (version 5.772)

• New server functions BUTTON(), CREATEATTACHMENT(), FORMATINTARRAYSQL(), PROTECTFORM(), REDUCEATTACHMENT(), REPLACEIFEQUALS(), SEARCHFILES() , SEARCHNEXTID(), SEARCHPREVID(), SENDCHATMESSAGE(), SCHEDULEPRINTOFATTACHMENT(), SQLTABLE(), UPDATEAUTOSUM()
• New javascript functions bt_Eval(), control_Save(), dg_VisibleColumns(), form_Save(), jsMeasureHours(), jsMeasureWorkDays()
• New variable #defaultvalues#
• In tools, the ability to find read-only controls that call an event
• Adding keyboard shortcuts to facilitate work with the portal: CTRL + Backspace – back, CTRL + Enter – save record, CTRL + Delete – delete record, CTRL + 1 – save and new, CTRL + 2 – save and continue editing, CTRL + 3 – preview, CTRL + up / down arrow – browse records in the datagrid, CTRL + Enter (in the datagrid) – open the marked record
• In the tools, it is possible to display portal usage statistics (editing forms, viewing pages, database queries) when logging is turned on in “ConnectionString.txt”. Logging is turned on by adding a parameter that must be written after a semicolon at the end of the relevant Connection String, and either “log=simple” (logging to NET Genium) or “log=full” (logging to NET Genium and files in the “Logs” directory)
• In the tools, the ability to search for database queries that use a LEFT JOIN + condition
• Allow direct manipulation of DataTable when loading data source in database query
• Extension of print templates with XLSM format
• Option to narrow the left navigation bar

August 7, 2013 (version 5.488)

• New dg_HideColumn javascript function
• Whisperer of server functions and variables in the script
• Option to set up a second SMTP server for sending e-mail messages
• Statistics on the use of the control elements of the editing form on the Administration tab
• Ensuring compatibility with IE 10 browser
• Ability to set the maximum file size in the File and Image controls
• Blocking brute force attacks from the Internet
• Option to transform statistical DataGrid data into a pivot table
• New variable #guid#
• Possibility to overwrite the current value of the control element in the database on the Administration tab
• Ability to display time period selection controls in the Picker
• Displaying the ID and PID of the record when hovering the mouse over the square next to the Title element in the edit form
• New server function COMMIT(), CAPTCHA(), EVALCAPTCHA(), IIF(), FORMATDATESQL(), FORMATDOUBLESQL(), FORMATINTSQL(), FORMATSTRINGSQL(), REMOVEIFCONTAINS(), REMOVEIFEQUALS(), REMOVEIFENDSWITH(), REMOVEIFSTARTSWITH(), DATECONDITION(), DATECONDITION2(), ATTACHMENTGALLERY, SCHEDULEPRINT(), PRINTATTACHMENT(), ATTACHMENTNAME(), LOGSERVICE()
• Double clicking on the date control will insert the current date/time
• Option to set descriptive text to control elements and editing forms with the option to export them to an MS Word application document from database tools
• Option to display log files from the Logs directory directly in database tools
• Option to choose between the full-text catalog Indexing Service and Windows Search
• Extension of print templates with XLSX and DOCX formats
• Expanded the number of possible columns in the history table to 200

August 8, 2012 (Version 5.069)

• Ability to send e-mail messages via SSL protocol
• Ability to set the required strength of passwords (weak, good and strong allow a 3-month password expiration, after which the user must change his password after successful login)
• Option to set a list of allowed IP address changes (in case of an unauthorized change, NET Genium will log the user out)
• Extension of functions of database tools
  • The database model is used for the purpose of creating an ER diagram in the MS Visio application using the reverse engineering function (MS Visio connects to the SQL server database, from which it retrieves information about database tables, their columns, primary keys and relationships; on a local installation of SQL Server, it is necessary to first create an empty database and have a structure identical to NET Genie created in it by exporting the database model)
  • List of all called external functions
• Option to set the number of months in the editing form, after which it is possible to delete history older than this number of months in the database tools
• The option to lock records in the edit form settings for a defined number of minutes, after which it is impossible to open the record by another user
• Ability to display floating text (RichText and HTML control) in the upper right corner of the edit form
• Possibility to compare the database structure of the editing form with another editing form
• Option to hide portlets if they are empty (contain no records)
• Option to set the default value of the controls according to the current value in the database
• Option to fill in the default value before each record is saved to the database
• Extended setting of default view table value search (contains, contains (fulltext) - SQL Server only, equals) and option to search without diacritics
• Ability to display a button next to the File and Image control
• Option to delete duplicate records after running the query
• Ability to name a query setting as a template to easily create a new query based on that template
• Option to name view table settings (DataGrid, LiteDataGrid) as a template to easily create a new query based on this view table
• Option to automatically convert print from HTML print template to PDF format
• Search in the Picker using ajax directly in the editing form without the need to open the Picker window
• Data export to the MS Excel application, including the name of the viewing table and the header
• Option to save DataGrid settings to all users
• Automatic setting of the graph width according to the screen resolution if its width is not explicitly specified

April 15, 2011 (Version 4.620)

• Updates for new versions of browsers (Chrome, Firefox) adding javascript functions

August 18, 2011 (version 4.600)

• Optimizing work with the Firebird database, optimizing queries and page loading speed

June 2, 2011 (Version 4.570)

• Loading details of view tables using ajax

May 15, 2011 (Version 4.560)

• Update rendering of forms for browsers MS Internet Explorer 9, Firefox 4.0, Google Chrome

March 20, 2011 (Version 4.501)

• Update for the new version of Firefox version 4.0

March 15, 2011 (Version 4.480)

• Update for the new version of MS Internet Explorer 9.0

December 10, 2010 (Version 4.410)

• Update for new version of Firefox version 3.6x

November 15, 2010 (version 4.380)

• Updates for new versions of Google Chroma, Safari browsers
• NET Genium speed optimization with Firebird database server

September 17, 2010 (version 4.343)

• Ability to create new entries directly from the calendar

September 1, 2010 (Version 4.320)

• NET Genium speed optimization
• Tool for evaluating the necessity of indexes in the database (Database Tools / Indexes)
• Option to set the index to the PFORM and PID column in the properties of the editing form
• The possibility of fully restoring a deleted record from history either directly in the History control or in database tools
• Expanding the number of free variables in the script to 52 (A – Z, AA – AZ)
• Option to disable the “New” button on the File and Image controls
• New script functions FORMATCURRENCY, FORMATDOUBLE, RENAMEATTACHMENT and WRITEMESSAGE
• Automatic bar chart height adjustment according to the number of displayed bars, if its height is not explicitly specified (the default setting of the height of one bar is 30px; if the specified height of the chart is less than 50px, NET Genium evaluates this data as the height of one bar)

June 23, 2010 (version 4.228)

• Possibility to save user settings of portlets and favorite items also to user groups
• Ability to save user settings of portlets, favorites and tables to multiple users or user groups in the context of the logged in user using the syntax “Administrator|User”

May 20, 2010 (Version 4.194)

• Support for full-fledged work in the Internet browsers Google Chrome and Safari

May 19, 2010 (Version 4.192)

• New ADDHOURS and ADDMINUTES script functions

April 2, 2010 (Version 4.158)

• Possibility to set the priority of automatically sent e-mail from the script

March 16, 2010 (Version 4.144)

• Option to remove selected rights from all child application objects in administrator mode
• Expanding the functionality of the TextBox control element called “Find on the map” with the option of choosing mapy.cz or Google map server, in which the address stored in the control element will be displayed

March 4, 2010 (version 4.135)

• Optimization of HTML code size
• Ability to mass change TextBox, DropDownList, ListBox, Radio and ForeignKey controls directly from the view table
• New variable #usergroups# – overview of user groups and users belonging to them

February 2, 2010 (Version 4.114)

• Possibility to restore a deleted record from the history in administrator mode

November 25, 2009 (version 4.059)

• Incorporation of valid legislative changes with effect from 1.1.1010 - change in VAT rates

October 21, 2009 (version 4.033)

• Convenient search for values in filters using AJAX after double-clicking on the filter or selecting the filter item “(Search)”
• Option to set details on ForeignKey control if it has zero width and its value is picked by Picker
• Placing a link in records displayed as plain text in the LiteDataGrid control

July 23, 2009 (version 3.996)

• New PADLEFT and PADRIGHT functions

July 21, 2009 (version 3.994)

• New OnAfterDelete script that is executed after deleting a record from the database after pressing the “Delete” button in the edit form

July 7, 2009 (version 3.984)

• New Map control designed for displaying OpenStreet maps with the ability to display custom locations on the map

June 16, 2009 (version 3.967)

• New FORMATDATAVIEW and SQL functions

June 15, 2009 (version 3.966)

• Option to color an e-mail message sent from a script
• Extending the functionality of the UPDATEAUTOSUM(id, form) script function - the “form” parameter can be either the ID of the form or its identifier
• Extended help for individual lines in the script

June 3, 2009 (version 3.954)

• Extension of the FORMATDATE() function with the possibility to display the order of the week of the year

May 27, 2009 (version 3.948)

• New navigation in admin mode

May 25, 2009 (version 3.946)

• Implementation of the Gantt chart into the TimeTable control

May 14, 2009 (Version 3.929)

• The ability to send simple messages was enabled for all logged in users, not just administrators

May 13, 2009 (version 3.928)

• Changing the method of counting currently logged-in users - the same user can now log in to the NET Genium portal multiple times within one license
• Changing the method of printing from the editing form to the printing templates of the MS Excel application - printing is now implemented in all sheets of the printing template
• Ability to send simple messages from admin mode to all currently logged in users
• Changed the minimum width of the MultiListBox control to 100px

April 30, 2009 (version 3.900)

• Ability to display the week number for dates
• Added gantt chart style preview to calendar control
• Optimizing the loading speed of portlets, editing forms and viewing pages

April 1, 2009 (version 3.849)

• New commands in the script (conditional saving of a value or multiple values in the database)
• Compatibility with Internet Explorer 8
• Option to open NET Genium in multiple Internet browser tabs

March 10, 2009 (version 3.816)

• New variable #noreply#

March 1, 2009 (Version 3.814)

• Fix handling of statistics query that contains cumulative columns

February 18, 2009 (version 3.810)

• Minor corrections to the display of statistical tables and their export to the MS Excel application

February 5, 2009 (Version 3.804)

• Option to export data to MS Excel from the statistical DataGrid

January 27, 2009 (version 3.796)

• Automatic removal of duplicate email addresses when sending email messages from a script
• Fixed an error raised in an external function when changing the used print template during printing to a print template

January 19, 2009 (version 3.793)

• Option to write variables to resource list in Planner control
• Saving the values of all columns to history when deleting a record
• Fix download of TIF file attachments

January 12, 2009 (version 3.790)

• Restriction of user account administrator rights - from this version, the user account administrator does not have the ability to change the passwords of users with administrative rights