automatic email from spooky? (Full Version)

All Forums >> [Product Help] >> Spooky Login Product Support



Message

travismp -> automatic email from spooky? (4/24/2008 12:10:21)

I use the spooky log-in system for my web. My site has two databases, one for Spooky, one for my client records. I require my users to have an email address in the spooky db. I have 1856 clients. We upload about 500-600 records daily to my records db. Some clients may have one record, while others may have close to a hundred.

Right now we send out an email to each client at the end of the day with the same data that is uploaded. It takes up to two hours of time. I would like to get away from these daily emails at the end of the day and see if I can find a way for the Spooky login system to replace this in-house project.

My question is this:

Can I write a query or something that says look at query “qry_DailyTests” and email them template “template_TESTS” using their email address within the spooky DB? My backend DB has all of the Spooky log in names and the Spooky DB has the same username and then their password.

So if client “Walmart” has 3 tests done today a template would email them saying “You have new tests online, please go review”

I hope this is clear. Thank you.



Spooky -> RE: automatic email from spooky? (4/25/2008 16:38:11)

Are you needing to customize the email (eg with template) so certain details are sent?
Im assuming a generic email would reuire them to login anyway, thus presenting the opportunity to show them the new data via a web page?



travismp -> RE: automatic email from spooky? (4/25/2008 16:46:51)

It could be a generic template that says something like

"You have new records online. Please log into the site to review. Thank you"

My issue is that some of my clients only get a handful of records per year. They do not need to log in daily to check for updates. They only want an email when there is something new posted, which may only be once a quarter.

This way if I upload 250 records for 55 companies today, 55 generic emails would go out, telling them to log in and see their new records.



Spooky -> RE: automatic email from spooky? (4/25/2008 16:59:20)

What I mean though, is your SQL query would check records assigned to companies and only post out those emails where a new record exists.
This custom SQL string can be setup within pop_email_users.asp (open the file and read the info there) but you would need to ensure first the SQL outputs the required values with the JOIN between the owners and records

Otherwise a separate script (using the same SQL JOIN) could be used for the same purpose



travismp -> RE: automatic email from spooky? (4/25/2008 17:14:02)

My DB is an Access DB. I can set up a query in there with all records for today with the [ComUserName] which matches up with [UserName] in the Spooky DB.

Do you have an known examples of a modified "pop_email_users.asp" so I can see an example of that?



Spooky -> RE: automatic email from spooky? (4/25/2008 23:14:18)

It all depends on the SQL
For the custom email script to run, it expects a database output of one record per email address :

EmailAddress
EmailFirstName
EmailUserName


The important (and required one) being the EmailAddress.
So if you can match up todays record and output a minimum of the (distinct) email address, then the custom script within the pop_email_users file will handle it. It would need to be distinct, so irrespective of how many records there are, only one unique email would be produced per batch of records for each user




Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.09375