web-erp-developers — Discussion on development of webERP

Re: [WebERP-developers] cron job for webERP

[Phil D. <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

Re: [WebERP-developers] Translate the column "typename" of the table "systypes" of the database.

[Phil D. <ph...@lo...>]

Well we only really need the translation so yes if we have it in some Z 
script that would be as good as anywhere then whenever the system comes 
accross a _($myrow['typename']) the translation should be fine. We just 
need to grep/ack for  $myrow['typename'] and replace with 
_($myrow['typename']) in echo/printf statements. The script doesn't 
really need to run at all - we just need the strings in the translation 
messages.po to be available for translation.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 23/05/14 07:01, Rafael Chacón wrote:
> Hi Phil,
>
> If we use translatable variables, I see 3 options:
>
> 1. Translatable variables in any script (e.g. the end of LanguageSetup.php).
> Pro: Translation.
> Cons: slow the script.
>
> 2. In a script called by install/index.php (or inside install/index).
> Pro: Read one time, no time delay in "operating" scripts.
>
> 3. In a "Z_SysTypes.php" script called: (a) by install/index.php as a
> database setup to load systypes table; (b) by "Utilities" menu as a
> re-set for the systypes table.
> Pro: An additional option. Code more clear and reusable.
> Cons: couldslower the setup (two steps instead of one)?
>
> Best regards, Rafael.
>
>
>
> 2014-05-22 2:19 GMT-06:00 Phil Daintree <ph...@lo...
> <mailto:ph...@lo...>>:
>
>     Sorry Rafael ... my suggestion is obviously the same as your
>     suggestion at 2 - sorry.
>
>     Phil
>
>     Phil Daintree
>     Logic Works Ltd -+64 (0)275 567890  <tel:%2B64%20%280%29275%20567890>
>     http://www.logicworks.co.nz
>
>     On 22/05/14 07:00, Rafael Chacón wrote:
>>     Hi,
>>
>>     The values of "typename" column of the table "systypes" are in
>>     English. They are used as they are in this column. Almost all of
>>     the terms do not appear in the dictionary of translations *.po.
>>
>>     To translate this, I found two solutions:
>>
>>     1.Directly overwrite the database with the local language.
>>
>>     2. Create a script "Z_SysTypes.php" containing an array of these
>>     "typename" as line-to-translate, rebuild the languages files, and
>>     translate. E.g.
>>
>>     Z_SysTypes.php:
>>     $SysType['0'] = _('Journal - GL');
>>     $SysType['1'] = _('Payment - GL');
>>     $SysType['2'] = _('Receipt - GL');
>>     ...
>>     $SysType['42'] = _('Asset Category Change');
>>
>>
>>
>>     I want a general purpose solution to add to main code (not only
>>     for my local installations).
>>
>>     What you you think is the best solution? Reviews? Recommendations?
>>     Suggestions?
>>
>>     Best regards, Rafael.
>>
>>
>>     ------------------------------------------------------------------------------
>>     "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...  <mailto: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...
>     <mailto: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

Re: [WebERP-developers] cron job for webERP

[Phil D. <ph...@lo...>]

The sales analysis reports can be run from cron they use the allow anyone variable so no output should be produced that could be exposed. Then use wget i think there is an example in the manual
-- 
Phil Daintree
+64(0)275 567890
Skype: daintree

On May 23, 2014 4:05:00 PM NZST, Marcos Garcia Trejo <ad...@gm...> wrote:
>I guess you need to forget (in part) the webERP job scheme, because it
>was
>done with interactive task in mind.
>Perhaps the best way to do this labor is to create some scripts (in
>PHP, of
>course) those could be runned out of line, in some hours of the nigth
>using
>CLI. for example see:
>http://www.php.net/manual/en/features.commandline.usage.php
>
>Saludos desde Mérida, Yuc!
>
>
>2014-05-22 21:08 GMT-05:00 Pak Ricard <pak...@gm...>:
>
>> 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
>>
>>
>
>
>-- 
>Ing Marcos R Garcia Trejo
>(52) 9991-513412
>Laboratorio de Ingeniería y Procesos Costeros (LIPC)
>Unidad Académica Sisal, UNAM
>MGa...@ii...
>Tel 52 988 931 1000
>
>
>------------------------------------------------------------------------
>
>------------------------------------------------------------------------------
>"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

Re: [WebERP-developers] cron job for webERP

[Phil D. <ph...@lo...>]

The sales analysis reports can be run from cron they use the allow anyone variable so no output should be produced that could be exposed. Then use wget i think there is an example in the manual
-- 
Phil Daintree
+64(0)275 567890
Skype: daintree

On May 23, 2014 4:05:00 PM NZST, Marcos Garcia Trejo <ad...@gm...> wrote:
>I guess you need to forget (in part) the webERP job scheme, because it
>was
>done with interactive task in mind.
>Perhaps the best way to do this labor is to create some scripts (in
>PHP, of
>course) those could be runned out of line, in some hours of the nigth
>using
>CLI. for example see:
>http://www.php.net/manual/en/features.commandline.usage.php
>
>Saludos desde Mérida, Yuc!
>
>
>2014-05-22 21:08 GMT-05:00 Pak Ricard <pak...@gm...>:
>
>> 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
>>
>>
>
>
>-- 
>Ing Marcos R Garcia Trejo
>(52) 9991-513412
>Laboratorio de Ingeniería y Procesos Costeros (LIPC)
>Unidad Académica Sisal, UNAM
>MGa...@ii...
>Tel 52 988 931 1000
>
>
>------------------------------------------------------------------------
>
>------------------------------------------------------------------------------
>"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

Re: [WebERP-developers] cron job for webERP

[Marcos G. T. <ad...@gm...>]

I guess you need to forget (in part) the webERP job scheme, because it was
done with interactive task in mind.
Perhaps the best way to do this labor is to create some scripts (in PHP, of
course) those could be runned out of line, in some hours of the nigth using
CLI. for example see:
http://www.php.net/manual/en/features.commandline.usage.php

Saludos desde Mérida, Yuc!


2014-05-22 21:08 GMT-05:00 Pak Ricard <pak...@gm...>:

> 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
>
>


-- 
Ing Marcos R Garcia Trejo
(52) 9991-513412
Laboratorio de Ingeniería y Procesos Costeros (LIPC)
Unidad Académica Sisal, UNAM
MGa...@ii...
Tel 52 988 931 1000

[WebERP-developers] cron job for webERP

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

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

Re: [WebERP-developers] Translate the column "typename" of the table "systypes" of the database.

[Rafael C. <raf...@gm...>]

Hi Phil,

If we use translatable variables, I see 3 options:

1. Translatable variables in any script (e.g. the end of LanguageSetup.php).
Pro: Translation.
Cons: slow the script.

2. In a script called by install/index.php (or inside install/index).
Pro: Read one time, no time delay in "operating" scripts.

3. In a "Z_SysTypes.php" script called: (a) by install/index.php as a
database setup to load systypes table; (b) by "Utilities" menu as a re-set
for the systypes table.
Pro: An additional option. Code more clear and reusable.
Cons: could slower the setup (two steps instead of one) ?

Best regards, Rafael.



2014-05-22 2:19 GMT-06:00 Phil Daintree <ph...@lo...>:

>  Sorry Rafael ... my suggestion is obviously the same as your suggestion
> at 2 - sorry.
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 22/05/14 07:00, Rafael Chacón wrote:
>
>  Hi,
>
>  The values of "typename" column of the table "systypes" are in English.
> They are used as they are in this column. Almost all of the terms do not
> appear in the dictionary of translations *.po.
>
> To translate this, I found two solutions:
>
> 1. Directly overwrite the database with the local language.
>
>  2. Create a script "Z_SysTypes.php" containing an array of these
> "typename" as line-to-translate, rebuild the languages files, and
> translate. E.g.
>
> Z_SysTypes.php:
> $SysType['0'] = _('Journal - GL');
> $SysType['1'] = _('Payment - GL');
> $SysType['2'] = _('Receipt - GL');
> ...
> $SysType['42'] = _('Asset Category Change');
>
>
>
>  I want a general purpose solution to add to main code (not only for my
> local installations).
>
>  What you you think is the best solution? Reviews? Recommendations?
> Suggestions?
>
>  Best regards, Rafael.
>
>
> ------------------------------------------------------------------------------
> "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 lis...@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
>
>

Re: [WebERP-developers] Question on StockClone

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

great! Thanks Phil.

Regards,
Ricard


2014-05-22 16:06 GMT+08:00 Phil Daintree <ph...@lo...>:

>  Yep - just had a look and tidied up - if you could test and let me know
> I've not messed up!
> Thanks
>
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890http://www.logicworks.co.nz
>
> On 22/05/14 12:55, Pak Ricard wrote:
>
> Hi all:
>
>  I'm checking the StockClone.php script, and I think the query at line
> 475 querying the standard cost values does not need to JOIN with locstock,
> also totalqih is not used anywhere on the script. Does it make sense to
> simplify this query? Am I missing anything?
>
> 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 lis...@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
>
>

Re: [WebERP-developers] Translate the column "typename" of the table "systypes" of the database.

[Phil D. <ph...@lo...>]

Sorry Rafael ... my suggestion is obviously the same as your suggestion 
at 2 - sorry.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 22/05/14 07:00, Rafael Chacón wrote:
> Hi,
>
> The values of "typename" column of the table "systypes" are in 
> English. They are used as they are in this column. Almost all of the 
> terms do not appear in the dictionary of translations *.po.
>
> To translate this, I found two solutions:
>
> 1.Directly overwrite the database with the local language.
>
> 2. Create a script "Z_SysTypes.php" containing an array of these 
> "typename" as line-to-translate, rebuild the languages files, and 
> translate. E.g.
>
> Z_SysTypes.php:
> $SysType['0'] = _('Journal - GL');
> $SysType['1'] = _('Payment - GL');
> $SysType['2'] = _('Receipt - GL');
> ...
> $SysType['42'] = _('Asset Category Change');
>
>
>
> I want a general purpose solution to add to main code (not only for my 
> local installations).
>
> What you you think is the best solution? Reviews? Recommendations? 
> Suggestions?
>
> Best regards, Rafael.
>
>
> ------------------------------------------------------------------------------
> "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

Re: [WebERP-developers] Translate the column "typename" of the table "systypes" of the database.

[Phil D. <ph...@lo...>]

Doesn't work within comments we would have to add some silly variables 
or something perhaps at the end of LanguageSetup.php ??

$NotUsed=_('Invoice');
$NotUsed=_('Credit note');
$NotUsed=_('GL - Journal');
$NotUsed=_('GL - Receipt');


etc

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 22/05/14 19:45, Phil Daintree wrote:
> Yes this is a good point  - there are a few places where we are using 
> data from the DB that is displayed. I have resolved the item 
> descriptions now.
>
> I am thinking we could use code like:
>
> echo _($myrow['typename')
>
> this would then resolve to something like
>
> _('Invoice')
>
> and get translated using the usual gettext process.
>
> then if we had within comments somewhere:
>
> /*
> _('Invoice')
> _('Credit Note')
> _('Receipt')
> .
> .
> .
>
> */
> Then xgettext would extract these strings for translation in each of 
> the translation files and gettext would have the data required to do 
> the translation :-)
>
> Is this a plan?
> Phil
>
> Phil Daintree
> Logic Works Ltd - +64 (0)275 567890
> http://www.logicworks.co.nz
> On 22/05/14 07:00, Rafael Chacón wrote:
>> Hi,
>>
>> The values of "typename" column of the table "systypes" are in 
>> English. They are used as they are in this column. Almost all of the 
>> terms do not appear in the dictionary of translations *.po.
>>
>> To translate this, I found two solutions:
>>
>> 1.Directly overwrite the database with the local language.
>>
>> 2. Create a script "Z_SysTypes.php" containing an array of these 
>> "typename" as line-to-translate, rebuild the languages files, and 
>> translate. E.g.
>>
>> Z_SysTypes.php:
>> $SysType['0'] = _('Journal - GL');
>> $SysType['1'] = _('Payment - GL');
>> $SysType['2'] = _('Receipt - GL');
>> ...
>> $SysType['42'] = _('Asset Category Change');
>>
>>
>>
>> I want a general purpose solution to add to main code (not only for 
>> my local installations).
>>
>> What you you think is the best solution? Reviews? Recommendations? 
>> Suggestions?
>>
>> Best regards, Rafael.
>>
>>
>> ------------------------------------------------------------------------------
>> "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

Re: [WebERP-developers] Question on StockClone

[Phil D. <ph...@lo...>]

Yep - just had a look and tidied up - if you could test and let me know 
I've not messed up!
Thanks

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 22/05/14 12:55, Pak Ricard wrote:
> Hi all:
>
> I'm checking the StockClone.php script, and I think the query at line 
> 475 querying the standard cost values does not need to JOIN with 
> locstock, also totalqih is not used anywhere on the script. Does it 
> make sense to simplify this query? Am I missing anything?
>
> 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

Re: [WebERP-developers] Question on StockClone

[Phil D. <ph...@lo...>]

Welcome Marco and Sabrina,

There are a few South American webERPers here.

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 22/05/14 16:53, mar...@tn... wrote:
> Hi Web ERP developers, I'm a Mexican IT Specialist, recently I found
> this project and I think that is a very interesting solution for Mexican
> Market, but this software needs some modifications to be more useful
> here, I'm currently working on that... (HHRR, Payrol, Mexican Invoices
> and Taxes).
>
> As well introducing Sabrina Torres as my Co founder & Marvelous
> Marketing Partner.
>
> In addition we are offering to all of you our services as an independent
> consultancy in Google Adwords Publicity, BI skills, PL/SQL, PHP and
> Database Administration (MySQL, Oracle and SQL Server), to continue my
> contribution to this great project.
>
>
> Warm Regards.
>
> Mark Dominguez
> IT Specialist & CEO
> http://tne.com.mx/MSSolutions
> http://mssolutions.com.ar (coming soon!)
>
>
> El 2014-05-21 18:55, Pak Ricard escribió:
>> Hi all:
>>
>> I'm checking the StockClone.php script, and I think the query at line
>> 475 querying the standard cost values does not need to JOIN with
>> locstock, also totalqih is not used anywhere on the script. Does it
>> make sense to simplify this query? Am I missing anything?
>>
>> 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

