Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

AutoEmailer


Jack_mcs

Recommended Posts

As I mentioned, it has to do with the email class I used. Changing over to the built-in oscommerce email functions is needed for some hosts for some reason.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

  • Replies 197
  • Created
  • Last Reply

Top Posters In This Topic

I'm not sure what effect having 4,000 customers will have. Maybe that is part of the problem. If your problem is like the other I mentioned, then you will need to change the email functions in the contribution.

 

If you have a Links Manger question, it should be asked it in the Links Manager support thread.

 

Jack

 

Hello Jack,

 

What I meant was, unlike the orders report which

collects only the orders up to certain number of

previous days, the CUSTOMERS reprt collects

the data of entire customers in the database.

 

If you select all the columns by checking in the

admin, it is going to be a long process and the server

may time out. (this happens with some of the

sales report contribution)

 

Anyway is that how it is supposed to work ?

 

Which is the E Mail function mod you are suggesting ?

Could you please clarify ?

Link to comment
Share on other sites

If you have a Links Manger question, it should be asked it in the Links Manager support thread.

 

Jack

 

Searched high and low for a Links Manager Support thread

Couldn't find it. Could anyone please post it it here or PM me ?

 

Cheers

Shred

Link to comment
Share on other sites

Searched high and low for a Links Manager Support thread

Couldn't find it. Could anyone please post it it here or PM me ?

 

Cheers

Shred

It's

here.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

I don't understand what you mean with the image.

 

Jack

 

 

Hello Jack,

 

When I click on the Announce menu in the admin the page that

