Counting files in DOCBASE

rvalenzuela

I've created a tree structure of folder inside a cabinet to organize a huge amount of files I needed to upload.

Now I need to do crosscheck that the files I had in my folders correspond to the ones I needed to upload. Primarily there are document types that I can use but I'd like to do something like:

select doctype, folder, count(*) from whoknowswhere

group by doctype, folder

There could be some errors caused by duplicate files.

I did experience an interruption on the load process which made me purge from the XML file those that already had been loaded, I might have made some bad decisions here.

By the way every folder represents a box so if I count then I could most probably identify where's the problem.

DQL is the answer? are there other tools for this?

Regards

msroth

Ruben,

You might try something like this:

select r_folder_path as fldr, r_link_cnt as cnt from dm_folder where i_cabinet_id in (select r_object_id from dm_cabinet) order by r_folder_path

Here is an example of the results:

fldr                                                                   cnt

-------------------------------------------- -----

/Folder 1                                                        3

/Folder 1/FY 2007                                       1

/Folder 1/FY 2007/2006-12-13               1

/Folder 1/FY 2008                                       2

/Folder 1/FY 2008/2008-2-5                    1

/Folder 1/FY 2008/2008-4-13                 2

/Folder 1/FY 2009                                       0

/Integration                                                 1

/Integration/Esignature                          1

/Integration/Esignature/Templates  1

/Resources                                                   79

You can also write a little Java/DFC code to do some recursive queries if you need more/other info that DQL can't provide.  I have some exaples of this also if you need them.