New Stadium 5 website

Hi all!

Stadium 5 has a brand new website. This website has a new blog as well as Stadium community section. As a result any Stadium 5 news, including new releases etc., will be communicated on the new blog.

Visit https://stadium.software and let me know what you think!

Stadium 5.11.2312.8770 is available (Hotfix)

This hotfix addresses the following issue:

• The Application Manager throws an exception when trying to add Server Users

We are currently hard at work on our next feature release which will contain a lot of exciting new features! Please visit our roadmap for more information.

Stadium 5.11.2306.8639 is available (Hotfix)

This hotfix release only contains critical bug fixes. We are currently hard at work on our next feature release which will contain a lot of exciting new features! Please visit our roadmap for more information.

Bug Fixes

• Server Installer fails with message: "A DLL required for this install to complete could not be run."
• Theme is not selectable in the Property Grid
• EmbeddedFiles cannot be renamed using the context menu
• Selecting an image from the Gallery assigns that image to all Image controls on the page
• Undo loses it's history
• Issues around undo-ing a page rename
• Issues around undo-ing a CallScript action
• Redo on Folder does not work in specific situations
• "Name already in use" thrown when undo-ing web service import
• Error on undo of DisplayMessageBox property
• Settings indicate a "Name already used" error even though it has not been used
• Object reference exception when closing an application
• Importing Files and Folders dialog has no owner set to it

Stadium 5.11 is available

It's been a long wait but it's finally here! This release contains a brand-new web service connector, an Application Manager, Undo and many other exciting new features. Keep reading for more details.

New features:

• Separate Designer and Server installers

  The 2 parts of Stadium were split and placed into separate installers. This allows you to install them independently of each other on the same or different environments. The 2 parts are:

  • The Designer: applications are designed here.
  • The Server: build, deploy and manage your applications

• Stadium Application Manager

  Stadium Application Manager (or SAM as we affectionately call it  ) allows you to deploy, delete and manage applications. Read the detailed list of features here.

• Undo / Redo

  Now you can undo those 'Noooooooo, what was I thinking??' moments after accidentally destroying your core piece of functionality.

• Web Service Connector

  Create a Web Service Connector manually or by importing an OpenApi 3 file. Read more.

• Forgot Password

  Configure your SMTP server details in the Stadium Application Manager and all of your secured applications, built on this version or later, will automatically include 'Forgot Password' functionality.
  Read more.

• Query Tester

  Test your database queries or stored procedures from within the Designer to see whether the expected data is returned.

• Improved Security Model

  The security model has been changed to be in line with the more familiar Roles security model. A page is now only accessible to a user if the page and the user belong to the same role.

• Removed ExecuteConnector and CallScript

  To invoke a script or connector now, simply drag it from the Application Explorer and drop it into a script at the position where you want to call it. As simple as that!

• Broken References

  Changing your application, e.g. deleting a Setting, can leave it with a lot of broken references to items that no longer exist. In the past, we removed these broken references, leaving you puzzled as to why a property is now suddenly blank? We changed this.
  
  Now a broken reference is rather marked as invalid and a validation error will be displayed in the Validation panel. This allows you to easily fix any issues that arise as a result of changes you make in your application.

• Extended UserAPI

  FetchUser and DeleteUser were added to the list of available web service methods. For more information see the API help in the generated application's Admin Section.

• Sample Applications

  See how to accomplish certain basic tasks in Stadium by means of examples. Find them at the Stadium website.

Other smaller changes:

• Connectors can now only be used inside of scripts.
• Rename [Static Data] to [Embedded Files]
• All new pages have a LoadScript by default
• Generate applications into individual application pools
• Exporting to excel now exports the dateformat of columns as well
• Designer performance improvements

Bug fixes:

• Fixed 'New Version' notification issues
• Fixed issue when downloading a file from a database
• Fixed issues with boolean comparisons
• Client-side validations were triggered at the incorrect time
• Fixed client-side exception when loading lots of data
• Access Denied was encountered when leaving the site idle for a while and then refreshing the page
• Query timeout was not respected when a DataGrid's Data is set via a script
• RadioButtonList triggered a Change event when rebinding a list with a selected item
• Stadium Designer crashed at a resolution of 1280 x 720
• Fixed many other bugs

Stadium 5.10.2192.7337 is now available

This hotfix release only contains critical bug fixes. We are currently hard at work on our next feature release which will contain a lot of exciting new features! Please visit our roadmap for more information.

Bug Fixes

• Application Explorer jumps back to currently selected page if other nodes are expanded
• Query parameters should not be converted to strings
• Incorrect handling of boolean value in script
• Adding a user on generated Apps with specific names leads to 404 exception

Stadium 5.10.2186.7123 is now available

This hotfix release only contains low impact bug fixes. We are currently hard at work on our next feature release which will contain a lot of exciting new features! Please visit our roadmap for more information.

Bug Fixes