Re: [WebERP-developers] Translate the column "typename" of the table "systypes" of the database.

[Phil D. <ph...@lo...>]

Yes this is a good point  - there are a few places where we are using 
data from the DB that is displayed. I have resolved the item 
descriptions now.

I am thinking we could use code like:

echo _($myrow['typename')

this would then resolve to something like

_('Invoice')

and get translated using the usual gettext process.

then if we had within comments somewhere:

/*
_('Invoice')
_('Credit Note')
_('Receipt')
.
.
.

*/
Then xgettext would extract these strings for translation in each of the 
translation files and gettext would have the data required to do the 
translation :-)

Is this a plan?

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 22/05/14 07:00, Rafael Chacón wrote:
> Hi,
>
> The values of "typename" column of the table "systypes" are in 
> English. They are used as they are in this column. Almost all of the 
> terms do not appear in the dictionary of translations *.po.
>
> To translate this, I found two solutions:
>
> 1.Directly overwrite the database with the local language.
>
> 2. Create a script "Z_SysTypes.php" containing an array of these 
> "typename" as line-to-translate, rebuild the languages files, and 
> translate. E.g.
>
> Z_SysTypes.php:
> $SysType['0'] = _('Journal - GL');
> $SysType['1'] = _('Payment - GL');
> $SysType['2'] = _('Receipt - GL');
> ...
> $SysType['42'] = _('Asset Category Change');
>
>
>
> I want a general purpose solution to add to main code (not only for my 
> local installations).
>
> What you you think is the best solution? Reviews? Recommendations? 
> Suggestions?
>
> Best regards, Rafael.
>
>
> ------------------------------------------------------------------------------
> "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

