Jump to content
Sign in to follow this  
Jack_mcs

AutoEmailer

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

Share this post


Link to post
Share on other sites

Please, more clear! Sorry, I don't understand.

Please, if you want, help me step by step.


Skype: centoasa

Skype: remigioruberto

Share this post


Link to post
Share on other sites

You need to start reading around post 41 and follow the instructions there.

 

Jack

Share this post


Link to post
Share on other sites
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 ?

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

I've just read from post #41 to end, and I have made the change in auto_announce, but the result is always the same. Please, post complete .php auto_announce working now!


Skype: centoasa

Skype: remigioruberto

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

Hi friends, thanks for your contribution!

 

Is there any way to announce the new products, including text link for each one ?

Share this post


Link to post
Share on other sites

There is already a new products module. Adding links is planned. I don't know what you mean about each one.

 

Jack

Share this post


Link to post
Share on other sites
It's

here.

 

Jack

 

Hello Jack ,

 

Many thanks for the link.

 

How can I get rid of the Message field which is defaulting to upperleft.jpg

 

in both admin/announce and admin/new products.

 

Many thaanks in advance

Share this post


Link to post
Share on other sites

Share this post


Link to post
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 ?

Share this post


Link to post
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

Share this post


Link to post
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 ?

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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.

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

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

 

Jack

Share this post


Link to post
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.

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×