[SQL-Ledger-users] Re: how to add fields?

[Andre F. M. <and...@te...>]

Many thanks for your answer.
Please, include this very practical how-to guide at your FAQ for helping=
=20
many other newbies.

When I install a new release, does the ct.cgi will be overwritten?
Is it possible to recode the cgi to read an EXTERNAL ASCII TEXT file for=
=20
easy customization, like the language files?
A file that will not be overwritten by new releases.
I imagine a standard file customer_fields.txt (part of released sources)=
=20
and another customer_fields_extras.txt
If the second file does not exists, only the first one is used. If it=20
does exist, BOTH are used.
It will be a LOT more easy than end users tweaking source code. It will =

even open door for a gui customization front end.
For a newbie end user like me, an external and clean text file is much=20
less frightening.
Best Regards.
Andre Felipe


>>>>>>>>>>>>>>>>>> Mensagem anterior <<<<<<<<<<<<<<<<<<

No dia 23/01/01, 18:16:31, "Ing. Dieter Simader" <dsimader@sql-ledger.or=
g>=20
escreveu o seguinte sobre o tema Re: one more translated text / how to a=
dd=20
fields?:


> 1. add the field to the database
> 2. edit ct.cgi and add the field in the section customer_form_header
> i.e

>   <tr>
>     <th align=3Dright>|.$locale->text('New Field').qq|:</th>
>     <td><input name=3Dnew_field size=3D20 maxsize=3D35
> value=3D"$form->{new_field}"></td>
>   </tr>

> 3. in the function save_customer add the field as follows

> ct.cgi line 494
>   # setup array for character fields to be escaped
>   @cflds =3D ("name", "addr1", "addr2", "addr3", "contact", "notes",
>             "shiptoname", "shiptoaddr1", "shiptoaddr2", "shiptoaddr3",=

>             "shiptocontact");

> add the field to the @flds array if it is a character field

> If it is a numeric field add it at line 515

>   # setup array for numeric fields
>   @nflds =3D ("tax1", "tax2", "terms", "creditlimit", "discount");


> Dieter Simader    http://www.sql-ledger.org   (780) 472-8161
> DWS Systems Inc.     Accounting Software       Fax: 478-5281
> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D On a clear disk you can seek forever=
 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

> On Tue, 23 Jan 2001, Andre Felipe Machado wrote:

> > Sir:
> > Attached, one more translated text to Brazilian Portuguese (BR).
> >
> > How could I add more fields to , lets say, customer table? What are =
the
> > steps? Should I use PgAccess to do this? And the sql-ledger screens?=

> > Many thanks.
> > Andr=E9 Felipe Machado
> > messages not answered in 2 bussiness days were lost. Please retransm=
it.