Re: [WebERP-developers] Question on StockClone

[<mar...@tn...>]

Hi Web ERP developers, I'm a Mexican IT Specialist, recently I found 
this project and I think that is a very interesting solution for Mexican 
Market, but this software needs some modifications to be more useful 
here, I'm currently working on that... (HHRR, Payrol, Mexican Invoices 
and Taxes).

As well introducing Sabrina Torres as my Co founder & Marvelous 
Marketing Partner.

In addition we are offering to all of you our services as an independent 
consultancy in Google Adwords Publicity, BI skills, PL/SQL, PHP and 
Database Administration (MySQL, Oracle and SQL Server), to continue my 
contribution to this great project.


Warm Regards.

Mark Dominguez
IT Specialist & CEO
http://tne.com.mx/MSSolutions
http://mssolutions.com.ar (coming soon!)


El 2014-05-21 18:55, Pak Ricard escribió:
> Hi all:
> 
> I'm checking the StockClone.php script, and I think the query at line
> 475 querying the standard cost values does not need to JOIN with
> locstock, also totalqih is not used anywhere on the script. Does it
> make sense to simplify this query? Am I missing anything?
> 
> 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

Re: [WebERP-developers] Translate the column "typename" of the table "systypes" of the database.

[ExsonQu <hex...@gm...>]

