Jump to content


Corporate Sponsors


Latest News: (loading..)

- - - - -

AutoEmailer


197 replies to this topic

#21 Richard Bailey

  • Community Member
  • 99 posts
  • Real Name:Richard

Posted 24 December 2005, 14:59

How about an option to auto email customers 1 week (moth whatever) after they ordered asking them to review the product?

This pulls them back into the site and helps generate content....

Rich..

#22 Jack_mcs

  • Community Member
  • 24,072 posts
  • Real Name:Jack
  • Gender:Male

Posted 24 December 2005, 15:11

Another good idea. I will plan it in the next update.

Jack

#23 Richard Bailey

  • Community Member
  • 99 posts
  • Real Name:Richard

Posted 24 December 2005, 15:12

Sweet!

Great contrib btw!!!

Have a fantastic chrimbo!

Rich

#24 azer

  • Community Member
  • 842 posts
  • Real Name:azer
  • Location:Paris, france

Posted 24 December 2005, 19:21

it seems to be a good feature taht i can read here , but do u plan to make it multi language, or being able to do like in newsletters some tempalte that you can save in the admin ? so far i can see that the messages u email are hard coded in the files ...
for the fck editor, there is contribution that would help you customize your installation :-)
MS2

#25 Jack_mcs

  • Community Member
  • 24,072 posts
  • Real Name:Jack
  • Gender:Male

Posted 24 December 2005, 20:29

Are you sure you are looking at the correct contribution? The FCKEditor is used and the text is not hard coded. Well, for the most part. There are a fewl Hello's but that would be easily changed.

Jack

#26 azer

  • Community Member
  • 842 posts
  • Real Name:azer
  • Location:Paris, france

Posted 25 December 2005, 20:40

well here is some example of

Quote

the text is not hard coded


auto_emailer_customers.php :

Quote

<tr class="smallText">
<td width="10%">Customer: </td><td width="30%" align="left"><?php echo tep_draw_checkbox_field('customer', '', $switch['customer'], ''); ?> </td>
</tr>
<tr class="smallText">
<td width="10%">Member Since: </td><td width="30%" align="left"><?php echo tep_draw_checkbox_field('member_since', '', $switch['member_since'], ''); ?> </td>
</tr>
<tr class="smallText">
<td width="10%">Last Logon: </td><td width="30%" align="left"><?php echo tep_draw_checkbox_field('last_logon', '', $switch['last_logon'], ''); ?> </td>
</tr>
<tr class="smallText">
<td width="10%">Number of Logons: </td><td width="30%" align="left"><?php echo tep_draw_checkbox_field('number_logons', '', $switch['number_logons'], ''); ?> </td>
</tr>



auto_emailer_orders.php :

Quote

<td width="10%">Order ID: </td><td width="30%" align="left"><?php echo tep_draw_checkbox_field('order', '', $switch['order'], ''); ?> </td>

MS2

#27 Jack_mcs

  • Community Member
  • 24,072 posts
  • Real Name:Jack
  • Gender:Male

Posted 25 December 2005, 22:12

Yep, just what a said. A handlful of words. But you are correct, they probably should be automatic. I will add that to the list.

Jack

#28 culturebee

  • Community Member
  • 38 posts
  • Real Name:culturebee@msn.com

Posted 30 December 2005, 02:21

View PostJack_mcs, on Dec 23 2005, 10:24 PM, said:

I've uploaded a new version. I Jack


Thank's Jack, this is a PLUS! I only have to study this great mod and how to set up a cron job. my host did it the first time, I don't know what they did, how to read it or where it is installed or anything. NEED TO LEARN CRON I,m hosting with I powerweb I try there control panel setup but was not must options.

I installed a few contribritions that needs a cron job Please Help Thanks :thumbsup:

#29 Jack_mcs

  • Community Member
  • 24,072 posts
  • Real Name:Jack
  • Gender:Male

Posted 30 December 2005, 02:36

Did you read the instructions in the readme? There is not much involved in setting up cron. You need to enter the command. I have included a sample but it is not the same on all hosts since it needs your path. Once you do that, you just enter the time values for when you want the script to run.

Jack

#30 culturebee

  • Community Member
  • 38 posts
  • Real Name:culturebee@msn.com

Posted 30 December 2005, 02:47

View PostJack_mcs, on Dec 29 2005, 09:36 PM, said:

Did you read the instructions in the readme? There is not much involved in setting up cron. You need to enter the command. I have included a sample but it is not the same on all hosts since it needs your path. Once you do that, you just enter the time values for when you want the script to run.

Jack

How do I enter the time say every friday at 6 am and where to exactly place this file my root reads /home/public_html/index.php

Thanks

#31 Jack_mcs

  • Community Member
  • 24,072 posts
  • Real Name:Jack
  • Gender:Male

Posted 30 December 2005, 03:19

As mentioned in the readme, there should also be settings for Minute, Hour, Day, Month, Weekday. Set the Time to 06:00, the Day to 6 aand the rest to *. You place the files into the admin directory as mentioned in the readme. Change your path to include the admin directory and file name as shown in the readme.

Jack

#32 culturebee

  • Community Member
  • 38 posts
  • Real Name:culturebee@msn.com

Posted 30 December 2005, 03:24

View PostJack_mcs, on Dec 29 2005, 10:19 PM, said:

