Unable to select value from excel csv file to enter into drop down option in a form

Hi,
For filling one form i wrote below code ::
{
“Name”: “try1”,
“CreationDate”: “2019-10-13”,
“Commands”: [
{
“Command”: “open”,
“Target”: “Secure Online Store”,
“Value”: “”
},
{
“Command”: “csvRead”,
“Target”: “praxelloentries.csv”,
“Value”: “”
},
{
“Command”: “type”,
“Target”: “xpath=//[@id="product:name"]",
“Value”: “${!COL1}”
},
{
“Command”: “select”,
“Target”: "xpath=//
[@id="product:email"]”,
“Value”: “${!COL2}”
},
{
“Command”: “select”,
“Target”: “xpath=//*[@id="product:country"]”,
“Value”: “label=${!COL5}”
}
]
}
All the fields got populated except last drop down for countries. It said invalid command {!COL5}.
Can someone please help? It is highly urgent.

Regards,
Dhanashree

I rewrite your macro code and now working lika a charm :slight_smile:

See image

Ths is the code macro

{
“Name”: “ZZZ”,
“CreationDate”: “2019-10-13”,
“Commands”: [
{
“Command”: “store”,
“Target”: “true”,
“Value”: “!errorignore”
},
{
“Command”: “bringBrowserToForeground”,
“Target”: “”,
“Value”: “”
},
{
“Command”: “store”,
“Target”: “John-test”,
“Value”: “!COL1”
},
{
“Command”: “store”,
“Target”: “johnemail-testl@johnemail-test.com”,
“Value”: “!COL2”
},
{
“Command”: “store”,
“Target”: “Macao”,
“Value”: “!COL5”
},
{
“Command”: “open”,
“Target”: “Secure Online Store”,
“Value”: “”
},
{
“Command”: “waitForPageToLoad”,
“Target”: “10000”,
“Value”: “”
},
{
“Command”: “type”,
“Target”: “id=product:name”,
“Value”: “${!COL1}”
},
{
“Command”: “type”,
“Target”: “id=product:email”,
“Value”: “${!COL2}”
},
{
“Command”: “click”,
“Target”: “id=product:country”,
“Value”: “”
},
{
“Command”: “select”,
“Target”: “id=product:country”,
“Value”: “label=${!COL5}”
},
{
“Command”: “click”,
“Target”: “xpath=//*[@id="product:country"]/option[121]”,
“Value”: “”
}
]
}

Replace store vars with your csv and working with csv read