*** holycow has quit IRC
*** johannesV has joined #gnuenterprise
*** btami has joined #gnuenterprise
<btami> good morning
<johannesV> good mornin
*** kilo has joined #gnuenterprise
<kilo> good morning
*** sjc has joined #gnuenterprise
*** reinhard has joined #gnuenterprise
<reinhard> good morning all
*** dcmwai has joined #gnuenterprise
<johannesV> wow, subversion has been localized :)
* kilo sends a big hug and a dram o' whisky to johannesV. The first for outer joins, the latter for all the misspelling in the mail 8-)))
<johannesV> :)
*** aries has joined #gnuenterprise
<aries> hi
<aries> hi btami,kilo and all
<kilo> hi aries
<btami> hi aries
* aries refreshing his mdk-cooker files, his never give up to use gnue =)
<aries> do you know about compiere?
<aries> http://www.compiere.org/product/tour/first.html
<aries> it's a java/oracle10g based crm, almost free
<btami> yes
<btami> if you treat oracle free
<aries> btami: you can d/l it
<aries> http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/linuxsoft.html
<btami> anyhow, you can't find too much java fans here :)
<aries> =)
<aries> I'm not a java fan too, I've coded just small applets in java, but I think it's philosophy is not bad. Anyway, it's unimportant in the GNUe's case :)
<aries> But the Compiere's functionality and it's stage is very impressive, don't you mind? I think I could not code for gnue in the near future, because I don't know enough about python (and I don't have enough time to learn and to be an experienced python-user)
<aries> but I need a good CRM...
<aries> I'd like to help but w/o money and py-knowledge, a think i can't :(
<btami> if you have knowledge about CRM and other things we want in packages
<btami> you _can_ help
<kilo> (of course yuo can send us pizza...) 8-))
<aries> kilo :)
<kilo> you are the 2nd person in a week who want a crm
<aries> if you need graphics artwork and other design things, i could help
<aries> kilo: everyone needs good erp-crm-sal-fin system
<kilo> well, i would need info that we could use to develop a crm
<aries> kilo, btami: in Hungary, there're a tender of GVOP, which can help the small business are to upgrade ther system to an up-to-date erp. Do you thing we can spend the money (if we won) for GNUe, to develop a professional crm-erp-etc ?
<aries> kilo: what do you mean about "info"?
*** lekma has joined #gnuenterprise
<lekma> hi all
<btami> aries: info=what is a CRM in your mind
<kilo> hmmm, getting tender money would be great
<lekma> johannesV: i've just seen your mail
<btami> hi lekma
<kilo> reinhard: info: anything that we could use to develop a crm
<kilo> hi lekma
<lekma> and don't understand yhings
<lekma> and i don't understand things
<lekma> :)
<btami> you *do* :)
<kilo> well that announce mail is pretty hard to decode 8-)))
<lekma> we used to have things like:
<johannesV> lekma, so what's the problem
<lekma> myList = session.find ('class', cond, sort, props)
<lekma> if mylist[0].module_prop:
<lekma>   do smthing
<lekma> this now raise an index error
<johannesV> lekma, and you are sure myList is *not* empty ?
<lekma> yep
<johannesV> hmm
<lekma> but mylist[0].module_prop may be None
<lekma> or used to be
<johannesV> can you paste the index-error please ?
<johannesV> lekma, can you add a line like "print len (myList)" just before the if ...
<lekma> wait a sec
<lekma> i have to solve a little mystery first (where the hell my cigs are hidden!!!!!)
<lekma> :)
<johannesV> :)
<lekma> Traceback (most recent call last):
<lekma>    File "<xul_forms.xul_XulForm>", line 16, in XulForm
<lekma>    File "/var/lib/gnue/gecocer/xul/forms.py", line 230, in run
<lekma>     if gnue_attribs[0].gnue_length:
<lekma>    File "/usr/lib/gnue/appserver/language/ObjectList.py", line 95, in __getitem__
<lekma>     raise IndexError
<lekma>  IndexError
<lekma> thi is the error
<lekma> well you're rigth len(gnue_attribs) = 0
<lekma> but it used to work
<lekma> :(
<lekma> i should test len (gnue_attribs) before doing anything else...
<johannesV> well
<johannesV> lekma you could do: if gnue_attribs: ...
<johannesV> which does that length-check without retrieving the complete list from the backend
<lekma> wait....
<johannesV> to be precise: doing if gnue_attribs: ... calls __nonzero__ of ObjectList.py
<lekma> the list can't be empty
<lekma>           klass = 'gnue_property'
<lekma>           cond  = ['eq', ['Field', 'gnue_id'], ['Const', item.xul_property.objectId]]
<lekma>           props = ['gnue_type', 'gnue_length', 'gnue_scale']
<lekma>           gnue_attribs = self.__session.find (klass, cond, [], props)
<johannesV> ok, what is item ?
<lekma> i think it's cause 'item.xul_property.objectId'
<lekma> item is a xul item
<johannesV> hmm, maybe we cannot assume *all* selects with indirect props to be left outer, do we ?
<johannesV> but, wait
<lekma> xul_property holds a fk to gnue_property
<johannesV> in this situation it's jsut a normal condition
<lekma> but is always empty at the time of call
<johannesV> so the condition cannot return a value ? or what do you mean with 'empty' at time of call ?
<lekma> when the call occur the list is empty
<lekma> but it used to work
<johannesV> hmm
<lekma> so i should test list before doing anything...
<johannesV> well, if you're not 100% sure the list can't be empty i'd call it "defensive programming" :)
<johannesV> but i'm still curious about this casse
<johannesV> s/casse/case
<johannesV> does item.xul_property.objectId contain a valid 'gnue_id' or not ? and if not, what does it hold then ?
<lekma> ok let's restart.... i'm confused this morning :(
<aries> btami: so, you need to know what i'd like to see in gnue called crm package
<lekma> what should be returned by 'if item.xul_property is not None:' assuming item is an object of class xul_item and xul_property is an fk to gnue_property that can be empty or not
<lekma> ?
<lekma> i think this is where pb starts
<johannesV> change it to: "if item.xul_property: ..."
<aries> btami: if try to write the ORACLE and other (SAP, SCALA) application servers' summary
<btami> aries: yep
<johannesV> lekma, you do get an instance of 'NullObject' which behaves like None
<aries> btami: is it enough?
<johannesV> but is not None
<lekma> ok so here we are
<johannesV> but
<johannesV> if xul_property is *not* a reference-property you would get 'None' (python type)
<johannesV> lekma, best thing would be to check all occurences of "... is None" and "... is not None"
<johannesV> and wherever a language-interface-Object is involved change it to " if x: ..." or "if not x: ...."
<johannesV> i'm sorry for that, but i thought the 'advantage' of doing foo.bar.baz is greater than the drawback of loosing identity to None
<johannesV> since it saves me from a lot of is not None -checks
<lekma> i agree
<lekma> another question
<lekma> how would i "empty" an fk
<lekma> we used to set to None
<lekma> will it work
<lekma> ?
<johannesV> i think so, but (what a shame ....) haven't tried ...
<johannesV> gimme a few secs
<lekma> since you're trying
<lekma> how would i select
<lekma> occurences of fk that are empty
<lekma> ?
<johannesV> lekma, to clear a refrence: just set it to None
<johannesV> lekma, can you precise the last question ?
<johannesV> do you mean something like this:  guys = sess_a.find ('person', {'address_country': None})
<johannesV> you would have to do it like:
<johannesV> guys = session.find ('address_person', ['null', ['field': 'address_country']])
<johannesV> (note: using a dictionary for conditions always creates equality for all keys)
<johannesV> bbl
*** btami has quit IRC
*** ajmitch_ has quit IRC
<aries> I have to go. Bye!
*** aries has quit IRC
<lekma> johannesV: that was what i meant...
<lekma> thank for the help
*** btami has joined #gnuenterprise
*** ajmitch_ has joined #gnuenterprise
*** btami has quit IRC
*** sjc has quit IRC
<lekma> any common guru around?
<lekma> why is there in gnue-common/src/rpc/drivers/xmlrpc
<lekma> in pw_xmlrpc/ServerAdapter.py
<lekma> line 359: string.join (errors.getException (1), u'\x91')
<lekma> ??
<lekma> why thi join on u'\x91'
<lekma> ?
<lekma> and then in ClientAdapter a split on u'\x91'
<lekma> let me rephrase:
<lekma> why the char in join and split is \x91
<lekma> it doesn't seem to decoded by python in utf-8
<lekma> it doesn't seem to be decoded by python in utf-8
<lekma> can someone tell me what is this char??
<lekma> never mind i foound out
<lekma> :)
<kilo> hehe
<johannesV> lekma, that was me who did that string.join
<johannesV> if you look into "gucharmap" you'll find this sequence UTF-8: 0xC2 0x91 to be PRIVATE USE ONE
<johannesV> so we're sure it does not occur in normal text
<johannesV> and theirfore it's safe to use it as field-separator (for sending back structured information to the client where it will be parsed again)
<lekma> ok
<lekma> i had a strange pb with this char appearing in errors
<lekma> but it was related to the way the error message was displayed
<lekma> not to the error message
<johannesV> actually this char should not appear in a message
<johannesV> since xmlrpc's fault-object has just a code and a string in it's constructor
<johannesV> we need a mechanism for transporting a tuple (exception-type, group, message, traceback) within a fault-object
<johannesV> lekma, do you still encounter problems with the language-interface ?
<lekma> i need to check all code before answerinfg this question
<lekma> and i won't have time to check before tomorrow
<johannesV> ok, just let me know if you need some help
<lekma> thx
<lekma> <johannesV> we need a mechanism for transporting a tuple (exception-type, group, message, traceback) within a fault-object
<lekma> wow so you mean
<lekma> by spliting on \x91 i can retrieve exception-type, group, message, traceback (in this order??)
<lekma> greaaaaaaaaaat
<johannesV> yes, of course
<lekma> i didn't realize
<johannesV> if you look into ClientAdapter.py you'll find the counterpart
<johannesV> where all these items are put into a RemoteError
<lekma> yep, now pieces fall together....
<johannesV> ok, great :)
* lekma is so dumd sometimes
* lekma is so dumb sometimes
<lekma> :)
<johannesV> things might get quite confusing some time :)
<lekma> bbl
<johannesV> me too
<kilo> if we can transport tuples, we could transport lists too...
<johannesV> kilo, the problem here was to do this using a fault-object to signal an exception
<kilo> bah 8-))
*** reinhard has left #gnuenterprise
<kilo> @seen neilt
<bigbrother> kilo: neilt was last seen here 23 hours, 35 minutes, and 40 seconds ago saying: <neilt> reinhard: you too if you have time
*** kilo has quit IRC
*** dcmwai has quit IRC
*** jamest has joined #gnuenterprise
<jamest> johannesV: properties should work again
<jamest> sorry for the delay
*** titopbs has joined #gnuenterprise
*** reinhard has joined #gnuenterprise
*** btami has joined #gnuenterprise
*** titopbs has quit IRC
*** johannesV_ has joined #gnuenterprise
*** johannesV has quit IRC
*** mixi has joined #gnuenterprise
*** dcmwai has joined #gnuenterprise
*** titopbs has joined #gnuenterprise
*** SachaS has joined #gnuenterprise
*** jcater has joined #gnuenterprise
<lekma> bye for today
*** lekma has quit IRC
*** holycow has joined #gnuenterprise
<johannesV_> jamest, great ! i'll have a look at it later, thanks !
*** aries has joined #gnuenterprise
<aries> hi all
<aries> btami: I've found Oracle Application Server 11i docs, lot of docs about financial, HR, PR, CRM etc. modules of Ora11i
<aries> btami: they are on: http://oraclesvca2.oracle.com/appsnet/
<aries> btami: i think they has useful ideas to transcend it :)
<jamest> would there be a reason unbound datasources wouldn't work anymore?
<jamest> i need an unbound block to have multiple rows
<jamest> but binding to a datasource w/o a table attached leaves the create new record disabled
<aries> btami: on this url there're implementation and user guides
<reinhard> create a new record in an unbound block?
<reinhard> never tried that
<reinhard> couldn't even tell if it ever worked
<jamest> i seem to recall it working
<jamest> but since I've been MIA for so long I wasn't sure if something changed
<jamest> i have a form that I want to create where none of the widgets tie to a real tables
<reinhard> I can't remember that we would have changed that purposedly
<reinhard> but well
<reinhard> we *do* have changed a few things in forms over the last 2 years ;-)
<jamest> :)
*** mixi has quit IRC
<aries> bye
*** aries has quit IRC
*** mnemoc_ has joined #gnuenterprise
*** mnemoc has quit IRC
<johannesV_> jamest, i did that using a static source
<jamest> ?
<jamest> i thought static sources had fixed values
<jamest> i need to take input
<johannesV_> of course, but you still can insert records into a static source
<jamest> i still think there is a bug in the nil datasource driver
<jamest> as it's isPending always returns 0
<jamest> which makes since from a never going to commit it point of view
<jamest> but forms UI won't let you add a new record until the current one isn't empty
<jamest> wtf am I talking about?
<jamest> ignore me
<johannesV_> anyway, i have such a situation in gnue-cddb project
<johannesV_> where i need to select matches available from remote cd-database
<johannesV_> i do not have a table in the backend available for that, so i create a datasource with type static
<johannesV_> insert via trigger as many new records
<johannesV_> and let the user modify that data
<jamest> i'll try it out
<johannesV_> ok
<johannesV_> :)
<johannesV_> bbl
*** johannesV_ has quit IRC
*** sjc has joined #gnuenterprise
*** nickr has quit IRC
*** SachaS_ has joined #gnuenterprise
*** btami has quit IRC
*** nickr has joined #gnuenterprise
*** SachaS has quit IRC
*** kilo has joined #gnuenterprise
*** jamest has left #gnuenterprise
*** jamest has joined #gnuenterprise
*** jcater has quit IRC
*** titopbs has quit IRC
*** holycow has quit IRC
*** jamest has left #gnuenterprise
*** reinhard has left #gnuenterprise
*** kilo has quit IRC
<nickr> Hah
<nickr> I just thought of something funny
<nickr> An example gnue app could be a suite of tools for the Hacker's Diet
<chillywilly> good for you
<chillywilly> I think Jason probably already wrote something like that
<chillywilly> ;P
<chillywilly> he's just crazy enough ;)
<nickr> Hehe
*** sjc has quit IRC
*** jcater has joined #gnuenterprise