v 2.06.02 (5/17/2010)
- fix: DotNetNuke 5.4.1 supported
v 2.06.01 (8/2/2009)
- feature: grideEdit validator position (right/down)
- feature: descriptions for summary sql(s) and possible errors
- change (internal javascript): __indooButton.value is asigned before __indooCheckSubmit check
- change: module now forces to close possible opened connections
- bugfix: try to fix .net error when clear array (cached schema data)
- bugfix: deleting record produce unnecessary error description
- bugfix: character "&" in filter field
- bugfix: sendToken parsing
- bugfix: when inlineedit is enabled and specific record is in edit mode at same time and when validation fails for specific record then in-line edit checkboxes clear values each second time
- bugfix: validator text for expression validator is changed on second failed validation to generic value
- bugfix: expression validator takes old value for specific field when new value is empty. Expression validator not works for in-line edit also.
v 2.06.00 (7/20/2009)
- bugfix: binary column wizard (title column)
- bugfix: double executing sql onViewRecord trigger
- bugfix: extra space for last binary column
- bugfix: regular expression validators adds extra space for in-line edit option
- bugfix: when more filter type 5 (fixed filter) is set than other filters then other filters disappear.
- bugfix: second datespan button not works when general filter list is not prsent.
- feature: simple mailing support for summary mail and simple mass mailing support with [sendMail] token
- feature: token [gridEditColumn:columnName] ,[gridEditColumn:columnName:format] , [gridEditColumn:columnName:format;culture], [sqlQueryTable] , [sqlQueryList], [emailsForUsers],[emailsForRoles]..
- feature: gui - moving between columns on grid edit or grid view property pages
- feature: Table wizard - data transfer utility (for sql server only) generate scripts for transferring table structure and data between different sql servers
- change: decrypt token; when parameter is empty now returns empty string (before token was not processed at all)
- feature: payment support within now only within command tag or with tokens: [paymentIPN], [isValidIPN] and/or [paymentScript]
v 2.05.03
- feature: added option for javascript function __indooCheckSubmit for javascript check before submit
- change: validators are now into <td><span>...</span></td>, before only in <td>...</td>
- feature: error description for sql tokens
- feature: direct support for telerik radEditor
- bugfix: text formatting for joined values (rare condition)
- change: using OR operator within same filter field
- feature: execute tokens after columnField or formField value assignment (customHTML, executed at prerender so it works only with »« brackets and for gridEdit only for invisible fields that returns plain text only)
- bugfix: default value on second (or grater) multple gridEdit page at insert
- bugfix: maxlength html attribute is set regardless autoavlidator setting
- feature: support for regular tokens within custom html field
More other features
v 2.05.02 (2/17/2009)
- feature: client script function for gridEdit (for example geIndooField(gridEditID, indexOrColumnNa,e))
- feature: check for empty values in id column at table settings page
- feature: direct conditional access to gridEditColumn .Net object
- feature: new tokens getCooke, setCookie, isUserInRole, userRoleList
- feature: hide filter button and filter help
- bugfix: dependable dropdownlist
v 2.05.01 (2/11/2008)
- feature: dependable dropdowlist supports default value and sql filter
- feature: raw value within custom html gridEdit area
- feature: storable dropdown lists (filter, gridEdit)
- feature: support for binaries with specific path
- bugFix: cultureText token was parsed only once
- bugFix: date span date picker
- bugFix: update sql trigger
- bugfix: redirect with enabled in-line edit
- change: gridview GUI for binary column
v 2.05.00 (2/11/2009)
- feature: dependable dropdowlist supports default value and sql filter
- feature: raw value within custom html gridEdit area
- feature: storable dropdown lists (filter, gridEdit)
- feature: support for binaries with specific path
- bugFix: cultureText token was parsed only once
- bugFix: date span date picker
- bugFix: update sql trigger
- bugfix: redirect with enabled in-line edit
- change: gridview GUI for binary column
(2/5/2009)
- feature: add raw data for formField token (when filed is invisible)
- feature: previous/next paging with text
- feature: custom expression validator supports blank fields
- feature: gui for configurable editor (more fields)
- feature: sqlQueryTable token (for values use javascript unecape function)
- feature: support for application name with unsafe characters
- change: finish multiple trigger executes only with click on last save/finish button
- change: binary field is shown even title value is null
- bugfix: redirect after saving gridEdit record with in-line edit option on
- bugfix: paging with previous/next option
- bugfix: span datepicker
- bugfix: cultureText token does not return right text for language without default culture
- bugfix: roles for current user's portal.
- bugfix: internal workaround for possible very rare core .net system encoding/cryptographic bug.
v 2.04.00 (22.12.2008)
- feature: dnn 5.0 support
- feature: encrypt/decrypt token
- feature: disable client-side validation on all grid edit columns at once
- feature: expression validator
- feature: replace tokens on some aditional fileds
- feature: shows internal settings name as tooltip for non-ie browsers
- change: default parseTokenLimit value is increased to 30
- change: sql trigger section is separated
- fix: module show error at postback when current table is deleted within page refresh (very rare situation - without effect on module work, temporary is settings page down)
- fix: id value is not populated when in-line edit is used
- fix: more properties for editable column are not set (for property page - some binary settings for upload limitations)
- fix: send mail only once when multiple page is used (before multiple times)
- fix: when using dependable dropdownlist and null text with default value then second dropdown is not intalizated (but works when first dropdown is changed)
- change: module visibility token procedure
- feature: text fields for gridEdit buttons accept tokens now
- feature: new sqlQuery_multiplePage_# token
- change: back button for multiple page doesn't cause client-side validation any more and doesn't cause server-side validation for "required" validator. Validation for multiplepages is executed for each page request regardless data on page is changed or not (before only when data was changed).
v 2.03.02 (22.11.2008)
- fix: more categories column support
- fix: custom properties
- fix: internal image names
- fix: previous/next paging shows double page info on last page
- fix: detail view mode shows column value instead of column text on manual typed list
- fix: html attributes settings page was hidden when gridEdit join is on second (or more) multiple page
- fix: javascript is slow when lot of in-line edit columns and records is on page (1000+ editable fields)
- feature: triple click on each textarea or textbox within setting resize field for more comfortable input
v 2.03.01 BETA 2 (18.11.2008)
- feature: on delete trigger-like window , trigger works also on bulk update/insert
- fix: idvalue token within limit ddl for gridEdit culumn
v 2.03.01 BETA (17.11.2008)
- fix: update query at finish multiplepage
- fix: case insensitive token for idValue
- fix: Firefox and chrome add extra comma when download binary file
- fix: idvalue token within limit ddl for gridEdit column
v 2.03.00 (13.11.08)
- fix: alternative connection use with current database also
- fix: valueId token not works within some column properties when in-line edit is enabled
- fix: javascript error when inline edit and record edit is choosen
- fix: sql syntax for MySQL for gridEdit dropdownlist
- fix: setVisibility token is executed before compute token
- fix: category tree with more tables returns error
- fix: parsing order for getObject/setObject token
- change: module works now without proper .NET's aspnet_client folder
- feature: custom error message for part or whole field, for more possible exceptions
- feature: alternative connection accepts connection name from web.config
- feature: formatting support for dropdownlist/radiobuttonlist
- feature: extended support for parameterized getObject/setObject token
- feature: localized record count number format
- feature: double height option for editor and multiline
- feature: option for dropdownlist filter on value from main table
- feature: custom property
- change: strip html tags from grid view column tooltip
v 2.2.02 (27.9.08)
- change: module hides summary row when value isRecordGridVisible is false
- feature: filterNotExactValuePrefix supports more characters (before only one)
v 2.2.01 (25.9.08)
- fix: summaryList field's tokens
- fix: error when no records found
v 2.2.00 (21.9.08)
- feature: improved token parser (added new support for nested tokens)
- feature: add queries for informix db (settings page only)
- feature: support for dnn version 4.9.0
- feature (underlying component): remove list of url parameter(s) on execute filter event
- feature: option for gridView summary row
- feature: option for clearing dnn cache
- feature: ids for html/javascript filter's table cell manipulation
- feature (component): getObject can accept enumerated values.
- feature: removed limitation to 100 fields within table settings page (with faster execution)
- fix&change: [setModuleVisibilityByGridId:parameterValue] token works now inside first step of parsing too (first module on page should be visible).
- fix: filterOnNoRecord options shows records when filter type is set to any other value except 0 or 1
- fix: removed extra empty spaces under custom html when read-only and left labeled position is checked
- fix: client side validation
- fix: readonly/invisible/default value
- fix: javascript error fix for checkIsValid function call that is not available in some very rare cases when grid is not rendered
v 2.1.00 (4.2.08)
- version upgrade (see 1.26 for details)
v 2.0.26 (4.2.08)
- feature: print works with regular module's print button when using filters, paging or sorting for gridView
- fix: apostrophe in filter box does not work
- fix: some text properties disappeared for grid edit column
- feature: auto correct old filter settings for changed requirements in previous version
v 2.0.24 (24.2.08)
- change: gap between module main section and module footer
- core DNN bug work-around: since DNN version 4.7 (in version 4.5 also but fixed in 4.6) dnn framework require tab id or portal id url parameter for post method only for pages used in background even when page is not part of dnn framework. Module adds this senseless parameter to such page(s) and this prevent unexpected logout from child portal when regular (not admin/host) user access to grid with pictures or ajax-like functionalities. Module in previous versions of DNN works without this "feature".
v 2.00.23 (24.2.08)
- fix: when in-line editable gridView column is set as invisible and gridEdit column as visible then values on in-line save in gridView invisible column did not preserve original value.
v 2.00.22 (22.2.08)
- feature: default format culture for module header/footer special token "command"
- feature: more simple option for implementation custom text editor
- change: strip html tags from tooltip
- fix: dnn built-in editor does not show actual data from database (dnn ver 4.7,8)
- fix: first default value for page size dropdownlist
- fix: design of table settings page for firefox
v 2.00.20 and v 2.00.21
- feature: support for tokens in regular expression field
- feature: more css styles for category tree
- fix: v2.00.20 empty module shown error
- fix: when gridview column order is changed (when delete or move some columns) then custom html for columns is not moved - highly recommended update for when using gridView column custom html option (or provided templates).
v 2.0.25 (18.3.08)
- change: filter with dropdownlist on joined column now use text column from joined table
- feature: empty value with token [indoogrid:nothing] in gridEdit field value
- feature (component):isFilterExactByDefault, filterNotExactValuePrefix
- feature: custom error description
- feature: component info show module version also (for googlebot)
- fix&feature: allow readonly and invisible join on gridEdit column (dropdownList)
- fix: for IE's buggy implementation of right key (apostrophe) keycode; http://www.thescripts.com/forum/thread151666.html
- fix: some uncode characters are not valid in IE after click on filter (thank you babypig)
- fix: initial default value for source of dependable dropdownlist
v 2.00.19 (9.2.08)
- feature: improved getObject token returns now values also for functions (methods)
- feature&change: excel and word export, different server contents; now with characterset information inside file
- fix: single filter as dropdownlist when source is database table now returns exact values only (before it acts as general search)
v 2.00.18 (7.2.08)
- feature: alternative connection string and table
- feature: required field for dropdownlist field is ignored if there is no values (useful for dependable dropdownlist)
- feature: link to tablesettings from common module settings (easy access table setting page on error)
v 2.00.17 (5.2.08)
- fix: input type=file html field javascript
- feature&change: default format for [indoogrid:currentDate=<valueList>] token is now short date. token accepts format parameters now
- feature (underlying component): you can set default headerRow for text import files.
v 2.00.16 (3.2.08)
- feature: drop view option
- feature: added finish button within some wizards
- fix: remove link did change order settings on main settings page
- fix dnn tokens [DNN:originalTokenName]fix
v 2.00.02 (beta - not for production. Suggestions and comments are welcome)
- fix: when only date is changed using datepicker then record is not saved, when input with url is set then value is not saved.
- fix: dbnull for text datatype did not select dbnull value from gridEdit column dropdownlist for text field.
- fix: error occurs when no records found in gridView and a max record on page is 1
- fix: multilanguage support loads only initial language for main page
- fix&change: up caption position for gridEdit was automatically set to "left position" when in-line was set to on
- feature: full multiple page support for gridEdit
- feature: workflow support for gridEdit (condition for specific multiplePage visibility; useful for questionnaire etc)
- feature: custom HTML for gridEdit form with rich text editor .
- feature: custom HTML for gridView column with rich text editor.
- feature: dependable dropdown now can take strings as primary key for second table
- feature: token sqlQuery supports connection string now. Syntax: [sqlQuery:<query>~x<connection string>] where x is: 0 or omitted=current dnn database, 1=native sql server 2005, 2=native sql serevr pre 2005, 3=native oracle; 4=odbc. Connection string can be omitted also.
- feature: optionally replace empty captions with column names.
- feature: editable column properties visible on main page (with help)
- feature: strip optional HTML tags from filter list of columns' captions
- feature: custom gridView page size options for end-users (with no paging or previous-next mode)
- feature: gridView condition field accepts expression can compute values now
- feature: new tokens; compute, dnn, setObject2, getObject2 (2 is for workflow; tokens are executed in this order: setObject,getObject,setObject_2,getObject_2, dnn is for nested dnn tokens because dnn do not support this and deletes unknown tokens also.)
- feature: custom gridView page number is textbox (optionally) so end-user can input any page
- feature: edit, view, delete command option on URL contents
- feature: mark as red all invalid sql table/column names within setup page.
- feature: error description when single record delete fails using gridEdit (when source is not updateable)
- feature: more minor help and functionalities improvement
- feature: hide specific gridView element
- feature: show gridView sql statement, parameters and connection (for developers)
- feature: url parameter name for new inserted id
- feature: new token cultureText
- feature: when default grid edit mode is insert it allows also edit at same time now
- feature&change: two pass within single token rendering, two rendering (within onLoad and onPrerender)
- feature&change: dependable dropdownlist request is moved outside dnn framework (much faster, no error log but with some limited security)
- feature&change: grid view header css change (css is now without image). It is possible to use more rows for header title now.
- component feature: gridEdit button back can use browser history now.
beta fix:
00 - multiplepage support
01 - insert new record button
v 1.06.00 (27.11.2007)
- feature: more options for filter dropdown list.
- feature: date picker for filters
- feature: improved in-line edit performance
- feature: module supports all basic dnn tokens now + indoo tokens
- feature: you can substract or add hours, days, months, etc to currentDate token.
- feature: improved inline edit error report
- feature (component): custom error descriptions
- feature (component): custom additional width for in-line textboxes
- feature: new conversation option for current culture.
- change: raw date value (only date without time information) is now whole day time span instead of exact value
- change: checkCode change
- bugfix: gridEdit custom dropdown list selecton for default value
- bugfix: in-line edit does not save records when there are unused columns defined within gridEdit
- bugfix: dependable gridEdit dropdownlist for DNN version 4.6.0+
- bugfix: in-line edit convert to null field values for column when master in-line edit option is on and in-line edit option is off for specified column. Error occur within in-line save procedure.
v 1.05.00 (3.11.2007)
- change: option for auto refresh after in-line save.
v 1.05.00 (30.10.2007)
- change: thumbnail width and thumbnail height are max thumbnail width and max thumbnail height now
- feature: help icons are available in insert mode too.
- bugfix: binary files are repeated in some situations (rare)
- feature: allow/disallow client (javascript) validation for all types of validators
- feature: new tokens [indooGrid:binaryLink] and [indooGrid:binaryLinkImage] works only within binary column's data. Link to binary data is now only this token not whole string.
- feature: more export options (export to file, export to excel or word application etc...)
- feature: content export/import dnn feature works with internal indoo db provider now
- feature: gridView or gridEdit item (row) position now can be specified with number (before move for only one step with click on down/up icon allowed)
- feature: improved GUI for dropdown list "null text" within gridView column property page
- bugfix: using more editable modules on same page and moving with cursors keys works for more modules on same page now
- bugfix(underlying component, gridEdit object): alternate_update command for ms access works with all numeric precisions now
- feature(underlying component, gridView object): isHeaderVisible, isColumnsHeaderVisible
- feature: support for default filter column
- feature: support for dropdownlist filter values
- bugfix & change: mail validator.
- feature: default value for insert mode.
- feature: regular expression within custom HTML gridView property.
- change: default format for [indooGrid:currentDate] is now "short date pattern ", see details: http://msdn2.microsoft.com/en-us/library/system.globalization.datetimeformatinfo.aspx
v 1.04.05 (5.10.2007)
- feature: improved GUI for dropdown list "null text" within gridView column property page
- bugfix: in rare cases are editable fields within gridView on second and later pages replaced with fields from first page.
- feature: javascript alert about changes within in-line fields supports tracking changes for multiple records and/or modules on same page now.
v 1.04.04 (3.10.2007)
- bugfix: removed duplicated file names within installation package (no broken links any more)
- feature: field width now working with dropdown list too
- feature: filed width for in-line editable fields is taken from gridView column width
- feature: auto default value within create/alter table wizard (zero for numeric fields and date, empty string for text fields - for ms sql db only)
- bugfix: in some rare situations when grid shows no records using in-line edit error occur
- feature: required validator for dropdownlist (empty value is not valid)
- bugfix: dbnull value is updated on numeric, date and binary fields now.
- some minor features/changes/fixes
v 1.04.03 (19.9.2007)
- Supports DNN ver. 4.6.0+ (some breaking changes are in this DNN version)
v 1.04.02 (14.9.2007)
- More descriptive information when connection to database fails (using connection string wizard)
v 1.04.01 (12.9.2007)
- Disabled default insert and in-line editing (avoid confuzing vhen save insert or save in-line changes)
- Fix: column width for gridView for first column (without leading command columns(s)) did not work.
- field "Redirect to URL" accept tokens now.
- Fix: thumbnails (binary files) are not shown when id column (or command column) not exists within gridView.
- Module record count section is removed when is empty (no more extra space with empty header)
- New token queryStringSafeSql prevents sql injection when value from url is used within plain sql query (like WHERE clause etc). Use this when numeric value is not available.
- Some minor fixes
v 1.04.00 (24.8.07)
- Hourglass cursor after click on import button
- info about number of successfully imported rows.
- new token [indoogrid:currentURLEncrypted]
- new insert button within gridView header
- in-line edit (editable gridView )
- improved predefined search within multiple columns: now works with joined tables also
- Filter data on more columns simultaneously
- Multiple search boxes limit is set to 10 (fixed limit from 2)
- Improved performance for retrieve data from DNN database.
- Wizard for unique key column adds identity column even if primary key already exists.
- new tokens [indooGrid:moduleID],[indooGrid:tabID],[indoogrid:navigateURL] (url without parameters), [indoogrid:queryString],
- fix: grid edit with specified id not works without at least one grid view column
- fix: custom condition for empty/null values for "grid view column data from more columns"
- more tokens for queryString in numeric queryString allowed
- fix: custom formatting (in some situations) values on gridDetail in view mode
- no links on picture for full image binary
- default image for binary (picture) content
- improved getObject and setObject tokens - now accept single parameter (integer or string) with objects
- new token for sql developer [multiplyRecord=<tablename>=<recordCount>;<comma separated field list>] special token for sqlWindow only. With this token you can easy create millions of records for real testing.
- New column for composed html within gridView column preview list
- On bulk update existing records should contains import default values in specified columns otherwise update error is occur. (this functionality can prevent users updating records from other users etc)
- fix: no valid index
- fix: more minor fixes
- new tokens (sqlQuery2, setObject2, getObject2 and getNumericObject2 tokens are filled within onPrerender cycle - this is after module execution, so we can get/set values generated within load process - e.g. inserted id, updated values etc). This tokens are available only within module header/footer, html header, scriptOnStart, scriptOnSubmit and "triggers" windows.
v 1.03.06 (25.6.07)
- show dropdownlist as radio buttons
- gridView as dropDownList (record selector)
- Table settings link is not visible until module is activated (some users mix terms "table settings" and "module settings")
- supported import/export of binary files (content is base64 encoded text)
- module skips activation/license check for requests from ip 127.0.0.1 - localhost. No more time limitation for developers (license is still required for testing environment when other users access test server from other network locations)
- improved dynamic dropdownlist fill
- download binary with original filename
- convert uploaded image to jpeg and reduce it to specified size or length if uploaded size is larger then specified
- limitation for some tokens that can consume more processor resources within module header/footer in now set to 10 (before 1)
- new token sqlQuery (reserved characters: [ ] and :) - example: [sqlQuery:select username from users where userid=[User:UserID]]
- gridEdit can edit only one DB record with specified id (GUI field added, underlying component support this feature from beginning - one of most important feature. You can edit/view specified record - specially useful with sqlQuery token)
- UPGRADE CHANGE: old module's settings where is checked "Grid edit insert as default" should be manually set to "defaul grid edit mode=insert"
- fix: null text(value) for dropdownlist/radio buttons list
- fix: edit button did not work when it was shown in last column and join column was used with same name than idkeycolumnname
- GridView Order by over user sort choice (add ! before order by clause)
- Condition for null and not null value within gridView column properties
v 1.03.04 (4.6.07)
- Module does no fill unnecessary logs for redirect exception any more (user invisible but unfriendly to portal admin)
- Default textbox width fix
v 1.03.04 (4.6.07)
- detail view datepicker fix
- add new method for contact registration server (in background)
- dynamic dropdownlist is available when option "hide grid view in insert mode" fix
- version control (added version to validation code - no need to renew licence after this upgrade for each fix)
- alternative update method fix
- gridEdit “demo version” fix
- ignore wrong user input for dropdown list.
- internal database access of viewPage now uses indoo database provider.
- new wizard "Add binary (file) columns"
- component upgrade: basic update method function
- improved bulk delete
- Userguide: How to calculating totals
- Userguide: Binary (files) wizard
v 1.3.03 (30.5.07)
- double click on gridView for initial descend sort (click for ascent)
- field ORDER BY (default SQL for gridView)
- binary file download improvement
v 1.3.02 (29.5.07)
- fix (dnn controls editor, calendar,..inside gridEdit are available again)
- v1.3.0
- detail view datepicker fix
- dynamic dropdownlist is available when option "hide grid view in insert mode" fix
- alternative update method fix
- gridEdit “demo version” fix
- ignore wrong user input for dropdown list
- internal database access of viewPage now use internal indoodb provider
- new wizard "Add binary file columns"
- component upgrade: basic update method function
- Userguide: How to calculate totals and Using (binary) files wizard
- works in Medium trust environment
- new tokens [queryString:] (and [numericQueryString:] for using value within non parameterized queries), new token: [indoogrid:currentURL]
- hide record count option
- help text with edit fields
- date picker (calendar) included
- dropdown list can be dynamically filled depends on selected value from second dropdown list (for example car make and car model)
- improved bulk import/export with new options
- v1.2.0
- insert only option
- default sort for gridView column
- module header and footer option: add custom sql commands and/or JavaScript on click to custom button/link
- gridEdit insert/cancel/save button text
- hide gridView option
- execute custom SQL statements on gridEdit insert, update or module view
- show gridEdit above gridView