Need help migration from imacros to ui.vision rpa, in vba

Ui.Vision HowTo
1

I am a user of imacros in vba excel, I don’t know how to start to do the migration. should i install something first? Is there any documentation where I can find out how?

Thanks for your help

2

you have to rewrite code again in UI Vision.
I can help if you can share code.

3

@fagoncis Did you see this iMacros alternative page from ui.vision yet? It has some hints. Also, you find imacros forum posts here.

If you get stuck during the conversion - just ask here! :slight_smile:

PS: Since you mention VBA. Ui.Vision has good command line support - it can do what the iMacros Scripting Interface can do.

4

Thanks so much for yor answer. Here is a part of my code into Excel

Set iim1 = CreateObject(“imacros”)
iret = iim1.iimOpen(“-ng”)
NAVEGADOR = “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/83.0.4103.97 Safari/537.36”
macro = “VERSION BUILD=2021” & vbNewLine
macro = macro & “SET !PLAYBACKDELAY 1” & vbNewLine
macro = macro & “SET !TIMEOUT 30” & vbNewLine
macro = macro & “URL GOTO=https://www…com/login.aspx” & vbNewLine
macro = macro & “TAG POS=1 TYPE=INPUT:TEXT ATTR=NAME:Email CONTENT=” & Sheets(“CALCULOS”).Range(“H16”) & vbNewLine
macro = macro & “SET !ENCRYPTION NO” & vbNewLine
macro = macro & “TAG POS=1 TYPE=INPUT:PASSWORD ATTR=NAME:Password CONTENT=” & Sheets(“CALCULOS”).Range(“K16”) & vbNewLine
macro = macro & “TAG POS=1 TYPE=INPUT:SUBMIT ATTR=NAME:_ctl0:ContentPlaceHolder1:ctrl_login:btnVO” & vbNewLine
macro = macro & “URL GOTO=https://www…com/Stock/List.aspx” & vbNewLine
macro = macro & “Wait SECONDS = 2” & vbNewLine

iret = iim1.iimPlayCode(macro)

5

This is simple script.
you have to give complete URL

What I can suggest you is to start recording and do the steps.
then remove commands not required.

UI Vision cannot read from Excel. It supports CSV.

6

In my opinion you have to recreate the logic of your script again based on a csv from which to extrapolate the data.
So you have to think carefully about the work to be done, create a csv where to save all the data to be extracted and finally carry out the automation.
Seeing the code it seems to me a simple login form to fill in with data extraction, a very simple job for ui vision to automate

7

here is the script
you can complete /edit

{
      "Command": "store",
      "Target": "true",
      "Value": "!errorignore",
      "Description": ""
    },
    {
      "Command": "store",
      "Target": "30",
      "Value": "!TIMEOUT_PAGELOAD",
      "Description": ""
    },
    {
      "Command": "open",
      "Target": "",
      "Value": "",
      "Description": "URL"
    },
    {
      "Command": "type",
      "Target": "xpath=//*[@NAME=\"Email\"]",
      "Value": "PUT EMAIL HERE",
      "Description": ""
    },
    {
      "Command": "type",
      "Target": "xpath=//*[@NAME=\"Password\"]",
      "Value": "Put Password HERE",
      "Description": ""
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@NAME=\"_ctl0:ContentPlaceHolder1:ctrl_login:btnVO\"]",
      "Value": "",
      "Description": "Submit"
    },
    {
      "Command": "open",
      "Target": "",
      "Value": "",
      "Description": "URL"
    },
    {
      "Command": "pause",
      "Target": "2000",
      "Value": "",
      "Description": ""
    }
8

for useragent you have to use extension and set with commands.