topic RE: Get Count of Files from a folder in Product Forum

Get Count of Files from a folder

HemalathaPolasa — Fri, 09 Apr 2021 10:51:00 GMT

Hi,

Do anyone have the code stage that have been already developed for getting the count of files (shared folder) or else can you suggest me what would be the best way to do?

1. We can use get files action and get number of rows from collection but the count of files in a folder will be more...I suspect there can be a possibility that it would throw memory exception.

Thanks!

------------------------------
Hemalatha Polasani
Application Developer-RPA
------------------------------

RE: Get Count of Files from a folder

diane.sanzone — Fri, 09 Apr 2021 12:39:00 GMT

Hi Hemalatha,

This is a little outside the box and I haven't tried it personally, but can you open the shared folder in Windows Explorer, then spy/read/parse the element in the lower left corner which displays the item count for the folder? Assuming all you need is a file count and there are no sub folders in the shared folder to falsely increase the value, this should give you the information you need.

Hope this helps.

------------------------------
Diane Sanzone
------------------------------

RE: Get Count of Files from a folder

TobiasArnold — Fri, 09 Apr 2021 13:02:00 GMT

Hi Hemalatha,

How many files are you dealing with?

Personally I would say using the get files action and use collection count is the way to go.
Don't care about memory. I think opening the folder in the file explorer will consume more memory as using the action.

------------------------------
Tobias Arnold
RPA Developer
ITERGO GmbH
Europe/Duesseldorf
------------------------------

RE: Get Count of Files from a folder

NickLeGuerrier — Fri, 09 Apr 2021 13:19:00 GMT

Hi Hemalatha,

You can create a copy of the existing Get Files action in the Utility - File Management Object and modify it to only return the count of the files in a given folder. If you are dealing with a very large number of files (10,000+ files), then returning a DataTable to a Blue Prism collection just to count it afterwards could be slow.

Here's a stripped down version that will count the files in a folder with a single search string (my VB.net is a little rusty):

Dim aFiles As FileInfo()
Dim aPattern As String
Dim oDirectory As New DirectoryInfo(Folder)

Try
aPattern = Patterns_CSV.replace("?", ",")
aFiles = oDirectory.GetFiles(aPattern.Trim)
fileCount = aFiles.Length

Success = True
Message = ""

Catch e As Exception
Success = False
Message = e.Message
End Try

Regards,
Nick

------------------------------
Nick LeGuerrier
Senior RPA Developer
MD Financial Management
Ottawa
------------------------------

RE: Get Count of Files from a folder

HemalathaPolasa — Mon, 12 Apr 2021 14:17:00 GMT

Thank you for the code 🙂
I have used Get Files action, I got to know there won't be more than 1000 files.

------------------------------
Hemalatha Polasani
Application Developer - RPA
IBM
Asia/Kolkata
------------------------------

RE: Get Count of Files from a folder

vinodchinthakin — Wed, 14 Apr 2021 04:54:00 GMT

Hi Hemalatha,

I have found following Asset from DX which consists of Get Files/ Folders count action, may be you can use the VBO or you can copy the code and use it in your process.
https://digitalexchange.blueprism.com/dx/entry/113833/solution/atcs---utility-file-management

------------------------------
vinod chinthakindi
------------------------------

RE: Get Count of Files from a folder

MANIKANTA1501 — Thu, 27 Jan 2022 14:09:00 GMT

Hi Nick,

Greetings for the day!

Even this code is giving the count by considering the temp files in the target folder. I mean if we have "2" proper files in a folder and "3" temp files in it. We expect the count to be "2" but the code is giving us the count as "5". So any suggestion on how to resolve this?

Thank You!

------------------------------
MANIKANTA PITCHAIAH KAPALAVAI
------------------------------

RE: Get Count of Files from a folder

PvD_SE — Fri, 28 Jan 2022 07:48:00 GMT

Hi M,

Just stick to the simplest thing there is: get a list of the files in a collection, filter out what you don't want to have (temp files) and count the number of rows left in your collection. All of this can be done by the standard out of the box BP actions. Anything else sounds like overkill to me.

------------------------------
Happy coding!
Paul
Sweden
------------------------------