Hi.
I am confused because I have another Macro which runs successfully and it uses a spreadsheet up to 11 columns (link=${!COL11}) - the json is below. In addition as you can see this Macro is successful where I am using the command ‘type’ for csvread of link=${!COL8}. However you have explained the reason for the other Macro failing is because TYPE cannot be used for a dropdown list selection? I have now been experimenting with XTYPE which apppears successful.
Thank you
{
_ “Name”: “CONFIRM_WASTE_EXPRESS_BOOKING”,_
_ “CreationDate”: “2019-2-7”,_
_ “Commands”: [_
_ {_
_ “Command”: “open”,_
_ “Target”: “http://medeformappde00.medway.gov.uk:8080/ufs_dev/LE_BULKYWASTE.eb?ebd=0&ebz=1_1548157566483”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “clickAndWait”,_
_ “Target”: "name=CTRL:142:",
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “clickAt”,_
_ “Target”: "id=CTID-204--A",
_ “Value”: “44,12”_
_ },_
_ {_
_ “Command”: “csvRead”,_
_ “Target”: “customerdata.csv”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “type”,_
_ “Target”: "id=CTID-204--A",
_ “Value”: “${!COL8}”_
_ },_
_ {_
_ “Command”: “clickAndWait”,_
_ “Target”: "name=CTRL:207:",
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “clickAt”,_
_ “Target”: "id=CTID-211--A",
_ “Value”: “426,20”_
_ },_
_ {_
_ “Command”: “csvRead”,_
_ “Target”: “customerdata.csv”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “selectAndWait”,_
_ “Target”: "id=CTID-211--A",
_ “Value”: “label=${!COL3}, ${!COL5}, ${!COL6}, ${!COL7}, ${!COL8}”_
_ },_
_ {_
_ “Command”: “clickAndWait”,_
_ “Target”: "name=CTRL:220:",
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “clickAt”,_
_ “Target”: "id=CTID-222--A",
_ “Value”: “32,11”_
_ },_
_ {_
_ “Command”: “type”,_
_ “Target”: "id=CTID-222--A",
_ “Value”: “Pathway”_
_ },_
_ {_
_ “Command”: “clickAndWait”,_
_ “Target”: "id=CTID-284--A-2",
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “type”,_
_ “Target”: "id=CTID-284--A-2",
_ “Value”: “BCEC”_
_ },_
_ {_
_ “Command”: “clickAndWait”,_
_ “Target”: “name=PAGE:N”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “clickAt”,_
_ “Target”: "id=CTID-311--A",
_ “Value”: “79,19”_
_ },_
_ {_
_ “Command”: “select”,_
_ “Target”: "id=CTID-311--A",
_ “Value”: “label=Mr”_
_ },_
_ {_
_ “Command”: “csvRead”,_
_ “Target”: “customerdata.csv”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “type”,_
_ “Target”: "id=CTID-313--A",
_ “Value”: “${!COL1}”_
_ },_
_ {_
_ “Command”: “type”,_
_ “Target”: "id=CTID-315--A",
_ “Value”: “${!COL2}”_
_ },_
_ {_
_ “Command”: “type”,_
_ “Target”: "id=CTID-320--A",
_ “Value”: “${!COL9}”_
_ },_
_ {_
_ “Command”: “type”,_
_ “Target”: "id=CTID-324--A",
_ “Value”: “${!COL10}”_
_ },_
_ {_
_ “Command”: “click”,_
_ “Target”: "id=CTID-327--A-1",
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “click”,_
_ “Target”: “name=PAGE:N”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “type”,_
_ “Target”: "id=CTID-380--A-3",
_ “Value”: “HB1”_
_ },_
_ {_
_ “Command”: “clickAt”,_
_ “Target”: "id=CTID-380--A-3",
_ “Value”: “4,8”_
_ },_
_ {_
_ “Command”: “type”,_
_ “Target”: "id=CTID-381--A-7",
_ “Value”: “HB15”_
_ },_
_ {_
_ “Command”: “clickAt”,_
_ “Target”: "id=CTID-381--A-7",
_ “Value”: “4,9”_
_ },_
_ {_
_ “Command”: “type”,_
_ “Target”: "id=CTID-382--A-13",
_ “Value”: “HB21”_
_ },_
_ {_
_ “Command”: “clickAt”,_
_ “Target”: "id=CTID-382--A-13",
_ “Value”: “7,6”_
_ },_
_ {_
_ “Command”: “click”,_
_ “Target”: “name=PAGE:N”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “csvRead”,_
_ “Target”: “customerdata.csv”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “clickAndWait”,_
_ “Target”: “link=${!COL11}”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “clickAndWait”,_
_ “Target”: "name=CTRL:1859:",
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “clickAndWait”,_
_ “Target”: “name=PAGE:N”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “clickAndWait”,_
_ “Target”: “id=payButton”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “clickAt”,_
_ “Target”: “id=CardCapturePage_txtCardNumber”,_
_ “Value”: “91,10”_
_ },_
_ {_
_ “Command”: “clickAt”,_
_ “Target”: “id=CardCapturePage_txtCardNumber”,_
_ “Value”: “92,7”_
_ },_
_ {_
_ “Command”: “type”,_
_ “Target”: “id=CardCapturePage_txtCardNumber”,_
_ “Value”: “4715059999000437”_
_ },_
_ {_
_ “Command”: “select”,_
_ “Target”: “id=CardCapturePage_cboEndMonth”,_
_ “Value”: “label=05”_
_ },_
_ {_
_ “Command”: “select”,_
_ “Target”: “id=CardCapturePage_cboEndYear”,_
_ “Value”: “label=2021”_
_ },_
_ {_
_ “Command”: “clickAt”,_
_ “Target”: “id=CardCapturePage_txtSecurityCode”,_
_ “Value”: “18,11”_
_ },_
_ {_
_ “Command”: “type”,_
_ “Target”: “id=CardCapturePage_txtSecurityCode”,_
_ “Value”: “123”_
_ },_
_ {_
_ “Command”: “clickAt”,_
_ “Target”: “id=CardCapturePage_txtName”,_
_ “Value”: “53,10”_
_ },_
_ {_
_ “Command”: “type”,_
_ “Target”: “id=CardCapturePage_txtName”,_
_ “Value”: “Name”_
_ },_
_ {_
_ “Command”: “clickAndWait”,_
_ “Target”: “id=CardCapturePage_btnSubmit”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “waitForPageToLoad”,_
_ “Target”: “”,_
_ “Value”: “3000”_
_ },_
_ {_
_ “Command”: “clickAndWait”,_
_ “Target”: “id=PaymentConfirmation_btnAuth”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “selectFrame”,_
_ “Target”: “index=0”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “click”,_
_ “Target”: “name=customCavv”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “type”,_
_ “Target”: “name=customCavv”,_
_ “Value”: “123”_
_ },_
_ {_
_ “Command”: “clickAndWait”,_
_ “Target”: “//*[@id="ContainerContent"]/center/form/table/tbody/tr[13]/td/input”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “selectFrame”,_
_ “Target”: “relative=top”,_
_ “Value”: “”_
_ },_
_ {_
_ “Command”: “waitForPageToLoad”,_
_ “Target”: “”,_
_ “Value”: “3000”_
_ },_
_ {_
_ “Command”: “clickAndWait”,_
_ “Target”: "name=CTRL:66:",
_ “Value”: “”_
_ }_
_ ]_
}