Select - Drop down with comma (,) from csv

#1

Need to select a text having comma (,) from drop down from csv.
Getting “Option type “” not supported”

Value tried: IN, India

echo is printing properly with out quotes.

CSV contains:
“IN, India”

#2

It sounds like did escape the, in the CSV files, so I am not sure why it does not work. => Can you send me a test case?

I did a quick test using our own store page and a CSV file with the country name "Bonaire, Sint Eustatius und Saba" and all worked fine.

{
  "CreationDate": "2018-7-16",
  "Commands": [
    {
      "Command": "open",
      "Target": "https://sites.fastspring.com/a9t9/instant/seeshell-pro",
      "Value": ""
    },
    {
      "Command": "csvRead",
      "Target": "readcsvtestdata.csv",
      "Value": ""
    },
    {
      "Command": "select",
      "Target": "id=product:country",
      "Value": "label=${!COL1}"
    }
  ]
}
1 Like
#3

Sorry, I did some mistake.
Now working fine.

#4

Hi for below code Im getting error in last command as - internal command !col5 is not supported.
{
“Name”: “try1”,
“CreationDate”: “2019-10-13”,
“Commands”: [
{
“Command”: “open”,
“Target”: “https://sites.fastspring.com/a9t9/instant/seeshell-pro”,
“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”: “XClick”,
“Target”: "xpath=//[@id=“product:country”]”,
“Value”: “”
},
{
“Command”: “type”,
“Target”: “”,
“Value”: “${!COL5}”
}
]
}
tried using select target and label . still same error can you please help?

#5

Solved here i rewrite your macro and working well :slight_smile: