Documentation:Emailing from an app using MDrivenServer: Difference between revisions

Emailing from an app using MDrivenServer

Latest revision as of 15:34, 10 February 2024

Be sure to set up the Portal settings or MDriven Server settings.

Serverside ViewModel

Create a serverside ViewModel like this:

When you have an action in your ViewModel named “email”, MDrivenServer will try to find the following properties in your ViewModel:

to: will be used as to email address. You can also send multiple emails in a comma-separated string to send to multiple. Use this syntax PopularName<email> to get a common name to show instead of the email. For example "PopularName1<email@email.x>,PopularName2<email2@email.x>"
Bcc : (Added 2020-11-27) Same rules as "to" but blind carbon copy
CC : (Added 2020-11-27) Same rules as "to" but carbon copy

from: the sender email (You may send the presentation as well as PopularName2<email2@email.x>)

~~frompresentation~~~~: the name to use as sender~~ This is no longer in effect as all is handled in the "from" column

body: the message

subject: the subject line

Emailxxx: Any action starting with email will trigger the send.

Adding attachments to server-side emails

Add a nesting column name "attachments".

Let the target nesting have the following columns: file:blob, name:string, and mediatype:string

None of the above is case-sensitive. See the example below:

Extensions 2020-05-28: Inline Disposition and Contentid

If you have an HTML email with pictures, you can either add the image content as base64 data: <img src="data:image/jpg;base64,base64-data-string-here" />

Or, if you do want base64 images, you can also add them as attachments and refer to them with a Contentid:

<img src="cid:THECCONTENTID" />

We now check the Attachments-nesting for a column named "contentid" and add this to the attachment. If it is not found, we still add the attachment but without an id.

When adding the content id, we also set the attachments-Disposition-Type to inline. This will have the effect of unlisting the attachment in the email - only showing the attachment where it is referenced from the cid.

The MDriven Book - See: Import data from other SQL servers

This page was edited 100 days ago on 02/10/2024. What links here

@@ Line 1: / Line 1: @@
-If you have an action in your viewmodel named “email” then MDrivenServer will try to find the following properties in your viewmodel:
+Be sure to set up the [[Turnkey email settings|Portal settings]] or [[Fill in the email settings in the admin UI|MDriven Server settings.]]
-'''to''' : will be used as to email address. You can also send in multiple emails in a comma separated string to send to multiple. Use this syntax  PopularName<email> to get a common name to show instead of the email
+=== Serverside ViewModel ===
+Create a [[MDrivenServer periodic server-side actions|serverside]] ViewModel like this:
-'''<s>topresentation</s>:''' <s>the name of the owner of the email</s>  this is replaced by sending in PopularName<email> in the "to" column [[Send email with attachments|as described here]]
+[[File:Example of viewmodel for emailing.png|frameless|509x509px]]
-'''from:''' the sender email
+When you have an action in your ViewModel named “email”, MDrivenServer will try to find the following properties in your ViewModel:
+* '''to''': will be used as to email address. You can also send multiple emails in a comma-separated string to send to multiple. Use this syntax  PopularName<email> to get a common name to show instead of the email. For example "PopularName1<email@email.x>,PopularName2<email2@email.x>"
+* '''Bcc''' : (Added 2020-11-27) Same rules as "to" but blind carbon copy
+* '''CC''' : (Added 2020-11-27) Same rules as "to" but carbon copy
-'''frompresentation''': the name to use as sender
+* '''from:''' the sender email (You may send the presentation as well as PopularName2<email2@email.x>)
-'''body:''' the message
+* '''<s>frompresentation</s>'''<s>: the name to use as sender</s>  This is no longer in effect as all is handled in the "from" column
-'''subject''': the subject line
+* '''body:''' the message
-'''Emailxxx''': Any action starting with email will trigger the send.
+* '''subject''': the subject line
-''The properties found will be used to send an email – you need to [[fill in the email settings in the admin UI]] for this to work''
+* '''Emailxxx''': Any action starting with email will trigger the send.
-Emailing from the server has been updated to allow for attachments as described here; [[send email with attachments]]
+===Adding attachments to server-side emails===
+Add a nesting column name "attachments".
+Let the target nesting have the following columns: file:blob, name:string, and mediatype:string
+None of the above is case-sensitive. See the example below:
+[[File:AttatchExample.JPG|link=https://wiki.mdriven.net/index.php/File:AttatchExample.JPG]]
+==== Extensions 2020-05-28: Inline Disposition and Contentid ====
+If you have an HTML email with pictures, you can either add the image content as base64 data: <img src="data:image/jpg;base64,base64-data-string-here" />
+Or, if you do want base64 images, you can also add them as attachments and refer to them with a Contentid:
+ <code><img src="</code>cid:THECCONTENTID<code>" /></code>
+We now check the Attachments-nesting for a column named "contentid" and add this to the attachment. If it is not found, we still add the attachment but without an id.
+When adding the content id, we also set the attachments-Disposition-Type to inline. This will have the effect of unlisting the attachment in the email - only showing the attachment where it is referenced from the cid.
+The MDriven Book - See: [[Import data from other SQL servers]][[Category:MDriven Server]]
+[[Category:Portal]]
+[[Category:The MDriven Book]]
+{{Edited|July|12|2024}}