Previous versions

Nouvelles fonctions et améliorations dans les versions 10.6/10.7 > Previous versions

Revenir à

Nouvelles fonctions et améliorations dans les versions 10.6/10.7

Previous versions

Nouvelles fonctions dans 10.5 GA

Les jointures entre tous les champs sont prises en charge avec Winshuttle Function Module pour QUERY.
Avant l'affichage des aperçus de résultats de la requête et du nombre d'entrées, un avertissement apparaît en cas de non-correspondance des champs inclus dans la requête.
Winshuttle QUERY est compatible avec Windows 8.
Winshuttle QUERY est compatible avec Microsoft Office 2013.
Winshuttle CENTRAL est compatible avec Microsoft SharePoint 2013. Remarque : SharePoint 2013 fonctionne uniquement avec les produits Winshuttle Version 10.5.
Le module complémentaire Winshuttle RUNNER fonctionne dans Microsoft Excel 2013.
Winshuttle QUERY est compatible avec SAP GUI 7.30.
Un bouton Arrêter est désormais disponible pour arrêter les processus de jointure automatique lorsque aucune jointure n'est trouvée.
La documentation des produits Winshuttle est disponible dans l'aide Web. Les documents PDF ne sont plus disponibles.
Un aperçu des résultats de la requête est possible seulement quand la fonction Adaptive Query Throttling est activée. (Correctif 10.4.1).
Le nombre d'entrées peut être affiché seulement quand la fonction Adaptive Query Throttling est activée. Remarquer que les résultats peuvent être différents de ceux d'une exécution SQL quand la fonction Adaptive Query Throttling est désactivée. (Correctif 10.4.1).

Dans la version 10.5

QUERY et RUNNER pour QUERY

Tous les scripts multitables avec critères envoient une exception SQL Lite sur un serveur W4l NON FM
Une requête multitable envoie TIMEOUT quand les deux options Extract All + EAQT sont cochées dans WFM 10.4 GA sur W4Q
Une exécution XML pour des champs à valeur négative conduit à l'affichage d'un signe moins après la valeur (avec exécution FM seulement)
Excel Expression ne fonctionne plus après la première exécution en cas d'ajout de données au fichier de résultats
Envoie une exception à l'exécution dans WFM lors d'une jointure de champs de type de données LANG et DECIMAL
Envoie une exception à l'exécution dans WFM lors d'une jointure de champs de type de données DECIMAL et STRING

QUERY

Instruction Select non valable rencontrée dans un script QUERY lié

CENTRAL/SERVER

Prise en charge de la fonctionnalité WFM trace sur Server

Problèmes résolus dans le Hotfix 1 de la version 10.4 du module de fonction

Un aperçu des résultats de la requête est possible seulement quand la fonction Adaptive Query Throttling est activée.
Le nombre d'entrées peut être affiché seulement quand la fonction Adaptive Query Throttling est activée. Remarquer que les résultats peuvent être différents de ceux d'une exécution SQL quand la fonction Adaptive Query Throttling est désactivée.

10.4 GA

QUERY et RUNNER pour QUERY

Jointures multitables sans le module de fonction Winshuttle (WFM)
Prise en charge des jointures gauches externes sur les systèmes non-WFM
Prise en charge des tables d'alias sur un système non-WFM
Tri de champ unique pour destination de sortie XML et SharePoint
Possibilité de génération dynamique du nom du fichier de sortie
Intégration du nouveau composant planificateur
Amélioration de "Exécuter en arrière plan sur SAP" pour les requêtes multitables
Option d'exécution en arrière-plan disponible dans l'écran d'exécution
Suppression de la limitation de morcellement.

QUERY

JOINS autorisés entre champs sans équivalence
Identificateur de table automatique Query
Possibilité de réorganiser le volet des critères de sélection
Ajout de tables directement dans QB sans recherche
Extraction autorisée des champs de texte long

Version 10.4 GA

QUERY et RUNNER

Entrée d'informations dans les champs obligatoires du formulaire d'entrée Variables d'exécution

CENTRAL/SERVER

Nouveau paramètre ajouté pour le niveau Query Developer Proficiency : « Autoriser la création manuelle de jointures entre les champs sans équivalence ». Version 10.4 GA

Problèmes résolus

QUERY et RUNNER