• Designer: Stored Procedure canvas has a blank space on the left
• Error is shown before displaying the message that the sapz was created in a newer designer
• Installer: Check at the start whether a newer version has already been installed
• Renaming the logged-in user's email does not update the logged-in user session details
• Query Name is not updated in the Property Grid when renamed in the Application Explorer
• Edge replaces special characters in a file to download
• Logging out after changing Login Mode causes token error
• Save-shortcut does not work after deleting control
• Context menu not displaying when right clicking on an action
• Decision's 'if' and 'else' node are indented too much on the script canvas
• UploadFile control behaves inconsistently when on both the template and on the page
• When loading a page, default property values are applied before changing to the defined property values
• Image size set to percentages breaks the left-to-right layout on the page
• DataGrid Column Editor should not allow generating columns from a FileSystem Connector
• DataGrid not shown when data is set after changing panel's Visibility
• Runtime error when handling uploaded files
• NavigateToPage causes a "url.startsWith is not a function" error
• The loopvalue of a ForEach action does not list the columns of a database row
• Image File paths should be html encoded
• DataGrid paging starts to act up after paging a couple of times
• Implicit conversion from varchar to varbinary(max)
• Long period of idle time causes javascript exception on Bugbear
• Tab order is wrong when categories are collapsed in the Property Grid
• Switching Login Mode to Windows Auth does not enable it in IIS
• Stadium Admin API returns 'Access Denied' when using Windows Auth
• Stadium API must return descriptive error messages
• Adding a Stored Procedure under the Database connector causes an exception to be displayed
• Maximizing dialogs should not expand over the Windows Taskbar
• Retrieving MySQL Tables & Views takes too long
• Testing the Database connector connection passes even if the login is disabled
• Stored proc with both fields and output parameter causes generation error
• DataGrid returns string when datatype should be boolean
• UserAPI returns guid with quotes around it
• Installation fails when IIS is not enabled
• Error thrown when JSON is pasted into an expression
• The 'Add Query' plus icon in the Application Explorer gets cut off when resizing the App Explorer pane
• Negative numbers are displayed with space(s) inbetween the minus sign and the number
• REST API calls to JIRA fail for different reasons
• An 'Object reference' error is thrown when regenerating a site after a short period of no action
• DropDown causes script errors if values contains spaces
• Moving a NavigateToPage into an Else statement higher up in the script causes an exception
• Generation fails with "Unable to cast object of type 'System.String' to 'Twenty57.Stadium.API.Interfaces.DataTypes.IField'."

Stadium 5.10.2156.6998 is now available

We changed our DataGrid to be more flexible and also introduced a new File System Connector in this release. Please give it a test run and let me know what you think!

The important new features I want to draw your attention to are:

• DataGrid Column Definitions

  Define columns independently to a datasource.

• File System Connector

  Access a folder on the webserver or network. For more on this, click here.

• Improved UploadFile Control

  Upload files to a Database or File System. Also, uploaded files can now be removed by the user before submitting them. Click here for more on this control.

• Improved DownloadFile Action (previously the GetFile action)

  Download files from a database, file system or Embedded Files.

• Enhancements to the Expression Editor

  Syntax highlighting and some other features were added to the Expression Editor to make it simpler to build an expression.

Other features and bug fixes we worked on can be seen below.

Features

• Add a validation to the UploadFile control to prevent use before all files have completed uploading
• A new page/folder is added into the same folder as the selected page/folder
• Rename ExecuteSqlCommand to ExecuteConnector
• Change the blank slate of the DataGrid
• Add divider lines inbetween the tabs of the canvas
• Remove the DisplayName of fields from a Database.Query and Database.StoredProc
• Force an admin user to be created on the first visit of a generated web application

Bug Fixes

• Add favicon.ico to the template
• Installer should start the WAS and W3SVC services if not running already
• Installer fails if the Default WebSite has been deleted in IIS
• Stadium does not install correctly on Windows 7
• Moving designer between screens using windows shortcut keys causes resizing issues
• Do not select a node in the Application Explorer when right-clicking on the node
• Double clicking a mapping validation should open the Field Mapping Editor
• Query parameter is not being picked up by 'Fetch Fields & Parameters'
• The top and bottom of the page canvas is not right-clickable
• Object Reference exception thrown when inserting a new row or column into the LayoutTable
• DataGrid content is displayed inbetween the SearchBox and the DataGrid as normal text
• Output parameter is not correctly resolved after pasting it into a script
• Control with the same name as it's page causes generation issues
• Foreign Key conflict when fetching the fields and parameters of a query
• Multiline string and reference concatenation inside of an expression causes the reference to not resolve properly
• Dragging conditions up and down does not persist when leaving the editor
• Deleting a copied script removes the wrong references
• The Validation icon in the Property Grid of the Designer does not disappear once corrected
• Do not expand the page when moving it in the Application Explorer
• Typing an expression into the ReferenceCombobox removes the '=' in front and saves it as a string
• Assigning a query or query field from script causes the browser to hang momentarily
• With no application open, clicking on the Template button on the Toolbar does not display the DefaultTemplate
• Anti-forgery token was meant for user
• Queries should not fetch parameters of commented sql code
• Clicking Save on the Options Editor does not update the attached field if no options were entered
• Literal value for query parameter does not resolve when assigning query field directly to Label Text
• ExecuteSQLCommand FirstRow field is undefined if query returned no rows
• Notification does not properly render non-string values
• Connection editor: Changing Server clears the Database field
• The DataGrid throws an error when assigning it data with one or more byte[] columns
• Save error after deleting a control
• Output parameters cannot be used further down in the script
• Reference in property SetValue.Value is lost when dragging the target control (SetValue.Target) into a LayoutGrid on the canvas
• Toggling DataGrid visibility after assigning data to it causes it to not display
• Using an Oracle Database causes a "duplicate section defined" exception at runtime
• Button with an EventHandler attached causes an incorrect tab order in the property grid
• When running the Form Wizard twice for the same operation, duplicate script names are generated
• Can't log off when error page is shown
• DataGrid columns should be type-agnostic
• Connector reference turns into an Expression
• Download version notification does not disappear if internet drops
• Data type Time causes an exception when fetching fields and parameters of a query
• Object reference exception when deleting a table row

Stadium 5.9.2074.6587 is now available

