Automatization from CSV


#1

Hello everyone :slight_smile:

I am new to Kantu, and therfore I need a hand for this.

I have an excel file, with one column. On every line there is one http url. I saved it in CSV and uplaod it to Kantu.

I would like Kantu to open the first link, click on the first button, then click on the seccon button that pops up, then close the tab, and repeat these steps for the second url link.

If there is anyone who could help I would be gratefull :slight_smile:


#2

You’re going to have to learn some basics yourself but to get you started, here’s how to open a link taken from a csv file.

        {
      "Name": "OpenCSV",
      "CreationDate": "2018-12-4",
      "Commands": [
        {
          "Command": "store",
          "Target": "CSVFILENAME.csv",
          "Value": "csvFile"
        },
        {
          "Command": "csvRead",
          "Target": "${csvFile}",
          "Value": ""
        },
        {
          "Command": "echo",
          "Target": "LineNumber: ${!csvReadLineNumber}",
          "Value": ""
        },
        {
          "Command": "while",
          "Target": "\"${!csvReadStatus}\" == \"OK\"",
          "Value": ""
        },
        {
          "Command": "selectWindow",
          "Target": "TAB=OPEN",
          "Value": "${!COL1}"
        }
    }

Replace “CSVFILENAME.csv” with the actual csv filename.

Save it into a file and name it whatever is appropriate, with the file extension “.json”, and in the macros folder of Kantu.

Next, you need to click the buttons you described. I can’t help you with that but the docs or vids will get you there fast, I’m sure.


#3

Hi TheWhippinpost,

First of all, thank you so much for taking the time to help me.
Some years ago I started as a beginer on VBA ang got to learn a lot. But at first it´s a bit hard to start from scratch, so thank you.

Just one question regarding the macro, where on the code can i indentify which line and wich column are we talking?

I will go deeper to learn to do the rest :slight_smile: Will get back here if i dont succeed


#4

I got this error message:


#5

It seems a comma , is missing behind } in line 30 :wink:


#6

I added the comma but still has the same message :frowning:


#7

I don’t think I can see the whole code in your image. To me it looks like you’re missing a closing } on line 30


#8

"value": "${!COL1}"

Is the column number.

LineNumber: ${!csvReadLineNumber}"

This will print the line number when it’s running in the Logs pane.