Yep, that's true. If you wanted it to come through, you'd need to build in some logic to convert those characters into HTML. I don't know of an easy way to do that, since I think you'd need both open and close tags to do it..
A long regex would do it, I think.
How do I ensure that I do not send notifications for the same comment twice, while also not missing out on any comments?
Let's say my subscription schedule is running every 30 minutes:
- Scheduled subscription task runs at 10:00am
- Comment is left at 10:01am
- Scheduled subscription task is created at 10:30am, but is delayed until 10:32am
- Comments left before 10:02am are filtered out
Am I missing something?
I like to use the "Previous 15 minutes" calculation technique:
This allows you to run a VizAlert every 15 minutes, that always looks at the previous quarter hour's worth of data. So your alert runs at 10:00 am, it checks all comments sent from 9:45am-10:00am. If it runs at 10:05am, it still checks comments sent from 9:45am to 10:00am, instead of comments sent 9:50am to 10:05am. It can run up to 15 minutes later with no misses and no duplicates (so long as it runs successfully!).
I implemented a Comment notifier alert several weeks ago because I was tired of having people comment on vizzes and no one knowing about it. It's been working fairly well so far. I'll post a version here, but it'll need to be a 10.0 version (that seems like it should be pretty universal these days, right? )
Attached is what I'm using, version 10.2.0. VizAlerts run every minute on my Server. Very basic but gets the job done. I'm sure Matt's will be fancier and friendlier than mine
CommentAlerter.twb 214.3 KB
I updated with my new and improved version. It's 10.0. If anyone uses it, be sure to switch it with your own branding to avoid copyright infringement!
Note--if you grabbed the version I posted earlier today, don't use it! Use the new one I just published instead. I inadvertently left in the "Email BCC" to my own email address, which I use to monitor that the commenting logic is behaving as I expect. But I don't want any emails from you, please, so make sure you get the current version, not the one from this morning. By the by, this is another good reason to make sure you're setting your default_allowed_recipient_address appropriately!
I tried this but there is no e-mail
When I enter the our server as a server name, there is a blank in left-side. But when I enter different thing, as you can see in the picture, I can see the output. Although I made comment on different workbooks, it shows only the comment which I made it on VizAlertsConfig workbook.
What is thing that I make wrong?
Thanks for your help and sorry for my english, i know it's not very good.
So, this is a fairly complex alert. The alert will only show comments that were entered in the previous quarter hour time window. So if it is currently 9:31, it will show comments entered between 9:15 and 9:30. If it is currently 10:29, it will show comments entered between 10:00 and 10:15. So your comments may not immediately show in the viz. The alert is meant to run every 15 minutes, so that it can send out the comments as quickly as possible, and so that the schedule aligns with the time window. So if you haven't already tried this, try publishing it up, subscribing on an every-15-minutes VizAlerts schedule, and then go and enter a bunch of comments on vizzes.
Note that if you comment on a viz you yourself own, and no one else has commented on it, then you will get no emails, because you already know what you wrote--why should it tell you again? But if you comment on someone else's viz, the owner will get an email. And anyone else who has commented on it in the past.
Matt Coles wrote:
...Note that if you comment on a viz you yourself own, and no one else has commented on it, then you will get no emails, because you already know what you wrote--why should it tell you again? But if you comment on someone else's viz, the owner will get an email. And anyone else who has commented on it in the past.
Clever, I like it!
First of all, thank you so much for your detailed answer. I will tell
you what I've done.
As you said, I added subscription (VizAlerts - 15 min) to 2 workbooks.
(one is my workbook and the other one is Comment Alert workbook of
VizAlerts-- cause I was not sure)
Then, I put comment on my workbook. This workbook published by admin and
mail address is mine. But when I put comment, I used another server user
with different mail address.
After 15 mins, I got 2 mails which are subscription mails. But there is
no comment mail again
I add the screenshot of the mail.
Sorry for that I am stealing your time. But I need to succeed it.
Thanks for your help.
This is a common problem. This happens when you haven't got your VizAlerts schedules set up correctly. Make sure that the schedules are disabled, as is described in the Install Guide. You can tell whether they are set up correctly by looking at your VizAlertsConfig\ScheduledTriggerViews viz. If you see data there, then you've done something right. If you don't see anything, but you know you subscribed to the VizAlerts schedules, then something is still wrong.
Let me know if that helps.
I had a little break to working on comment alert, I tried other things on VizAlert. Now I am trying again this and I have still problem :)))
I share screenshots again. As you can see, I can see my comment on Comment Alert workbook. But there is no mail. My config workbook settings is like on the screenshot. Maybe problem is on this workbook.
I changed the calculation "allowed_from_address". Now you see an address -my commentor's address- in this calculation but before this, I tried .*@karadanismanlik\.com\.tr but it did not work.
Why I cannot get mail? I am waiting your help. Thanks.
((VizAlert runs as requested. It's disabled and I scheduled on Task Scheduler)