I would like to know how many people have opened that email. The idea is count the number of times the image is loaded in the mail box. and in the "download_my_files" procedure I write an insert statement to insert one count each time the image is loaded.Are you using "download_my_files" to record the number of accesses for the files for later processing on the database server, or are you hoping to dynamically update your users email with that count?
Since it is inserted as a html text, I am not able to capture the image download hits or how many times people have opened the mail.
Thanks AndyH for the reply. I am using "download_my_files" just to record the number of accesses for the files for later processing on the database server.
But when I add the html code as a text which includes image file links and some text, as I mentioned in my first post-- it is pasted as a content on the mail body. It doesn't contain the link to the file in the apex server.So, the problem has nothing to do with your 'download_my_files' package, it sounds like you are not creating your email correctly. What code are you using to do this?
archana2 wrote:OK, how many of the original recipients have opened the mail when your table contains the following counts?
If i send the same mail message to 10 people, and 9 ppl open that mail, i should get a count of 9 in my table <where i insert the count >.
archana2 wrote:Why? What use is this? It doesn't tell you that any of the original recipients have actually read it. A hit could be from someone who received an autoforward or from an anti-virus scanner.
For the time being we are trying to collect just the number of times an email is opened - if the counter says 10- means 10 times it is opened. It could be one person opened it ten times or ten people opened it one time ..We are not capturing the IP .As of now no unique hits are captured.