Hello Everyone,
I was wondering if any of you are using this feature of NScan. I am setting it up to test the triggered email for a future "surprise and delight" concept we are working on. I want to test to see if I actually get the triggered email tonight.
I've followed the instructions in help on setting up a Monitor Individual Attribute on the couple records I am testing and I also set up a contact point purpose that is NScan email with my business email address on my account. Is this really all I have to do? I've made sure that the monitor individual attribute value is in LTR_NSCAN_DEFAULTS and I've added my Tessitura account to LTR_NSCAN_MONITOR_SECURITY (not sure if I needed to for the email notification or not). We do have an attribute that is Monitor Email Attribute but I'm not sure I need to do anything with that as the help document does not reference this attribute.
Is there anything else I need to do to make this work?
Hi Christoper,
You also need to set up a SQL Server Agent job to run the NP_SEND_EMAIL procedure. This is usually scheduled to run every 5 minutes. From the N Scan v6 Installation Instructions document:
The NP_SEND_EMAIL procedure must be scheduled in SQL server to run on a regular basis in order to send N-Scan email notifications. The recommended run interval is every 5 minutes. Documentation on setting up a job to run a stored procedure on a schedule can be found on MSDN at this URL: http://msdn.microsoft.com/en-us/library/ms187880(v=sql.105).aspx
CheersSarah
Hi Sarah,
Thank you for the response. I would have never guessed that needed to happen as well.
Chris
Hey Tom,
Sadly, we're still on 5.XXX version of N-SCAN. Once we make the leap and upgrade, I will look into these new tables and try again. If that doesn't work, I may reach out to you more. :)
Hi Christopher,
That little nugget about setting the email job to run is in the installation documentation, but not in the application guide itself. Stumped me initially as well!
Kelly
Any ideas as to why the LTR Tables were left in the client view of system tables? It's definitely confusing to have them there, seems like they could be removed from view as part of the upgrade since they are obsolete.
Christopher,
If you are now using N-Scan 6.0.5 the names of these tables have changed to TR_NSCAN_Monitor_Security and T_Defaults. The old table names you are showing below were deprecated with N-Scan 5.x.
We also found that the system did not grant us access to the new tables and it took a while to figure out why things were not working correctly.
--Tom
…
718.724.8135
tbrown@BAM.org
From: N-Scan [mailto:groups-n-scan@tessituranetwork.com] On Behalf Of Christopher CuhelSent: Tuesday, December 15, 2015 2:21 PMTo: Thomas Brown <tbrown@bam.org>Subject: [N-Scan] Patron Entered Triggered Emails
I often wonder that but honestly have no idea. I would suggest submitting a TASK ticket for an enhancement request to have those unused tables removed.