For the general discussion of webERP project

emdeex | 1 Sep 2008 02:40

Re: PDF append

Hi Arnold,

> However it seems that pdf_append is only added to PrintCustTrans.php and
> not to PrintCustTransPortrait.php?

Your right, I only added the pdf_append code to PrintCustTrans.php.
The Portrait version is not done yet, if you amend it, send it over
and I'll update CVS...

thanks,
Murray

On Mon, Sep 1, 2008 at 8:47 AM, Arnold Ligtvoet [RaptoBike]
<arnold@...> wrote:
> Hi All,
>
> I was trying to add a checklist to each order for a certain product and
> hoped that I could do this according to:
> http://www.weberp.org/AppendPDF
>
> Aha: found it! The manual at that page says: "create a pdf_append
> directory in the root folder of your webERP". This directory should be
> under companies/[company name]/
>
> However it seems that pdf_append is only added to PrintCustTrans.php and
> not to PrintCustTransPortrait.php?
>
> Is there any reason for that?
>
> Arnold

(Continue reading)

headers

Nicholas Lee | 1 Sep 2008 09:47

Foreign character sets?

I need to use a mixture of Chinese and English characters.

Is there any documentation on setting up weberp to work with Chinese or characters?

Problem I have at the moment is, something like 近义词 displays as 近义词

Nicholas

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users

headers

steven | 1 Sep 2008 12:26

Re: Foreign character sets?

Hi Nicholas,

I am a Chinese user too. First of all, check if your SQL is in GB Encoding. I think your setting is UTF-8.

If your interface is Chinese, but data is &#8888. It is the problem. If problem in interface too, next.

Basically if you using the language po, the system can be use in Chinese & English. The problem in your word is you are using UTF-8 as encoding. But there is problem in PDF if you use UTF. If you are using simplified Chinese, make sure you have the zh-CN .po file in GB code.

Steven

Nicholas Lee 提到:

I need to use a mixture of Chinese and English characters.

Is there any documentation on setting up weberp to work with Chinese or characters?

Problem I have at the moment is, something like 近义词 displays as 近义词

Nicholas

------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ web-ERP-users mailing list web-ERP-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org https://lists.sourceforge.net/lists/listinfo/web-erp-users

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users

headers

steven | 1 Sep 2008 12:27

Re: Foreign character sets?

Hi Nicholas,

I am a Chinese user too. First of all, check if your SQL is in GB Encoding. I think your setting is UTF-8.

If your interface is Chinese, but data is &#8888. It is the problem. If problem in interface too, next.

Basically if you using the language po, the system can be use in Chinese & English. The problem in your word is you are using UTF-8 as encoding. But there is problem in PDF if you use UTF. If you are using simplified Chinese, make sure you have the zh-CN .po file in GB code.

Steven

Nicholas Lee 提到:

I need to use a mixture of Chinese and English characters.

Is there any documentation on setting up weberp to work with Chinese or characters?

Problem I have at the moment is, something like 近义词 displays as 近义词

Nicholas

------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ web-ERP-users mailing list web-ERP-users <at> lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/web-erp-users

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users

headers

Nicholas Lee | 1 Sep 2008 15:41

Re: Foreign character sets?

Actually I'm trying to use a combination.

Allow my Chinese users to enter some detail in Chinese and menus - but with most of the detail in english. I'm using the CVS version and but I'm also not able to get the chinese menus to work with zh_HK 308.

I dumped a database changed the tables to utf-8 and re-created it, but that didn't seem to help the character display problem.

On Mon, Sep 1, 2008 at 10:26 PM, steven <steven-/9Nu+vH3JDG2XPSFrh85NA@public.gmane.org> wrote:

Hi Nicholas,

I am a Chinese user too. First of all, check if your SQL is in GB Encoding. I think your setting is UTF-8.

If your interface is Chinese, but data is &#8888. It is the problem. If problem in interface too, next.

Basically if you using the language po, the system can be use in Chinese & English. The problem in your word is you are using UTF-8 as encoding. But there is problem in PDF if you use UTF. If you are using simplified Chinese, make sure you have the zh-CN .po file in GB code.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users

headers

Geordon Marchak | 2 Sep 2008 00:44

Pulling GL data based on the sales location


Hi,

I'm looking for a way to pull GL info out of weberp by office location.
Is there a good way to go about this?

Regards,

Geordon Marchak
3DTechnics Systems

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

headers

Nicholas Lee | 2 Sep 2008 05:43

Re: Foreign character sets?

