I’m very new to UI Vision and Jason code. I need to read a csv or excel line by line into a website then capture data from five different locations on the website and write each location to a different column in either csv or excel file. I can’t provide the actual website so I’m using Thesaurus, capturing the first word in each change of words. I’ve tried to copy the code from this site While, do... repeat if - the best option? but it is not working for me. Can someone point me in the direction on how to do this? Thanks so much.
{
“Name”: “FileName”,
“CreationDate”: “2023-8-25”,
“Commands”: [
{
“Command”: “csvRead”,
“Target”: “"C:\Users\EmployeeID\Downloads\NIR"”,
“Value”: “csvValue”,
“Description”: “”
},
{
“Command”: “echo”,
“Target”: “"Status = {!csvReadStatus}, line = {!csvReadLineNumber}”,”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “while”,
“Target”: ““”{!csvReadStatus}\" == \"OK\"", "Value": "" }, { "Command": "echo", "Target": "Status = {!csvReadStatus}, line = {!csvReadLineNumber}", "Value": "" }, { "Command": "comment", "Target": "{!csvReadLineNumber}+1",”,
“Value”: “"!csvReadLineNumber"”,
“Description”: “”
},
{
“Command”: “open”,
“Target”: "https://www.thesaurus.com ",
“Value”: “”,
“Description”: “”
},
{
“Command”: “clickAndWait”,
“Target”: “linkText=global-search”,
“Value”: “”,
“Targets”: [
“linkText=global-search”,
“xpath=//[@id=“root”]/div/header/form/div/div/button",
],
“Description”: “”
},
{
“Command”: “type”,
“Target”: “id=global-search”,
“Value”: “{!csvValue}”,
“Description”: “”
},
{
“Command”: “click”,
“Target”: “id=mainForm:j_id_32”,
“Value”: “”,
“Targets”: [
“id=mainForm:j_id_32”,
“name=mainForm:j_id_32”,
"xpath=//[@id="mainForm:j_id_32"]”,
“xpath=//input[@id=‘mainForm:j_id_32’]”,
“xpath=//div[2]/input”,
“css=#mainForm:j_id_32”
],
“Description”: “”
},
{
“Command”: “type”,
“Target”: “"id=nirName"”,
“Value”: ““{!COL1}" }, { "Command": "click", "Target": "xpath=//[@id=\"setaDir\"]/img", "Value": "" }, { "Command": "storeEval", "Target": "{!csvReadLineNumber}+1”, "!csvReadLineNumber"",
“Description”: “”
},
{
“Command”: “click”,
“Target”: "xpath=//[@id="mainForm"]/table/tbody/tr/td/p”,
“Value”: “”,
“Targets”: [
“xpath=//[@id="mainForm"]/table/tbody/tr/td/p",
“xpath=//td/p”,
“css=#mainForm > table > tbody > tr:nth-child(1) > td > p”
],
“Description”: “”
},
{
“Command”: “click”,
“Target”: "xpath=//[@id="mainForm"]/table/tbody/tr/td”,
“Value”: “”,
“Targets”: [
“xpath=//[@id="mainForm"]/table/tbody/tr/td",
“xpath=//td”,
“css=#mainForm > table > tbody > tr:nth-child(1) > td”
],
“Description”: “”
},
{
“Command”: “selectWindow”,
“Target”: “tab=-2”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “click”,
“Target”: "xpath=//[@id="post_1"]/div/div[2]/div[2]/div/p[3]”,
“Value”: “”,
“Targets”: [
“xpath=//[@id="post_1"]/div/div[2]/div[2]/div/p[3]",
“xpath=//div[2]/div/p[3]”,
“css=#post_1 > div > div.topic-body.clearfix > div.regular.contents > div > p:nth-child(3)”
],
“Description”: “”
},
{
“Command”: “click”,
“Target”: "xpath=//[@id="post_1"]/div/div[2]/div[2]/div/p[3]”,
“Value”: “”,
“Targets”: [
“xpath=//[@id="post_1"]/div/div[2]/div[2]/div/p[3]",
“xpath=//div[2]/div/p[3]”,
“css=#post_1 > div > div.topic-body.clearfix > div.regular.contents > div > p:nth-child(3)”
],
“Description”: “”
},
{
“Command”: “store”,
“Target”: “true”,
“Value”: “!errorIgnore”,
“Description”: “”
},
{
“Command”: “click”,
“Target”: "xpath=//[@id="post_1"]/div/div[2]/div[2]/div/p[3]”,
“Value”: “”,
“Targets”: [
“xpath=//*[@id="post_1"]/div/div[2]/div[2]/div/p[3]”,
“xpath=//div[2]/div/p[3]”,
“css=#post_1 > div > div.topic-body.clearfix > div.regular.contents > div > p:nth-child(3)”
],
“Description”: “”
},
{
“Command”: “echo”,
“Target”: “"Reading CSV line No. ${!csvReadLineRnumber}"”,
“Value”: “!errorIgnore”,
“Description”: “”
},
{
“Command”: “csvRead”,
“Target”: “C:\My Documents\UI_Vision\NIR”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “store”,
“Target”: “false”,
“Value”: “!errorIgnore”,
“Description”: “”
},
{
“Command”: “end”,
“Target”: “”,
“Value”: “”,
“Description”: “”
}
]
}