197 replies to this topic

[Jack_mcs]

This is the support thread for this contribution, which generates customer and order reports. The reports are attached to an email which may be saved as a csv file. It also has a module to send emails to your customers automatically. I use this for birthday announcements but it can be edited to suit any purpose.

All of this is accomplished via cron so this will not work on a Windows server.

Jack

[dave111]

I'm having issues with the filename, for some reason my server keeps renaming the file to "ATT****.dat"

All the data is there, but kind of annoying, any ideas how to fix? I havent changed any of the filename info auto_orders.

[Jack_mcs]

No, I'm not sure where that gets changed at. The sript I use marks it as an excel file but that is changed at some point. Mine come is with type .att (attachement) so I suspect if is the email program doing it. It may not understand the mime type as it is set.

Jack

[dave111]

BTW added a new version to this:

Modified the orders sent to picked up orders even if customer used PWA checkout. Also pulled out order status so that orders are only picked up once *no matter what status they have*. Adding the following fields to the order CSV/email: date purchase, Street Address, City, Postcode, State, Country, Telephone, Email.
The last version was fully functional, so you may want to test both versions to see which works best for you.
Only file changed is auto_orders.php, but this download includes the full package.

[dave111]

Also the filetype wasnt to do with the email app it was making sure the mimetype in the script matches the mimetype name on the server.

Default mime type for excel on most servers is: application/vnd.ms-excel

(however it seems better to have the file send as a .csv not .xls, so just set up a new mimetype for csv and make the script match this type) i hope this makes sense.

[Jack_mcs]

I just uploaded a new version. I added an interface to the options in admin. Once installed, you can change the settings as you like and receive the reports with the next cron update. I plan on adding other options to the reports but wanted to get some feedback on how this works before I spent too much time on it.

Jack

[culturebee]

Having problem setting up autoemailer please help getting this error with FCKeditor installed


Warning: main(../../admin/FCKeditor/fckeditor.php): failed to open stream: No such file or directory in /home/xxxxxxxxxx/public_html/admin/includes/functions/html_output.php on line 12

Warning: main(../../admin/FCKeditor/fckeditor.php): failed to open stream: No such file or directory in /home/xxxxxxxxx/public_html/admin/includes/functions/html_output.php on line 12

Fatal error: main(): Failed opening required '../../admin/FCKeditor/fckeditor.php' (include_path='.:/usr/local/lib/php') in /home/xxxxxxxxxx/public_html/admin/includes/functions/html_output.php on line 12


in my html_output i have this 'home/xxxxxxxxx/public_html/admin/FCKeditor/');

thank you

[Jack_mcs]

Did you download and install the editor? It's not included in the contribution.

Jack

[culturebee]

Jack_mcs, on Nov 1 2005, 11:07 PM, said:

Did you download and install the editor? It's not included in the contribution.

Jack

Yes I Downloaded FCKeditor but not sur if its set up right .

Its in admin/FCKeditor/fckeditor.php

thank you for helping

Edited by culturebee, 02 November 2005, 04:31.

[Jack_mcs]

The instructions state:

Quote

require("../../FCKeditor/fckeditor.php");

but you say you have

Quote

'home/xxxxxxxxx/public_html/admin/FCKeditor/');

so I suspect that is the problem.

Jack

[culturebee]

Jack_mcs, on Nov 2 2005, 09:07 AM, said:

The instructions state:but you say you haveso I suspect that is the problem.

Jack

I meant in the the same file html_ouput i have

////
// 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.mysite.com/admin/FCKeditor/');
$oFCKeditor -> Value = $text;

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

return $field;
}



and in FCKeditor/fckeditor.php I have 'home/pasword/public_html/admin/FCKeditor



am I missing Something still getting error

Warning: main(../../FCKeditor/fckeditor.php): failed to open stream: No such file or directory in /home/xxxxxxxxxx/public_html/admin/includes/functions/html_output.php on line 12



Thank You!

Edited by culturebee, 02 November 2005, 20:36.

[Jack_mcs]

Try

$oFCKeditor -> BasePath	= 'FCKeditor/';

I'm not sure why you changed the fckeditor.phpfile. I can't find that in the instructions but maybe I'm mssing it..

Jack

[culturebee]

Jack_mcs, on Nov 2 2005, 07:46 PM, said:

Try

$oFCKeditor -> BasePath	= 'FCKeditor/';

I'm not sure why you changed the fckeditor.phpfile. I can't find that in the instructions but maybe I'm mssing it..

Jack

I happen to get the editor to show trying to find the right path I used

require("../../public_html/admin/FCKeditor/fckeditor.php");

Some files were also missed when installing FCKeditor I'm now installing all the files I downloaded
will recleck installation.

Thanks for your help.

[Jack_mcs]

You should never need to use the full path like that from within the shop, except for in the configure files. It may work but should not be needed. That would indicate something else is wrong.

Jack

[culturebee]

Jack_mcs, on Nov 2 2005, 11:13 PM, said:

You should never need to use the full path like that from within the shop, except for in the configure files. It may work but should not be needed. That would indicate something else is wrong.

Jack

Thanks for that info I'll have to recheck my installation.
maybe cause I'm still using a temp URL from my host.

I,m also getting this error when updating email in announce when page updating

Fatal error: Maximum execution time of 30 seconds exceeded in /home/xxxxxxxx/public_html/admin/auto_emailer_announce.php on line 103

Thank You.

Edited by culturebee, 03 November 2005, 04:22.

[Jack_mcs]

The hosts limits how long a script can run and you are exceeding that. It shouldn't happen though the way the contribtution is set up though unless you have a large number of customers with the same birthdate or join date, but that would have to be quite large.

Jack

[culturebee]

Jack_mcs, on Nov 3 2005, 01:01 PM, said:

The hosts limits how long a script can run and you are exceeding that. It shouldn't happen though the way the contribtution is set up though unless you have a large number of customers with the same birthdate or join date, but that would have to be quite large.

Jack

Thanks still in the testing zone trying to learn this great contri.

Just want to know how to exactly use this my main Ideal is I get new
products every week so I want to send member customers an email update This email
goes out once a week I'm not sure if this will do it for me.

Thank You

[Jack_mcs]

That's a good idea of a use for it but it can't do it as it is set up now. A new module would be needed that is a cross between the announcemnt and report options, or you could edit the announce module to load in the new products and include those in the email. I'll put that on the list for the next version but it may be months before it happens.

Jack

[culturebee]

Thanks Jack for the quick responce.

You get it. If you can I will be the first to try it out. like I said still broswing for the best way to use contrib. in my store.
there are so many, some work a little diff but the same.

Thank You again!

Edited by culturebee, 04 November 2005, 01:42.

[Jack_mcs]

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