Sur un serveur W4I, si le module de fonction de Winshuttle n’est pas installé, l’exécution des scripts multitables envoie une erreur de type SQLite.
Une requête multitable envoie TIMEOUT quand les deux options Extract All + EAQT sont cochées dans WFM 10.4 GA sur W4Q
Si le module de fonction est déployé, l’exécution d’un script pour une extraction XML avec des valeurs négatives affiche des signes «-» après les valeurs extraites.
Lorsque l’option « Ajouter les données » est utilisée dans les paramètres du fichier de résultats, les expressions Excel ne fonctionnent pas après la première exécution.
Quand une requête est exécutée dans le module de fonction Winshuttle, une erreur est remontée si les champs de type de données LANG et DECIMAL sont joints.
Quand une requête est exécutée dans le module de fonction Winshuttle, une erreur est remontée si les champs de type de données Decimal et String sont joints.

QUERY

Instruction Select non valable rencontrée dans un script QUERY lié.

Added in Version 10.3

NEW FEATURES/MINOR IMPROVEMENTS

QUERY and RUNNER for QUERY

Support for run-time variables for all linked QUERY scripts in a chain.
When calling a query-as-a-service:
- A method is implemented that returns the number of entries.
- A parameter in the query input is added that limits the number of records returned.
Ability to abort a running QUERY script execution.
- On aborting a QUERY, the process is also killed on the SAP side and lingering chunks are removed.

QUERY

Users have the option to apply padding or leading zeros.
SharePoint lists are added to the available output destinations for SAP data.
For multiple-table QUERY scripts, the WFM can process the RFC in the background.

Bugs fixed

QUERY and RUNNER in version 10.3

Improvement to manage multi-table query execution on SAP version 4.7 to fix issue related to GENERATE_SUBPOOL_DIR_FULL
SSO works with QUERY as a Service.

CENTRAL/SERVER

Query Caching for Web Services – in Web Service Designer you can specify to cache a particular query either in memory or in a database. Subsequent requests to the Winshuttle Server will return results from the cache.
Support for Query autopost using Windows username and password (SSO) for 32-bit/64-bit computers.
Support for using Windows username and password (SSO) for consuming web services.
Support for passing SAP Credentials Object as a part of autopost call for Query.
The Web Service Autopost API in CENTRAL for Query has been exposed.
New site preference to allow users to manage String Padding of criteria. The default value will be false.

Added in Version 10.2

NEW FEATURES/MINOR IMPROVEMENTS

QUERY and RUNNER for QUERY

Link Script setting has been introduced to automatically launch and execute another QUERY script in sequence a current QUERY script has finished running.
QUERY Log Viewer will display execution logs for jobs with two additional fields Output fields and Selection fields. Failed jobs will appear in Red.
Proper Warning message is shown when Exchange Server information is Wrong to send an E-mail for Scheduler
Dutch and Spanish locales are now supported
QUERY can be scheduled on Winshuttle Server
Separate installers available for machines with MS Office 32 bit and 64 bit.

QUERY

You can now record the Transaction Codes in QUERY to capture Tables and the fields that are being modified. A category has been provided in the Data Dictionary, called Recorded Transactions
Left outer joins for SAP tables are now supported.
Search in SAP Data Dictionary - to bring back the Table Descriptions. When searching for SAP tables using wild cards or by field name, users will be able to see the table text description.
Auto Joins are improved and default join is now provided between Primary key & Index Key.
An option is provided to restrict query to be published as a web service.
Orphan Chunk records in SAP from terminated chunking queries are now cleared automatically
Custom Security Check is incorporated in WFM (Winshuttle Functional Module) where a customer can add custom code with custom authorization check for security check.
You can restrict access to SAP tables for users through Winshuttle CENTRAL Administration.

BUGS FIXED

QUERY and RUNNER

Function module "SXMS_TIMEDIFF_SEC" not found message when attempting table joins, can’t find SAP tables, Admin Defaults not retained.
On Autoposting a large query file the SERVER usage climbs upto 90%
Unable to read and write to same excel file
Custom Tables not displaying in 10.1 in different SAP version environments

CENTRAL/SERVER

Localization Support – French, German, Spanish and Dutch for SharePoint 2007 & 2010
Central License Administrator can delete the Expired License
Published Web Services will be visible to all Users with delete permissions to only self-owned services. Site Collection Admin can delete all the published Web Services
Configurable Email Templates
NINTEX Activity for Autopost on SharePoint 2007 & 2010
32 bit and 64 bit Installer for Winshuttle Server
Ability to pass Windows User Name and Password to use SSO in case of SAP
Variable target URL in published web services.
Support for Load Balancer for Winshuttle Server
Support for UTF character in Web Service Name
Run later (Server) for Excel/SQL destination type QUERY scripts
QUERY policies for Restricted Table access
Linked QUERY Support in CENTRAL
Scheduling a query script on SERVER via Add-In
Run with SAP credentials for QUERY web services.

