akkash
1
Hi , I;m trying to loop read csv and open links stating from raw 50 then do action and do same to 51,52,53…extra
, the problem is when start loop it keep doing the action for the line 50 how to make it work like 50, 51 ,52 … extra
{
“Command”: “store”,
“Target”: “50”,
“Value”: “!csvReadLineNumber”
},
{
“Command”: “csvRead”,
“Target”: “jemmy-grey.csv”,
“Value”: “”
},
{
“Command”: “open”,
“Target”: “${!col1}”,
“Value”: “”
},
admin
2
Use a loop, see How to make macro pause not stop after xx loop - #2 by admin
Or, more advanced, mark the rows in the CSV file that are already processed:
akkash
3
Hi , used ${!loop} but not work it started to read from the first line not line number 50
{
“Name”: “bears”,
“CreationDate”: “2021-3-25”,
“Commands”: [
{
“Command”: “store”,
“Target”: “{!loop}",
"Value": "!csvReadLineNumber"
},
{
"Command": "store",
"Target": "50",
"Value": "!csvReadLineNumber"
},
{
"Command": "csvRead",
"Target": "6.csv",
"Value": ""
},
{
"Command": "open",
"Target": "{!col1}”,
“Value”: “”
},
{
“Command”: “clickAndWait”,
“Target”: “xpath=//[@id=“PWS_ROOT”]/div/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div/div/div/div/div[2]",
“Value”: “3000”,
“Targets”: [
"xpath=//[@id=“PWS_ROOT”]/div/div[2]/div/div/div/div/div/div/div/div[2]/div/div/div/div/div/div/div/div/div[2]”,
“xpath=//div[2]/div/div/div/div/div/div/div/div/div[2]”,
“css=#PWS_ROOT > div.App.AppBase > div.appContent > div > div > div > div > div > div > div > div:nth-child(2) > div > div > div > div.XbT.zI7.iyn.Hsu > div > div > div > div > div.Jea.b8T.gjz.ujU.zI7.iyn.Hsu”
]
}
]
}
You must create a custom loop
This is an example with random line, change with your prefered line number