Winshuttle FAQs

Description

We are working on reporting using API's, to join the assignment and form API we would like to determine the assignment ID on the form. As you probably know the assignment ID is an automatically generated ID which is unique for every approver of the step. What we want is to get the assignment ID of the current approver in the form. If this is not possible we would like to know if there is a different join you would recommend?

Applies To

12x

Solution/Immediate Workaround

Only possible to achieve the same is by using the Request ID ; so basically you can achieve this by having Form Name template and then the element you will be using for Form Name template mark it as available for reporting.See screenshot attached.

https://winshuttle-help.s3.amazonaws.com/foundation/en/apis/forms_api.htm

For the API's user can go through the below link

Description

When opening a Data Template in Studio and clicking on the Run tab you see only a Test button and no Run button.

Applies To

Studio 11, User Governance 11

Cause

There are several prerequisites for running a script.

Solution/Immediate Workaround

Ensure the script is in a Production state in the Transaction or Query library on the Foundation site.(To do so make sure the Script is submitted to the Foundation by clicking on Submit to Foundation under Foundation tab in Studio)

Ensure the Runnable property is set to Yes. This is part of the normal approval workflow. If you attempt to change this manually, the approval will restart.

Check who is in the Runner property on the script. This is the runner who can run the script and applies when there is a Data File approval selected.

Ensure when opening the script, you open the approved script from Foundation. Opening a script from a local or shared network location will not allow a run.

After opening the script ( from the Foundation site or from the software Library), be sure to save the Data Template locally. This converts the data template to a data file. Data templates cannot be used for runs.

Ensure you are a member of a group applied to a policy in Foundation that allows running against the SAP server type you are trying to run against.

Ensure you have a license assigned.

Note 1 - If you are seeing this for a Query script and all the above recommendations are met, upgrade to atleast 11.2.12 and retest. In some lower versions of 11.2 Query templates show test once saved locally.

Note 2- Ifall the above recommendations are met, rename the Winshuttle folder saved inC:\Users\*username*\AppData\Roaming, then launch Studio, then open the script from its library and go to the Run tab

Description

EP Logon ticket not found

Applies to

Studio, Transaction

10.X, 11.X

Cause

Setting not configured yet to support EP Logon through the browser.

Solution

At the following location: C:\Users\*USERNAME*\AppData\Roaming\Winshuttle\SapShuttleConnector\8

The file at that location which should be modified is: EpLogonSettings.xml

In the file, find element:<USE_READ_HTTPEVENTS_1> and set the value to 'true'

Description

AutoRun plug-in is failing with error "Error from processor: Corrupt OpenXML document. ErrorCode: 2028". User submitting the file is using Office 365. Other users on different versions of Excel do not experience the error.

Applies To

Studio/Foundation 11+, Office 365

Cause

Studio uses Spreadsheet Gear, as does the AutoRun plugin. Currently Spreadsheet Gear only supports up to Patch 1803 for Office 365. User was on Patch 1903.

Solution/Immediate Workaround

Downgrade Office to Patch 1803.

Description

Whenever a form is rejected, the mandatory fields are still checked. I.e. Whenever you want to reject and close the request, the user still needs to fill out a lot of mandatory information. This doesn't make sense.

Applies To

Composer 11.x and 12.x

Cause

Missing configuration

Solution/Immediate Workaround

This issue can be resolved by setting the "validateOnReject" key to "false" under Foundation --> Workflow configuration options.

See below screenshots:

Additional Information

Description

I have made some changes to an Excel file outside Studio, I have left the Excel file open in the background and when trying to make additional changes to it from within the preview in Studio, it won't allow me modify it. I receive the following error message " This data file is in read-only mode to preserve any formatting, charts and any other elements".

Also if I try to save the excel file within the Studio preview when the filters are on, I get the read only message. If I remove the filters I am able to save the file.

Applies to

Studio 11.X, 12.x

Cause

This was designed to prevent accidental deletion of data in Excel.

Solution

Studio 11 does prevent write access within Studio to preserve any formulas or data that may have been inputted directly in Excel. This has been designed to prevent the user accidentally deleting formulas that they may have entered directly in Excel while the file was being used in Studio.

In Studio 11.1.0, only data files that contain unsupported elements (PivotTables, charts, filters and graphs) open as read-only:

Studio v11.1.0 release notes

Description

"Open with Access" option is disabled in SharePoint list options.

Applies To

SharePoint

Cause

If the list is accessed using the different browser other than Internet Explorer browser.

Solution

Try accessing the SharePoint list using Internet Explorer Browser in order for "Open with Access" option to be enabled.

Description

How to use if conditions inyour script

Applies to

10x

Solution

If first transaction- used when an action will only need to be taken for the first data record

Example: ME22N often requires the display be toggled (Display/Change command) for the first record in order to allow for any updates, however this only has to happen for the first record as all subsequent records will be in change mode.

