I need some help migrating to RPA from iMacros

Ui.Vision
1

I need some help fairly quickly this week. While I have some background in programming it is not helping me much in trying to convert a script I made in Imacros several years ago to work with RPA.

Here is the old script:

VERSION BUILD=8820413 RECORDER=FX
SET !DATASOURCE bing-03.csv
SET !LOOP 1
SET !DATASOURCE_COLUMNS 1
set !var1 1
add !var1 {{!loop}}
SET !DATASOURCE_LINE {{!var1}}
SET !ERRORIGNORE YES
TAB T=1
URL GOTO={{!COL1}}
wait seconds=85

If it’s not clear what it’s doing I can explain. You can guide me or just create it so I can use it and I will compensate you for your time.

I am in the USA and you can respond here or email me at christian at nielsentech. com.

Thank you.

2

Hi, if I understand your IMacros macro correctly, all it does is to read some URLs from a CSV and then open up the website in the browser?

If so, this post here shows to read URLs from a CSV file in ui vision. You don’t even need the screenshot command. So just that should work:

{
      "Name": "url from csv",
      "CreationDate": "2021-7-19",
      "Commands": [
        {
          "Command": "csvReadArray",
          "Target": "url.csv",
          "Value": "myCSV",
          "Description": ""
        },
        {
          "Command": "echo",
          "Target": "Number of rows = ${!CsvReadMaxRow}",
          "Value": "green",
          "Description": ""
        },
        {
          "Command": "executeScript_Sandbox",
          "Target": "return ${mycsv[0]}.length;",
          "Value": "col",
          "Description": ""
        },
        {
          "Command": "echo",
          "Target": "Number of columns = ${col}",
          "Value": "pink",
          "Description": ""
        },
        {
          "Command": "comment",
          "Target": "loop over all CSV values in the array",
          "Value": "",
          "Description": ""
        },
        {
          "Command": "forEach",
          "Target": "myCSV",
          "Value": "row",
          "Description": "With each loop, we copy a new arraw ROW into the ${row[0] variable"
        },
        {
          "Command": "echo",
          "Target": "url is ${row[0]}",
          "Value": "brown",
          "Description": ""
        },
        {
          "Command": "open",
          "Target": "${row[0]}",
          "Value": "",
          "Description": ""
        },

        {
          "Command": "pause",
          "Target": "85000",
          "Value": "",
          "Description": "time to wait in MILLIseconds"
        },
        {
          "Command": "end",
          "Target": "",
          "Value": "",
          "Description": ""
        }
      ]
    }

Or, have a look at the CSV reading demo macro:

CSV reading URL
CSV reading URL735×360 54.6 KB

If that does not help you, let me know where you get stuck and I can assist further.

PS: A imacros command like SET !DATASOURCE_COLUMNS 1 is not needed with uivision, as it detects the available number of columns automatically.

3

Thanks for your reply. I just found it as I did not get a notification.

I will try what you sent. It should be a simple task, but I have been working with someone on Fivrr.com and they have been struggling to send me something that will work. I have been debugging parts of their scripts for them. :slight_smile:

I am starting to learn about JASON which should help…

Thanks again.

4

Awesome! The script worked perfect once I edited the CSV file name.

Thank you so much. How can I repay you???

Chris

5

I am glad it works! I enjoy answering these ui vision posts :smiley:

6

I’m glad you enjoy it because I ran into an error:

  • [error]

Line 8: open’ failed. No page load event detected after 10 seconds. Error detail: still same ipc secret

Can we change it so that a page no opening up is ignored and have it just continue?

Also, I set the time for 35 seconds. The proxy I was using sometimes times out.

Chris