Hi Henrik ,
I am assuming the predefined scripts are either Transaction or Query scripts.If they are,assuming the production Foundation is identified as a "production status".,the scripts that a submitted to the foundation need to be "Approved" based on the workflow assigned by the admin.That is when the scripts are considered ready to run.
To run these scripts,download the scripts contained in either Query Scripts or Transaction Scripts folder and also the corresponding Data Template .
After making sure you are logged in the Studio to the production foundation,launch the downloaded Data Template and login to Foundation using the Winshuttle Add-in. You should notice that by moving control to the worksheet ,the script that was designated for that worksheet is already picked.Also notice the 'Test' button is not 'Run' button.
Another method is to login to foundation using 'login to Winshuttle " in the Winshuttle Run tab ,then moving to the Winshuttle Foundation tab,open data template from the foundation tab.You should see 'Run' instead of 'Test' again.
The third way is through Studio, in Open option there are three choices Open Query Script Library,Open Transaction Script Library being the important ones.Any script picked from the library should also launch data file in Studio.Please ensure you see 'Run' instead of 'Test' again.
Hope,this is what you are looking for.
------------------------------
rama medisetty | Winshuttle Developer
Exxon Mobil Corporation | 1(346)335-0562
------------------------------
Original Message:
Sent: 09-11-2019 09:39
From: Henrik Axell
Subject: Winshuttle run / Winshuttle thru Excel
After a bit of digging, I found the solution and understanding needed
https://docs.winshuttle.com/studio-en-12-1-x-online-help-studio-w-foundation-user-gov/12/excel-addin-transaction.htm
------------------------------
Henrik Axell Master Data Analyst
Essity Hygiene and Health
Original Message:
Sent: 09-11-2019 02:28
From: Henrik Axell
Subject: Winshuttle run / Winshuttle thru Excel
Hi all
We have recently identified the usage of running Winshuttle with Excel with a predefined script.
The issue I am facing is that the script it self that it published towards foundation to be able to run towards our production-enviroment, where can I/should I pick that script up when running it in excel?
If I save it locally on my hard drive I can run it, but if I want a user to do the same, they can´t access my drive.
And when I browse the scripts on our sharepoint, it says "The specified path is invalid" even thou I can see the library in question.
Anyone else running winshuttle with excel and how have you solved it?
------------------------------
Henrik Axell Master Data Analyst
Essity Hygiene and Health
------------------------------