If Not first transaction- used when an action will not be needed for the first data record, but will be needed for any subsequent records

Example: ME22N often collapses the header, item overview, and/or, item detail tables for subsequent records. Because of this you will want to include opening these tables in your script, while including an If NOT first transaction condition around them.

If on SAP field- used to check if a value exists or does not exist in SAP prior to updating that record

Example: In MM02 if you want to validate a specific material group and update a specific set of fields for that group

If on Index field- allows you to search and update multiple rows based on one fields value

Example: In CA02 there is no a good way to identify the correct operation number you'd like to update using the entry number. As there is not a way to filter out the correct operation number anif on index condition can be used to locate the specific operation in order to update the related fields.

If- allows you to setup a range of condition types dependent on the operator selected

Example: For an FB50 multi-company posting, your header company code will apply for all of the line items unless the company code is replaced with at the time the line item is entered. Because of this in your data file you may want to leave the company codes blank for the accounts that have the header company code. For this you can use an IFcompany code columnNot Blank condition

Operators possible

= - Ifcolumn valueequals a specific value

> - Ifcolumn valueis greater than a specific value

< - Ifcolumn valueis less than a specific value

>= - Ifcolumn valueis greater than or equal to a specific value

<= - Ifcolumn valueis less than or equal to a specific value

<> - Ifcolumn valuedoes not equal a specific value

Blank - Ifcolumn valueis blank (does not have a value)

Not Blank - Ifcolumn valueis not blank (has a value)

Starts with - Ifcolumn valuestarts with a specific value

Contains - Ifcolumn valuecontains a specific value

Ends with - Ifcolumn valueends with a specific value

Between - Ifcolumn valueis between two specified values

Additional Information

http://winshuttle-help.s3.amazonaws.com/transaction/en/ts-adv-guide/10.x/4079.htm

Description

We have noted in the SAP GUI version provided, that the SAP GUI Patch level is not supported by Winshuttle or SAP.

Cause

SAP GUI version is not supported.

Solution

*Note that SAP no longer supports anything below SAP GUI 740

Studio Version(s) 10.7.2 and Higher:

730 - patch 15 and above

740 - patch level 19

Studio Version(s) 11.4.1 and Higher, Including 11.2.12:

730 - patch 15 and above

740 - patch 19 and above

750 - patch 10 and above

Studio Version 12.1:

730 - patch 15 and above

740 - patch 19 and above

750 - patch 10 and above

760 - patch 1, patch 2 and patch 3

SAP Versions Supported by Studio 12.1:

S/4HANA 1909 - 754

S/4HANA 1809 - 753

S/4HANA 1709 - 752

S/4HANA 1610 - 751

EHP8 - 750

ECC 6.0

ECC 6.0 NonERP

Additional Information

How to determine SAP GUI logon pad version and patch level

SAP Current Supported SAP GUI Patch levels

Description

In a SharePoint 2010 list, the Data Sheet view option is grayed-out or a view set to use Data Sheet displays a message that ActiveX controls are not supported.

Applies To

SharePoint 2010, Firefox, Chrome, any non-IE browser

Cause

In SharePoint 2010, the Data Sheet view uses ActiveX controls which are an old Microsoft technology not supported in modern browsers.

Solution/Immediate Workaround

To view a Data Sheet list, Internet Explorer must be used.

Additional Information

SharePoint 2013 uses a different technology and Data Sheet is now Quick Edit and can be used in any browser.

Description

How to add materials to a material BOM in CS02

Applies to

Transaction, Studio

10.X, 11.X

Solution

Click on the New Entries button. This will move the existing materials up.

Enter next material on the second row and press the ENTER key.

Create your loop around the above process.

Here is an example of the loop and how it would look in the data file.

Description

My e-mail approval flow works fine, but the result inside the form is not what I' expect.

Applies To

11x;12x

Solution/Immediate Workaround

This issue can be resolved by making the below changes.

1.Go to workflow administration site

2. Now click on the Configure Options

3. Search Emailapprovaltype in the name text box.

4. Click on the EmailApprovalType, and then Edit the value

5. Currently the value is plaintext for the customer, We need to change it to delimited. Click on save

6. Again click on save

Below link can be followed for the same.

winshuttle-help.s3.amazonaws.com/foundation/en/configurator-options/workflow-configurator-options-DelimitedCommentFilterRegex.htm

Description

How to find the location of the saplogon.ini file in SAP GUI

Solution

Launch your SAP Logon Pad

Click the button in the top left corner and select Options

Go to SAP Logon Options > Local Configuration Files

Find path of the saplogon.ini file in the Connection string

Description

When running a script, the following popup messages are received.

Cause

Options within SAP GUI cause these notification messages to appear.

Solution

To avoid these notifications, follow the below instructions.

Open SAP GUI

Open the top left menu (to the left of SAP GUI XXX)

Click Options

Accessibility & Scripting > Scripting

Untick the settings under "Enable scripting".

Description