In this release, we redesigned the entire Event Framework from scratch! This new, greatly enhanced, more powerful and easy to use Event Framework gives you the freedom you need to design highly interactive applications, making your users' experience so much better. Please give it a test run and let me know what you think!

The important new features I want to draw your attention to are:

• Events

  A powerful event framework allowing designers to greatly enhance the interactivity and user experience of their applications. PageLoad and OnChange were added as two new events with more to come in the future!

• List controls now use JSON formatted data

  DropDown, RadioButtonList and CheckBoxList now use JSON formatted data when specifying static options. By doing this, options can now be re-used simply by reading them from a Static Data file or copy pasting them from one control to another.

• Static Data

  Include files & images as static data into your Stadium application and use them on certain controls and actions.

• Selectable Rows in a DataGrid

  The DataGrid now has an optional checkbox column allowing the user to select one or more of the rows inside of the DataGrid. The application designer can then iterate through the selected rows using a ForEach action in a script.

• Get or set the search term of the DataGrid

  Being able to get or set the searchterm is very useful when navigating away or back to a page where the DataGrid should remember the user's previous search.

Other features and bug fixes we worked on can be seen below.

Features

• Database column type, HierachyId, is now supported
• Expanding the DropDown on the canvas should also select the control
• In the generated application, do not allow the current user to be deselected as Administrator
• Add messages to empty tables in the Admin site
• On the canvas, indicate invisible columns by displaying their text as light gray
• Prevent possible security attacks on the generated application(i.e. Clickjacking, XSS)
• Infer types assigned to properties
• Allow selecting Connectors as Value for the SetValue action
• Allow assigning references to the Message property of the Notification Action
• Improve the performance of the Gallery Editor
• Allow get and set for the Options property on list controls via scripts
• Do not delete actions inside of the current Button paths when changing the Buttons of a DisplayMessageBox
• Changes around setting and deleting of the Application Start Page
• Toastr error messages thrown by Stadium should be explicitly dismissed by the user
• Database connection validation not disappearing after correcting it
• Remove the option to assign Control properties to the NavigateToPage.Destination property
• Use the ~ to represent the script in a reference breadcrumb
• The Tables & Views pane of a query should be open by default
• Rename DataSources to Connectors
• ConnectionString editor loses focus when testing a connection
• Add a '+' icon to DataSource node in the App Explorer to add new queries
• Rename the ForEach loop variable
• Provide an indication to the user when there are script errors

Bug Fixes

• Connecting to SQL Server via ODBC fails
• InstallTools folder should not be installed when installing Stadium
• Copying a page does not restore references to corresponding controls
• Adding a LayoutTable to the page causes an ObjectReference error
• CallScript action used in an EventHandler causes ObjectReference error on Generation
• Gallery gets hidden behind Main Window of Designer when adding new images
• After the FormWizard exits, the focus in the App Explorer should be on the newly added page
• Right clicking on the tab of a canvas, closes the canvas
• Validation issues on Page Parameter, Script Input Parameter and Script Output Parameter editors
• Hover and selection issues of controls inside of a LayoutGrid
• DataGrid alignment is off on the page canvas
• Deleting a folder should close any open tabs of deleted items
• Designer Window/Pane Layout does not persist unless application is saved
• Changing access requires the affected user to log out and log back in again before it takes effect
• Uninstall completes but does not remove Stadium
• Double clicking an image in the Image Gallery does not select and assign it to the Image Control
• The ReferenceComboBox does not persist changes on blur
• Strange behaviour during setting the data of a DataGrid using SetValue
• An ExecuteSqlCommmand action using session variables as parameters inside of an event script on a template causes a generation exception
• All panes except the Toolbox freeze up if the Toolbox is clicked while a context menu is open
• Ordering of pages is incorrect when renaming a page
• The icon next to the 'New Query' item in the Database context menu is missing
• When generation fails, the failed build overwrites the working website
• An @ symbol in an Expression causes a script error
• Copying Container controls containing other Container controls causes naming issues
• EventHandler "Copy to script" functionality causes errors when saving the application

Stadium 5.8.1985.6160 is now available

We are releasing our first version of the Web Api that will simplify integrating the user database with other systems. On top of this, there are many other added features and improvements.

The features I want to draw your attention to in this version are:

• Web Api

  Access and manage users of generated applications via a REST web api. To see more on this, generate an application and visit the API menu of the Admin section in the browser.

• More powerful Image control

  The image control can now display images straight from a database or get an url to an image using datasources, settings, page parameters or expressions. Best of all, the control can be accessed from inside of a script allowing you to dynamically change which image is displayed without the need to renavigate to the page.

• 'Google-like' file upload

  Upload multiple files at once by selecting them from a file selector or by dragging them straight into the box. They will immediately start uploading without the need to press the upload button.

• New action: Call script

  Call other scripts from within a script. You now have the ability to break big unwieldy scripts into smaller more concise scripts and invoke them when needed. Creating smaller scripts leads to more readable and understandable applications as they grow bigger.

• Improvements to the Tables & Views pane of a Query

  Quickly generate CRUD queries by making use of our generator. Do this by right clicking on a table or view and choosing between a Select, Insert, Update or Delete statement. Changes have also been made to enhance both usability and the performance of this pane.

• Lists can now be set using JSON

  The items for any list control, i.e. CheckBoxList, RadioButtonList or Dropdown, can now be set by assigning a JSON object to the Options property. This simplifies reuse of lists across controls.

• More wide-spread use of expressions on actions

  Expressions proved to be so useful on the SetValue action, that we decided to make them available to all actions.

Please download this latest version and let us know what you think! Other added features and bug fixes are listed below.

Features

