Hello everyone,
I am trying to automate a web process where I go to a website take input from csv file and if I was able to update the record I write it to a csv file.
The macro runs fine, but once in a while, I get timeout errors with because of mainly click buttons. Is there a way to fix time out errors?
Here is my code. The timeouts occur because of click actions inside loop.
{
“Name”: “TeamsUpdateRevise”,
“CreationDate”: “2020-8-21”,
“Commands”: [
{
"Command": "comment",
"Target": "store // 30",
"Value": "!timeout_wait"
},
{
"Command": "open",
"Target": "https://home-c27.incontact.com/inContact/Login.aspx?ReturnUrl=%2f",
"Value": ""
},
{
"Command": "click",
"Target": "xpath=//*[@id=\"logo\"]/div",
"Value": "",
"Targets": [
"xpath=//*[@id=\"logo\"]/div",
"xpath=//div[3]/div/div/div",
"css=#logo > div"
]
},
{
"Command": "click",
"Target": "id=ctl00_BaseContent_msl_txtUsername",
"Value": "",
"Targets": [
"id=ctl00_BaseContent_msl_txtUsername",
"name=ctl00$BaseContent$msl_txtUsername",
"xpath=//*[@id=\"ctl00_BaseContent_msl_txtUsername\"]",
"xpath=//input[@id='ctl00_BaseContent_msl_txtUsername']",
"xpath=//div[3]/input",
"css=#ctl00_BaseContent_msl_txtUsername"
]
},
{
"Command": "click",
"Target": "id=ctl00_BaseContent_msl_txtUsername",
"Value": "",
"Targets": [
"id=ctl00_BaseContent_msl_txtUsername",
"name=ctl00$BaseContent$msl_txtUsername",
"xpath=//*[@id=\"ctl00_BaseContent_msl_txtUsername\"]",
"xpath=//input[@id='ctl00_BaseContent_msl_txtUsername']",
"xpath=//div[3]/input",
"css=#ctl00_BaseContent_msl_txtUsername"
]
},
{
"Command": "type",
"Target": "id=ctl00_BaseContent_msl_txtUsername",
"Value": "abc@yahoo.com",
"Targets": [
"id=ctl00_BaseContent_msl_txtUsername",
"name=ctl00$BaseContent$msl_txtUsername",
"xpath=//*[@id=\"ctl00_BaseContent_msl_txtUsername\"]",
"xpath=//input[@id='ctl00_BaseContent_msl_txtUsername']",
"xpath=//div[3]/input",
"css=#ctl00_BaseContent_msl_txtUsername"
]
},
{
"Command": "click",
"Target": "id=ctl00_BaseContent_btnNext",
"Value": "",
"Targets": [
"id=ctl00_BaseContent_btnNext",
"name=ctl00$BaseContent$btnNext",
"xpath=//*[@id=\"ctl00_BaseContent_btnNext\"]",
"xpath=//input[@id='ctl00_BaseContent_btnNext']",
"xpath=//div[2]/div/input",
"css=#ctl00_BaseContent_btnNext"
]
},
{
"Command": "type",
"Target": "id=ctl00_BaseContent_mslp_tbxPassword",
"Value": "Helloworld",
"Targets": [
"id=ctl00_BaseContent_mslp_tbxPassword",
"name=ctl00$BaseContent$mslp_tbxPassword",
"xpath=//*[@id=\"ctl00_BaseContent_mslp_tbxPassword\"]",
"xpath=//input[@id='ctl00_BaseContent_mslp_tbxPassword']",
"xpath=//div[4]/input",
"css=#ctl00_BaseContent_mslp_tbxPassword"
]
},
{
"Command": "click",
"Target": "id=ctl00_BaseContent_mslp_btnLogin",
"Value": "",
"Targets": [
"id=ctl00_BaseContent_mslp_btnLogin",
"name=ctl00$BaseContent$mslp_btnLogin",
"xpath=//*[@id=\"ctl00_BaseContent_mslp_btnLogin\"]",
"xpath=//input[@id='ctl00_BaseContent_mslp_btnLogin']",
"xpath=//div[2]/div[2]/input",
"css=#ctl00_BaseContent_mslp_btnLogin"
]
},
{
"Command": "click",
"Target": "linkText=REPORTING",
"Value": "",
"Targets": [
"linkText=REPORTING",
"id=module-picker-link",
"xpath=//*[@id=\"module-picker-link\"]",
"xpath=//a[@id='module-picker-link']",
"xpath=//module-picker/a",
"css=#module-picker-link"
]
},
{
"Command": "clickAndWait",
"Target": "css=#admin-icon-svg > path:nth-child(14)",
"Value": "",
"Targets": [
"xpath=//*[@id=\"admin-icon-svg\"]/path[8]",
"css=#admin-icon-svg > path:nth-child(14)"
]
},
{
"Command": "open",
"Target": "https://home-c27.incontact.com/inContact/Manage/Users/UserList.aspx",
"Value": ""
},
{
"Command": "pause",
"Target": "2000",
"Value": ""
},
{
"Command": "comment",
"Target": "label // moveOn",
"Value": ""
},
{
"Command": "comment",
"Target": "label // moveOn",
"Value": ""
},
{
"Command": "csvReadArray",
"Target": "row.csv",
"Value": "rowArray"
},
{
"Command": "executeScript",
"Target": "return Number(${!CsvReadMaxRow} -1)",
"Value": "rowLast"
},
{
"Command": "echo",
"Target": "${rowLast}",
"Value": ""
},
{
"Command": "executeScript",
"Target": "return Number(${rowArray[${rowLast}][0]})",
"Value": "row"
},
{
"Command": "comment",
"Target": "open // https://home-c27.incontact.com/inContact/Default.aspx",
"Value": ""
},
{
"Command": "csvRead",
"Target": "data_ids.csv",
"Value": ""
},
{
"Command": "echo",
"Target": "${!CSVREADMAXROW}",
"Value": ""
},
{
"Command": "echo",
"Target": "${row}",
"Value": ""
},
{
"Command": "while_v2",
"Target": "${row} <= ${!CSVREADMAXROW}",
"Value": ""
},
{
"Command": "store",
"Target": "${row}",
"Value": "!CSVREADLINENUMBER"
},
{
"Command": "csvRead",
"Target": "data_ids.csv",
"Value": ""
},
{
"Command": "click",
"Target": "//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_agvsUser_tbxSearchText\"]",
"Value": ""
},
{
"Command": "type",
"Target": "//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_agvsUser_tbxSearchText\"]",
"Value": "${!COL1}"
},
{
"Command": "click",
"Target": "//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_agvsUser_btnSearch\"]",
"Value": ""
},
{
"Command": "pause",
"Target": "3000",
"Value": ""
},
{
"Command": "store",
"Target": "3",
"Value": "!timeout_wait"
},
{
"Command": "store",
"Target": "true",
"Value": "!errorignore"
},
{
"Command": "comment",
"Target": "verifyElementNotPresent // //*[text()[contains(.,'No Entries Found')]]",
"Value": ""
},
{
"Command": "storeText",
"Target": "/html/body/div[2]/form/div[5]/div/div/div/div[1]/div[2]/div/div[2]/div/table/tbody/tr/td/div/div",
"Value": "noEntry"
},
{
"Command": "comment",
"Target": "echo // ${noEntry}",
"Value": ""
},
{
"Command": "store",
"Target": "false",
"Value": "!errorignore"
},
{
"Command": "comment",
"Target": "assertText // //*[text()[contains(.,'No Entries Found')]]",
"Value": ""
},
{
"Command": "comment",
"Target": "gotoIf_v2 // ${noEntry} == No Entries Found",
"Value": "nextIteration"
},
{
"Command": "comment",
"Target": "if_v2 // ${noEntry} == \"No Entries Found\"",
"Value": ""
},
{
"Command": "gotoIf_v2",
"Target": "${noEntry} == \"No Entries Found\"",
"Value": "nextIteration"
},
{
"Command": "comment",
"Target": "end // ",
"Value": ""
},
{
"Command": "click",
"Target": "/html/body/div[2]/form/div[5]/div/div/div/div[1]/div[2]/div/div[2]/div/table/tbody/tr[2]/td[4]",
"Value": "",
"Targets": [
"xpath=//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_agvsUser_gridView\"]/tbody/tr[2]/td[4]",
"xpath=//td[4]",
"css=#ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_agvsUser_gridView > tbody > tr.gridAlternatingRowWithHoverClass > td:nth-child(4)"
]
},
{
"Command": "storeText",
"Target": "//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcUserDetails_tpnlUserDetails_ctrlUserDetails_lblUserName\"]",
"Value": "userName"
},
{
"Command": "comment",
"Target": "echo // username = ${userName}",
"Value": "userName"
},
{
"Command": "click",
"Target": "linkText=Teams",
"Value": "",
"Targets": [
"linkText=Teams",
"id=TeamList",
"xpath=//*[@id=\"TeamList\"]",
"xpath=//a[@id='TeamList']",
"xpath=//div[2]/ul/li[2]/a",
"css=#TeamList"
]
},
{
"Command": "pause",
"Target": "3000",
"Value": ""
},
{
"Command": "click",
"Target": "//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_agvsTeams_tbxSearchText\"]",
"Value": "",
"Targets": [
"xpath=//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_agvsTeams_gridView\"]/tbody/tr[4]/td[2]",
"xpath=//tr[4]/td[2]",
"css=#ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_agvsTeams_gridView > tbody > tr:nth-child(4) > td.nameColumnExtraWidth"
]
},
{
"Command": "type",
"Target": "//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_agvsTeams_tbxSearchText\"]",
"Value": "${!COL2}",
"Targets": [
"xpath=//*[@id=\"__tab_ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents\"]/span",
"xpath=//span[3]/span/span/a/span",
"css=#__tab_ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents > span"
]
},
{
"Command": "click",
"Target": "//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_agvsTeams_btnSearch\"]",
"Value": "",
"Targets": [
"xpath=//*[@id=\"__tab_ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents\"]/span",
"xpath=//span[3]/span/span/a/span",
"css=#__tab_ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents > span"
]
},
{
"Command": "pause",
"Target": "3000",
"Value": ""
},
{
"Command": "comment",
"Target": "click // //*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_agvsTeams_btnSearch\"]",
"Value": ""
},
{
"Command": "store",
"Target": "true",
"Value": "!errorignore"
},
{
"Command": "storeText",
"Target": "/html/body/div[2]/form/div[5]/div/div/div/div[1]/div/div[2]/div/div[2]/div/table/tbody/tr/td/div/div/p",
"Value": "teamName"
},
{
"Command": "store",
"Target": "false",
"Value": "!errorignore"
},
{
"Command": "pause",
"Target": "1000",
"Value": ""
},
{
"Command": "gotoIf_v2",
"Target": "${teamName} == \"No Entries Found\"",
"Value": "nextIteration"
},
{
"Command": "click",
"Target": "/html/body/div[2]/form/div[5]/div/div/div/div[1]/div/div[2]/div/div[2]/div/table/tbody/tr[2]/td[2]",
"Value": "",
"Targets": [
"id=ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria",
"name=ctl00$ctl00$ctl00$BaseContent$Content$ManagerContent$tcTeam$tpnlAgents$ctrlTeamAgentDetails$gsUnassigned$tbSearchCriteria",
"xpath=//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria\"]",
"xpath=//input[@id='ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria']",
"xpath=//label/input",
"css=#ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria"
]
},
{
"Command": "comment",
"Target": "click // /html/body/div[2]/form/div[5]/div/div/div/div[1]/div/div[2]/div[1]/span[3]/span/span/a/span",
"Value": ""
},
{
"Command": "click",
"Target": "/html/body/div[2]/form/div[5]/div/div/div/div[1]/div/div[2]/div[1]/span[3]/span/span/a/span",
"Value": "",
"Targets": [
"id=ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria",
"name=ctl00$ctl00$ctl00$BaseContent$Content$ManagerContent$tcTeam$tpnlAgents$ctrlTeamAgentDetails$gsUnassigned$tbSearchCriteria",
"xpath=//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria\"]",
"xpath=//input[@id='ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria']",
"xpath=//label/input",
"css=#ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria"
]
},
{
"Command": "click",
"Target": "//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria\"]",
"Value": "",
"Targets": [
"id=ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria",
"name=ctl00$ctl00$ctl00$BaseContent$Content$ManagerContent$tcTeam$tpnlAgents$ctrlTeamAgentDetails$gsUnassigned$tbSearchCriteria",
"xpath=//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria\"]",
"xpath=//input[@id='ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria']",
"xpath=//label/input",
"css=#ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria"
]
},
{
"Command": "type",
"Target": "id=ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria",
"Value": " ${userName}",
"Targets": [
"id=ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria",
"name=ctl00$ctl00$ctl00$BaseContent$Content$ManagerContent$tcTeam$tpnlAgents$ctrlTeamAgentDetails$gsUnassigned$tbSearchCriteria",
"xpath=//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria\"]",
"xpath=//input[@id='ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria']",
"xpath=//label/input",
"css=#ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_tbSearchCriteria"
]
},
{
"Command": "click",
"Target": "css=#ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_btnSearch_ShadowButton > div > svg",
"Value": "",
"Targets": [
"xpath=//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_btnSearch_ShadowButton\"]/div/svg",
"css=#ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_btnSearch_ShadowButton > div > svg"
]
},
{
"Command": "pause",
"Target": "2000",
"Value": ""
},
{
"Command": "store",
"Target": "3",
"Value": "!timeout_wait"
},
{
"Command": "comment",
"Target": "store // true",
"Value": "!errorignore"
},
{
"Command": "comment",
"Target": "verifyElementNotPresent // //*[text()[contains(.,'No Entries Found')]]",
"Value": ""
},
{
"Command": "comment",
"Target": "store // false",
"Value": "!errorignore"
},
{
"Command": "store",
"Target": "true",
"Value": "!errorignore"
},
{
"Command": "storeText",
"Target": "/html/body/div[2]/form/div[5]/div/div/div/div[1]/div/div[2]/div[2]/div[3]/div/div[9]/div/div/table/tbody/tr/td/div/div/p",
"Value": "noEntryUser"
},
{
"Command": "store",
"Target": "false",
"Value": "!errorignore"
},
{
"Command": "gotoIf_v2",
"Target": "${noEntryUser} == \"No Entries Found\"",
"Value": "nextIteration"
},
{
"Command": "comment",
"Target": "store // false",
"Value": "!errorignore"
},
{
"Command": "click",
"Target": "//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gvUnassigned_ctl02_cbSelectRow\"]",
"Value": "",
"Targets": [
"xpath=//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_btnSearch_ShadowButton\"]/div/svg",
"css=#ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_btnSearch_ShadowButton > div > svg"
]
},
{
"Command": "click",
"Target": "//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_btnAddUsers_ShadowButtonSpan\"]",
"Value": ""
},
{
"Command": "click",
"Target": "/html/body/div[2]/form/div[4]/div/main/sidebar/div/div/div[2]/ul/li[1]/a/span[2]",
"Value": "",
"Targets": [
"xpath=//*[@id=\"ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_btnSearch_ShadowButton\"]/div/svg",
"css=#ctl00_ctl00_ctl00_BaseContent_Content_ManagerContent_tcTeam_tpnlAgents_ctrlTeamAgentDetails_gsUnassigned_btnSearch_ShadowButton > div > svg"
]
},
{
"Command": "store",
"Target": "${!COL1}",
"Value": "!csvLine"
},
{
"Command": "store",
"Target": "${!COL2}",
"Value": "!csvLine"
},
{
"Command": "store",
"Target": "${!COL3}",
"Value": "!csvLine"
},
{
"Command": "store",
"Target": "${!COL4}",
"Value": "!csvLine"
},
{
"Command": "store",
"Target": "${!COL5}",
"Value": "!csvLine"
},
{
"Command": "store",
"Target": "${!COL6}",
"Value": "!csvLine"
},
{
"Command": "store",
"Target": "${!COL7}",
"Value": "!csvLine"
},
{
"Command": "store",
"Target": "${!COL8}",
"Value": "!csvLine"
},
{
"Command": "csvSave",
"Target": "insertedValues.csv",
"Value": ""
},
{
"Command": "label",
"Target": "nextIteration",
"Value": ""
},
{
"Command": "executeScript",
"Target": "return Number(${row} + 1)",
"Value": "currRow"
},
{
"Command": "store",
"Target": "$currRow",
"Value": "!CSVLINE"
},
{
"Command": "csvSave",
"Target": "row.csv",
"Value": ""
},
{
"Command": "executeScript",
"Target": "return ${row} + 1",
"Value": "row"
},
{
"Command": "pause",
"Target": "1000",
"Value": ""
},
{
"Command": "click",
"Target": "/html/body/div[2]/form/div[4]/div/main/sidebar/div/div/div[2]/ul/li[1]/a/span[2]",
"Value": "row"
},
{
"Command": "pause",
"Target": "1000",
"Value": ""
},
{
"Command": "comment",
"Target": "store // false",
"Value": "!errorIgnore"
},
{
"Command": "end",
"Target": "",
"Value": ""
},
{
"Command": "comment",
"Target": "csvSave // insertedValues",
"Value": ""
},
{
"Command": "",
"Target": "",
"Value": ""
},
{
"Command": "comment",
"Target": "refresh // // ",
"Value": ""
}
]
}