*Hi, Rafael,*

      You've brought up a great topic. There are others which should be
translated such as roles etc. Create a file special for translation is great
idea. 
      And the challenge lays in that we have to lots files affected.

      Best regards!

      Exson

       



--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Translate-the-column-typename-of-the-table-systypes-of-the-database-tp4657452p4657454.html
Sent from the web-ERP-developers mailing list archive at Nabble.com.

[WebERP-developers] Question on StockClone

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

Hi all:

I'm checking the StockClone.php script, and I think the query at line 475
querying the standard cost values does not need to JOIN with locstock, also
totalqih is not used anywhere on the script. Does it make sense to simplify
this query? Am I missing anything?

Regards,
Ricard

[WebERP-developers] Translate the column "typename" of the table "systypes" of the database.

[Rafael C. <raf...@gm...>]

Hi,

The values of "typename" column of the table "systypes" are in English.
They are used as they are in this column. Almost all of the terms do not
appear in the dictionary of translations *.po.

To translate this, I found two solutions:

1. Directly overwrite the database with the local language.

2. Create a script "Z_SysTypes.php" containing an array of these "typename"
as line-to-translate, rebuild the languages files, and translate. E.g.

Z_SysTypes.php:
$SysType['0'] = _('Journal - GL');
$SysType['1'] = _('Payment - GL');
$SysType['2'] = _('Receipt - GL');
...
$SysType['42'] = _('Asset Category Change');



