topic Count all uploaded documents in Share sites in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/count-all-uploaded-documents-in-share-sites/m-p/303615#M256745 <HTML><HEAD></HEAD><BODY><SPAN>Alfresco gurus,</SPAN><BR /><BR /><SPAN>After looking fruitlessly for a tool that provides an accurate total count of uploaded files in the Share document libraries, I've cobbled together the following, inelegant Javascript script (I'm a fortran programmer!).&nbsp; I've verified the count successfully against test Alfresco instances (versions 3.2r2 and 4.x) by going into each site and manually counting every file uploaded.&nbsp; Please take a look and see if I've goofed up somewhere.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />//<BR />// Script to recursively descend into sites and count files in document libraries<BR />//<BR /><BR />var count = 0;<BR /> <BR />// Get an array of all site nodes<BR />var sites = siteService.listSites(null,null,0);<BR /> <BR />// Loop over sites<BR />for each (var site in sites) {<BR />&nbsp;&nbsp;&nbsp;&nbsp; //logger.log("Site: " + site.shortName);<BR />&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp; // First, find files at the top level in /documentLibrary (excluding subfolders)<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp; // Loop over the sites's children (doclib, wiki/blog, etc.)<BR />&nbsp;&nbsp;&nbsp;&nbsp; for each (child in site.node.children) {<BR /> <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Loop over the children of doclib/wiki/blog and get files in the doclib<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for each (item in child.children) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // Find unique files<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ufile = unique(item);<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (ufile.isDocument &amp;&amp; ufile.displayPath.match(/documentLibrary/)) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //logger.log("&nbsp;&nbsp; " + ufile.displayPath + "/" + ufile.name);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; count++;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp; // Now add the file nodes in /documentLibrary subfolders<BR />&nbsp;&nbsp;&nbsp; getSpaces (site.node, 0);<BR />}<BR />logger.log("Total: " + count);<BR /><BR />// Function to find every file in a doclib subfolder in a site<BR />function getSpaces (node, depth) {<BR />// Recursively descend into folders and files all files<BR />&nbsp; if (node.isContainer) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //logger.log("Folder: " + node.displayPath + "/" + node.name);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for each (var file in node.children) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (file.displayPath.match(/documentLibrary/) &amp;&amp; file.isDocument) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; //logger.log("&nbsp;&nbsp; " + file.displayPath + "/" + file.name);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; count++;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp; }<BR />&nbsp; var children = node.children;<BR />&nbsp; for each (var child in children) {<BR />&nbsp;&nbsp;&nbsp; if (child.isContainer &amp;&amp; node.children.size != 0) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; getSpaces(child, depth++);<BR /> <BR />&nbsp;&nbsp;&nbsp; }<BR />&nbsp; }<BR />}<BR /> <BR />// Function to find unique members of an array<BR />function unique (origArr) {<BR />&nbsp;&nbsp;&nbsp; var newArr = [];<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; found = undefined;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x = 0;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; y = 0;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; origLen = origArr.length,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; found,<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; x, y;<BR /> <BR />&nbsp;&nbsp;&nbsp; for ( x = 0; x &lt; origLen; x++ ) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; found = undefined;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for ( y = 0; y &lt; newArr.length; y++ ) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if ( origArr[x] === newArr[y] ) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; found = true;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; break;<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if ( !found) newArr.push( origArr[x] );<BR />&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp; return newArr;<BR />};<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><BR /><SPAN>Regards,</SPAN><BR /><BR /><SPAN>Anurag</SPAN></BODY></HTML> Wed, 24 Apr 2013 17:26:33 GMT ashankar 2013-04-24T17:26:33Z Count all uploaded documents in Share sites https://connect.hyland.com/t5/alfresco-archive/count-all-uploaded-documents-in-share-sites/m-p/303615#M256745 Alfresco gurus,After looking fruitlessly for a tool that provides an accurate total count of uploaded files in the Share document libraries, I've cobbled together the following, inelegant Javascript script (I'm a fortran programmer!).&nbsp; I've verified the count successfully against test Alfresco insta Wed, 24 Apr 2013 17:26:33 GMT https://connect.hyland.com/t5/alfresco-archive/count-all-uploaded-documents-in-share-sites/m-p/303615#M256745 ashankar 2013-04-24T17:26:33Z Re: Count all uploaded documents in Share sites https://connect.hyland.com/t5/alfresco-archive/count-all-uploaded-documents-in-share-sites/m-p/303616#M256746 <HTML><HEAD></HEAD><BODY><SPAN>You need not write the entire logic. just use the fallowing query to get all the documents that are uploaded into site</SPAN><BR /><BR /><SPAN>var noOfDocs=search.luceneSearch("TYPE:\"cm:content\" AND PATH:\"//app:company_home/st:sites//*\" ");</SPAN><BR /><BR /><SPAN>This will give the documents that are uploaded into site which are cm:content and it's subtypes.</SPAN><BR /><SPAN>if you have your own type just specify it.</SPAN><BR /><SPAN>Since you want count, just this will return array so you can use noOfDocs.length</SPAN><BR /><BR /></BODY></HTML> Tue, 28 May 2013 12:11:00 GMT https://connect.hyland.com/t5/alfresco-archive/count-all-uploaded-documents-in-share-sites/m-p/303616#M256746 rajupingili 2013-05-28T12:11:00Z