Archive: RPA Forum

Need to get the output of a CMD command for use in your wizards? Check out this short guide! https://kryonsystems.force.com/KryoNet/s/article/Extract-Output-from-a-CMD-Command

You can extract zip file content using: 1- Python >> use Run script>> select python as language>> enter the below code : Python COde:from zipfile import ZipFile# Create a ZipFile Object and load sample.zip in itwith ZipFile('C:\temp\backup\myexcel.zip', 'r') as zipObj:# Extract all the contents of zip file in different directoryzipObj.extractall('C:\temp\') And then Run the wizard. 2- Batch File>> Create a batch file>> enter following code: @echo offsetlocalcd /d %~dp0Call :UnZipFile "C: emp"" "C: empackupmyexcel.zip"exit /b :UnZipFileset vbs="%temp%_.vbs"if exist %vbs% del /f /q %vbs%>%vbs% echo Set fso = CreateObject("Scripting.FileSystemObject")>>%vbs% echo If NOT fso.FolderExists(%1) Then>>%vbs% echo fso.CreateFolder(%1)>>%vbs% echo End If>>%vbs% echo set objShell = CreateObject("Shell.Application")>>%vbs% echo set FilesInZip=objShell.NameSpace(%2).items>>%vbs% echo objShell.NameSpace(%1).CopyHere(FilesInZip)>&

Push notifications for wizard alerts and robot offline notifications are supported via a push notification service called Pushover. See our article on KryoNet to get started! https://community.kryonsystems.com/KryoNet/s/article/Send-Push-Notifications 

Hi there! Welcome to the RPA forum!This is a forum for Kryon RPA users, and we invite you to ask questions, and share ideas from experiences working with the Kryon RPA platform and its components- Kryon Studio, Kryon Robot, Kryon Console, Kryon Admin and Kryon Application Server. Post, share, and respond to others! We can't wait to learn more about your experiences! 

Error Handling in VBA. Kindly watch this 23 min for handling errors while we write macro. Same will be useful while utilizing the same inside Kryon Studio Run Macro Advanced command. https://1drv.ms/v/s!AgFWy-B5ZbSi1VSiFYMfVq5rn712?e=OzHZLe Regards,ZK

First of all, you need to split the contacts if you want each of them to receive a separate email. To do that, use the split command. Afterward, you need to create a loop that checks the value in the variable that stores the email addresses and sends the wizard to the correct action accordingly (Send an email if the variable contains something/Doesn’t send if not).  To make it happen, do one of the following: Use a loop command that sends the email to each employee as long as the variable that stores the email address is Not empty.  Create a loop and let it run between two steps using an If Else command. Check out Kryon Academy, especially the Email Commands module from the Using Advanced Commands course. The demos there describe the same action suggested above: http://academy.kryonsystems.com. 

Open PowerShell as Admin and run the following command (in this example it checks for port 443 and computer name demotest1): Test-NetConnection -Port 443 -ComputerName demotest1

When you add advanced commands to a recorded step, you should always add them to Step End. By doing so, the application has time to load and you can be sure that the robot won't waste time on looking for the application it has to run the commands on. The default of Step End is to 'Go to Next Step'. When you have a core action, you'll always see it between Step Start to Step End.

Below is some example code for a random date generator. This could be used for testing your wizard for checking for holidays or any other purpose. 

Recording rules:• 100%DPI.• When using visual approach make sure to use commonly DPIs used (By users) resolution • If the screen sizes are not the same make note and plan accordingly • Don’t ever define a web browser as an application.Windows rules: • Try to be as specific as possible regarding window deduction.• Don’t put a long wait time for finding a window as this will keep the bot ideal until that period is over.• If you use a visual action in your flow don’t add the visual command to your window tab.Advanced commands:• Always at the end of the step.• There are ADC which you can’t use in a ADC step (Because they require a visual step)Detectable Objects:• It must be static.• It must be unique • It must at least 3 letters long.Offsets:• Keep the distance from the detectable object to a minimum • Don’t overlap your offset with your detectable object • Make sure that the distance between your detectable object and your offset is static.Sensors (Attended Automation)• Use multistep sens

When using “Get Excel Range Data” advanced commands with formatted text, pay attention to the column size. If your column is too narrow to display the full cell contents and you see ####, Kryon will return ####.  All you've got to do to fix this is make the column wider.You can do that using this excel macro:Sub AutoFitCells()Cells.SelectCells.EntireColumn.AutoFitEnd Sub

In order to work with Query from excel advanced commands you need to make sure to: 1. Install ODBCOLEDB Driver for AccessExcel. 2. The installation of MS Office (Excel) should be 64bit (the studio is 64bit as well). 32bit Office does not work and raises error.

Kryon Studio wizard editor has a built in "Find" option to help you search through lines of code or steps in your wizard for words or variables. This is very useful when you start to create multi step wizards with advanced commands for troubleshooting. The "Find" option is located on the main toolbar and is highlighted in the screen shot below.   

A very handy feature of the console is the availability to use Cron for setting up Time Triggers. In case you want to use cron for time-triggered (advanced tab), here is a useful editor you can use:https://crontab.guru/