I want a general purpose solution to add to main code (not only for my
local installations).

What you you think is the best solution? Reviews? Recommendations?
Suggestions?

Best regards, Rafael.

[WebERP-developers] Fwd: [Web-erp-svn] SF.net SVN: web-erp:[6719] trunk/locale/es_ES.utf8/LC_MESSAGES

[Rafael C. <raf...@gm...>]

Hi,

This an "emergency correction". It is pending to re-build all the language
files. I will do it later.

Best regards, Rafael.


---------- Forwarded message ----------
From: <rc...@us...>
Date: 2014-05-18 11:36 GMT-06:00
Subject: [Web-erp-svn] SF.net SVN: web-erp:[6719]
trunk/locale/es_ES.utf8/LC_MESSAGES
To: web...@li...


Revision: 6719
          http://sourceforge.net/p/web-erp/reponame/6719
Author:   rchacon
Date:     2014-05-18 17:36:42 +0000 (Sun, 18 May 2014)
Log Message:
-----------
Manual correction of the missing line "Change A Stock Category Code".
Spanish file only.

Modified Paths:
--------------
    trunk/locale/es_ES.utf8/LC_MESSAGES/messages.mo
    trunk/locale/es_ES.utf8/LC_MESSAGES/messages.po

Modified: trunk/locale/es_ES.utf8/LC_MESSAGES/messages.mo
===================================================================
(Binary files differ)

Modified: trunk/locale/es_ES.utf8/LC_MESSAGES/messages.po
===================================================================
--- trunk/locale/es_ES.utf8/LC_MESSAGES/messages.po     2014-05-18 14:22:52
UTC (rev 6718)
+++ trunk/locale/es_ES.utf8/LC_MESSAGES/messages.po     2014-05-18 17:36:42
UTC (rev 6719)
@@ -8,7 +8,7 @@
 "Project-Id-Version: WebERP 4.081\n"
 "Report-Msgid-Bugs-To: \n"
 "POT-Creation-Date: 2014-02-08 17:33+1300\n"
-"PO-Revision-Date: 2014-05-14 23:20-0600\n"
+"PO-Revision-Date: 2014-05-18 11:23-0600\n"
 "Last-Translator: Rafael Chacon <raf...@gm...>\n"
 "Language-Team: TecnoSoluciones.com <web...@te...>\n"
 "Language: es_ES\n"
@@ -43418,44 +43418,48 @@
 msgstr "Cambiar un código de cliente"

 #: includes/MainMenuLinksArray.php:527
+msgid "Change A Stock Category Code"
+msgstr "Cambiar un código de categoría de inventario"
+
+#: includes/MainMenuLinksArray.php:528
 msgid "Change A Customer Branch Code"
 msgstr "Cambiar un código de sucursal de cliente"

