Please help me - Menu updating for a webpage

Please help me to create a script, I have a recurring data entry task, so with the help of UI.vision
I want to auto-fill the webpage from the excel sheet. but I can’t write a script. can u help me to write a script to read series of data in a row and fill the webpage and it should loop each rows. one more point is there is a field in the webpage where I have to click the end key in the keyboard to select an option. I will attach a script where I have recorded the task. can u help me modify the script so that the task will be automated?
{
“Command”: “click”,
“Target”: “id=meal-name”,
“Value”: “”
},
{
“Command”: “click”,
“Target”: “id=meal-name”,
“Value”: “”
},
{
“Command”: “type”,
“Target”: “id=meal-name”,
“Value”: “meal name”
},
{
“Command”: “click”,
“Target”: “id=meal-description”,
“Value”: “”
},
{
“Command”: “click”,
“Target”: “xpath=//[@id=“Meal”]/div/div[2]",
“Value”: “”
},
{
“Command”: “click”,
“Target”: “id=meal-meal_category_id”,
“Value”: “”
},
{
“Command”: “select”,
“Target”: “id=meal-meal_category_id”,
“Value”: “label=SIDES - restaurant name”
},
{
“Command”: “click”,
“Target”: “id=meal-meal_category_id”,
“Value”: “”
},
{
“Command”: “click”,
“Target”: “id=meal-enabled”,
“Value”: “”
},
{
“Command”: “type”,
“Target”: “id=meal-enabled”,
“Value”: “1”
},
{
“Command”: “click”,
“Target”: “id=meal-quantity_unit”,
“Value”: “”
},
{
“Command”: “type”,
“Target”: “id=meal-quantity_unit”,
“Value”: “Number”
},
{
“Command”: “click”,
“Target”: "xpath=//
[@id=“Meal”]/div/div[6]”,
“Value”: “”
},
{
“Command”: “click”,
“Target”: “id=meal-position”,
“Value”: “”
},
{
“Command”: “type”,
“Target”: “id=meal-position”,
“Value”: “5”
},
{
“Command”: “click”,
“Target”: “xpath=//*[@id=“Meal”]/div/h3[1]”,
“Value”: “”
},
{
“Command”: “click”,
“Target”: “id=save-Meal”,
“Value”: “”
},
{
“Command”: “click”,
“Target”: “”,
“Value”: “”
},
{
“Command”: “”,
“Target”: “”,
“Value”: “”
}
]
}

Paste here url of website with form and the csv with data to use.

sorry i cant share the URL it is password protected. can i send You the screenshot of the webpage and the csv file with three rows to fill in the form.

Without the url i can not store the xpath of every field

study this guide and create the macro yourself

https://ui.vision/rpa/docs/selenium-ide/csvread

can u help me if I provide the screenshot? because the URL is password protected once u login I will receive an access code. which u have type within 10 seconds. this webpage is just a filling form. I used Xpath to go to next field and save it. please send me an example script where CSV file is read and written in each field. and how to select the field. should i write Meal name - csv type.

Here this is an example it’s easy.

Create your macro looking at the example

https://ui.vision/rpa/docs/selenium-ide/csvread

i have two doubts if i want i click and type in a field what is the script i have to use?
should i use id=meal name, in value csvwrite{!col1}.
and if i have a no of option in a field i want press end key in the keyboard can u write the script for this or should i combine the two scripts my task and the demo csv read script will it work?

It’s simply, read the link i have posted there is an example

If you don’t want to study anything then pay a programmer who can make you the whole.

Here you have all information to create your macro

https://ui.vision/rpa/docs/selenium-ide/csvread

what is the script to be used for click end key so that it selects last option.

Do you mean what is the command that is used? That would be click:

https://ui.vision/rpa/docs/selenium-ide/click

No, like my macro is an form filing. there is a field where first i have to click then a drop down options pops out. and i have to select the last option. can anyone tell me the script

You can use Xclick and Xtype to emulate keyboard KEY_DOWN and KEY_ENTER can select a drop menu

https://ui.vision/rpa/docs/xclick

https://ui.vision/rpa/docs/xtype

{
“Command”: “click”,
“Target”: “id=meal-meal_category_id”,
“Value”: “”
},
{
“Command”: “select”,
“Target”: “id=meal-meal_category_id”,
“Value”: “label={!COL7}" }, { "Command": "XClick", "Target": "id=meal-meal_category_id", "Value": "{KEY_PGDN+KEY_PGDN+KEY_PGDN+KEY_PGDN+KEY_PGDN+KEY_ENTER}”
},

Read here you paste a wrong macro code

https://ui.vision/rpa/docs/xclick

https://ui.vision/rpa/docs/xtype

{
“Command”: “XType”,
“Target”: “${KEY_DOWN+KEY_DOWN+KEY_DOWN+KEY_DOWN+KEY_DOWN+KEY_ENTER}”,
“Value”: “”
},

is there any option which can go to the end option

In some select drop menu you can use a little trick, after you open the select with xclick to select the latest element use xtype and KEY_UP not KEY_DOWN, from the first element go up in the latest element, this works in some select dropmenu.

{
“Command”: “XType”,
“Target”: “${KEY_UP}”,
“Value”: “”
},
{
“Command”: “XType”,
“Target”: “${KEY_ENTER}”,
“Value”: “”
},

No its not working i have 1000 options in that dropdown i want to select the last option

is there any other way

Can you post url page to see this dropmenu please ?

I use another type of solution, open dropmenu with xclick i see the list of element and with xtype I type the value to select, it usually select the element simply with xtype command and i confirm with KEY_ENTER.

Exist various types of different dropmenus, in some a command work, in other a command can not work.

Thanks

{
“Command”: “XClick”,
“Target”: “3DUdNY_dpi_96.png”,
“Value”: “”
},
{
“Command”: “XType”,
“Target”: “id=meal-meal_category_id”,
“Value”: “”
},
{
“Command”: “sendKeys”,
“Target”: “id=meal-meal_category_id”,
“Value”: “${KEY_PGDN+KEY_PGDN+KEY_PGDN+KEY_PGDN+KEY_PGDN+KEY_PGDN+KEY_PGDN+KEY_PGDN+KEY_PGDN+KEY_PGDN+KEY_ENTER}”
},

this script is working but it is selecting the middle option , how to make it go at the end