*** Amorphous has quit IRC
*** ncjp has quit IRC
*** derek has quit IRC
*** jcater_ has quit IRC
*** SachaZzzz has quit IRC
*** bigbrother` has quit IRC
*** Amorphous has joined #gnuenterprise
*** derek has joined #gnuenterprise
*** jcater_ has joined #gnuenterprise
*** SachaZzzz has joined #gnuenterprise
*** ncjp has joined #gnuenterprise
*** bigbrother` has joined #gnuenterprise
*** kilo has joined #gnuenterprise
*** reinhard has joined #gnuenterprise
*** johannesV has joined #gnuenterprise
<johannesV> good morning
<reinhard> good morning
<kilo> good morning
*** btami has joined #gnuenterprise
<btami> good morning
*** johannesV has quit IRC
*** lekma has joined #gnuenterprise
<lekma> good morning
*** chillywilly has quit IRC
*** johnnyss has quit IRC
*** nickr has quit IRC
*** johannesV has joined #gnuenterprise
*** nickr has joined #gnuenterprise
*** chillywilly has joined #gnuenterprise
*** johnnyss has joined #gnuenterprise
*** SachaS has left #gnuenterprise
*** SachaZzzz is now known as SachaS
*** kilo has left #gnuenterprise
*** lekma has quit IRC
*** jamest has joined #gnuenterprise
*** lekma has joined #gnuenterprise
*** Amorphous has quit IRC
*** btami has quit IRC
*** Amorphous has joined #gnuenterprise
*** klasstek has joined #gnuenterprise
*** derek has quit IRC
*** jcater_ has quit IRC
*** derek has joined #gnuenterprise
*** nickr has quit IRC
*** nickr has joined #gnuenterprise
*** btami has joined #gnuenterprise
<jamest> i thought there was a way to execute a sql statement from a trigger?
<jamest> not a simpleQuery
<jamest> but a update statement
<jcater> is it connectionName.sql() ?
*** lupo__ has joined #gnuenterprise
<jamest> hmmm, i didn't look at the connection level let me check
<nickr> I need to make a little app to calculate sales quotes
<nickr> hmm Do I need to create database records for the actual quote in order to produce a report from it?
<jamest> nickr: ?
<jamest> using gnue-reports?
<jamest> or what?
<nickr> Yeah
<nickr> Well
<nickr> I could use either gnue reports or my own reporting system
<nickr> but I mean I need to create a list of data essentially from a database of prices, discounts, schedules etc
<nickr> I'm just wondering if I need that to be created as a group of records in the database in order to get it as an output or if I can get it directly from the forms client somehow\
<jamest> not exactly sure what you're doing but i typically store all that info as i always get hit up for it later
<jamest> quotes are one part of my system that don't do that and it's a pain as people want that history here at times
<nickr> Oh
<nickr> my company wants a quck and dirty quotes maker
<jamest> in some of my forms i have a trigger do the work, store the record(s), then call a python app to generate the output form
<nickr> they suggested that I use excel
<nickr> which I'd rather not do
<nickr> I think that gnue would be a good solution to rolling my own
<jamest> hmmmm
<nickr> am I right in this thinking?
<jamest> it could do it
<nickr> I've created the schema
<nickr> which I believe covers it
<jamest> what I do for output forms
<nickr> I have an items field, a discounts field which lists a multiplier for vaiour types of customers (VARs, MSRP, etc)
<nickr> er, table
<nickr> table
<jamest> is a python app that uses reportlab to build the output
<nickr> I have such an app
<nickr> for other projects
<nickr> well really its a module
<jamest> my "form" tool is a custom version of http://www.reportlab.org/bauer1.html
<jamest> which I made a module
<nickr> Mine's really simple, it takes an xml input file with lists of tables and some metadata and formats them
<nickr> all I need to do is extend it to allow a logo image and it produces output sufficient for this project
<jamest> like my packing slips, the gnue-form frontend isn't directly bound to any tables
<jamest> the shipping guys fill in the form, press a complete button
<nickr> how complicated is the glue for this?
<nickr> I can make a table that extends down as they enter items right?
<jamest> i just show a rows == 10
<nickr> that owuld be the 'output'
<jamest> my output looks nothing like the form
<nickr> Well
<jamest> as it adds company logo, barcodes, extra info the shippers don't enter
<nickr> I mean I need to display the resulting data as they enter it
<nickr> not the real 'output'
<nickr> just what it calculated for the price breaks and stuff
<jamest> my shipping form which does validation that the part is in the order is 463 line gfd
<jamest> i'd guess a little over 100 lines of python
<jamest> in triggers
<nickr> okay okay
<nickr> but actually help me here :)
<jamest> and then my seperate packslip generator program
<nickr> given that its possible :)
<jamest> whoops, i was trying to answer how complicated
<nickr> ah okay
<nickr> it doesn't seem particularly complicated
<jamest> hang on
<jamest> so you just need totals?
<jamest> what's your email?
<jamest> you can send privately :)
<nickr> not exactly just needing totals
<nickr> essentialy the sales person selects a discount/pricing schedule, and then adds items to a list which have this pricing schedule applied to them
<nickr> if they don't specify an exact count they can select a quantity break
<nickr> if they specify an exact count for every item then it caries over the price and totals
<nickr> does that make sense?
<nickr> at the end they click a done button or whatever and it outputs a nice pdf of the quote for the customer
<nickr> or whatever
<nickr> that part is moderately easy
<nickr> it'd be nice if they could see the items as they are added and then be able to at least delete them if they make a mistake
*** Amorphous has quit IRC
*** Amorphous has joined #gnuenterprise
<jamest> another option if forms is too rough would be a small custom app based upon gnue-common
<jamest> i do that for more complex tools like our scanner app and order processing app
<nickr> what does gnue-common provide that fo example my existing wxpython toolchain doesn't?
<jamest> both present a QT designer built UI to the user
<nickr> hm
<jamest> access to our datasources
<nickr> ah
<nickr> thats nothing in this case though, really
<jamest> basic argument parsing
<nickr> hm
<jamest> the debug and profiling stuff
<nickr> I don't 'get' forms I think :)
<jamest> forms is mainly a data-aware front end that provides basic input manipulation, validation, and triggers
<jamest> you drag and drop tables onto a form in designer
<nickr> right, but can it do what I described above?
<jamest> save the result
<jamest> yes
<jamest> but you have to provide the output app
<jamest> from what you're talking about though i'm not sure you're better off doing it that way
<nickr> Why is that?
<jamest> forms can't dynamically change the UI layout currenlty
<nickr> Can't a display a data table?
<nickr> hm
<jamest> well, you "paint" a screen(form) in gnue-designer
<nickr> I understand that.
<jamest> where you setup the field positions, things like UPPERCASE
<jamest> max lenght
<nickr> There's no scrollable data table widget?
<jamest> you'd set the rows=10
<jamest> which is a poor mans table in some respects
<nickr> ohh
<nickr> I see
* SachaS does the happy dance in #ebXML channel after successfully exchanging an ebXML message between two open source ebXML messaging implementation instances
<nickr> thats why your examples have like one romw
<nickr> because in practnice there'd be 15 or whatever
<jamest> but that rows= setting is set once per block and can be overridden field entry on the screen
<jamest> so like in my item maintenance form I have the commonly used fields set to rows=10
<jamest> and the less frequently used fields on the screen along the bottom with a rows = 1
<nickr> I see
<jamest> for me I use forms more than I should
<jamest> as it presents a common interface to most our apps
<jamest> but if you need areas to expand and contract then forms won't fly
<nickr> clearly forms needs a data table widget which can at least contain result data or allow you to select a record to edit in another page
<nickr> then it'd be champion
<nickr> sort of along the lines of that stupid bad program I'm trying to replace here.. uhh
<jamest> we're talking about adding a table widget
<jamest> but really other than looks the rows= does the same thing
<nickr> Filemaker
<nickr> fwew, my brain exploded
<jamest> ew is right :)
<nickr> well, one thing it has that I lkke is the dat'a grid view
<nickr> which can expand into a form view
<nickr> well, its like in parallel
<reinhard> nickr: a grid is going to be in form's next release
<reinhard> (if everything goes like we want it to)
<nickr> will thaht release occur in less than a week? :)
<reinhard> ermm....
<nickr> I didn't think so ;)
<reinhard> I'd rather say "end of year"
<nickr> hmm
<jamest> reinhard: and you'd rather not say which year right ?
<jamest> :)
<nickr> heheh
*** SachaS is now known as SachaDinner
*** Amorphous has quit IRC
*** Amorphous has joined #gnuenterprise
*** nickr has quit IRC
*** nickr has joined #gnuenterprise
*** btami has quit IRC
*** ra3vat has joined #gnuenterprise
*** ra3vat is now known as dimas
*** psu has joined #gnuenterprise
<psu> A very short GNUe Traffic is now out at
<psu> http://www.kernel-traffic.org/GNUe/gnue20060501_114.html
<psu> Very short, because no-one said anything much all last week
<lupo__> silence is golden, eh?
* psu notes that he's not looking like having the same problem this week
*** SachaDinner is now known as SachaS
*** sjc has joined #gnuenterprise
*** psu has quit IRC
*** jamest has left #gnuenterprise
*** jcater has quit IRC
*** jcater has joined #gnuenterprise
*** kilo has joined #gnuenterprise
*** johannesV has quit IRC
*** klasstek has quit IRC
*** SachaS has quit IRC
*** sacha has joined #gnuenterprise
*** lupo__ has quit IRC
*** reinhard has quit IRC
*** kilo has left #gnuenterprise
*** sacha is now known as SachaZzz
*** derek has quit IRC
*** sjc has quit IRC
*** derek has joined #gnuenterprise
*** jcater has quit IRC
*** dimas has quit IRC
*** jcater has joined #gnuenterprise