Automate

 View Only

  • 1.  Winshuttle Studio Connect logon macro

    Posted 06-25-2020 05:58
      |   view attached
    Hi,

    I'm using a macro to run several published transaction scripts.
    In the macro I use the ALC file to logon to SAP automatically.
    Is it also possible to use VBA to logon automatically to Winshuttle Studio Connect?

    Regards, Tom

    ------------------------------
    Tom Schurink |
    Signify |
    ------------------------------


  • 2.  RE: Winshuttle Studio Connect logon macro

    Employee
    Posted 06-25-2020 20:13
    Hi Tom

    Hope you're well!

    Not that I'm aware, but that doesn't mean it's not possible.  I do have a couple of questions about your use case:

    • Is there a reason you cannot save your Winshuttle Connect credentials? 
    • Or is it that you are sharing this with other users who may or may not have logged in? 
    • Or is this being run by a "bot?  If so, the bot typically has saved Connect credentials.


    I guess I have more questions than answers this evening.  :)   

    Best Regards,
    Sigrid

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

    Original Message


  • 3.  RE: Winshuttle Studio Connect logon macro

    Posted 06-26-2020 02:08
    Hi Sigrid,

    For me it is just a "nice to have" vba challenge to see if you can write code that recognizes if a user is logged in, if not, then log in automatically.
    In that way the macro will always run, weather you are logged in or not, without manually entering your credentials.
    But then I ran into an issue that surprised me and I think this is not supposed to happen.
    When I'm logged out from Winshuttle and run the macro, the log on to connect pop-up window is appearing.
    To my surprise the macro started to run while I clicked the cancel button in the pop-up window, and the macro was working as supposed.
    Maybe you can check if this also is the case when you do the same handlings as I did.

    Regards, Tom

    ------------------------------
    Tom Schurink |
    Philips Lighting |
    ------------------------------

    Original Message


  • 4.  RE: Winshuttle Studio Connect logon macro

    Posted 06-26-2020 02:51

    Hi Tom,

     

    There is an add in for Excel so you can run the script directly from Excel without opening up Studio, you just need to ensure you have the same bit versions of Excel and Studio. I'm having great success with 64 bit at the moment.

     

    You could script the macro to run through the process of selecting the options on the ribbon for that add in.

     

    Cheers


    NOTICE: This email and any attachments are confidential.
    They may contain legally privileged information or
    copyright material. You must not read, copy, use or
    disclose them without authorisation. If you are not an
    intended recipient, please contact us at once by return
    email and then delete both messages and all attachments.




    Original Message


  • 5.  RE: Winshuttle Studio Connect logon macro

    Posted 06-26-2020 04:21
    Hi Ben,

    What you are proposing is exactly what I'm already doing.
    I run the macro by coding the add in, this is standard code provided by Winshuttle.
    My point is that I'm logged out from Winshuttle, so in Excel the icon on the left shows "Log on to Winshuttle".
    Then when I run my macro, Winshuttle shows the log on pop-up window, because I'm logged out.
    Without entering credentials and by clicking the cancel button, the macro starts to run.
    In fact I answered my own question because it does seem to be possible to automatically log on to Winshuttle with VBA macro by, clicking the cancel button.
    I'm not really sure yet, but when my statements are correct then I think this is called a software bug.

    regards, Tom


    ------------------------------
    Tom Schurink |
    Philips Lighting |
    ------------------------------

    Original Message


  • 6.  RE: Winshuttle Studio Connect logon macro

    Posted 06-26-2020 07:46
    Ok, I think I figured it out.
    The very first time I run my macro in Excel and I'm not logged in, I need to log on with my credentials in the Winshuttle log on popup window, to be able to run the maco. I don't check the "Remember credentials" checkbox and I click ok, and the macro starts running.
    The second time I run the macro, the Winshuttle log on pop-up window is appearing again and although I click the cancel button, the macro starts running.
    So that means although the log on popup window is appearing again and I click cancel without entering my credentials, Winshuttle remembered that I'm logged in, so the macro starts running..
    Although I didn't check the checkbox to remember my credentials and although the icon on the left in Excel still shows "Log on to Winshuttle", Winshuttle remembered my log in credentials and knows I'm still logged in.
    So maybe it's not a bug, but in my opinion this is not the way this should be working.

    When Winshuttle remembered my log in, the log in popup window should not appear the second time I run the macro.
    When I click cancel in the log in popup window, the macro should not start running. Not needed when the popup window isn't showing the second run.
    When I'm logged in to winshuttle, the Excel icon should show my name. I don't know if this is possible when running a macro.

    Regards, Tom

    ------------------------------
    Tom Schurink |
    Philips Lighting |
    ------------------------------

    Original Message


  • 7.  RE: Winshuttle Studio Connect logon macro

    Employee
    Posted 12-10-2020 12:51
    Hey Tom,

    Thanks for letting us know about this behavior on the Connect Login. I have logged it as a bug to have this checked out. Can you confirm which version of Winshuttle Studio you saw this behavior?

    For a bit of background, when you login to Connect, it stores a local login file within %AppData% that the system uses to confirm your credentials. Unchecking the Remember Me would not delete this AppData file, so it looks like clicking Cancel is failing back to that AppData file, rather than bailing out of the Login completely as we would expect. 

    In terms of the Macro, typically people would be running this with their credentials stored and saved so that this pop-up does not appear. Without this, the macro would have to somehow determine which user is currently running the script, and have their login credentials stored in the macro logic to login under the correct user. I wouldn't recommend this as a best practice, but as you mentioned, this was more of a VBA "challenge" anyway.

    Thanks again for sharing the feedback!

    ------------------------------
    James Lofgren | Solution Engineer
    Winshuttle North America | [City] |
    ------------------------------

    Original Message


  • 8.  RE: Winshuttle Studio Connect logon macro

    Posted 12-11-2020 02:04
    Hi James,

    I have the latest version now, but if I'm correct, it was Studio 12.0

    Regards,
    Tom

    ------------------------------
    Tom Schurink |
    Signify Netherlands B.V. |
    ------------------------------

    Original Message


  • 9.  RE: Winshuttle Studio Connect logon macro

    Employee
    Posted 12-11-2020 11:57
    Hey Tom,

    Thanks for the reply! I was actually able to reproduce this issue on 12.1, so our support team is escalating to engineering to have this resolved. Nice find!

    ------------------------------
    James Lofgren | Solution Engineer
    Winshuttle North America | [City] |
    ------------------------------

    Original Message


  • 10.  RE: Winshuttle Studio Connect logon macro

    Posted 06-28-2020 21:04

    Hi Tom,

     

    Yeah forgot about the log on, not sure how you would get around that with a Macro.

    Would be keen to know if you do come up with a solution.

     

    Ben




    Original Message