When running a script, you get this message in the log column: "No batch input data for screen..."

Cause

This message can appear for many different transaction codes. It will come up in the following scenarios:

Pop up Screen

If the script encounters an SAP screen that it either does not have any information, or didn't expect at that point in the run.

Example

It indicates that a popup or dialog box that came upduring executionand so the script has gotten off track.

New Screen

If a new screen is popping up for the current record that didn't exist for the record that was recorded (different screen flows for different data).

Example

If we populate a field on one screen for a particular data/record, a new screen might appear with fields that must be filled. As this new screen sequence was not recorded, the script returns the error.

Missing / SkippedScreen

If the script has a screen recorded that does not appear for certain data.

Example

The recording is done with a set of screen flows--but for particular data, one of the screens is not displayed by SAP. The script will navigate through that screen, which is not actually displayed by SAP, and return the error.

Solution

If you see this error, try running in step-by-step mode, and stop on each screen to see if you can identify the issue.

You can also record the scenario that is generating the error and compare it with the original script. This should illustrate what is processing differently so that you can then edit / modify the existing script to accumulate the new scenario.

Different data may have different (SAP screen) flow sequences.

Description

How to add long text in Studio 11 and keep the existing text

Applies to

11.X

Solution/Immediate Workaround

- Create script 1 to download the existing text from SAP to Excel

- Create script 2 to upload the additional text from Excel to SAP

- Link script 1 to script 2

- Choose one column in the date file that will concatenate the existing and additional text. That same column will be used in the mapper on the second 1 for the upload into SAP

See Help Guide for Studio 11 'add long text' method: recording long text.

Additional Information

It will be useful to use additional Excel features

- to have the additional text before or after the existing text

- to have an 'ENTER' space between the existing text and the additional one

- not to add a 'ENTER' space if there is no existing text.

Description

A Connect user is trying to reset their password but is getting the error "Your profile is not yet set. You cannot use this functionality".

Applies To

Connect license users.

Cause

Connect profile has not been correctly set up

Solution

This message indicates that your initial Connect password has not yet been set, which would not allow you to reset it. Did you receive your initial registration from [email protected] ? This email can be resent by your license administrator by following the below steps:

1. Log into connect.winshuttle.com

2. Go to Communications Tab > Email Communications

3. Type in user's email address and date range you wish to search for, select View

4. Check the box next to User Creation email and select Resend Selected Email.

Additional Information

Please also be sure to check your junk folder as it may automatically be directed there depending on your network preferences.Once you have received the e-mail please follow the link to create your password. Once your password has been created you should be able to successfully log into the application.

Description

How to export SharePoint Lists data to SQL Database?

Applies To

SharePoint, SQL

Solution

Follow the steps mentioned below by navigating to the SharePoint List:

List Actions > Export to SpreadSheet/Excel.

Save the Excel file.

Open your SQL database with SQL Management Studio.

Right click on your database > Tasks > Import Data.

Select your Excel file as the source, and specific table as destination.

Fill all other needed options.

Click finish.

This should load the Excel data (original, list data) to the SQL table.

Description

We have a solution which uploads to a SharePoint list.

Users have a 2 way process where they attach attachments with the same name, but with in different attachment elements. In this case on the next step (where both attachments are displayed) we see only one of them, and in request item there's also only one of attachment. The system sees them as one the same happens also if these attachments has different sizes. The type of attachments is also the same.

Applies To

Composer 11.2.1

Cause

SharePoint restriction.

Solution/Immediate Workaround

This is a designed behavior as all the form attachments are added to a form list item in SharePoint

and SharePoint does not allow duplicate attachments.

As a workaround, you can use rename attachment plugin add attachment to the activity and then rename these attachments.

Additional Information

Description:-

Customer request for vendor key for wfm during SAP upgrade or migration.

Applies to:-

All WFM versions, SAP HANA upgrade.

Solution:-

SAP stops providing vendor keys for abap add-on manufacturers as per attached sapnote.

We should recommend customer to un-install WFM before SAP upgrade and re-install WFM after SAP upgrade.

In case customer having any issues while un-installing WFM or any concerns then customer should contact Winshuttle support.

Description

I have been trying to run a winshuttle query and I get errors. If I try and limit the dataset I get: Query cannot be executed because the query length exceeds 65536 characters If I try the full dataset : Exception of type 'System.OutOfMemoryException'

Applies to

Query 10.x

Cause

Whilst the 64k row barrier has been lifted on products since Excel 2003, there are other limitations if you are handling large amounts of information. The number of rows imported is also dependent on the number of columns, the more columns you have, the less rows that can be displayed. In addition Excel 2007 and 2010 still have 2GB memory limitations, if you are handling large amounts of information. If using pivot tables linked to external database tables (or text files), there can be no more than 65,536 unique values in any one field. Unless you are handling large datasets, you should not encounter these other limitations.

Solution

