Automate

 View Only

  • 1.  Speed of condition data upload/update in VK11

    Posted 01-27-2021 09:24
    I created a script for vk11 upload with 2 thousand lines of data records. I was hoping it would not take time but to my surprise it is uploading one record per second. Is this speed normal. ? I made the script in batch input mode. I was expecting it to be much higher.
    Any ideas to speed up ?
    BR,
    Manoj

    ------------------------------
    Manoj Adhikari | Pricing Specialist
    Metso Oy | +358440526010
    ------------------------------


  • 2.  RE: Speed of condition data upload/update in VK11

    Posted 01-27-2021 10:51
    Hi Manoj,

    what's helping me is:
    disable automatic calculation in Excel,
    minimize the excel window to only the upper row,
    disable backup data in run screen,

    I hope this can speed up you upload too .

    best of luck, Jan

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

    Original Message


  • 3.  RE: Speed of condition data upload/update in VK11

    Posted 01-28-2021 02:21
    Hi Jan,
    Thanks for your suggestion. I applied the suggestion as you mentioned and yet I am finding it really slow. Speed is the same still. I have also tried uploading through script scheduling, and closed all my open programs but yet it is slow.
    :/
    Kind regards,
    Manoj

    ------------------------------
    Manoj Adhikari | Pricing Specialist
    Metso Oy | +358440526010
    ------------------------------

    Original Message


  • 4.  RE: Speed of condition data upload/update in VK11

    Employee
    Posted 01-27-2021 19:09
    Hi Manoj

    I agree with Jan's suggestions.

    Also, are you posting them individually?  If so, if it is the same access sequence/keys for each of the 1000's, you could try a loop.

    Best Regards,
    Sigrid


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

    Original Message


  • 5.  RE: Speed of condition data upload/update in VK11

    Posted 01-28-2021 02:27
    Hi,
    I do not fully get your question here but just to let you know, I created a script through recording. I used one example material to upload the condition data. and once recording and mapping is completed, I just copy pasted all the remaining lines into right fields. And then i saved and ran the script through excel.
    Loop is something i am not much familiar yet, so i will have to see if that helps.
    Anyway, thank you for recommendation.
    BR,
    Manoj

    ------------------------------
    Manoj Adhikari | Pricing Specialist
    Metso Oy | +358440526010
    ------------------------------

    Original Message


  • 6.  RE: Speed of condition data upload/update in VK11

    Posted 01-29-2021 07:49

    One thing you could is load one record manually and compare that to the one second time. Maybe one second isn't so bad?

    Also, if you can run it on server the processing time might not seem to be as bad since it frees up resources on your computer.

    Thanks,
    Derek



    ------------------------------
    Derek Sayres | SAP PLM Business Analyst
    ------------------------------

    Original Message


  • 7.  RE: Speed of condition data upload/update in VK11

    Posted 02-03-2021 04:56
    Hi,

    Actually one second is quite bad, when you have the need to update hundreds of thousands of rows.
    Perhaps running on server might be a good idea, but resource wise, i did not see the upload blocking me from doing other tasks at all.
    I noticed with Loop i was able to reduce time in the end. It seems it also matters whether my SAP have WFM installed or not.

    BR,
    Manoj

    ------------------------------
    Manoj Adhikari | Pricing Analyst
    Metso Oy | +358440526010
    ------------------------------

    Original Message


  • 8.  RE: Speed of condition data upload/update in VK11

    Employee
    Posted 02-03-2021 09:23
    Hi Manoj

    Speed will definitely improve with later versions of the product.  V11 introduced an improved look and feel.  All later versions focused on performance improvements.

    Also for the loop, you should be able to create a loop with more than 30-ish items.  If you are running into an error there, you can open a support ticket to track it down.

    Best Regards,
    Sigrid


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

    Original Message


  • 9.  RE: Speed of condition data upload/update in VK11

    Employee
    Posted 01-29-2021 15:56
    Hi Manoj

    The way you are loading, it sounds like you are posting 1 record at a time, which is slower.

    You can create a loop, with the condition type and access sequence information in there once, and then the "line items" are all of the condition records.

    Then when you run, it will post all of them in one go, which is more efficient.

    There is information in the online training on basic looping which may help you, if you want to pursue it.

    Best Regards,
    Sigrid

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

    Original Message


  • 10.  RE: Speed of condition data upload/update in VK11

    Posted 02-03-2021 09:14
    Hi Sigrid,
    Yes in the beginning, i was only using the single line update. But later I managed to do with Loop. I noticed also that not always the loop and batch works. With my SAP having WFM11.0 i was not being able to upload more than 35 details line in one block of details. So i had to put header in every 36th line. But another SAP environment with WFM12.1, batch upload works with no limit of details count per block.
    Anyway, thank you for your help and suggestions, wish you a good day ahead.
    BR,
    Manoj

    ------------------------------
    Manoj Adhikari | Pricing Analyst
    Metso Oy | +358440526010
    ------------------------------

    Original Message