• Allow a Query to execute CREATE PROCEDURE
• All controls should have a Visible Property
• Change email to be the username of a user
• SetValue should allow column mapping when setting DataGrid.Data
• Allow assigning a query with output parameters to a control or action
• Connections and Queries: Always test/execute through the service in the Designer
• In the Menu Control: Order the pagenames in the Destination Page dropdown of the MenuItem
• Change all boolean values from True/False to true/false
• Remove the .NET Framework 3.5 dependency

Bug

• DataGrid search fails when searching for dates
• Pasting an action should select that action afterwards
• Do not allow tabbing into the texbox on the canvas
• Controls should be highlighted when their properties show
• Oracle should allow defining parameters with @
• A control cannot be dragged onto the canvas immediately after creating a new application
• Application Explorer loses focus after selecting a page, script, template, query or stored procedure
• No-typing ReferenceCombobox does not grab focus when dropped down
• ReferenceComboBox incorrectly changes the property description on the PropertyGrid
• Fonts missing from themes folders
• Uninstall does not remove Stadium from the StartMenu of Windows
• ODBC and Oracle render illegal column names
• Control loses focus after moving it on the canvas
• Edge reports 404 when fetching the generateSourceMap file
• Float icon overlaps tab when making the pane very narrow
• DataGridColumn renames header text when changing
• DataGridColumns across separate DataGrids can be selected simultaneously
• Tab stops with parameters in the Property Grid are incorrect
• Error page image is being cut-off
• Validations DropDown in the Property Grid allows moving through items with up and down arrows
• AutoMapping of fields for MySQL does not happen
• Horizontal Scrollbar is in the middle of the dropdown of the ReferenceComboBox
• Admin section does not populate the Page property on the Access Denied error page
• When all submenu items are unaccessible, hide the top level item
• Executing a stored proc via a query lists the parameters of the stored proc as parameters to the query
• DataSource toolbar menu does not highlight the submenu hovering over
• Tab order is not correct for the properties of the TextBox
• When opening the Stadium Designer, an exception is thrown if access is denied to the pc's environment properties
• Exception thrown when pasting an action on the page canvas
• The latest styles and scripts are not used on applications created on Stadium 5.7 and then upgraded to Stadium 5.8
• When dragging a table, view or column into a query below the sql text, a No-entry icon is shown
• Do not ask to remember the password when creating a windows authenticated admin user
• Prevent update queries being assigned as datasource for datagrids
• Property dropdown does not close when tabbing between programs
• Cannot call methods on References in the Expression Editor
• Tables & Views cannot be retrieved for example database, Wide Wolrd Importers
• Update PropertyGrid when adding or removing MenuItems on the canvas
• Image on the ErrorPage jumps to the left of the text at a certain width
• Do not allow Expressions on control properties
• DataGrid column not updating property grid when Database was selected
• ReferenceComboBox throws NullReferenceException in certain scenarios
• The Help file menu remains highlighted after the dialog closes
• DataGrid did not resolve fields correctly with spaces in the name
• 'Internal Server Error' exception occurs when testing the database connection

Stadium 5.7.1913.5819 is now available

The new version of Stadium 5 has exciting new features and improvements handing the designer of applications a lot more control and power.

I would like to draw your attention to some of these new features:

• Direct Page/Script interaction

  Scripts were seen as closed entities, not having access to the controls on the same page except via script parameters. This has been changed. Controls on the same page can now be accessed directly from your script. You can also set properties of controls using the new SetValue action.

• Session Variables: Logged-in user information

  Basic information of the logged-in user can now be used in the application. This information will only be populated if your site makes use of authentication, i.e. not an anonymous site.

• New Action: Variable

  Variables are moved from script level to be items within the script, enabling the variables to have scope.

• Allow a user to change his own password

Other added features, improvements and bug fixes are listed below:

Features

• Create the error, access denied and 404 pages
• Move the nuget packages to MyGet
• Change Stadium application icon for the designer
• Admin section: Change the 'To Application' menu item to be an arrow
• A new node to the Application Explorer should immediately be in edit mode
• Change the FormWizard scripts to make use of direct page / script interaction
• Change the name of the FormWizard scripts that are generated
• Speed up opening the designer
• Limit the Application Name to 49 characters due to IIS restrictions
• In the generated application, prevent firing a script twice on double click
• Order queries/stored procs alphabetically in ReferenceCombobox
• Change the file menu 'Release Notes' to 'Stadium 5 Blog'
• Introduce a Tables & Columns pane on the Query Editor
• Query Editor: Implement SQL syntax highlighting
• Add a "quick help" to the DataGrid Search
• ExecuteSQLCommand: Allow results and output parameters to be used further down in script
• CallWebService: Allow using result further down in the script
• UploadFile control should return uploaded filename
• More descriptive error messages on UploadFile control
• DataGrid and ExecuteSQLCommand should not allow typing a value into the DataSource property
• Remove SetOutput and SetVariable actions (the SetValue action replaces them)
• New Action: SetValue

Improvement

• Better naming of a Copy-pasted item
• Improved upgrading process via the Designer
• Remove the hamburgers from the query/stored proc parameters
• Show more information when a exception is thrown on save
• Space items equally on the menu bar
• DataGrid LinkColumn on a template threw an exception
• Script Variables Editor in Property Grid caused an exception
• Event Info not updating in Designer

Bug