Added in Version 10.1

NEW FEATURES/MINOR IMPROVEMENTS

QUERY & RUNNER

Support for MS Office 2010
The number of tables you can join in your query has been increased from 9 to 25
The number of WHERE clause values which can be used in a QUERY has been increased
Tables used in the QUERY to be listed in the log viewer
New comprehensive list of T-codes and their related tables have been added
User will be notified whenever query output is filtered as per user authorizations

BUGS FIXED

QUERY and RUNNER

Infoset/SAP Queries security – User can now run only those Infosets/SAP Queries which are associated with the user group he belongs to
Unable to run SQL query using SSO logon
Log Viewer displays log of only one query when two queries are run simultaneously
Unable to query tables starting with "/"
Incorrect SAP details should not allow user to go ahead in query schedule wizard
Unable to run SQL queries on CRM (when router string is used)
An error occurs after generating support shuttle file
Log records not written for unsuccessful scheduled Runs on sqlSHUTTLE using SSO logon
Default table joining doesn’t happen with alias table when base table is deleted and then added

Added in Version 10

Note: In version 10.0 querySHUTTLE is rebranded as Winshuttle QUERY and xSHUTTLE as Winshuttle RUNNER for QUERY.

NEW FEATURES

QUERY & RUNNER

Queries can be created using 2 new data sources
Infosets
Logical databases
Even the SAP queries predefined on SAP servers can be run using Winshuttle QUERY
Renovated criteria builder pane for better usability experience
Enhanced QUERY performance with optimization in both QUERY and Winshuttle function module (WFM)
Usage of Microsoft Excel formulae in mapping stage to transform data before downloading
Support for queries of lengths more than 4000 chars with maximum limit of 65536 chars
Ability to run Queries using Excel macros
Advanced encryption standard used for ALF encryption
All admin restrictions will be shown to users while creating a query
Ability to delete user specified tables of the local data dictionary
Size of application window can now be changed
New application option to get the debug information for quick problem resolution

BUGS FIXED

QUERY and RUNNER

Limit of 250 records for evaluation license not respected while downloading records in case of command prompt
Adding any Table to favorite’s category -- the table description is always truncated
Incorrect Query Manager Search
Combination of Write Headers option with "Append data" or "Overwrite Data" doesn't write the headers in the result file
In QM Search, it is impossible to search a query without entering wildcards with table / field name criteria
In excel add-in all fields are clickable (working) during the run process (Extraction and writing of data).
Excessive flickering of screens
Time out setting – least of values set on WFM or client to be respected

Added in querySHUTTLE version 6.2:

BUGS FIXED

querySHUTTLE & xSHUTTLE

Unlimited download to SQL server with evaluation license
By default SQL Server destination type name doesn't get enabled in mapper screen
Query which is suppose to extract records with field not null, extracts all records with null field
Latest version of Windows Live Messenger affects querySHUTTLE and xSHUTTLE
Incorrect functionality of e-mail settings in application options in few cases
Running a query having fields with '/' in their name sends an exception
Advanced run option "Overwrite Existing Data" does not save its state once control is out of it
The RFC Read table had a bug which would cause an alignment error on trying to read MARD and other tables from SAP release 4.7
In QM Search, it is impossible to search a query without entering wildcards with table / field name criteria

querySHUTTLE

Queries can be scheduled for date even after license expiry when SQL server is the destination type
After removing a join, if another table is added, the join comes back
Unable to use the wildcard ‘*’ while setting the field criteria
VIEWS not supported by standard SAP (SQ02 transaction) allowed to be used in query builder
Search in Winshuttle Data Dictionary does not show unique values of the results
Not able to run a SQL Server query in VISTA (as Virtual PC)

xSHUTTLE

Query builder options shown in admin options which is of no significance
xSHUTTLE add-in crashes when graphical object exists with macros in MS excel 2007

NEW FEATURES

querySHUTTLE & xSHUTTLE

querySHUTTLE and xSHUTTLE are now available in French and German languages
Backward compatible of querySHUTTLE and xSHUTTLE clients with older Winshuttle Function Module (WFM) versions (till WFM version 6.1)
No. of entries for multi-table queries
Chunking for multi-table queries
Default chunk size for single table queries which enhances query performance
Customizable path for SAP logon.ini file
A more comprehensive Data Dictionary with additional tables which are commonly used
Delete option provided on Authorization fields table in admin options
Validation checks added in WFM while adding authorization objects on WFM
Zoom in feature on the query builder area and also on individual tables
To aid in troubleshooting, trace file can be written for queries
Option to run queries directly on the SAP server or to use the Winshuttle adaptive query throttling algorithm. Running a query directly on the SAP server can improve query performance
Improvements to command line functionality
Download data to SQL Server
Suppress application window while the query is running
View WFM version on querySHUTTLE/xSHUTTLE client
Undo option in mapper screen
Query scheduling - attaching the data file to an email
querySHUTTLE extracts do not seem to respect field formats in Excel

