topic Re: Script to copy documents to a relevant folder in Alfresco Forum

Script to copy documents to a relevant folder

anuradha1 — Mon, 12 Mar 2018 09:38:43 GMT

Hi, I am using Alfresco Community 5.2 and i need to create a script to copy document to a relevant folder. copy-to-rel-folder.js var createdDate = document.properties["cm:created"];var dd = createdDate.getDate();var mm = createdDate.getMonth()+1; //January is 0!var yyyy = createdDate.getFullYear();i

Re: Script to copy documents to a relevant folder

afaust — Mon, 12 Mar 2018 12:41:53 GMT

Simply get the name path until the "COMMISSION_MEETINGS" folder and then iterate over iters chidlren, checking the folder names against your pattern using endsWith / regex checks. Or you may perform an FTS query using the "search" root scope object looking into the path and doing a wildcard match on the folder names.

Re: Script to copy documents to a relevant folder

anuradha1 — Tue, 13 Mar 2018 04:31:15 GMT

Thanks Axel.
Could you please give me a sample code how to do it. I have no idea about how to change my code to achieve this.

Re: Script to copy documents to a relevant folder

afaust — Tue, 13 Mar 2018 17:12:45 GMT

How did you write the code you already have? It shouldn't need a sample to make two or three small adjustments to the code if you have written it yourself. I recommend you make yourself familiar with the ScriptNode API if you are unsure about which properties / functions to call. Specifically you should only need to use the childFileFolders() function and the name property to deal with the contents of the COMMISSION_MEETINGS folder and filter by name..

Re: Script to copy documents to a relevant folder

mehe — Tue, 13 Mar 2018 19:44:48 GMT

just change the way you filled your "today" variable

Re: Script to copy documents to a relevant folder

anuradha1 — Wed, 14 Mar 2018 04:41:50 GMT

I'll try this way & will inform if i success in this.
Thank you.

Re: Script to copy documents to a relevant folder

anuradha1 — Mon, 19 Mar 2018 06:34:14 GMT

I have achieved that task using childFileFolders() method.

Thanks all for helping me.

My JS code is below, in case if someone needs.

//Get document created date
var createdDate = document.properties["cm:created"];

//Get date, month & year seperately from the createdDate
var dd = createdDate.getDate();
var mm = createdDate.getMonth()+1; //January is 0!
var yyyy = createdDate.getFullYear();

//Date & month formatting
if(dd<10){
dd='0'+dd;
}
if(mm<10){
mm='0'+mm;
}

//Get access to the parent folder
var objDestFolder = companyhome.childByNamePath("Shared/public");

//Get all childrens in the parent folder into nodes array
var nodes = objDestFolder.childFileFolders();
var x = nodes.length;
nodes.sort(function(a, b){return a - b});

//Chack whether folder name(date) > created date
for (i = 0; i < x; i++) {
var ch = objDestFolder.children[i].name;
var ch1 = objDestFolder.children[i].properties["cm:title"];
var res = ch1.split(": ");
var fDate = res[1];
var res1 = fDate.split("/");
var fDD = res1[0];
var fMM = res1[1];
var fYYYY = res1[2];
if(yyyy == fYYYY)
{
if(mm == fMM)
{
if(dd <= fDD)
{
//Document move to the relevant folder
var folderDes = companyhome.childByNamePath("Shared/public/" + ch);
document.move(folderDes);

}
}
}

}