-
1. Re: Question to advanced alerting
Matt ColesFeb 13, 2017 7:15 AM (in response to jens.bruckmann)
Could you attach the packaged workbook (.twbx) that you're working with so we can see it? And let us know what sheet it is that you're trying to get to function as an alert.
-
2. Re: Question to advanced alerting
jens.bruckmann Feb 13, 2017 11:33 PM (in response to Matt Coles)Hi Matt,
Sure. Attached the workbook and the excel file I am using. I have created a single sheet for this for testing
-
Book1.xlsx 8.9 KB
-
Book1.twbx 60.2 KB
-
-
3. Re: Question to advanced alerting
Matt ColesFeb 14, 2017 2:03 PM (in response to jens.bruckmann)
(posted under the wrong account, earlier)
Alright, couple things going on here. First, your VIZ_IMAGE content reference is using "views/" at the beginning, which isn't correct. Should be:
<p>Hello Jens,</p><p>Your Daily open Ticket view</p>VIZ_IMAGE(Book1/Sheet1&:size=600,400|vizlink)
That problem should result in VizAlerts throwing an error that says:
The following errors were encountered trying to process your alert:
General errors:
Unable to render content reference VIZ_IMAGE(views/Book1/Sheet1&:size=600,400|vizlink) with error:
HTTP error getting vizdata from url https://yourserver/views/views/Book1/Sheet1&:size=600,400?&:format=png&:size=1500,1500&:refresh=y. Code: 404 Reason: Not Found
Once you remove the "views/" from the front, that should work. Why you aren't getting any email right now, not even the failure message, is odd, because you really should be.
However, because you've got a crosstab going on, you're going to be generating lots of duplicate emails. What you want, I assume, is a single email every day that is sent to you (and maybe others?) that simply renders the table into a PNG and embeds it, right? If so, you'll want two sheets--one with just the text fields for the email...Email Action, To, Subject, Body. You'll add your conditional filters to this sheet so that data only shows when, say, Number of Records is > (some threshold). This will be your "trigger" view. The other sheet, which is the crosstab, will be referenced in the Email Body field in your content reference. So it would be rendered to a PNG and embedded in the email that is generated by the first sheet, your "trigger view".
does that make sense?
-
4. Re: Question to advanced alerting
jens.bruckmann Feb 14, 2017 11:30 PM (in response to Matt Coles)Hi Matt,
thanks a lot for your help. Indeed I had to remove 2 parts in the link to get a mail by posting a comment as first step and yes I want to get a daily mail mail and not multiple
1. definitly the /view in front of and 2. the size as this was already given in the link. After I added the comment test_alert in the comment box I got a mail which looked like I have expected.
But it looks like the part with the trigger is not clear to me.
What I did is following:
I am using now 3 Data Sources
1. VizAlerts
2. The Excel File
3. The Data I really want to see in the subject
I copied the needed files marked with a star from VizAlerts to the Excel datasource and and edit the fields from Vizalerts with the * and entered there the data from the excel file
I set the trigger in this sheets as a conditional filter: which would be in words filter number of records at least >1
In the second sheet I added the value which I want to present
nevertheless I do not get a mail every 15 min from vizalert. Maybe my config file is wrong? Do I need to change something there?
Attached all files I am using
Btw as I extracted the VizAlertsConfig it was telling me the file is using a different timezone? Any Idea to this?
-
VizAlertsConfig.twbx 68.4 KB
-
test.twbx 125.0 KB
-
Book1.xlsx 8.9 KB
-
-
5. Re: Question to advanced alerting
Matt ColesFeb 15, 2017 7:27 AM (in response to jens.bruckmann)
-
6. Re: Question to advanced alerting
jens.bruckmann Feb 15, 2017 10:59 PM (in response to Matt Coles) -
7. Re: Question to advanced alerting
jens.bruckmann Feb 16, 2017 6:21 AM (in response to jens.bruckmann)In addition to this I do not get a mail every 15 min from the demo sheet, too. So I guess there is something wrong with the config file? Do I need to set a trigger there, too?
-
8. Re: Question to advanced alerting
Matt ColesFeb 16, 2017 7:17 AM (in response to jens.bruckmann)
The config workbook you attached earlier looked fine to me, and I can't see anything being wrong with the yaml file if you're getting the test email. I would look at the log file(s) and see if it's actually sending the mail or not. It really should be sending something, either the expected email, or a failure email. Feel free to attach them here if you want me to take a look.
-
9. Re: Question to advanced alerting
Matt ColesFeb 16, 2017 7:18 AM (in response to Matt Coles)
Never mind--the email you show above is from a standard subscription, you can tell by the footer. You need to disable the Schedule before VizAlerts will pick it up.
-
10. Re: Question to advanced alerting
jens.bruckmann Feb 16, 2017 7:38 AM (in response to Matt Coles)Hi Matt
Can you tell me which log files I have to look at, please?
BR
Jens
Am 16.02.2017 um 16:20 schrieb Matt Coles <tableaucommunity@tableau.com<mailto:tableaucommunity@tableau.com>>:
Tableau Community <https://community.tableau.com/?et=watches.email.thread>
Question to advanced alerting
reply from Matt Coles<https://community.tableau.com/people/matthew.coles?et=watches.email.thread> in VizAlerts - View the full discussion<https://community.tableau.com/message/580985?et=watches.email.thread#580985>
-
11. Re: Question to advanced alerting
Matt ColesFeb 16, 2017 7:51 AM (in response to jens.bruckmann)
Don't worry about the log. Just disable the VizAlerts subscription schedule. Then it should work.
-
12. Re: Question to advanced alerting
jens.bruckmann Feb 16, 2017 11:41 AM (in response to Matt Coles)Hi Matt
I think I have disabled the subscriptions but still not get a mail?
BR
Jens
Am 16.02.2017 um 16:52 schrieb Matt Coles <tableaucommunity@tableau.com<mailto:tableaucommunity@tableau.com>>:
Tableau Community <https://community.tableau.com/?et=watches.email.thread>
Question to advanced alerting
reply from Matt Coles<https://community.tableau.com/people/matthew.coles?et=watches.email.thread> in VizAlerts - View the full discussion<https://community.tableau.com/message/580988?et=watches.email.thread#580988>
-
13. Re: Question to advanced alerting
Matt ColesFeb 16, 2017 11:50 AM (in response to jens.bruckmann)
1 of 1 people found this helpfulCould you show me the screenshot of the Schedule Settings, as I did with mine above? You'll want to go to the Schedule itself, on the the Details page. A radio button will tell you whether it's enabled or disabled.
If it's Disabled, as it should be, then take a look (and attach if you like) the logs.
-
14. Re: Question to advanced alerting
jens.bruckmann Feb 16, 2017 10:14 PM (in response to Matt Coles)1 of 1 people found this helpful