Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Looking to learn other ways of loading to free up excel use

    Posted 01-15-2019 10:30
    Looking to learn new ways of loading other then the standard way from excel one load at a time. When I use excel I can only load one script at a time. When I have multiple excels up they are locked out from loading.

    I have tried using scheduling but have found some t-codes (VK11, VK12, and others) when scheduled a few minutes apart using the same t-code lines show as error but when reran independently with no issue. I am also seeing when a scheduled load is running and want to use excel it opens the load file and lose the use of working on other excel files.


    ------------------------------
    Benjamin Kielas | SAP Master Data Team Lead
    Generac Power Systems, Inc. | [City] | (262) 544-4811
    ------------------------------


  • 2.  RE: Looking to learn other ways of loading to free up excel use

    Posted 01-15-2019 14:16
    ​An option that we use here is to obtain an older, secondary laptop (or desktop) computer to use as a "grunt" machine for running large scripts.  I, personally, have access to 5 or 6 computers that I can use to run Winshuttle scripts... though I believe that you can only be running scripts on one machine at a time (due to licensing restrictions).

    Additional fyi, I believe that the script feature 'backup sap data' (for running Transaction scripts) makes it so that you cannot use Excel while a script is running.  I have users here that, at least with Transaction v10.7, were able to launch multiple instances of Transaction on a single machine, and run multiple scripts simultaneously, but if you are using the 'backup sap data' option, that is no longer possible.

    ------------------------------
    Jeremie Dippel
    Project Engineer @ Rockwell Automation
    Wisconsin Local Wug Leader
    I'm your huckleberry.
    ------------------------------



  • 3.  RE: Looking to learn other ways of loading to free up excel use

    Posted 11-18-2020 16:59
    if you want to be able to run multiple Winshuttle templates at the same time from the same physical screen...

    disable the Hardware Graphic Acceleration and verify the result:
        Open Excel.
        Click on file, Options.
        Go to the Advanced tab.
        Under the Display section, check the box for 'Disable hardware graphics acceleration'.
        Click ok and restart Excel. 


    ------------------------------
    Jack McGarry | Sr Business Systems Analyst | Airgas, an Air Liquide company
    ------------------------------



  • 4.  RE: Looking to learn other ways of loading to free up excel use

    Employee
    Posted 11-20-2020 10:24
    Hi Benjamin

    You can also spin up VM's and use those to run Winshuttle. 

    Also, you can use Foundation, Studio Manager or Evolve to run on server/schedule on server.  Here's a Wuginar I did a few months ago on the topic:  https://www.winshuttle.com/assets/webinar-why-server-based-execution-is-a-game-changer-wuginar/ 

    Best Regards,
    Sigrid

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