Announcement

**peteconway** · 10-21-2021, 05:01 AM

Have you given thought to send your emails as Viewbox generated rather than pdf?

Pete

**Ted Giles** · 10-22-2021, 01:30 PM

Originally posted by aprescott View Post

Can you elaborate? I'm open to other options if I can get it working. My current solution was working perfectly until I moved it over to the server.

It's a Permissions Issue if it works locally and not on the server.
Contact your host. As them where the blockage is. They should be able to see the exception being thrown.
Look for folders/files being created on the server to support the mailout.

**aprescott** · 11-10-2021, 01:56 PM

peteconway This intrigues me. I'm looking at a lot of Alpha docmentation/videos on emails and reports with viewboxes, but being completely new to viewboxes its a little beyond me. Also can't find anything leading to a bulk email. Can you point me in the right direction?

**frankiez** · 11-14-2021, 04:57 PM

I use SQL Agent & Database mail for batch or single email functions. I use email templates so content can be updated easily. This includes Text and HTML formats.
To make it easier, I have an email_box table that uses a trigger to fire the SQL Database mail procedure (EXEC msdb.dbo.sp_send_dbmail). I use this as an email history table
In my production systems, the SQL database server is separate from the web server so these emails do not have any impact on my Alpha applications.
If this is of interest, I can post some scripts with examples to show how easy this is to set up and implement. SQL Database mail does not allow PDF attachments since there are security issues regarding the file system. I prefer to dynamically create nice HTML emails.

**gianfior85** · 11-15-2021, 05:15 PM

frankiez I would be very interested in seeing an example of how you set this up.

**frankiez** · 11-15-2021, 05:42 PM

gianfior85 ---Give me a day or two and I will put a simple example together using the SQL Northwind database.

**aprescott** · 11-24-2021, 09:46 AM

OK sports fans, It's been a long journey but I believe I almost have it sorted!

I present the following code:

Code:

function sendmail as c (e as p)
debug(1)
dim donCN as sql::Connection
dim donARGS as sql::Arguments
dim sqlCode as p
dim itsOpen as l
dim itWorked as l
dim donorArray[0] as p
dim js as c

sqlCode.getData = <<%txt%
SELECT * from monthgift
where mailpreference='EM' AND mailtrigger = 'Y'
group by id_number

%txt%
itsOpen=donCN.open("::name::donor sql") 'Use this to check that the database connection works
itWorked = donCN.ToPropertyArray(sqlCode.getData,donorArray) 'Use this to verify that the data is added to the array (donorArray)

for each donor in donorArray
[COLOR=#c0392b][B]donargs.set("ARGID",donor.id_number) 'The viewbox is filtered to generate the report by argument ARGID.[/B][/COLOR]
'read the css from the control definition
dim ix as n
dim tmpl as p
tmpl = e.tmpl
ix = tmpl.page_fields.findi("vb","v.variablename")
if ix > 0 then
dim json as c
json = tmpl.page_fields[ix].v.viewbox.definitionJSON
dim p as p
p = json_parse(json)
dim css as c
css = p.formview.css
end if

dim html as c = "<html><head><style>" + css + "</style></head><body>" + crlf() + e._html + "</body></html>"

dim MyOrganizationEmailAddress as c = DummyEmail@Address
dim Email as c
Email = ""
Email = donor.email
dim SparkpostKey as c = SPARK POST KEY GOES HERE
dim pm as p
pm.send_to = Email
pm.from_name = "Patrick Eades - Skylark Clinic, Inc."
pm.from_email = MyOrganizationEmailAddress
pm.subject = "Skylark Monthly Giving Record"
pm.message_html = html
pm.options.inline_css = .t.
pm.attachments = "c:\A5Webroot\PC\December2021.pdf"
pm.message_text = ""

'this property is very important. if you don't set this property the email message will not use the stylesheet
pm.options.inline_css = .t.
dim pResult as p
pResult = email_send_sparkpost(SparkpostKey,pm)
dim count as n
if pResult = .t. then
count = count+1
end if
next
if count >= 1 then

js= "alert('Successfully sent " + AllTrim(count) + " Emails');"
end if
sendmail = js
end function

Screenshot 2021-11-24 084536.jpg

I have success when I hard code in the SQL query to send to only one email (viewbox is correctly generated and email successfully sends) but now I need it to loop through the donor array and generate the viewbox/send email for each one. I'm not certain the best way to go about that. I tried setting an argument but I don't know I'm on the right path. Further, I don't think I'm actually calling that argument in the xbasic.

Any thoughts? I am so close!!

**peteconway** · 11-24-2021, 03:31 PM

I’m away from the desk this week, but the actions in the view box definition do what you want to do, they fire for each new record put your code say in the post or pre-render or on complete. Sorry can’t be more specific I don’t have a pc with me.

**peteconway** · 11-25-2021, 05:32 PM

So call the sendmail(); function in the on.populate Event

**aprescott** · 11-29-2021, 11:03 AM

Looking at the debugger, it looks like e._html is not getting a value, so my final HTML for the email has nothing in the <body> tags. Is there somewhere with documentation on e._html? the only other reference to _html I can find is from the Video tutorial I am copying is in the Javascript when I call the sendmail function:

Code:

var html = $('viewboxcontent').innerHTML;
var data = A5.ajax.buildURLParam('_html',html);



{dialog.object}.ajaxCallback("","","sendmail","",data);

I have tried this code in both the onpopulate event as well as on a button on the page. I'm not even sure if this is the same thing as e._html is referring to.

**peteconway** · 11-29-2021, 06:07 PM

I'll take a look today for you i'm back in the chair

is the code shown your latest? send your vb.

Announcement

The Alpha Software Forum Participation Guidelines

Sending Personalized Reports in Batch Email

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment