*** bigbrother has joined #gnuenterprise *** bigbrother has joined #gnuenterprise the functions appserver exports through xmlrpc are documented in doc/api reinhard, can i reuse GNUe Common for that ? does it provide the necessary modules ? @version Vee2d2: The current (running) version of this Supybot is 0.79.9. The newest version available online is 0.79.9. yes you could use the datasources functions however that would probably mean to build your application on the general gnue-common structure to some extent at least lekma: i think that was gnue-gsdgen which did that job reinhard, you mean there is no generic way to use only the middleware part of Commons ? reinhard, middleware + data abstraction ... i have never tried i have never used common outside gnue reinhard: so how do you generate gcd files?? reinhard, hmm ok ... jcater and jamest have, so they might be able to tell you more lekma: gcd is a file format intended for manual writing reinhard, ok i will ask when they come to the channel ... manual?? our common experience up to now is that writing a gcd with your favourite editor is about 5-10 times faster than using gnue_classrepository.gfd but i think we still support the other way around, too just have to check, give me a second *** jcater has joined #gnuenterprise speak of the devil :) are there any gnue relevent rss feeds out there.. ? insanekane: voila :) are the cousins gone forever, I didnt even find reference to them when searching the site heya devil^H^H^H^H^Hkcater jcater, too. :) jcater, hello :) reinhard, thanks :) morning jcater, hi, i am trying to figure out how to use GNUe AppServer and COmmons indenpendently from the Forms and Reports framework ... can you give me some information on this ? lekma: i think i have a brain blockade now it looks like there is currently no way to get a gcd or gsd from the stuff you entered in gnue_classrepository.gfd we completely gave up on that path because people really had problems with that form insanekane: http://www.gnuenterprise.org/tools/common/docs/ Title: GNUe Common Library Documentation - GNU Enterprise (at www.gnuenterprise.org) contains a good developer's guide also http://www.gnuenterprise.org/~jcater/examples/ Title: Index of /~jcater/examples (at www.gnuenterprise.org) contians a few examples from my store bigbrother: wtf is your problem today? reinhard: ok ok thanks lekma: i hope very much you didn't spend too much time entering this stuff into the form reinhard: can you take a moment to explain me the new way?? lekma: sure i understand the manual creation of the gcd file but then what?? lekma: please take a look at sample.gcd in the samples dir that's more or less everything appserver needs a module self-contained in a single file then you do gnue-gcd2sql foo.gcd and appserver does the rest creates all the classrepository entries ie what happens if i modify an existing class creates the tables if you add new properties in a gcd file just redo gnue-gcd2sql and appserver will automatically update what's needed jcater, so that means I can switch my existing wxPython+pickled-data application to wxPython+GNUeAppserver keeping the same UI ? except that appserver won't touch existing columns in the database i.e. not do any DROP COLUMN or stuff like that yes insanekane: you might also want to check out our subversion tree and look at GNUe Point of Sale it was a custom app I did for my business but is a standalone wxPython application that uses gnue-common's datasources reinhard: ok i'll fiddle a bit with this jcater, oho ... i will check that ... jcater, you mean the POS is only in the svn tree ? lekma: i'm open for any question, thanks for playing :) insanekane: yes I didn't use appserver as my backend though but with the design of common appserver should work the same as using a database directly as far as getting appserver up and running, though bigbrother was upgraded I don't have any experience and installed moments ago any issues blame Vee2d2 er, i mean derek sorry Vee2d2 :) bigbrother: @weather 38654 jcater, i am interested in using AppServer because I wish to add some features like using an IM for doing almost-Natural-language queries, or for recieving notifications ... bigbrother: weather 38654 @weather 76248 jcater: The current temperature in Olive Branch, Mississippi is 84°F (10:20 AM CDT on August 27, 2004). Heat Index: 92°F. Conditions: Clear. Humidity: 74%. Dew Point: 75°F. Wind: SSW at 9 mph (15 km/h). Pressure: 30.10 in (1019 hPa). Visibility: 10.0 miles (16.1 kilometers). UV: 7 out of 12 Vee2d2: The current temperature in Keller, Texas is 83°F (9:53 AM CDT on August 27, 2004). Heat Index: 88°F. Conditions: Scattered Clouds. Humidity: 69%. Dew Point: 72°F. Pressure: 29.94 in (1014 hPa). Visibility: 7.0 miles (11.3 kilometers). UV: 4 out of 12 bleh what a sucky day :) good one for the indoors for sure. reinhard: it seems that restarting gnue-appserver does also the trick if you still use classrepository.gfd lekma: really wow this appserver thingy is better than i thought must be cool people those developers :-) lekma: however, the disadvantage remains the stuff you entered in the form is not as easily transportable as a file like how would you make a .deb from it ... yep you'd probably have to use gnue-gsdgen to create a dump of the gnue_* classes then import it again in the other database with gnue-schema then restart appserver on the target system what is this package www in the svn tree ? insanekane: that's our web page oh its the website reinhard, heh ... i was faster :))) this is checking that out too ... reinhard, :) not from my side ... reinhard, err ... no u indeed were faster ;) hmm ... there was an exception when trying to view the svn through th web ... reinhard: can you run gnue-gcd2sql while appserver is running?? reinhard, is there any concept of like proxy objects which are instances of objects in the AppServer and abstract away the actual connections ? something like SQLObject ? lekma: yes you can, and new modules, classes and properties should become active immediately however appserver caches that info so for changes to become active, you might need to restart appserver reinhard: another question do you still need the gnue_id property in every class you create?? lekma: it is created silently and transparently you don't need to mention it in the gcd reinhard: cool... insanekane: yes, i think there is what you want you can do things like myCustomerList = find ('customer', {'group': 'abc'}) for c in myCustomerList: print c.name print c.street c.processed = True ... this will iterate through all customers of group 'abc' reinhard: and the last question for today, i've seen (in packages folder) you can have localised version of modules and classes, how does it work? print the database fields "name" and "street" and set the boolean field "processed" to "True" lekma: you mean the .hu.gcd? yep that's easy well, kinda :-) if a module defines a class another module can extend the class so, for example, the module "foo" defines a class consequently named "foo_customer" with name, street, city the module "bar" could extend the class foo_customer to add the vatId so if you only load foo.gcd, you have the table without vat id if you also load bar.gcd, you have the same table, but with vat id this is very good to add special fields needed in some countries reinhard: i think i'm starting to get it reinhard, ok, so creating say a new customer would be like c = Customer(appserverConnection) ??? insanekane: not directly it is c = new ('customer') reinhard, hmm ok ... in fact, there is only a single class reinhard, aha ... and then setting c.name = "Some Name" would automatically update the db ? exactly hmm ok ... super :) what abt transactions ? transactions are currently handled by the database begin() .... commit() ... rollback() i assume ? ;) oho ... and yes, you would have a "session" object with these functions reinhard: and old question (and this one will be the last for today, i really have to go) but since there seem to have been a lot of change maybe it's worth asking it... but these functions don't do more than telling the db to actually do it reinhard, wow excellent :) insanekane: now that are the very basic functions of appserver reinhard, how about implementing functionality to the AppServer ? like for eg, a Jabber server ? we haven't even started to talk about the *really* fun stuff reinhard, oh ... what kind of fun stuff ??? insanekane: yeah, that :) how would you implement "unique" attribute for a property and how would you create a "sequence" (pg sense of it)? lekma: there are triggers reinhard, what ? insanekane: just a sec, please let me answer lekma's question first :) reinhard, oh sure of course :) lekma: you could use the onCommit trigger to create the sequence in the form?? it will only be generated just before saving or in the appserver?? lekma: no, just define a procedure with the name onCommit it will be called before committing this object automatically no need to do anything in the form ok lekma: sorry s/onCommit/onValidate/ there is also an onInit that gets called on creation of a new record but you can create a new record in a form and decide to not save it then you lose a number in the sequence insanekane: appserver is not targeted at internet services reinhard, ok ??? i didn't quite understand what you meant mentioning a jabber server well not a jabber server ... well sortof ... well just let me explain what you *can* do :) ok good idea :) first to make the definitions clear ok to distinguish when we talk about database and when we talk about the appserver we say "table" and "column" for databases ok and we say "class" and "property" for appserver k basically, as the first step, think of every class is a table in the db and every property is a column and then you can do more ok reinhard: thx for the explanations, i'll be back maybe later or else tomorrow and i'll bug you a little bit more :) you can, as explained above, access classes and properties as "native" python objects also, you can define reference properties so you can do if i would be an invoice object c = i.customer and c then is a customer object -- ok next, you can have procedures that is, you can do c.doSomethingWeird() yes i got that .. bye all for your customer object cya lekma *** lekma has left #gnuenterprise hmm ok and behind that is a python code you wrote even with parameters and a function result -- u mean it resides on the server ... yes, exactly ok next, you can have indirect properties like in the above example, you can access ok i.customer.name or i.customer.country.code or whatever -- next, you can have calculated fields if you have a procedure getopenAmount () for the customer object you can access c.openAmount as read-only property hmm ok like it was a db field, but it is calcuated on runtime and last, you can have triggers ok that are procedures with predefined names that automatically get called on certain events onInit, onValidate, onChange onDelete hmm ok ... code in this triggers can raise an exception which means that the commit, change, delete etc. will not take place ok that's basically all of course you can write any code you want into those procedures ok ... hmm i think thats more than enough for a variety of tasks atleast for my lowly ideas ;) now if you *would* use forms you would get the ui for many of your classes "gratis" from appserver because with current development version appserver can generate an ui definition for gnue-forms on the fly just from the class definition oho but thats a problem for me ... so classes in AppServer can do one-to-many relationships ? does it do many-to-many ? and all this is codified by writing an XML file describing the classes yes ? yes to the XML file no to many-to-many hmm how come no many-to-many ? is there are a better way acoording to GNUe ? there is no many-to-many in a relational system and appserver, while taking many advantages from the object approach is in it's basic concept still a relational system there is no many to many in a relational system ? no way ... or i don't understand what you mean? for eg. one book has many authors, an author may write many books ,,, so u need 3 tables ... one for book, one for author and one to store the relationships between authors and books yes like in a relational db yes ... in OO ... we would have 2 classes, and in each class we would store a vector for the property on which the relationship exists ... in book, a vector for authors, and in author a vector for books_written so is that possible in AppServer ? there are no vectors other than you create a detail table/class hmm ok ... so there is no concept of arrays ? as a fundamental datatype ? ok another question ... the GNUe is under GPL ... so any modules i create with it, are also GPL ? hello reinhard are you there ? reinhard, ill be back after dinner ... ciao :) and thanks for all the info :) jcater, thanks for your help :) bye *** insanekane has quit IRC good there are any other appserver users ;) * SachaS thinks jcater, jamest, derek are waiting till appserver version 1.0 i s out. in that case, go appserver go going home see ya later *** SachaS has quit IRC *** holycow has joined #gnuenterprise *** johannesV_ has quit IRC *** sjc has joined #gnuenterprise *** wendall911 has joined #gnuenterprise *** reinhard has quit IRC *** kilo has joined #gnuenterprise *** SachaS has joined #gnuenterprise *** reinhard has joined #gnuenterprise hi reinhard *** btami has joined #gnuenterprise btami: good evening i will be having a demo with gnue tomorrow will show them windows, too i installed newest exe files from download section noticed that the buttons on the toolbar look quite strange they all are in a black box is that normal? you have to install the latest common controls from ms download site ah anyhow, i'v tested them on XP only you can't give me an url, can ou? oh win me here :( and first got what you got generally it seems to work ah ok it needs 6.0 common controls hrm is that some dll or such ? yes i'm not sure i will risk installing something on my running windows machine and risk breaking something thanks for your info that's at least something i can tell them :) np reinhard: common controls is official ms stuff you can install it safely oh it is safe to install because it is from ms? that's like you say it is true because i read it in the newspaper ;-)) reinhard: maybe it will not help, i will try it on 98 later... in few word the story is: in the ToolBar.py i used a big .bmp befor it contained all icons then jason added 2 new icons to toolbar and i don't want to re-create the big .bmp from individual .bmp files again instead rewrote the code to use an empty ImageList first and add individual .bmp icons in a for cycle as other uidrivers do after this change i'v got that strange toolbar what you got too ok again thanks for the info http://www.gnuenterprise.org/~btami/source-and-py2exe.JPG off for today night all *** reinhard has quit IRC bye *** btami has quit IRC *** sjc has quit IRC :( *** switch has left #gnuenterprise *** tocer has joined #gnuenterprise *** tocer has left #gnuenterprise *** tocerdm has joined #gnuenterprise *** tocerdm has left #gnuenterprise *** jamest has left #gnuenterprise *** kilo has quit IRC *** jcater has quit IRC *** Vee2d2 has quit IRC *** Vee2d2 has joined #gnuenterprise @seen Vee2d2: seen [] *** dimas has quit IRC *** jcater has joined #gnuenterprise *** holycow has quit IRC *** ajmitch_ has joined #gnuenterprise morning *** tocer has joined #gnuenterprise *** tocer has left #gnuenterprise hi ajmitch_ *** wendall911 has quit IRC word up chillywilly and ajmitch *** switch has joined #gnuenterprise just trying to learn how reports can be useful *** switch has quit IRC whiirrred chillywilly *** ncjp has quit IRC ajmitch hello *** holycow has joined #gnuenterprise *** jcater has quit IRC *** sjc has joined #gnuenterprise *** lekma has joined #gnuenterprise *** reinhard has joined #gnuenterprise i am reading the log. reinhard, what do you mean we need more chicks? ;) hi all reinhard: can you specify foreign keys in a gcd file ? lekma yes: as type you just use MODULENAME_CLASSNAME yeah i've seen this, but the foreign key point on gnue_id, what i want is to have it point on a specific field/property of another table/class is this possible ? hmmm, if i understand right from your questions from yesterday you have another field as primary key in that other table/class. eg a customer_id yes something like this which brings another question you would have to ask reinhard, i think per default the primary key is gnue_id can you specify a primary key in a gcd? the question is: can you define a primary key other than gnue_id yep, thx for clarifying it... i have not seen that feature in a .gcd again you have to check with reinhard. it could be a new feature. SachaS: can you take a moment to explain me what those new gld file... are ? i have played with .gld files. but I still have not completely figured out how they work i have a project with a couple of .gcd files so at the moment I want to concentrate to get the application right == at the moment I do not want to waste time on designing nice forms ok, thx so i write a .gld file per class and so I can check the application but dont waste time fiddling with creating nice forms. does this answer your question? lekma: currently there is no way to use a field as primary key other than gnue_id reinhard: ok there *might* be this feature at some point but not in the near future SachaS: how do you use the gld file gnue-read-gld? lekma: if you look at the gcd files, there's much information in there and appserver is nearly able to build a form from only this info the missing info is in the gld which is the labels to use, the order, and some other details gnue-readgld *but* you need post 0.1 i.e. current svn version how do you call it? i mean the form resulting from a couple gcd/gld? if your appserver connection in connections.conf is [appsconn] and your class is foo_bar then you call it with gnue-forms appserver://appsconn/form/foo_bar wow i'm gonna test this right away reinhard: i still need to know if i can specify a foreign key other than one pointing on gnue_id, is this possible? reinhard I tried to call a generated form. module x with class y. module z which extends class y of module x. Only the OnInit of modulex x with class y is called NOT all OnInit bound triggers. lekma: as you can't specify a primary key other than gnue_id there will be no foreign key other than gnue_id of course.. you can of course just have a normal field but then you have no referential integrity checking from the db you would have to do it yourself in triggers SachaS: you told that to johannes, right? I think he is looking at it right. will check again whether all OnInit bound triggers are called of an extended class. I think he might even already have fixed it i was working on my project for 2 days. johannes was away for those 2 days. i had some issues. one issue was: not all bound triggers were called. another issues was: I had the impression that all extensions (extending properties) must be nullable. otherwise you get an error, obviously all previous records do NOT have the extended properties. in my view that was an limimtation. have to check again. it might be importantant, when you use package X, which extends a class, that packages X needs/wants to have its properties non-nullable. i think these were the two main issues I was seeing. oh yeah, another issue was: to have default values set in a .gcd file. SachaS: these latter 2 are closely connected so a onInit fills a record with default values, or if a user hits "new record" the default values will be displayed... if you don't have default values, extension properties *must* be nullable or the extension can't be installed into an existing db ok i see the connection. ok, demo starting with having default values, the values of the extended properties of previous records would be set to those default value. good luck with the demol. SachaS exactly s/demol./demo maybe there needs a third type: n/a not availlable. because maybe its not a good idea to set the default value to previous records. johannesV was trying to figure out how appserver could "remember" default values for properties. eg a new gnue_ table etc. another issue was dependencies: but I think that could be solved like .deb packages. eg packages X depends on package Y which depends on package Z i have an issue with .gld. for one property I do get a dropdown, for the other property I do not get a dropdown both propertis are of a referenced data type the one property where I get a drop down is defined in the same .gcd file the one property where I do not get a drop down is (eg it references a class of a different module) defined in another .gcd file re n/a the not available datatype or value. i remember a conversation with a guy of incomplete information. we somehow must give more information about the incomplete information. eg a default value for exmple, or a null value, a n/a value, or a not used value. maybe someone knows more about it. * SachaS confirms, that two OnInit bound procedures are called. I used a gnue-designer(tm) made form against an extended class. ok will test with .gld file again. * SachaS confirms that all (2 in my example) OnInit bound procedures are called when using a .gld form. when I look at the appserver log window, and when I can trust the order, then the OnInit of the module which extends the class is called first, last is the original base class. actually I was expecting the reverse. first the base class onInit, followed by all extended OnInit triggers. in the current situation I imagine the extended onInit cannot access the base object, as it is not yet created. will test. SachaS: how do you call an appserver procedure from a form? the order the OnInit are called should follow the dependency, IMHO eg the onInit bound trigger or procedure is called whenever you create a new record (or object) the sample.gcd/gfd show datasource.call("proc_name"), but it doesn't seem to work other wise look in the samples dir, there is a form with a button when pressed calls a procedure on the appserver ok let me check retval = dtsPerson.call("address_show", {}) if retval is not None: print "retval =", retval ]]> did you use the second argument of the call procedure? ?? this sample doesn't do anything here it is supposed to print address_name but it doesn't i finish first my test, then i look at the sample, one minute. ok thx reinhard: yes the order of the onInit should be reverse, i think. module x with class y. module z which extends class y. onInit of z_y is called first. there you cannot access x_y so thats a problem. RemoteError: Instance '48760175068174029133591956859853' of class 'project_project' not found ok lekma testing the sample. lekma, it works for me. you must have a record in the form. so search without any criterias hi and you should get 4 records (spock, mccoy, chekov, and kirk) then hit show record and appserver prints a statement hi ajmitch. i got the records but it doesn't print anything is this supposed to work with 0.1.0 appserveror post 0.1.0? is this supposed to work with 0.1.0 appserveror or post 0.1.0? s/appserveror/appserver hi ajmitch * holycow waves to all heya hi holycow *** holycow has quit IRC *** mixi^ has quit IRC *** MiXi has joined #gnuenterprise *** skiold has joined #gnuenterprise lekma it should just work where do you look for something to print? its where you started the appserver. oohh, wait i'll check SachaS: ok i see it now SachaS: thx *** Vee has quit IRC *** Vee has joined #gnuenterprise ok. lekma. reinhard: seems like in an onInit I cannot access the objects properties. in samples.gcd onInit: print self.address_name I get an error: RemoteError: Instance '14117849080354379075377898981004' of class 'address_person' not found how did the demo go? SachaS: to get a dropdown, you have to mark the field you want to see in the dropdown as "search="100"" (in the referenced table) *** ncjp has joined #gnuenterprise SachaS: re order of OnInit calls - I agree that the OnInit for the module that defined the class should be first - can you please send a mail to gnue-dev? *** Vee has quit IRC lekma: please be aware that the print address_name runs server side! reinhard: will send the email SachaS: please also mention the error you get when accessing other properties lekma: oh, just saw you already found out demo went fine they seem to be interested to develop something using appserver *** ncjp has quit IRC reinhard: is the api.txt doc valid for 0.1.0? yes (at least it should) *** ncjp has joined #gnuenterprise reinhard: jbailey got same problem with trying to build appserver deb, I've got to try & track it down now :( hmmm reinhard: could you provide some example on how to use stringtable and stinglist types? ajmitch: you have any error message? lekma: not sure if api.txt is acutally what you want to read at all reinhard: :) it's the api between appserver and gnue-forms / gnue-reports reinhard: ok, then how can i retrieve all the values from a given field/property? reinhard: just that it can't import gnue ah reinhard: ie not in a form but in a gcd ajmitch: that means probably that gnue.pth is missing lekma: you mean in a procedure code? reinhard: that's the thing - it's not gnue.pth is present, has correct permissions, and is pointing to the right place yep ajmitch: what happens when you simply do "import gnue" from the python prompt? reinhard: for me, it works fine on jbailey's box with my gnue-common 0.5.7, it didn't lekma: can you please explain what you mean with "al the values from a given field/property" can you give me an example? reinhard: another reinhard: let's say i have a module foo, a class bar an a property barId i want in an OnValidate() in the class foo_bar, to list all the values already in the db for property foo_barId is this possible reinhard: another question is where can i get the list of all predefine bound procedure (OnValidate, OnCommit,...)? yes list = find ('foo_bar', {}, 'foo_barId') for i in list: print i.barId -- you find the list in api.txt brb reinhard: ok thanks *** MiXi has left #gnuenterprise *** MiXi has joined #gnuenterprise *** Vee has joined #gnuenterprise *** MiXi has joined #gnuenterprise *** mixi^ has joined #gnuenterprise *** MiXi has quit IRC reinhard: list = find ('foo_bar', {}, 'foo_barId') <-- is this post 0.1.0 material ?? *** Vee has quit IRC *** Vee has joined #gnuenterprise no, should work with 0.1 if i use svn, when i change a gcd i should use gnue-readgcd instead of gnue-gcd2sql? lekma: yeah, exactly we renamed that because gnue-gcd2sql doesn't generate sql any more :) thx File "/usr/lib/gnue/common/rpc/drivers/xmlrpc/pw_xmlrpc/ClientAdapter.py", line 96, in _runMethod raise client.DistantError, e.faultString DistantError is what i got when using list = find ('foo_bar', {}, 'foo_barId') in Onvalidate in the form side, nothing unusual in server output with 0.1 and svn (the error output is slightly different between 0.1 and svn) sorry mixed up parameter order try find ('foo_bar', properties = ['foo_barId']) ok thx you can also add a sortorder = [fieldname, fieldname] to define the sorting of the resulting list and, in case you care, making the error output more usable is something that we are working on right now :) just as a minor hint in case you want to use this for a sequential id i think it's a suboptimal way to do it iterating through all records might be bad for performance if your table grows big) better have a second class where you store the last barId you used reinhard I was thinking about the bound triggers. the transaction has to be over all bound triggers, not each individual. not sure if that is currently the case or not. the bound triggers will be part of the same transaction as the event that fires them i.e. if you store an object ok. so thats fine. reinhard: no, i'm trying to test if an entry doesn't already exist... i'm not yet on sequences all OnValidate triggers *and* the storing of the object itself are one single transaction oh lekma: then you'd probably want if find ('foo_bar', conditions = {'foo_barId': valueToTest}): print "already existing!" and leave the dirty job to the database SachaS: you ask why we need more chicks "there's nothing like a good meal, a good wine, and a bad girl" ;-) haha reinhard: i have the same error with find ('foo_bar', properties = ['foo_barId']) i'm using current gnue-forms and svn gnue-appserver lekma: sorry i have to leave right now :(( ok, see you the problem is that you don't see the *real* exception in the error message will be here again on monday sorry to leave you without being able to help will try to solve that on monday if you are here again bye *** reinhard has quit IRC thx and bye *** jcater has joined #gnuenterprise *** lxf has joined #gnuenterprise *** tocer has joined #gnuenterprise *** tocer has left #gnuenterprise *** mixi^_ has joined #gnuenterprise *** lekma has left #gnuenterprise *** mixi^ has quit IRC *** mixi^_ has quit IRC *** mixi^_ has joined #gnuenterprise *** lekma has joined #gnuenterprise *** mixi^_ has quit IRC *** mixi^_ has joined #gnuenterprise *** derek has quit IRC *** derek has joined #gnuenterprise *** mixi^_ has quit IRC *** mixi has joined #gnuenterprise *** lekma has quit IRC *** lxf has quit IRC *** Vee has quit IRC *** ajmitch_ has quit IRC *** Vee has joined #gnuenterprise *** ajmitch_ has joined #gnuenterprise *** skiold has quit IRC anyone know of a utility to generate ann md5 password? *** holycow has joined #gnuenterprise *** jcater has quit IRC *** jcater has joined #gnuenterprise *** chillywilly has quit IRC *** chillywilly has joined #gnuenterprise *** chillywilly has quit IRC *** chillywilly has joined #gnuenterprise *** cilkay has quit IRC *** cilkay has joined #gnuenterprise *** cilkay has joined #gnuenterprise *** sjc has quit IRC *** tocer has joined #gnuenterprise *** tocer has left #gnuenterprise *** jcater has quit IRC *** jcater has joined #gnuenterprise *** chillywilly has quit IRC *** chillywilly has joined #gnuenterprise *** chillywilly has quit IRC *** chillywilly has joined #gnuenterprise *** chillywilly has quit IRC *** chillywilly has joined #gnuenterprise *** insanekane has joined #gnuenterprise *** sjc has joined #gnuenterprise *** thomas has joined #gnuenterprise I am trying to find out the status of the financials. Actually of all the packages. The www.gnuenterprise.org status system doesnt work. Anybody out there know anything about the status of the packages? Is everything just in the planning stages? *** sjc has quit IRC *** thomas has quit IRC *** insanekane has quit IRC *** sjc has joined #gnuenterprise *** sjc has quit IRC *** sjc has joined #gnuenterprise *** insanekane has joined #gnuenterprise hi .. what version of wx is supported by gnuenterprise ? my version is generating a segfault when trying the classrepository.gfd file *** insanekane has quit IRC *** insanekane has joined #gnuenterprise *** mixi^ has joined #gnuenterprise *** mixi has quit IRC *** mixi^ has quit IRC *** mixi^ has joined #gnuenterprise *** tocer has joined #gnuenterprise *** tocer has left #gnuenterprise *** insanekane has quit IRC insanekane using the classrepository.gfd is outdated. the latest way to develop an application is to write .gcd files have a look at the sample.gcd file in the gnue-appserver/samples directory *** holycow has quit IRC *** insanekane has joined #gnuenterprise *** skiold has joined #gnuenterprise *** insanekane has quit IRC *** skiold has quit IRC *** skiold has joined #gnuenterprise *** skiold has quit IRC *** psu has joined #gnuenterprise *** mixi^ has quit IRC *** mixi has joined #gnuenterprise *** mixi has quit IRC *** mixi-two has joined #gnuenterprise *** reinhard has joined #gnuenterprise *** reinhard has quit IRC *** psu has quit IRC *** skiold has joined #gnuenterprise *** Ahewes has joined #gnuenterprise hi *** insanekane has joined #gnuenterprise hi ... what version of wxPython is suppported for forms ?? *** holycow has joined #gnuenterprise * holycow waves *** insanekane has quit IRC hey all anyone around? I am not that I can help lol thats all right, just curious finally got a standalone machine setup with postgres, now to muck about and see if i can get gnue to connect even :) I 'm just reading the docs I have a lot of web apps that I would like to integrate. No idea yet how I'm going to get it all together. *nod* i don't see anything out there like gnue that is this versatile *nod* *** skiold has quit IRC What the world (read: my world) needs is for some project to start hacking and chopping the major web apps to store their data in one place. unfortunately for that you need a framework agreed I use sql-ledger, request tracker, squirrelmail, interchange, and about four other apps on occasion. Individually, they all rock. lol i know, its a fucking mess I can use them on the commandline or at any pc. *** havoc has quit IRC Or my accountant or customers or anyone else for that matter. *nod* But I have way, way too much data. every single framework i've seen is so very limited in scope or so far into theoretical data related stuff yeah storing all of those things in postgres, and having a framework to build any type user interface is really th eonly answer i would like to have same as y ou but also be able to build web interfaces as well as pda level interfaces sometimes you just need certain information on a pda for example well, I don't need a pda interface, but I do need to store all my customer data in one unified place. I know there are haks for most of the apps I use to store *some* data in an LDAP store, but not all of them. well... you don't need it now may be a better way to say that, i'm betting that down the road ui display needs will change on a org by org basis :) just my personal guess tho as well as driving the data strage integration at the same time *** havoc has joined #gnuenterprise is there a demo of gnue integrating with a web app somewhere? not to my knowledge bummer. well, downloading it all again anyway. I periodically just download gnue, compile, and try to get an example working. i've only got it to work once long ago the documentation isn't newb friendly exactly i'm hoping to get enough questions answered that i can write the guide tho lol * ajmitch returns hola aj does gnue have a wiki? yep main menu gnue.org thx trying the debian install again...there are a lot of recommended packages this time around. anyone know what this firebird c32 server is? hmmm...methinks there should be generic install notes instead of a different set for each platform. never heard of it apt-cache show package is usually helpfull well, the debian install notes are about three lines long, and the last line just gives this firebird database as an example. apt-get update apt-get install gnue-.* heh use postgresql or mysql, I think well firebird is a db like postgres, but i've never used it Ahewes: what debian branch are you using? ajmitch, how does the app server apply to work flow in general terms... for example: i have a workstation and db server holycow: don't ask me lol I don't know the appserver at all that sounds like you can create forms without app server? sure most use of gnue is without appserver really? oh neat Ahewes: I'm guessing you're using woody... okay so when i insert data source into a new app, i get a few options, none of which allow me to specify an ip, user, pass ... is there another place to specify a remote datasource? /etc/gnue/connections.conf ahhhh! danke or wherever that file is on your box datasources are defined there :) *nod* sorry i expected that to be in properties, no that makes sense <-- using subversion grab, so in my home dir aha ok, I have to leave now, will be back in an hour or so :) cya, thx for answering my stupid questions :) oh no shit that worked heh something has to be done about these tiny little non resizeable popup windows tho heh i feel like i'm developing in lotus notes again *** sjc has quit IRC *** tocer has joined #gnuenterprise *** tocer has left #gnuenterprise Ahewes, how far have you gotten with each install manage to connect to a db and make some fields yet? I got distracted by expert systems... I got the install of the packages done, and picked postgres, so I installed the psycopg package. I started postgres up but then got to thinking about other things I wanted to try with postgres, so I'm a bit off track. hehehe it's a terrific db eh? I think I should be ready to edit /etc/gnue/connections.conf but it's time to pick up a prescription from the pharmacy so I'll try it when I get back. postgres is very nice. i'm off for some dry ribs lol I think they hae their shit together. very good docs. ttys Ahewes, as a complete newb i found it frighteningly easy to setup I'll add to the wiki when I'm done. I'm taking notes. trying to setup something like mysql, or god forbid mssql is a lil' more complicated back in an hour. cya Ahewes: what version of the gnue .debs are you using? ajmitch, what is the basic process of geting information out and into a table say first name last name, one form two text fields i'm not groking the concepts as i do little db dev type stuff hmm? you mean in a form? yep, just trying to understand the basics, simple form with two fields, for input what's not working? have you read the forms developers guide? ah, the one in the gnue-forms/doc directory? yeah oh okay, nope, didn't realize the help files were there ... makes sense X) two questions: my datasource has a name: that i gave it, source: tables (sounds right) but no connection: information where is that input, i presume in need to select the column/field/table somewhere? something like this okay when i'm looking at the block editor it has 4 columns the datasource filed there is supposed to be what? the database name? and the base table column is the table i'm working on? in designer? sorry, yes designer datasource is the datasource that you defined... and the table is the table you work on I see that the datasource editor isn't showing the connection, but the property editor does *nod* yep I don't know enough about designer to help much :) hehe no worries, i'm just hoping for luck :) ajmitch, who would be the designer expert in here? probably sacha jcater danke *** cilkay has left #gnuenterprise *** lekma has joined #gnuenterprise *** jcater has quit IRC *** reinhard has joined #gnuenterprise hmmm... someone working on the gnue site?: http://www.gnuenterprise.org/docs/ Title: Index of /docs (at www.gnuenterprise.org) I get a directory listing. *** SachaAway has quit IRC *** johannesV has joined #gnuenterprise Ahewes: the website is in a state of transition for current docs, best way I think is to select the tool you want to look at and then use the doc link from that page i.e. if you look for a doc regarding gnue-forms first go to the gnue-forms page then there the docs are listed *** SachaS has joined #gnuenterprise reinhard! :) good morning hi sacha__ ajmitch! SachaS.. sacha__ is a simple irc client reinhard: /usr/lib/python2.3/site-packages/gnue.pth was getting 'usr/lib/gnue/python/' in case bibrother has issues and I have no idea why it was doing that :) * SachaS is trying johannesV new .gld patch * SachaS will do so in a couple of minutes ajmitch: isn't that correct? reinhard: no / at the beginning oh so I've filed a grave bug against my own package until I know it's fixed :) I can't reproduce it, even in a chroot I'd bet it depends on the version of python you use but I'm wondering if it's specific to the package versions in testing, which I haven't tried yeah.. distutils (who handles these paths) is part of the python package I know well, maybe python-dev (not sure) and the call is distutils.sysconf.get_python_lib() iirc distutils.sysconfig.get_python_lib() jbailey did try to build and failed, right? what version of debian did he try to build on? it would have to have been sid or sarge well but I'm not sure what he built with that's actually the question :) what did you try? sid i always thought the buildd's run on sid I don't have a sarge chroot setup yet :) yes, they do but this is an arch: all package so the buildd's don't touch it i can try to reproduce the error on sarge today later today will let you know off to meeting at the moment I've got an os.path.abspath() call around the function call to see if it works :) ajmitch: i had the same problem when packaging common for gentoo (ie the usr without leading /) *** dimas has joined #gnuenterprise lekma: great! how'd you fix it? ;) with a hammer: - p = path [len(self.root):] + p = "/" + path [len(self.root):] in setup.py I was worried about that... I might do the same :-) good to know that it wasn't just me seeing it :) * ajmitch has to run away now, bbl :) *** insanekane has joined #gnuenterprise reinhard, hello are you there ? *** holycow has quit IRC SachaS: have updated the referenced-classes gld ? no what is the supported version of wxPython for forms component ? johannesV: situation: module x with class y. module z which extends class y. you have to add a search-attribute to the class beeing referenced in order to have it as dropdown do you expect 2 gld's? yes one for module x and one for module y err z ok. same as gcd: one file per module sorry but the info and search is confusing. ok will try. one sec. lekma: what did you use for root= ? johannesV: i have locale to: de_CH.UTF-8 it only takes de_CH thats OK. so i call gfcvs -u gtk2 appserver://appserver/form/project_project project_project => moduleX_class_Y insanekane: 2.4 IIRC insanekane: though you'd probably better use the gtk2 user interface gnue-forms -u gtk2 ... :q errr reinhard, ok ... i got a segfault with wxPython 2.5 *** sjc has joined #gnuenterprise insanekane: that's possible * SachaS has to think for a moment wx is known for incompatible changes between versions :( reinhard: --prefix=/usr --install-lib=/usr/lib i think tht's all i did reinhard, :) lekma: you didn't use --root ? reinhard, designer seems to require some attributes of the underlying python-C++ interface .. for designer, you need 2.4 it won't work with anything except 2.4 lekma: the change you posted above would only have *any* effect if you use --root --root=/ i think, it's imported from the gentoo distutils classes and is a fake root up until the files are installed let me verify yep that's correct, in my case --root=/, that's standard installation procedure for gentoo ah there is a bug in setup.py to build the path in gnue.pth, the value of --root is stripped from the directory so if you have --root=/tmp/install and your dir ist /tmp/install/usr/lib then everything is ok but if --root=/ and lib = /usr/lib then it strips the "/" at the beginning :( must be the same problem with debian reinhard, btw, when i tried to setup appserver from the cvs (ie, using the cvs install method), there were errors - t couldnt "find" the psycopg drivers ... but after installing using the normal method, it works ... reinhard: i'm playing right now with the rpc server, trying to test a xul client... insanekane: that's strange Sacha: is it now working ? reinhard, indeed you would have to add a gld for the moduleX where classY get's a search-property or you have a gld for module-Z where classY has a search-property lekma: did you find out anything wrt your problem with find()? johannesV: i cant get the .gld right am i correct: Session.open ({'password': 'test', 'user': 'test'},) should open a session and return a session nr ? yep reinhard: yep the find()is solved what was it? * reinhard is curious i was being stupid :-) well reinhard, which version of pyGTK should I install ? that's a reliable source for problems :) :) btw is there a way to import procedures from another gcd? lekma: you can write a .py file and import that from both procedures if you want to share code you see, i'm being stupid again... :) lekma: appserver has even a python shell running where you can connect to (just kidding) ;) :) SachaS: send me the gcd's and the gld's you have by now and i'll have a look at them is it forbidden to declare a dict like this: authentication = "{'password': 'test', 'user': 'test'}" (with the double quote)? i mean in python with the double quote it will be a string you have to leave away the double quote busy by writing other email i'm not sure i can... it comes from a javascript, i'll test lekma: I'm not sure how python translated dictionaries into xmlrpc in any case you have to write something in javascript that gets translated to the same xmlrpc construct i think there is already an XPCOM component for XML RPC .... IIRC lekma: looking at the webfrontend js code siesel once wrote it seems like js also knows the {} syntax *** skiold has joined #gnuenterprise johannesV: its working. ok johannesV: I saw you did the sequence of the OnInit, OnValidate etc right well it's not a real sequence the only thing we can do is this way i think they must follow the dependencies which dependencies ? module x depends on module y which depends on module z so the OnInit goes: z, y, x i can only say first to call the OnInit-trigger of the module which defines the class, and than calling OnInit of all modules extending the class (without a determined order) how can a module depend on another one ? hmmm like module y introduced properties module x uses thos properties eg module y MUST be installed so that module x can be used. well, but OnInit get's called for a given class ! so let's say the class 'address_country' has an OnInit-trigger defined by the module 'address' and there's a module 'foo' extending address_country by adding a new property and another OnInit-Trigger (of the module foo) have to run for lunch. will read log. have not thought it through but got the impression that dependencies must be checked. see you later so the sequence will be: address_country.address_OnInit, address_country.foo_OnInit i think you're mixing up something the circumstance that a module extends a class does NOT introduce any dependency ... *** insanekane has quit IRC reinhard: is there a way in geasSessionManager.py to know if the client is gnue-forms or some other? nope johannesV still. i might mix something up. lets say module X is base backage module Y is finance package module Z is statistics package module U is production package in module Z (or a class of module Z) we might need some case statements eg module Z can produce a status of the organisation so in module Z: if module Y is installed to # crazy statistics stuff; end if module Y is installed do crazy finance statistics end if module U is installed do crazy production statistics end * SachaS thinks we have to wait till i got a real use case one could argue, that the Z statistics module extends certain classes with doCrazyStatics procedures we have to wait till i get a real use case. anyways ;) I got .gld working the way I need it. and the order of OnInit is now with your patches as I was expecting it hi hi ajmitch * SachaS thinks that it cannot be that the sequence of the calls of the OnInit's can be arbitrarly module U with class A, module V extends A, module W extends A with W depends on V which depends on U the OnInit must be: U_A.A_onInit, V_A.V_onInit, W_A.W_onInit because extensions of A in W might use properties of V_A I think the same is true for onValidate how about onDelete? I guess there it takes the referse order: W_A.W_onDelete, V_A.V_onDelete, U_A.A_onDelete so how can one define the dependency? if someone installs module U followed by module W it will fail (if W depends on V) does it fail? actually I might not fail, actually it might even install but if procedures in W_A use properties from V_A, then they will fail. at run time SachaS: module U defines the class; that's ok - so it will be the first OnInit and the last onValidate but modules V and W are in a random order ok. is there a way to define the order? there can't be a dependancy between them, since they might not know each other i think currently there is not. no there is NO order base module, finance module, add-on-finane module I want to express, that add-on-finance module depends on finance module as I said I do not have a use case in my application but if many modules extend a class X I seriously wonder if the random order of the executions will cause problems. s/the execution/the bound trigger execution/ anyways I shut up and do some gnue use cases :) * SachaS started this morning with a weekly planning spreadsheet. now i think damn I should do this with gnue TOO. everything I do I think I should do it with gnue TOO :) Think thats a positive sign. OK I now realy shut upt. BTW genereated forms kick ass for rapid prototyping! somehow I would like to see hyperlinks in a generated form to open up a new form :) SachaS: that would be gnue navigator then :) yeah gnue navigator does understand appserver://appserver/form/my_sexy_form right? :) right this is nothing specific to gnue-navigator but to gnue-forms (reading appserver://... is built into GFInstance.py) thanks. its getting better and better. whats on your (johannesV, reinhard, other appserver devs) guys radar? * SachaS peeks into the roadmap exception-handling, gnue_messages, company- & year-support, session-management johannesV: you don't need navigator to open another form.. :) that's what runform() is for :) ajmitch still lives in 2-tier world time to get into n-tier world ajmitch :) ajmitch: right, but this way i would have to code the call to runForm () into a given form but if a form is created dynamically it wouldn't have that code built in * ajmitch is trying to fixup the gnue-common package ajmitch: you read the logs? what do you pass to --root ? reinhard: yeah, thanks for the top top bah tip ;) running build_scripts cd . && /usr/bin/python setup.py install --root=/home/ajmitch/debian/gnue/gnue-common-0.5.7/debian/gnue-common/ --no-compile -O0 --prefix= /usr --install-lib=/usr/lib/gnue/python trying to create /home/ajmitch/debian/gnue/gnue-common-0.5.7/debian/gnue-common/usr/lib/python2.3/site-packages/gnue.pth self._quote is buggy, I presume :) ah blame cdbs! can you run it without the trailing / for --root? nope cdbs adds that in, iirc damn it didn't for earlier versions of cdbs, i guess you are right, self._quote is buggy in the sense that it should remove the trailing slash if there is one added that testing... appears to work if self.root[-1] == "/": self.root= self.root[:-1] in self._quote *** lxf has joined #gnuenterprise ajmitch: better would be root = self.root true if root [-1] == os.sep no point making it a global change root = root [:-1] reinhard: btw, when making tarball releases, is it possible to lowercase the directory name? :) change appears to work is it a problem with the uppercase name? we would have to change the name of the tarball, too to gnue-common.0.5.6.tar.gz instead of GNUe-Common..... not so much a problem as it gives me a warning when I build ok currently I do the naughty step of repacking the tarball with a new dir name :) i will talk with j* to rename the package names thanks I have read several times that many people don't like tarballs that aren't fully lowercase it's probably in gnu coding standards as well most likely * SachaAway is away: away *** mixi-two has quit IRC *** dimas_ has joined #gnuenterprise *** mixi has joined #gnuenterprise reinhard: ok, gnue-appserver should be buildable now :) *** jamest has joined #gnuenterprise about the irc-logs, since 2004-08-24, they are all empty, are they still available somewhere else than http://www.gnuenterprise.org/irc-logs/ ? Title: Index of /irc-logs (at www.gnuenterprise.org) ?? bigbrother is a bot? jamest!! lekma: yes bigbrother is a bot *** dimas_ has quit IRC that's me jamest: do you know of any tips/guides/howtos/anything on how to use & learn reports? ;0 not really every time i use reports i use whatever samples are availabe and bug jcater :) *** psu has joined #gnuenterprise *** skiold has quit IRC ajmitch: excellent ajmitch: so i could expect upload of appserver, forms, and common soon? plus docs ;-) reinhard: what forms version? 0.5.6? 0.5.6 yes good thing you reminded me sponsor is busy at work, will try & get it uploaded soon thanks if I see jbailey around I'll hunt him down also hi ajmitch up late, or up early? up late about 1:30 here *** mixi has quit IRC *** mixi has joined #gnuenterprise *** mixi has quit IRC *** mixi has joined #gnuenterprise *** insanekane has joined #gnuenterprise *** lekma has quit IRC *** skiold has joined #gnuenterprise reinhard, wxPython 2.4.2.4 is ok for designer ?? i *think* not working with designer myself, I can't really tell bbl SachaAway: aren't you using gtk2 as your default-UI ? (cause you're adding a -u gtk2 argument to your gfcvs call) *** lxf has quit IRC *** lxf has joined #gnuenterprise johannesV: ok changed to gtk2 as default in gnue.conf thanks *** skiold has quit IRC *** lxf has quit IRC *** johannesV has quit IRC *** psu has left #gnuenterprise *** johannesV has joined #gnuenterprise *** Ahewes has quit IRC *** dcmwai has joined #gnuenterprise *** jcater has joined #gnuenterprise *** psu has joined #gnuenterprise *** dsan has joined #gnuenterprise hi there jo er hi pretty sure u already know it but err... hi dsan viewcvs.cgi is broken on gnue website module "svn" not installed. hi psu erm... sorry ... s/cvs/svn ;) I was interested by your svn2cl script, but can't find it so far bbl *** dsan has left #gnuenterprise johannesV: i am again working with the .gld *** dimas_ has joined #gnuenterprise module x with class y and module z with class a class y references class a *** reinhard has quit IRC i do not get it right so that i have a form of y with one extra tab for the display of class a i do get an extra tab with one drop down of the one search property of the a.gld pure z_a works fine but not as detail of a masters x_y *** insanekane has quit IRC derek - r u about? just wanted to say I agree 1000% with you on web applications My work laptop has been b0rked for the last 2 weeks so I have had no option but to use webmail. It's soooo slow Feels like it's running on another computer, or something ;-) The idea of using a web-based ERP app is now even less appealing than it was johannesV: the label of an info tag of a .gld is not shown in the form. *** psu has left #gnuenterprise right an info is used as a entry with style label f.e. you want to have a dropdown with address_country.code and as an information address_country.name so giving and oh ok that is the info for. yeah thats what i thought of info means just 'display as information' ok is the space between a search and an info dependent on something? i get a long space between the two no, there shouldn't be a space in between ... do you have info before search or the other way round check again johannesV the master/detail thing in a .gld can give me antoher hint about it? it sort of works with the search and info but it is intended to be used just for one line, right? there's no master/detail in gld like the country example given above there is only lookups in gld using our samples: country is the master, person the detail so if editing a person, country is used for lookups so in the country-class you would add search- and info-values i dont understand. because you want to say which properties are used when another class references a country ok. hmmm person and country two classes if person references country oh only looksup -> i cannot have a person displayed and edit its fileds and as well have its associated country (address in my example) in the same form. of course you can just look at the sample.gfd in appserver/samples this is the way it works damn ok i look. after looking at sample.gfd import the newly sample-*.gld in our appserver/samples and have a look at appserver://appserver/form/address_person then you should get a similair form ok the sample does not make sense as you do not want to change the country business class. ? changing like: de is no longer Germany but Deutschland all you can do is assigning a new country to the person *gotcha* ok ;) as i have mentioned before there is no master/detail in gld arghhh :) cant you implement it? ;) what you are looking for is a relation like invoice and invoice-lines no we don't want to implmenet that (now) can you change the roadmap? ;) ok gotcha so i must write a custom form :( having such relations in generated forms does not make much sense well you can use the debug-file-option to store a generated form and the modify it :) like appserver://appserver/form/masterclass?debug-file=myform.gfd yes this will store the gen.form code in the local file 'myform.gfd' master/detail would be cool if you do this for the detail-class as well you would have to merge both gfd' only it cannot be handled in an automatic way so one could use the result i just thought i can do the application without needing custom forms it would be less effort to use something like designer to create them btw. forms with such relations are usually subject to the customer ok ok no master/detail now so one would have to design them manually anyway we have talked about this a few days ago (i thought) we did even we sometimes talk of the same thing, we might be speaking of it on different levels :) well no m/d :( ok no worrie no worries thanks. np johannesV: there is a capitalisation issue: DB001: 0:02:30.526 [ServerAdapter:406] localhost - - [30/Aug/2004 19:41:22] "POST / HTTP/1.0" 200 - Auflösen: Session.request (1, 'partner_customer', [], [], ['partner_address', 'partner_changedWhen', 'partner_ba', 'partner_bA', 'partner_shortName', 'partner_isActive', 'partner_name', 'partner_createdWhen', 'partner_changedBy', 'partner_createdBy']) do you see the partner_ba and partner_bA ? it should be a partner_bA this happens when I go into search mode and then hit query a generated form. hmm, i don't think mixing case this way is a good idea ... :) i'm not sure if db-backend supports this appserver's classrepository is case-sensitive, but the backend usually not well I have to be case correct when i create the .gld file otherwise appserver does not accept it if I set it to lowercase in the .gcd and .gld it works if i set the field to camelcase in the .gcd and .gld it does not work gcd and gld must match if they match in camelcase the generated form does not work i think importing a 'non-existent' property from gld would raise an error if they match in lower case the generated form works ? i'll try that ... just a sec its a referenced field I am talking camelcase does NOT work ? nope * johannesV has to reboot after distupgrade *** johannesV has quit IRC *** johannesV has joined #gnuenterprise SachaS: using camel-case properties works well but i've lost my syntax-highlighting during the last upgrade :( have to tweak that vim again johannesV I have cameCase issues in my setup the ones which are not working are: references to other classes from other modules. i can send you the files, if you want. the project :) yes please send them (have tried it with ref's too which doesn't matter) hmmm ok send it to you ah, got syntax-highlighting and filetype-detection back in vim :) good, i'll look at it tomorrow morning ok thanks i can do it all lowercase until tomorrow ;) SachaS: but send the camelcase file anyway ... so we can catch a bug if there is one ! ok, i'm off for today *** johannesV has quit IRC *** jcater has quit IRC *** SachaZzz has quit IRC *** jcater has joined #gnuenterprise *** dimas_ has quit IRC *** jamest has left #gnuenterprise *** sjc has quit IRC *** holycow has joined #gnuenterprise hey all *** jcater has quit IRC *** jamest has joined #gnuenterprise *** holycow has quit IRC *** dcmwai has quit IRC *** dcmwai has joined #gnuenterprise *** jcater has joined #gnuenterprise *** holycow has joined #gnuenterprise *** jcater has quit IRC *** jcater has joined #gnuenterprise *** jamest has quit IRC *** VeeOffice has joined #gnuenterprise *** ajmitch_ has quit IRC *** ajmitch has quit IRC *** Vee2d2 has quit IRC *** ajmitch has joined #gnuenterprise *** ajmitch has quit IRC *** ajmitch has joined #gnuenterprise *** holycow has quit IRC *** dcmwai has quit IRC *** jcater has quit IRC *** reinhard has joined #gnuenterprise *** johannesV has joined #gnuenterprise *** dimas_ has joined #gnuenterprise *** SachaS has joined #gnuenterprise good morning *** dimas_ has quit IRC i guess there is no polymorphism in gnue business classes. like there is a class "partner" class "supplier" would be a subclass of "partner" class "customer" would also be a subclass of "partner" the class "contact" would have a reference to etiher a supplier or a customer. with polymorphism the contact could have a reference to a partner class, but when creating the contact instance it is assigned to eg a customer. SachaS: no there's no such a mechanism ok. thanks. did you have a look at the files I sent you? yes i gave them a look, but it would take a bit more time to check them guess I am at a stage where I could start to look at the code ;) the developer cannot keep up ;) *** lekma has joined #gnuenterprise morning everyone *** mixi^ has joined #gnuenterprise *** mixi has quit IRC * SachaS changes to lower case to temporarly avoid a problem SachaS: your gcd's has way too long identifiers ! partner/forms/partner-de_CH.gld: PropertyNotFoundError: Die Klasse 'partner_contact' hat keine Eigenschaft 'ohterPhone1' yeah i fixed that timemgt/schemas/timemgt.gsd: UnicodeEncodeError: 'ascii' codec can't encode character u'\xfc' in position 20: ordinal not in range(128) dah? which class was not functioning well with camelcase ? hi are you looking at the lastest one? i sent you two gzip files * ajmitch tries to fix up his form so that it loads... :) let me check ah, learning forms & reports in 24 hours - such fun :) in partner/schemas/partner.gcd all properties of type address_address * ajmitch hopes people will be here for the next few hours to answer stupid questions ;) if they are lowercase eg billingaddress it works if they are camelcase billingAddress they fail address_address works fine it looks ugly (cause of missing gld i think) but it works ok i got locale set to de_CH.UTF-8 so whats the name of the property in the partner.gcd file where the datatype is address_address? ok, if i use ?language=de_CH it's using the proper gld-data and it still works ? i think you have the borked version so in the partner.gcd file, do you have a customer with: o billingaddress, or o billingAddress ? if it works, can you do a query & search billingAddress i've to leave for lunch now ok so it fails here ok in my case the form comes up but when i do a query & search it fails gah nasty DB000: _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'contactID,deadline,date,id FROM orders WHERE ((1 = 0))' at line") mysql... lunch time * SachaLunch makes happy dance, he got another positive email * ajmitch does the sad dance of pain :P much better... DB000: File "/usr/lib/gnue/python/gnue/forms/uidrivers/_base/UIdriver.py", line 335, in updateEntry DB000: handler = entry._displayHandler DB000: AttributeError: GFEntry instance has no attribute '_displayHandler' johannesV: can I blame you for this one? ;) forms 0.5.6 *** reinhard has quit IRC ajmitch: i'll have a look ajmitch: how can i reproduce that ? not sure, it just happens.. I'm just fighting to try & get some forms & reports done asap ajmitch: can you try the flollowing: remove all *.pyc files and try again doesn't matter my entry had typecast="" which kind of typecast ? forms & designer really can't handle forms with slight errors :) typecast was empty ah, ok i'll try that :) i haven't ever tried with an empty typecast, caus i'm writing gfd's manually ... *lol* I can get designer to not start by missing something like 'masterlink' or 'detaillink' :) ok, it's reproducable. if an empty typecast is given the error you've mentioned is raised yup ok, found it fast work but what would be the right thing to do raise an exception like: sorry, but i cannot determine which displayhandler to use or use a default? or just do nothing (very bad idea) or ... right give a warning & use a default use a default, but which one ? maybe text string.. ok, text ajmitch: please svn-up :) I'm not using svn... especially as I'll be using this on a windows box :) * ajmitch runs svn up anyway :) so, how would you get the latest code then ? I report bugs, and use packages :) hmm, ok, but i can treat this bug as fixed now ok johannesV: do you have any tips on how to use reports? :) what kind of tips ? general howto.. the current documentation is non-existent I'm wanting to do a basic printout from a forms trigger fill in some info on the form, hit a button & print out a report based on that hmm, haven't tried something like that, but sounds like you would use parameters ? *** Vee has quit IRC *** Vee has joined #gnuenterprise *** Vee has quit IRC *** Vee has joined #gnuenterprise johannesV: that's nice to say that, but the lack of documentation gives me *nowhere* to start on that track :) well, the only documentation available is the sourcecode; i haven't done much with reporting too what kind of information would you like to change with the form ? params for the query ? basically filling out an order form, so entering in a set of values - generating a printout to send on to the factory workers :) and the data in the order form isn't stored in a db ? it is hmm, so where's the problem ? calling the report from a trigger ? yes or the general overview of reports which is sadly lacking :P i was looking at the sample-reports johannesV: currently the appserver does not have a odbc interface, does it? ? so I could connect with a normal odbc client to it don't mix rpc with odbc: you need an rpc client to connect to appserver, and you need an odbc-client to connect to a database via ODBC ... *** mixi has joined #gnuenterprise yeah i was asking if I could connect to the appserver via odbc :) guess not :) not yet i can access the db via odbc curses * ajmitch kicks forms & designer they're both segfaulting now anyways no problem ajmitch i see you are about to create a report :) guess thats my next step too SachaS: it does not make sense to connect to appserver via odbc ?! I'll *try* and make a report the documentation at the moment is appalling :) *** mixi_ has joined #gnuenterprise johannesV: reporting tools can connect to db's via odbc. so I was thinking why not access appserver via odbc for reporting non gnue reporting tools I am talking about eg i firedup openoffice and could do a report but against the backend database so one would have to write an odbc-driver for appserver which is an interface between odbc and rpc that would be ugly the odbc driver could use the rpc interface of appserver I'm not volunteering to write it! :) nor do i :) haha * ajmitch selects some nice loud music for his morning alarm & goes off to sleep night ajmitch night night ajmitch johannesV: i think my application is basically working all with generated forms no master/detail but thats not necessary, you can just do that in a different form so I can enter times I was working for a project. next thing would be to generate a nice report that's right eg a list of work done in a time range (15 July til 15 August) i think this is missing in the roadmap atm, but it was planned to build it once we have a bit more time what is missing? like appserver://appserver/report/module_class auto generated reports? which generates a basic report for that class (tabular or the like) kick ass :) how is your gnue time in the future? can you continue to contribute as much as you could up til now? i'm working fulltime gnue atm it would be great that you would get some gnue paid work this depends on how much money BYTEWISE Software likes to invest into gnue in the future eg you could develop an application for a customer at the moment i'm full paid :) well, that's another one, right. it would be much better to have a customer paying the bills :)) company's should get attracted by gnue. *** mixi^ has quit IRC maybe a company would be willing to do a prototype of some sort with gnue that would be good, yes. ok so I have to look at gnue reports again. on my todays todo list I had an item: "think about migration". thats a hard one. eg if I start today to use my system to fill in real data. eg make snapshot install from current cvs. *** mixi has quit IRC so I know that the application is still working tomorrow and that I can keep developing on a new release of it and one day ... migrate from that snapshot to the latest release. same with packages: what if I change my packages in such a way that they are no longer compatible? => migration issues * SachaS thinks maybe I skip the "how to migrate" todo item :) well that are general design issues concerning reports: its allways possible to get XML from gnue-appserver via gnue-report and THEN use a tool such as jasper (http://jasperreports.sourceforge.net/) reports which imports XML data. Title: JasperReports - Home (at jasperreports.sourceforge.net) general design issues. I am sure you have gone through some in your professional career :) eg migrating bytewise customers to new releases etc.... *** reinhard has joined #gnuenterprise :) reinhard: please give me a call if you've a bit time left *** jamest has joined #gnuenterprise * SachaS thinks auto generated reports would be cool. new tools were release to the open source community yesterday SuSE/Novell with their openxchange server (http://www.open-xchange.org) Title: OPEN-XCHANGE™ : The Collaboration and Integration Server Environment (at www.open-xchange.org) today Orbeon with a "integration suite", which includes an XML presentation server (with XForm (server side)) (http://www.orbeon.org) Title: Orbeon - Open Source Integration (at www.orbeon.org) *** johannesV_ has joined #gnuenterprise *** johannesV has quit IRC *** btami has joined #gnuenterprise wohoo ... diggin into GBaseApp shows a lot dead and malfunctioning code ... haha ... and that's a good thing how ? =) johannesV_: ? is it possible to use appserver over ssl? *** jcater has joined #gnuenterprise w00t I was right on that website url problem yesterday hi jcater wrong channel howdy lekma jamest: you might have noticed the gnue.common.apps.errors file according to that new 'standard errors' i was trying to add a replacement of 'handleStartupError' to GBaseApp doing this with an sys.exceptionhook handling 'uncatched exceptions' we then can replace the handleStartupError calls with apropriate exceptions or (in most cases: we do not catch exceptions and call handleStartupError) that was why i was reading through all that code in GBaseApp and some other modules hi all i didn't know we had dead code in baseapp no logs from 2004-08-24 getCommandLineParameters(self,paramList) doesn't get called (i think) or catching GConnection.InvalidFormatError is not necessary because it won't get raised (ConfigParser.ConfigParser instances won't raise DuplicateSectionError, or MissingSectionHeaderErrors at all) which has been filed as python-bug in Oct. 2003 so instanciating GConnections.Connections () with an 'empty' connections.conf just works fine without an exception well or I never wanted handleStartupError to be replaced w/exceptions handling commandline-args like --debug-file= ... that seems backwards I like the idea of catching uncaught ones transparently but why would we eliminate the ability to call the handle* functions directly reinhard: u around?? there's no need to do so. if it's enought to raise an exception we would need less code for catching exceptions and convert them into a handleStartupError which eliminates the risk of catching too much exceptions i think the point is in dividing errors into groups and adding an exception handler which is aware of that groups f.e. a UserError could be just a line saying something like 'hey, the file you requested isn't there' but if a SystemError occurs it will give a complete traceback, helping a dev. to find the bug reinhard: am i correct in saying, the _sessNo returned by a geasSessionManager.open can be used as the session_id for a geasSessionManager.call? *** nickr has quit IRC reinhard: or should i call getSessionId() to know the session_id? *** nickr has joined #gnuenterprise lekma: the former reinhard: _sessNo = session_id, correct (sorry to bug)? reinhard: the code in geasSessionManager seems to say different reinhard: sorry, i was wrong forget it do i need svn version of forms to use appserver://... like url?? is it possible to use appserver over ssl? a lot of question... lekma, do you have the sample in gnue-appserver/samples working? yep samples work wait i just ran the setup-db.sh, this worked, do i need something else? well then you have to start the appserver and then the client see you later *** SachaS has quit IRC [Errno url error] unknown url type: 'appserver' when trying gnue-forms appserver://gecocer/form/adress_country do i need svn version of forms to use appserver://... like url?? *** insanekane has joined #gnuenterprise reinhard, are you busy atm ? anyone here ? yep lekma, im having problems runnning a form ... i designed the modules using classrepository.gfd ... and the form using gnuedesginer ... bu running the form, gives me an error that the relation is not on the database ... but i have already made the classes using the classrepository form ... you should not use classrepository.gfd anymore oh ... then what should i use for making the classes ? create a gcd file (see in samples/) oho ... ok ok, after i create. then what should i do ? and then run gnue-readgcd --connection=gnue -u gnue -p gnue mymodule.gcd ok ... change connection user and password according to your settings well, i havent made any changes to settings ... so hacker/secret will work right ? and the tables, modules, classes... should be available in appserver no hacker/secret is for using with forms gnue/gnue is a db user (who should own the gnue db) ok ... *** bluesbaron_ has joined #gnuenterprise to test your appserver you can run setup-db.sh in samples ok ... so after that i use the designer to make the form ... and in the data sources tree, i select appserver with hacker/secret to make the form ? lekma, ok ... will do that *** bluesbaron_ has left #gnuenterprise yep lekma, are there any external resources like tutorials other than on gnue website, that i can refer ? insanekane: unfortunately no yhat i know but you always find some useful ressources in doc directories of each packages hehe ... i checked them :) even if it's sometimes a bit outdated *** btami has quit IRC lekma, what is the difference between a bound procedure and a normal procedure ? good question, i think reinhard is the expert on this subject what i understand lekma, ok is bound procedures are a set of predefine procedures that are always called if they exist like OnInit, OnValidate.... aha but you should ask SachaS or reinhard, they know better okie lekma, thanks a lot for ur help :) *** SachaS has joined #gnuenterprise * SachaS is away: away *** insanekane has quit IRC SachaS: after having setup appserver with samples, is there a form i can call with an appserver:// like url?? *** holycow has joined #gnuenterprise *** jbailey has joined #gnuenterprise Anyone seen the top article on /.? =) lekma: in principle you can call all classes using an appserver://appserver/form/classname style url but if you have provided a gld-file for some classes the generated form will look better btw: the appserver-url is constructed as follows "appserver:///form/[?debug-file=[;formwidth=][;formheight=][;language=]] where is the name of the connection in connections.conf file defining appserver is the class of which you'd like to have a form for everything between [] is optional if a debug-file option is given the generated forms-code will be stored in the given 'local' file the other params determine maximum form with and height as well as the language to use like de_AT or en or en_US and so on ok, i'm off for today *** johannesV_ has quit IRC back i think we have to remove gnue-classrepository.gfd *** holycow has quit IRC reinhard: then what should we use in exchange? gcd files ok * reinhard beats reinhard write docs! write docs! sigh :) it really would be about time i think if i had written docs 2 weeks ago i meanwhile would have saved so much time here more than i would have needed to write the docs :) let's document it right now if i wrote gcd file then how would i transform it? into gsd? gnue-readgcd -c *** gsoti_away has joined #gnuenterprise that reads the gcd directly in your database and i can use gsscvs to extract gsd directly from database? err ggcvs ggcvs or gnue-gsdgen, yes but currently, gnue-gsdgen only exports data not schema reinhard: thanks, so clear and simple :) the gcd file is more or less the "source file" for a gnue package night all *** reinhard has quit IRC *** gsoti_away has left #gnuenterprise *** sjc has joined #gnuenterprise *** insanekane has joined #gnuenterprise hello all .... morning im getting an error with using the setup.py script in the svn version .... hello ajmitch basically, the error is pygettext command not found ... but i am able to run pygettext command on the console without error has anyone seen this problem before ? nope... okie the latest stable release doesnt have a gnue-readgcd (ie. 0.1.0) how come ? umm was it in 0.0.9? no 0.1.0 ... err ... i dont know abt 0.0.9 is it new in the svn ? probably hmm ok if it's not in the last stable release then it's most likely that it was added recently.. ajmitch, do you know how i could resolve this pygettext problem ? is it in your $PATH when you run setup.py? ajmitch, this is the error i am getting when i issue ./setup.py build running build sh: line 1: pygettext: command not found Could not find 'pygettext'. Strange. It should be included in the Python distribution. well ... i am able to issue a pygettext in the console and it doesnt give any error yes, and all that setup.py does is call pygettext on the system what does pygettext --version say? what does pygettext --version return? * jcater goes back to his hole hi jcater just the man I wanted to hunt down you are the reports guru, I heard? :) jcater, 1.4 pygettext.py (xgettext for Python) 1.4 ok.. ajmitch: yip so they say got any hints for someone wanting to do a simple printout of a report from a form? eg, user hits 'print this sheet' & it spits out something based on what they entered? lucky for you, I'm working in reports today yay has gnue been used in production environments ? or is it still experimental ? it's been used in production ajmitch, what kind of modules where used in it ? afaik forms & reports jcater can answer questions about that :) no not gnue module ... i mean what kind of packages ? like inventory ? accounting etc ... I don't think any packages as such have been used in production just things done using the gnue tools jcater: quick tip on how to call reports from forms? :) give me a few minutes I'm adding a runReport atm ok thanks :) svn update and test out my runReport function * jcater runs off to beat users * ajmitch hands jcater a large bat *** insanekane has quit IRC *** holycow has joined #gnuenterprise *** insanekane has joined #gnuenterprise hello all jcater, there is a problem running the sample.gpd file given with gnue-appserver ... I know nothing about gnue-appserver though I think gpd's are supposed to be run using gnue-navigator not gnue-appserver jcater, no the problem is with navigator the sample comes in gnue-appserver ... anyway ... shall i paste the traceback ? it is wierd ... syre sure DB000: Traceback (most recent call last): DB000: File "/usr/local/gnue/lib/python/gnue/navigator/UIwx.py", line 189, in OnTreeItemActivated DB000: object.run() DB000: File "/usr/local/gnue/lib/python/gnue/navigator/GNObjects.py", line 185, in run DB000: self._controller._clientHandlers[self.type](self, self._params) DB000: TypeError: _runReport() takes exactly 2 arguments (3 given) i tried printing self._params ... it is an empty dictionary ... jcater, any ideas how to fix ? not without digging into it looks like it has to do with reports support in navigator nope ... not appserver though it fails before it reaches the code to do with reports it is calling _runReport() on the fail well ... the call fails ... and not because of any code in the _runReport() but the exception is wierd ... since we are passing only 2 objects ... how does it think we are passing 3 ? *** insanekane has left #gnuenterprise *** insanekane has joined #gnuenterprise erm .. insanekane: are you using svn to get our source? I fixed that one traceback jcater, i already got the source err ... im on dialup ... if the fix is minimal i will do the same changes here if you tell me how GNObjects.py:94 def _runReport(self, step, parameters={}): \ (ignore that last \ line) okie so i have to add that attribute ? i mean parameter ? oh ok i get it .. jcater, ok im getting one further error on params.update(self._params) ... like 130 of the same file should i comment it out ? or replace self._params with parameters ? I think so ok i will try jcater, ok i got the "merged" output on console but not in the GUI ... is that normal ? um, well, you are the first to get gnue-navigator working with reports I wouldn't say that's normal though but it hasn't been finished apparently ok so noone else is trying to get it work ? aha ok... well, I've been asked a few times to look at it but you are the first I didn't completely brush off hehe i hope thats a good sign :) jcater, what is the expected result of running a report in navigator ? jcater, ok i got it output to an xml file ... so i guess it is upto the devloper to convert it into a format suitable for viewing correct ? sounds like you need to specify a filter I don't recall exactly how to do that with gnue-navigator but it might be something like "html" or "text" aha ... so the GUI for controlling all this is not yet made yes ? reports mostly has been used in "batch" mode so everything has been passed via command line stuff is in place for dialogs to prompt user for stuff like printers, etc just not finished I got hit with some major work projects so had to quit for a while jcater, suppose i wanted to add a GUI for controlling this ... would I just modify UIwx.py or something else (for the wx backend ie) ? within the context of navigator-run reports, yes for command-line reports, we have a GRRunUI jcater, ok got it does the master= masterlink= detaillink= syntax in datasources has changed??? not in several years why? it doesn't work with an appserver connection... ah jcater, btw, excellent :) it is working :) btw are import tags in forms repaired?? jcater, which is the preferred gui backend ? gtk2 or wx ? wx is the testbed/reference implementation and is what I use ok good ;) jcater: how do you use fk_source and fk_key in a field tag?? look at gnue-forms/samples/zipcode/zipcode.gfd for an example fk_key="state" fk_source="validator"> that says the current field (state) should be linked to the state field of the "validator" datasource but when displayed on screen (i.e., via a dropdown) to use "description" as the displayed text jcater, thanks a lot for your help :) will bug you often :) good night all dayumn, jc is here and i don't have the designer in front of me :) jcater, i was playing around with designer over the weekend, and its really a fantastic piece of work it has a long ways to go what i couldn't grok for example is how to create an input form with two text fields and input the data into a simple table, say first name last name is there anything in way of tutorial onthis? jcater, *nod* but i see where its going Form's Developer Guide its really going in the right direction oh okay lemme look at that oh is that the open office document you wrote? yeah that deals with an ntier setup with appserver tho... what about simple designer -> postgres? ? http://www.gnuenterprise.org/tools/forms/docs/ Title: GNUe Forms Documentation - GNU Enterprise (at www.gnuenterprise.org) bigbrother: did I ask you anything? no, didn't think so *** insanekane has quit IRC *** jamest has left #gnuenterprise hehe k. yeah thats the document i read that one hell of a document, thats an amazing amount of work that shouldn't have anything to do with appserver as a newb i wasn't able to grok how to create a simple to input first and last name into a simple table however ah *nod* you are right, i'm mixing it up with a ton of other things i read, its kinda meleting into one at this stage :) thats not to say that the document should have any such newb related info i think the document is perfect for its intended use i know its gotta be super simple tho for example: i can successfully connect to postgres, which is on another machine i can create a db connection and a block then i create two fields, first name, last name and i think an enter key it's not clear how to link the fields to the table columns, and have the enter button update the db at first glance any tips on easy way to do it? i know i will haveto probably write a trigger of some sort *** mpirun has joined #gnuenterprise ah easiest way currently is probably to have two blocks the first one only contain those two fields and it shouldn't be tied to a datasource the second should be tied to the datasource oh! then use an On-Enter trigger on the first block's last field to block2.initQuery() then set each of the corresponding 2 fields in the second block to the values in the first then block2.executeQuery() * jcater is in a tad of a hurry so sorry for the crash coars4e jeez...you guys really got as much done as your website suggests? mpirun, these guys are amazing when gnue starts to catch on a lot of companies are going to be pissed off jcater, no worries on the crash course! thats EXACTLY what i needed! awesome, awesome,thx, can't wait to get home. before i get started, does this install fairly easily on rhel3, or should i start on something else? once i get my first simple form up i'm gonna make a mini tutorial weeeellll, not sure debian is by far the easiest to install anything on there are debian packages and you just do apt-get install gnue and your done however i have been using the latest svn downloads for that there you download into a dir from subversion repository and run some scripts to create symlinks and such... but i can't remember the steps for youright now third option is to compile/install on rhel, that shouyld be fairly standard as with any compiled/install proggy i think gnue ought to ship with a local db, particularly on windows, something like the newly open sources ibm db... cloudscape or whatever its called :) just for easy of 'getup and go' *** jcater has quit IRC *** jcater has joined #gnuenterprise holycow: of course debian is easy to install on - but you do still need to setup configuration in /etc/gnue I might get around to automating that with debconf when I use gnue a bit more I'd like to get into appserver oh that would be coo aj cool even i think the problem that you may run into is in that gnue is so flexible and powerfull you can have a local db, networked db you can have app server in both cases sure then you will have a newb situation ... i'm not sure whether that needs to be a consideration, but we will get questions from newbs about what all the steps mean most people don't know how to setup postgres, etc. but just something simple for reports filter setup, for example if they don't know how to setup postgres then they shouldn't be trying to use it lol :) thats what i mean anyway, I have to go bbl then the qeustion is, do you include something like cloudscape by default or .. ? k. later :) *** gsoti_away has joined #gnuenterprise *** lekma has left #gnuenterprise *** jcater_ has joined #gnuenterprise *** sjc has quit IRC *** holycow has quit IRC *** qman has joined #gnuenterprise *** holycow has joined #gnuenterprise *** holycow has quit IRC *** holycow has joined #gnuenterprise *** gsoti_away has quit IRC *** jamest has joined #gnuenterprise *** jamest has quit IRC *** jamest has joined #gnuenterprise *** egging12 has joined #gnuenterprise *** chillywilly has quit IRC *** egging12 has quit IRC hrm..installed to /opt, and it made a /etc/opt/gnue...that correct? *** jcater_ has quit IRC *** jamest has quit IRC *** jcater_ has joined #gnuenterprise *** holycow has quit IRC *** holycow has joined #gnuenterprise *** SachaS has quit IRC *** lekma has joined #gnuenterprise *** holycow has quit IRC *** lekma has left #gnuenterprise *** chillywilly has joined #gnuenterprise *** chillywilly has joined #gnuenterprise *** chillywilly has quit IRC *** chillywilly has joined #gnuenterprise *** johannesV has joined #gnuenterprise hi all johannesV: is there a cvs equiv of the gnue-readgcd script? *** vergil has joined #gnuenterprise dimas: gcdcvs and for gnue-readgld it's gldcvs *** lekma has joined #gnuenterprise *** SachaS has joined #gnuenterprise *** SachaS has left #gnuenterprise *** johannesV has quit IRC *** SachaS has joined #gnuenterprise *** johannesV has joined #gnuenterprise hi johannesV *** johannesV_ has joined #gnuenterprise hi johannesV_ hi sacha__ ;) johannesV_ do you think its easy to have condition of a datasource be changeable in a form? i think at the moment once the form is loaded, the condition of a datasource is fix. jamest once moved it into the trigger namespace but after editing the condition in a trigger it did not affect the query. SachaS: i don't know ok. thanks. i assume using createResultSet () or simpleQuery () is not what you want ? i think even with simpleQuery it did not work. if i remember right what problem would you like to solve ? ok. Arbeitsrapport so i have a table with work items each with a start dateTime and with a stop dateTime ok so i want to have a way to let the user chose: query all work items with start >= 15.08.2004 and stop <=31.08.2004 i was thinking this is typically a condition of the datasource and what does happen after selecting the date range ? i mean i do not have the date range fix coded in the form sure, but will the result be displayed in the form or printed in a report ? or something else ? ah was thinking in the form i am at the verge where shall i design a nice form so i think this is not a big thing and i think it should work where shall I design a nice report (html,xml etc) ok. thanks have to play with it. s/where/when i think using an unbound block for the selection fields and a button with a trigger for populating the data-block will do the job but i'll try something similair; just a sec actually i am not sure when to build a form with explicit the main gnue form navigation bar and when to build a form with extra buttons with extra query's and populating things etc. what's an explicit gnue form navigation bar ? *** johannesV has quit IRC SachaS: using a simpleQuery works fine so your problem is solveable without any specials or tricks can you past your simpleQuery call, plase? ok no special tricks :) what are you currently working on? exceptions and then gnue-messages well you have a block which has no datasource bound to it, say it's called "blkSelection" this block has two fields, fldStart and fldEnd then you have a block "blkItems" which is bound to a datasource "dtsItems" in a button's trigger-code you can say something like: dtsItems.simpleQuery ({'start': blkSelection.fldStart.get (), 'stop': blkSelection.fldStop.get ()}) and that's it so enter both dates and press the button :) content of {} is the condition, right? Note: you would have to check if there are other conditions on that datasource right how about the >= ? each key is a db-field and each value the corresponding value; condition is 'EQ' multiple conditions are concatenated using AND oh, damn right how silly i am ... you'd like to have a range ... hmm so we would have to use the createREsultSet () i'll check again something like: {'start': LQ blkSelection.fldStart.get(), ...} with LQ being like less or equal to? jamest thought having condition in the trigger namespace would solve it: eg dtsItems.condition.set( ... ) and then run the query on it oh i think to remember when I was asking jamest about that it was rather the question to change the order properties of a datasource. wow, just found a bug in datasources.drivers.dbsig2.dataobject hmm SachaS: you would have to create a condition using something like GConditions.buildTreeFromPrefix () *** MiXi has joined #gnuenterprise *** mixi_ has quit IRC ok, SachaS, now i got it you can do it like: from gnue.common.datasources.GConditions import buildTreeFromList cond = buildTreeFromList (['and', ['ge', ['field', 'start'], ['const', blkSelection.fldStart.get ()]], ['le', ['field', 'stop'], ['const', blkSelection.fldStop.get ()]]]] ) dtsItems.createResultSet (cond) that's it looks a bit ugly here but it's ok :) * SachaS shakes head :) johannesV_ why is setCondition not working? ;) in GDataSource.py dont reply :) ;) the setCondition is in there but is not working guess the idea was to have it working in the trigger namespace just browing through GDataSource.py seems like dtsItems is an instance of a GDataSource the problem is not setCondition the problem is to give a 'usable' condition instance to that object and this condition has to be created (i.e. from buildTreeFromList ()) hmmm ok gotcha so maybe setCondition(cond) would also work (cond from above) maybe johannesV_ what is the difference between a trigger calling createResultSet(cond) and the user pressing search query ? does gnue-forms when the user sets values while in search mode create the condition accordingly? as you have shown above? ok damn :) dtsItem.simpleQuery( X ) where X is the condition as a dictonary, where the name value are equal conditions. johannesV_: is that enough to load certain gcd's to initialize new appserver db? simpleQuery( X ) sets the equal condition in line 149 ok thats why a simpleQuery does not work hi dimas hello SachaS simpleQuery( X ) sets the equal condition (GConditions.GCLike) in line 149 dimas: loading a gcd updates gnue_* tables AND creates the physical tables for the new classes so it's enought but you might have to restart appserver to know the new classes dataObject is obscure :) SachaS: ? johannesV_: dataObject = Connection.supportedDataObjects['object'] do not grasp what DataObjects are; not to worry relates to the underlying db johannesV_: DB000: psycopg.ProgrammingError: ERROR: Relation "gnue_module" does not exist like i messed something :) messed and missed johannesV_: loading a gcd updates gnue_* *updates*, so they should exist before? how to create gnue_* ? dimas I think you need to load the base.gsd file (that in the gnue-appserver/samples further you have to load the auth.gcd file further you need a auth.gsd file which does not exist but was moved into the sample.gsd file johannesV_: maybe the tabledata of table gnue_useraccess should go into a auth.gsd dimas loading base.gsd, auth.gcd and your manually created auth.gsd (take info from sample.gsd gnue_useraccess part) its puzzling why base.gsd and auth.gcd plus user access data is in the sample.gsd is actually in the "sample" directory as they are necessary for every application. yes base.gsd is loaded dimas: in appserver/samples run setup-db.sh or setup-cvs-db.sh SachaS: no auth.gsd this is included in auth.gcd ! it is NOT in sample.gsd johannesV_: thanks johannesV_: user name and password is in sample.gsd and not auth.gsd no, auth.gcd defines the class gnue_useraccess yes which updates gnue_* yes why is there no auth.gsd ? the sample-account is of course introduced by sample.gsd but that data is in samples.gsd ? because it is a *sample* account :) ok :) but does not help much for a beginner well guess its always the same default users is bad :) so maybe that why there is no auth.gsd :) no, auth.gcd defines the class gnue_useraccess which has nothing to do with it's data anyway, that authentication class is just a hack but does not the appserver NEED gnue_useraccess ? it will be replaced by somewhat better mechanism right, atm it needs it, but it's too simple for production use (in real life) * dimas will read the backlog later openldap caugh caugh ;) * dimas is off to client gnue supports single sign on ;) anyways i will shut up again :) np i've to leave for a short while anyway cool. thanks today I looked at gnue source code guess I have to learn what {}, [] in python are :) actually I think its crazy if you can import gnue stuff in a trigger guess you can realy screw up the gnue-forms viewer :) did I say I shut up ? There's a new upgrade script on ash, ~vin/upgrade_bro, to upgrade brother with some bug fixes and fix the log rotation cron script (logs will re-appear at midnight, like a backassward cinderella story?). Just needs someone with root@ash to run it *** jamest has joined #gnuenterprise *** btami has joined #gnuenterprise hi all anyone can restart logs please ? @misc last --with upgrade VeeOffice: There's a new upgrade script on ash, ~vin/upgrade_bro, to upgrade brother with some bug fixes and fix the log rotation cron script (logs will re-appear at midnight, like a backassward cinderella story?). Just needs someone with root@ash to run it :) *** insanekane has joined #gnuenterprise lekma, hello are you there ? anyone here ? VeeOffice: thx jamest/jcater ??? insanekane: hi btami, hi :) btami, have you used gnue-designer ? a bit btami, i made a form but not able to get it to work ... btami, actually, it is an extremely simple form ... what is the problem? btami, i first made my module and class ... the class has 2 attributes: name, and sign ... so i made the .gcd file, and used gnue-readgcd to setup the db ... i checked it manually using psql, and it was made correctly .... btami, then using gnue-designer, i started an empty form, and dragged the 2 properties onto the form and saved it ... btami, but, when running the form ... it opens the form correctly, but i cant add any instances of my class ... any error messages? well it says "NoneType object doesnt have any attribute gnue-name" btami, wait .. i will get u a traceback .. wait is your appserver set up correct? you made it with setup-db.sh ? btami, err um ... its working now .... :) ... btami, yeah i used setup-db.sh hmm its working now ... i wonder if it is because i restarted appserver ... yes, IMO btami, do you know if instances of a class can be given its own implementation of a procedure ? or are procedures shared for all instances of a class ? i think the latter btami, ok stupid question i guess ... heres a better one ... how do i make a one to many relationship between 2 class ? in .gcd and in the form .... insanekane: i'm not up to date on .gcd and appserver terminologi, but you can try designer wizard first to produce one2many forms desginer has wizards ? file-new-wizard sorry, have to go now bbl btami-swpool, thanks :) *** jamest has quit IRC *** jamest has joined #gnuenterprise *** bigbrother has joined #gnuenterprise *** bigbrother has joined #gnuenterprise *** insanekane has quit IRC insanekane one to many relation: an company has many projects a project belongs to one company i omitted the module name so you have to add that to the type of the project class eg if module where class company is defined is called module X then you have to set *** insanekane has joined #gnuenterprise insanekane one to many relation: an company has many projects a project belongs to one company i omitted the module name so you have to add that to the type of the project class eg if module where class company is defined is called module X then you have to set SachaS, oh great :) ... but what about navigating to the projects from the company ? SachaS, btw, can I get the source for the appserver_howto file ? SachaS, are you busy ? ermm ... stupid question sorry the appserver howto is outdated SachaS, yes i know :) thats why it would be good to have it :) SachaS, most of it is usable i think ... the classrepository.gfd will even be removed, i think * SachaS sent appserver howto to insanekane SachaS, yeah i know ... erm ... eyah i know you sent it : SachaS, writing a little wxPython program to make a gcd file ... u are ? SachaS, yes ... just a little utility ... or is gcd also going to the trash bin ? haha not as far as I know, I hope not i am building upon .gcd's :) SachaS, if you are free ... can you explain to me how I would build a form for the above company-project example, where i can see the company name, and under it a grid of all the projects it is involved in ? insanekane: what about writing a gtk2 program for creating gcd ? or what about vim ? umm ... cuz i dont know gtk2, or vim ... am i right if you don't like pure xml ? :)) moreover, ive used wx a lot so i am very familiar with it and so it will be very easy to make the "utility" ... johannesV_, whats not to like in XML ? johannesV_, pure XML ? is there any other kind ? ;) well if you create a wx program this one will create the gcd (which is xml) johannesV_, yes, i am hoping to output the gcd as an xml ... and if possible to directly push it into the database, like readgcd does ... gcd is xml SachaS, yes i know its XML :) hmm, so it would be better if readgcd has an option for reading gcd from standard-in then to avoid duplicating that part johannesV_, umm i guess so johannesV_, have i seen u somewhere else ? like #scribus insanekane: don't know :) johannesV_, do you come to #scribus ? no, i don't know scribus johannesV_, ok just asking :) np johannesV_, when i meant pushing to the database ... i was actually thinking of duplicating the readgcd ... but now i think u have given a better option :) *** jamest has quit IRC :) johannesV_, but that will require a change to the current readgcd as it is ? ie, does it support reading the gcd from the stdin currently ? no it doesn't by now, but i could change it :) *** jamest has joined #gnuenterprise johannesV_, oho ... johannesV_, ok, i guess ur changes will happen way before i complete the utility :) ok good night all ... *** insanekane has quit IRC bye *** SachaS has quit IRC *** sacha__ has quit IRC *** jamest has quit IRC *** jamest has joined #gnuenterprise *** SachaS has joined #gnuenterprise * SachaS is away: away *** reinhard has joined #gnuenterprise *** reinhard has quit IRC *** jcater_ has joined #gnuenterprise *** reinhard has joined #gnuenterprise *** jcater_ has quit IRC i'm getting: ------------------------------------------------------------ Error: Unable to login to datasource. ------------------------------------------------------------ where to check what cause this? on the appserver side it's traced with: DB001: 0:00:56.696 [ServerAdapter:452] Unexpected Exception in XML-RPC code: exceptions.TypeError:isinstance() arg 2 must be a class, type, or tuple of classes and types DB001: 0:00:56.698 [ServerAdapter:406] exodus.vbc.elcom.ru - - [01/Sep/2004 22:32:20] "POST / HTTP/1.0" 500 - you broke it local or remote appserver? local chillywilly: i'm innocent :) neigh! :P which python version? *** lekma has quit IRC and do you use pw_xmlrpc or py_xmlrpc? 2.2 and it set to plain xmlrpc by default checking for py_xmlrpc *** sjc has joined #gnuenterprise most probably you use xmlrpclib (that is pw_xmlrpc) can you please try python >>> import xmlrpclib >>> print repr (xmlrpclib.Fault) Python 2.2.2 (#1, Nov 6 2002, 18:18:06) [GCC 3.2.1 20020903 (ALT Linux, build 3.2.1-alt0.4)] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> import xmlrpclib >>> print repr (xmlrpclib.Fault) are you using a release or svn version? svn will you be able to be here tomorrow I think johannesV_ will be able to help you as he is fiddling around with exceptions currently and I was quite offline for 2 days now and haven't followed too closely reinhard: sure, thanks it just worked with xmlrpc.py_xmlrpc do any of the applications have releases yet for download? seems like client still talks via pwxmlrpc and throws exception on commit changed setting in connections.conf to py_xmlrpc also and it worked mpirun: not as complete business packages so your server runs with py_xmlrpc and your client did run with pw_xmlrpc and they don't like each other yes and i set correct value in conn...conf already< thanks *** bluesbaron_ has joined #gnuenterprise *** johannesV__ has joined #gnuenterprise *** bluesbaron_ has left #gnuenterprise to start with, i'd like ot build a basic CRM for sales contacts..important, but not exactly critical...should i start with the releases, or pull current? i would suggest current *** johannesV_ has quit IRC cool..thanks. mpirun: you might want to look at gnue-packages contains some pre-alpha stuff for packages *** johannesV__ has quit IRC *** btami-swpool has quit IRC *** reinhard has quit IRC *** sjc has quit IRC *** jamest has quit IRC *** jbailey has quit IRC *** jamest has joined #gnuenterprise *** Vee has quit IRC *** Vee has joined #gnuenterprise *** wt has joined #gnuenterprise hola, gnue people anyone here interested in helping? I am looking for how to install the gnue packages *** jcater_ has joined #gnuenterprise hi you look like you are from my neck of the woods it is you jcater, whuzzup? *** jamest has quit IRC *** jamest has joined #gnuenterprise *** Amorphous has joined #gnuenterprise wt: howdy *** jcater has quit IRC *** jcater_ has joined #gnuenterprise *** MiXi has quit IRC *** mixi has joined #gnuenterprise jcater, hi' hep me guess I missed out boo hoo :(( wt: what's up? *** jamest has quit IRC jcater, ? everything everything is up you never emailed me back about the job posting, btw I wasn't sure how you wanted to proceed with that does anyone know what the appserver is good for? I am guessing nothing hehe I freaking love acl s jcater, what is adrius? a friend's game not very far ah wt: ah I am thinking of using gnue I did email you back should I? but it got bounced and I never resent it wt@midsouth.rr.com? yeah, but I sent from home and rr doens't like email servers from home crazy yeah well...I have gnue's connections.conf working we've usually used college students to fill this position you consider interns? I did contact those two professors last week no response * jcater is a former student of theirs too, so kinda odd yanu is a ewelch will eventually get back to you he just takes some getting used to :) I had 4 years it must take longer okay, but down to business are there any erp packages for gnue? even the Base? and if not, do you do for hire work for gnue? we are mainly tools now though I have seen some effort going into the base I don't do for hire work where would I get that schema file? I'm already too swamped (hence the need for help :) figured just wasn't sure um SachaS: were you working on the base? I am gonna be starting a business real soon now it would be in our svn tree, I'm sure I want to use gnue for the backend under gnue-packages/ is there a web interface? and does schema calculate ddl diffs now? not sure about the diff support yet * jcater has been so busy w/other stuff for the last 6 months I'm just now getting back up to speed with ah what's been happening I think the designer is pretty cool, btw whoever's baby that is, it is looking good thanks plus, you should know my interest/effort doesn't extend beyond the 2-tier tools Ideally, I like a zope forms client but that is pie in the sky i.e., not into appserver oor the applications 2 tier is fine for me I used zope for a long while, but am moving off of it now what are you going to? I hate PHP *** Amorphous has quit IRC mod_python-type stuff my two bitches w/zope zodb and well zodb what's wrong with it? api? *** Amorphous has joined #gnuenterprise can't use source repositories for one so it doesn't play nice with all the other stuff I have like svn? and I have trouble w/zodb bloating up when hit hard on my commerce site yeah, svn so I have to clean it up each night ah i.e., it will go from 20Mb to over 2Gb new versions fixing that? because of crappy session handling would that not be a zope problem instaed of zodb? dunno anyhow gnue I'm moving to pure-python stuff now since that is this channel bah someone who wants to stay on topic that's not the #gnue way why is the docs dir f'ed on the website? oops need to fix that that is old cruft docs are under each tool's doc/ structure now i.e. other projects is also f'ed http://www.gnuenterprise.org/tools/forms/docs/ Title: GNUe Forms Documentation - GNU Enterprise (at www.gnuenterprise.org) bigbrother: stfu I hope to finish the website in the next month or so okay so I kinda understand some of the concepts that is an improvement the websvn is f'ed this is kinda disheartening sigh yeah our svn got 0wned not too long ago so we had to do an emergency source install is the code safe? yeah just someone using us to relay into other machines we checked though but our main server is debian bad ass and debian + source installs aren't nice together nope I haven't fixed websvn as a result that's why everything is packaged for debian yeah, but a few things don't play nice in debian as packages svn being one of them is it not just a matter of installing a newer version? *** Amorphous has quit IRC we almost lost our repository on numerous occasions, and moving from debs to source stopped that behavior altogehter wt: because we are a popular project, we got hit w/a 0-day exploit I have never lost an svn repo so no debs available ah hmmm wonder how I would load a package? I am guessing these are forms and other stuff anyone care to throw me a bone? *** jcater has quit IRC no one to talk to sad is me *** chillywilly has quit IRC *** dimas has quit IRC *** chillywilly has joined #gnuenterprise *** dimas has joined #gnuenterprise