-#: includes/MainMenuLinksArray.php:528
+#: includes/MainMenuLinksArray.php:529
 msgid "Change A Supplier Code"
 msgstr "Cambiar un código de proveedor"

-#: includes/MainMenuLinksArray.php:529
+#: includes/MainMenuLinksArray.php:530
 msgid "Change An Inventory Item Code"
 msgstr "Cambiar un código de artículo de inventario"

-#: includes/MainMenuLinksArray.php:530
+#: includes/MainMenuLinksArray.php:531
 msgid "Change A GL Account Code"
 msgstr "Cambiar un código de cuenta contable"

-#: includes/MainMenuLinksArray.php:531
+#: includes/MainMenuLinksArray.php:532
 msgid "Change A Location Code"
 msgstr "Cambiar un código de ubicación"

-#: includes/MainMenuLinksArray.php:532
+#: includes/MainMenuLinksArray.php:533
 msgid "Update costs for all BOM items, from the bottom up"
 msgstr ""
 "Actualización de costos de todos los elementos de lista de materiales, de
"
 "abajo hacia arriba"

-#: includes/MainMenuLinksArray.php:533
+#: includes/MainMenuLinksArray.php:534
 msgid "Re-apply costs to Sales Analysis"
 msgstr "Aplicar Costos al Análisis de Ventas"

-#: includes/MainMenuLinksArray.php:534
+#: includes/MainMenuLinksArray.php:535
 msgid "Delete sales transactions"
 msgstr "Eliminar transacciones de venta"

-#: includes/MainMenuLinksArray.php:535
+#: includes/MainMenuLinksArray.php:536
 msgid "Reverse all supplier payments on a specified date"
 msgstr "Revocar todos los pagos a proveedores en una fecha específica"

-#: includes/MainMenuLinksArray.php:536
+#: includes/MainMenuLinksArray.php:537
 msgid "Update sales analysis with latest customer data"
 msgstr ""



------------------------------------------------------------------------------
"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-svn mailing list
Web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-svn

Re: [WebERP-developers] Wrong file name

[Phil D. <ph...@lo...>]

I've fixed now.
Thanks - I just used svn rename - this did the delete and add with the 
new name

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 16/05/14 11:59, Pak Ricard wrote:
> Hi all:
>
> I realized the file css/wood/images/User.png should be named user.png 
> (in lowercase) as it's showing error in my error log.
>
> For any reason I can't commit this change. Could any admin pls do it?
>
> 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

[WebERP-developers] Wrong file name

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

Hi all:

I realized the file css/wood/images/User.png should be named user.png (in
lowercase) as it's showing error in my error log.

For any reason I can't commit this change. Could any admin pls do it?

Regards,
Ricard

Re: [WebERP-developers] How to remake Language Files?

[Rafael C. <raf...@gm...>]

Hi Phil,

Thank you, very much.

Best regards, Rafael.
El 14/05/2014 16:48, <ph...@lo...> escribió:

> If you are using linux you can run - build/make_release.sh
>
> or look at the command in there to run
>
> xgettext - to extract all the strings to
>
> locale/en_GB.utf8/LC_MESSAGES/messages.pot
>
> and msgmerge to merge the new strings extracted into this new
> messages.pot into the new
>
> locale/your-language-locale/LC_MESSAGES/messages.po
>
> and then re msgfmt to create a new messages.mo
>
> We do have some scripts to manage translations but they are a bit hit
> and miss so I tend to justs run the make_release.sh script to update all
> language translations with the latest scripts
>
>
> Phil
>
> On 2014-05-14 15:45, Rafael Chacón wrote:
> > Hi,
> >
> > I am looking for line "Change A Stock Category Code" to translate it,
> > but I can not find it in the *.po file.
> >
> > How do I rebuild Language Files?
> >
> > Best Regards,
> >
> > Rafael Chacon
> >
> >
> ------------------------------------------------------------------------------
> > "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
>

Re: [WebERP-developers] How to remake Language Files?

[<ph...@lo...>]

If you are using linux you can run - build/make_release.sh

or look at the command in there to run

xgettext - to extract all the strings to

locale/en_GB.utf8/LC_MESSAGES/messages.pot

and msgmerge to merge the new strings extracted into this new 
messages.pot into the new

locale/your-language-locale/LC_MESSAGES/messages.po

and then re msgfmt to create a new messages.mo

