Find the byte size of a folder in PDM

PDM Generality
1

Hello
From the PDM local view, how is it possible to find the byte size of a folder with its contents?
Like the Windows environment, you have to right-click/property and then read the information next to "size:"
Thank you for your help.

2

Hello

It doesn't mean much in EPDM: the real size of your windows folder in your local view depends on the elements that are actually synchronized with the vault (usually it's not much unless you're the only one working in your company). If you synchronize all the content of a folder, its size can quickly be multiplied by 100 (or even infinity if you didn't have any documents synchronized).

1 Like
3

Indeed, you are right. I will specify my need. How do I know the size of a folder with its contents still in a local view without getting the latest version of the files in my cache?
In other words, how can the size of the file be estimated before outsourcing its contents from the vault?
Thank you

4

So I would say that it smells like an EPDM query (but my knowledge of SQL and data from the EPDM database is too limited for me to do it...).

Below is a request (made by American colleagues of Visiativ) to list all the files with a given name. you have to take inspiration from the trick to find all the files in a given directory, then either make a loop to calculate the sum of the file sizes, or redo an export of the result to be able to summarize it in Excel for example.

File_Location_&_Status (GoEngineer).crp (1.5 KB)

A good google search for what you want in English could allow you to find a query closer to what you're looking for than mine

otherwise there is this one that would have to be slightly modified: (it looks for the subfolders, you are the files that need to be found)

List All Project Folders Stored Under a Specified Folder

This example lists folders by replacing the folder path.

Select P.Name
 From Projects P, ProjectTree Pt, Projects P2
 where P.ProjectID > 1 And
            P2.Path Like '\Projects\' And
            P2.ProjectID = Pt.ProjectID And
            P.ProjectID = Pt.ChildProject
 Order By P.Name Asc
1 Like
5

Hello
Otherwise, even if it means being on Excel, a macro that uses the chest search can help. Just retrieve only the latest version of the file contained in the targeted folder and calculate the volume as you go.
A little longer in processing time than a sql query but it all depends on the content of the folder (the scan of our complete database which is physically 1.3TB on the server takes about 3 hours if my memory is good but I retrieve data at the same time so necessarily longer than a simple scan to recover the size of a file)

2 Likes
6

Hello

Thank you for your feedback. Unfortunately I don't have access to the SQL server!!
I think I'll have to get the latest version folder by folder...

Thank you

7

I'm going to test the search tool with an excel export. And with the size column, I'll be able to get the sum. Thank you Cyril you put me on the track

8

Hello
I just tested the right-click properties on a folder in the PDM and it works like windows. There is the number of files as well as the total size of the folder...

1 Like