so i made a working script where it opens up a page, uses option 1 & 2 from .csv file and submit, afterwards it loops and does the same thing again. everything is perfect till here.
just 1 problem that it does not use row 2 from try number 2
so for example row one option 1 & 2 is orange & fruit respectively, row 2 option 1 & 2 being carrot and vegetable. but when i run the script, even if it loops 10 times it will keep on posting orange and fruit rather trying 20 more entries of that .csv file
sharing my simple code here if anyone can identify the problem and fix my issue so i can try on loop and data entered be from next line on consecutive tries.
thankyou
{
"Name": "document",
"CreationDate": "2024-12-10",
"Commands": [
{
"Command": "store",
"Target": "danny.csv",
"Value": "csvFile",
"Description": ""
},
{
"Command": "csvRead",
"Target": "${csvFile}",
"Value": "",
"Description": ""
},
{
"Command": "while",
"Target": "${!csvReadStatus} == \"OK\"",
"Value": "",
"Description": "Loop through CSV rows"
},
{
"Command": "open",
"Target": "MY URL",
"Value": "",
"Description": ""
},
{
"Command": "type",
"Target": "name=Option1",
"Value": "${!COL1}",
"Description": ""
},
{
"Command": "type",
"Target": "name=Option2",
"Value": "${!COL2}",
"Description": ""
},
{
"Command": "click",
"Target": "xpath=//button[@type='submit']",
"Value": "",
"Description": ""
},
{
"Command": "pause",
"Target": "2000",
"Value": "",
"Description": ""
},
{
"Command": "csvRead",
"Target": "${csvFile}",
"Value": "",
"Description": "Read next row"
},
{
"Command": "endWhile",
"Target": "",
"Value": "",
"Description": ""
}