*** ayers has joined #gnuenterprise
*** reinhard has joined #gnuenterprise
<reinhard> good morning
<ayers> reinhard: good morning! :-)
<ayers> I've got my application partially running.
<ayers> But I have a few questions/issues.
<reinhard> shoot :)
<ayers> OK.. first off...
<ayers> I have a "Customer"
<ayers> I have a "Mailing" that refers to a "Customer"
<ayers> In the layout file of the customer I have a search position for tha customers 'code'.
<ayers> When I edit a mailing I therefor have a lookup for customer code to assign the customer... everthing is fine.
<reinhard> ok
<ayers> But now I have a mailingentry (mailing to mailing entry is a to many relationship)
<ayers> The Mailing also has a 'code' but I also want to add the customer 'code' as search field for the mailing entry.
<ayers> I can add the "customer" field, but that lookup will show me the internal gnue_id.
<ayers> (i.e. I can add the 'customer' search field to the 'mailing' layout.)
<ayers> So I suppose I need to actually add a 'customercode' field to the mailing that gets syncronized with the 'customer' attribute.
<reinhard> mailingentry : mailing is 1:n ?
<reinhard> no
<reinhard> mailingentry : mailing = n:1 ?
<ayers> the later, yes
<reinhard> and mailing : customer = n:1, too?
<ayers> ACK
<reinhard> ok, I see
<reinhard> I think I'd have to take a closer look at this
<ayers> I can send you the code... if you like?
<reinhard> I think that would help
<reinhard> thank
<reinhard> thanks
<ayers> sure
<ayers> it's on its way... I'll see if I can setup a svn repository for it...
<ayers> the active folders are ./etc ./classes ./layouts ./processes
<ayers> the ./barcode is an unrelated tool... ./form just conains experiments and ./schema was an attempt to load data into the tables defined by classes (but haven't got it to work yet)
<reinhard> oka
<reinhard> y
<reinhard> will look at it later
<ayers> Thanks!
*** johannesV has joined #gnuenterprise
*** btami has joined #gnuenterprise
*** snigelgr has quit IRC
*** johannesV_ has joined #gnuenterprise
*** johannesV has quit IRC
<ayers> how can one traverse realtionships (i.e. attributes referencing other classes) in OnChange code?
<ayers> I'm trying something like:
<ayers>     <procedure name="OnChange">
<ayers>       <![CDATA[
<ayers>         if propertyName == 'ADM_customer':
<ayers>           self.customercode = newValue.code
<ayers>       ]]>
<ayers>     </procedure>
<ayers> where I thought newValue would contain the object... but it seems to be a unicode string.
<reinhard> I think you might need something like
<reinhard> mycustomer = find('ADM_customer', conditions={'gnue_id': newValue})[0]
<reinhard> to find the object
<reinhard> or rather
<reinhard> mycustomer = session.get('ADM_customer', newValue)
<ayers> This may do the trick... but now I've got an acception because the code is trying to modify  read-only attribute.
<ayers> I thought read-only would only apply to the UI and not to code... Let my try to change that for now...
<reinhard> let me add that I consider it very unlikely that you really end up needing a redundant customer id in that class
<ayers> OK... :-)
<reinhard> but of course a learning effect is there when trying how it *would* be done if you needed it :)
<ayers> Well I will need it later anyway for presetting values.
<ayers> But actually I'd like them to be preset immdieatly (as in form like triggers) rather than on commit.
<ayers> But I suppose I would need a read form (as opposed to a .gld) to do that.
<reinhard> you mean preset for new records?
<reinhard> you would do that in OnInit
<ayers> Well preset depending on assigned values
<ayers> ie: Customers define prefered character sets.
<ayers> so when I create a new mailing and I assign the customer the character set of the mailing should be set to the same value as the customer.
<ayers> s/customer./customer's./
<ayers> During OnInit the customer hasn't been set naturally so I can't determine the character set for the mail at that time.
<ayers> To work around that, I could create three attributes:
<ayers> 1st: a calculated attribute from the customer's character set
<ayers> 2nd: a real property for the mailing's characterset which will remain empty by default
<ayers> 3rd: a calculated attribute that will either take the mailing characterset if set or the customers version.
<ayers> hmm well I guess I could drop the first attribute.
<reinhard> yes
<reinhard> that would be something like
<reinhard> Character set:
<reinhard> (o) Customer standard (ISO-8859-1)
<reinhard> ( ) individual: _____________________
<reinhard> it's a matter of taste whether that is better than just having a charset
<reinhard> and having it change automatically with every change of the customer field
<reinhard> you can do both
<ayers> I can't seem to get the read-only attribute out of the repository... I guess I'll need to recreate it.
<ayers> should I be able to load data with gsscvs and a .gsd file into a repository created by *gcd class files?
<reinhard> sure
<reinhard> there is a list of countries in the samples IIRC
<ayers> seem I need to set gnue_id
<ayers> the examples with the country doesn't use classes.. it uses schema and tables.
<ayers> so I wasn't sure that would work
<ayers> is there a way to dump the current data into a data file?
<ayers> It also uses a schema with a primarykey definition.. can that also be done with classes?
* ayers tries
<ayers> Unbekannter Tag <primarykey>
<ayers> It also seems that gsscvs cannot find the correct table for the class either.
<ayers> I've tried both tablename="Classname" and tablename="Module_Classname"
<ayers> both raise exception that they cannot find the table.
<ayers> my command line looks like:
<ayers> sudo gsscvs --connection=appserver --mode data schema/data.gsd
<ayers> And I get: ERROR:exception.system.exceptions.KeyError:Unhandled exception KeyError:
<ayers> ...
<ayers>   File "/usr/local/src/svn/gnue/gnue/.svndevelbase/gnue/common/datasources/readgsd.py", line 408, in __import_data
<ayers>     raise InvalidFieldsError, (item.tablename, n,
<ayers> KeyError: u'ADM_Characterset'
<reinhard> ayers: you must import the data into the backend connection
<reinhard> directly to the database
<reinhard> not into the appserver connection
<ayers> OK. so that would be [gnue] in my case I believe...
<ayers> sudo gsscvs --connection=gnue --mode data schema/data.gsd
<reinhard> yes
<ayers> same error... though...
<reinhard> (although I wouldn't run that as root...)
<ayers> -rwx-----x 1 root staff 221 27. Apr 12:49 /usr/local/src/svn/gnue/gnue/gnue-common/scripts/gsscvs
<ayers> the setup-svn.py script setup the all the scripts to only be read a execuaable by root.
<reinhard> that is strange
<ayers> Well I /think/ it was the setup-svn.py script...
<reinhard> probably a matter of the umask setting
<ayers> I surely didn't check it out as root.
<ayers> I'll simply do a: sudo chmod g+rx /usr/local/src/svn/gnue/gnue/gnue-*/scripts/g*cvs for now
<reinhard> hmmm
<reinhard> I think you should check the fieldname
<reinhard> it also has to be ADM_something
<reinhard> in your gsd file
<ayers> Ah, thanks, we are getting further...
<ayers> Yes!!!
<reinhard> actually the exception should be "no field name foo in table bar"
<reinhard> but there seems to be a bug in the exception handling code :(
<reinhard> which raises another exception and makes the original exception invisibe
<reinhard> invisible
<ayers> ahh OK.  should I open some kind of bug report for this?  (once my app is done I can look whether I can help with a fix)
<reinhard> our bug tracker is down :(
<reinhard> gnue.org and gnuetnerprise.org have moved a few weeks ago
<reinhard> and not everything is up again :(
<ayers> ACK...
<reinhard> I think I fixed it
* ayers updates
<ayers> It seems you left some debug code ;-)
<ayers> ERROR:exception.application.gnue.common.datasources.readgsd.InvalidFieldsError:Unhandled exception InvalidFieldsError:
<ayers> InvalidFieldsError: Table 'ADM_RegistrationType' has no field 'code, description'
<ayers> works as expected! Thanks!
<reinhard> yep, removed the debug code again
<ayers> the navigator resizing is hiding my fields.. Let me comment out the description in the process definition.
<ayers> It seems properties defined the gcd class files but ommitted in the gld layout files are appendend in the generated form.
<ayers> is there a way to hide these properties in the generated form?
<reinhard> hmmmm
<reinhard> I am not sure
<reinhard> in any case, you could put them on a different tab so they don't clutter up the main form
<ayers> you can define tabs int a gld file?
<reinhard> yes
<ayers> Cool I though block could only be defined in forms
<ayers> *thought *blocks
<reinhard> page=...
* ayers tries
<ayers> Loading GNUe language definitions
<ayers> ERROR:exception.application.gnue.common.definitions.GParser.MarkupError:Unhandled exception MarkupError:
<ayers> XML markup error in '[unknown]' at line 29:
<ayers> Error processing <page> tag [I do not know what a <page> tag does]
<ayers> <module name="ADM" language="de">
<ayers>   <class name="Mailing" label="Sendungsverwaltung">
<ayers>     <page name="main">
<reinhard> oh sorry
<reinhard> in the gld
<ayers> yeap
<reinhard> <property name="foo" label="bar" page="Additional Information"/>
<ayers> Great! Cool!
*** Morphous has joined #gnuenterprise
<ayers> The ordering ofthe pages is always alpahabetical?
*** Morphous_ has quit IRC
<reinhard> I think it is, yes
*** jamest has joined #gnuenterprise
*** btami has quit IRC
<ayers> bbl
*** ayers has left #gnuenterprise
*** ayers has joined #gnuenterprise
*** jcater has joined #gnuenterprise
*** Morphous_ has joined #gnuenterprise
*** Morphous has quit IRC
<reinhard> ayers: ok, looked at your sample
<reinhard> I think the best way is to have a hand crafted form instead of the generated one here
<reinhard> for now
<reinhard> actually it would make sense to have the read only fields being really read only fields
<reinhard> in the generated form
<reinhard> instead of entries with style="label"
<reinhard> so you can also search for them
<reinhard> but I think we will do that with next appserver release
<reinhard> series
<reinhard> so appserver 0.5.x remains compatible with form 0.5.x
<reinhard> (IIRC read-only fields did not work too nicely in gnue-forms 0.5.x)
<reinhard> you can save the generated form to a file using "gfcvs appserver://appserver/form/ADM_mailingEntrySessionShort?debug-file=foo.gfd" so you have a starting point
*** jamest_ has joined #gnuenterprise
*** jamest has quit IRC
*** jamest_ is now known as jamest
<ayers> back
*** jamest has quit IRC
<ayers> reinhard: Thanks!  I'll try that!
*** jamest has joined #gnuenterprise
*** jamest has quit IRC
*** jamest has joined #gnuenterprise
*** derek has joined #gnuenterprise
*** sjc has joined #gnuenterprise
*** Morphous has joined #gnuenterprise
*** Morphous_ has quit IRC
<ayers> int the PRE_FOCUSOUT field trigger, self seems to be the field.
<ayers> do we have access to the current object?
*** johannesV_ has quit IRC
<ayers> Acually I currently do not need access to the object.
<ayers> I've looked at the invoces.gfd examples
<ayers> So I'm trying to have a POST-CHANGE trigger that sets values in other fields
<ayers> but it seems like it's currently not trigger (in my setup)
<ayers> ah wait...
*** jamest_ has joined #gnuenterprise
*** jamest has quit IRC
*** jamest_ has quit IRC
*** jamest has joined #gnuenterprise
<reinhard> off for today
*** reinhard has quit IRC
*** jamest has quit IRC
*** ayers has left #gnuenterprise
*** jamest has joined #gnuenterprise
*** jamest has quit IRC
*** sjc has quit IRC
*** jcater has quit IRC
*** bigbrother has joined #gnuenterprise
*** jcater has joined #gnuenterprise
*** derek has quit IRC
*** jcater has quit IRC