• [STADFIVE-1843] - Control added at top of canvas if dropped at the bottom of the page
• [STADFIVE-1989] - LayoutTable inserts new row at wrong index
• [STADFIVE-1990] - Merge places all the controls horizontally next to each other
• [STADFIVE-1991] - Unnecessary wrapping of controls in LayoutGrid
• [STADFIVE-1996] - Set CurrentObject after deleting a control
• [STADFIVE-1997] - Script canvas loses focus after delete
• [STADFIVE-2003] - Query Pane Fields and Parameters has too many tab stops
• [STADFIVE-2004] - LayoutGrid always stacks controls
• [STADFIVE-2006] - LayoutGrid holds onto focus after merging cells (Causes copy paste and context menu issues)
• [STADFIVE-2009] - Query / Stored Proc naming issue
• [STADFIVE-2013] - Caching causes page to remember previous page parameter value
• [STADFIVE-2014] - Do not open sapz files made in future versions of Stadium
• [STADFIVE-2019] - Application Explorer node loses focus after renaming
• [STADFIVE-2020] - Cannot edit DataGrid Column headers on the canvas
• [STADFIVE-2023] - Error when opening file
• [STADFIVE-2026] - Deleting a script from an event causes NullReferenceException
• [STADFIVE-2029] - Canceling event creation causes NullReferenceException
• [STADFIVE-2031] - Copying and pasting a query causes error when trying to save the file later
• [STADFIVE-2034] - Designer throws exception when adding a control to the page
• [STADFIVE-2039] - Stadium Designer crashes
• [STADFIVE-2041] - Create new application using Folder toolbar button causes exception
• [STADFIVE-2043] - Not allowed to drop action on second drag
• [STADFIVE-2045] - Fields and Parameters Selection colour is wrong shade of blue
• [STADFIVE-2052] - Clicking on a DataGrid column does not select the column
• [STADFIVE-2056] - Installer drops the DownloadAllVersions appSetting
• [STADFIVE-2061] - DataGrid column Header Text should update if the field name changes
• [STADFIVE-2062] - Edge issue: Cannot scroll on a readonly Textbox
• [STADFIVE-2063] - ReferenceCombobox tabs into the 'hint' textbox
• [STADFIVE-2064] - Stadium error page: Page and Control are always blank
• [STADFIVE-2066] - Form Wizard throws NullReferenceException
• [STADFIVE-2067] - Name not displaying in Property Explorer for certain elements
• [STADFIVE-2069] - Upgrading Stadium removes the Custom.css from the WebApp.Template
• [STADFIVE-2070] - When generating over an existing IIS application, an error is occasionally thrown
• [STADFIVE-2071] - Cancel on the Application Explorer loses focus
• [STADFIVE-2072] - Form Wizard throws an exception when generating the form
• [STADFIVE-2075] - Some generated pages cause a syntax error in the web console
• [STADFIVE-2080] - Generation throws an System.Data.Entity.Infrastructure.DbUpdateException exception
• [STADFIVE-2082] - Make ReferenceCombobox dropdown longer
• [STADFIVE-2084] - NullReferenceException thrown on save
• [STADFIVE-2089] - Images are not viewable when visiting the site remotely
• [STADFIVE-2106] - ReferenceComboBox does not want to close
• [STADFIVE-2110] - IIS Worker process crashes
• [STADFIVE-2115] - Property Grid loses focus when spacebar is used to check checkbox
• [STADFIVE-2132] - Setting the width of the image to 'auto' renders incorrectly
• [STADFIVE-2134] - Strange behaviour when dragging the designer window
• [STADFIVE-2140] - Error is hidden behind designer when opening a sapz file by double clicking
• [STADFIVE-2155] - Invisible elements can be seen when the page loads
• [STADFIVE-2165] - Dragging a control causes a NullReferenceException
• [STADFIVE-2203] - Sql Server type 'geography' throws error when retrieving Fields & Parameters
• [STADFIVE-2206] - New Page icon is disabled on context menus
• [STADFIVE-2231] - Moving the DataGrid into a Panel causes a object reference error
• [STADFIVE-2232] - Field names and query column names with spaces in cause script errors
• [STADFIVE-2235] - Canceling an event creation throws object reference exception
• [STADFIVE-2240] - Designer crashes when attempting to open the databases dropdown on the Query Editor with a faulty connection
• [STADFIVE-2241] - Database dropdown in the Query Editor toggles without something happening
• [STADFIVE-2242] - Connection String Editor can be closed without closing the popup dialog first
• [STADFIVE-2243] - List of open pages and scripts doubles up the icons
• [STADFIVE-2251] - Hyperlink in a column of the DataGrid does not wrap
• [STADFIVE-2253] - Can't change the case of headers or querystrings on the CallWebService action
• [STADFIVE-2258] - Keep Query tab open when something changed
• [STADFIVE-2230] - ODBC and Oracle render illegal column names

Thanks to the entire team: Bernhard, Anthony, Amol, DT, Rafael, Solveig, Franz and Leah! Welcome to Solveig who joined our team in July.

Stadium 5.6.1786.5197 is available

Stadium 5.6.1786.5197 is now available. Head over to the Stadium Website to download it.

Important new features:

• Feedback
  User feedback is very important to us. That is why we introduced a way for you to tell us what you think and which features you feel are missing straight from within the Stadium Designer. So please tell us!! :D
• Optimized query execution
  If the same query is used multiple times per page, code will be generated to execute the query once and re-use the result.
• Updating of the generated application
  Generating from the Stadium Designer will always update all settings on the site - After the initial generation of the web application via the Stadium Designer, the application can be updated via 2 different methods:
  1. Via the Stadium Designer (using the 'Run' button) - This is seen as debugging your application and will always use the settings defined in the sapz file as the source. Any settings on the generated web app will be overwritten with the values found in the sapz file.
  2. Via the Admin Site (using the Upload Application feature) - This should be used to update production or live environments. Using this route will not update/change any connections or settings  that have been altered on the Settings page of the Admin Site (altered connections/settings are indicated by the word 'edited' displayed next to them). Only the unaltered connections/settings that have been changed/added in the sapz file will be updated/added on the site. 