If you are getting this error whilst trying to run a query, please check whether you have any where clause with an 'IN' operator. The message indicates that the file size exceeds the limit of 65536 characters.

The RFC to SAP call does not support more than 65536 characters per query. The length of the query measures spaces, characters, commas, inverted commas, and all other symbols to create the query and it counts as a character. It takes into account both the data in the IN file as well as the data being extracted.

The following characteristics apply to the IN operator in Winshuttle QUERY:

* A query can contain several IN operators.

* Each IN operator can not contain more than 1000 values.

* A query line can not exceed 65,536 characters.

If you have a lot of data to process, you will have to divide the file size and execute two queries.

Additional Information

The Exception of type 'System.OutOfMemoryException' can be solved by using the chunking option in the advanced run options of Query and is covered in more details here: Exception of type 'System.OutOfMemoryException' was thrown

Description

When recording a script, the SAP GUI opens as a small box with scrollbars andonly the first couple of rows are visible due to screen size reduction.

Applies To

Transaction, Studio

10.X, 11.X

Solution

To get the same screen size as you would normally get in SAP using Transaction, please follow the steps below:

1. Close Winshuttle Transaction and any Excel workbooks that might be currently open.

2. Navigate to your Appoptions.xml file on your machine (please note that this can be located in a hidden folder).

3. Open and Edit the Appoptions.xml file ---> look for value ---> change the value of to and save.

4. Open Transaction and run the scenario again.

Additional Information

Note for Studio 11.X this feature was made available from Winshuttle Function Module 11.3

Description

Error in log column reads: Authorization to message text table 'T100' is missing. SAP has returned message ID and number:

Applies to

Studio 11.x

Transaction 10.x

Cause

Missing authorizations for table 'T100'

Solution

Forward the details in the following article to your SAP Basis team so that they can access this table in your SAP user profile and in particular attention should be paid to the paragraph headed 'Table Level Authorizations in which it is stated that Transaction needs access to table 'T100'.

What authorizations are needed for Transaction

Description

Winshuttle will not pick up text that is entered into the Text Editor. You must instead use the Change Editor to input Long Text.

Solution

Go into the text editor. Create your loop around this process - hit Enter, enter text in the top row, and then click the next page button. Please note that each line will hold a maximum of 72 characters.

To navigate to the Text Editor, first click the Editor icon in the transaction you are recording. The position may change depending on which t-code you are in.

After clicking the Editor icon, you will see a Microsoft Word editor, but data entered there can not be captured in your recording. Instead you will want to select Goto --> Change Editor from the drop-down Menu.

Within the Text Editor, you can select the first line, hit enter, put your text into the first row and then click the Next Page.

Here is an example of the loop and the data file:

Description

Users are noticing slowness when using WinShuttle products

Applies To

Foundation, Studio, Excel Addin

Cause

There are several areas to investigate when looking into performance issues, such as SQL, memory and WinShuttle configuration

Solution

The dbo.tracelog table within the Foundation User Governance database may have grown to over 100mb. If it's greater than 100 MB, truncate that table. If that tracelog table gets large, it can cause timeout related issues on the site and various functionality.

Make sure User Governance and Workflow Logging is turned OFF; this can cause performance issues if it's on.

If VM's are being used, ensure Dynamic Memory is turned off

Ensure that you've applied the App Fabric CU 6, plus the changes needed in the DistributedCacheService.exe.config as described here: https://blogs.msdn.microsoft.com/calvarro/2014/03/20/points-to-consider-with-distributed-cache-on-sharepoint-2013-updated/

If any SharePoint CU have been applied, make sure the configuration wizard has been ran on each of the servers; if not your databases will be placed in read only mode and will cause all sorts of issues for WinShuttle.

If user is facing issues on the Foundation site for the number of items in a folder/lists/libraries not loading then the list view threshold set in SharePoint need to be checked. See attached article how to do so The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator.

In case the performance degrades performing an IISRESET improves performance.

If customers have many solution and users, it is advisable to have load balancing of Winshuttle servers.

Some times as the database size grows it slows down the performance. We recommend to perform archiving regularly. http://winshuttle-help.s3.amazonaws.com/foundation/en/workflow-10-8-archiving-workflow-process-data.htm

If the size of temp folder on the workflow server is causing performance issue, please check attached article related to same . The size of the temp folder on the Workflow server is causing performance issues .

Verify your system requirements as per our System requirements guides. In general production servers will require double the amount of RAM and CPU output. Any CPU or Memory requirements from Winshuttle side do not include your Windows OS, Antivirus or Database requirements. For example on Foundation12 Production a 32 GB requirement is given, this is 32 GB only for Foundation and does not include any IIS web services, Antivirus, SharePoint, Windows OS or MS SQL Database. As a rule of thumb if your system is running at a constant 70\% of resources used like Memory and CPU you need to make sure to add more resources as any peek in resource consumption can crash the system or cause extreme slowness.

