Search results

hi, if i have queue items in a queue, and change the item key from "Field1" to "_requestId", is this supposed to not change the item key for the already created queue items? i am updating an older process, and would like to see with my own eyes if it works before importing it. thanks in advice

hi. i want to add zeros before a number so that the length of the text is 8 digits. how do i do this? the information i get looks like "AB00000001" , i want to make it "AB00000002" by using Trim("AB" & ToNumber(Right[number];8))+1) i get AB2, but i miss all the zeros in between. how do i solve...

hi. i have a text with 2 letters and 8 numbers that looks like "AB00000001" that is in a text data item. i want to add +1 to the number. how do i do this when it is text format? thanks

hi. i am updating a process for multiple inputs. the process runs simulations based out of 5 inputs that is given. it takes 15-20 minutes per simulation, afterwards an excel sheet is sent to an end user with the simulation information. the chance of an error is fairly high during the simulation...

hi i have 2 collections, collection A with 50 rows and collection B with 150 rows which holds currency rates for different countries. i want to compare the currencies in the collections for those rows who are included in both collections. how do i get the row holding a specific currency without...

hi . i wonder how i select items in this sap table: i want to select the first one "exchange rate type" by clicking the box to the left, and afterwards select another item a few rows down. how do i click the box? i am not able to spy it, only the row name. thanks

hi. i have a sap drop down where i want to select item number 11, which is totally blank. but it says max number is 10. i use navigate select item. i tried writing "" in the text but it doesnt work. how do i solve this? i can select all other items except this blank one thanks i tried spying in...

i am so tired of drop downs in sap. anyways, i now have a drop down that i want to press to get a invoice as pdf. i cannot identify the menu bar and use select menu item. i am only able to set focus to it. so i tried doing that and sent enter key to root element but doesnt work. any ideas?

hi how do i access sap drop down menu in the upper menu bar? i cannot identify the drop down button, but i can identify the dropdown window (as win32 window) that appears after the button have been pressed. but since i do not know how to open the window, i am a little bit stuck help would be...

hi as the subject says, how do i double click a specific field in a sap table? i am only able to do "set focus" in the nav stage. any ideas?

hi. i want to get a cell that can have a 0 before some other numbers. how can i do this? the cell looks like "01" but the value is only 1. but i want to get "01". the cell is formated. is there a way to do this?

hi. i cant figure out how to add a collection as one single queue item. i am using utility work queue add item to queue but it adds all my rows as individual items instead of only one. would appreciate some help here

hi im making a process that is including SAP right now, and all sap windows works except this single one. the box i want to write in is not a normal text box, it has "possible entries", of all currencies in a menu. i have tried write stage, which got me this error: Internal : Failed to perform...

hi, i get a error from when trying to write in a specific textbox in SAP i get this error if i use navigate to send keystrokes, i can only select "set focus". any ideas? i am using attach in the beginning of the stage.

hello i have made a simple process which opens outlook, and downloads 3 excel attachments. and rename them. i get a ActiveX error from the production once in a while. it looks like this: " ERROR: Internal : Could not execute code stage because exception thrown by code stage: Could not create...

hi. i have a process that extracts an excel document from sap and saves it. but it extracts it in a weird format, called "Microsoft Excel 97-2003 Worksheet (.xls)". i want to change this without having to open the file (if possible) because the file also has a pop up that says "The file format...

hi. i am now making a process where i check if the hierarchy in SAP is similar to a excel sheet. to do that, i need to copy the hierarchy. i am now thinking that i can expand the whole hierarchy and then press the copy button above the tree. but i am not sure of what do to after i have pressed...

hi. i have been sitting with this for hours now. i cannot identify a window correctly, there are multiple similar window. i want to write the date in a window and the only thing i have done successfully is making a global mouse click on it. but i still cant write in the window while it is...

hello i was assigned with a new process. this time i am accessing a huge excel file with a lot of data. the first step is to choose 1 out of 2 options in a pivot table to filter the huge data. i believe it is possible to create a macro in excel that changes the pivot table and then use "run...

hi. i have a problem, i am now learning ms excel vbo, but i just cannot use the open workbook action. i get error "Internal : Could not execute code stage because exception thrown by code stage: Exception has been thrown by the target of an invocation." i dont know why. i know the file path is...