Hello all,
Just a heads up, I had this whole macro previously automated in UIPath, but due to licensing issues (too expensive) I’m transferring over to UIVision. So far, I really like the client. There are a few differences, but overall it seems fairly straight forward.
I’ll also note that I’m definitely not an expert. So please excuse any simple issues.
Now, for my code: I’m trying to create a webform macro where I read an Excel CSV with rounding areas, and input it into my company’s ticketing suite. COL1 is my building, COL2 is the department, and COL3 is my tech’s name. I’ve already built the routine, but I can’t seem to get the macro to read from my CSV. I keep getting error logs:
[Line 11] Internal variable “!COL1” not supported, etc, so my best guess is that i’ve not stored the CSV in a datatable or variable properly.
So thats issue 1, issue 2 is getting the macro to repeat ForEachRow of the CSV.
See my code below. Thanks again for any help!
{
"Name": "TicketSub",
"CreationDate": "2022-3-24",
"Commands": [
{
"Command": "csvRead",
"Target": "Rounding List Ryan.csv",
"Value": "",
"Description": ""
},
{
"Command": "click",
"Target": "linkText=Create New",
"Value": "",
"Description": ""
},
{
"Command": "click",
"Target": "xpath=/html/body/div[2]/div/div/div/div[2]/div[4]/div/ul/li[3]/a/span[2]",
"Value": "",
"Description": ""
},
{
"Command": "click",
"Target": "xpath=//*[@id=\"main\"]/div/div/div[2]/div[2]/div/div/div/div/div/div/div/div/div[3]/input",
"Value": "",
"Description": ""
},
{
"Command": "type",
"Target": "xpath=//*[@id=\"main\"]/div/div/div[2]/div[2]/div/div/div/div/div/div/div/div/div[3]/input",
"Value": "Frank Mauro",
"Description": ""
},
{
"Command": "pause",
"Target": "3000",
"Value": "",
"Description": ""
},
{
"Command": "XClickRelative",
"Target": "rhslfo_dpi_96.png",
"Value": "",
"Description": "Select Customer Name"
},
{
"Command": "click",
"Target": "xpath=//*[@id=\"main\"]/div/div/div[2]/div[2]/div/div/div[2]/div/div/div/div/div/div/button",
"Value": "",
"Description": "Browse All Templates"
},
{
"Command": "click",
"Target": "xpath=/html/body/div[4]/div/div/div/div[2]/div[2]/div/input",
"Value": "",
"Description": ""
},
{
"Command": "pause",
"Target": "10000",
"Value": "",
"Description": ""
},
{
"Command": "type",
"Target": "xpath=/html/body/div[4]/div/div/div/div[2]/div[2]/div/input",
"Value": "${!COL1}",
"Description": "Rounding Location"
},
{
"Command": "pause",
"Target": "3000",
"Value": "",
"Description": ""
},
{
"Command": "click",
"Target": "xpath=/html/body/div[4]/div/div/div/div[3]/div/button",
"Value": "",
"Description": ""
},
{
"Command": "type",
"Target": "name=summary",
"Value": "${!COL2}",
"Description": "Department name"
},
{
"Command": "click",
"Target": "xpath=//*[@id=\"main\"]/div/div/div[2]/div[2]/div[4]/div/div/div/div/div/div[2]/label/span[2]",
"Value": "",
"Description": ""
},
{
"Command": "click",
"Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div/assignee-chooser/div[2]/div[5]/label/div/input",
"Value": "",
"Description": ""
},
{
"Command": "type",
"Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div/assignee-chooser/div[2]/div[5]/label/div/input",
"Value": "${!COL3}",
"Description": ""
},
{
"Command": "click",
"Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div/assignee-chooser/div[3]/div/div/div[2]/div/div[3]/span[2]",
"Value": "",
"Description": ""
},
{
"Command": "click",
"Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div/assignee-chooser/div[3]/div[3]/div/div[2]",
"Value": "",
"Description": ""
},
{
"Command": "click",
"Target": "xpath=/html/body/div[4]/div/div/div/div/div/button",
"Value": "",
"Description": ""
},
{
"Command": "click",
"Target": "xpath=//*[@id=\"main\"]/div/div/div[2]/div[2]/div[4]/div[3]/div/div/div/div/div[2]/label/span[2]",
"Value": "",
"Description": ""
},
{
"Command": "click",
"Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div[2]/assignee-chooser/div[2]/div[5]/label/div/input",
"Value": "",
"Description": ""
},
{
"Command": "type",
"Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div[2]/assignee-chooser/div[2]/div[5]/label/div/input",
"Value": "frank mauro",
"Description": ""
},
{
"Command": "click",
"Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div[2]/assignee-chooser/div[3]/div/div/div[2]/div/div/div",
"Value": "",
"Description": ""
},
{
"Command": "click",
"Target": "xpath=/html/body/div[4]/div/div/div/form/div[2]/div[2]/div/div[2]/assignee-chooser/div[3]/div[2]/div/div[2]",
"Value": "",
"Description": ""
},
{
"Command": "click",
"Target": "xpath=/html/body/div[4]/div/div/div/div/div/button",
"Value": "",
"Description": ""
},
{
"Command": "click",
"Target": "xpath=//*[@id=\"main\"]/div/div[2]/div/button",
"Value": "",
"Description": ""
},
{
"Command": "pause",
"Target": "3000",
"Value": "",
"Description": ""
}
]
}