It is safe to assume because invoices, orders, parts, and projects are
not yet being substantially re-engineered. When they are, the user
interface components will need to be re-engineered once. After that,
they will be far more upgrade-safe than they have in the past.
Best Wishes,
Chris Travers
On 5/24/07, Ted Onley <[EMAIL PROTECTED]> wrote:
> Yes.
>
> Thank you!
>
> Is it safe to assume the upgrade to 1.3 won't take into consideration these
> customizations, or will there be a means to utilize data created from the
> add_custom_field() function?
>
> Ted
>
> Chris Travers wrote:
> > SQL-Ledger (and LSMB 1.2 and lower) rely on a global instance of the
> > LedgerSMB::Form object (SL uses SL::Form). This is used as $form. It
> > is instantiated from the http request.
> >
> > As of 1.3, we are moving away from the global object architecture to
> > something more modularized.
> >
> > So if you add an html form element with a name of my_field to the
> > project screen (in my example below), any data you enter will be saved
> > in the db. TO display that data, you will need to have it set the
> > value to: "$form->{my_field}".
> >
> > So the whole element might be printed out as:
> > print qq|<input type="text" name="my_field" value="$form->{my_field}"/>|;
> >
> > Does that make more sense?
> >
> > Best Wishes,
> > Chris Travers
> >
> > On 5/24/07, Ted Onley <[EMAIL PROTECTED]> wrote:
> >> I told you that you might hear from me soon --
> >>
> >> When you say loaded and saved from the $form variable hash - that means I
> >> don't
> >> hav e to add any SQL to my customizations?
> >>
> >> Ted
> >>
> >> Chris Travers wrote:
> >>> 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
> >>>
> >> -------------------------------------------------------------------------
> >> 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
