Link list from CSV file

UI.Vision RPA
1

Hey everyone!

I’m brand new to macros in general, and Kantu looked like the best Addon for my uses.

Well, let me explain.
I have a link list (aprox. 200 urls). I want to create a macro that opens a link, do an action (simple click) and closes the tab. And then, do the same for the other link.

I want to mass delete some uploaded images. Could you guys help me out here?

Thanks!

2

To open a URL stored in a CSV file:

{
  "Name": "AT-OpenCSV",
  "CreationDate": "2019-02-4",
  "Commands": [
    {
      "Command": "store",
      "Target": "CSVFILE.csv",
      "Value": "csvFile"
    },
    {
      "Command": "csvRead",
      "Target": "${csvFile}",
      "Value": ""
    },
    {
      "Command": "echo",
      "Target": "LineNumber: ${!csvReadLineNumber}",
      "Value": ""
    },
    {
      "Command": "while",
      "Target": "\"${!csvReadStatus}\" == \"OK\"",
      "Value": ""
    },
    {
      "Command": "echo",
      "Target": "status = ${!csvReadStatus} line = ${!csvReadLineNumber}",
      "Value": ""
    },
    {
      "Command": "selectWindow",
      "Target": "TAB=OPEN",
      "Value": "${!COL15}"
    },
    {
      "Command": "selectWindow",
      "Target": "TAB=0",
      "Value": ""
    },
    {
      "Command": "pause",
      "Target": "",
      "Value": ""
    },
    {
      "Command": "selectWindow",
      "Target": "TAB=CLOSEALLOTHER",
      "Value": ""
    },
    {
      "Command": "endWhile",
      "Target": "",
      "Value": ""
    }
  ],
}

Change: “Value”: “${!COL15}”

… to reflect the column position in your csv file that contains the URLs. For example, if it’s column 2, change to “${!COL2}”

Replace the pause command with commands that perform the “simple action” (delete image) you wish to execute.

Good luck

1 Like
3

btw, i’m using Firefox addon!

4

Hello

Is there any way we can open CSV links through loop in New Tab ?