Hi,
I am working on some web data fill design and need your help and time here, I tried to put the need in a very simple way (i think) for better
understand and based on that MAY be I will be able to get to the goal.
Considering demo html/xml page and excel file which contains data to process
In a web page the drop down or text or checkbox are defined with their class name and option are numbers, and this is help to find and fill the
data
Flow Chart Step Data
Open IE Page from Excel URL Excel Data
Search for Div Class Excel Data
search for option value Excel Data
Fill the data as per option value
Search for Div Class Excel Data
search for option value Excel Data
Fill the data as per option value
Search for Div Class Excel Data
Enter the text in box Excel Data
Search for Div Class Excel Data
Select checkbox based on option Excel Data
wait for 5 sec
submit form
close IE Current page
Loop the process till last value in excel
-----------------------------------------------------------------------
for example please refer below data sheet
[TABLE="width: 1188"]
<tbody>[TR]
[TD]Web page[/TD]
[TD]Div Class[/TD]
[TD]option value[/TD]
[TD]Div Class[/TD]
[TD]option value[/TD]
[TD]Div Class (Text)[/TD]
[TD]Div Class (Checkbox) Option[/TD]
[TD]Wait time before review (sec)[/TD]
[TD]Wait time before Submit (sec)[/TD]
[/TR]
[TR]
[TD]xxx.com[/TD]
[TD]Test_program[/TD]
[TD]XXX15[/TD]
[TD]Test_program1[/TD]
[TD]XXX18[/TD]
[TD]abcd[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]zzzz.com[/TD]
[TD]Test_program2[/TD]
[TD]XXX16[/TD]
[TD]Test_program2[/TD]
[TD]XXX19[/TD]
[TD]ghghhtytjnmj[/TD]
[TD]3[/TD]
[TD]6[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]xxx.com[/TD]
[TD]Test_program3[/TD]
[TD]XXX17[/TD]
[TD]Test_program3[/TD]
[TD]XXX20[/TD]
[TD]edfr[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]yyyxxx.com[/TD]
[TD]Test_program4[/TD]
[TD]XXX18[/TD]
[TD]Test_program4[/TD]
[TD]XXX21[/TD]
[TD]thsd[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]xxx.com[/TD]
[TD]Test_program5[/TD]
[TD]XXX19[/TD]
[TD]Test_program5[/TD]
[TD]XXX22[/TD]
[TD]vgrffg[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]xxx.com[/TD]
[TD]Test_program6[/TD]
[TD]XXX20[/TD]
[TD]Test_program6[/TD]
[TD]XXX23[/TD]
[TD]bhytgj[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]
Kindly help.
I am working on some web data fill design and need your help and time here, I tried to put the need in a very simple way (i think) for better
understand and based on that MAY be I will be able to get to the goal.
Considering demo html/xml page and excel file which contains data to process
In a web page the drop down or text or checkbox are defined with their class name and option are numbers, and this is help to find and fill the
data
Flow Chart Step Data
Open IE Page from Excel URL Excel Data
Search for Div Class Excel Data
search for option value Excel Data
Fill the data as per option value
Search for Div Class Excel Data
search for option value Excel Data
Fill the data as per option value
Search for Div Class Excel Data
Enter the text in box Excel Data
Search for Div Class Excel Data
Select checkbox based on option Excel Data
wait for 5 sec
submit form
close IE Current page
Loop the process till last value in excel
-----------------------------------------------------------------------
for example please refer below data sheet
[TABLE="width: 1188"]
<tbody>[TR]
[TD]Web page[/TD]
[TD]Div Class[/TD]
[TD]option value[/TD]
[TD]Div Class[/TD]
[TD]option value[/TD]
[TD]Div Class (Text)[/TD]
[TD]Div Class (Checkbox) Option[/TD]
[TD]Wait time before review (sec)[/TD]
[TD]Wait time before Submit (sec)[/TD]
[/TR]
[TR]
[TD]xxx.com[/TD]
[TD]Test_program[/TD]
[TD]XXX15[/TD]
[TD]Test_program1[/TD]
[TD]XXX18[/TD]
[TD]abcd[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]zzzz.com[/TD]
[TD]Test_program2[/TD]
[TD]XXX16[/TD]
[TD]Test_program2[/TD]
[TD]XXX19[/TD]
[TD]ghghhtytjnmj[/TD]
[TD]3[/TD]
[TD]6[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]xxx.com[/TD]
[TD]Test_program3[/TD]
[TD]XXX17[/TD]
[TD]Test_program3[/TD]
[TD]XXX20[/TD]
[TD]edfr[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]yyyxxx.com[/TD]
[TD]Test_program4[/TD]
[TD]XXX18[/TD]
[TD]Test_program4[/TD]
[TD]XXX21[/TD]
[TD]thsd[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]xxx.com[/TD]
[TD]Test_program5[/TD]
[TD]XXX19[/TD]
[TD]Test_program5[/TD]
[TD]XXX22[/TD]
[TD]vgrffg[/TD]
[TD]7[/TD]
[TD]5[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]xxx.com[/TD]
[TD]Test_program6[/TD]
[TD]XXX20[/TD]
[TD]Test_program6[/TD]
[TD]XXX23[/TD]
[TD]bhytgj[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]
Kindly help.