Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    alex-never
    @alex-never
    script.png
    Actually, there are some some questions. Still working with Excel action. With the Get Range i can copy to variable a range of cells. What is a correct action to paste them back in other Excel file (or sheet). Write Range is not working as it produces error. Write Row is also not working.
    error.png
    Iron-Hunter
    @Iron-Hunter
    Get Range returns a delimited string, while write range uses a datatable so you should simply switch out the Get range command with the get range as datatable command and select the output action as datatable to be able to use that variable with write range
    alex-never
    @alex-never
    Change of action to Get Range as Datatable helps. But, now you have to select at least 2 rows of data in the initial range, for example A1, F1. I assume, that one row is reserved for the Header (even if you do not select Add Header). If you select only one row (A1, F1), you get error during the execution Write Range (Index is out of range exception).
    Iron-Hunter
    @Iron-Hunter
    I do not really understand your question but I will try to clarify how both functions work.
    Get Range needs 2 parameters, the first one is the starting cell to start retrieving from and the second one is the last cell to end retrieving at. It can start in A1 for example and End at A10 so that way the range now contains the column from these cells or you can get a whole table ex. A1 to B10 and that way you get everything in that 2 column table. So to clarify even more, if you have a square that you wish to copy on a graph you can do so easily if you know the coordinates of the corners. The first cell location in the function acts as the location of the top left corner of the square while the last cell location in the function acts as the location of the bottom right corner of the square. As such you can specify the range from any cell to any cell which will give you a matrix containg the data but when you write it you only give it the starting cell and it will start placing all the data from that cell (Top left corner of the table) and fill it as necessary
    If you still find it difficult to understand I am willing to help you more even through an online call or something similar
    alex-never
    @alex-never
    My test use case is quite simple. I need to copy data from cell A1 to F1 and put it starting with cell A5. So, Here is my config:
    WRITE_R.png
    GET_R.png
    alex-never
    @alex-never
    And here is the error
    r_error.png
    My assumption, is that because i try to get values only from 1 row. When i change Get Range to A1 - F2, then there is no errors.
    But i need only values in one row (not the full row, only from a range).
    alex-never
    @alex-never
    And one more question in parallel. Where can i find the description of Filter configuration for Outlook actions? There are some in the example scripts and as i can see they differs from what is actually used in Outlook. For example, in Outlook [from] in taskt [SenderName]. Also how can i use partial matches, like 'Invoice *'?
    Iron-Hunter
    @Iron-Hunter
    @alex-never Hi, as for the first question remove the curly braces on the variable name. Unfortunately I don't think I can help you regarding the second questions since I still haven't gone in depth into the outlook and email commands
    alex-never
    @alex-never
    @Iron-Hunter, the curly braces are working fine. Here is an example of working code.
    working.png
    But, as soon as i change F2 to F1, it produces error.
    Maybe this is not the way i should proceed with copying of a range in one row?
    Iron-Hunter
    @Iron-Hunter
    @alex-never For me when I use the curly braces around the variable I get an error, however I tried many different examples using Get and Write Range and I can't seem to reach your error so I would have to take a look at the excel file you are working with as well as the bot file to be able to help you further
    alex-never
    @alex-never
    @Iron-Hunter test table is simple as that
    excel.png
    Ironhunter95
    @Ironhunter95
    @alex-never And what exactly are you trying to do with it?
    alex-never
    @alex-never
    @Ironhunter95 , the idea is to copy a range from one row (not the full row) and paste into another. This is just a test example. I need values A1:F1 to be copied to A5:F5.
    Ironhunter95
    @Ironhunter95
    aaaaasdasd.png
    aaaaasdasd.png
    I just did that, no problesm
    problems
    want me to send the script?
    levandox
    @levandox
    Is takst server available?
    alex-never
    @alex-never
    @Ironhunter95 , please, attache the script. because for some unknown reason similar configuration doesn't work for me. i do not get any errors, but nothing is copied in the file.
    git-volver
    @git-volver
    I want to start to use taskt, but I am facing some difficulties to do with a simple case, that is, log in to a site with name and password in a web page, just it. How to send the credential to work? and how to do this without type the password text plain? I do not find such a sample. Regards!
    Ironhunter95
    @Ironhunter95
    @alex-never
    @git-volver , what I can think of off the top of my head is using the specific class or element of the text boxes for login username and password and then sending keystrokes there..as for the password the only way I can think of to make it secure is that you run a seperate bot at the start to encrypt the passcode with a certain key and place it in a document..then in the login bot you can retrieve that encrypted passcode and decrypt it and use it..There may be other ways but this is what I can think of
    sorry if it wasn't much of a help
    git-volver
    @git-volver

    @git-volver , what I can think of off the top of my head is using the specific class or element of the text boxes for login username and password and then sending keystrokes there..as for the password the only way I can think of to make it secure is that you run a seperate bot at the start to encrypt the passcode with a certain key and place it in a document..then in the login bot you can retrieve that encrypted passcode and decrypt it and use it..There may be other ways but this is what I can think of

    Ok, I will think about it, thanks by your collaboration!

    alex-never
    @alex-never
    @Ironhunter95 , thanks for file. I have included my excel file, but unfortunately it still produce the same error - out of range. Maybe the reason in versions of Taskt (v3.5.0.0) or Excel (MS Office 365 Pro Plus).
    alex-never
    @alex-never
    Can someone share examples of filters for Get Outlook Email action? For partial match of subject (like, "manage"), dates filters (like, between 01/12/2020 and 31/12/2020), presence of attachment, partial match of sender (like, "@mycompany.com"), keywords in email body, etc.
    Aman Wadhwa
    @amanwadhwa08
    DO we need to install any driver or need to change settings as create browser is failing for me.
    saucepleez
    @saucepleez
    @amanwadhwa08 You will need ChromeDriver present. It has typically been included in the Resources folder which sits 1 level below where the .EXE is.
    saucepleez
    @saucepleez
    If you are unable to resolve any issues, please create a new issue for them in the Github, that way we can know if your problem is resolved.
    alex-never
    @alex-never
    @saucepleez , the TaskT tool is really interesting and promising. I have already found several use-cases how to automate my personal daily routines. But when it comes to complex tasks with different systems involved lack of up-to-date documentation limits the possibilities to use the tool. Do you have in plans update of the wiki with action descriptions and specifications?
    MukeshMikky
    @MukeshMikky
    Hi, I am a newbie to RPA. I want to schedule taskt bot remotely in a server. How to do this? Thanks!
    saucepleez
    @saucepleez
    @/all Does anyone here use the official code signed releases? Or you typically build yourself? I ask because I am unsure if it's worth renewing the code signing certificate as it has a monetary cost associated with it.
    CameronHerwig
    @CameronHerwig
    The signed release adds a lower barrier to entry for less technical people looking to play with RPA. We could write up a guide on pulling and building to replace it and help newer users. Generally I build myself to allow a deeper look into the underlying code during execution if I encounter any issues.
    alex-never
    @alex-never
    I do use official releases. But if there be easy step-by-step guide, i think it will be OK just to follow it.