James Campbell
going with the flow
Posts:57
 |
| 09-02-2010 09:06 PM |
|
Impossible, I just sent this:
 |
|
|
|
|
James Campbell
going with the flow
Posts:57
|
| 09-02-2010 09:27 PM |
|
Do you think this is because the email with the tracking image is shown in the logs????? |
|
|
|
|
James Campbell
going with the flow
Posts:57
|
| 09-02-2010 09:28 PM |
|
I still do not get why every email is shwon in the log, what kind of log is that, we should options to only show who it was sent to, when it was sent etc, in text, not my whole html email with images and all.... |
|
|
|
|
James Campbell
going with the flow
Posts:57
|
| 09-02-2010 09:44 PM |
|
Sent another, same issues, using tracking(image) as stylesheet doesn't work at all.and BTW this is a different email and different list:
 |
|
|
|
|
James Campbell
going with the flow
Posts:57
|
| 09-02-2010 11:44 PM |
|
Oh, I see, Full body logging was on. I turned it off, now how do I delete the log? |
|
|
|
|
James Campbell
going with the flow
Posts:57
|
| 09-03-2010 09:19 AM |
|
Now today when I send out emails a simple test with just myself on it, it says it failed, but I get the email, click to show images and no stats change and it still says it failed. Any ideas? |
|
|
|
|
James Campbell
going with the flow
Posts:57
|
| 09-03-2010 09:35 AM |
|
All the sudden it is now only showing 5 items or so in the log, all without the body. I didn't check the box but it looks like the setting finally took , my clear import log link is still working but it looks like the log has been truncated. |
|
|
|
|
Chad Nash
Posts:5260
|
| 09-03-2010 09:39 AM |
|
James,
We recently found the issue to this and will need to add some enhancements into the Stats reporting area.
Basically what we found out is that the 'Failed' statistics are only showing up for the entire failed table, meaning that the failed statistics are not failed just for the specific newsletter. So, the system checks the failed table and sees those emails so it shows them as failed.
The reason this happens is because typically when a failed email exists it fails all of the time, this is usually if an email didn't have an @ symbol or missing a . etc.. What we found in some cases though is that it failed at one point because of another newsletter or maybe invalid email settings and so from then on for all newsletters it will verify and show the invalid failed email.
So we need to change this to find only failed emails for this specific newsletter, this could be a query change however the problem here is that whenever an email is marked as failed we don't currently store the newsletterID so this is why we have to add the enhancement.
Thanks,
Chad
|
|
|
|
|
James Campbell
going with the flow
Posts:57
|
| 09-03-2010 09:54 AM |
|
Could you provide a query that can delete all failures for now, or can I just do it myself in one table?
One of my first runs, there was a smtp server issue, not allow 200 at a time, so everything failed. |
|
|
|
|
Chad Nash
Posts:5260
|
| 09-03-2010 09:57 AM |
|
Oh... Yes, actually you should be able to clear them directly in the control panel under Reports for failed emails.
Otherwise...
DELETE FROM DataSprings_OptInFailedEmails
Thanks,
Chad
|
|
|
|
|
James Campbell
going with the flow
Posts:57
|
| 09-03-2010 02:18 PM |
|
Once I added that sp you posted:
CREATE PROCEDURE [dbo].[DeleteScheduleHistory]
@TypeName nvarchar(255)
AS
delete from ScheduleHistory where ScheduleID in (select ScheduleID from Schedule where TypeFullName=@TypeName)
It now deletes, but the link says clear import log, should change that to clear log instead or something. |
|
|
|
|
Ryan Bakerink
river guide
Posts:1900
|
| 09-07-2010 08:20 AM |
|
Hello James,
Thank you for your input on the link, we can evaluate this and send it to our dev team to see if this would be a good implementation.
Thanks,
Ryan |
|
|
|
|
Chad Nash
Posts:5260
|
| 09-07-2010 09:14 AM |
|
Hi James,
Thanks for your input... Yes I agree that it should change. I think this area of code is/was also used in the Interactive User Import so its mislabeled when it was brought over. Ill have it fixed for the next release.
Thanks,
Chad
|
|
|
|
|