Automate

 View Only
  • 1.  Script for MD62 Transaction

    Posted 11-22-2022 12:11
    What will be ideal way to build Win Shuttle script for MD62 T code (For uploading requirements ), by using loops or conditions? Any script available for reference?

    ------------------------------
    Mahesh Sanap | Analyst
    Eaton Corporation | 8668353029
    ------------------------------


  • 2.  RE: Script for MD62 Transaction

    Employee
    Posted 11-23-2022 17:25
    Hi Mahesh,

    It depends on what you're trying to do.  For the most part, you can use the FORWARD button to move horizontally to scroll through a screen full of  weeks or months or whatever period you're using.

    HTH
    Sigrid

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



  • 3.  RE: Script for MD62 Transaction

    Posted 11-24-2022 04:49
    Hi Sigrid,
    I am trying to build a script for mass upload in MD62 (Schedule Lines), being beginner in building scripts - need your help on guiding what logic we can use to build it as we have more than 100 planning materials and demand horizon is for 117 Weeks. So, it's tough to upload/change manually each week. Looking for script to automate it. Pls your help on it.

    Thanks,
    Mahesh

    ------------------------------
    Mahesh Sanap | Analyst
    Eaton Corporation | 8668353029
    ------------------------------



  • 4.  RE: Script for MD62 Transaction

    Employee
    Posted 11-29-2022 20:13

    Hi Mahesh

    Typically we answer questions on the community - not build scripts from scratch for customers.

    Sounds like some training would be helpful.  You can sign up for some basic training here:  https://community.winshuttle.com/browse/training  and contact your account rep for services assistance, as needed.

    I can only offer an example here - attached.  Here is what I entered for this example:
    entered values in the first row that I could see
    Note I hard coded selected version in my example - you can record to use the option you want

    hit the page forward
    hit save

     You'll need to put a loop around the set of 5 entries, uploading 5 at a time in a row.

    That's what I did in the attached example

    Ensure when you select your recording mode as BATCH mode, which I found to be the best selection, otherwise it didn't start in the week I provided properly.  Click change mode and choose BATCH.

    Example attached uploading 5 values at a time.  Please ONLY use this as an example.  My intention is to show you an approach.  Please do NOT run this in production, either.  You can adjust the entries and try it in a non-prod system to see what I did.

     

    Material requirements after run:


     

    If you don't want to use a loop, you can record all of the entries for the one material – say 50 weeks – repeating the steps above as you record it, and then map them as separate columns for entry/update.

     

    Sigrid



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



  • 5.  RE: Script for MD62 Transaction

    Posted 11-30-2022 05:34
    Appreciate your help Sigrid for sharing the details.

    I have also built a script but sometimes after script run, system won't show data for all weeks, there will be few missing weeks in middle...at start and end weeks will be correct...and when i ran the same script for 2nd time, it will show all weeks correctly...not sure why it's happening...appreciate if you can help on it.

    ------------------------------
    Mahesh Sanap | Analyst
    Eaton Corporation | 8668353029
    ------------------------------

    Attachment(s)



  • 6.  RE: Script for MD62 Transaction

    Employee
    Posted 12-01-2022 12:06
    Mahesh,
    Did you look at my example and suggestion about BATCH mode?  Yours is non-batch.  Please take a look and try recording in BATCH.
    Sigrid

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