Automate

Wondering if there is a way to make the log column in a Winshuttle transaction script dependent on the SAP environment the user is logged into.  For example, I would like to be able to have the log column chosen as follows:

If environment = ECQ 400 then use column G in excel template

else if environment = ECP 400 then use column E in excel template

Any ideas on this are appreciated,


------------------------------
Leonard Landry | Senior Financial Analyst
Clearwater Seafoods | 9024572364
------------------------------

Hi Leonard,

You may be able to use a column in the data template where the user populates their environment, and then use an IF condition to point the log to a specific column. Copy/paste the log column row in Studio and then use an IF condition for each. 

The other option I can think of would be to use a formula to look at the log for the environment, then pull/copy the details into an unmapped column. That way, as you switch environments, the logs will be saved separately. 

------------------------------
Vanessa Kutasi | Application Analyst II
IDEXX | New England WUG Leader
------------------------------

Original Message:
Sent: 05-31-2021 13:41
From: Leonard Landry
Subject: Log Columns based on SAP environment (Quality vs Prod)

Wondering if there is a way to make the log column in a Winshuttle transaction script dependent on the SAP environment the user is logged into.  For example, I would like to be able to have the log column chosen as follows:

If environment = ECQ 400 then use column G in excel template

else if environment = ECP 400 then use column E in excel template

Any ideas on this are appreciated,


------------------------------
Leonard Landry | Senior Financial Analyst
Clearwater Seafoods | 9024572364
------------------------------

Hi Leonard -

I just tried out Vanessa's suggestion, but unfortunately, Log columns cannot be included in IF conditions. But her other option is a good one, essentially using Excel to populate different columns based on the SAP environment that the script was run to.

The only other idea I have would be to still use a column as an indicator of the environment, but have the same script, duplicated, and also linked, and the log columns would be pointing to different columns in the different scripts. It would run or not run the appropriate script in the linked set of scripts, and would write to unique log columns.

Thank you!

------------------------------
Jennifer Hwang | SE
Winshuttle North America
------------------------------

Original Message:
Sent: 05-31-2021 13:41
From: Leonard Landry
Subject: Log Columns based on SAP environment (Quality vs Prod)

Wondering if there is a way to make the log column in a Winshuttle transaction script dependent on the SAP environment the user is logged into.  For example, I would like to be able to have the log column chosen as follows:

If environment = ECQ 400 then use column G in excel template

else if environment = ECP 400 then use column E in excel template

Any ideas on this are appreciated,


------------------------------
Leonard Landry | Senior Financial Analyst
Clearwater Seafoods | 9024572364
------------------------------

Thank you for your reply.  My preference would have been to automate using an IF condition within the script, but since that is not possible one of the other suggestions will do the trick.

------------------------------
Leonard Landry | Senior Financial Analyst
Clearwater Seafoods | 9024572364
------------------------------

Original Message:
Sent: 06-01-2021 09:23
From: Jennifer Hwang
Subject: Log Columns based on SAP environment (Quality vs Prod)

Hi Leonard -

I just tried out Vanessa's suggestion, but unfortunately, Log columns cannot be included in IF conditions. But her other option is a good one, essentially using Excel to populate different columns based on the SAP environment that the script was run to.

The only other idea I have would be to still use a column as an indicator of the environment, but have the same script, duplicated, and also linked, and the log columns would be pointing to different columns in the different scripts. It would run or not run the appropriate script in the linked set of scripts, and would write to unique log columns.

Thank you!

------------------------------
Jennifer Hwang | SE
Winshuttle North America

Original Message:
Sent: 05-31-2021 13:41
From: Leonard Landry
Subject: Log Columns based on SAP environment (Quality vs Prod)

Wondering if there is a way to make the log column in a Winshuttle transaction script dependent on the SAP environment the user is logged into.  For example, I would like to be able to have the log column chosen as follows:

If environment = ECQ 400 then use column G in excel template

else if environment = ECP 400 then use column E in excel template

Any ideas on this are appreciated,


------------------------------
Leonard Landry | Senior Financial Analyst
Clearwater Seafoods | 9024572364
------------------------------