• Notification action
  This action displays toastr notifications to the user. Use this to keep your user updated as to what your script is busy doing or what your script accomplished.
• Save and Cancel was re-introduced on the dialogs
• Separated filename from Virtual Directory name
  Because of the differences between what a filename allows and what a Virtual Directory name allows, we thought it useful to split the two. Should you wish to, you can now set the Application Name (Virtual Directory Name) in the Stadium Designer. If not, we will sanitize the filename and use that as the Virtual Directory Name.

Things you need to know:

We had a bug on panels specifying transparent borders. When applications saved these panels, they were incorrectly specified as white. This has been fixed in the latest version but unfortunately requires you to manually set them back to Transparent when opening the application in the Designer.

Among other new features and improvements are:

• No data being returned is now handled as an empty value and not as a problem / exception anymore.
• Introduced a delete button on editors displaying a list of items
• Stabilized the Upload Application feature on the Admin site.
• TextBox now renders out an <input> if it is specified to only have 1 line. Previously, it would always render out a textarea.
• RadioButtonList defaults can now be set using a single string coming from a query
• Improved the Login screen
• Menu and toolbar changes
• 'Add a query' button was removed from the Form Wizard
• Show a clearer message to the user when a sql error occurs
• On scripting, allow placing other actions after a GetFile action
• Started our journey to even more powerful ways of using DataSources
• Queries and Stored Procs are now grouped per connection in the Application Explorer
• The Query Editor is now being displayed on the Canvas instead of a popup

Bug fixes:

• IIS Express Port specified in the config file was not used
• RadioButtonList with no default value caused a script error
• GetFile 
• failed to open pdf files
• did not stop executing the script when it failed
• FileUpload control did not clear the filename from the textbox after upload
• Queries specified but not being used in the application should not cause errors during generation
• Query failed when using a page parameter that is not present in the QueryString
• Renaming Query Parameters incorrectly updated them in the sql text
• Certain query parameter types caused errors during runtime
• An exception occurred when using the Form Wizard on a datagrid found inside of a panel
• Transparent panel borders did not take the theme into account
• Stadium did not successfully convert strings to Guid's
• Menu control: submenu items could not be deleted via the Menu Items Editor
• Form Wizard threw an exception if the focus was on a folder in the Application Explorer
• Cannot paste to the page canvas if the page was selected via the tab at the top of the canvas
• Copy paste issue regarding Layout Table control
• Error occurred when clicking on the Event Validation
• Double clicking a Decision Condition Validation did not open the Conditions Editor
• Drag drop issues
• UI related fixes:
• The DropDown control jumped around when clicking on it in the Stadium Designer
• Issue around the Context Menu when moving from grid column to the page
• The canvas jumped up when adding controls to the LayoutGrid
• Canvas jumped when selecting controls
• ReferenceCombobox with parameters caused property grid alignment issues
• Admin Site:
• The 'Enter' key should not add a newline when editing a connection on the Settings page
• Several other bugs were fixed

Thanks to the entire team: Bernhard, Anthony, Greg, Amol, Darshit, Franz and Leah! And welcome to Rafael who joined our team a week ago.

Stadium 5.5.1723.4875 is available

Good news! Stadium 5.5.1723.4875 is now available with lots of long awaited functionalities. Head over to the Stadium Website to download it.

Among the new features and improvements are:

• Themes for the generated websites
• Quick Form Generation
• Templates
• Application Security
• Settings can now be set on the site itself, and not only via the designer
• ODBC Preparser - Parameters can now be defined using sql syntax, e.g. @myParameter, instead of the normal '?' character
• Improved behaviour surrounding validations
• In addition to the "generate & browse", it is now possible to only generate the code.
• Application, pages, folders and scripts can now be renamed directly from the Application Explorer
• Underscores (_) are allowed in all names
• Ctrl+W will close the active canvas
• Dialogs can be resized
• Usability improvements
• Lots of other bug fixes

Thanks to the entire team: Bernhard, Anthony, Greg, Amol, Darshit, Franz and Leah! And also to Brenna who still had a part in most of this release.

Stadium 5.4.1586.4260 is available

Head on over to the Stadium Website to download it. It contains the following new features and fixes.

• Generated Applications now use Bootstrap. There is one theme for now, more will follow soon.
• A new Layout Control, LayoutGrid is available. It is based on the Bootstrap Grid system. See the Stadium Help site for more details on how to use it: http://help.stadium.twenty57.com/Controls/Layout%20Grid
• The look and feel of the designer has been revamped
• It is easier to view and map parameters on control and action properties
• If a child menu is added to a menu item, the validation for the parent menu item is removed
• Load time of files has been improved
• The Result/Error wrapper on the Web Service response has been removed
• All the Web Service errors are written out instead of being aggregated
• More padding at the top and the bottom of the designer
• Rendered controls in the designer are smaller to make it easier to see how you page will look
• Auto scroll to the bottom of the designer when placing a new control below the last control
• Fix the Add Query/Connection/Constant link to the top of the page
• Better scrolling on the Connections/Queries/Constants pages
• Better error messages in the Designer
• Roll back to previous working version if upload and generation of application fails for some reason
• Bug Fix: Expose query parameters on script input mappings

A big thanks to Amol, Anton, Anthony, Bernhard, Darshit and Greg for the dev work and to Leah and Franz for the design and UX input.

Stadium 5.2.1484.3745 is available

