Internal variable "!COL1" not supported


#1

I am using a CSV file imported using the ‘import CSV’ function. My CSV file has column headers labelled COL1, COL2 etc… In my test target and pattern I have ${!COL1} , ${!COL2} etc…

However when running the test I immediately receive “error Internal variable “!COL1” not supported”

Initially I thought I received this because I am using Firefox however I use Chrome and this still occurs.

Any advice please


#2

Can you please post a test macro here?


#3

{
“Name”: “TEST CSV”,
“CreationDate”: “2019-1-21”,
“Commands”: [
{
“Command”: “open”,
“Target”: “http://medeformappde00.medway.gov.uk:8080/ufs_dev/ufsmain?formid=LE_BURNODOUR”,
“Value”: “”
},
{
“Command”: “select”,
“Target”: “id=CTID-346--A",
“Value”: “label=Air pollution (including dust/grit in the air)”
},
{
“Command”: “click”,
“Target”: "name=CTRL:145:
”,
“Value”: “”
},
{
“Command”: “type”,
“Target”: “id=CTID-514--A",
“Value”: “Chart Place”
},
{
“Command”: “click”,
“Target”: "name=CTRL:525:
”,
“Value”: “”
},
{
“Command”: “select”,
“Target”: “id=CTID-529--A",
“Value”: “label=CHART PLACE, PARKWOOD, GILLINGHAM”
},
{
“Command”: “click”,
“Target”: "name=CTRL:538:
”,
“Value”: “”
},
{
“Command”: “click”,
“Target”: “name=CTRL:145:",
“Value”: “”
},
{
“Command”: “click”,
“Target”: "name=CTRL:538:
”,
“Value”: “”
},
{
“Command”: “select”,
“Target”: “id=CTID-454--A",
“Value”: “label=Commercial/Business use”
},
{
“Command”: “type”,
“Target”: "id=CTID-348-
-A”,
“Value”: “Garden”
},
{
“Command”: “click”,
“Target”: “id=CTID-444--A-2",
“Value”: “”
},
{
“Command”: “click”,
“Target”: "id=CTID-450-
-A-2”,
“Value”: “”
},
{
“Command”: “type”,
“Target”: “id=CTID-452--A",
“Value”: “Air Pollution Commercial Business use No path”
},
{
“Command”: “type”,
“Target”: "id=CTID-355-
-A”,
“Value”: “Air Pollution Commercial Business use No path”
},
{
“Command”: “click”,
“Target”: “name=PAGE:N”,
“Value”: “”
},
{
“Command”: “select”,
“Target”: “id=CTID-259--A",
“Value”: “label=Mrs”
},
{
“Command”: “type”,
“Target”: "id=CTID-261-
-A”,
“Value”: “${!COL1}”
},
{
“Command”: “type”,
“Target”: “id=CTID-263--A",
“Value”: “${!COL2}”
},
{
“Command”: “click”,
“Target”: "name=CTRL:267:
”,
“Value”: “”
},
{
“Command”: “click”,
“Target”: “id=CTID-469--A-1",
“Value”: “”
},
{
“Command”: “type”,
“Target”: "id=CTID-474-
-A”,
“Value”: “1”
},
{
“Command”: “type”,
“Target”: “id=CTID-477--A",
“Value”: “Street”
},
{
“Command”: “type”,
“Target”: "id=CTID-480-
-A”,
“Value”: “Town”
},
{
“Command”: “type”,
“Target”: “id=CTID-482--A",
“Value”: “Sussex”
},
{
“Command”: “click”,
“Target”: "name=CTRL:499:
”,
“Value”: “”
},
{
“Command”: “type”,
“Target”: “id=CTID-268--A",
“Value”: “01634 333333”
},
{
“Command”: “type”,
“Target”: "id=CTID-272-
-A”,
“Value”: "lagandev.sentmail@medway.gov.uk"
},
{
“Command”: “click”,
“Target”: “name=CTRL:549:",
“Value”: “”
},
{
“Command”: “click”,
“Target”: "name=CTRL:66:
”,
“Value”: “”
}
]
}


#4

This is an internal eform.


#5

the csvread command is missing


#6

My apologies!

Thank you