Login Web page through Loop

[krajay07 (ajay kumar)]

Hi All,

I am new in Uipath, want to login web page via while loop have login & password details in Excel file.

[PavaniDilip (Pavani)]

you can use read range of excel and store details in datatable. Pass the values in open browser using type into activities. use for each activity to loop thru all excel records.
hope this helps.

[krajay07 (ajay kumar)]

Thanks for the update,
Can you share any xaml file for reference the same.

[Reddy_Paluri (Omkar Reddy)]

Hi @krajay07,

Pls find the attached solution.Let me know if you have any issues.

@You can pass your excel folder path.I am giving some dummy example.

Forum.zip (22.2 KB)

Regards,
Omkar P

[krajay07 (ajay kumar)]

Hi @Paluri

Thank you very much,
I have designed it successfully.

[krajay07 (ajay kumar)]

Hi @Paluri,

Can you please help me in moving these files from download folder to any other destination?

[Reddy_Paluri (Omkar Reddy)]

Hi @krajay07,

Pls try below activity.Let me know if you have any issues.

if you are moving specif files only like .xlsx

How to move specific file from one folder to another

Hi all, I have downloaded two sheets i.e, 1.7166a12c-4d74-4073-87a4-321b63d7758a-canada.csv 2.7166a12c-4d74-4073-87a4-321b63d7758a-united_states.csv I need to move the files to another folder. The problem here is, whenever I download the file, the name of the downloaded file will be changed. So I need to change the files with respect to names. How can I move the files? Someone help me in solving this.

Regards,
Omkar P

[krajay07 (ajay kumar)]

Hi Paluri,

I need only begin with “UETTR*”.xls files to move the different folder.

Regards,

[Reddy_Paluri (Omkar Reddy)]

Hi @krajay07,

Pls find the solution.Let me know if you have any issues.

MoveFiles.zip (30.0 KB)

@Change your file extenstion like *.xls and change your source and destination path.

Regards,
Omkar P

[krajay07 (ajay kumar)]

Hi Paluri,

Thanks Its moving file but also showing message no file found.

Regards,

[Reddy_Paluri (Omkar Reddy)]

Hi @krajay07,

Remove message box in else part and try it

[krajay07 (ajay kumar)]

Hi Paluri,

Please can you advise how I can solve this problem?
In community addition.

[Reddy_Paluri (Omkar Reddy)]

Hi @krajay07,

Pls find the link and some people also face this issue.I am also tested same thing i am getting different error.
@you can check with below link questions tab you can raise your query.

Text to Speech - RPA Component | UiPath Marketplace

Regards,
Omkar P

[krajay07 (ajay kumar)]

Hi Paluri,

Can you please help.
Situation:- I have four CSV files with the same column and datatype need to create a new CSV file and append all four CSV files data into it.

Regards, Ajay Kumar

[Reddy_Paluri (Omkar Reddy)]

Hi @krajay07,

Please find the solution.If you have any issues.Let me know.

I am not tested this solution because i don’t have input csv files. and give the correct csv path inside.

Readmultiple csv.xaml (6.2 KB)

Regards,
Omkar P

[krajay07 (ajay kumar)]

Hi Omkar,

Everything is fine but Final consolidate file showing no header how can i add header as well.

[Reddy_Paluri (Omkar Reddy)]

Hi @krajay07,

This will help you.

How to add header to Append CSV Activity

@Anthony_Humphries i create other project for dispatcher and this for performer

Try this updated file
Readmultiple csv.xaml (9.5 KB)

Regards,
Omkar P

[Reddy_Paluri (Omkar Reddy)]

Hi @krajay07,

If this solution is working fine.Please mark it as solution.Still you have any issues.Let me know

Thanks,
Omkar P

[krajay07 (ajay kumar)]

Hi Omkar,

Its not showing Header in newly created file.

[Reddy_Paluri (Omkar Reddy)]

Send me your input CSV files and your xaml file