Forums / Addon Admin Tools / Email Archive Manager

Email Archive Manager

Views: 65,744

Results 81 to 100 of 209
15 Apr 2010, 6:06 PM
#81
gothstone avatar

gothstone

Zen Follower

Join Date:
Jun 2005
Posts:
330
Plugin Contributions:
0

Email Archive Manager

Now I get it. The goal is to break html that can't be used inside another page, but fix the rest. I think I have it now, all my tables are corrected, and I don't see any code anymore. Here is my rewriten section:

      if ($action=='prev_html') {
        $html_content = $this_email->fields['email_html'];
        $html_content = str_replace('__','><',$html_content);
        $html_content = str_replace('_html','<html',$html_content);
        $html_content = str_replace('_base','<base',$html_content);
        $html_content = str_replace('_table_','<table>',$html_content);
        $html_content = str_replace('_table ','<table ',$html_content);
        $html_content = str_replace('_/table','</table',$html_content);
        $html_content = str_replace('</table_','</table>',$html_content);
        $html_content = str_replace(array('_tr_','_tr>'),'<tr>',$html_content);
        $html_content = str_replace(array('_/tr_','_/tr>'),'</tr>',$html_content);
        $html_content = str_replace(array('_td_','<td_'),'<td>',$html_content);
        $html_content = str_replace('_td ','<td ',$html_content);
        $html_content = str_replace(array('_/td_','_/td>','</td_'),'</td>',$html_content);
        $html_content = str_replace('"_','">',$html_content);
        $html_content = str_replace('_ ','> ',$html_content);
        $html_content = str_replace('_li>','<li>',$html_content);
        $html_content = str_replace('_div ','<div ',$html_content);
        $html_content = str_replace('_/div_','</div>',$html_content);
        $html_content = str_replace('_/div','</div',$html_content);
        $html_content = str_replace('</div_','</div>',$html_content);
        $html_content = str_replace('_strong_','<strong>',$html_content);
        $html_content = str_replace('_/strong_','</strong>',$html_content);
        $html_content = str_replace('strong_','strong>',$html_content);
        $html_content = str_replace('_/strong','</strong',$html_content);
        $html_content = str_replace('_!','<!',$html_content);
        $html_content = str_replace(array('_br_','_br /_','_br />','_br /','<br /_'),'<br />',$html_content);
        $html_content = str_replace('_style','<!-- style',$html_content);
        $html_content = str_replace('_/style_','</style> -->',$html_content);
        $html_content = str_replace('em_','em>',$html_content);
        $html_content = str_replace('_/em','</em',$html_content);
        $html_content = str_replace('_img ','<img ',$html_content);
        $html_content = str_replace('_a href','<a href',$html_content);
        $html_content = str_replace('_sup_','<sup>',$html_content);
        $html_content = str_replace('_/sup','</sup',$html_content);
        $html_content = str_replace(array('_/a_','_/a>'),'</a>',$html_content);

        $html_content = str_replace(array('<html>','</html>','</html_','_/html_'),'',$html_content);
        $html_content = str_replace(array('<head>','</head>','_/head_'),'',$html_content);
        $html_content = str_replace(array('<body>','</body>','_body_','_/body_'),'',$html_content);
        $html_content = str_replace('"_','">',$html_content);
        $html_content = str_replace('_nobr','<nobr',$html_content);
        $html_content = str_replace(';nbsp;',' ',$html_content);
        $html_content = str_replace('&','&',$html_content);
        $html_content = str_replace('&amp&','&&',$html_content);
        $html_content = str_replace('& ',' ',$html_content);
        $html_content = str_replace('"','"',$html_content);
      }

2 + 2 = 5 for extremely large values of 2

Pez Collectors Store •••••••• My Plugins List

27 Jul 2010, 9:30 PM
#82
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Email Archive Manager

(From a PM)

Great Contribution! I'm having trouble using the Email Archive Manager, it does not display any emails. The page isnt broken, just not doing anything.

