Archive: RPA Forum

I have an Excel file with two columns (code, sum) and I want to find a specific value by searching the sum in that same row for example: I want to get the 'code' 8 by searching the sum 8000 by using an Excel macro function (or the query from excel)example of the excel file: 

We are so proud to be recognized as a Leader in RPA in the Forrester report, "The Forrester Wave: Robotic Process Automation, Q1 2021", published today. Check out the full story here.

I got a client ID (a number), (Example: 123456)I got the length of it by using the command "Get Length".The length will always be less then 10 digits,But I want it to be equal to 10. (Example: 0000123456)how can I accomplish that? thanx in advance

In order to solve this - verify net.tcp communication between Studio and Server. 1) Check Studio: Help -> about and see if - next to server - it says http.2) If it does, change the following in your config file:enforceserverschema to net.tcp     

Hi team, Any idea to rotate the PDF using vb script. I have archived through python but can you assist the same for me in vb? Attaching the Py FYR.

If you find that your wizards aren't working properly (especially the HTML advanced commands) in Chrome you might be missing our Kryon Connector for Chrome extension. If you have Kryon RPA v19.3 or above you can install it from here: https://chrome.google.com/webstore/detail/kryon-connector-for-kryon/phhmigidlcofifmichkhofnibnflhpkf/ If you have a version earlier than 19.3 you can install the legacy version here: https://chrome.google.com/webstore/detail/kryon-connector/bobjelhgkmdobdbhiaemkombflgdoalk

Hiin continuation of the topic about sending notifications about problems with robots https://community.kryonsystems.com/s/question/0D506000078syJ2CAI/sending-slack-notifications-from-your-kryon-robot,sent notifications about unsuccessfully completed tasks that are performed by robots the trigger was configured on the Kryon database, the LeoAutomationRunHistoryAnalyticsData tablewith the condition WizardCompletedStatus! = 0 Only tasks that complete with errors Very convenient when you are not behind the pc

RPA for handling the Policies Demo/Details : https://www.youtube.com/watch?v=D3FFHPr-cXA

I have an embedded wizard in a wizard (wizard 2). I have tried to link the embedded wizard to wizard 2 so once the steps for embedded wizard is over, it will go to wizard 2 and continue running. However, it didn't continue running on its own. It stops there. I was wondering where could i go wrong.Here is what i have done.I intend to go to step 4 from step 3(embedded wizard)What can be done to ensure the robot runs smoothly? 

I have a table loop that run on rows (splited by ___)and in each row I split the data by ||| to fields.if in a specific field I dont have the right data I want to move on to the next row,so what I did is to put an IF and if its not the correct answer dont do anything. my Q is there anything better to do than that (like in C# loop break or continue)thank u

I would like to extract data from row 11 and let robot know to stop extracting data once the row is empty. but how can i do that? i know that i can use a loop item advanced command? here is what i have done so far.  

I would like to get the name of the excel file in the format ".xls" only. but so far it will return me the file in the format "xls" and "xlsx". I have tried using the if method but it returns me files in xls and xlsx which isn't the outcome i want. So far here is what I have done. I would like to use the if else command

Description:This wizard demonstrates the robot's ability to loop through folders containing 2 images and performing a comparison using Microsoft Cognitive Services. The Microsoft Cognitive Services have been developed into a .NET plugin that contains 2 functions. The first function is to process a single image and the result is an image ID. The second function is to compare the 2 image IDs and it returns 2 values, isIdentical and Confidence Level. Once the results are received, the robot writes the information into an output excel. General Information:Kryon Studio Version: 20.9 Preliminary Adjustments:Update the root folder, which contains folders of the images. Update the API Key (Requires a subscription with Microsoft Cognitive Services, Face Recognition) Update the endpoint URI (Requires a subscription with Microsoft Cognitive Services, Face Recognition) Assumptions:There is an existing subscription with Microsoft Cognitive Services, Face Recognition. Process Developer/Contributors:

If you do you get questions like: start cmd.exe and start JAVA.If I create a BAT file it won't work.. this is the cmd command in need to start: rundll32 user32.dll,SetCursorPosand this is the java environment: C:Program Files (x86)Marathonjre1.8injavaw.exe -Xmx1024m -Dsun.net.http.allowRestrictedHeaders=true -jar marathon.jar server=omdh.kase.se An attended start will force the user to first open cmd.exeAfter you've done that it askes for Java to start:any idea's?

Emailtrigger with the first unread mail wil mark the mail read before your script starts!!!let's say you want to let a robot be triggered by a mail with subject #Blueprint​ You create a trigger in the Administrator Console. Wath out! If in your robot script it say it acts on this subject with "unread email' this will not work.Because if you have one email receieved, the trigger will mark thisemail read.. and your script won't find an email according to these rules.So remove this mark from the GET EMAIL command and let your script move the mail to a subfolder or delete afte use otherwise the script will keep reading this mail.Mind you this is how it worked in version 20.3

Hi everyoneI'm running on excel file and taking all the table from it (don't know the actual size).when I'm showing what I got from the excel file - it gives me all the table including all the empty rows (but with the delimiters |||||_)I have a loop that runs on the data and split it into row and variables and after that insert the variables into SQL, and then go to the next row.in the loop after it ran on the data it will still run and will show me that the row = '|'. how can I fix this???I can add an IF to check if the first variable is empty but that means that the loop will run one more time for no reason..

