Ok, here is the full detail.
Currently the scripts in bin/ are customized by customization scripts.
Rather than naming them "custom_$script" as in SQL-Ledger, we put
them in the custom/ folder and just use the same name as the script
they alter.
We also provide a means to extend certain core portions of the
software including invoices, orders, projects, and parts. To add
custom fields, use the add_custom_field() function, and to remove them
use the drop_custom_filed() function (both from psql). These
functions create fields, and also track them so we can dynamically add
them to queries.
The syntax is:
add_custom_field(entity_name VARCHAR, new_field_name VARCHAR,
field_datatype VARCHAR);
Currently there are issues of putting in optional fields using
non-VARCHAR/TEXT types. This will be fixed in 1.3.
For example: select add_custom_field('project', 'my_field', 'varchar')
creates a new varchar field for projects called 'my_field'. This is
then appropriately loaded and saved based on the $form variable hash
key with the same name.
Then you have to add the customizations to the front-end via the
custom scripts so that the fields are displayed and captured in the
data entry screens.
Best Wishes,
Chris Travers
On 5/22/07, Ted Onley <[EMAIL PROTECTED]> wrote:
> I look forward to seeing the detail.
>
> There are only a couple fields that I need to implement, but they are critical
> for the client and the requirements their customers put on them.
>
> It sounds like you have it covered though.
>
> I'll implement the same logic I have with my custom_ scripts for now, then
> move
> it to the new ledgerSMB implementation when it arrives. I really can't wait
> for
> the release of 1.3 before moving my client, and I really want to use LedgerSMB
> instead of the alternative.
>
> Ted
>
> Chris Travers wrote:
> > Also I will send a detailed explenation of this tomorrow or the next
> > day. If you don't see it, remind me (I am travelling at the moment).
> >
> > On 5/22/07, Chris Travers <[EMAIL PROTECTED]> wrote:
> >> It is likely that custom_ scripts will be removed in favor of an
> >> entirely new system. Customers/vendors/employees willb e replaced in
> >> 1.3, much of the rest of the app will be replaced in 1.4.
> >>
> >> _custom scripts have a few issues in that saving them automically,
> >> etc. is a problem. We are moving instead to custom fields which are
> >> automatically picked up and saved on certan entities. Currently these
> >> include parts, invoices, and orders. Then you have to do the user
> >> interface customization (using _custom scripts for this for now), but
> >> the new architecture will move this into custom workflow scripts and
> >> custom templates.
> >>
> >> Best Wishes,
> >> Chris Travers
> >>
> >> On 5/22/07, Ted Onley <[EMAIL PROTECTED]> wrote:
> >>> Sorry (again) if this is a double (or triple) post...... I haven't seen
> >>> it post
> >>> yet. I've obviously done something wrong...
> >>>
> >>>
> >>> I've done some work on converting a client of mine to SQL-Ledger. This
> >>> work
> >>> includes some custom fields in a custom table for inventory items, as
> >>> well as
> >>> some customizations in inventory processing within the invoicing system.
> >>> I'd
> >>> like to convert them to Ledger-SMB instead.
> >>>
> >>> Is the provision of using 'custom_' scripts on front end modules going to
> >>> be
> >>> changed/removed at some point in Ledger-SMB? If so, will there be any
> >>> provision
> >>> for customization within Ledger-SMB that could be carried forward over
> >>> upgrades?
> >>>
> >>> Ted Onley
> >>>
> >>>
> >>>
> >>> -------------------------------------------------------------------------
> >>> This SF.net email is sponsored by DB2 Express
> >>> Download DB2 Express C - the FREE version of DB2 express and take
> >>> control of your XML. No limits. Just data. Click to get it now.
> >>> http://sourceforge.net/powerbar/db2/
> >>> _______________________________________________
> >>> Ledger-smb-devel mailing list
> >>> [email protected]
> >>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
> >>>
> >
> > -------------------------------------------------------------------------
> > This SF.net email is sponsored by DB2 Express
> > Download DB2 Express C - the FREE version of DB2 express and take
> > control of your XML. No limits. Just data. Click to get it now.
> > http://sourceforge.net/powerbar/db2/
> > _______________________________________________
> > Ledger-smb-devel mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
> >
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________
> Ledger-smb-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
