ccfiel, I don't even know what all the tools do yet wt what do you mean? :) i have tried gnue? :) ccfiel, exactly what I said...I don't know what a gcd is wt..ah..ic..:) I think gsd is gnue schema definition you havent tried gnue? ccfiel, I am just getting into it wt yes...its where you define you class.. classess....modules..etc.. gsd? no gcd..its where you define your classess..modules...properties..etc.. gsd is for gnue schema..definition.. gsd is for gnue schema..definition.. and gcd is where you define your classes modules..etc.. gld? *** cilkay has quit IRC *** Lord_mYk has joined #gnuenterprise *** ccfiel has quit IRC hello.. *** ccfiel has quit IRC anyone here? *** ccfiel has joined #gnuenterprise *** holy_cow has quit IRC *** wt has quit IRC *** btami has joined #gnuenterprise hello..btami.. :) hi ccfiel *** johannesV has joined #gnuenterprise *** holycow has joined #gnuenterprise *** dimas has joined #gnuenterprise *** reinhard has joined #gnuenterprise *** sjc has joined #gnuenterprise *** sjc has quit IRC *** mixi has joined #gnuenterprise anyone interested in live access to a Compiere system? ccfiel: please look at sample.gsd from the appserver samples for populating data *** sjc has joined #gnuenterprise reinhard: ic... reinhard: what is the difference between gsd files and gcd? when i load the sample i used gcd..? when do i used gcd or gsd? * btami thinks: all you(we) need is Developers Guide by Reinhard :) btami: is there any? :) yes, just too short yet :) btami, seems as if i've found and fixed the dup-bug loading share/* and samples/* works now ccfiel: gcd are class definitions johannesV: cool but i'd like to do some more tests with appserver and postgres before commiting gsd are, in case of using appserver, mostly data reinhard..ahh..ic..:) johannesV: was it the cursor.descriprion gives uppercase in kinterbase ? btami yes ok reinhard: thanks.. it's in DBSIG2's recordset *** sjc has quit IRC in general the cursor's description should return the fieldnames correctly but since that doesn't apply to kinterbasdb (pre7) ... *** sjc has joined #gnuenterprise yes, it's a broblem(bug?) for us, but from SQL point of view it's not a problem, koz sql names are case insensitive right reinhard: what does this error means? AttributeError:'NoneType' Object has no attribute 'gnue_name'? anyone who wants to test/play with a live compiere ERP/CRM system shall contact reinhard or johannesV, they got the connection information. reinhard: nevermind..:) i just compile my appserver..:) reinhard: its now running.. SachaS: can you send me it into btami freemaul hu ? or myself. i asked the guy who runs the system. it is ok for him to let gnue developers access it. btami i will thx btami is that freemaul not freemail ? freemail my typing is horrible, grrr ok i have modified the zipcode sample to run in a 3tier application the zipcode.gfd is now ok..but the states.gfd (master/detail) does work at all..it cannot display the detail and you cannot save detail.. i have modified the zipcode sample to run in a 3tier application the zipcode.gfd is now ok..but the states.gfd (master/detail) does not work at all..it cannot display the detail and you cannot save detail.. is application ok for master/detail? is application server ok for master/detail? *** sjc_ has joined #gnuenterprise *** sjc has quit IRC SachaS: got it, thx *** sjc_ has quit IRC *** sjc_ has joined #gnuenterprise *** kilo has joined #gnuenterprise *** sjc_ has quit IRC good morning everyone hello.kilo.. kilo : is application server ready for master/detail? SachaS: thx for the link, i fell in love with Freemind ccfiel: coffee first... kilo..sure..:D back ccfeil: what do you mean? i have modified the zipcode sample to run in a 3tier application the zipcode.gfd is now ok..but the states.gfd (master/detail) does not work at all..it cannot display the detail and you cannot save detail.. it should be transparent with regard to this kilo what do you mean? hmm, wait hi kilo paste here the datasources section of the gfd ok no problem for freemind hi SachaS well that is a good tool only problem is that ... java under that prequery="Y" table="zipcode_state"/> master="dsstate" masterlink="zipcode_state" order_by="zipcode_city" prequery="Y" table="zipcode_zipcode"/> kilo this week I will meet a guy who is part of the UBL technical committee. From what I know he is into UBL very much and he is also into Open Source. So i will meet him. Basically at one point in time we want to transform a gnue-invoice (from kilos billing package ;) possibly into a UBL-invoice. that would be easy afaik if there will be a public transformation style sheet or some public/open source transformation library that would be sweet ok one thing i learned: if a invoice has 3 must fields and 20 optional fields two parties will not have the same optional fields used even worse, one party will require optional fields so both parties will have to provide exactly those optional fields which the other party needs. they have to agree on the optional fields this is a problem and the two parties have to communicate, I think. one technical problem: if an XML schema has those optional fields also optional (this seems obvious that the XML Schema has them as optional) it is not enough to check if a UBL invoice instance for example is conform to the XML schema. first of all it has to be conform kilo: if you like i can email you the gcd and gfd files..:) but then if the other party has to be able to use it, the optional fields have to be given as welll. this is a point I will talk to the guy I meet. how this problem is solved in todays world. :) it is not enough to just produce an UBL invoice but the parties have to agree what optional fields they use, or dont use. SachaS: i see. it IS an interesting problem ccfiel: i think you should link the two databases via the detail's gnue_id field ie you store the detail's gnue_id in the master table and link tehm using it kilo..ic ok ill try...: *** mixi has quit IRC *** mixi has joined #gnuenterprise *** wt has joined #gnuenterprise *** wt_ has joined #gnuenterprise reinhard: err, hmm, how wonderful it would be if makefiles deleted gmo files before msgfrt... 8-))) johannesV: seems everything ok here, appserver with sample.gfd, my "complicated" test form, designer *** wt_ has quit IRC bwa ha ha ha ha btami, there are still problems in common regarding case f.e. in a form set a fieldname to "FooBar" .... :) then you still get a duplicate select (and odd behaviour in forms) wt: hi kilo: it works..thanks.. ccfiel: wow is there a way to tranport existing table to a gsd file? :) yes how? :) johannesV: so it's not a firebird only problem ? btami, no it's a prob in common (still) :( ccfiel: ggcvs is your tool ggcvs --database yourdatabasename --export both -o filename.gsd kilo: where can i find that tool? windows? yes...windows.. :) gnue-gsdgen kilo..ok..ill try.. mornin guys hi holycow kilo..when using gnue-gsdgen..an error occured DB000: datetime.datetime(2004,9,28,15,49,17,792000) s not a valid datetime object. why? kilo, hi exporting data of class 'zipcode_state' ... kilo..when using gnue-gsdgen..an error occured DB000: datetime.datetime(2004,9,28,15,49,17,792000) s not a valid datetime object. why? ccfiel: it is highly annoying that you post nearly every message twice wt: pos running? kilo, kinda reinhard: sorry.. ccfiel: dunno reinhard: sometime i mis type the words...so i repeat my..message. mistyping is no problem, we all mistype kilo: ic.. ok..sorry..ill will not re type my message again..even i mis type things.. reinhard: sorry:( languages are redundant enough... btami: yes, we should use assembly to not be redundant 8-)) ccfiel, if we can't parse it, we will let'cha know i have finish converting zipcode sample in forms to a 3tier application.. would this be usefull to the community? ccfiel, yes ccfiel, I so don't understand the 3tier stuff interface <-> logic <-> datastore ? ccfiel: send it to me ok... what is your email? can the taxes in the gnue-packages handle graduated taxes? UI <----> Application Server <-----> database Server ccfiel, same thing I said yes..:) wt: http://www.gnuenterprise.org/tools/appserver/docs/manual/devguide.html and http://www.gnuenterprise.org/tools/appserver/docs/whitepaper/whitepaper.html kilo at gnuenterprise point org reinhard: what do you think, should we put the 3-tier zipcode example in appserver's sample dir, or to gnue-contrib? does the appserver utilize any advanced features in databases? like the table inheritance in postgresql? no ccfiel, btami kilo: what is the best way to look at the "classes" in the app server the schema viewer seems to show the underlying tables hmmm, yes. look at the gcd files that are used to build the tables like sample.gcd * kilo really hopes ther IS a sample.gcd... kilo, surely there is huh dont deal with any tables starting with gnue_* they are considered as 'system' tables kilo, right, but why does the schema viewer show them? in desigenr? I think so because it is a dumb schema viewer 8-))) it's a feature, you can create forms for appservers 'system' table too :) oh for the international addressing, there is a standard will it be used? they even define a way to describe how to put the addresses on envelopes for shipping via templates brb.... i think it will be used in the future, not in the initial version *** ccfiel has quit IRC also, the items have VATs not everywhere has VATs how will that be addressed? VAT is nullable. btw dont considere anything in packages to be working or released in any form (though they are working...) kilo, I am not I am just commenting on what I see ok, that's fine kilo, can't run a form from the designer get a big backtrace something about not well formed XML dont try that. is is a known bug, placed in our (non-existent) bugzilla 8-)) run forms with gfcvs instead kilo, any idea what the bug is? nope bugzilla? don't you mean your non-existant DCL? who cares if it is imaginery? 8-)) kilo: i would prefer gnue-contrib i also thought so what is wrong with dcl? wt: dcl is good, we used it befor regularly just not enough man power to set it up again :( reinhard: do *.gmo files get deleted on your system when setup-cvs.py is run? SachaS: what is the reason you dont use your own time-tracking system? is it normal for the person.gfd to cause large backtraces? kilo: ok, you've made it kilo: i will look at the po makefile *now* lol *** dimas has quit IRC johannesV: now how should one use theis Company and Year thing? kilo, say you have a class "foobar" which depends on company in your gcd say: that's it now every new instance stored in foobar will get a ref to gnue_company (as selected in login-dialog) ok and what if i simply dont want to use it? every query made to that class foobar will get an automatic filter to the current "company" just don't add filter=".." in your gcd's same applies to gnue_year in that case you have to skip that fields in login-dialog and can i disable this login box? (this is something which will change in the future) kilo, atm you would have to change appserver's db-driver then but i think we will add a more generic aproach soon (i don't like that hardcoded stuff either) kilo: we want to let people try and test this feature and then see which road we will go on change appserver's db-driver? ah, that only needs an international degree of excorsism... kilo, change getLoginFields () function to *not* return the "gnue_company" "gnue_year" fields :) but, as i've mentioned, this is for testing now kilo: I am afraid I loose the data SachaS: why? btami, I will try to set up dcl it seems that dcl doesn't even use gnue intrastructure though wt: speak to derek first, he has dumped all former DCL data somewhere but if you do it, well, that would be great johannesV: ok, thx kilo: u think I should use it? ;) why not? kilo, you don't have anything right now kilo, I will try to set it up on my box in fact i havent installed it, but looking at the source i dont see any reason you could not use it what does it take to get an account on your box, if I am successful? you mean gnue box? kilo, yes kilo, the webserver jamest is your man kilo, dcl doesn't even use gnue webserver things are jamest's I mean if can set up DCL on your box, that is great. next step would be to set it up on GNUe's webserver, but enabling access to it is jamest's area off for a while *** SachaS has quit IRC reinhard: thx, gmo files are now updated *** ccfiel has joined #gnuenterprise hello..kilo.. i have email it to you..:) ok, will check it thx kilo no probs...is there any way i can contribute to the project? :) i think if you remain this active, you will get an access soon sure.. i realy like the concept of gnue.. if you use appserver and report errors... or any part of gnue reports need much work ok..im not familiar with the archeticture of report..is there any documents that i can read... before i make any...action..:) i think samples are useful you mean the samples of 2tier? report samples ok.. ill try to look at it.. when we do reports in a 3tier apps..would it be diffent to 2tier..? imho it won't be much different kilo..ok..ill try to look at it..:) svn up gnue-contrib now, hotline project uses appserver and has a report in it too ok..ill try to look at it..:) kilo have you recieve my email? wait, have to check yes, thx. will have a look at it ok..if you have any comment..just tell me..:) *** SachaS has joined #gnuenterprise kilo: migration issues is another concern. i start using the app today, then in 2-3 months I want to update to latest svn ... *** nickr has quit IRC that is a problem, yes. regular db backup can help though *** nickr has joined #gnuenterprise means upgrading .gcd, .gsd, .gld, .gfd etc kilo do you used windows environment? very little kilo in master/detail (states.gfd) i tried to add a record in the master and decided to revert the adding. after that i cannot close the form or even enter a query im using..windowsXP :( ccfiel: what is field 'zop'? bbl *** btami has quit IRC kilo: what file? states.gfd i just copied it from the sample.gfd ( in gnue-forms) i think i can be ommited..:) hehe heheheh have you tried it? :) leaving for London ;) not sure if I can sneak in see you later bye *** SachaS has left #gnuenterprise kilo.. include the 2tier the same problem i encounter..have you encounter this problem? London??? SachaS enters reinhard's machine??? 8-))) ? have to go now.. bye.. *** ccfiel has quit IRC *** lekma has quit IRC *** kilo has quit IRC *** lekma has joined #gnuenterprise hi everyone how do you use the new gnue_company and gnue_year?? i can't seem to be able to store a year... lekma: gnue_year is a detail of gnue_company so first make sure you have loaded the new "gnue.gsd" yeah i did then add one or more company-recs i created a company and a year to that company so, the next step is to determine which classes use gnue_company or gnue_year this is done by adding an attribute filter="gnue_year" to the classes in gcd-files example: but appserver doesn't store the year even thougt it dispatches Session.store after loading that gcd with gnue-readgcd (gcdcvs) two things take place 1.) gnue_class.gnue_filter for the given class (f.e. address_person) is set to the filter (like gnue_year) 2.) the schema of address_person will be changed to have an extra ref-field (gnue_year) (the 1. step also includes a change of gnue_property class for address_person) 1.) gnue_class.gnue_filter for the given class (f.e. address_person) is set to the filter (like gnue_year) you mean there's a new property address_person.gnue_year ? right this property will be added automagically by gnue-readgcd (like gnue_id is added automatically) can you define your own fiters? s/fiters/filters lekma: not right now, but i've worked out a concept which would allow such individual filters (arbitrary ones) we'd like to proof the concept first using gnue_company and gnue_year and if it's good and working well we can think of extending that filter-concept are those filters in 0.2.0? yes well, not there is only gnue_company and gnue_year in 0.2.0 but, hey, 0.2.0 is about one day old :) *lol* having arbitrary filters working is not the big problem actually this should play well with some minor changes, but getting the information for all that filters is a bit problematic since you won't have a login-dialog with tons of filter-values to be entered whenever you start a session or maybe i don't call a class using a filter, so i don't like to enter filter-values anyway if we can solve this problem, having tons of filters is ok :) there is nothing of filters in 0.2.0 reinhard: not even company and year?? reinhard, isn't our current version 0.2.0 ? 0.2.0 was what we released just before you committed oh, damn, right the version we are working on now is 0.3 lekma, i'm sorry i've mis-informed you so that's my mistake then johannesV: no problem the frequency of commiting and releasing is way too fast atm :) time for 0.2.1? :) any gnome studs here? anybody know how i can shotdown on logout in gnome? shutdown even in gnome you can have a logout dialog where you can choose to shutdown but for this to work you need to have rights to shutdown ah ok i have 2 remarks on the filter thing 1/ it looks like you're reintroducing a kind of 'foreign key' check 2/ asking for the year at login time is not right lekma, it's not a check we're introducing but an automatic constraint all queries have the proper filter set, all inserts get automatically filled with the proper filter the time to query for the filter-values is the problematic thing i've put it into login-dialog atm, because i had no idea where to do this lekma, do you have an idea about that 2/ ? johannesV: but you could already have done this with normal classes declaration no, i would then have to add the filtered property to all queries (including forms) and i had to maintain the fk in all new instances manually (by code) this way appserver handles this internally and therefore making this filters transparent to the user i must not change a gfd to view completely different records just by giving another company at login-dialog to the appserver's client (like forms) it seems as if there's only one company's data for example johannesV: ok, but then let's say i start to work on company 1000, and after a while i have to work on company 2000, do i have to open a new session? lekma: we highly welcome proposals on how to enter/switch companies/years lekma, exactly that's the point of interest atm it might also make sense that forms and/or navigator has a function to ask a new company/year and (transparently for the user) closes the existing session and opens a new one but actually we are in the phase of brainstorming and i'm happy for any kind of input well there's one simple way to handle this, which is asking the user to enter/select the desired datas i may be influenced by the way SAP handle this which is when you're in a transaction which is company/sales org/plant dependent it asks you for the corresponding code for every transaction? over and over again? well you can define defaults for ex by users my experience is that users like to select a company, work "in" that company, and explicitly change if they want which would mean appserver must be able to notify the client of such an additional request and this would need an implementation in forms and reports and ... yes, or every form has the company field there explicitly hmm, and what about other filters then ? or the year field etc. having a field per filter ? I think I will ask Sabine what she thinks about this she does accounting for several companies on a single system that's kinda the typical case of single install multiple company or at least one of the typical cases i like the idea of requesting values as they're needed don't misunderstand me i do agree with the filter idea, but the next thing will be the question, why not combine related filters, like company and yeare but i think that the company shouldn't be the top filter i think more like a 'group' filter should be top and i really think that you should be able to switch filters in transaction without having to open a new session for example in accountiong you want to consolidate the year result for a whole group lekma: that's something else or even for several years you can at any time in a trigger or procedure access data from other years or companies by setting an explicit condition on gnue_year or gnue_company so you can select the "consolidation" company ok an other example: and in that company, you could call a procedure that does the process of consolidation bbl phone a buyer works for several companies and order stuff for depending on the filter company he has to have a session open for each and every company he's working for? lekma: he could also have an order form where he has a company dropdown in fact actually what you say is still possible reinhard: that's my point *** jamest has joined #gnuenterprise the company and year values just get into effect for all transactions that do not set it explicitly and i think for several cases this makes sense hey i see the timestamping is in... thx whoever did it thx lekma, it was again me :) morning (here anyway) hi jamest jamest: where can i place feature requests for common? ? like? it would help a lot for appserver if it was possible to do inserts, deletes and updates without a recordset object i.e. if Connection had methods like insert(fielddict), delete(conddict), update(fielddict, condditct) how would you do that? raq sql against the datasource? where fielddict is a dictionary with {fieldname: value} to store and conddict is a dictionary {fieldname: value} to build the where clause from right now we do that in the DBSIG level don't we? no we do that in RecordSet._post() asking me about datasources after months of inactivity is almost cruel :) building the SQL and that stuff that means you cannot access that code without requesting a resultset before example at first glance this seems like something sane in appserver, i know i need to delete the record from table x where gnue_id = "abc" so with current datasources in common i first need to do a query SELECT gnue_id WHERE gnue_id = "abc" to get that RecordSet object created then i can do RecordSet.delete() RecordSet.post() which results in the DELETE sql but I have to do that silly SELECT before and ya know to me what you're suggesting make sense I've learned something today don't mess in common if you don't know exactly what you're doing is what i've learnt :) *** agx has joined #gnuenterprise hi all but I was thinking we had a sql passthru in connections reinhard: good news! jamest: I don't want SQL passthru and that might complement that as that won't work with non-SQL backends (if we ever have some) how would you specify the table to manipulate? oh right reinhard: didn't have any time to finish my translation since i was 1 week in milan for the (suck) Linux Word Expo of course as parameter to any of those 3 functions reinhard: but maybe i found a sponsor for GNUe :-P my point is the code is already there i'm saying we already may do something similar to what you want (direct access via connections) and this seems like a good addition reinhard: they're going to pay for my translation and for other stuffs it just needs moved from RecordSet to Connection reinhard: ouch, you seems busy, i'll back later agx: that#s good news reinhard: yeah, makes sense, as for where to list the wishlist item i don't think we have anything in place beyond the roadmap file reinhard: i'm in contact with an italian linux foundation, they have allocated 10.000 euro for developing OSS applications, and i'm forcing also this one to use GNUe this already *is* in the roadmap file :) lol (i put it there several months ago) i've not had any time for gnue so didn't notice another minor thing gnue-common/utils/update-tools-docs is now called automatically on release but as of, um, yesterday, i'm starting to get back in as part of my new job it would be much better if it was possible to regenerate the docs for *one* package reinhard: where is the tutorial you promised me? i've to show them something done with gnue :-P and i have also to show them that programming with it is easy! agx: still working on it reinhard: can you send the raw to me? i need to finish something for friday (in italian of course) agx: it's on the website appserver section reinhard: URL? reinhard: couldn't we just adjust that script to allow an arg passed in? or prompt y/n per package? agx: http://www.gnuenterprise.org/tools/appserver/docs/manual/devguide.html (although i didn't get around to adding much lately :(( ) jamest: i would prefer arg as release process runs fully automated now except for the symlink in downloads/current directory on ash, which would also be great if that could be automated somehow (which was my third point) reinhard: it's not what i mean, i think basic usage like building menu and form agx: oh agx: please browse through the website, "developer tools" section reinhard: don't woory, i'll try to arrange something :-) every tool has a list of available dcumentation jamest: another thing after reverting all that case sensitivity stuff we did we still have the problem that some fields appear duplicate in SELECT statements reinhard: just last question: who is in charge for developing the ERP packages? i.e. if you have a form with a field named "FooBar" but in the db the field is named "foobar" you get a "SELECT foobar, FooBar FROM table" I *think* this was there before we started hacking on common as I wouldn't know what change of ours could cause the problem hmmmm agx: "in charge"? we are a free software project :) i recall that the recordset(?) builds a list of fields linked to a table field wonder if something in there is wack i'd be willing to spend some time digging tonight and fixing the script reinhard: come one... FS is not anarchy (i hope!) *** johannesV_ has joined #gnuenterprise agx: we have some volunteers that have started to work on the stuff reinhard: there should be a guy that is more in charge of other reinhard: well ... writing ERP packages is not a matter of puppie-developers :-))) actually we haven't decided yet be as good a place as any to jump back in reinhard: it's a 2 year job :-( there has been quite some discussion about the direction to go do we want KISS or do we want SAP (in a nutshell) reinhard: i want to make SAP :-))) jamest: maybe you have a really old version of forms and common running somewhere reinhard: it's not so complicated... its just that they want to sell consultants ;-)))) where you can verify that the problem was already there s/that/whether/ reinhard: joking apart, the project of developing a big ERP for the italian market will get live in december/january jamest: and, as we are just talking about it did you follow the discussion between kilo and me reinhard: unlikely i have no time now to contribute to ERP package design, but if you have a very modular basis, is the best way to have integration between different modules developed by different projects regarding SAP style packages vs. KISS style packages? reinhard: did'nt follow it reinhard: i'was off from IRC for the last 8 days agx: this question was directed at jamest reinhard: i mean... yeah keep it KISS but not too much :-) reinhard: the default GNUe GUI isn't really very easy :-P reinhard: navigator is really a confusing tool, the way forms are handled via the icon bar also :-P reinhard: so there is a lot about GNUe i have to learn, only mad that addressbook form reinhard: s/mad/made/ reinhard: no, when was it? http://www.gnuenterprise.org/irc-logs/gnue-public.log.2004-09-22 it was quite a lengthy discussion search for "kiss" *** dimas has joined #gnuenterprise *** johannesV has quit IRC reinhard: thanks, that's not a problema now, the real problem is the learning curve and that it's almost unfinished reinhard: OUCH! you're crazy :-) WE need an address class :-) LOOOOOOOOOOOOOOOOOOL Kilo i'm with youuuuuuuuu! ROFL * agx is making fun of reinhard reinhard: BTW you can make ERP just using IRC+DIA... you have to go onto the real field and make a lot of UML drawing (not coding, drawing *g*)... after all you'll see that you need and Address class because company and people usually change address if not phisically they do this onto the legal paper (sorry for bad english). reinhard: ops, first s/you can/you cannot/ reinhard: of course for me it's not time for that implementation stuff, still the project i'm involved is not started. A KISS app from the DB point of view is not interesting for me because will be hard to modify and for my target (medium sized company) that'll be really a problem. reinhard: instead a KISS app form the user point of view is really *needed*... it's really amazing that programmer just think "what" or "how" to develope and ignore what the users would like to see :-P (generally speaking, don't take it personally) agx: i think it will most probably end up in two lines of development for packages a lightweight one and a full-blown one so if you are interested in the full-blown most probably kilo and btami are the people to talk to as well as several others i can't remember now exactly that showed interest in that path i think that it would be best long term to have 2 packages as well i don't smaller businesses need the complexity of trying to maintain something like SAP when something simple would meet their needs jamest: ok, agree now, can we come up with a name? ;-) reinhard: yes, that's exactly what i proposed to people i'm gathering around in italy: reinhard: i told them: "If you are worried it takes to much to develop (2 years), we can first make a small package for "preventivi" and invoices that can be done in few weeks in order to see if our development team work well togheter" dcl-support@gnuenterprise.org is a bad address that is a very bad thing it is the official contact email for dcl *** wt has quit IRC *** wt has joined #gnuenterprise and dcl peeps here? I was wondering about the possibility of making the dcl schemas use gnue-readgsd instead of php since it is a gnue application, allegedly *** jcater has joined #gnuenterprise *** agx has quit IRC *** wt has quit IRC hi jcater if you have a few spare minutes can you please read the log and tell me what you think? * jcater looks under his desk I'm not seeing any about my feature requests lol how well supported is gtk2 on other platforms? mac/windows? (not our client; the library in general) dunno AFAIK gtk2 runs nicely under windows, but gnome lib doesn't so most apps don't work I *thought* somebody reported to run gtk2 forms frontend under windows w/o major issues *** kilo has joined #gnuenterprise kilo: as to our discussion about gnue-kiss and gnue-fullblown jamest: i think that it would be best long term to have 2 packages as well jamest: i don't smaller businesses need the complexity of trying to maintain something like SAP when something simple would meet their needs *** erkkie has joined #gnuenterprise btw hi kilo :) reinhard: what am I looking for? you mean in the logs? reinhard: jamest: where can i place feature requests for common? the part starting with that line :) the select was needed for some databases iirc I have no problem with adding that as an extension as that's what the extensions were for you could do it at the DBSIG level so most databases would support it outright (just like our getsequence, gettimestamp, etc, support) *** holycow has quit IRC *** dpr has joined #gnuenterprise lo all, i'd just like to find out how i can get the value within an entry field from within the form.pre-commit trigger i tried __main__.start.stateETY.get() .. where state is the name of the page and that didn't work i also tried start.stateETY.get() and stateETY.get() no luck also, is there a pre-commit trigger for the insert button? dpr: try referencing BlockName.FieldName.get() I'm not sure what you mean by pre-commit trigger for an insert button? you mean a pre-commit that only fires for newly created (i.e., inserted) records? if so, there's a pre-insert trigger jcater: i'm trying to use the pre-insert trigger but it doesn't appear to work when i fill out the form and click the green insert button (in gnue-forms) .. the trigger doesn't fire i have messageBox('test', 'test') set to fire nothing happens pre-insert fires before inserting into the database (i.e., on commit) not when the user actually types into a new recore record *** holycow has joined #gnuenterprise is there any trigger that fires on clicking the insert button? yeah, let me look thanks could it be On-NewRecord? yes, that's what I was looking for cool that seems to work ta jcater: should i be getting the value of the Entry and not the Field? i.e. shouldn't it be entryName.get() ? i don't get something also, the On-Record trigger seems to fire when the app is started and shut-down as well that can't be right it should only fire when a new record is appended dpr: open a form implicitly adds a new empty record (the one you see before you query) we also fought with that when adding an OnInit trigger to appserver hmmm.. but that makes it difficult to do checks? i.e. if the zip code entered is 5 digits long and only numeric etc. 'cause the program will shit out an error everytime the app starts up checks? i don't think On-NewRecord is the place to put checks where then? because it's fired *before* the user enters stuff at least that was my understanding on the entry buttons? but then i found another problem if the user clicks on the entry field then decides they rather want to search the checks don't like them inputting nothing and complain so what i want is that it does the check just before the item is appended to the stack i'd say check usually would go in before-commit is commit to the stack or to the database? what is the stack? well, the records in gnue aren't appended directly into the database they go into some sort of stack/queue then when u click save they're appended into the database right? right so, where is the commit to? but inserting a record already inserts it into the stack the database or stack? when you edit it, you edit it as part of the stack yes, i want to do the check before it's inserted into the stack you can't it's inserted into the stack when it's still empty then it's edited *in* the stack hmm.. so in order for me to do checks, i have to go through every single item in the stack when they click commit and tell them, one by one, which ones aren't correct? that will driver users nuts drive dunno would be curious what those do who use forms in 2 tier in production (not that appserver would have a better soultion to that problem, though) will your users knowingly and purposely add more than one record before committing? maybe the autocommit feature would be a good thing to use otherwise bbl *** mixi has quit IRC dpr: I think your problem is you are doing this at the form level if you do it at the field level or at the block level then you can do checks as you go along not just at the end there's no reason to need to loop through each record at the end *** mixi has joined #gnuenterprise *** agx has joined #gnuenterprise *** wendall911 has joined #gnuenterprise *** agx has quit IRC *** agx has joined #gnuenterprise *** agx has left #gnuenterprise *** Morphous has joined #gnuenterprise *** Amorphous has quit IRC *** johannesV_ has quit IRC *** holycow has quit IRC reinhard: ah, yes, i am here... reinhard: if i want to store in a property gnue ids coming from multiple classes, should i use the 'id' type for the property and check at store time, or is there another way? lekma: seems ok that way lekma: yes, I'd also say you could do that probably thx guys it's about adresses :) however this will not make use of referential integrity features of the db lekma: i figured that lekma: it's exactly the point where the problems with that approach start :) lekma: what is an address? 8-)) from my pov an address is an object that can be attached to nearly anything hah employees/contacts/plants address is an object, reinhard... warehouses/companies... kilo: i hear you polar bears... :) and several contact can share the same address like Ursus_Maritimus.adress_region=Canada NWT :) but i also like to have only one class for addresses a KISS approach Ursus_Arctos.address_region=Canada NWT reinhard: you should copyright "KISS" lekma: my wife would not want that ;-) :) well maybe under the GPL ;-) i've tried the single address pool in a smallish business app and it sucked hard and long yip * jcater raises his hand me too! not saying it doesn't have a place in large, complex systems jamest: what do you mean 'single addresspool'? one address table that stored ship to, bill to, vendor, customer addresses that other things then linked to what I'm assuming you're talking about above jamest: yes, that was also my understanding of what lekma meant yes that's correct, why does it suck? what sucked? i used it several times the single address pool everything pulled from it made ad-hoc sql reports more complex ?? it confused my assistants that i could have handed off such sql report creation too simple systems that only required 1 address had to be adjusted ensure only 1 address existed and that multiple addresses didn't get linked in that's what I recall as the biggest pains *** erkkie has quit IRC there's no point in normalizing addresses it's leads to cluster fuck sql * chillywilly runs off :) :) cat jamest | chillyfilter cluster fuck sql hmmm skimming over the log .... sucks ... ... hard and long ... ... fuck ... what channel am i in here?? :) O_o also KISS... reinhard: i must have been gone longer than I thought as it sounds like gnue :) *** kilo has quit IRC *** chipig` has joined #gnuenterprise *** dpr has quit IRC *** jamest has quit IRC night all *** reinhard has quit IRC good night everyone *** lekma has quit IRC *** chipig`oracle`cl has left #gnuenterprise *** wendall911 has quit IRC *** wt has joined #gnuenterprise *** MiXi^ has joined #gnuenterprise *** ccfiel has joined #gnuenterprise hello pll.. *** wendall911 has joined #gnuenterprise *** Lord_mYk has joined #gnuenterprise *** mixi has quit IRC *** jamest has joined #gnuenterprise hello jamest.. hi jamest: im exploring gnue...i think i found a bug.. i tried running zipcode sample..(states.gfd) ok *** ccfiel has quit IRC when i add a record..in the master and decided not to continue a click the revert.. after that i cannot close the form using the icon..and even enter a query or any of the buttons.. does not work..:( let me look im using windowsXP.. so you added the record in the master then reverted while in the master? yes. you get an error msg about index being out of range? nothing...no error... hmmmmm in svn head it is generating an error msg under linux so there is definately a problem try this revert in the master then go down to the detail block and revert again then try and exit ok ill try.. if so then we're probably seeing the same bug and I'll take a look in a little bit but i've not touched gnue code in months so no promises on a fix tonight :) ok...il try to check.. :) jamest: yes it works..:) ok, same bug then yes same bug..can i help..? if you would like? but im not experience programmer in pyton..:) i seem to recall a while back someone wanting to make it so you could only revert specific blocks it may be related i'm not even sure where to point you, i'm really really rusty you mean its a feature? not bug? :) may be a bug in a new feature i don't recall if anyone even implemented it but it sure seems like the blocks require seperate rollback ic... i also found something...wierd.. when you delete a record.. what's that? when you delete a record..and its the last 2 record left... the 2 record became the same... sigh ui corruption on commit eh? but you make a fresh query again it display the correct...record.. thats a problem that comes and goes all the !@#!@# time i'll look at that too thanks..:) no problem good a place as any for me to get back into the code :) i realy like to help the project...:) i hope i can help.. how about i do the testing? :) we're always wanting help sure, sounds great i made my first contribution in appserver :) i made the zipcode sample to a 3tier apps..:) ok..ill do the testing..:) cool jamest what time do you usually log on here so that we could communicate? :) i could report you if i found something.. i'm almost always logged in at home and work however I've been mia for months just switched jobs and starting some new gnue based stuff there ic..thats good to hear... i really like the concept of gnue.. so should be close to irc from 8am to 5pm CST and probably 7pm to ? as well ok..its now morning in our place.. jamest: imho, how about every time a commit happens it should do a refreash..query..accourding to the filter..:) that's in the works jcater started commiting work on that last weekend IIRC *** wt has quit IRC jamest: you don't work for the uni anymore? no where do you work now? ajrs a company i've consulted for for years ok they are gnue users cool jamest: thats good.. about to become a lot bigger gnue users too :) :) do they have a website? ajrs.com doh crazy that :) hmm, their site needs work ;P disclaimer: i don't claim the website or the "buttons" sigh, i'm too slow it's on my todo their images are all jaggy too yes who made that site? the main site was paid for the eClaim button was dontated by a big customer so we used it the tracking numbers graphic, i dunno i've started working on the site some for the online stuff and tracking stuff but low priority * chillywilly redesign http://design.metalexpress.net with divs and css but of course IE breaks the damn thing we're moving from a 5k sq ft building to a 25k sq ft http://mx.libertyetech.com/2col.html cool and at the new building we're installing all new networking equipment leaving the old server in place at the old building and putting in a new setup are you in a cube? until after the move yes then back to a private office we don't have the space now ajrs moves about every 2 years dbls in size I was cramped into a little back conference room util the corporate office moved out of the waukesha plant what are there products? :) with another guy no products now I have a big office of my own :) service? yay we work with insurance companies to replace stolen car electronics or damaged ic.. and our reps know car audio so we provide fraud prevention as well cool..:) nifty it does mean I'm spending far more time coding anybody here know about md5 collisions? today was working on new invoice system with gnue forms front end and gnue-common progs cool...thats nice.. so more bugs will be elinated..:) no where near the number reinhard and johanne(sp?) are fixing now they are devoting X hours a week to it bugs? what bugs? I think they are random features ;) jamest: i think there are more doing the appserver.. they've put in a lot of love all over the place and it really has made a difference sigh it's time to crack open the forms code stop that * jamest is scared the sighing that is... depressing you? just reminds me of someone I know who is very depressed and all they ever type is *sigh* hmmmm holy fud puckers! it's time to crack open the forms code jamest why are you depressd? better chillywilly? ccfiel1: I'm not gre gobs of gooey goop batman! great* haha ... holy fud puckers ?? wtf ?? lol i just know the gnue code isn't kind to newbs or old dudes that haven't been digging thru it in recent memory thus the.... sigh *sigh* why you depressed chillywilly? because life sucks and then you die heya chillywilly: what gnome applet/desklet have I been seeing that looks like the OSX menu? you struggle your whole life and are rewarded with the big dirt nap wendall911: I dunno I don't use that one chillywilly: hmm, I have seen screen shots, just can't find it...I don't really want to use it, just wanted to check it out for kicks. Thanks anyway. :) let me look cripes! old people and their funny sayings someone has scattered these strange "comment" things throughout the forms code woah... I forget where the desklet files are and what their extensions are bah no biggie help me :) gdesklets ? yea *.display yea and where do they usually live? /usr/share/gdesklets/Displays/ on Debian k gnomebar? nope starterbar-desklet that's the one I believe you're talking about the one that rotates and magnifies? wonder why I can't just click ona .display file anymore and have it fire up the desklet chillywilly: I think it is starterbar http://gdesklets.gnomedesktop.org/categories.php?func=gd_show_app&gd_app_id=13 yea chillywilly: it just looks like the one that rotates and magnifies in a screenshot, just not sure if it does I don't think it rotates I just put buttoms on my panel ;P chillywilly: yeah, same here, plus I like having my desktop and open apps choosers on the bottom, ie the default *** wendall911 has quit IRC *** jcater has quit IRC ccfiel1: that bug was caused by the autocommit feature on blocks always trying to commit the form at exit even if it was empty states.gfd demos autocommit so was triggering it svn head should be ok now jamest: ic.. do i need to get it a new copy of gnue-forms? you running a release? or from an .exe? i use to download the source form the svn.. svn would get it or you can change 1 line in your install if event._form._currentBlock.autoCommit: replace with if event._form._currentBlock.autoCommit and not event._form.isSaved (): in the executeExit(self, event) method around line 886 i have to run *** jamest has quit IRC ok thanks jamest... *** holycow has joined #gnuenterprise hello holycow.. hey dudes *** ccfiel has quit IRC * chillywilly worships the holycow * holycow noogies chillywilly i dub thee 'saint chillywilly' *pof* *** cilkay has joined #gnuenterprise *** ccfiel has joined #gnuenterprise hello pll..