By default nothing shows up, you have to perform a search in order to get results. Are you able to load the page and perform a search?

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

27 Jul 2010, 9:42 PM
#83
mateogp avatar

mateogp

New Zenner

Join Date:
Sep 2007
Location:
Frankfort, Illinois, United States
Posts:
21
Plugin Contributions:
0

Re: Email Archive Manager

Thanks for your quick reply!

The page renders fine, doesnt display any errors. However there is no search field. All I get is the normal top of the page and bottom, but no content. I checked to make sure there was emails in the archive and there are. Any ideas what I can do to fix it?

I'm using Zencart 1.3.8a.

Thanks!
Matt

28 Jul 2010, 6:29 AM
#84
bidgee182 avatar

bidgee182

New Zenner

Join Date:
May 2010
Posts:
29
Plugin Contributions:
0

Re: Email Archive Manager

Hi

I installed Email Archive manager and when i view emails in HTML this is what i see.......... It seems to be pulling the css in from the email welcome template

How do I remove this??

Thanks

28 Jul 2010, 2:27 PM
#85
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Email Archive Manager

mateogp:

The page renders fine, doesnt display any errors. However there is no search field. All I get is the normal top of the page and bottom, but no content. I checked to make sure there was emails in the archive and there are. Any ideas what I can do to fix it?
Re-upload the files. It sounds like either they got corrupted during transfer, or you put them in the wrong place.

Bidgee182:

I installed Email Archive manager and when i view emails in HTML this is what i see.......... It seems to be pulling the css in from the email welcome template

How do I remove this??
Have you made any customizations to your email templates?

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

10 Aug 2010, 12:30 AM
#86
rlexyd avatar

rlexyd

Zen Follower

Join Date:
Nov 2006
Location:
Sydney, Australia
Posts:
478
Plugin Contributions:
0

Re: Email Archive Manager

Hiya Frank,

Just wondering if you can help me.

I am using your Email Archive Manager which is Great :) in my Zen-cart 1.3.9 and it seems to be working fine, guess it doesn't need to be updated to the latest 1.3.9 version :)

The only problem I am getting is when I click on (Trim Email Archive), it's deleting all the emails, even ones that are new and only a few days old!

I have changed the dates on my website to suit the d/m/y. Would that be the problem? if so what do you think is the fix?

Hope you can help.

Best Regards,

*Zen Cart eCommerce Solution - Putting the Dream of Owning an Online Business within reach of anyone!

12 Aug 2010, 5:41 PM
#87
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Email Archive Manager

Glad you like it, rlexyd. :bigups:

The Trim functionality doesn't even look at your date formats. Since the date selections are preset radio buttons (1, 6, or 12 months), there's no date to enter, so the code just automatically puts the date in MySQL format. If you didn't touch the code in the addon you should be fine.

Assuming you didn't touch the code, let's do a test. Make sure you've installed the latest version of Email Archive Manager from the addon section. Then open email_history.php, and find this code at line 60:

$db->Execute("delete from " . TABLE_EMAIL_ARCHIVE . " where date_sent <= '" . zen_date_raw($cutoff_date) . "'");

Just above that line, enter the following code:

$sql = "delete from " . TABLE_EMAIL_ARCHIVE . " where date_sent <= '" . zen_date_raw($cutoff_date) . "'";
die($sql);

Save and upload the file to your /admin directory.

Now perform a trim, any date range. When you do, the page will come back blank with just the SQL query listed at the top. Copy and paste that query into a response post on this thread.

When you're done, go back into email_history.php and undo the changes described above. You can simply comment out the new lines and uncomment the original.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

12 Aug 2010, 11:32 PM
#88
rlexyd avatar

rlexyd

Zen Follower

Join Date:
Nov 2006
Location:
Sydney, Australia
Posts:
478
Plugin Contributions:
0

Re: Email Archive Manager

Hello Frank,
Thank you for your reply.

I did as you asked, here is the query:

delete from zen_email_archive where date_sent <= '20101307'