Check you paging files on the servers. If your system is paging, this indicates lot of memory is being consumed and hence your system is using it's secondary memory a space of your hard disk which is going to slow down the server.

Make sure you do not have DNS resolution delays you can check this by using the server IP in the URL instead of the name.

Ping the Foundation server and see how many milli seconds it takes.

Go directly to the foundation server and test the speed directly on the Foundation Server.

If you are using a virtual machine make sure that those resources are reserved specifically for this machine and not share in a virtual pool among-st other virtual machines as this would take those resources away from your virtual machine but would not show up visually in your Virtual machine.

Always check that your PC is not using a VPN, wireless and are connected to Ethernet cabled connections.

Make sure you specifically exclude all winshuttle folders and processes from the Antivirus scanning process to avoid slowing down winshuttle processes.

It is important to reboot servers during downtime hours to avoid issues of pending Microsoft updates not being written correctly into the windows registry.

Any web debugging tool will be very helpful in analyzing delays a good 3 party tool which can be used for this is fiddler see link for more information and help: https://www.telerik.com/fiddler

Slow logins or user delays can be a cause of corrupted windows credentials this can be resolved by having your IT department creating those user credentials.

While using load balancer's or web proxies bypassing those temporarily might also help in isolating the issue.

Clearing the browser cache might also be of help in correcting performance issues.

Additional Information

Hardware and Software requirements for SharePoint 2013 https://docs.microsoft.com/en-us/SharePoint/install/hardware-and-software-requirements-0

Description

Need to create a loop in F-28 for document or reference numbers

Applies To

Studio, Transaction

Solution

Go into F-28 and enter all the header information then Process open items. Once you are on the document selection screen do the following:

1. Enter the first document number

2. Select "other selection" (this moves you to reference)

3. Select "other selection" again (this moves you back to doc number)

4. Enter the second document number

5. Select process open items

Your loop will be around steps 1-3. While entering the doc numbers, they will appear to be removed from the list. However once you hit process open items you will see that all documents have in fact been pulled into view.

Description

Here are the steps to follow to check the SAP GUI installation. This may be requested as a troubleshooting step.

Solution

1. Go to your SAP logon pad, click on the rectangle at the top left and select Options .

2. Select System Information and click on Check SAP GUI Installation

3. Click Next to start the Wizard.

4. When the wizard finishes you will see a message appear confirming whether the SAP components are installed correctly.

You should also see a .cab file at this location: C:\Users\

Description

When you try to open the Winshuttle Excel Add-in you get an error message "License Checkout Error"

Solution

Solution 1 - This error usually occurs when the user is attempting to open the Winshuttle Excel add-in before activating the software. To resolve you will need to have the user activatethe Winshuttle application directly from the desktop icon. After activating the license,the user should be able to access the Excel add-in without error.

Solution 2 - If the Winshuttle software is already activatedand the user is still receiving this error, the userlikely hasboth the developer and runner software installed. Having both applications installedcan causeExcel to readthe incorrect add-in. To resolve you will need toconfirm which application the user is licensed for. If the user has a developer licensethey will want to uninstall the runner software. If the user has a runner licensethey will want to uninstall the developer software.

Description

Does Winshuttle Studio work with non-ERP SAP Systems such as CRM and SRM?

Applies to

Studio 11.X

Transaction 10.X

Solution

Winshuttle Studio works with non-ERP systems as long as you are using SAP GUI.

Your ability to work with Winshuttle depends on your SAP configuration and on the scenario that is implemented. In some instances, using the full Studio suite will help you to address certain data extraction and even update scenarios. This depends on the version of your SAP system and the availability of BAPIs and rFMs that will work satisfactorily with the Studio suite including Direct, Transaction, and Query.

The approach for automating some of the mass extracts, change, and create scenarios will not be the same as for Transaction recordings and will depend heavily on the SAP API model for the target CRM or SRM system.

Many Business Partner-related functions can be successfully maintained by using the requisite SRM and CRM BAPIs and rFMs, such as BAPI_BUPA_CENTRAL_CHANGE.

Additional Information

Can the Winshuttle Function Module be installed on non-ERP SAP systems?

Description

Recently upgraded from Transaction to Winshuttle Studio. When opening a script I am seeing the below error.

Applies To

Scripts that were created in an older version of the software, then opened using Studio 11 or higher.

Solution

1. You will need to open the script using an older version of the software. Then go to Update mapping > Filters and uncheck the hide all disabled fields checkbox. If you scroll through the mapping you should see some If condition icons that are not needed/relevant (see image below). Delete these and resave. The next time you open the script using Studio the error should be resolved.

2. Rerecord the script using Studio.

Description

Is it possible toset default setting for folders where "scripts" and "Templates" are saved. can you tell us if we can use "System environment variables" to set defalut values for directories for "scripts" and "Templates" while installing the studio application

Applies To

10x;11x;12x

Cause

As Designed

Solution/Immediate Workaround