I've figured out that the charset of the http connection (Content-Type=etc) and the DB connection (see 2nd diff) are dependent on the user language. I can't say that I'm an expert on character sets, but this strikes me as problematic.

Inserting/Editing data in the database dependent on user language seems to be asking for trouble:- two users with different character sets are going to see different data. Better to have a consistent charset used in the database.
Furthermore, multiple languages implies multiple languages (character sets) to display, implies multiple character sets to store in the database. This again seems lead to so problems.

I would think it would be better to have a consistent default character set, maybe UTF-8, for weberp.

Anyway I hack the code a little to switch to UTF-8.

--- header.inc 2008-09-02 03:25:03.000000000 +0000
+++ header.inc.orig     2008-09-02 03:24:42.000000000 +0000
<at> <at> -7,7 +7,7 <at> <at>
        // $title - should be defined in the page this file is included with

        if (!headers_sent()){
-               header('Content-type: text/html; charset=' . _('UTF-8'));
+               header('Content-type: text/html; charset=' . _('ISO-8859-1'));
        }
        echo '<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">';

<at> <at> -15,7 +15,7 <at> <at>
        echo '<html><head><title>' . $title . '</title>';
        echo '<link REL="shortcut icon" HREF="'. $rootpath.'/favicon.ico">';
        echo '<link REL="icon" HREF="' . $rootpath.'/favicon.ico">';
-       echo '<meta http-equiv="Content-Type" content="text/html; charset=' . _('UTF-8') . '">';
+       echo '<meta http-equiv="Content-Type" content="text/html; charset=' . _('ISO-8859-1') . '">';
        echo '<link href="'.$rootpath. '/css/'. $_SESSION['Theme'] .'/default.css" REL="stylesheet" TYPE="text/css">';
        echo '</head>';

<at> <at> -76,4 +76,4 <at> <at>
echo '</tr>';
echo '</table>';

-?>
+?>

--- ./ConnectDB_mysqli.inc      2008-09-02 03:31:24.000000000 +0000
+++ ./ConnectDB_mysqli.inc.orig 2008-09-02 03:28:14.000000000 +0000
<at> <at> -159,7 +159,7 <at> <at>

function DB_escape_string($String){
        global $db;
-       return mysqli_real_escape_string($db, htmlspecialchars($String, ENT_COMPAT, _('UTF-8')));
+       return mysqli_real_escape_string($db, htmlspecialchars($String, ENT_COMPAT, _('ISO-8859-1')));
}

