I have a small email newsletter (100% double-opt-in, less than 400 subscribers) that we publish with CDO.Message and CreateMHTMLBody (on Win2k server, so we are using CDONTS).
We are using CreateMHTMLBody because the newsletter is dynamically generated, pulling data 3 different data sources, otherwise it would be a cinch to use the existing tracking bug we utilize on simpler mailer that runs with CDO.NewMail and manual composition of the HTML code.
Anyone got much of a clue how best to send emails to selected people from a database table and to be able to track them, maybe as much as a read receipt, or perhaps just checking that they don't bounce, or end up in the bad mail folder.
Is this best/possible to try and code or is there a free/cheap component that does this simply.
I am currently developing a final year project which is a web based tracking system tracking exam questions. I am using IIS as the server, MS access for the database, and ASP with VBScript for the scripting side of things.
One of the things I want to do would be to e-mail a user/moderator whenever a exam question is edited/completed/updated. does anyone have any previous expierence in this? i don't even know where to start.
It's an ASP-built Intranet app, so I can't show you the site, but I'll show you screen shots if you think that will help. The app is to keep track of issues called in to a Support help desk. These issues are called tickets. Each ticket has one and only one row in this given table (let's call it Ticket). Any additional info on a ticket will be entered into another table (called History), so it's possible to have many rows in that table for each one in the table I am focusing on.
The app in question uses SQL Server 2000 as its datasource. The table contains info entered when a ticket was created, but I have included a mechanism for users to go back and change info that was originally entered. This leads me to my dillemma. The boss wants me to find a way to keep up with changes to that original info. It seems logical to keep this info in another table. Let's call this new table Audit.
I have explored using a trigger which would create a row in the Audit table whenever an Update was used on the Ticket table. The problem with that is, you have one row per changed field, and that could add up. Actually, it's not a problem, just something to consider.
The alternative is to have ASP code which would, when any edits are made, manually compare each new value in the form to each existing value, and record those items which have changed. This seems like it would put a lot of work on the web server. There are generally maybe 10 people using this app at any given time, so that may or may not be important.
For the record, the Ticket table has about 40 fields. The PK is a single field, and it's an Identity with type int. Most of the other fields are int, as they contain FKs that point to values contained in statics tables. There are a few tables of type varchar, and 3 fields which contain large amounts of data, as they are description fields. Users type in up to 3000 characters here, but it's typically a few hundred characters.
there is a form(ex=subscribe.asp) which is an asp page where users can sign up for newsletters. this asp file calls a php file in the form action which i have written and this php file processes information user entered and inserts to the database. this works fine. in the website there are numerous pages from which a user can click on an image and be redirected to subscribe.asp and fill in the form.
I need to know which page the user was before subscribe.asp ex = aboutus.asp, contactus.asp etc. is there a way i can pass information from this subscribe.asp file to the php file which the php file can read and find out the source of the previous page (ex= aboutus.asp, contactus.asp etc).
anyone know a good way of tracking an email so that i know if theyve been opened? and preferably somethign where i can identify the recipient (matching with our crm)?
My goal is to be able to advertise on different web sites i.e. fortune.com, wsj.com, etc. and when a prospect clicks my ad/link they are sent directly to a contact form that I've created where it will automatically populate a field "referral" with the referring url (wsj.com, etc.) as where the user came from.
However, not all my leads/prospects will be coming from referral urls and searches. Some might be going directly to my web site via www.mydomain.com. Therefore, when a prospect comes that way, the ASP contact form should adjust to compliment that prospects entry. So, the "referral" field would be a drop-down that has these options:
And, if the user chooses "option 2" another select box appears with a list of publications, i.e. Forbes, Business Week, Fortune, Leaders, etc. And, if Option 4 is chosen, then Employee, friend, owner, and other would appear in a select box.
Currently, I have the contact form working so that the user must specify where he/she came from as I described it above. I am simply looking for a piece of code to automate the referral process if a prospect comes from an online ad or specific url (i.e. www.mydomain.com/coupon1).
direct me on the right road to doing link tracking. Im trying to create a system for my website, where as you click on a link or image on my webpage, you get directed to the detail page and also at the same time increment up the hitcount on that link.
I tried to use a onclick function, but since that is client side code it didnt work. The idea behind it is to get my products displayed to my customers, with the most popular items first. This seemed so simple when i set out on this project, but right now ive hit a wall. Im using dreamweaver, have got quite a good knowledge of ultradev and all that goes with it. Is there a way in dreamweaver for me to do this?
I am trying to create a website for students where they have to log in before they can access any of the materials on the site. Therefore the login will be done on the homepage. Providing log in is successful, I then want to be able to track which student downloads which materials. I know how to deal with the login code but am not sure when I create the session variables to track the users. Is this done on the following page? Also do I need to use the global.asa file?
does the session on start event happen the minute the student arrives at the homepage or can I tell it to start once the students have logged in? any advice will be gladly received.
I am developing an intranet site for my customer and i have faced a problem with session tracking. Many files added as include files and i found me unable to track session between two pages. I tried it with applying many logics but it failed.
There might be some sily mistake happaning by me but i can't track it. Give me idea about this. Is session variable does not work in include files?
Is it possible to track where a user is going from a page? My goal is to be able to tell if a user is going to a new page inside my domain vs them going to an outside link - and have an alert box appear if they are going to an outside domain name.
I currently have a bit of JavaScript that I add to all the links within my page that when click alert box is avoided, but if they go to a link without that code (via Address Bar in the browser, back button, and refresh button) they get a alert box.
I'm designing an online shopping cart using ASP. I want the flexibility of session tracking by using URL rewriting but I don't know how I would go about this.
I'd like to know how I would go about storing and retrieving session data (i.e. product items + their quantities) using URL rewriting? Code:
I wonder how I would go about an email tracker using ASP. I need this for the database to capture all unsubscribe requests. For instance, someone emails "unsubscribe@domain" I should be able to catch that email, get who emailed it and record that to my unsubscribe table. Also I am using a a commercial mail server (ability mail server) and not the virtual smtp server which comes along with IIS.
I am just starting in asp and would like to get an image to follow the cursor (ie if the cursor was at x=100,y=100 then the image would be x=10,y=10) and would move as if locked to the cursor.
I have a site with a login page and several dozen secured pages behind it. The user data is in an Access Database. The client wants to add some specific tracking features. I haven't started working in it yet, so I don't have any code.
This is more of a planning phase and I wanted to make sure I wasn't going down the wrong path from the beginning.
1. The primary goal is to track the number of times each user logs in during the course of a month. They want to keep track of 3 months worth of information. After that, each new month would overwrite the oldest month.
The login code is pretty standard stuff - check for a match in the database and create server variables.
I'm thinking I'll need to add a table to the database with a field for UserID, a date field and a numerical field. When the user logs in, the page will need to check and see if a record exists for this user and this month in the table.
If so, it will update the record by incrementing the numerical field and updating the date field. If no record exists for this month, it will create a new record. This part I'm pretty sure I can handle. I'm not quite sure how to automatically overwrite the oldest month when the number of records per user is greater than 3.
Any thoughts on the best way to do this? 2. As a secondary goal, they wanted to see if it was possible to track which pages each user was going to while they are logged in. I don't have the foggiest idea how to do this. Any ideas?
I have built a site where users make a purchase, but in order to make a purchase they need to log in. If they are not logged in they are directed to the login page. This all works fine. Here is the issue.
If they select an item to purchase and are not logged in and they are redirected to the login page, after successful login I want them to be redirected back to the link they selected to get to the login pagin. So if they select a widget to purchase and they log in the system will direct them to that widget.
I know this is done with session variables but I have no idea how to accomplish it. I did notice that this site does the very thing I want to do except I am working in ASP with an Access 2000 database.
I have currently deployed an online marketing initiative for a web site and I was looking for a way to use javascript to track link-throughs from my online ads. I have been told that it can be done by setting a cookie for the web site visitor(s).
So, this is the entire process that I am looking at capturing:
[1]Wall Street Journal online ad - visitor clicks through to my landing page (www.mysite.com/widget)
[2]My site sets a cookie for that visitor.
[3]If that visitor goes to my contact page (www.mysite.com/contact) he/she fills out the form and sends it (using ASP to send form);
[4]I receive the visitors contact information as well as the destination from where he came from i.e. wall street journal or google.com, etc.
Here's the code so far that I have. I believe I am basically just getting a cookie and setting it. I need help with transferring the cookie within the contact form.
guide me towards a script that can handle bounced emails from a newsletter campaign. I am not interested in .Net solution. The mail server is Exchange 2003 if that helps. Right now clueless about tracking of bounced emails.
I have a login page that posts to an asp page and uses a security.inc and database for the security on the site. I'm looking for an effective way to track who is logging into my site. each user has a specific username and password that is checked against the database. How can I find out which of these users are actually logging onto my site?
I need some help: with cdosys i'm able to send e-mail from asp using the local exchange server. Now I also have to save the sent mail into the user's mailbox for future reference: how to?
let me preface this question by telling you that I cut cable and fix printers. I avoid web stuff whenever possible. But alas, my wealthy benefactors insist . . .
I'm hopefully to the last step in cookieless user-id tracking for file downloads. Here's where I am:
To download such-and-such, user enters their email addy on a form.
Form posts email to an access db which generates a user id
iis creates a link http://domain/downloadid=userid and sends it to the email address entered
At this point I no longer know what to do. Understand that that the above constitutes a poorly modified address book. Here are the caveats for this project:
If you@you.com downloads a file, I want a tick in the db. Be that adding the filename or other marker to your db record or a whole other media-list table that adds your id. Whichever is the simplest.
I'm totally good if it's a dreadfully loose way of tracking (even fake ids would be permitted and tallyed in the db as fake). I'm more interested in usage stats than protecting any of our golden audio files. Hopefully, this very spartan system could become a way to grow some trending data, like "everybody that downloaded X also grabbed a copy of Y" and so forth.
My iis/asp/access knowledge consists of exactly the things I've been forced to do so far. If this is just too cheeseball of a question, feel free to point me to the right chapter in your favorite book and I'll go buy it! My Googling for this one have been returning about 3/4 of the entire internet, so I decided to just ask.
I have an important question to ask about how to trap events when the user close the browser window.
I'm a ASP programmer and I have s MSSQL database with a user table where I'm able to track if the user is logged in or not.
However this is not easy to track if the user close the browserwindow without using the logout button. I have tried putting in code in Session_onend, but it doesn't seem to run if the browser is closed. Eg. tracking visitors in a application variable in Session_OnStart and Session_OnEnd. Code:
I am a system administrator whom has been charged with the logging of user activities on my network. I want to track when a user logs into a machine, logs out of a machine or locks a system.
Is there an application out there that I can run on my server or a client based app that anyone knows of? Or do I have to make this from scratch?
I'm using CDO to send mail to the site owner from ASP pages with forms. Recently one of my forms is occasionally sending email with what seems to be an insertion which is replacing the plain text part of the email with something else. Looking at the server sent email source, the hacked emails have the following:
this is dependant on whether or not I can get my sessionID. This is assigned by the server yes?
so...when I log in, I query what my session ID is, and then store that in a DB along with a flag that says I'm logged in.
now, along comes someone else who has me in their buddy list, I think I can query the sessionIDs and remove any records from the DB where the sessionID no longer exisits. (not sure how yet but I'll work on it).
Then the second user will query the DB to see if I have logged in (and a sessionID still exists). if so, his buddylist will show me as logged on...although it could be 20 mins out of date, it's getting closer to the real thing. Code:
I'm looking at the various free and paid website traffic tracking options available. None seem to do quiet what I want and the rest are too expensive.
I'm already using asp with an sql database on my site so I'm thinking how hard could it be to program my own traffic tracking? Anyone have any ideas or better yet code! for such a thing?
Here's the scenario. I'm currently using cdosys/asp to send mail to our SMTP server. We use a product called MailFilter to check for SPAM. It doesn't work very well. If MailFilter isn't working cdosys also has problems and emails don't get sent. As these email are confirmations for customer's bookings this means lots of customers calling to see where their confirmation emails have gone. The root of the problem is MailFilter but that here to stay. So I had this thought of sending the message to a queue of some sort so at least they will get to the customer eventually rather than being lost for good. So here's the question:
Can I/How do I send messages to a mailbox on our exchange server using cdo.message?
I'm using CDO from my vb component to fire email. The problem is whenever one of the email addresses in to, or cc is wrong then none of the mails are fired even to the correct addresses. It gives an error like
The server rejected one or more recipient addresses. The server response was: 550 Relaying denied for <xfd@wre.com>
My code goes like this. Why is the mail server trying to look for the validation of email ids??I want that atleast the mail should be fired to the correct email addresses rather than no email fire. Can i achieve that.
Dim iMsg As New CDO.Message Dim iConf As New CDO.Configuration
Set iMsg.Configuration = iConf With iMsg .To = strToEmail .From = strFromEmail .CC = strCCEmail .BCC = strBCCEmail .Subject = strMailSubject If strMailFormat = "TEXT" Then .TextBody = strMailBody Else .HTMLBody = strMailBody End If If strAttachment <> "" Then .AddAttachment strAttachment End If If intPriority = 2 Then .Fields.Item("urn:schemas:mailheader:X-Priority") = cdoHigh .Fields.Update End If