*** johannesV has joined #gnuenterprise *** btami has joined #gnuenterprise good morning good morning good morning *** aries_mindworks has joined #gnuenterprise hi btami! can you tell me what's the difference about 3-tier and 2-tier? *** sjc has joined #gnuenterprise hi aries_mindworks in 2-tier client programs (forms /reports) talk direct to sql backend in 3-tier there is a middleware layer called gnue-appserver here client programs talk to gnue-appserver and appserver talks to sql backend gnue-appserver contains the so called business logic in 2-tier mode business logic is spread in sql backend (triggers/stored procedures) and in forms/reports http://www.gnuenterprise.org/tools/appserver/docs/manual/devguide/General-Concepts.html#General-Concepts *** kilo has joined #gnuenterprise btami: thanks! kilo: hi good morning hi aries_mindworks got your msg yesterday, but was dealing with the kids kilo: btami has answered, thanks ok, just reading the logs btami: ok, I'll read it *** reinhard has joined #gnuenterprise good morning all hi reinhard *** edus has joined #gnuenterprise Hi all hi Kilo, are you still on gnue-luca?, can I be of some use? I'm trying to undestand how to implement a simple Invoices system But maybe I'm missing the already done modules *** dimas has quit IRC edus: you must have thought gnue-packages, not gnue-luca, that is reinhard's baby but yes, i am on packages and an invoices system is quite ready reinhard: hi For invoices I'll make a report each one? yes you can take a look at two svn trees first gnue, there in gnue-packages/supplychain/billing and then in gnue-contrib, where under gnue-invoice you will find a simple working invoicing software... kilo: how do you think: gnue-invoice should be a simple ledger, or would you improve it to serve a roboust tasks? Sorry, but gnue-contrib is on the main gnue svn branck? branch kilo: you know, i'm planning to implement a complicated crm-erp stuff. now it's in the planning phase edus: gnue-contrib is a separate svn tree svn co svn://svn.gnuenterprise.org/var/svn/gnue-contrib gnue-contrib aries_mindworks: well it is very simple, but can be used for inhouse invoicing Thanks!, now I'll go for it a good starting point for a more complex one but not planning to put much work in it aries_mindworks: mögy oszt kész kilo: are you interested in a crm-erp, or any other guy? kilo: :D al gnue is about crm-erp Aries: But the whole GNUe would be an ERP, right? kilo: i need advices, critics about my UML edus: you're right, but there's no an enterprise quality erp stuff. It's a wonderful backend, without really usable applications interested in such a way that i am willing to help aries_mindworks: just put it some public place, and we will criticise it :) but dont have much knowledge of it aries_mindworks: we have real deep knowledge only on hungarian payroll/personal tax calculation and whisky production of course aries_mindworks: we just started to turn our foxpro based stuff into gnue btami: it's enough for me (hungarian payroll) btami: others should implement it to they native tax laws Aries_mindworks: I'll go up to Italian's tax laws *** SachaZzz has quit IRC *** SachaS has joined #gnuenterprise what is gnue_luca ? reinhard's small-size gl you want to work in the uk? i will become employed by a UK company then they send me to the US for a project some ebXML project ;) oh oh oh, oh la la arghh some closed source project sniff i had sleepless nights girls ? dont drink thath much i will have to sign a non disclosure agreement ... I am in an difficult situation. on one side the belief in free software and on the others side signing my life away :) it is probably not that bad well i think it must not be a problem. sign it. *** aries_mindworks has left #gnuenterprise *** chillywi1ly has joined #gnuenterprise *** chillywilly has quit IRC *** holycow has joined #gnuenterprise *** holycow has quit IRC *** btami has quit IRC *** dimas has joined #gnuenterprise is there up to date build for win32? I've seen only theese: http://www.gnuenterprise.org/downloads/current.php they are up to date with the latest releases will it work with svn version of the appserver? *** dcmwai has joined #gnuenterprise I think for running you need Python installed, then try to use the svn's version But I'm using only Linux, so not sure at all *** kilo has quit IRC dimas: you mean forms/reports release on client, appserver svn on server? that should work yep but appserver svn needs common svn ok common svn on client? and forms release? no way It does not run on latest svn? probably you can't even mix svn forms of last week with svn common of today and vice versa lots of incompatible changes due to cleanup when we could see next stable then? :) ASAP as soon as cleanup of datasources is done, and I'm quite quickly approaching it now I've GNUe running on Gentoo, did thoose who ask about pygettext.py solved the problem? I can't remember off hand you mean pygettext, right? (without .py) actually it should be included in python Gentoo does not have it, you need to take from Python.org, then copy it on /usr/bin, and make a link to it named pygettext At least I've solved doing this Strange thing the Gentoo does not give it bundled Today I've discovered gnue-contrib, better to follow it or gnue-luca? *** dcmwai has quit IRC *** dcmwai has joined #gnuenterprise *** jamest has joined #gnuenterprise edus, both *** edus has quit IRC *** edus has joined #gnuenterprise crashed... edus, both :D *** dcmwai has quit IRC *** dcmwai has joined #gnuenterprise Is a class not a valid type for a procedure parameter? I get readgcd: Reference 'kontoplan_konto' not allowed for 'GCParameter' instance inkonto rynik are you german speaking? Does readgcd read ahed so that I can reference a class futher down in the module? No, Swedish kontoplan konto is same in german. Ah... Gues we learned accounting from the germans then. So, you should understand my question then. Or... *** lekma has joined #gnuenterprise hola hi rynik, no, the problem here is you cannot have a refernence type as parameter of a procedure parameter support only base types (string, number, date, ...) DB000: Traceback (most recent call last): DB000: File "/usr/bin/gnue-reports", line 29, in ? DB000: GRRun().run() DB000: File "/usr/lib/gnue/reports/client/GRRun.py", line 245, in run DB000: omitGNUeXML=self.OPTIONS["exclude_xml"]) DB000: File "/usr/lib/gnue/reports/base/GREngine.py", line 65, in processReport DB000: report = GRParser.loadFile(fileHandle, self._connectionManager) DB000: File "/usr/lib/gnue/reports/base/GRParser.py", line 61, in loadFile DB000: initialize, attributes={"_connections": connections}) DB000: File "/usr/lib/gnue/common/definitions/GParser.py", line 166, in loadXMLObject DB000: object.phaseInit(dh._phaseInitCount) DB000: File "/usr/lib/gnue/common/definitions/GObjects.py", line 112, in phaseInit DB000: self._phaseInit(phase) DB000: File "/usr/lib/gnue/common/definitions/GObjects.py", line 148, in _phaseInit DB000: initter(phase) DB000: File "/usr/lib/gnue/common/definitions/GObjects.py", line 148, in _phaseInit DB000: initter(phase) DB000: File "/usr/lib/gnue/common/definitions/GObjects.py", line 141, in _phaseInit DB000: inits[phase]() DB000: File "/usr/lib/gnue/common/datasources/GDataSource.py", line 252, in __secondaryInit DB000: self.__master = self._topObject._datasourceDictionary.get ( DB000: AttributeError: 'NoneType' object has no attribute 'lower' it seems last change to DataObject broke reports *** btami has joined #gnuenterprise lekma: let me look lekma: can you please test again? yep DB000: Traceback (most recent call last): DB000: File "/usr/bin/gnue-reports", line 29, in ? DB000: GRRun().run() DB000: File "/usr/lib/gnue/reports/client/GRRun.py", line 245, in run DB000: omitGNUeXML=self.OPTIONS["exclude_xml"]) DB000: File "/usr/lib/gnue/reports/base/GREngine.py", line 65, in processReport DB000: report = GRParser.loadFile(fileHandle, self._connectionManager) DB000: File "/usr/lib/gnue/reports/base/GRParser.py", line 61, in loadFile DB000: initialize, attributes={"_connections": connections}) DB000: File "/usr/lib/gnue/common/definitions/GParser.py", line 166, in loadXMLObject DB000: object.phaseInit(dh._phaseInitCount) DB000: File "/usr/lib/gnue/common/definitions/GObjects.py", line 112, in phaseInit DB000: self._phaseInit(phase) DB000: File "/usr/lib/gnue/common/definitions/GObjects.py", line 148, in _phaseInit DB000: initter(phase) DB000: File "/usr/lib/gnue/common/definitions/GObjects.py", line 148, in _phaseInit DB000: initter(phase) DB000: File "/usr/lib/gnue/common/definitions/GObjects.py", line 141, in _phaseInit DB000: inits[phase]() DB000: File "/usr/lib/gnue/common/datasources/GDataSource.py", line 249, in __secondaryInit DB000: if hasattr (self, 'master') and master: DB000: NameError: global name 'master' is not defined argh typo :( sorry please try again *** dimas has quit IRC reinhard: it works thanks Traceback (most recent call last): File "/usr/lib/gnue/appserver/geasSessionManager.py", line 290, in commit s.commit () File "/usr/lib/gnue/appserver/geasSession.py", line 320, in commit self.__connection.commit () File "/usr/lib/gnue/appserver/data.py", line 943, in commit for (table, row) in self.__orderInserts (): File "/usr/lib/gnue/appserver/data.py", line 990, in __orderInserts result = self.__orderByDependency (records) File "/usr/lib/gnue/appserver/data.py", line 1090, in __orderByDependency extend (self.__fishSort (table, data [table], fishes [table])) File "/usr/lib/gnue/appserver/data.py", line 1122, in __fishSort value = r.getField (depField) File "/usr/lib/gnue/appserver/data.py", line 1864, in getField value = new.get (field) AttributeError: 'NoneType' object has no attribute 'get' lot of changes recently??? :) *** chillywi1ly has quit IRC guess there is currently no day without a change ;) *** chillywilly has joined #gnuenterprise lekma: that looks like one of johannesV's changes tried a quick fix johannesV: can you please check if it is correct? and yes, there *are* lots of changes :) Traceback (most recent call last): File "/usr/lib/gnue/appserver/geasSessionManager.py", line 290, in commit s.commit () File "/usr/lib/gnue/appserver/geasSession.py", line 320, in commit self.__connection.commit () File "/usr/lib/gnue/appserver/data.py", line 944, in commit fields = tables [table] [row] KeyError: u'sales_saleorders' *** titopbs has joined #gnuenterprise hmmm hope johannesV will come back soon :) :) no pb *** SachaS has quit IRC *** dcmwai has quit IRC Bye all *** edus has left #gnuenterprise back for 5 minutes lekma, how do you create that situation ? or the other way round: how to reproduce ? basically commiting a lot of things... (i'll have to dig in the code to see what are the specifics) but it's not smthing exotic i mean how can you force appserver to requery a record which does not exist ... lots of store and then a commit it used to work i'm afraid i don't really understand the question i don't really know what's happening in the code (i didn't wrote it) but i'm quite sure there's no fish-hook or exotic things happening hm, so i've to play a bit in order to reproduce it ... it's no store but a bunch of session.new (python script) well, that should be ok ... (not using xmlrpc interface) which session.new do you use ? well i pass session to my class (self.__session = sess) but what kind of session is that, language-interface ? then i use self.__session.new(mod_class) the one you use in On-Validate, On-Change,... ah, ok so that's ok i wonder how you can introduce non-existing records there ... do you change the gnue_id manually ? nope well, even that should work never hmm, you're adding new instances in an OnValidate trigger ... maybe i should try that ... are you adding new instances of the class running the OnValidate or of another one ? or do you abort that OnValidate ? anotherone no i don't abort do you call commit in that OnValidate ? *** titopbs has quit IRC This question is for those of you who do active development on GNUe.Do you update your working copy of svn on a daily base? tiredbones: yes tiredbones: i try to test svn on a daily basis but stick with the last working svn for real work johannesV: the commit is at the origin of the onvalidate, there's no commit afterward bbl *** btami has quit IRC bbl *** lekma has quit IRC for the logs: lekma can you tar.gz the files involved (gcd/gfd and maybe gsd) so i can reproduce your situation you can mail it to me (like the last time) i'll try to check it tomorrow ok, so i'm off for today too ... *** johannesV has quit IRC bbl *** SachaS has joined #gnuenterprise *** kilo_ has joined #gnuenterprise *** barsema has joined #gnuenterprise *** sjc has quit IRC Hi, can I import a library to a .gfd file and use for example wxPython in it? rynik: you'd have to hook into forms internals you can import the library i'd not want to attempt it though as I can't imagine things would go well OK. way beond my skill I would like to pop up a file chooser i don't think there is an easy way to do that atm pitty jamest, what did you mean by "you can import the library"? you can do imports inside triggers if you need access to a python module so you could import wx where in the trigger? and long ago you could get to forms internals inside a trigger i *think* we may have plugged that hole though and removed access to the internals you could do at the top of the trigger or you could do in a startup trigger and make the module a global there is an example of doing that in the forms guide thanks, will nasty things happen? As yuo would not try I mean. i do imports from various python modules without issue i've not tried to mix in something like WX though well hmmmm you might be able to get away with it I got me a nice file chooser and I see no problem so far! you just left the parent of the dialog as None right? as that, i think would work wassup negros? hm... I dont know about parent I just did from wxPython.wx import * i wouldn't try trying to extend the forms UI via wx in a trigger but a popup modal dialog.....i can't think of any real issues isn't the first argument to a wx dialog the parent wx widget of the dialog or is that the wxID * jamest is running from memory here but as long as you're doing popup dialogs i guess it'd probably work without messing up forms i wouldn't try to add fancy buttons or anything to the forms UI itself thouhg filname = wxFileSelector("Ccoose a file") chillywilly: it's quitting time is what's up chillywilly: so I can go home! and, um, work rynik: i think that'll be fine bbl jamest Thanks for your time! *** jamest has quit IRC YESS!!! Bye bye ProtocolError hi hey ajmitch_ didn't you mention you have a new version of appserver ready to upload? no, I said it was 'almost' ready :) I've been a little bit busy lately ;) * ajmitch_ should probably fix it the quick way, and then do it the proper way ah ok np just wondered why it wasn't uploaded I think you'll make it until sarge freeze ;-) heh bed time night all *** reinhard has quit IRC *** kilo_ has quit IRC lalala *** mnemoc has quit IRC *** mnemoc has joined #gnuenterprise *** mnemoc has joined #gnuenterprise *** dcmwai has joined #gnuenterprise *** Vee has joined #gnuenterprise