thanks for the idea @Mark Lim​ https://community.kryonsystems.com/KryoNet/s/question/0D51o00006z7VgOCAU/automation-sample-sending-telegram-notifications-from-your-kryon-robot In this particular wizard, notifications are sent when the robot turns off (ghost), but you can do it for any requests

I pressed ctrl+A to select all,and after that I want to cancel it, the pnly option that worked was to mouse click on an empty spot on screenIs there any other option to Cancel the select all Thank u very much

If anyone ever runs into issues when using the java UI commands, make sure to reinstall Java (for 64 bit latest version is currently: jre-8u271-windows-x64) and change the installation path to : C:Program Files (x86)Javajre1.8.0_271 (i.e. your version). By default the installation points to C:Program Files which causes the AC not to work and then you get the following error in Kryon:  Please follow instructions in the Advanced Commands guide - Appendix E: https://kryonsystems.my.salesforce.com/sfc/p/24000000H7fv/a/0600000024Yo/dATXEkFnKX8Ova58c9YeVUG1fmmzNHolCil0Zh_Ltoo When it's all working correctly, you should get a screen like this: - click the cursor icon - on the left and then select the object in your java application.  Thanks and good luck!Marlon

Hi everyoneI'm trying to use an SQL DBso I opened the SQL command, and inside they ask me to insert the connection string - and I don't know what is itI tried this but it didn't workI don't know what to do nextPlease help meThank you all

HII want to create a xml file that will have all the built-in values.such as the folder path, built-in variables ETC. thanks

Hi everyone! Kryon released the new v20.9 version and here are the release notes attached! ✨ Bug fixes focusing on:General errors Installation Advanced commands usability and functionality Performance issues in console and clients Auto-healing mechanism New Features and Enhancements PerformanceStudio and Robot logs are now routed to the local server for performance enhancement A new monitor added to supervise over the Robots health status and restart Robots when needed Log optimization - Log level in some areas was reduced from info to debug What we worked on in Kryon StudioImproved support for Windows Narrator and added functionality Improved UI Automation and Java Advanced Commands You can now access Kryon Community and Kryon Academy through Kryon Studio home page and wizard editor What we worked on in Kryon AdminMulti-tenancy Support New stand-alone independent Export and Import user permissions 

While running a wizard with the Robot (20.3; via trigger), when I'm connected via RDP to the server the Robot runs as expected.But when I disconnect from the server and no longer see the screen, the wizard can't find Chrome windows and the process fail.The screenshots I captured from the "Window not found" fallback is just a black screen. (BTW, I already set the "EnableLogonExpert" key to False but it changed nothing) Thanks,Omer

Congratulation for Kryon Bot Camp winners! Bot Camp winners and their medal-earning wizards were awarded at the Kryon Automation Olympics:Gold: Abhi Saxena and Ishi Saxena for their Intelligent Pharma Bot Silver: @Eduard Zhereliuk​ Eduard Zhereliuk for his Customer Complaints Resolver for Retail Business Bot Bronze: @Sasidharan T​ Sasidharan T for his Signature Verification Bot Abhi, Ishi, @Eduard Zhereliuk​ , @Sasidharan T​  - share with us your tips for creating a a winning automation? You can see the winning projects HERE. Bot Camp developers were awarded gold, silver, and bronze medals and cash prizes for developing the most innovative and impactful automation wizards that push the boundaries of robotic process automation. “We were astounded by the creativity, diversity, and scope of the Bot Camp entries we received,” said Harel Tayeb, CEO of Kryon. “This event proves the untapped talent and innovation of citizen developers around the world and the impact they can bring to today’s