Automate

 View Only

  • 1.  IE05 Characteristics Values How to get there?

    Posted 09-15-2021 03:29
    Hi Community, since weeks i try to extract the  class information from our equipment.Query and direct isn't the needed output coz 300K rows in excel is very unsexy  and not really nice to handle. so i tried to export it from IE05 and it work's nearly great, till that pop-up is comming to select the layout "AGAIN" coz it has no value when it's loaded in the beginning (see the red arrow's). Problem is i can't aktivate the second time the row with the layout it won't be recorded...and that's desperating. The only way to activate that row is with a mouse click and that click is not recorded. 




    Any idea how to get there, imo the solution would be a great way to get the information pretty easy with a time schedule job each night so u could process the info in further reports very nice.

    Thx in advance

    ------------------------------
    Matthias Lautenschlaeger | PLM Assistant
    GSI Helmholtzzentrum für Schwerionenforschung GmbH |
    ------------------------------

    Attachment(s)

    Txr
    IE05_20210915_090924.Txr   1.07 MB 1 version
    xlsx
    IE05_20210915_090924.xlsx   288 KB 1 version


  • 2.  RE: IE05 Characteristics Values How to get there?

    Posted 09-15-2021 08:32
    Hi Matthias-

    I've always used this Query using a logical database (LDB) instead. So this is another option for you to try. You can change the operator of the equipment number field, my example is using a like but you can change it to = for a single equipment, of between for a range, for IN to point to a list of equips. 

    Thanks!

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

    Attachment(s)

    Qsq
    Equipment-LDB-Class+Char-Excel.Qsq   1.51 MB 1 version
    xlsx
    Equipment-LDB-Class+Char-Excel.xlsx   26 KB 1 version


  • 3.  RE: IE05 Characteristics Values How to get there?

    Posted 09-16-2021 02:30

    Hi Jennifer, thank you for the template. Thats what i talked about in my post, it's complete inaceptable to give my workpackageleader a sheet with 300K rows to find what they need and update the data. Compared, to the output in the query mode, i get 18K Equipments, so far and as well 18K lines, thats also a lot but with excel they could use the filter functions. No idea why it's not possible to activate the row in the subscreen? But thx again, i was at that point also, with the BAPI Method but thats not what we want.

    Screen from our testsystem, which has a few of our equipments :) 200K Rows is nothing smooth to handle



    ------------------------------
    Matthias Lautenschlaeger | PLM Assistant
    GSI Helmholtzzentrum für Schwerionenforschung GmbH |
    ------------------------------

    Original Message


  • 4.  RE: IE05 Characteristics Values How to get there?

    Posted 09-16-2021 09:28
    Hi Matthias -

    Yes, I tried it too, and that screen does not work to capture a row selection. That table does not have any background enabled fields to be able to be selected, even as a cursor position, to select that row. And there's no other option to select all or anything. So really the only option of capturing that would be to use Gui scripting recording mode.

    Thanks!

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

    Original Message