Hello community!
I want to enter the email ids one by one
As shown in the above website.
Bot will enter first email id and then it will click on submit,After that there are few options to select it will select that one by one, and at last after filling all the details for this one mail id…one request number will get genrated i want to extract only that request number and i have to paste it in a excel ill attach a sample
Like this i want to maintain
And after extracting request number,Bot will logout that page and it will do same steps for next mail id.
What logic i can use?
Anil_G
October 11, 2023, 4:16am
2
@Priyesh_Shetty1
I hope you have emails also in the same excel…
for each row in excel or read data into datatable and use for each row in datatable
Inside loop currentRow("EmailId").ToString will give the id…next in the loop perform all remaining steps till end
Use get text to get the request number
Use assign with currentRow("RequestNumber") = reqnum
The same process repeats for each row
Cheers
@Anil_G i have added that mail ids in config sheet actually i have stored that mail ids in array and i am taking values from config.
Gokul001
October 11, 2023, 4:39am
4
HI @Priyesh_Shetty1
Use read range activity → to Read the Input excel file (ie Whre you have email ids) → Store it in DtInput
Use Open Browser activity → Open the Website as you need
Use For each Row in DataTable activity → Pass the DtInput
Type into activity → CurrentRow("Emailid").ToString
Use Get text activity
Check out the XAML file
11.10.2023_Forum_1.xaml (11.7 KB)
Regards
@Priyesh_Shetty1
If you are storing all the emails ids in a config
Separated them ;
you can use split Function
And follow the process which you want
Otherwise if any let me know
Cheers
@Shiva_Nikhil iam storing the values in config only…i want to iterate the email ids one by one.
Gokul001
October 11, 2023, 4:49am
7
Have you check this XAML file @Priyesh_Shetty1
@Priyesh_Shetty1
Emails=demo@gmail.com ;newuser@gmail.com .
If you can do in the same way which i have mentioned
Anil_G
October 11, 2023, 5:17am
9
@Priyesh_Shetty1
Then please use for each email id…using the for each loop and passing array…
Then use add data row and construct the row with email id and request number as needed and write the data
The logic remains same
Cheers
@Gokul001 but i have stored the values i mean the emails in config
And second thing is once the request number is extracted and pasted in excel it will logout that website and again it will login from there and enter 2nd email id and do the same step?
@Shiva_Nikhil example-config(“emails”).tostring.split(","c).toarray like this
Gokul001
October 11, 2023, 5:53am
12
Hi @Priyesh_Shetty1
Okay, Then you need to add all the things inside the Loop
Can you share the sample config file here
@Gokul001 sorry but due to some restrictions by company it is system is not allowing to share a file…how can i do that then?
@Priyesh_Shetty1
arr_mailids=config(“emails”).tostring.split(","c).toarray
use for each activity to loop through each mail id
and inside place all the activities which you need to do
cheers
Gokul001
October 11, 2023, 6:06am
15
Hi @Priyesh_Shetty1
How the email look in the Config file
Some thing like this
xx@gmail.com,yyy@gmail.com,mmm@gmail.com
@Gokul001 yes gokul it looks like this exactly
Gokul001
October 11, 2023, 6:10am
17
Hi @Priyesh_Shetty1
Check out the XAML file
11.10.2023_Forum_2.xaml (11.7 KB)
Regards
@Gokul001 thank u this method worked…once ill get the request number i want to do it like this
My 4 files name is WBR9C and the name will remain same only for the process so as shown in above image i want to maintain flagging and i want to paste that request number in front of every file.
I need to add request status and request number in excel sheet.
Gokul001
October 12, 2023, 4:33am
19
HI @Priyesh_Shetty1
After extracting the Request No You can Use Lookup activity to get the range .
pass the out value in the Write cell and enter the value in the excel file
system
October 15, 2023, 4:33am
20
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
