Automate

​Hello All,
Still very new to Winshuttle, but I'm loving it!  Questions...

I've created a v12 script to create new PM Material Masters.  There are a few fields where a List Values table has been created to validate input, but the problem is although the fields have required data validation, one of the valid data selections is empty/null data.  There lies the problem.  So,

• Is there any way to add a null value in the list table area?  Or,
• What is the more acceptable practice to check for a field being empty/null when there's a list table preventing the acceptance of a null value?  For the fields in question, empty/null is allowed by SAP as a valid input?

(not able to add screenshot)

------------------------------
Shelia LeBeauf | Maintenance Coordinator
Newmarket Corporation | 713.740.8331
------------------------------

Hi Shelia

Have run into the same, and tried even a blank space to no avail.  But you can use IF logic to accomplish what I think you want to do.


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

Original Message:
Sent: 02-21-2020 11:46
From: Shelia LeBeauf
Subject: MM01 - Creating List Values for Required Fields

​Hello All,
Still very new to Winshuttle, but I'm loving it!  Questions...

I've created a v12 script to create new PM Material Masters.  There are a few fields where a List Values table has been created to validate input, but the problem is although the fields have required data validation, one of the valid data selections is empty/null data.  There lies the problem.  So,

• Is there any way to add a null value in the list table area?  Or,
• What is the more acceptable practice to check for a field being empty/null when there's a list table preventing the acceptance of a null value?  For the fields in question, empty/null is allowed by SAP as a valid input?

(not able to add screenshot)

------------------------------
Shelia LeBeauf | Maintenance Coordinator
Newmarket Corporation | 713.740.8331
------------------------------

​Hi All,

Would turning on the Skip Field indicator and replacing the blank in the source data with the Skip field indicator resolve this?

Regards

------------------------------
Mark Tiller | Delivery Enhancement Developer
Transport for London (TfL) | 0203 054 4196
------------------------------

Original Message:
Sent: 02-24-2020 14:04
From: sigrid kok
Subject: MM01 - Creating List Values for Required Fields

Hi Shelia

Have run into the same, and tried even a blank space to no avail.  But you can use IF logic to accomplish what I think you want to do.

I copied the field I wanted to use the LOV - Weight Unit above.  And I use an IF THEN ELSE statment

IF it's filled in, i.e. not blank, I use the LOV.
For the ELSE,  it's blank, I allow an upload of blank - or I could just make the value fixed and upload a blank - either works.

Hope that makes sense and works.

Best Regards,
Sigrid

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

Original Message:
Sent: 02-21-2020 11:46
From: Shelia LeBeauf
Subject: MM01 - Creating List Values for Required Fields

​Hello All,
Still very new to Winshuttle, but I'm loving it!  Questions...

I've created a v12 script to create new PM Material Masters.  There are a few fields where a List Values table has been created to validate input, but the problem is although the fields have required data validation, one of the valid data selections is empty/null data.  There lies the problem.  So,

• Is there any way to add a null value in the list table area?  Or,
• What is the more acceptable practice to check for a field being empty/null when there's a list table preventing the acceptance of a null value?  For the fields in question, empty/null is allowed by SAP as a valid input?

(not able to add screenshot)

------------------------------
Shelia LeBeauf | Maintenance Coordinator
Newmarket Corporation | 713.740.8331
------------------------------