Internal variable "!COL1" not supported

Post complete macro code and i solve the problem

Post json of your macro please

Here the json of the macro. Thx a lot! :slight_smile:

{
  "Name": "Test",
  "CreationDate": "2021-2-22",
  "Commands": [
    {
      "Command": "csvRead",
      "Target": "liste.csv",
      "Value": ""
    },
    {
      "Command": "open",
      "Target": "https://www.lbc.fr/",
      "Value": ""
    },
    {
      "Command": "clickAndWait",
      "Target": "xpath=//*[@id=\"container\"]/main/div/div/div/header/div/nav/div/a[2]/div/span",
      "Value": "",
      "Targets": [
        "xpath=//*[@id=\"container\"]/main/div/div/div/header/div/nav/div/a[2]/div/span",
        "xpath=//a[2]/div/span",
        "css=#container > main > div > div:nth-child(1) > div:nth-child(1) > header > div._1TRNX.a8N1M > nav > div:nth-child(1) > a.styles_newAdLink__Oi46f > div > span"
      ]
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div/div/div/div/div/div/div[2]/div/div/div[2]/div[2]/div[5]/div/div/div[2]",
      "Value": "",
      "Targets": [
        "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div/div/div/div/div/div/div[2]/div/div/div[2]/div[2]/div[5]/div/div/div[2]",
        "xpath=//div[2]/div[5]/div/div/div[2]",
        "css=#container > main > div > section > div > div > div:nth-child(2) > div._14s_w.tShLp > div > div > div > div._3DI7P > div > div:nth-child(2) > div > div > div.CUS2Y > div:nth-child(2) > div:nth-child(5) > div > div > div._3MBji"
      ]
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div/div/div/div/div/div/div[2]/div/div/div[2]/div[2]/div[5]/div/div[2]/div/div",
      "Value": "",
      "Targets": [
        "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div/div/div/div/div/div/div[2]/div/div/div[2]/div[2]/div[5]/div/div[2]/div/div",
        "xpath=//div[5]/div/div[2]/div/div",
        "css=#container > main > div > section > div > div > div:nth-child(2) > div._14s_w.tShLp > div > div > div > div._3DI7P > div > div:nth-child(2) > div > div > div.CUS2Y > div:nth-child(2) > div:nth-child(5) > div > div:nth-child(2) > div:nth-child(1) > div"
      ]
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div/div/div/div/div/div/div[2]/div/form/div[2]/button",
      "Value": "",
      "Targets": [
        "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div/div/div/div/div/div/div[2]/div/form/div[2]/button",
        "xpath=//button[@type='submit']",
        "xpath=//button",
        "css=#container > main > div > section > div > div > div:nth-child(2) > div._14s_w.tShLp > div > div > div > div._3DI7P > div > div:nth-child(2) > div > form > div._2Qp5n > button"
      ]
    },
    {
      "Command": "click",
      "Target": "name=subject",
      "Value": ""
    },
    {
      "Command": "type",
      "Target": "name=subject",
      "Value": "Titre⚡️",
      "Targets": [
        "name=subject",
        "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[2]/div/div/div/form/div/div/div/div/div/input",
        "xpath=//input[@name='subject']",
        "xpath=//div/input",
        "css=#container > main > div > section > div > div > div:nth-child(2) > div:nth-child(2) > div > div._3DI7P > div > form > div._13bYy > div > div.zfCs0._3oWkS._2R7h7 > div > div.ZlsP9.aj3_W._1mwQl._3LV9U > input"
      ]
    },
    {
      "Command": "click",
      "Target": "name=body",
      "Value": ""
    },
    {
      "Command": "type",
      "Target": "name=body",
      "Value": "Texte",
      "Targets": [
        "name=body",
        "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[2]/div/div/div/form/div/div/div[2]/div/textarea",
        "xpath=//textarea[@name='body']",
        "xpath=//textarea",
        "css=#container > main > div > section > div > div > div:nth-child(2) > div:nth-child(2) > div > div._3DI7P > div > form > div._13bYy > div > div._3GY3c > div > textarea"
      ]
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[2]/div/div/div/form/div[2]/div/div[2]/button",
      "Value": "",
      "Targets": [
        "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[2]/div/div/div/form/div[2]/div/div[2]/button",
        "xpath=//div/div[2]/button",
        "css=#container > main > div > section > div > div > div:nth-child(2) > div:nth-child(2) > div > div._3DI7P > div > form > div._3lDmP._1MzeB > div > div:nth-child(2) > button"
      ]
    },
    {
      "Command": "click",
      "Target": "name=price",
      "Value": ""
    },
    {
      "Command": "type",
      "Target": "name=price",
      "Value": "32",
      "Targets": [
        "name=price",
        "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[3]/div/div/div/form/div/div/div/div/div/input",
        "xpath=//input[@name='price']",
        "xpath=//div[3]/div/div/div/form/div/div/div/div/div/input",
        "css=#container > main > div > section > div > div > div:nth-child(2) > div:nth-child(3) > div > div._3DI7P > div > form > div._13bYy > div > div > div > div > input"
      ]
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[3]/div/div/div/form/div[2]/div/div[2]/button",
      "Value": "",
      "Targets": [
        "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[3]/div/div/div/form/div[2]/div/div[2]/button",
        "xpath=//div[3]/div/div/div/form/div[2]/div/div[2]/button",
        "css=#container > main > div > section > div > div > div:nth-child(2) > div:nth-child(3) > div > div._3DI7P > div > form > div._3lDmP._1MzeB > div > div:nth-child(2) > button"
      ]
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[4]/div/div/div/div[2]/div/div/div/div/div/div/div",
      "Value": ""
    },
    {
      "Command": "XType",
      "Target": "${KEY_CTRL+KEY_V}",
      "Value": ""
    },
    {
      "Command": "XType",
      "Target": "${KEY_ENTER}",
      "Value": ""
    },
    {
      "Command": "pause",
      "Target": "1700",
      "Value": ""
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[4]/div/div/div/div[3]/div/div[2]/button",
      "Value": "",
      "Targets": [
        "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[4]/div/div/div/div[3]/div/div[2]/button",
        "xpath=//div[3]/div/div[2]/button",
        "css=#container > main > div > section > div > div > div:nth-child(2) > div:nth-child(4) > div > div._3DI7P > div > div.BB7X4.Lcmwl > div > div:nth-child(2) > button"
      ]
    },
    {
      "Command": "click",
      "Target": "id=downshift-0-input",
      "Value": "",
      "Targets": [
        "id=downshift-0-input",
        "name=address",
        "xpath=//*[@id=\"downshift-0-input\"]",
        "xpath=//input[@id='downshift-0-input']",
        "xpath=//div[2]/form/div/div/div/div/div/input",
        "css=#downshift-0-input"
      ]
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[5]/div/div/div/div[2]/form/div/div/div",
      "Value": "",
      "Targets": [
        "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[5]/div/div/div/div[2]/form/div/div/div",
        "xpath=//div[2]/form/div/div/div",
        "css=#container > main > div > section > div > div > div:nth-child(2) > div:nth-child(5) > div > div._3DI7P > div > div:nth-child(2) > form > div._1xhqY > div > div.n0W59"
      ]
    },
    {
      "Command": "type",
      "Target": "id=downshift-0-input",
      "Value": "${!col1}"
    },
    {
      "Command": "XType",
      "Target": "${KEY_ENTER}",
      "Value": ""
    },
    {
      "Command": "pause",
      "Target": "1500",
      "Value": ""
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[5]/div/div/div/div[2]/form/div[2]/div/div[2]/button",
      "Value": "",
      "Targets": [
        "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[5]/div/div/div/div[2]/form/div[2]/div/div[2]/button",
        "xpath=//div[2]/form/div[2]/div/div[2]/button",
        "css=#container > main > div > section > div > div > div:nth-child(2) > div:nth-child(5) > div > div._3DI7P > div > div:nth-child(2) > form > div._4cwig._3z5iR > div > div:nth-child(2) > button"
      ]
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[6]/div/div/div/form/div/div/div[3]/span/div/div/span/div",
      "Value": "",
      "Targets": [
        "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[6]/div/div/div/form/div/div/div[3]/span/div/div/span/div",
        "xpath=//form/div/div/div[3]/span/div/div/span/div",
        "css=#container > main > div > section > div > div > div:nth-child(2) > div._14s_w._3Q1o0 > div._1i0e0._2siHy._38NUf._3aduF > div._3DI7P > div > form > div:nth-child(1) > div > div:nth-child(3) > span > div > div > span > div"
      ]
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[6]/div/div/div/form/div/div/div[3]/span/div/div/span/div",
      "Value": "",
      "Targets": [
        "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[6]/div/div/div/form/div/div/div[3]/span/div/div/span/div",
        "xpath=//form/div/div/div[3]/span/div/div/span/div",
        "css=#container > main > div > section > div > div > div:nth-child(2) > div._14s_w._3Q1o0 > div._1i0e0._2siHy._38NUf._3aduF > div._3DI7P > div > form > div:nth-child(1) > div > div:nth-child(3) > span > div > div > span > div"
      ]
    },
    {
      "Command": "pause",
      "Target": "250",
      "Value": ""
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[6]/div/div/div/form/div[2]/div/div[2]/button",
      "Value": "",
      "Targets": [
        "xpath=//*[@id=\"container\"]/main/div/section/div/div/div[2]/div[6]/div/div/div/form/div[2]/div/div[2]/button",
        "xpath=//div[6]/div/div/div/form/div[2]/div/div[2]/button",
        "css=#container > main > div > section > div > div > div:nth-child(2) > div._14s_w._3Q1o0 > div._1i0e0._2siHy._38NUf._3aduF > div._3DI7P > div > form > div._3lDmP > div > div:nth-child(2) > button"
      ]
    },
    {
      "Command": "click",
      "Target": "xpath=//*[@id=\"container\"]/main/div/div[2]/div/form/button",
      "Value": "",
      "Targets": [
        "xpath=//*[@id=\"container\"]/main/div/div[2]/div/form/button",
        "xpath=//button[@type='submit']",
        "xpath=//button",
        "css=#container > main > div > div:nth-child(3) > div > form > button"
      ]
    }
  ]
}

Move this command

 {
      "Command": "csvRead",
      "Target": "liste.csv",
      "Value": ""
    },

Before the first !COLXXX used in the macro

2 Likes

It works now! Thant you so much!!! :smiley: :partying_face: :kissing_heart:

1 Like