Automate

Hola Manuel,

SAP login is needed only once within a chain of scripts.
Go to chain settings (screenshot) and then to ALC.


When I run chained scripts, Winshuttle studio 12.1 gives me the message 'All scrips ran succesfully'.
Furthermore, the log table of the last script is filled out, so that's another sign all scrips within the chain have finished.

------------------------------
jan ketele | Sr engineer release mgt
Xeikon Manufacturing NV | +3234431875
------------------------------

​Thank you Jan

I've done what you say, but it works only when you are chaining only queries or only transactions. In my case I have both and it's necessary to validate the Log On for each one... The custom option is not available... :(


Concerning the message box, I didn't say before that I run the scripts embebed into the Excel File and with the most of the pages hiden, for user's appearence reasons... In this case it's difficult to realize if the scripts have finished or not... I need a real message box. I can do it directly by an Excel Macro in VB, but the problem is that the message is shown before the script has finished. I  launch by VB the starting of the Winshuttle and the message appears inmediately. I need something into the winshuttle script...

------------------------------
manueldomingo.oreiro |
PSA Groupe |
------------------------------

Original Message:
Sent: 06-09-2020 08:13
From: jan ketele
Subject: 2 questions

Hola Manuel,

SAP login is needed only once within a chain of scripts.
Go to chain settings (screenshot) and then to ALC.

When I run chained scripts, Winshuttle studio 12.1 gives me the message 'All scrips ran succesfully'.
Furthermore, the log table of the last script is filled out, so that's another sign all scrips within the chain have finished.

------------------------------
jan ketele | Sr engineer release mgt
Xeikon Manufacturing NV | +3234431875
------------------------------

Hi Manuel,

if you start your script from vb then you can check in vb if the last row of the log filecolumn is filled. 
Don't show the message box until this is filled.
Or make check the log header and check if the Execution time  has a value.  That should work for both Transaction and Query.

regards

------------------------------
Jan van Asseldonk | Consultant
CTAC | +31629078169
------------------------------

Original Message:
Sent: 06-09-2020 10:50
From: manueldomingo.oreiro
Subject: 2 questions

​Thank you Jan

I've done what you say, but it works only when you are chaining only queries or only transactions. In my case I have both and it's necessary to validate the Log On for each one... The custom option is not available... :(

Concerning the message box, I didn't say before that I run the scripts embebed into the Excel File and with the most of the pages hiden, for user's appearence reasons... In this case it's difficult to realize if the scripts have finished or not... I need a real message box. I can do it directly by an Excel Macro in VB, but the problem is that the message is shown before the script has finished. I  launch by VB the starting of the Winshuttle and the message appears inmediately. I need something into the winshuttle script...

------------------------------
manueldomingo.oreiro |
PSA Groupe |
------------------------------


Original Message:
Sent: 06-09-2020 08:13
From: jan ketele
Subject: 2 questions

Hola Manuel,

SAP login is needed only once within a chain of scripts.
Go to chain settings (screenshot) and then to ALC.

When I run chained scripts, Winshuttle studio 12.1 gives me the message 'All scrips ran succesfully'.
Furthermore, the log table of the last script is filled out, so that's another sign all scrips within the chain have finished.

------------------------------
jan ketele | Sr engineer release mgt
Xeikon Manufacturing NV | +3234431875

Hi Manuel

As you've found out, chaining transaction and query scripts does not allow you to carry through the initial login between them.  Once you switch between the two, i.e. from query to transaction or transaction to query, it will prompt for another login.  

I would suggest you open a support ticket requesting our product team consider an enhancement for a single login to work.   I think it should work with one login, as well. :) 

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------

Original Message:
Sent: 6/11/2020 2:27:00 PM
From: Sigrid Kok
Subject: RE: 2 questions

Hi Manuel

As you've found out, chaining transaction and query scripts does not allow you to carry through the initial login between them.  Once you switch between the two, i.e. from query to transaction or transaction to query, it will prompt for another login.  

I would suggest you open a support ticket requesting our product team consider an enhancement for a single login to work.   I think it should work with one login, as well. :) 

Best Regards,
Sigrid

------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------