Monday, 18 December 2017

The Year in Review and Our Plans for 2018

As this year comes to a close, we at Stadium wanted to reflect on the year that has been, and look forward to the year ahead. Most importantly, we want to thank you, our users, for trusting us to meet your development needs and look forward to working with you in 2018.

A year ago we had spreadsheets full of goals and we’re proud to say we knocked (most of) them out of the park. Thank you for making 2017 unforgettable.

In 2017, we were proud to bring you

  • Direct Page-Script interaction

    Being able to access page controls directly from inside scripts allows for simplified and more powerful scripting.
  • Session Variables: Logged-in user information

    Basic information of the logged-in user can now be used in the application.
  • User REST Web Api

    Basic management of the Stadium users in generated applications.
  • Simplified query creation

    Use the Tables & Views Pane to quickly and easily generate queries for specific tables or views. Also use this pane to see what tables and columns are available in your database while writing your query.
  • Expressions

    Build expressions by using a combination of javascript and application values and then assign the result of the expression to either controls or actions.

What’s in store for 2018!?

We are already planning some exciting updates, including more features, updates to the UI and a further streamlined experience including a new website.
  • Events

    PageLoad and OnChange are some of the many other events we will be introducing. This will allow designers to greatly enhance the interactivity and the user experience of applications built with Stadium.
  • Static Data

    Include files & images as static data into your Stadium application and use them in controls and actions.
  • Stadium Server

    The Stadium Server will allow deploying applications to remote servers as well as managing your already generated applications.
  • File System DataSource

    A DataSource that will allow you to access your filesystem.
  • WebService DataSource

    This DataSource will allow you to invoke and use a WebService like you would a database.

Lastly, we want to implement the great feedback you are giving us - so please continue to let us know what you’re working on and never be shy to suggest new features and improvements.

It’s been a year of highs and lows, but one thing is certain: all of us at Stadium are proud of what we and our users have accomplished in the past year. Your work is the reason why we come to work everyday. We are dedicated to bring your ideas, your creativity, and your businesses to life on the web - and we couldn’t do it without you.

Happy holidays

The Stadium team

Tuesday, 28 November 2017

Stadium 4.2.2836.6165 is now available

Stadium 4.2.2836.6165 is available for download from the Twenty57 website. It contains the following bug fixes:
  • RDL Report Viewer fails to expand rows (#2938)
  • IsExportable on Links does not work (#2887)
  • Changes to Stadium Concurrent Login (#2873)

Friday, 20 October 2017

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

Thursday, 19 October 2017

Stadium 4.2.2833.6157 is available

Stadium 4.2.2833.6157 is available for download from the Twenty57 website. It contains the following bug fixes:
  • GridIterator CheckBoxList variable not returning a value (Zendesk #2874)

Friday, 22 September 2017

Stadium 4.2.2832.6155 is available

Stadium 4.2.2832.6155 is available for download from the Twenty57 website. It contains the following:
  • Standard Bank Security Issues (Zendesk #2667)
  • DataGrid SelectAllCheckBox column selects all checkboxes across all DataGrids on the page (Zendesk #2806)
  • Image control cropping issue when on the same page as an UploadFile control (Zendesk #2801)

Wednesday, 16 August 2017

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.

Friday, 28 July 2017

Stadium 4.2.2831.6148 is available

Stadium 4.2.2831.6148 is available for download from the Twenty57 website. It contains the following:
  • Add a 'Crop Height' and 'Crop Width' property to the ImageViewer for fixed size cropping (Zendesk #2584)