As mentioned in the readme, there should also be settings for Minute, Hour, Day, Month, Weekday. Set the Time to 06:00, the Day to 6 aand the rest to *. You place the files into the admin directory as mentioned in the readme. Change your path to include the admin directory and file name as shown in the readme.

Jack

I,ll have to go over the readme and study the cron and how it all works together Thanks Jack ;)

#33 mr_absinthe

  • Community Member
  • 368 posts
  • Real Name:Alex
  • Location:London, UK

Posted 03 January 2006, 16:12

Jack,

well done, good contribution as usual.

My guess is that files in auto_emailer folder need to be CHMOD to 777 otherwise it's impossiple to update - if I'm right, you should perhaps include it in install instructions.

This code needs to be in /admin/includes/boxes/auto_emailer.php
'<a href="' . tep_href_link(FILENAME_AUTO_EMAILER_NEWPRODUCTS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_AUTO_EMAILER_NEWPRODUCTS . '</a><br>' .

Also these two defines should be added to admin/includes/languages/english.php before the closing ?>:
define('HEADING_TITLE_AUTO_EMAILER_NEWPRODUCTS', 'New Products');
define('TEXT_AUTO_EMAILER_NEWPRODUCTS', 'Send notifications about new products.');

I have one questin - in announce section - Number of Days - if I type 1 and hit update, the number 1 is there, however if I leave the page and come back it is empty - any idea?

Thank you,

Alex
Absinthe Original Liquor Store

#34 Jack_mcs

  • Community Member
  • 24,072 posts
  • Real Name:Jack
  • Gender:Male

Posted 04 January 2006, 00:37

Thanks for the bug fixes Alex. I will fix those in the next version. As for the last problem, it appears I somehow deleted the code that handles that. It is there in the previous version but not in this last one. To fix it, find this line of code in admin/auto_announce.php

Quote

if ($diff >= 0 && $diff < 18)
and replace it with

Quote

// Start Date Difference
if ($diff >= 0 && $diff < 18)
// Stop Date Difference
I think that should fix it.

Jack

#35 mr_absinthe

  • Community Member
  • 368 posts
  • Real Name:Alex
  • Location:London, UK

Posted 04 January 2006, 12:44

Jack,

thanks that seems to do the trick (it is actually admin/auto_emailer/auto_announce.php).

However I have a problem with the cron - or with the script itself.

When I use php -q /home/USER_NAME/public_html/admin/auto_emailer/auto_emailer.php and replace USER_NAME with my database user name, I receive this email from cron: No input file specified.

Same message when I replace USER_NAME with my control panel user name.

When I change the path to:
php -q /home/httpd/vhosts/mywebsite.com/httpdocs/admin/auto_emailer/auto_emailer.php
nothing happens, however all of my crons use the absolute path.

I tried to call admin/auto_emailer/auto_emailer.php in my browser but it didn't work.

Alex
Absinthe Original Liquor Store

#36 Jack_mcs

  • Community Member
  • 24,072 posts
  • Real Name:Jack
  • Gender:Male

Posted 04 January 2006, 13:59

If you go to admin->Auto Emailer->Settings, is there at least one box checked? I take it, from your statement, that you have other cron jobs that work? If you delete the auto_emailer.php file (or just rename it), then cron should send you an error message. Do you receive that?

Jack

#37 mr_absinthe

  • Community Member
  • 368 posts
  • Real Name:Alex
  • Location:London, UK

Posted 04 January 2006, 14:20

In settings, all boxes are checked.

I have few cron jobs that work just fine. When I use this path php -q /home/CP_USER_NAME/public_html/admin/auto_emailer/auto_emailer.php and rename the admin/auto_emailer/auto_emailer.php, I get this message: No input file specified.

Alex
Absinthe Original Liquor Store

#38 Jack_mcs

  • Community Member
  • 24,072 posts
  • Real Name:Jack
  • Gender:Male

Posted 04 January 2006, 17:36

What happens when you try to run the script from your browser - http://yoursite.com/admin/auto_emailer/auto_emailer.php? It should execture the script and send you the emails. There won't be any output in the browser though. Did you change the email addresses in the scripts?

Jack

#39 mr_absinthe

  • Community Member
  • 368 posts
  • Real Name:Alex
  • Location:London, UK

Posted 04 January 2006, 18:20

It kept loading via browser so I did the following changes:

// include('../includes/configure.php');  -  commented out

// Define the database details
  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', 'user');
  define('DB_SERVER_PASSWORD', 'password');
  define('DB_DATABASE', 'database');

With the above changes, the script is executed (via browser only!) however no email is received. I have checked announce box only in settings. I have also double checked the email setting:
//Set some common items
  $Sender = 'me@mysite.com';
  $Recipiant = 'noreply@mysite.com';
  $Cc = '';
  $Bcc = '';
  $currentDate = date('Y-m-d'); //or enter a date in the form of yyyy-mm-dd

Such a great contribution, I've no idea what could be wrong... :(

Alex
Absinthe Original Liquor Store

#40 Jack_mcs

  • Community Member
  • 24,072 posts
  • Real Name:Jack
  • Gender:Male

Posted 05 January 2006, 04:35

Did you upload all of the files for the email class? I'm sure you did but thought I should ask. If you place an echo statement in one of the files, the output of that statemetn should be sent to you as a separate email. You could try that.
echo 'test emial'."\n";
If you are still not getting any emails, then it would have to be somthing related to cron. I suggest asking your host to be sure cron is running properly. They can also test the script to make sure if it is running without errors.

Jack