While installing there is no way to set the default paths.

Its only after the installation you can change the path by either going to Options and then Locations to change the default path( see screenshot below) or for multiple users you can change in App Options file.

Description

We run the Winshuttle and encountered error - You cannot do this action on a Production Server

Applies To

Studio 11.x, Transaction 10.x

Cause

Basically, a script which has been approved and put into Production status can be run on a SAP server marked as a Production server.

Solution

There are 2 things that can be done. Either the script be submitted, approved and put in Production status, or change the Production server to be identified as a non-production server in Central/Foundation setup.

Description

You are developinga form that pulls data from a SharePoint list and you would like to migrate the form into production, but how do you create the list in production so that SharePoint names all the list columns correctly?

If the column names do not match exactly, issues will arise when publishing or accessing the migrated form.

Applies To

Anyone who would like to migrate a SharePoint list from one environment to another and wants to make sure that the column names are all exactly the same.

Cause

Depending on how you create the SharePoint list columns, Quick Edit or List Settings, SharePoint may assign a different name on the back end.

Quick Edit Created Columns - Notice how the column was named Address, but SharePoint has named the column tupu on the back end.

Columns Created Using List Settings - Using this method will guarantee that the column names match with what SharePoint has on the back end.

Solution

The best practice in this case would be to make a List Template from the original list so that the list and all of it's data can be seamlessly migrated to the new environment with the exact same column names as the original list.

Export list as a list template

First, open the list you wish to export and navigate to list settings and click Save List as Template.

Then, give the template a name and check the Include Content box. Click OK. You should receive a message that your list template has been created and a link to the template.

For your reference, the link to the SharePoint list template gallery will be: http://<\%YOUR SITE URL\%>/_catalogs/lt/Forms/AllItems.aspx

If you wish to download the template for use in another environment, use the link in the List Template Gallery.

Create a new list from a list template

Once you have downloaded the list template, use this link to access the List Template Gallery in the destination environmenthttp://<\%YOUR SITE URL\%>/_catalogs/lt/Forms/AllItems.aspx

Then, click on the Files tab in the ribbon.

Next, select Upload Document and navigate to your list template file.

Now that you have imported the list template, it is ready for use.

Navigate back to your forms site and select Lists from the left pane, then click Add an App.

Your list template will appear at the end of the "Apps You Can Add" section. All you need to do is click on the template to create a list.

Description

When trying to log into SAP through Winshuttle, I am getting the below error.

Applies to

Studio 11

Solution

Open your SAP logon pad and navigate to Options > SAP logon Options > Local Configuration Files. This will show you your file path for your SAP logon file (either an .ini or .XML).

Copy this file path. Next, open Winshuttle Studio and navigate toOptions > SAP Settings, and browse it to the SAPlogon.ini file path you copied from your SAP logon pad. After this, close and reopen Studio and you should be able to login successfully.

Additional information

This file path is what reads your SAP logon system information. If there are any changes or updates made, this can sometimes affect the logon through Winshuttle. Mapping this SAPlogon file path within Winshuttle helps to correctly point and read the SAP logon information.

Description

User is uploading documents attachments in transaction VA02 via Winshuttle Script in Studio v.12.0.1, WFM v.11.4.1, SAP GUI 750 (patch 4). The script is running without errors and the attachments are visible directly in SAP. However, when the user tries to open the attachment in VA02, they receive an error "Attachment list No authorization for this action". Manually the user is able to attach the documents, access them and delete them. The issue is only related to attachments that were uploaded via Winshuttle script.

Applies To

Studio v.12.0.1, WFM v.11.4.1, SAP GUI 750 (patch 4)

Cause

Missing authorization.

Solution/Immediate Workaround

If a document is attached via Winshuttle Studio and it is "BDS" attachment type (as in this case), to be able to view this document in SAP the following authorization is required.

Authority Object = S_BDS_D

LOIO_CLASS = BDS_LOC1

Activity = ‘03’

Additional Information

See attached screenshot for further details on the required authorization.

Description

How to change material classification

Applies to

Transaction, Studio

10.X, 11.X

Solution

In Basic Data view use the Scroll down list to go the Classification tab

(For some systems, you may have to enter data on the Basic Data 1 tab prior to selecting the Classification tab.)

Select the Class type and press Enter

Select all classes and press Enter

Click the position button (binoculars)at the bottom of the screen to search for the characteristic that should be changed. Enter the value 1 to maximum number of hits.

Change the value, press Enter, and then click Save.

When you map the script, insert a loop and an IF condition:

Use a loop to change several characteristics

Use an 'IF First Transaction' condition, if the screen with Class Type (step 2) appears only when you launched the transaction for the first time. The screen will then be skipped on subsequent occasions.

Additional Information

To have unique values, change the User Settings in SAP before you start the recording. In SAP GUI, start MM02, enter a material number and press Enter. Select Basic Data 1 and press Enter. Click the Classifications tab, and choose a class type. Click the Extras menu, and click User Settings. In the window that opens, click the General Settings tab and click the language indicator option button.