function DB_show_tables(&$Conn){

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users

headers

Phil Daintree | 2 Sep 2008 13:09

Re: Foreign character sets?

The hack you have adopted will translate the character string UTF-8 and 
use the translated string as the character set.

I see the issue and yes the business needs to use a common language 
through out - but it is often necessary for users in other countries to 
see the interface in their language - which often means a different 
character set.

Phil

Nicholas Lee wrote:
> I've figured out that the charset of the http connection 
> (Content-Type=etc) and the DB connection (see 2nd diff) are dependent on 
> the user language.  I can't say that I'm an expert on character sets, 
> but this strikes me as problematic.
> 
> 
>    1. Inserting/Editing data in the database dependent on user language
>       seems to be asking for trouble:- two users with different
>       character sets are going to see different data.  Better to have a
>       consistent charset used in the database.
>    2. Furthermore, multiple languages implies multiple languages
>       (character sets) to display, implies multiple character sets to
>       store in the database. This again seems lead to so problems.
> 
> 
> I would think it would be better to have a consistent default character 
> set, maybe UTF-8, for weberp.
> 
> 
> 
> Anyway I hack the code a little to switch to UTF-8.
> 
> --- header.inc  2008-09-02 03:25:03.000000000 +0000
> +++ header.inc.orig     2008-09-02 03:24:42.000000000 +0000
>  <at>  <at>  -7,7 +7,7  <at>  <at> 
>         //  $title - should be defined in the page this file is included 
> with
> 
>         if (!headers_sent()){
> -               header('Content-type: text/html; charset=' . _('UTF-8'));
> +               header('Content-type: text/html; charset=' . 
> _('ISO-8859-1'));
>         }
>         echo '<!doctype html public "-//W3C//DTD HTML 4.01 
> Transitional//EN">';
> 
>  <at>  <at>  -15,7 +15,7  <at>  <at> 
>         echo '<html><head><title>' . $title . '</title>';
>         echo '<link REL="shortcut icon" HREF="'. $rootpath.'/favicon.ico">';
>         echo '<link REL="icon" HREF="' . $rootpath.'/favicon.ico">';
> -       echo '<meta http-equiv="Content-Type" content="text/html; . 
> _('UTF-8') . '">';
> +       echo '<meta http-equiv="Content-Type" content="text/html; 
> charset=' . _('ISO-8859-1') . '">';
>         echo '<link href="'.$rootpath. '/css/'. $_SESSION['Theme'] 
> .'/default.css" REL="stylesheet" TYPE="text/css">';
>         echo '</head>';
> 
>  <at>  <at>  -76,4 +76,4  <at>  <at> 
>  echo '</tr>';
>  echo '</table>';
> 
> -?>
> +?>
> 
> 
> --- ./ConnectDB_mysqli.inc      2008-09-02 03:31:24.000000000 +0000
> +++ ./ConnectDB_mysqli.inc.orig 2008-09-02 03:28:14.000000000 +0000
>  <at>  <at>  -159,7 +159,7  <at>  <at> 
> 
>  function DB_escape_string($String){
>         global $db;
> -       return mysqli_real_escape_string($db, htmlspecialchars($String, 
> ENT_COMPAT, _('UTF-8')));
> +       return mysqli_real_escape_string($db, htmlspecialchars($String, 
> ENT_COMPAT, _('ISO-8859-1')));
>  }
> 
>  function DB_show_tables(&$Conn){
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

headers

Phil Daintree | 2 Sep 2008 13:11

Re: Pulling GL data based on the sales location

What do you mean office location? There is no distinction only one DB 
for all offices?

The tables are chartmaster for the chart of accounts
chartdetails for the balances
gltrans for the transactions

Phil

Geordon Marchak wrote:
> Hi,
> 
> I'm looking for a way to pull GL info out of weberp by office location.
> Is there a good way to go about this?
> 
> Regards,
> 
> Geordon Marchak
> 3DTechnics Systems
> 
> 
> 
> 
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
> Build the coolest Linux based applications with Moblin SDK & win great prizes
> Grand prize is a trip for two to an Open Source event anywhere in the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> web-ERP-users mailing list
> web-ERP-users@...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
> 

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

headers

Nicholas Lee | 2 Sep 2008 09:18

Re: Foreign character sets?

On Tue, Sep 2, 2008 at 11:09 PM, Phil Daintree <phil-isGUPO4C75EXyZwO/O/09A@public.gmane.org> wrote:

The hack you have adopted will translate the character string UTF-8 and
use the translated string as the character set.

Since it's not translated then getext will just use "UTF-8" - I was just being lazy, I could have removed the _() completely but didn't see the point.

I see the issue and yes the business needs to use a common language
through out - but it is often necessary for users in other countries to
see the interface in their language - which often means a different
character set.

Might be better to default to UTF-8. Assume the data is store as UTF-8, but allow in cases where UTF-8 is not sufficient to use one of the other character sets.

In either case the decision to use an alternative character set should be by design rather than user choice as it has an impact on the business information and display of that information.

I'm not really a developer, so I'm not sure how good unicode is. I would think though that 90% coverage and good data consistency is more important.

Nicholas

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

_______________________________________________
web-ERP-users mailing list
web-ERP-users@...
https://lists.sourceforge.net/lists/listinfo/web-erp-users

10	May 2013
25	April 2013
12	March 2013
13	February 2013
29	January 2013
49	December 2012
86	November 2012
47	October 2012
90	September 2012
64	August 2012
99	July 2012
72	June 2012
16	May 2012
81	April 2012
163	March 2012
154	February 2012
134	January 2012
169	December 2011
279	November 2011
99	October 2011
116	September 2011
181	August 2011
112	July 2011
109	June 2011
142	May 2011
140	April 2011
190	March 2011
146	February 2011
96	January 2011
63	December 2010
120	November 2010
90	October 2010
39	September 2010
75	August 2010
107	July 2010
237	June 2010
88	May 2010
131	April 2010
127	March 2010
76	February 2010
127	January 2010
207	December 2009
65	November 2009
74	October 2009
143	September 2009
144	August 2009
273	July 2009
159	June 2009
143	May 2009
245	April 2009
369	March 2009
218	February 2009
197	January 2009
89	December 2008
90	November 2008
160	October 2008
139	September 2008
149	August 2008
125	July 2008
110	June 2008
100	May 2008
73	April 2008
168	March 2008
67	February 2008
106	January 2008
23	December 2007
44	November 2007
113	October 2007

Mon	Tue	Wed	Thu	Fri	Sat	Sun

1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30