Need to automate a form filing with 2 text files

Ui.Vision
,
1

hello
im new to ui vision, i have used imacros few years back but forgot how to code the automation. i recently needed to file some forms and got to know about UI Vision. i want to know if anyone can help me code this project

so i have file A and file B
i need to visit a url which will allow me to fill a form
i want to use my file A & B as data for column A & B respectively

example
visit url
put content of column a with file A first line
than put content of column b with file B first line
then hit submit
loop to redo same process again with next line
so if have 10 lines, it should read file A and B same lines for that number of attempt meaning on 7th time after opening url it should read line 7 of file A in column a and line 7 of file B in column b and and hit submit

can i do that? pls help.
thanks

2

Hi, do you have an iMacros macro that does this task? Or this is a new project?

If you already have an imacros macro, just post it here (plus ideally a video of the macro running) and some of us here can give hints to to best convert it to Ui.vision macros.

3

thankyou for your reply. unfortunately i dont have anything made yet. i tried with imacro but i was unsuccessful and got to know its no longer active so no support available from forums.
if you can give me a sample, i can change the url and other details for it to work and report back if any issue arises.
thanks

4

Hi, I recommend these two macros to get started. They show to extract values from a website and how to read data from CSV files (a text file like you mentioned is simply a CSV file with only one column):

image
image678×923 123 KB

1 Like
5

ill see to it and report back

thanks

6

clearly this is way harder than imacros

here is my code. i made list.csv for my data a & b

{
“Name”: “form”,
“CreationDate”: “2024-10-25”,
“Commands”: [
{
“Command”: “open”,
“Target”: “https://url.form”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “csvRead”,
“Target”: “list.csv”,
“Value”: “”,
“Description”: “”
},
{
“Command”: “type”,
“Target”: “id=:r0:”,
“Value”: “list.csv”,
“Targets”: [
“id=:r0:”,
“name=optionA”,
“xpath=//[@id=":r0:"]",
“xpath=//input[@id=‘:r0:’]”,
“xpath=//input”,
“css=#:r0:”
],
“Description”: “”
},
{
“Command”: “type”,
“Target”: “id=:r1:”,
“Value”: “list.csv”,
“Targets”: [
“id=:r1:”,
“name=optionB”,
"xpath=//[@id=":r1:"]”,
“xpath=//input[@id=‘:r1:’]”,
“xpath=//div[3]/div/input”,
“css=#:r1:”
],
“Description”: “”
},
{
“Command”: “click”,
“Target”: “id=:r2:”,
“Value”: “”,
“Targets”: [
“id=:r2:”,
“xpath=//*[@id=":r2:"]”,
“xpath=//button[@id=‘:r2:’]”,
“xpath=//form/button”,
“css=#:r2:”
],
“Description”: “”
},
{
“Command”: “clickAndWait”,
“Target”: “5”,
“Value”: “”,
“Description”: “”
}
]
}

im not able to use my data which is option1,option2 setting on my option a and option in the form.