How to deal with skipping CSV blank cells

UI.Vision RPA
1

How to skip to a Click when the ${!COL9} unit is blank?

Or allow the error to continue to allow the script.

Ask for help

{
“Command”: “click”,
“Target”: “xpath=//[@id=“content”]/div/div/div[2]/section[4]/div/div[2]/button[2]",
“Value”: “”,
“Targets”: [
"xpath=//[@id=“content”]/div/div/div[2]/section[4]/div/div[2]/button[2]”,
“xpath=//button[2]”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(1) > div.col-x24.col-l20 > button.btn.listing-editor__quantity-btn.btn–tertiary”
]
},
{
“Command”: “click”,
“Target”: “xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div/div",
“Value”: “”,
“Targets”: [
"xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div/div”,
“xpath=//section[4]/div[2]/div[2]/div/div/div”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(1) > div”
]
},
{
“Command”: “click”,
“Target”: “linkText=Custom”,
“Value”: “”,
“Targets”: [
“linkText=Custom”,
“xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/nav/ul/li[2]/a",
“xpath=//nav/ul/li[2]/a”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(2) > div > nav > ul > li:nth-child(2) > a”
]
},
{
“Command”: “type”,
“Target”: “id=customSizeInput0”,
“Value”: “{!COL8}", "Targets": [ "id=customSizeInput0", "xpath=//*[@id=\"customSizeInput0\"]", "xpath=//input[@id='customSizeInput0']", "xpath=//li/div/div/input", "css=#customSizeInput0" ] }, { "Command": "click", "Target": "xpath=//*[@id=\"content\"]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li/div/div/button", "Value": "", "Targets": [ "xpath=//*[@id=\"content\"]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li/div/div/button", "xpath=//li/div/div/button", "css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input--half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > ul > li > div > div > button" ] }, { "Command": "type", "Target": "id=customSizeInput1", "Value": "{!COL9}”,
“Targets”: [
“id=customSizeInput1”,
"xpath=//[@id=“customSizeInput1”]”,
“xpath=//input[@id=‘customSizeInput1’]”,
“xpath=//li[2]/div/div/input”,
“css=#customSizeInput1”
]
},
{
“Command”: “click”,
“Target”: “xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[2]/div/div/button",
“Value”: “”,
“Targets”: [
"xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[2]/div/div/button”,
“xpath=//li[2]/div/div/button”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > ul > li:nth-child(2) > div > div > button”
]
},
{
“Command”: “click”,
“Target”: “xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/div",
“Value”: “”,
“Targets”: [
"xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/div”,
“xpath=//div[2]/div/div[2]/div/div/div/div”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > div”
]
},
{
“Command”: “type”,
“Target”: “id=customSizeInput2”,
“Value”: “{!COL10}", "Targets": [ "id=customSizeInput2", "xpath=//*[@id=\"customSizeInput2\"]", "xpath=//input[@id='customSizeInput2']", "xpath=//li[3]/div/div/input", "css=#customSizeInput2" ] }, { "Command": "click", "Target": "xpath=//*[@id=\"content\"]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[3]/div/div/button", "Value": "", "Targets": [ "xpath=//*[@id=\"content\"]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[3]/div/div/button", "xpath=//li[3]/div/div/button", "css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input--half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > ul > li:nth-child(3) > div > div > button" ] }, { "Command": "click", "Target": "xpath=//*[@id=\"content\"]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/div", "Value": "", "Targets": [ "xpath=//*[@id=\"content\"]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/div", "xpath=//div[2]/div/div[2]/div/div/div/div", "css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input--half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > div" ] }, { "Command": "type", "Target": "id=customSizeInput3", "Value": "{!COL11}”,
“Targets”: [
“id=customSizeInput3”,
“xpath=//[@id=“customSizeInput3”]",
“xpath=//input[@id=‘customSizeInput3’]”,
“xpath=//li[4]/div/div/input”,
“css=#customSizeInput3”
]
},
{
“Command”: “click”,
“Target”: "xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[4]/div/div/button”,
“Value”: “”,
“Targets”: [
“xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[4]/div/div/button",
“xpath=//li[4]/div/div/button”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > ul > li:nth-child(4) > div > div > button”
]
},
{
“Command”: “click”,
“Target”: "xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/div”,
“Value”: “”,
“Targets”: [
“xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/div",
“xpath=//div[2]/div/div[2]/div/div/div/div”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > div”
]
},
{
“Command”: “type”,
“Target”: “id=customSizeInput4”,
“Value”: “${!COL112}”,
“Targets”: [
“id=customSizeInput4”,
"xpath=//[@id=“customSizeInput4”]”,
“xpath=//input[@id=‘customSizeInput4’]”,
“xpath=//li[5]/div/div/input”,
“css=#customSizeInput4”
]
},
{
“Command”: “click”,
“Target”: “xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[5]/div/div/button",
“Value”: “”,
“Targets”: [
"xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div/ul/li[5]/div/div/button”,
“xpath=//li[5]/div/div/button”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(2) > div > div > div.listing-editor__custom_sizes > ul > li:nth-child(5) > div > div > button”
]
},
{
“Command”: “click”,
“Target”: “xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div[2]/button",
“Value”: “”,
“Targets”: [
"xpath=//[@id=“content”]/div/div/div[2]/section[4]/div[2]/div[2]/div/div[2]/div/div/div[2]/button”,
“xpath=//div/div/div[2]/button”,
“css=#content > div > div:nth-child(1) > div:nth-child(2) > section:nth-child(5) > div:nth-child(2) > div.col-x24.col-l20 > div.dropdown.listing-editor__input–half > div:nth-child(2) > div > div > div.form__actions.br–none > button”
]
},