For more information, please see the attached script and data files.

Description When trying to export a list from the Forms site to Excel, an error pops up: To export a list, you must have a Microsoft Sharepoint Foundation compatible application. Applies to Foundation 10.X, 11.X

SharePoint 2013 Solution According to the following Microsoft blog, this is an Office issue.

To export a list, you must have a Microsoft Sharepoint Foundation compatible application

Review and share the suggested solutions with your IT.

2020 Connect Maintenance and Release Schedule

During these maintenance and release windows, Winshuttle Connect may be temporarily unavailable. To best prepare for this maintenance window please leverage these Connect Best Practices, click here.We ask that you please plan for this in advance for any initiatives or projects that occur during these maintenance and release windows. We apologize for any inconvenience this may cause you.

Date

Day of the Week

Type

Time (Pacific Standard Time)

January 17th

Friday

Maintenance

9pm - 6am

February 14th

Friday

Maintenance

9pm - 6am

March 13th

Friday

Maintenance

9pm - 6am

April 10th

Friday

TBD

9pm - 6am

April 17th

Friday

TBD

9pm - 6am

May 15th

Friday

Maintenance

9pm - 6am

June 12th

Friday

Maintenance

9pm - 6am

July 17th

Friday

Maintenance

9pm - 6am

August 14th

Friday

Maintenance

9pm - 6am

September 11th

Friday

Maintenance

9pm - 6am

October 16th

Friday

Maintenance

9pm - 6am

November 13th

Friday

Maintenance

9pm - 6am

November 20th

Friday

Release

9pm - 6am

December

N/A

N/A

No scheduled maintenance or releases

If you have any questions please be sure to contact Winshuttle Support.

Description

The Operations task list has no positioning controls to select Operation Number & Find button is disabled so GUI-Scripting and If-on-Index is needed to change data in an Operation number.

Applies to

Transaction, Studio

Solution

You can useok_code =OBSE to bring up a Search on Object Specification.

Use Object as 'O' and put in the Object Number you want it to find and press Enter.

This will position the Operation Number searched for in first line which can then be edited (or also put in a loop for multiple Operation Numbers)

Description

CJ20N -Project builder

Steps

Recording Mode: Any

Applies To

Studio 10.x

Solution

When you create a project or open an existing project and would like to edit it do not use the buttons in the panel on the left. These buttons are not associated with any function codes, so when they are recorded, they will not perform the create or open operation.

Instead, use the menu items for Project > New or Project > Open .

Description

How to add multiple WBS elements (plus its level) on the next available line

Applies to

Transaction 10.X

Studio 10.X, 11.X

Solution/Immediate Workaround

Use CJ01 instead

1- Create your project

2- Goto WBS element overview

3- Fill in the first WBS element (and its level) on the last line of the table in the Basic data Tab

4- Hit enter

5- Edit > Object > Position

6- Enter the WBS element just created

7- Double click on the first line (or leave the cursor on the 1st line then Details > WBS details screen)

8- Fill in all additional data

9- Validate

Description

Error received on running script in Studio 11: Exception from HRESULT: 0x800A03EC

How to check my SAP GUI version

Applies to

Studio 11.X

Cause

Error is most likely caused by how the script has been recorded or mapped to the data file.

Immediate Workaround

Create and remap a new data file and runthe existing script using the new data file

If this does not solve the case,create a new script and run using the new data file.

If neither of the above steps help resolve the case, send Winshuttle Support the latest version of the script, data file and application trace when running that script. Also confirm any recent changes to the environment and versions for the following systems:

Studio

Excel

SAP GUI

Windows OS

Additional Information

How to confirm which version of Studio you are using

How to generate trace files in Studio 11

Description

The 'New' button is grayed out. It is possible only to open scripts.

Applies to

Transaction/Query 10.X

Cause

License type does not enable creation of new scripts.

Solution

If you have a Connect license, confirm that you have a Studio license which enables you to create new scripts. If you have a Runner license it is expected that you can only open and run scripts. Normally this would be done using the Excel add-in.

If you have a Central license, it is likely that you have not been granted a license specifically for Query or Transaction. Please contact your Central site administrator and have them confirm that you have both a Central and a Product license.

*Note: From version 11.0 onward, Transaction, Query, Direct and Runner desktop applications are rolled into a singular installer, Studio. Available functionality (create, run, etc.) within the singular product is determined by license assigned in Connect or Foundation.

Winshuttle Studio 12.1-Connect and Foundation version 12.1 Compatible

Winshuttle Studio 12.1 - 32/64 Bit

Winshuttle Studio 11.2.12-Foundation version 11.2.12 Only

Winshuttle Studio 11.2.12 - 32/64 Bit

MSI Install Links

Only for use with mass installs by System Administrators

Please use the link that corresponds to your Excel bit version. If you are unsure how to check this, please click here.

Winshuttle Studio 12.1 - 32 Bit

Winshuttle Studio 12.1 - 64 Bit

Winshuttle Studio 11.2.12 - 32 Bit

Winshuttle Studio 11.2.12 - 64 Bit

Not Sure Where to Start?

Getting Started with Studio v12

Release Notes

Release Notes

ArchivedVersions

Archived Versions

Description

After associating the Excel file with the script, I see the below error when clicking into the Mapper.

Applies to

Transaction 10.x

Solution

Check the format of your Excel file. If the format is ".xlsx" please try resaving the Excel file as:

Open the script and use this newly saved file as the data file. Run the script again to see if this solves the issue.

Description

When logging into Winshuttle with a Connect License receive an error message:

Your credentials and license are currently being used to login from a different machine.

This is in violation with Winshuttle policy. Please contact your administrator for more details

Applies to

Studio 10.X and 11.X with Connect Licensing

Cause

This issue is generally caused in one of two ways:

After the last use of our product, the session was not closed by clicking File > Exit or using the red X in the top right corner

You are logged in on multiple different machines at the same time

Winshuttle's End User License Agreement licenses stipulates that a license can only be used by a single named user for one session at a time, however it is possible to have two concurrent logins. This is designed to allow for users who may not have logged out of a previous session. When you attempt to login to a second session you will receive a Warning as per the above however you will be allowed to login for the second session.

Solution

To resolve this Warning you can simply click OK to access the application.

Additional Information

Please be sure to close our software by using File > Exit or clicking the red X in the top right corner of the window in the future to avoid this issue.

If the warning persists then please notify Winshuttle Support and request a Forced Check Out of the older session; and advise a suitable time when you will be logged out of your current session.

If you attempt a third login from a third location, you will be blocked and you will require Winshuttle Support's assistance to unlock your account.

Description

Tax jurisdiction or address duplication popup is captured in script but does not appear to be handled during run

Applies To

XD01, XD02, XK01, XK02 (not limited to)

Cause

The tax jurisdiction and address duplication popups are from a third party tool Vertex. The scripts cannot interact with these popups when run in the background - this is also seen in SAP native recordings through SHDB.

Solution

Use GUI scripting or use Run on errors mode

*Run on errors will launch the GUI when the script encounters the popup. As the OK code is in the script for the popup the script will automatically move past the popup without user intervention.

Description

User is unable to logon to the Winshuttle application using Citrix server and is experiencing these set of errors in the details section of the error message:

Applies To

Citrix server clients operating with Studio 12.x.

Cause

There is an error in the configuration of the server for the user client.

Solution

Within the Citrix server, rename the user's Winshuttle folder in the C:\users\(user-id)\AppData\Roaming\Winshuttle location so that a new file is created.

Description

This error message is reported only when the user runs the GUI Scripts issue after updating Office 2016 v1806 (Build 10228.20080).

https://support.microsoft.com/en-us/help/4032364/how-to-control-the-blocking-of-ole-com-components-in-microsoft-office

Applies To

Studio

Excel builds 1806 and 1902

Cause

After updating Office 2016 v1806 (Build 10228.20080), the creation of the VBscript engine fails with: hr = CoCreateInstance(CLSID_VBScript, NULL, CLSCTX_INPROC_SERVER, IID_IActiveScript, (void**)&m_pActiveScript); hr: 0x80070005: Access is denied.

Solution

Add registry entry from installer from Office 2016 (Build 10228.20080) onwards.

To override and allow a OLE/OEM component,follow these steps:

Check OS version from Computer - Properties

Office bit version from Excel, account - About Excel. Data seen in tiny header line.

Then based onyour OS/ExcelVersioncase, go to registry in path

Case 1 - 64/32 bit Office with 32 bit OS:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Office\16.0\Common\COM Compatibility

Case 2 - 32 bit Office with 64 bit OS:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Wow6432Node\Microsoft\Office\16.0\Common\COM Compatibility\

Add this key if it is not present

{B54F3741-5B07-11cf-A4B0-00AA004A55E8}

This key is for enabling VBScriptin Excel.

(Program related can be seen in registry Computer\HKEY_CLASSES_ROOT\CLSID\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}\ProgID and it gives me VBScript. )

Then inside this key just added, add D-Word ActivationFilterOverride and modify its value to 1.

The file is no longer available.

Additional Information

If you had previously applied this fix and then upgraded Office again, please note that you will need to reapply the fix.

Read more :

See also the attached resolution article

Description

One of the Query data fields is returned with many leading zeros and the customer would like these zeros to be removed.

Applies to

Studio v.11x.

Solution

Create a transform using the formula =Value(cell).

Additional Information

Be sure to map the cell field (bottom left in image) to an unmapped cell in your script. The software will use this cell to convert the data.

Please note that as per current configuration and design, using Formula is only possible if the Data Type is Excel. Access as a Data Type is not supported.