Just wondering, shouldn't the date have shown up as 20100713?

Hope you can solve this.

Best Regards,

*Zen Cart eCommerce Solution - Putting the Dream of Owning an Online Business within reach of anyone!

18 Aug 2010, 9:46 PM
#89
rlexyd avatar

rlexyd

Zen Follower

Join Date:
Nov 2006
Location:
Sydney, Australia
Posts:
478
Plugin Contributions:
0

Re: Email Archive Manager

You there Frank??

*Zen Cart eCommerce Solution - Putting the Dream of Owning an Online Business within reach of anyone!

19 Aug 2010, 6:37 PM
#90
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Email Archive Manager

Sorry, went underground dealing with some non-Zen Cart stuff.

You're right, that date isn't correct. I'll look into this further.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

19 Aug 2010, 10:33 PM
#91
rlexyd avatar

rlexyd

Zen Follower

Join Date:
Nov 2006
Location:
Sydney, Australia
Posts:
478
Plugin Contributions:
0

Re: Email Archive Manager

I'm sure you are busy and I appreciate ur help :)

Cheers,

*Zen Cart eCommerce Solution - Putting the Dream of Owning an Online Business within reach of anyone!

25 Aug 2010, 12:39 PM
#92
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Email Archive Manager

rlexyd, how exactly did you go about changing the date format?

Did you follow the instructions in this FAQ article?

https://www.zen-cart.com/tutorials/index.php?article=401

Did you make any date-related edits to email_history.php?

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

25 Aug 2010, 9:59 PM
#93
rlexyd avatar

rlexyd

Zen Follower

Join Date:
Nov 2006
Location:
Sydney, Australia
Posts:
478
Plugin Contributions:
0

Re: Email Archive Manager

Hiya Frank,

Yes, I followed the instructions from that link to change the dates.

Also, after the Trim email archive was Not working, I did attempt to alter the dates from the email_history.php and it didn't make a difference, so I just replaced it back with the original file!

