jbailey (~jbailey@CPE00062579efac-CM014260028338.cpe.net.cable.rogers.com) left irc: "Client exiting"
Action: chillywilly drop kicks dtm in the head
<dtm> sweet.
LuftHans (~lufthans@wsip-68-107-221-207.ph.ph.cox.net) left irc: "und wech"
reinhard (~reinhard@M1264P004.adsl.highway.telekom.at) joined #gnuenterprise.
wendall911 (~wendallc@216.255.199.8) left irc: Read error: 110 (Connection timed out)
sjc_ (~sjc@cpc2-seve3-4-0-cust112.popl.cable.ntl.com) joined #gnuenterprise.
sjc_ (~sjc@cpc2-seve3-4-0-cust112.popl.cable.ntl.com) left irc: Read error: 104 (Connection reset by peer)
sjc (~sjc@cpc2-seve3-4-0-cust112.popl.cable.ntl.com) joined #gnuenterprise.
sjc (~sjc@cpc2-seve3-4-0-cust112.popl.cable.ntl.com) left irc: Remote closed the connection
sjc (~sjc@cpc2-seve3-4-0-cust112.popl.cable.ntl.com) joined #gnuenterprise.
sjc (~sjc@cpc2-seve3-4-0-cust112.popl.cable.ntl.com) left irc: Client Quit
sjc (~sjc@cpc2-seve3-4-0-cust112.popl.cable.ntl.com) joined #gnuenterprise.
johannesV (~johannes@M1564P005.adsl.highway.telekom.at) joined #gnuenterprise.
kilo (~kilo@ip102-205.ktv.tiszanet.hu) joined #gnuenterprise.
lupo__ (lupo@pD9E680EF.dip.t-dialin.net) left irc: Remote closed the connection
kilo (~kilo@ip102-205.ktv.tiszanet.hu) left irc: Read error: 60 (Operation timed out)
SachaS (~Sacha@dialup-196-245.conceptual.net.au) joined #gnuenterprise.
nenhum (~juanjo@cm0085.red.mundo-r.com) joined #gnuenterprise.
nenhum (~juanjo@cm0085.red.mundo-r.com) left #gnuenterprise ("Client exiting").
jamest (~jamest@gw.math.ksu.edu) joined #gnuenterprise.
johannesV_ (~johannes@M1564P005.adsl.highway.telekom.at) joined #gnuenterprise.
johannesV (~johannes@M1564P005.adsl.highway.telekom.at) left irc: Read error: 111 (Connection refused)
nenhum (~juanjo@213.172.36.226) joined #gnuenterprise.
dsmith (~user@mail.actron.com) joined #gnuenterprise.
wendall911 (~wendallc@216.255.199.8) joined #gnuenterprise.
jbailey (~jbailey@dragonfly.fundserv.com) joined #gnuenterprise.
dcmwai (~dcmwai@219.95.60.16) joined #gnuenterprise.
lupo__ (lupo@pD9E680EF.dip.t-dialin.net) joined #gnuenterprise.
dcmwai (~dcmwai@219.95.60.16) left irc: Read error: 104 (Connection reset by peer)
dcmwai (~dcmwai@219.95.57.163) joined #gnuenterprise.
_florin_ (~florin@pD9E6913B.dip.t-dialin.net) joined #gnuenterprise.
<_florin_> hello everybody!
<_florin_> is there anybody here who can answer me tons of gnue-dev/newbie-questions?
<_florin_> i need to know how to access a table (R/W access), as a starting point...
<_florin_> are there any docs on the topic? the FAQ doesn't loose a word about it,
<_florin_> and other useful docs i couldn't find on the website. (me blind?)
<jamest> ?
<_florin_> ?
<jamest> you should setup /usr/local/gnue/etc/connections to provide connections to your database
<nickr> ?
<_florin_> it's /etc/gnue/connections here, and yes, i did.
<jamest> then in gnue-designer you should be able to see your tables 
<_florin_> i'm doing the following (this will take a while, since i'm actually doing it now):
<_florin_> starting the mysql daemon. i have a db called 'white', and a table called 'people'.
<_florin_> starting gnue-designer (0.5.2 sarge .deb)
<_florin_> here's the corresponding entry in gnue/connections.conf:
<_florin_> [white]
<_florin_> comment = White Plus Anvelope
<_florin_> provider = mysql
<_florin_> host = localhost
<_florin_> dbname = white
<_florin_> #dbname = developer
<_florin_> now. what do i actually have to do in order to create some spreadsheet-kind-of-form for my table?
<jamest> i'd open designer go to the file menu
<jamest> new from wizard
<jamest> then choose probably the simple wizard for now
Action: jamest is doing this from memory
<_florin_> file->new->from wizard:
<jamest> it should show you a list of connections that include the one you added
<jamest> then you can pick a table(once you've logged in)
<_florin_> <snip lots of errors>
<_florin_> DB000:   File "/usr/lib/gnue/python/gnue/designer/templates/reports/MailMerge.py", line 42, in ?
<_florin_> DB000:     class SimpleReportTemplate(ReportTemplate):
<_florin_> DB000: NameError: name 'ReportTemplate' is not defin
<_florin_> and nothing further happens.
<jamest> is this cvs or a packaged version?
<_florin_> a packaged, 0.5.2.
<_florin_> is this a gnue-designer kind of error, or just a wizard-error?
<_florin_> should i get a cvs-version of gnue? would this make things work?
<jamest> i think this is a designer wizard error :(
<_florin_> can i build that interface (for my table) by hand (-> designer yes, wizard no).
<jamest> yes
<_florin_> how?
<jamest> in the lower left you should have a list of connections
<jamest> open the one you want
<jamest> then it'll ask for login
<jamest> then drag and drop the table you want into the empty form painter area
<_florin_> in the "schema navigator" i have my db: white->people->(columns...)
<jamest> yes, drag the table name onto the form
<_florin_> (i mean: white->Tables->people->...)
dcmwai (~dcmwai@219.95.57.163) left irc: "Client exiting"
<_florin_> ok
<_florin_> i have a label: <edit> pair for each column.
<jamest> it should have created a simple form based upon your table columns
<jamest> right
<jamest> now you'll have to line them up in columns manually (the wizard would have done this for you)
<_florin_> is there any way i can reposition/resize the labels/edit fields?
<jamest> yes
<jamest> you can drag and drop them where you want
<jamest> you can set all properties on the left side property editor
<_florin_> seems to work... i was irritated by the fact that i have no visual feedback while dragging... :-)
<jamest> it should be context sensitive
<jamest> save often btw
<_florin_> ok... dragged them.
<_florin_> can i have a list or something, to show me everyting in that table?
<jamest> once you've dragged them into columns then you can set the rows property 
<jamest> which sets the max number of rows displayed
<jamest> poor mans spreadsheet :)
<jamest> that rows setting can be at the block level or row level
<jamest> er
<jamest> entry 
<jamest> block or entry level
<jamest> and you can mix and match
<nickr> party mix
<jamest> set block to display 10 and one entry in that block to display only 1
<jamest> so you can put the important stuff in a grid type layout and show less important details as 1 row per entry 
<_florin_> trying to... i think i just crashed the designer :-( but i'm starting to get the picture.
<jamest> what platform you on?
<jamest> designer is a finicky beast
<jamest> we have some wierd UI issues in there that I think are related to the way we use wxWindows
<_florin_> linux-ppc, debian testing. my wxWindows was someting like wxGtk, iirc.
<lupo__> _florin_: huhu :-)
<_florin_> i crashed the designer again (segmentation fault... i think this one does not go on me :-)
<jamest> wow
<jamest> i can't recall if we have outstanding commits for segfaults on designer
Action: jamest can't recall what has been done since last release other than the datasource stuff in common
<_florin_> well... i can reproduce it. segfault 2 :-)
<jamest> ooooo
<jamest> we've found our replacement derek!
<_florin_> glad i can help :-)
<jamest> you might try the latest devel stuff if you can
<_florin_> it happens right after setting 'rows' at block level to 10 and trying to save.
<_florin_> i'll install the cvs stuff soon...
<jamest> you hit tab after entering 10?
<_florin_> dunno... i don't think so. am i supposed to?
<jamest> at one time it helped make things more sane
<jamest> also if you can save the .gfd file with default 
<jamest> you can open it w/ any text editor
<jamest> and find the rows="1" line and replace
<jamest> or add a rows="10" to the block defs
<jamest> i think the internal .gfd file is fairly understandable
SachaS (~Sacha@dialup-196-245.conceptual.net.au) left irc: Read error: 113 (No route to host)
<_florin_> the TAB worked :-)
<_florin_> what about the other widgets, like drop-down box or similar -- can i use them instead of the edit fields?
<_florin_> or is it getting complicated?
<jamest> sure you can use them
<jamest> internally forms doesn't care what the field type is
<_florin_> and how is this database-connection thingy work?
<jamest> ?
<_florin_> how does the gnue-forms client what data comes into what widget?
<_florin_> (er... i mean how does in _know_ what data...)
<jamest> if you look in the gfd file you created
<jamest> you'll see a logic section that contains blocks
<jamest> those blocks contain fields, triggers, field modifiers, etc
<jamest> and a layout section
<jamest> layout sections contain entries
<jamest> you can have several <entry> items in the layout section that map to 1 <field> item in the logic section
<_florin_> can i delete logic items from within the designer (tree view on the left hand?)
<_florin_> or do i have to do it by hand (editor)
<jamest> i don't remember
<jamest> i think you can right click them and choose delete
Action: jamest has a bad habbit of using designer for layout then vi/emacs for triggers and logic changes
<_florin_> ... which is probably a good way, provided that one has extensive knowledge about .gfd files :-)
<_florin_> now.
<_florin_> i have something like the following:
jbailey (~jbailey@dragonfly.fundserv.com) left #gnuenterprise ("Client exiting").
<_florin_> Name: [     ]    Addr: [    ]    Accnt: [     ]
<_florin_> where name, addr and accnt are labels, the brackets are edit fields.
<_florin_> i'll put a drop-down list right under the name edit-field.
<_florin_> i'm required to select a data source and specify a field name.
<_florin_> i assume i have to select 'use an existing data source'.
<_florin_> but what about the field name?
<jamest> that would use one that is already part of the form you're creating
<_florin_> i have three fields so far in my logic part. the one i want is name="fldName" field="name".
<_florin_> so which one is it? "fldName", or just plain "name"?
<jamest> name="fldName"
<jamest> but
<jamest> where are these name values coming from?
<jamest> the database itself?
<jamest> er
<jamest> the same table itself?
<jamest> or some other table ?
<_florin_> yes, it's the same table. is that bad?
<_florin_> (just think of the dropdown as of an alternate view of the database... it actually makes no real sense, it's just for me to get the feeling of it)
<_florin_> i'm trying to have a spreadsheed-like view without that multiple-edit-fields thing, which is rather ugly...
<jamest> i think this is doable
<_florin_> what about key/description values? leave them on default (name, name)?
<jamest> description is what appears in the dropdown as an option
<jamest> key is what is actually stored in the database field
<_florin_> so key would be like '%Smith' or something?
<_florin_> (like a search pattern?)
<jamest> no
<_florin_> i think something's going wrong. i got the following new entry in my gfd/logic:
<_florin_>  <field name="fldfldName" field="fldName" fk_description="name"
<_florin_>              fk_key="name" fk_source="dtsPeople"/>
<jamest> lets use the US states as a sample
<jamest> lets say I'm entering the state for a sales form
<jamest> I'd want the downdown to spell out the state
<jamest> but to only store the 2 char value
<jamest> that way my sales reps don't say "Alaska huh?  must be AL"
<jamest> then I'd have a lookup table that contained state/description fields
<jamest>  AK    | Alaska
<jamest> er
<jamest>  state |          description
<jamest> -------+--------------------------------
<jamest>  AL    | Alabama
<jamest>  AK    | Alaska
<_florin_> so i'd give key="state" and description="description"?
<jamest> right
<jamest> i'm trying to find a sample 
<jamest> ok
<_florin_> (then setting both to "name" would be the correct for me, since i want to see and search for the actual names)
<jamest> did you package contain a samples directory?
<_florin_> i don't know...
<jamest> i imagine on debian it would have ened up in /usr/share/gnue-forms
<jamest> or something like that
<jamest> if not
<jamest> http://www.math.ksu.edu/~jamest/downloads/
<jamest> you'll find zipcode.gfd
<jamest> that shows a very simple use of a dropdown
<jamest> also
<_florin_> ok.
<jamest> http://www.gnuenterprise.org/~jcater/docs/forms/
<jamest> jcater has fairly recent pdf files of several guides that I'm not sure if they made it into the last release
<_florin_> i'll look into those from jcater's home directory.
<_florin_> i got an error now from gnue-forms: 1054 unknown column "fldName" in 'field list'
<jamest> does it still list a fldfldName?
<jamest> wait
<jamest> nevermind, confused self
<jamest> what's that line look like now?
<_florin_> it did.
<_florin_> i changed it to:
<Vee> bleh bleh bleh
<_florin_> <field name="fldfldName" field="name" fk_description="name"
<_florin_>              fk_key="name" fk_source="dtsPeople"/>
<_florin_> now it crashes with:
<_florin_> DB000: AttributeError: 'NoneType' object has no attribute 'has_key'
btami (~tamas@wrr.napnet.hu) joined #gnuenterprise.
<Vee> I have 2 tables of 'names' I want to get a distinct list of names that exist in either table.. 
<Vee> hmm.. select distinct B.name, A.name from A left join B using (name) gives me all A, but I'm missing the unique entries from B.. 
<jcater> what database?
<Vee> mysql :)
<jcater> oh
<jcater> sorry
<jcater> can't help
<Vee> really need a union
<jamest> _florin_: i think you might want
<jamest> <field name="fldName" field="name" fk_description="name" fk_key="name" fk_source="dtsPeople"/>
<jamest> but I've never tried a block re-referencing itself for key values
<jamest> bbi1h, lunch
<jcater> Vee: that was my thought
btami_ (~tamas@wrr.napnet.hu) joined #gnuenterprise.
btami (~tamas@wrr.napnet.hu) left irc: Read error: 110 (Connection timed out)
Nick change: btami_ -> btami
_florin__ (~florin@p5085F74C.dip.t-dialin.net) joined #gnuenterprise.
<_florin__> design question: in application development using gnue, where's the point where a 2-tier approach is a bad choice and 3-tier starts to be the good choice?
_florin_ (~florin@pD9E6913B.dip.t-dialin.net) left irc: Read error: 60 (Operation timed out)
<_florin__> related question: for 3-tier, the app-server is needed, right? how usable is it yet?
<reinhard> _florin__: i can answer the second question
<reinhard> appserver is heavily under development and is just about starting to become usable
<reinhard> i can't answer the first question because i'm biased ;-)
<Vee> jcater, yea.. we really need to upgrade our servers to mysql 4.x or even better postgresql but that's a ways off still.. almost got me a work around though.. using a temp table 
nenhum (~juanjo@213.172.36.226) left #gnuenterprise ("Client exiting").
johannesV_ (~johannes@M1564P005.adsl.highway.telekom.at) left irc: "Leaving"
<_florin__> reinhard: biased in what way?
<lupo__> he's one of the main appserver hackers. :-)
<_florin__> oh
<_florin__> that's biased...
<_florin__> what still needs to be done in order to have the appserver on a usable level?
<_florin__> (and i'd still like to hear some opinions/experiences on 2 vs 3 tier design, if someone feels like chatting...)
<_florin__> thanks for your help! now i have my hello world :-) gotta go now...
_florin__ (~florin@p5085F74C.dip.t-dialin.net) left #gnuenterprise.
ajmitch (~ajmitch@pop11-port75.jetstart.maxnet.co.nz) joined #gnuenterprise.
jamest (~jamest@gw.math.ksu.edu) left irc: Remote closed the connection
jamest (~jamest@gw.math.ksu.edu) joined #gnuenterprise.
jamest (~jamest@gw.math.ksu.edu) got netsplit.
sjc (~sjc@cpc2-seve3-4-0-cust112.popl.cable.ntl.com) got netsplit.
jamest (~jamest@gw.math.ksu.edu) returned to #gnuenterprise.
sjc (~sjc@cpc2-seve3-4-0-cust112.popl.cable.ntl.com) returned to #gnuenterprise.
#gnuenterprise: mode change '+b *!*@199.243.96.2*' by saberhagen.freenode.net
lupo__ (lupo@pD9E680EF.dip.t-dialin.net) left irc: Read error: 110 (Connection timed out)
lupo__ (lupo@p5085F73E.dip.t-dialin.net) joined #gnuenterprise.
dsmith (~user@mail.actron.com) left irc: Remote closed the connection
dsmith (~user@mail.actron.com) joined #gnuenterprise.
jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: "home"
Action: Poincare test
<jamest> test confirmed
ajmitch_ (~ajmitch@vodca.otago.ac.nz) joined #gnuenterprise.
kilo (~kg_kilo@fw.i-trade.hu) joined #gnuenterprise.
<jamest> reinhard: i see you removed that comment but any ideas on why it was there?
sjc (~sjc@cpc2-seve3-4-0-cust112.popl.cable.ntl.com) left irc: "sleeping"
<reinhard> jamest: no
<reinhard> but it was just too annoying
<reinhard> it was printed like 100 times
<ajmitch_> hi reinhard
<ajmitch_> & jamest :)
<reinhard> hi
<jamest> :)
<jamest> gotcha
lupo__ (lupo@p5085F73E.dip.t-dialin.net) left irc: Remote closed the connection
<btami> jamest: that comment was from jcater IIRC
<btami> but blame derek of course :)
<jamest> of course
<jamest> i'd blame jcater but he's not feeling well
<kilo> old trick to escape being blamed 8-))
jcater (~jcater@cpe-066-061-071-147.midsouth.rr.com) joined #gnuenterprise.
<kilo> silent, he has cometh...
<jamest> mr cater
<chillywilly> carter
<chillywilly> yo carter
<jamest> kater
<chillywilly> cooter
<jamest> hooter
<jamest> 'puter
<jamest> can you look at reinhards last commit and give insight into what that comment meant
Action: jcater looks up from his theraflu and wonders wtf is going on
<chillywilly> stupor
<jcater> well
<jcater> judging from his comment
<jcater> it looks like the message was pissing reinhard off
<jcater> but that's just a hunch
<jamest> nah, i meant in the code itself
<jcater> ah
<jamest> that note only means something to one person
<jamest> and he's on drugs
<jamest> theraflu from what I hear
<chillywilly> drugee
<ajmitch_> poor chap
<jcater> man
<jcater> y'all are worse than my users
<jcater> I come home to rest
<jcater> and get bombarded
<jcater> =)
<jcater> requestConnection is a relic of the old combined DataObject+DataConnection days
<ajmitch_> it's just to show that we luv you
<jamest> we wanted you to feel at ease
<jamest> and you're used to total soul draining unrelenting harassment
<kilo> you need whisky. if it kills flu, it is good. if it does not, at least you feel good 8-))
<jamest> since your wife and users are at work we have to fill in until she returns
<jcater> kilo: already on top of it
<jamest> vodka and niquil 
<jcater> Southern Comfort, actually
<chillywilly> isn't that a dangerous combo?
<jamest> 1 week till kde 3.2 release
Action: jamest does a happy dance
<kilo> whisky = uisge beatha in gaelic, that mean 'the water of life'
<chillywilly> who cares?
<chillywilly> ;P
<jcater> iirc, getConnection replaced the old requestConnection logic
<jcater> requestConnection had to be passed a DataObject
<jcater> which really limited it
<jcater> now you can simply do
<jcater> conn = connections.requestConnection("gnue")
Action: chillywilly is kde free again....maybe I have like desktop personality disorder
<jcater> plus you can pass it an autologin boolean variable
<jcater> and don't have to manually call loginToConnection
<jcater> it will do it when the time comes
<jcater> the old requestConnection call was more a hack
<jcater> it's been on my list to glimpse for requestConnection
<jcater> and fix all the calls to it
<jcater> but,  um
<jcater> err
<jcater> well
<jcater> haven
<jcater> haven't had time/motivation to gnue this past month
<jcater> (or two)
<chillywilly> slacker
<chillywilly> ;P
dneighbo (~dneighbo@ip68-109-180-32.ph.ph.cox.net) joined #gnuenterprise.
jamest (~jamest@gw.math.ksu.edu) left irc: "Client exiting"
derek (~dneighbo@ip68-109-180-32.ph.ph.cox.net) left irc: Connection timed out
btami (~tamas@wrr.napnet.hu) left irc: 
reinhard (~reinhard@M1264P004.adsl.highway.telekom.at) left irc: "There's always one more imbecile than you expect."
Nick change: dsmith -> goops
Nick change: goops -> dsmith
kilo (~kg_kilo@fw.i-trade.hu) left irc: 
SachaS (~sacha@online.havanawave.com) joined #gnuenterprise.
SachaS (~sacha@online.havanawave.com) left irc: Client Quit
SachaS (~sacha@online.havanawave.com) joined #gnuenterprise.
marcello (~marcello@adsl-ull-238-119.42-151.net24.it) joined #gnuenterprise.
dsmith (~user@mail.actron.com) left irc: "Good Night"
nenhum (~nenhum@cm0085.red.mundo-r.com) joined #gnuenterprise.
nenhum (~nenhum@cm0085.red.mundo-r.com) left irc: "Nunca+"
jcater (~jcater@cpe-066-061-071-147.midsouth.rr.com) left irc: "Client exiting"
<marcello> query #dpkg
<marcello> oops
wendall911 (~wendallc@216.255.199.8) left irc: "Download Gaim: http://gaim.sourceforge.net/"
someon (~some1@h24-81-151-173.vf.shawcable.net) joined #gnuenterprise.
marcello (~marcello@adsl-ull-238-119.42-151.net24.it) left irc: "Leaving"
ajmitch_ (~ajmitch@vodca.otago.ac.nz) left irc: "Leaving"
--- Wed Jan 28 2004