If you already have Stadium 5 installed, the designer should prompt you to install it the next time you open it. Otherwise head over to the Stadium website and download it now!

• ODBC Connections to databases like MySQL, DB2 and PosgreSQL are now supported
  • You'll need to set up a User DSN for connecting in the Designer and a Service DSN for connecting via the server
  • Only text queries are supported at this stage
  • Parameters are specified using a ? and display as Parameter1, Parameter2 etc in the Designer (eg select * from Products where ProductId = ?)
• Cut Copy Paste has been reintroduced. It works on Pages, Scripts, Controls and Actions
  
  • When copying individual controls/actions across pages/scripts, page/script specific mappings will be lost
• Validation messages in the designer for unmapped properties and events
  
  • Double click on the validation to bring the control into focus.
  • Once the property has been mapped, the validation disappears
• Upgrade to .net Framework 4.6
  
  • the installer will download and install it if needed
• Upgrade to IIS 10 Express
  
  •  the installer will download and install it if needed to run Generated Apps (no IIS on the PC)
• Create a default Stadium5 App Pool and run all uploaded applications through it
• Required Field Validator added to Checkbox List
• Redesign of the Query Editor - see your parameters and fields on one screen
• Rename query parameters - useful for ODBC queries where all parameters are written as ‘?’ in the query and display as Parameter1, Parameter2 etc in the Designer
• Manually pull query fields and parameters
  
  •  they are no longer automatically refreshed
• Connections - Only persist if a server or dsn is specified
• Queries - only persist if SQL has been specified
• Toolbox Controls listed in one section
• Right-click context menu on open tabs with options to close all, float and dock tabs, close current tab and close all but this
• Visible And Read-Only properties on Checkbox, Checkbox List, Date Picker, Drop Down, Panel, Radio Button List and TextBox can now be set using Query Fields, Page Parameters and Constants as well as a static True/False value
• Better handling of Images
• Fix security permissions errors when the Designer is not run as an Administrator
• Security Certificate Updated

Thanks to Anton, Amol, Darshit, Greg and Shaun for all the dev work

Stadium 5.2.1426.3566 is available

Stadium 5.2.1426.3566 is available, head over to the Stadium website to download it and get started!

There have been a lot of back-end changes to how Stadium 5 works. We've tried to make the upgrade from earlier versions as smooth as possible but some things might still go wrong. If you have problems upgrading your version or opening existing files please let me know. We'll do our best to solve the issue.

Here's what is new in this build

• Improved Designer performance - opening, saving and working with SAPZ Files
• Simplified install
• Default locations to save sapz files and the generated web apps changed to minimise issues with security permissions on Program Files
• We've removed the Stadium server (localhost\Stadium5). A redesigned interface to manage applications and securities will be implemented in the future
• New Controls - Image, Radio Button List, Checkbox List and Checkbox
• New properties on Form Controls - Label, Label Position, Read-Only and Visible
• New Action - For Each
  
  • Use it to loop through the selected options from a Checkbox List
• Events have moved off the controls and onto the page in a separate window. This will allow us to add other event types more easily
• Support for Oracle connections and text queries - no stored procedures and packages support yet
• Only prompt you to save the file if there have been changes
• Stadium Header and logo removed from the uploaded applications - add in your own
• Application Title property has been removed and page title is defaulted to the page name and displayed on the tab
• Prevent you from opening a file in an earlier version of Stadium than it was last edited in
• Fix: Application upload works when using IIS Express
• Fix: Grid wrap with long values
• Fix: Attempt to load as much information in a corrupted file rather than stopping it from opening all together
• Fix: Allow Double Quotes and apostrophes to be passed from constants into scripts

Stadium 5.2.1262.3088 released

If you already have Stadium 5 installed the Designer will prompt you to install it next time you open it. Otherwise head over to the Stadium Website and get going!

The big changes are all in the background, so as a user you won't see many differences, but we've laid the ground work for Undo, a more responsive designer, and adding in cool new controls and actions.

Here is a list of what you will see

• Easier to Upload and Browse your Application - more prominent button and clearer wording
• Tool tips on the various properties
• Clearer options on the Upload File control
• Decision shows you what your conditions are on the canvas
• Better handling of potential IIS Directory name clashes - We now give each file a unique GUID so we can track it properly and know whether we created it or not
• Copy and Paste between pages works more smoothly

Expect more regular updates and releases going forward. So get building and let us know what you think, and what control or action you really want.

New version of Stadium 5: 5.1.1084.2281

The second Stadium 5 Beta release is on the Stadium Website so head over and download it now.

If you haven't used Stadium 5 yet, what are you waiting for? It is quick and easy to install and if you don't have the prerequisites (.net Framework 4.5 and IIS/IIS Express) installed, Stadium will download and install them automatically. And once installed, the designer will tell you whenever there is a new release available.

NB: If you do have the first Beta release of Stadium installed you will need to do a clean install of this version. We have a completely new installer and have changed the way we handle file updates on upgrades. These changes should ensure that this is the last time a clean install is needed!

1. Make a backup of your 'Application and User List File' so you don't lose the list of Users and uploaded Apps. You will find it here: C:\ProgramData\Stadium5\ApplicationStorage. It is an encrypted file so you won't be able to read its contents


2. Uninstall your existing Stadium from the Programs list


3. Delete all the remaining install files and folders EXCEPT the Configuration folder. This allows you to keep all your existing applications


4. Now run the new installer. It doesn't matter if you already have a Virtual Directory, Stadium will handle it if they have the same name


5. If you kept the Application Storage file, your login credentials should still be the same. The user specified as part of this install will also be an admin user


6. If you didn't keep your Application Storage file you will need to delete your existing Application Virtual Directories from IIS before uploading them again

