Form Fill from CSV error

UI.Vision RPA
1

Hello,

I am in Chrome trying to fill in a web based form from a csv list. The inputs are web URLs.

Everything works until it goes to fill the second box and gives me the error

[error]
Internal variable “!COL2” not supported

I am not sure why this happens because it looks like it should just be referencing what is in each column.

Looping doesn’t help because I have multiple text boxes that need filled with their own unique url.

Thank you in advance!

2

Hi, can you post your macro here? Maybe it is a syntax error or typo.

Does ${!COL1}] work ok?

3

Yes it ${!COL1} does work but fails going to the second

4

{
“CreationDate”: “2018-7-17”,
“Commands”: [
{
“Command”: “store”,
“Target”: “180”,
“Value”: “!timeout_macro”
},
{
“Command”: “store”,
“Target”: “fast”,
“Value”: “!replayspeed”
},
{
“Command”: “comment”,
“Target”: “The file ReadCSVTestData.csv is pre-installed with Kantu.”,
“Value”: “”
},
{
“Command”: “csvRead”,
“Target”: “kantucsv_test.csv”,
“Value”: “”
},
{
“Command”: “echo”,
“Target”: “Status = ${!csvReadStatus}, line = ${!csvReadLineNumber}”,
“Value”: “”
},
{
“Command”: “while”,
“Target”: “”${!csvReadStatus}" == “OK”",
“Value”: “”
},
{
“Command”: “echo”,
“Target”: “status = ${!csvReadStatus}, line = ${!csvReadLineNumber}”,
“Value”: “”
},
{
“Command”: “click”,
“Target”: “id=in_tweet_1”,
“Value”: “”
},
{
“Command”: “type”,
“Target”: “id=tweet_url_1”,
“Value”: “${!COL1}${!csvReadLineNumber}"
},
{
“Command”: “click”,
“Target”: “name=addMoreTweets_1”,
“Value”: “”
},
{
“Command”: “click”,
“Target”: “id=in_tweet_2”,
“Value”: “”
},
{
“Command”: “type”,
“Target”: “id=tweet_url_2”,
“Value”: "${!COL2}${!csvReadLineNumber}”
},
{
“Command”: “click”,
“Target”: “name=addMoreTweets_2”,
“Value”: “”
},
{
“Command”: “click”,
“Target”: “id=in_tweet_3”,
“Value”: “”
},
{
“Command”: “type”,
“Target”: “id=tweet_url_3”,
“Value”: “${!COL3}”
},
{
“Command”: “storeEval”,
“Target”: “${!csvReadLineNumber}+1”,
“Value”: “!csvReadLineNumber”
},
{
“Command”: “store”,
“Target”: “true”,
“Value”: “!errorIgnore”
},
{
“Command”: “echo”,
“Target”: "Reading CSV line No. ${!csvReadLineNumber} ",
“Value”: “!errorIgnore”
},
{
“Command”: “csvRead”,
“Target”: “kantucsv_test.csv”,
“Value”: “”
},
{
“Command”: “store”,
“Target”: “false”,
“Value”: “!errorIgnore”
},
{
“Command”: “endWhile”,
“Target”: “”,
“Value”: “”
}
]
}

5

Bumping this to see if anyone can help.

6

What is the goal with this line?

7

Goal is to have it reference text in a csv file and fill in a line in a form.

8

I am happy to use the kantu macro, this is my first macro plugin that I use, but it is not successful, I am in need of using this on cpanel and cloudflare, but there are errors, I think this is not working with Javascript or maybe I was the one that is not doing the right configuration of the macro, I notice that the macro do work for the dropdown menu in both cpanel and clould flare and there is another timeout error that i found doing the test… do anybody have idea on how to do about it,

9

Hello, it’s a better idea to create separate issue, paste there your macro, show screenshots of problem parts on page and on macro + log. Also please provide your system\browser\kantu version there.
Best regards.