197 replies to this topic

[Jack_mcs]

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

[100asa]

Please, more clear! Sorry, I don't understand.
Please, if you want, help me step by step.

[Jack_mcs]

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

Jack

[valley]

Jack_mcs, on Jan 29 2006, 07:44 PM, said:

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 ?

[valley]

Jack_mcs, on Jan 29 2006, 07:44 PM, said:

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

[100asa]

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!

[Jack_mcs]

valley, on Jan 30 2006, 12:44 AM, said:

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

[REKiEM]

Hi friends, thanks for your contribution!

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

[Jack_mcs]

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

Jack

[valley]

Jack_mcs, on Jan 30 2006, 01:37 PM, said:

It's
here.

Jack

Hello Jack ,

Many thanks for the link.

How can I get rid of the Message field which is defaulting to [img]http://www.yoursite.com/images2/upperleft.jpg[/img]

in both admin/announce and admin/new products.

Many thaanks in advance

[Jack_mcs]

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

Jack

[valley]

Jack_mcs, on Feb 4 2006, 02:31 AM, said:

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 ?

[valley]

valley, on Feb 4 2006, 05:42 AM, said:

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

[valley]

valley, on Feb 4 2006, 06:05 AM, said:

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 ?

[Jack_mcs]

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

[valley]

Jack_mcs, on Feb 4 2006, 02:09 PM, said:

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

[Jack_mcs]

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

[valley]

Jack_mcs, on Feb 4 2006, 05:07 PM, said:

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.

[Jack_mcs]

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

[valley]

Jack_mcs, on Dec 24 2005, 03:24 AM, said:

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