querySHUTTLE

An online library of templates that represent commonly used queries across various SAP components
Joining a table to itself or its aliases
Restore Winshuttle master Data Dictionary
Listing all possible joins between tables added in query builder area
Query files can be published to both excel files and templates
F4 (help) retrieves field descriptions
Automatic padding of leading zeroes while setting field criteria
Prominence given to table views, index fields and primary key fields. Warning messages thrown whenever non-index fields used in join creation and setting criteria
Operators ‘<’ and ‘>’ can be used in criteria pane

xSHUTTLE

Allow update mapping
Redesign of xSHUTTLE add-in
xSHUTTLE add- in support for MS Excel 2002 and 2003

Added in querySHUTTLE version 6.1:

BUGS FIXED

querySHUTTLE & xSHUTTLE

In the Query Builder, using criteria for a SAP field of data type ‘decimal’ in a multiple table query sends an error in certain scenarios
Advanced Run Options: Query Execution Timeout is not functioning correctly
‘Scheduled Run’ notification email format is incorrect
Unable to set ‘TAB’ delimiter in text output
‘IN’ operator using a value containing ‘AND’ enclosed with spaces causes an error in ECC 6 and ECC 5 Winshuttle Function Module
"Clear result file" option clears the entire spreadsheet instead of only clearing the data portion of the excel file
While extracting data from the ‘PCL2’ HR table, the long text field data is encrypted
'Disable / Enable querySHUTTLE add-in in ‘Options’ does not work correctly
When using macro-enabled workbooks in Office 2007, querySHUTTLE automatically adds a file extension

querySHUTTLE

The publish button is disabled on opening a file. This appears enabled again after ‘Run’
The button 'Add selected Table(s) to Query builder' is not disabled while adding tables to the Query Builder
Auto mapping a file having more than 255 fields does not send a warning message when MS Office 2003 is used

xSHUTTLE

‘Show query text’ button is not disabled

NEW FEATURES

querySHUTTLE & xSHUTTLE

querySHUTTLE and xSHUTTLE are now compatible with SAP release 4.7
querySHUTTLE and xSHUTTLE are now compatible with SAP CRM
Log Viewer - The ‘run reason’ column is added
SSO (Single Sign On) and EP (Enterprise Logon) options are now compatible
Progress indicators have been changed and added in relevant locations
Users can now extract data to SQL server databases
Users can now specify the ‘Log Column’ in the command line
Query execution timeout parameter has now been added to the Winshuttle Function Module
sqlSHUTTLE – this has been designed and developed for the ability to schedule a query to execute when the user is either not connected to the enterprise or when they do not want the query to be executed from their workstation/PC
querySHUTTLE and xSHUTTLE have now been designed to work without the Winshuttle Function Module being present on the SAP system. Single table queries will only be possible if the Winshuttle Function Module is absent. The SAP profile security functionality present through the Winshuttle Function Module is now applicable through the client also.
Regional settings support across application for date/time/number formats
supportSHUTTLE has been added into querySHUTTLE and xSHUTTLE
An Excel file can now be used to hold a list of values for SAP field criteria
Implementation of manual De-Activation process
Implementation for evaluation extension key support
CD image distribution – consolidation of all files including installation files into a single MSI based installer
The HR data cluster table PCL2 can now be used to extract data (long text)
‘query execution time out’ is now added in the ‘Admin Options’
From the Application options, it is now possible (configurable) to specify where the Data Dictionary should be picked up from
New tables have been added to the standard Winshuttle Data Dictionary

querySHUTTLE

In the Data Dictionary, users can now add their own transaction codes

Added in querySHUTTLE version 6.0 Update 1:

BUGS FIXED

querySHUTTLE & xSHUTTLE

Users cannot extend their evaluation licenses using extension keys

NEW FEATURES

querySHUTTLE & xSHUTTLE

querySHUTTLE and xSHUTTLE are now compatible with SAP release ECC 5.0
The deactivation process has been improved to allow users to deactivate licenses manually if they are unable to use automatic deactivation due to loss of internet connectivity

Aussi dans cette section

Problèmes résolus dans les versions 10.6/10.7

Problèmes connus dans Query Version 10.6.1 GA