opens (http://www.affiliatesexcel.com/catalog/admin/auto_emailer_announce.php)

has this picture with a web page in the "Message" field.

 

Ipresume it is there from your instructions

 

///

// Output a form textarea field w/ fckeditor

function tep_draw_fckeditor($name, $width, $height, $text) {

 

$oFCKeditor = new FCKeditor($name);

$oFCKeditor -> Width = $width;

$oFCKeditor -> Height = $height;

$oFCKeditor -> BasePath = 'http://www.yoursite.com/FCKeditor/';

$oFCKeditor -> Value = $text;

 

$field = $oFCKeditor->Create($name);

 

return $field;

}

 

How can I empty it to fill in new info ?

Link to comment
Share on other sites

Hello Jack,

 

Ipresume it is there from your instructions

 

///

// Output a form textarea field w/ fckeditor

function tep_draw_fckeditor($name, $width, $height, $text) {

 

$oFCKeditor = new FCKeditor($name);

$oFCKeditor -> Width = $width;

$oFCKeditor -> Height = $height;

$oFCKeditor -> BasePath = 'http://www.yoursite.com/FCKeditor/';

$oFCKeditor -> Value = $text;

 

$field = $oFCKeditor->Create($name);

 

return $field;

}

 

I have now changed to a correct path

$oFCKeditor -> BasePath = 'http://affiliatesexcel.com/catalog/admin/FCKeditor/FCKeditor';

 

but I still get the default html in the field

Link to comment
Share on other sites

I have now changed to a correct path

$oFCKeditor -> BasePath = 'http://affiliatesexcel.com/catalog/admin/FCKeditor/FCKeditor';

 

but I still get the default html in the field

 

HELLO Jack,

 

I have finally got the FCK editor in the Announce and Product info

pages in the admin.

 

Here is what I had to do.

 

Your instructions asked to upload the FCKeditor directory to the admin

directory. As this was a password protected directory I had to move the

FCKediror directory up to the Catalog directory.

 

I had to change the require statement on line 12 in the

admin/include/functions/html_output.php

as below

require(DIR_FS_CATALOG .'FCKeditor/fckeditor.php');

 

I had to change the base path as below

/ Output a form textarea field w/ fckeditor
 function tep_draw_fckeditor($name, $width, $height, $text) {

 $oFCKeditor = new FCKeditor($name);
 $oFCKeditor -> Width  = $width;
 $oFCKeditor -> Height = $height;
 $oFCKeditor -> BasePath  = '/catalog/FCKeditor/';
 $oFCKeditor -> Value = $text;

$field = $oFCKeditor->Create($name);

return $field;
 }

 

However all this seems to be enough as the FCK editor removes

and change the formatting of any html you place in the message field.

 

Any idea why the editor behaves badly ?

Link to comment
Share on other sites

No, it works fine here, and I assume for others that use it since no one has mentioned this before. The instructions mention that you may need to change the path so that is expected. You shouldn't have to move it out of admin though.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

No, it works fine here, and I assume for others that use it since no one has mentioned this before. The instructions mention that you may need to change the path so that is expected. You shouldn't have to move it out of admin though.

 

Jack

Hello Jack,

Many thanks for the reply.

 

Just one question about the editor.

 

function tep_draw_fckeditor($name, $width, $height, $text)

 

Is it supposed to work only as a text editor or also as

an HTML editor ? Can you cut and paste HTML pages

which is what I try to do by selecting the source menu first.

 

However the output is getting distoted and truncated.

 

Cheers

Shred

Link to comment
Share on other sites

Yes, it should work at an html editor. There is a support thread for it here somewhere. You might want to ask questions about it there since they would have more experience with it.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Yes, it should work at an html editor. There is a support thread for it here somewhere. You might want to ask questions about it there since they would have more experience with it.

 

Jack

Hello Jack,

 

Many thanks for the reply. I will Check it out.

I use MAVDs WYSIWYG addon in admin catogories

which work quite well for cut and paste. FCK seems

more adapted for creating new pages.

 

However, on further tests it seems that the server

stops after sending a couple of hundred messages.

As the script can be called by CRON, is it possible

to incremently select perhaps 100 messages from the list

If this can be done then the CRON can be set up for

every 15 minutes or so to send the messages to a different

group of people.without creating any SPAM issues (for big lists)

 

As it is it looks like the script can't send the mail to

the whole customer list due to the server limitations.

Link to comment
Share on other sites

Most servers have a limit on emails so as not to lock out other sites. I think that addng a call to sleep() every so often will prevent this from happening. I will try to get test this but it could be a while.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

I've uploaded a new version. I added a new products module which will inform your customers of new products added since an entered date, or from todays date if one is not entered. Also corrected a few minor coding problems.

 

Jack

 

On testing Aut_customers.php I get the following error

 

PHP Warning: mysql_query(): Unable to save result set in /home/affili43/affili43-www/catalog/admin/auto_emailer/auto_customers.php on line 46

[sun Feb 5 10:48:00 2006] [error] PHP Warning: mysql_query(): Unable to save result set in /home/affili43/affili43-www/catalog/admin/auto_emailer/auto_customers.php on line 46

[sun Feb 5 10:48:00 2006] [error] PHP Warning: mysql_query(): Unable to save result set in /home/affili43/affili43-www/catalog/admin/auto_emailer/auto_customers.php on line 46

Link to comment
Share on other sites

Those errors are most likely caused by your database or your servers resources. Try repairing your database first using phpmyadmin. If that doesn't do it, contact your host and ask them so check it. The usual cause of that message is that you are out of memory.

 

Jack

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Those errors are most likely caused by your database or your servers resources. Try repairing your database first using phpmyadmin. If that doesn't do it, contact your host and ask them so check it. The usual cause of that message is that you are out of memory.

 

Jack

 

Hello Jack,

Many thanks for your reply. I got my host to check out

and it seems everything was OK> Any way I haven't

made more trials.

 

I have a problem with adsmin/auto_emailer_announce.php.

 

It looks like it is not writing the number of days field to the

auto_emailer/auto_announce.php file when you update after

filling in a number for example 2.

 

All the other fields seems to be writing new data.

 

When I simply update the fild carry the number inserted but

if you change menu and come back later it disapperars.

 

I think due to this the auto_announce.php do not out put

when you make a trial.

 

Could you please let me know how this can be fixed ?

 

Cheers

Shred

Link to comment
Share on other sites

If the permissions on the file are correct then your host is blocking it somehow.

 

Jack

 

Hello Jack,

 

I have rechecked the permissions which are set to

777 both for the autoemailer directory and the files.

 

I did a trial changing the subject in the subject field

which has been updated in the file also with new time stamp.

 

When I change the number of days the time stamp is changed

showing the file has been accessed but the ield returns empty

during next refresh of the admin file.

 

Could you please let me know the line number or statement

that is re written to take the nunber of days ?

(I couln't find an obvious one . ) I can check if this is re written.

Link to comment
Share on other sites

Hello Jack,

 

 

Could you please let me know the line number or statement

that is re written to take the nunber of days ?

(I couln't find an obvious one . ) I can check if this is re written.

 

On checking the admin file I see a code section

else if ($pos_start = strpos($fp[$idx], "// Start Date Difference") !== FALSE)
	  {
		 for ($idy = $idx; $idy < count($fp); ++$idy)
		 {
			if ($pos_stop = strpos($fp[$idy], "// Stop Date Difference") !== FALSE)
			{
			   $new_text[0] = "	  if (\$diff >= 0 && \$diff < ". $ae_array['days'] . ")";
			   $new_text[1] = "\n";
			   array_splice($fp, $idx + 1, $idy  - $idx - 1, $new_text);
			   break;
			}
		 }
	  }

 

However I can't see a corresponding statement in the auto_announce.php

between the Date Selection and Subject . Have I got the latest file

or am I missing something ?

// Start Date Selection
  $adjDate = sprintf("%s-%s-%s", $adjYr, substr($customer['customers_dob'], 5, 2),substr($customer['customers_dob'], 8, 2));
// Stop Date Selection
  $diff = DifferenceBetween($currentDate, $adjDate);

  if ($diff >= 0 && $diff < 18)
  {
// Start Subject
	 $Subject = 'test' . ' ' . $customer['customers_firstname'] . ' ' . $customer['customers_lastname'];
// Stop Subject

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...