You can check an image snapshot of what happens when I go to trim email archive, emails are only a week old and it still deleted them all.
(http://a.imageshack.us/img26/6650/eamerror.jpg)

Hope you can help figure out what's causing this and how to fix it :)

Best Regards,

*Zen Cart eCommerce Solution - Putting the Dream of Owning an Online Business within reach of anyone!

15 Sep 2010, 8:00 PM
#94
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Email Archive Manager

From your screen shot it looks like everything worked as expected. You had several emails all within a few days of each other, you chose to delete them, and they were gone. Is there something there that I'm missing? You'd need one or more emails older than a month to see any issues with the delete process.

An updated version has been posted on the add ons page. It includes the code changes I recommended to you in packaged form. In addition to a larger test set, you may want to give that package a try.

http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=198

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

15 Sep 2010, 10:57 PM
#95
rlexyd avatar

rlexyd

Zen Follower

Join Date:
Nov 2006
Location:
Sydney, Australia
Posts:
478
Plugin Contributions:
0

Re: Email Archive Manager

Hi Frank,

Thanks for your response.
I am not sure how you missed what I meant?

Your Mod's Trim feature is suppose to DELETE specific emails which have been received for a certain time period, the 1st option being (Delete e-mail older than... 1 month)!!
When I click on the (Delete e-mail) button, it Deletes ALL the e-mails, Even E-mails which were only Received a couple of days ago!!

Hope you get what I mean now?

Best Regards,

*Zen Cart eCommerce Solution - Putting the Dream of Owning an Online Business within reach of anyone!

16 Sep 2010, 7:17 PM
#96
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Email Archive Manager

D'oh, total brain fart on my part. You're right, I'll take another look.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

16 Sep 2010, 7:26 PM
#97
blindside avatar

blindside

Totally Zenned

Join Date:
Sep 2004
Posts:
1,237
Plugin Contributions:
1

Re: Email Archive Manager

Okay, better idea. I'm going to circumvent Zen Cart's date conversion code entirely and let MySQL do the math. That way it doesn't matter what date format you use.

Look for a new v1.6 later this evening.

Frank Koehl
"Cleverly Disguised as a Responsible Adult"

frankkoehl.com

22 Nov 2010, 3:07 AM
#98
eaglewu avatar

eaglewu

New Zenner

Join Date:
Jan 2007
Posts:
82
Plugin Contributions:
0

Re: Email Archive Manager

This is what customer got when I click resend msg:

$EMAIL_SUBJECT
$EMAIL_MESSAGE_HTML
$EMAIL_FOOTER_COPYRIGHT
$EMAIL_DISCLAIMER
$EMAIL_SPAM_DISCLAIMER
$EXTRA_INFO

text preview works fine. html preview doesn't. it looks like:

body {background-color:#ffffff; color:#000000; font-family:Verdana, Arial, Helvetica, sans-serif; text-align:center;} a:link {color:#0066cc;} a:hover {background-color:#eeeecc; color:#0066cc;} a:visited {color:#0066cc;} .holder {background-color:#f9f9f9; border:1px solid #9a9a9a; font-size:9px; text-align:left; width:550px;} .header {font-size:10px; padding:0px; width:550px;} .content {font-size:10px; padding:5px; width:550px;} .footer {border-top:1px solid #9a9a9a; font-size:9px; text-align:center; width:550px;} .extra-info {background-color:#cccc99; border:1px dashed #9a9a9a; font-size:10px; margin-top:10px; padding:5px; width:550px;} .content-line {padding:5px; font-size:10px;} .content-line-title {font-weight:bold; font-size:11px; padding-top:3px;} .order-detail-area {background-color:#CCCC99; border:1px #9a9a9a; width:542px; padding:2px; font-size:10px; } .product-details {font-size:10px;} .product-details-num {font-size:10px; font-weight:bold;} .order-totals-text {font-size:10px; font-weight:bold;} .order-totals-num {font-size:10px; } .comments {background-color:#FF6699; border:1px #9a9a9a; width:542px; padding:2px; font-size:10px; } .address-block {background-color:#E4E8F3; border:1px solid #9a9a9a; margin-top:3px;} .address {font-size:10px;} .payment-detail, .payment-footer {font-size:10px;} .extra-info {background-color:#cccc99; border:1px solid #9a9a9a; font-size:10px; margin-top:10px; padding:5px; width:550px;} .extra-info-bold {font-weight:bold;} .disclaimer {background-color:#f9f9f9; border:1px solid #cccccc; font-size:10px; margin-top:10px; padding:5px; width:550px;} .disclaimer1 {color:#666666; padding:5px;} .disclaimer1 a:link {color:#666666;} .disclaimer1 a:visited {color:#666666;} .disclaimer2 {color:#666666; padding:5px;} .copyright {border-bottom:0px solid #9a9a9a; padding:5px;} .order-licences-area{background-color:#DDDDAA; border:2px #9a9a9a; width:542px; padding:2px; font-size:10px; } .licences_code{font-weight: bold; font-size: 12px; font-family: monospace;}

My zencart 1.36, email archive latest

What should I do?

22 Jan 2011, 12:26 AM
#99
novastar avatar

novastar

Zen Follower

Join Date:
Jul 2009
Posts:
127
Plugin Contributions:
0

Re: Email Archive Manager

Any time I hit the search button it takes me to the log in screen. I did a fresh install of zen cart, installed this mod and I get the same error. Any solutions?

2 Feb 2011, 1:00 PM
#100
kevlar441 avatar

kevlar441

New Zenner

Join Date:
Dec 2010
Posts:
3
Plugin Contributions:
0

Re: Email Archive Manager

I'm a newbie and I feel like an idiot because I have installed Email Archive Manager 4 times and it still does not appear in the tools menu. I do have Email Archiving active and I have sent numerous emails. Still nothing. I recently upgraded to 1.39h and am using the old Sophie Blue template.

I thought I felt confident I put all the files in their proper places. Any ideas?