topic Re: Attach a document into an email in Alfresco Archive

Attach a document into an email

mvicidomini — Mon, 07 Oct 2013 14:41:42 GMT

Hello all, i would like to attach a document when it is uploaded to alfresco. I know that there is the default notification from the workflow but for internal reason my customers ask me to attach the original document into an email. I have writen a small script but i don't manage to attach the docum

Re: Attach a document into an email

mrogers — Mon, 07 Oct 2013 14:52:31 GMT

I don't think its supported.

Re: Attach a document into an email

mitpatoliya — Tue, 08 Oct 2013 09:15:50 GMT

You need to send mail in task-listner java class which will be invoked during transition.

Re: Attach a document into an email

rjohnson — Tue, 08 Oct 2013 10:17:39 GMT

The standard mail action does not allow attachments. You need to create a derivative. There is one on the internet which I downloaded and it works fine with 4.2c. My code is based on the code at http://savicprvoslav.blogspot.co.uk/2010/10/send-html-email-from-alfresco-33-with.html. Happy to share it with your but I can't attach it to this post so send me a message with an email address & I will forward it on.

Re: Attach a document into an email

mvicidomini — Wed, 09 Oct 2013 14:10:09 GMT

Hello Bob thanks a lot for your help. latong06@gmail.com

Re: Attach a document into an email

rjohnson — Wed, 09 Oct 2013 16:58:29 GMT

Sent. Any issues, post here and I will do what I can

Re: Attach a document into an email

mvicidomini — Thu, 17 Oct 2013 15:27:00 GMT

Hello Bob , i'm sorry but i was to fast. I add a rule that will execute that will send an email with the document that has just been added.
The problem is that it execute a mail loop without end.
Please find my script below.

Do you see something wrong ?

Thanks in advance

var PubDate = document.properties["cm:created"];
document.properties["cmublicationDate"] = PubDate;
document.save();

var renditionDef = renditionService.createRenditionDefinition('cm:'+document.name, 'reformat');
renditionDef.parameters['mime-type'] = "application/pdf";
var pdfFile = renditionService.render(document, renditionDef);

var mail = actions.create("fg-mail");
var addresse = "admin@cip.mc";
var templateArgs = new Array();
var templateModel = new Array();
templateArgs['addressee'] = addresse;
templateModel['args'] = templateArgs;
mail.parameters.template_model = templateModel;
mail.parameters.template = companyhome.childByNamePath("Data Dictionary/Email Templates/Notify Email Templates/notify_user_email_fr.html.ftl");
mail.parameters.subject = "Ajout de document";
mail.parameters.from = ANEMAIL;
mail.parameters.text = "Template has not been found. Please call Liberator support";
mail.parameters.node_to_attach = pdfFile;
mail.parameters.attachment_extension = "pdf";
mail.parameters.to = MYEMAIL;
mail.execute(document);

Re: Attach a document into an email

rjohnson — Thu, 17 Oct 2013 17:17:00 GMT

Well, I can't see a loop in your code for sure so I suspect that your rule is firing when the document is added and when the PDF is created as a rendition.

First I assume you have a rule that only fires when content is added to the folder. Nothing that fires on an update.

Assuming that is the case I suspect that Alfresco considers the creation of the rendition a "new" document (if you look inside the node browser it is a hidden child node of your document). If memory serves your PDF Rendition has a document type of cmdfExport.

Looking at my code, I filter on document type and so this may be why I have never had this problem, so I would suggest you add code in your rule javascript like


if(document.typeShort != "cm:pdfExport") {
  …… execute your code
}
‍‍‍‍‍

and see if that works.

Re: Attach a document into an email

mvicidomini — Fri, 18 Oct 2013 10:30:04 GMT

Does not work , it is still looping

Re: Attach a document into an email

rjohnson — Fri, 18 Oct 2013 11:26:13 GMT

Does it repeatedly email the same thing?

Re: Attach a document into an email

mvicidomini — Fri, 18 Oct 2013 12:24:38 GMT

Yes unfortunatly

Re: Attach a document into an email

rjohnson — Fri, 18 Oct 2013 13:22:23 GMT

Can you try using the standard mail object and just mail yourself a message. If that loops its a problem with the rule trigger. If not then its something to do with the fg-mail object but I cannot think what as near enough I do exactly what you are trying to do and it works fine for me.

Re: Attach a document into an email

mvicidomini — Fri, 18 Oct 2013 13:45:29 GMT

Hello,

i have already try with the simple email notification and it work fine. Maybe it is a problem with my script ….

Do you have any advise ?

Thanks

Re: Attach a document into an email

rjohnson — Fri, 18 Oct 2013 14:46:17 GMT

Honestly your script looks fine, and I do more or less the same thing as you and it works well for me. The difference is that I look for specific document types and only email PDF's of those whereas I assume you will email a PDF for any document type.

I can only assume that the creation of the rendition is causing the script to trigger over and over and the document type of the rendition is not cmdfExport - it may well be cm:content in which case a PDF rendition and your original document will be indistingushable.

One thing to try would be this

replace


var renditionDef = renditionService.createRenditionDefinition('cm:'+document.name, 'reformat');
renditionDef.parameters['mime-type'] = "application/pdf";
var pdfFile = renditionService.render(document, renditionDef);
‍‍‍‍‍

with


var pdfFile = document.transformDocument("application/pdf", userhome);
‍‍‍

This will create the PDF document in userhome which (I presume) is not covered by your rule (if it is create the PDF somewhere that isn't).

If that doesn't work I am at a loss, but please let me know as I will test it on my own installation and figure it out because this is important to me.

Re: Attach a document into an email

mvicidomini — Sun, 20 Oct 2013 21:36:10 GMT

Still looping, but the thing i that if i do not apply the rule the the subfolder it works fine. As soon as i apply it on the subfolders it is at this moment that the mail sending is looping.

thanks again for all your time.

Re: Attach a document into an email

rjohnson — Sun, 20 Oct 2013 23:22:02 GMT

Well, it sounds like somethings hapening in your sub folders. Do you have any other rules?

Re: Attach a document into an email

mvicidomini — Mon, 21 Oct 2013 06:30:21 GMT

Nothing, it is a fresh install …

Re: Attach a document into an email

mvicidomini — Mon, 21 Oct 2013 08:12:58 GMT

I found the mistake, it is link to

var PubDate = document.properties["cm:created"];
document.properties["cmublicationDate"] = PubDate;
document.save();

Because as soon as i removed it the mail stop looping but i cannot retrieve the file to attach to the email anymore.
So , how can i retrieve the referenc of the document that has just been added

Thanks again

Re: Attach a document into an email

rjohnson — Mon, 21 Oct 2013 14:29:47 GMT

So if I understand, when you remove the code above the rule doesn't recognise "document" as existing?

If this is so then I think you have a deeper problem here because "document" always exists in a rule and points to the "document" you have just created.

Are you sure that your issue is not with the template trying to use document.properties["cmublicationDate"] and failing because that does not exist (or is null)?

What error do you actually get?

Re: Attach a document into an email

mvicidomini — Tue, 22 Oct 2013 08:20:42 GMT

Hello,

when i use var pdfFile = document.transformDocument("application/pdf", userhome); it creates correctly the file in the userhome.
But mail.parameters.node_to_attach = pdfFile does not retrieve anything i mean there is no attachment to the email.

Thanks.