Re: [WebERP-developers] cron job for webERP

[Pak R. <pak...@gm...>]

Hi:

Have been trying to use the MailSalesReport as a cron test but I'm getting
the error:

Fatal error: Call to undefined function DB_query() in
/home4/username/public_html/mydomain.com/weberp/includes/GetConfig.php on
line 10

So, something is missing, I guess it's an include file, but wihch one? I
suppose the $AllowAnyone is meant to skip the login process.

Any clue?
Thanks!

Regards,
Ricard


2014-05-23 16:38 GMT+08:00 Pak Ricard <pak...@gm...>:

> Thanks Phil:
>
> Will look at it in detail, and come back if I get something useful for the
> community :-)
>
> Regards,
> Ricard
>
>
> 2014-05-23 15:17 GMT+08:00 Phil Daintree <ph...@lo...>:
>
> The sales analysis manual has the example - I knew I'd written sommat up:
>>
>> Automating Sales Reports
>>
>> Having created reports it is possible to email sales reports to defined
>> recipients. A script called MailSalesReport.php is a template for doing
>> this. There are no links to this script and no security level is set up
>> for it. All that is required is to save this script to another file
>> named anything with an extension of .php under the same directory as the
>> other scripts.
>>
>> This script will need to be edited with the email addresses of the
>> people to receive the report and the reportID - the system generated
>> report number to be run. The lines to edit are:
>>
>> /*The Sales report to send */
>> $ReportID = 4;
>>
>> /*The people to receive the emailed report */
>> $Recipients = array('"Root" ','"some one else" ');
>>
>> The lines surrounded by /* and */ are comments.
>>
>> Once edited to the ReportID or choice and the Recipients all entered the
>> file should be saved.
>>
>> To schedule the report to run an entry in crontab under a linux
>> installation that would send the report at 0:0 each week day (assuming
>> wget is installed in /usr/bin/wget and that the web server is on the
>> same machine and the new script is called DailySalesReport.php) would be:
>>
>> # Scheduled email of a daily sales report
>>
>> 0 0 * * 2-5 root /usr/bin/wget
>> http://localhost/web-erp/DailySalesReport.php
>>
>> since the page has no output - it would be pointless running it in a web
>> browser although it would initiate another email to the defined
>> recipients.
>>
>> A similar template script is available called MailSalesReport_csv.php
>> that mails the comma separated values file for a ReportID to the
>> Recipients defined in the script in just the same way as
>> MailSalesReport.php script above.
>>
>> A more elegant solution to automatic emailing of sales analysis reports
>> is available using the report_runner.php script this script can be run
>> from a shell or directly from cron and takes command line parameters.
>> This has the advantage instead of hardcoding a number or scripts this
>> script can be run with the paratmers below:
>>
>> -r reportnumber (the number of the webERP report)
>> -n reportname (the name you want to give the report)
>> -e emailaddress[;emailaddress;emailaddres...] (who you want to send it to)
>> [-t reporttext ] (some words you want to send with the report-optional)
>> [ -H weberpHOME] (the home directory for weberp - or edit the php file)
>>
>> Phil
>>
>> Phil Daintree
>> Logic Works Ltd - +64 (0)275 567890
>> http://www.logicworks.co.nz
>>
>> On 23/05/14 14:08, Pak Ricard wrote:
>> > Hi all:
>> >
>> > I'm facing some performance issues with my installation, mainly because
>> > of some batch processes using a lot of resources. Every morning we
>> > launch a custom script to optimize stock in every location, and do
>> > around 150 business checks and send emails to everyone concerned in the
>> > team, so the first one opening webERP every morning launches the script
>> > automatically (as the DB optimization fucntion does.)
>> >
>> > Used to work great but now it's taking too much time and shared
>> > resources at the hosting space. I would like to split it in several
>> > tasks launched by cron job, but problem is I have no idea how to write a
>> > webERP script that is able to be launched by cron.
>> >
>> > Does someone have a sample that could be used as a template?
>> >
>> > Many thanks!
>> >
>> > Regards,
>> > Ricard
>> >
>> >
>> >
>> ------------------------------------------------------------------------------
>> > "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
>> > Instantly run your Selenium tests across 300+ browser/OS combos.
>> > Get unparalleled scalability from the best Selenium testing platform
>> available
>> > Simple to use. Nothing to install. Get started now for free."
>> > http://p.sf.net/sfu/SauceLabs
>> >
>> >
>> >
>> > _______________________________________________
>> > Web-erp-developers mailing list
>> > Web...@li...
>> > https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>>
>> ------------------------------------------------------------------------------
>> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
>> Instantly run your Selenium tests across 300+ browser/OS combos.
>> Get unparalleled scalability from the best Selenium testing platform
>> available
>> Simple to use. Nothing to install. Get started now for free."
>> http://p.sf.net/sfu/SauceLabs
>> _______________________________________________
>> Web-erp-developers mailing list
>> Web...@li...
>> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>>
>
>