Versions History

• Import of Vigilens users on the basis of their JDE equivalent by dynamic connection from Oracle JD Edwards

• Sharing a configured homepage with other users

• Dynamic management of query execution environments from JDE (JDEUTIL prerequisite)
• Ability to call the web interface using HTTPS protocol

• Web Interface Setup Application (WebConfig)
• New VglUpdateQueries application that allows you to modify (interactively or in batch mode) the data source and the Excel templates for all the queries in a tree structure.

• Complete redesign of the user interface
• Bookmark Management
• Widgets Management

• Multi-language management
• Translation of query name, description, columns, execution parameters…
• Ability to customize the query icon

• Recovery of the JDEdwards user for the execution of VIGILENS queries.
• Possibility to use the line security defined in JDEdwards by associating a JDE ROLE with a Vigilens user.

• Ribbon menus (Microsoft Office type) and new icons.
• Possibility to customize the queries icon Possibility to insert data matrix in the report editor.
• Generation of URLs corresponding to queries.
• Ability to modify numeric fields in sum and vice versa.

• “Group of queries” type queries (consecutive execution of a series of selected queries).

• Possibility to enter the operator in the parameters at runtime (and no longer only the values).

• Possibility to assign several sub-directories to a user (both for viewing shared queries and for publishing them).
• Possibility to create users of type VIGILENS DEDICATED (VIEWER with reserved access).
• Direct access to the modification of certain components of the queries (conditions, list of fields to be visualized, restitutions).
• Possibility to specify a macro to be executed after data insertion during MSExcel restitution.

• For Excel type output, the possibility to merge the range of cells corresponding to the inserted data with any existing range of cells (with the same name).
• Possibility of reducing the time needed to retrieve the data (by deactivating the record counter and the [Cancel] button).

• Possibility to apply the format defined at Vigilens level in MSExcel restitutions.

• Addition of the vglHeader parameter in Vigilens URLs allowing to choose the information to be displayed in the header. (name and descriptions of the columns).

• Possibility to set the opening of MSExcel files in a new window.

Validated compatibility with Windows 10

• New application allowing the creation of indicator pages refreshed according to a configurable frequency (requires an additional dedicated license).

• Possibility to select tables in relation to existing standard joints.
• Addition of the original query in the publication information.
• Possibility to define a format for the reconciliation fields on this type of query.

• Ability to display descriptions associated with fields such as address, cost center, company, item (JDEdwards databases only).
• Ability to export data from the consultation grid to a dynamic cross table.

• Calling a Vigilens request from a JD Edwards web menu using the connected JDE profile (requires a specific JDE application, features provided to Vigilens clients on request).

• Possibility to use the line security defined in JDEdwards by associating a JDE profile with a Vigilens user.
• Possibility to mass import Vigilens profile/JDE profile/data source associations.

• Ability to generate text files without field and/or record separator, with choice of encoding format UTF-8 Business queries.
• Availability of a pack of model queries for the Finance professions on the ERP ORACLE JDEdwards (requires a special license).

• Connection to Oracle databases with OCI instead of ODBC (better memory management for string size).
• Ability to define a DB2/400 type runtime statistics database.

• Possibility to define a time out linked to the last activity on a query (it is recommended that this time out be greater than the query execution time).
• Possibility to limit the number of lines in the result (to limit the risk of saturation of the browser memory).
• Possibility to choose the day of the beginning of the week (calendar display).

• Possibility to quickly modify the data source or the environment of a query (and possibly its subqueries) without scrolling down all the screens.

• Limitation of the number of lines in automatic mode (using the vglMaxLineNumber parameter).
• VigilensOPManage A return type “The same type as last input parameter” is now available.

• Possibility to choose the extension of text-type files.

• The query summary displays the list of recipients for email type returns.

• Date functions return the value “Null” when the data is not filled Table names are no longer case sensitive for export to a database (Oracle).

• Possibility to define Excel renderings in XLSM format (including macros).

• Possibility to define formats at user level New “IfThen” functions.

• Improved ergonomics to restrict access to data sources.

• Excel returns (no longer CSV) in web or scheduled mode (see impacts specified in the installation procedure).

• Version management for Oracle databases (V8 and lower / V9 and higher).

• Implementation of query history management (creation, modification, and publication).
• Possibility to create “full join” type joins (not available for Access and Oracle databases below V9).
• Management of the Excel document format (.xls or .xlsx).

• Email
• Barcode
• Conditional formatting

• Reports in PDF format
• Multi-request states
• Annexes (JDE)

• Web execution
• Multilingual
• Management of decimals(JDE)

First commercialized version