So what does this release of Stadium 5 include?

New Installer

• Checks the pre-requisites and installs them if needed - .net Framework 4.5 and IIS Express 8
  
  • We'll only install IIS Express if you don't have IIS running on your machine
• One page to complete everything

One Click Deploy

• Button located in the Menu icons
• Your file is uploaded to localhost and opens in your default browser
• It will automatically save the changes and if it is a new file prompt you to Save it before continuing
• Applications uploaded from the designer are always uploaded without Authentication
• Note:  Applications are created using the application name in the designer. This is both the title of the Application and the name of the IIS Virtual Directory. This name can contain spaces and it cannot be edited on the Admin site at any point

New Layout Control - Table

• Drag it onto a page and put other controls into each cell of the table
• Allows you to space controls consistently, especially when building a form

Updates to Existing Controls

• Default Date property added to the Date Picker
• Quick Links to add a Constant, Query or Page Parameter directly from the control/action properties if none exist
• Add a variable or output parameter immediately if none exist and you try to set one
• Link Validations to Buttons and Links. You can't save an input if the validations don't pass
• Easier to use connections editor


• If you specify Windows Authentication you need to make the IIS AppPool/DefaultAppPool user a valid user on the Server and the Database. The Application uses the App Pool Identity by default as the Windows Authentication User

Improved Designer Interaction

• One click open of pages and scripts. If you don't interact with it, it will close. If you do, it will remain open. Double-click will keep the page or script open
• One click open of constants, connections and queries. Once you click away, they automatically close
• Copy and Move of controls, actions, pages and scripts. It works similarly to Stadium 4 at the moment. Have both pages or scripts open next to each other to copy and move controls and scripts between them
• The .sap and .sap.config files have been combined into one .sapz file. The designer will still open .sap files but will automatically save all files as .sapz. The Upload functionality on the Stadium 5 Admin Site will only accept the single .sapz file.
• New icons
• Properties grouping changed
• Access the Online Help directly from the designer: F1, Help>View Help or click the icon next to every control and action

New Look and Feel for the Applications

• Default Theme has been refreshed
• It is clean, modern and gives a sense of space

  

IIS vs IIS Express

Stadium needs either IIS or IIS Express to host the admin site and your applications. If you have IIS installed we will run everything off it. The Stadium Admin site will be at http://localhost/Stadium5 and your applications will be at http://localhost/{ApplicationName}.

If we install IIS Express we will run everything off it. The Stadium Admin Site will be at http://localhost:8032/Stadium5 and your applications will be at http://localhost:8033/{ApplicationName}. They run off different ports because this allows us to Start and Stop the application server to refresh the list when applications are uploaded, refreshed and deleted while keeping the Admin site running. You can start the Web Server from the Designer (File>Start Web Server) and an IIS Express Icon lives in the Icon Tray. You can also access all your sites from here and stop them if needed.

What is next?

• A new look and feel for the designer. We're making sure the Stadium Branding is consistent
• Search in the designer
• Auto complete lists of options in the designer to make it easier to assign the right value to a property
• Warnings when properties haven't been mapped
• Add your own layout templates to decide what the pages should look like

A very big thank you to Anton, Shaun, Amol, Ryan, Dina, Franz and Shamima for all the development, design, testing, great ideas and fun times.

Stadium 5 Beta is available

You can download the beta from http://stadium.twenty57.com so head over and take it for a spin. A very big thank you to Dina, Anton, Shaun, Amol, Ryan, Franz and Shamima for all their hard work, ideas and support.

Stadium 5 is not compatible with Stadium 4. It has a simplified control and functionality set and events and actions are implemented in a completely new way. It can be run side by side with earlier versions of Stadium.

Auto Update

Stadium checks for a new version when you open the designer. If there is one, it will offer to install it.

What you See is What you Get Designer

Controls are displayed in the designer canvas similarly to how they will look in your browser. You can place controls horizontally or vertically without needing panels.

Scripts to execute your click events

We have introduced Scripts in Stadium 5. Scripts are self-contained pieces of code that will do the work when you click a button or link. The components in your script aren't exposed directly to your page controls and your controls aren't exposed to the script components. You will need to create input and output parameters on the script and use these to pass information between your page and your script. The idea behind this is that it allows the same script to be used in different places on the same page and is a better framework for introducing custom actions, allowing the same script to be used across different pages and executing a script on different events, not only click.

Build your own form: stand-alone controls rather than a data input

Instead of a data input control we have created separate controls so you can build the form you want in the layout that suits you best.

Data Model/Data sources

Write all your queries in one place and select which one you want to link to a control or component. You can use the same query in multiple places.

Help

Help is available online: http://help.stadium.twenty57.com. Click the help icon in the menu bar.

Stand Alone Applications as separate sites

Every Stadium application uploaded generates its own code with a separate IIS website and a unique URL. This means you can customise every application in a different way and the generated application is portable and can be installed on any server. To navigate to any application, use this URL.

Admin UI

The Stadium Admin website is only used to manage your applications and users. If you aren't an admin user, you won't be able to access it. If you run many applications and you want one website where the end users can access all of them, build it in Stadium!

Authentication

When you upload a SAP File you can choose whether people need a log-in to access it or whether it should be open for any one with the url. If you require authentication, your application is created with the same authentication method applied to your Stadium Admin Site.

Browser Compatibility

We use HTML5, CSS3 and JS to ensure your site will run in any modern browser as well as on mobile.

No Database needed

Stadium 5 is not dependent on SQL Server to store your application and user information. It is stored in memory. We will look at allowing you to integrate with a database in future releases.