We do have some scripts to manage translations but they are a bit hit 
and miss so I tend to justs run the make_release.sh script to update all 
language translations with the latest scripts


Phil

On 2014-05-14 15:45, Rafael Chacón wrote:
> Hi,
> 
> I am looking for line "Change A Stock Category Code" to translate it,
> but I can not find it in the *.po file.
> 
> How do I rebuild Language Files?
> 
> Best Regards,
> 
> Rafael Chacon
> 
> ------------------------------------------------------------------------------
> "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

[WebERP-developers] How to remake Language Files?

[Rafael C. <raf...@gm...>]

Hi,

I am looking for line "Change A Stock Category Code" to translate it, but I
can not find it in the *.po file.

How do I rebuild Language Files?

Best Regards,

Rafael Chacon

[WebERP-developers] MRP issue

[<ph...@lo...>]

Hi Benjamin,

Your solution looks reasonable to me. Rather than iterating through to
get the initial sums you can use the array_sum() function. then use
different variable names for the sums inside the array and then
overwrite $TotalRequirement and $TotalSupply each time at the end of
thw hile statement.

I think this is more efficient but I may be wrong.

Thanks
Tim

On 11 May 2014 20:34, Benjamin Piltz <bp...@vi...> wrote:
> Hi there,
> 
> as a frequent user of MRP I found another error (which was in the 4.04 
> I
> still run maybe it is fixed now).
> 
> Anyway the Error is the following:
> In LevelNetting are all requirements and supplies checked for an item 
> to
> determine if it has to be ordered. A while loop checks all the
> requirements and supplies to each other and returns the resulting unmet
> requirements. The while loop condition is:
> 
>      $reqi = 0; //Index for requirements
>      $supi = 0; // index for supplies
>      $totalrequirement = 0;
>      $totalsupply = 0;
> 
>      $totalrequirement += $requirements[$reqi]['quantity'];
>      $totalsupply += $supplies[$supi]['supplyquantity'];
> 
> 
>      while ($totalrequirement > 0 && $totalsupply > 0) {
> 
> If unfortunately the first index of either $requirements or $supplies 
> is
> 0 but higher indexes are not then the loop is not entered. This can 
> happen.
> 
>      $totalrequirement += $requirements[$reqi]['quantity'];
>      $totalsupply += $supplies[$supi]['supplyquantity'];
> 
> to
> 
>          for($i = 0; $i < $requirementcount; $i++){
>              $totalrequirement += $requirements[$i]['quantity'];
>          }
>          for($i = 0; $i < $requirementcount; $i++){
>              $totalsupply += $supplies[$i]['supplyquantity'];
>          }
> 
> iterating through all supplies and requ.
> But then having to reset them back inside the loop on the first run to
> the first indexes:
>          $init_totals_for_first_run = 1;
>          while ($totalrequirement > 0 && $totalsupply > 0) {
>                  if($init_totals_for_first_run){
>                      $totalrequirement = 
> $requirements[$reqi]['quantity'];
>                      $totalsupply = $supplies[$supi]['supplyquantity'];
>                      $init_totals_for_first_run = 0;
>                  }
> 
> 
> This worked for me now also quick and dirty.
> 
> 
> best,
> 
> Benjamin.
> 

Re: [WebERP-developers] New web-host

[Phil D. <ph...@lo...>]

Hi Exson,

Thanks for that - I've applied the update SQL to the demo now :-)

Phil

Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz

On 12/05/14 00:02, ExsonQu wrote:
> *Hi, Phil,*
>
>            I've received positive feedback of the new website from webERP
> Chinese Community QQ group.
>
>           And at the mean time, they feedback that Table
> 'weberpdemo.custitem' does't exist. It seems that the sql not updated.
>
>           Best regards!
>
>           Exson
>
>            
>
>
>
> --
> View this message in context: http://weberp-accounting.1478800.n4.nabble.com/New-web-host-tp4657418p4657422.html
> Sent from the web-ERP-developers mailing list archive at Nabble.com.
>
> ------------------------------------------------------------------------------
> Is your legacy SCM system holding you back? Join Perforce May 7 to find out:
> • 3 signs your SCM is hindering your productivity
> • Requirements for releasing software faster
> • Expert tips and advice for migrating your SCM now
> http://p.sf.net/sfu/perforce
> _______________________________________________
> Web-erp-developers mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-developers
>