Funciones nuevas y mejoras de la versión 10.6/10.7 > Previous versions
Previous versions
Nuevas funciones en la versión 10.5 GA
- Se admiten los joins entre campos con el Módulo de función de Winshuttle para QUERY.
- Antes de que aparezcan la vista preliminar de los resultados de las consultas y el número de entradas, aparecerá una advertencia en el caso de que se incluyan campos que no se corresponden en la consulta.
- Winshuttle QUERY es compatible con Windows 8.
- Winshuttle QUERY es compatible con Microsoft Office 2013.
- El complemento de Winshuttle RUNNER funciona en Microsoft Excel 2013.
- Winshuttle QUERY es compatible con SAP GUI 7.30.
- El botón Detener ya está disponible para detener los procesos de join automáticos cuando no se encuentran joins.
- La documentación para los productos de Winshuttle está disponible en el producto como ayuda online. Ya no hay disponible documentación en PDF.
- Los resultados de las consultas solo se pueden previsualizar cuando está activado el límite de consultas adaptables. (Hotfix 10.4.1)
- El número de entradas solo se puede ver cuando está activado el límite de consultas adaptables. Hay que tener en cuenta que cuando el límite de consultas adaptables está desactivado, los resultados pueden ser diferentes de los de una ejecución de SQL. (Hotfix 10.4.1)
En la versión 10.5
QUERY y RUNNER para QUERY
- Todos los scripts multitabla que tienen un criterio de selección sin el módulo de función, en el servidor W4I, tienen la excepción de SQL Lite.
- Las consultas multitabla envían el TIEMPO DE ESPERA cuando Extraer todo y EAQT son una combinación válida en WFM 10.4 GA en W4Q
- XML se ejecuta para campos con resultados de Valor negativo. Para ello, se muestra con un signo negativo tras el valor (solo con la ejecución de FM)
- La expresión de Excel no funciona después de la primera ejecución cuando se utilizan los datos adjuntos al archivo resultante.
- Envía una excepción al ejecutar en WFM cuando se combinan los campos LANG y DECIMAL.
- Envía una excepción al ejecutar en WFM cuando se combinan los campos Decimal y String.
QUERY
- Se ha encontrado una sentencia de selección no válida en el script vinculado de QUERY.
Errores reparados en el Módulo de función de Winshuttle 10.4 Hotfix 1
- Los resultados de las consultas solo se pueden previsualizar cuando está activado el límite de consultas adaptables.
- El número de entradas solo se puede ver cuando está activado el límite de consultas adaptables. Hay que tener en cuenta que cuando el límite de consultas adaptables está desactivado, los resultados pueden ser diferentes de los de una ejecución de SQL.
Errores reparados en el Módulo de función de Winshuttle 10.4 Hotfix 1
- Los resultados de las consultas solo se pueden previsualizar cuando está activado el límite de consultas adaptables.
- El número de entradas solo se puede ver cuando está activado el límite de consultas adaptables. Hay que tener en cuenta que cuando el límite de consultas adaptables está desactivado, los resultados pueden ser diferentes de los de una ejecución de SQL.
10.4 GA
QUERY y RUNNER para QUERY
- Combinaciones para tablas múltiples sin el Módulo de función de Winshuttle (WFM).
- Las combinaciones exteriores a la izquierda se apoyan en el sistema no-WFM.
- Compatibilidad de tablas de alias en el sistema no-WFM.
- Orden de campos sencillos para XML y destino de salida de SharePoint.
- Capacidad de generar un archivo de salida de forma dinámica.
- Integración de nuevo componente planificador.
- Mejora en «Ejecutar en segundo plano de SAP» para consultas de tabla múltiple.
- La opción Ejecutar en segundo plano está disponible en la pantalla de ejecución.
- Se ha eliminado el límite de fragmentación.
QUERY
- Se permiten combinaciones entre campos que no se corresponden.
- Identificador de tablas automáticas de Query.
- Capacidad para volver a ordenar la selección del panel de criterios.
- Añadir tablas directamente a QB sin realizar ninguna búsqueda.
- Permite la extracción autorizada de campos de texto largo.
Versión 10.4 GA
QUERY y RUNNER
- Campos de entrada obligatorios en el formulario de entrada de variables de Run Time.
CENTRAL/SERVER
- Se ha añadido un parámetro nuevo para el Nivel de competencia de programador de Query: «Permitir combinaciones manuales entre campos que no se corresponden» versión 10.4 GA.
QUERY y RUNNER
- Campos de entrada obligatorios en el formulario de entrada de variables de Run Time.
CENTRAL/SERVER
- Se ha añadido un parámetro nuevo para el Nivel de competencia de programador de Query: «Permitir combinaciones manuales entre campos que no se corresponden».
Errores reparados
QUERY y RUNNER
- En las instancias del servidor W4I no pertenecientes al Módulo de Función de Winshuttle, todos los scripts multitable con criterios envían una excepción SQLite.
- Las consultas multitabla envían el TIEMPO DE ESPERA cuando Extraer todo y EAQT son una combinación válida en WFM 10.4 GA en W4Q
- En las implementaciones con el Módulo de Función de Winshuttle, una ejecución por campos XML con valores negativos mostrará un signo negativo tras el valor.
- Al utilizar el ajuste Anexar datos al archivo resultante, las expresiones de Excel no funcionan después de la primera ejecución.
- Cuando se ejecuta una consulta en el Módulo de Función de Winshuttle, se envía una excepción si los campos de datos del tipo LANG y DECIMAL están vinculados (incluidos en un join).
- Cuando se ejecuta una consulta en el Módulo de Función de Winshuttle, se envía una excepción si los campos de datos del tipo Decimal y String están vinculados (incluidos en un join).
QUERY
- Se ha encontrado una sentencia de selección no válida en el script vinculado de QUERY.
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
Home
Back
Next
Contents
Index
Product Help
Support
Print
Trademarks
Feedback
Back to top
Winshuttle.com
