Posted @ 03/26/2015 04:47 PM
Date: July 6, 2016
XOG & Query Bridge Version 1.4.0 
New in 1.4.0
- Menu integration with Integration Manager.
- Several usability and performance improvements.
- Bug fixes.
Improvements
- New option in XOG tool and NSQL tool to periodically refresh the output preview.
- Now Text Files (.txt) are allowed as data sources for Data loader tool.
- New Clear button in ‘Transform with XSLT’.
- Better visualization for big NSQL queries.
Bugs fixed
- The Data loader tool ignores the delimiter when enclosed in double quotes, in any column of the data source file.
Other changes
- When running existing queries, the queries list, the filters and the parameters are now displayed in alphabetical order.
Date: January 5, 2016
XOG & Query Bridge Version 1.3.0
New Login Procedure in Version 1.3.0
- STEPS TO LOGIN:
All users now must login using their email address that was registered with their account instead of their previous Username and reset their password the first time they login to XQ Version 1.3.0
1) Enter your email address that you registered your XQ account with
2) Click on “Reset Password” and complete the form.
3) Your account is now ready with your new login credentials and happy XOGing
New in 1.3.0
- New authentication module based on Keycloak, with a new login procedure.
- New Application UI, including selectable themes
- New ‘Clear’ button below the input area in SQL tool and XOG tool
- Users are now able to set a preferred CA PPM environment
- Several usability and performance improvements
Improvements
- Execute existing queries improved functionality
- The column order in the query output now coincides with the order defined in the SQL statement
- “No record found” message removed from the query output during query processing
- In the XOG tool the apply stylesheet option is activated only when selecting a zip file
- New Bulk XOG request status: ‘IN QUEUE’ to better inform the user about pending requests
- Authentication form enabled from the XSL Transformation tool
Bugs fixed
- Issues that caused query parameter filters not to display correctly in the SQL tool
Other changes
- Modified query execution logic to optimize the application memory consumption
XOG & Query Bridge Version 1.2.1
New in 1.2.1
- XQ has improved interactive user documentation. Now it is much easier to search and browser for the help content: http://kb.itroisolutions.com
Improvements
- N/A
Bugs fixes
- Defects in the Data Loader tool.
- Refresh button when running a single XOG request now works.
Other changes
- N/A
Updated: September 8, 2015
XOG & Query Bridge Version 1.2.0
New Data Loader tool:
The big change with version 1.2.0 is the inclusion of a new Data Loader tool. The tool provides a GUI that allows you to easily map Microsoft Excel/CSV files to XOG (XML) files.
New in 1.2.0
- A new simple and easy to use GUI that allows the mapping of Micorsoft Excel/CSV files to XOG (XML) files.
- Visualization enhancements to the User Guide.
- Bugs fixed in the queries execution with parameters.
Improvements
- N/A
Bugs fixes
- Several NSQL execution defects.
Other changes
- N/A
XOG & Query Bridge Version 1.1.1
New in 1.1.1
- XSLT transformations are stored in bulk XOG requests responses (ZIP files) when ‘Apply stylesheet’ is enabled.
- ‘CA PPM URL’ and ‘CA PPM username’ are added as new columns in the execution history table.
- Enhancements in user guide visualization (It is displayed in a more user-friendly document viewer)
- Tab navigation is enabled in the ‘Transform XML with XSLT’ tool
- Enhancements in ‘Run existing NSQL’ functionality: Dynamic input filter, more user-friendly controls, bugs fixed in the queries execution with parameters, button to refresh existing queries list.
- Ability to switch credentials without interrupting XOGs requests in progress.
Improvements
- Allow naming of XQ queries: Query name/id validation before overwriting it.
- ‘Test Connection’ functionality added.
- Added buttons in ‘Transform XML with XSLT’ tool: Copy to clipboard (desktop version only), Download XML or Copy to single xog request box.
Bugs fixes
- Several NSQL execution defects.
- Short filenames error (3 characters or less) during file upload for bulk requests.
Other changes
- N/A
XOG & Query Bridge Version 1.1.0
New in 1.1.0
- New feature to run existing CA PPM queries.
- Fixed the footer link to the XQ Blog.
- Enhancements in CA PPM login validation and errors messages.
- Attach the results in email and send notification now are checked by default.
- Ability to synchronize URLs between XQ web and XQ desktop versions.
Improvements
- NA
Bugs fixes
- URL alias is mandatory
- Characters that cause errors in a URL aliases are prohibited ‘-‘, ‘¬’,’:’,’;’ ‘|’
Other changes
- New XQ demo video has been added to the login page.
Version 1.0.9
April 14, 2015
New in 1.0.9
- Now you can view and edit the name of the NSQL query.
- The name of the NSQL query is set to maximum size of 50 characters and special characters are avoided.
- Desktop version is now downloaded as a ZIP file.
- Desktop version features new artwork (new icon set).
- Footer link updated with our Privacy Policy
Improvements
- NA
Bugs fixes
- Allow naming of NSQL queries, critical errors found when username is too long
Other changes
- Corporate logos redirect to related information.
Download the User Guide: XOG-Query-Bridge-UserGuide-v1.0.9
Version 1.0.8
March 16, 2015
New in 1.0.8
- Links have been added to the application icons: IT-ROI logo redirects to IT-ROI corporate website, XQ Bridge logo redirects to the application home.
- Downloadable files have been added, a suffix indicating the result of the XOG requests: e.g. T3_I2_U1_F0, where:T = Total, I = Inserted, U = Updated, F = Failed
- The log generated upon each bulk request has been enhanced to include the XOG request result statistics: number of total, inserted, updated and failed records. It ONLY applies for requests submitted after the installation of the new version.
Improvements
- Rename results zip file based on the XOG request result statistics for enhanced usability.
Bugs fixes
- Browser cache settings have been disabled.
- Error occurring when trying to download the result of a canceled request.
Other changes
- Administration features to facilitate the password reset support activities.
Version 1.0.7
March 02, 2015
New in 1.0.7
- Connection blocking for HTTP methods: PUT, DELETE, OPTIONS
- Clickjacking Protection for Java EE
- Error 403 page added, Forbidden Access.
- URL-path of the form /xogbridge/../xogbridge have been forbidden.
- 10 MB limit for Bulk XOG request has been implemented.
- Increased performance in database connections, 35% less.
Improvements
- Reduced consumption of database connections, 35% less.
Bugs fixed
N/A
Version 1.0.6
February 02, 2015
New in 1.0.6
- Several UI/UX tweaks and improvements.
- Improvements on user registration authentication data control.
Improvements
- Added IDs for all controls to facilitate regression testing.
Bugs fixed
- Minor adjustments in web interface
Other changes
N/A
Version 1.0.5
November 21, 2014
New in 1.0.5
- Several UI/UX tweaks and improvements.
- Added user account administration feature for support activities.
Improvements
UI/UX
Bugs fixed
N/A
Other changes
N/A
Version 1.0.4
November 21, 2014
New in 1.0.4
- Version tracking made visible in the application.
- Self-explanatory messages during the request and validation of a serial key.
- Included support for requesting serial keys in case of more than 6-segment MAC addresses
Improvements
N/A
Bugs fixed
- Issues with virtual adapters or obfuscated MAC addresses of more than 6 segments
Other changes
N/A
Version 1.0.3
October 31, 2014
New in 1.0.3
- Submission of single XOG requests to any instance of CA PPM.
- Submission of bulk XOG requests (using ZIP files) to any instance of CA PPM.
- XML transformation utility based on XSLT
We welcome all feedback for XOG & Query Bridge: