How to read all the files from the sub folder

Help Studio
, , ,
21

hi @ray_sha

Ok means you are saying that once all the files read from all subfolders and just assume that some new files get added to all same subfolders. Then it must not read the files which are read previously and only read the new files.

RIght ??

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

22

hey @Pratik_Wavhal

say there are a total of 50 sub folders in the main file and in that first run 10 of which are processed.
The bot may be stopped of some reason.
Now in the second run, those 10 sub folders which were processed shouldn’t be processed again, the bot must continue from the 11th subfolder

23

Hey @ray_sha

I got your query.
One solution for that will be processed files should move to some other folders and this will be efficient also.
Or else you can record the names of processed files to excel but it will take more time to check whether that file name is present in the excel or not and then proceed further.

So you can choose the solution of moving the files.

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

24

Hey,

I am saved the processed sub folder in another folder.
Now I have to compare if the sub folders are present in the other folder as well.

How would I condition the if ?
Thanks

25

Folder names are text and not numbers… If you want the sequence then folders will have to be named like this:
Folder_00001,Folder_00002,Folder_00003...
Also you may need to Sort the items after your command varMyFiles=Directory.GetFiles("c:\myfolder","*.*", SearchOption.AllDirectories)
varMyFilesSorted = System.Array.Sort(Of String)(varMyFiles)

1 Like
26

hey @bcorrea,

Folder_00001,… Folder_000015 or Folder_00015??

Thanks in advance!

27

just make sure that if you have like 10 folders, that the ones from 1 to 9 have one zero to the left, and if you have more than 100 folders, that the 1 to 9 have 2 zeroes and the ones from 10 to 99 have one zero to the left…

1 Like
28

Hi @bcorrea

@ray_sha wants to say that assume that there are a total of 50 sub folders in the main file and the workflow i have given her is perfectly 100% working but now she wants that if my workflow is running and while running suppose something happens and bot gets stop in middle only while reading the files from subfolders.

So next time when she will run the bot that should skip the already processed/readed files and continue with the files that are remained to process/read.

So for that i gave her solution that she should move the files to another destination once they get processed.

So for that now her que is as below

I am saved the processed sub folder in another folder.
Now I have to compare if the sub folders are present in the other folder as well.
How would I condition the if ?
Thanks

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like
29

I would not give myself that trouble… I would just do everything again and overwrite if already there…

1 Like
30

Hi @ray_sha

I am saved the processed sub folder in another folder.
Now I have to compare if the sub folders are present in the other folder as well.
How would I condition the if ?

I have updated the workflow as per requested. Below is the updated workflow.
Updated_Ray_Sha.zip (8.3 KB)

Output :-
image

Within that subfolder names will be same as it is. Refer below SS :-

Main Folder :-
image
Copy of Main Folder :-
image

Within that subfolder inside all the files will also move same as Main Folder :-

Moved all files to Copy of Subfolder1 i.e., Empty Subfolder1 from Mainfolder

image
image696×177 2.82 KB

After reading all files comes to Copy of Mainfolder’s Subfolders
image

Mark as solution and like it :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

2 Likes
31

Thanks @Pratik_Wavhal @bcorrea

1 Like
32

hi @ray_sha

So the solution i have provided is useful for you now ??

Means does your issue is solved with my solution ??

If Yes then
Mark as solution :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like
33

Hi Pratil_Wavhal,
Thanks for the solution,
But i have different file extenstions,i need to extract all of them,how can we do it.

thanks

34

Hi @Navya

I have already posted the solution on below thread. Have a look to it.

Mark as solution and like it der :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

35

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.