2

If you want the macro to continue running after an error occurs, you can add
Store | true | !ErrorIgnore
To see if everything is running ok you could check with an if for the variable !StatusOK

3

Very simple solution with if, if value have 0 number of characthers do not execute action

   {
      "Command": "if_v2",
      "Target": "${!COL9}.length == 0",
      "Value": ""
    },
    {
      "Command": "comment",
      "Target": "Do Nothing",
      "Value": ""
    },
    {
      "Command": "end",
      "Target": "",
      "Value": ""
    },
4 
  "Command": "if_v2",
  "Target": "${!COL15}.length > 0",
  "Value": ""
},
{
  "Command": "type",
  "Target": "id=fly-uploader-20210113-input",
  "Value": "${!COL15}",
  "Targets": [
    "id=fly-uploader-20210113-input",
    "xpath=//*[@id=\"fly-uploader-20210113-input\"]",
    "xpath=//input[@id='fly-uploader-20210113-input']",
    "xpath=//div[3]/div/div[2]/div/input",
    "css=#fly-uploader-20210113-input"
  ]
},
{
  "Command": "click",
  "Target": "id=fly-uploader-20210113-button",
  "Value": "",
  "Targets": [
    "id=fly-uploader-20210113-button",
    "xpath=//*[@id=\"fly-uploader-20210113-button\"]",
    "xpath=//button[@id='fly-uploader-20210113-button']",
    "xpath=//body/div[3]/div/div[2]/div/button",
    "css=#fly-uploader-20210113-button"
  ]
},
{
  "Command": "end",
  "Target": "",
  "Value": ""
},

It used to be like this all the time, but now it doesn’t work "Internal variable “!COL15” not supported
At Line 7 in ”

Why can’t it be used now! Is there any other way to skip blank cells.

Thanky

5

“Command”: “if_v2”,
“Target”: “{!COL15}.length > 0", "Value": "" }, { "Command": "type", "Target": "id=fly-uploader-20210113-input", "Value": "{!COL15}”,
“Targets”: [
“id=fly-uploader-20210113-input”,
“xpath=//[@id=“fly-uploader-20210113-input”]",
“xpath=//input[@id=‘fly-uploader-20210113-input’]”,
“xpath=//div[3]/div/div[2]/div/input”,
“css=#fly-uploader-20210113-input”
]
},
{
“Command”: “click”,
“Target”: “id=fly-uploader-20210113-button”,
“Value”: “”,
“Targets”: [
“id=fly-uploader-20210113-button”,
"xpath=//[@id=“fly-uploader-20210113-button”]”,
“xpath=//button[@id=‘fly-uploader-20210113-button’]”,
“xpath=//body/div[3]/div/div[2]/div/button”,
“css=#fly-uploader-20210113-button”
]
},
{
“Command”: “end”,
“Target”: “”,
“Value”: “”
},

以前一直都是这样，但现在不起作用“
在的第7行不支持内部变量“！COL15 ”

为什么现在不能使用它！有没有其他方法可以跳过空白单元格。

谢谢你

6

Blank cells ( = cells with “” content) are supported. But maybe the 15th column is completely missing? Can you post a sample CSV file here? Then we cant est.