*** cilkay has quit IRC *** sjc has joined #gnuenterprise *** btami has joined #gnuenterprise *** johannesV has joined #gnuenterprise *** holycow has quit IRC *** reinhard has joined #gnuenterprise *** wt has joined #gnuenterprise *** kilo has joined #gnuenterprise good morning good morning good morning *** holycow has joined #gnuenterprise anyone around? *hmmm* yes aye i downloaded cvs files, been several months since last i had a chance to startup gnue ... now i can't connect to a data source on postgres on the other system (connection is fine), do i need to run anything to fix this? i vaguely remember an email giving instructions to do so about a month and a half ago ... ? can you connect with psql? i use pgaccess to connect yep, seems to be fine, lemme try to add a table do you get any error message with gnue? and, most important, what tool are you trying? create table * works, errors in gnue forms * yes can you paste the error message here? (in case of a traceback the last few lines) oh nm, it works now ... weird, restarted designer. do you still want the error message? forms or designer? pardon me, designer ok then no, don't want the error message IIRC designer is known for some weird behaviour when trying to connect k. sorry to bother you, i don't know why it didn't work earlier np :) i see a whole lot of new stuff up there, congrats reinhard, where is the majour push right now in terms of development ... appserver, forms ... other? holycow: in designer, file/connect works sporadic... kilo, cool, good to know sometimes you can connect once, and then can not do so any more. you can seea whole bunch of error messages in the terminal then. in that case just restart designer k. *** sjc has quit IRC reinhard: the etc dir (containing sample.report-filters.conf) is missing from released gnue-reports sorry for reporting this not before the release, but i'm just back from my 3 days holiday btami: should that become installed somewhere? btami: np it's like common's connections.conf yes but it seems to have been missing before, too hasn't it? yep should "setup.py install" install it somewhere? exactly where common installs connections.conf and gnue.conf ok just noticed when building/testing .uhu packages... i checked all the downloaded files, samples, wiki, website ... is there a simple example of how to create a form (without appserver) for lets say inputing first name, last name into a simple two column table to postgres? i don't have much sql and relational database experience, so some of the terminology via designer is confusing ... although i grok the general idea of whats going on here forms has a developers guide http://www.gnuenterprise.org/tools/forms/docs/Developers-Guide.pdf oh there we go *nod* cool danke but the fastest way is using developers simple form creation wizard s/developers/designer *nod* thats really a cool tool, i have trouble selecting my table and appropriate field to populate lets say a pulldown menu via that ... but thats due to my lack of skill okay, the part i always get stuck on when inserting a new data source is the 'select validator table/source' menue i have a postgres db that i can connect to, it has a table labeled 'names' with columns 'name_first' and 'name_last' how does the validator table popup relate to my table? * btami is away: according to the developers guid i need to select an alias ... ? *** allemann454 has joined #gnuenterprise bbl *** btami has quit IRC *** allemann454 has left #gnuenterprise okay, the developers guide is mostly useless for newbs * holycow waits to pounce on sacha when he arrives :) holycow: have you tried the new form wizard? yep, i realize this makes me look stupid, but i just don't get it say you wanted the simplest form possible, display 4 rows (first 4 entries or whatever) of a single table as soon as i grok some more of this i'm writing a sub-newb tutorial lol ;) ok, step-by-step instructions follow desginer File/New/From wizard... menu entry k. on Forms tab select Simple form wizard click Start wizard k. new designer instance starts Form title: aaa Connection: select your connection to the db k. click Next in the next step select the table the name of my table is 'names' ok, tehn select 'names' okay i see it there now... what are all the other things in there? like? referential_constraints role_column_grants postgresql inner things ahhhhhhh! no shit okay thats what got me, i didn't see my table in there, okay got the rest :) on next step select the columns you want to display k. yuo can sort their order too in the right listbox select arrangement method k. for simple form, select Single record with labels to the left or for a grid, select 'grid format' and when you press OK, magix begin and when you see the results, SAVE!!! nice ... then run gfcvs form.gfd :) yay! easy yes yes yes okay one tutorial starting up one last question... how is the data 'inserted' into db.. i noticed the ui is generated once the form is running... do you typically create a 'submit' button in your forms or? oh save! wow holy shit thats superb, okay you guys are in trouble now thanks kilo! expect a quick tutorial in the next few days np i think the wiki is a good place for such a tutorial, you could place some screen captures in the wiki too thats what i was thinking ... where i got lost was selecting the table now open up a text editor to view form.gfd and read through Forms' TechGuide and DevGuide lots of possibilities to try i wasn't expecting postgres internals to be available in table select window eg when you are bored to hit the Save button several times, try AutoCommit and so on... *nod* my biggest frustration was just learning to 'find' the stupid table... the document now makes sense cool. actually i'm going to start writing small information stores right away i REALLY need gnue, i can't believe how easy it is autocommit? ohhhhh... sweet autoinsert... autonextrecord... i have two more questions... unrelated to this now that i can create tables and insert data autosendmorecashandwhiskytokilo lol :) do you guys have a fund? i would like to donate something... money order or whatever ask reinhard, or better, james/jcater/derek. cool stuff * ajmitch has to work on an app using gnue this week and I see new forms/reports/navigator ajmitch has to prepare new debian packages this week ;-) lol :) reinhard: I've got current common & appserver :) oh no, last one like that was lekma, and he disappeared one day before deadline... reinhard, i would like to donate a bit of cash... do you guys have anything setup? appserver is still missing that gnue-setupdb manpage... and I don't know enough about that prog to write a manpage ;) i grok now exactly what problems gnue solves for me ... not that gnue-setupdb does much... you guys got it exactly right reinhard: I might drop debian & move to ubuntu ;) my other question is i want to write gnotime in gnue ... all it does is store information about various todo lists... and then you can hit a 'timer' to time the amount spent on a particular task my question is, can you say connect to a python app that say 'times' tasks ... than grab information from it and drop it in as a var into gnue? and second one would be, are there any considerations for a tree like widget in gnue? neither are necessary, just curious holycow: a tree widget is available under wx, just undocumented re your first question, i have to think and 3 hrs sleep does not help that... ah! so one would need to just hack the xml file, cool. that could be interesting no worries ... the question definately pushes some of what you guys are doing outside the scope of the project ... look at gnue-forms/samples/tree i.e. do you become a general programming framework, or keep it simple and straight forms input oh cool! that form throws off errors, thats fine, i won't be able to code up something like that for a while oh last question... is gnue appserver similar to various python engines for python webframeworks? say like mod python or some of the custom engines? in other words, say a part of the application requires some webforms to be deployed... the webforms simply post the data to the gnue appserver or is there an intermediate step, say modpython or some other form of cgi to hand over the data or retrieve data? holycow: sorry i can't follow, but it is my fault. ask reinhard. lol no prob :) i'll ask another time, i know you guys are busy/tired thanks for your help greatly appreciated i wait for the coffee to make some effect lol now i'm too excited to go back to sleep :) all your fault kilo lol gotta buy some tea to put me to sleep :) i'll see you guys in a few ajmitch: gnue-setupdb is a helper script that creates the tables necessary for gnue-appserver to run it you must have your connections.conf set up and it takes no parameters at all holycow: you cannot donate money right now AFAIKT, but you can donate documentation, bug reports, and patches :-) holycow: appserver is not a web service off again ajmitch: we might release another version of appserver that contains a manpage for gnue-setupdb within a few days reinhard: yet another release? ;) yes reinhard, danke off now for real *** holycow has quit IRC *** johannesV_ has joined #gnuenterprise *** kilo has quit IRC *** johannesV has quit IRC *** jamest has joined #gnuenterprise good morning jamest morning are you ready for a feature request/idea for forms? sure a dropdown that isn't a dropdown i.e. an entry that can be connected to another table that validates against a key in that table but instead of a dropdown it has a button or something like that already there that opens a search dialog ah that isn't already there rationale: dropdown is ok for things like currencies, countries, item groups what I wanted is a little more generic I think but would have same effect but for example to enter an item number i wouldn't want my form to load all 100000 item records to fill the dropdown list more generic is even better :) i wanted forms to allow you to tie any field to a datasource so what is already there? that datasource would be expected to return fields along the lines of key, description, [description],[description]..... then when a function key or toolbar or something triggered the "search" function a dialog would pop up? sorry, users yes where i see a grid with that datasource? it would display join(descriptions) and i could filter by any of the description columns? ah oh and the user would pick one and the key would be entered into the firld field i would see the need to filter by description columns that seems very reasonable (remember my 100,000 items ) yeah i was thinking filter on the datasource, but the dialog could add addtional filter rules but basically that's quite exactly what I was meaning yeah typical search dialog this is a oracle sql*forms feature I really miss i see a dialog with several entries on the top item number, item description, item group, price i can enter search criteria in them and press "search" key cool get all items that match and can select one we could drop the join() of the description fields and just not display the key field yeah, i'd prefer a grid and that would be nicer than sql*forms that I recall if you really wanted to show the key you could setup the datasource key, key, description yep but the idea was you'd only have to add something like but what would i have to enter in the entry in the main form? the key? searchds="mytDatasource" to the field or entry key == the value actually inserted after the user chooses one so if I'm looking up a sku i can scroll though all the available ones, via the grid and pick the one I want, then that sku would be put into that firls field key is bad wording for it now i want even more my item table has a gnue_id that is a random number and an item number i want the form entry to accept/display the item number but to store the gnu_id in the backend gnue_id of course that wouldn't be much a problem as dropdowns do that now and to validate you can only enter valid item numbers yes exactly like dropdowns coupled with searchds youd be there ok now it's been a really long time *how much* of this is already implemented? the search stuff none now you can define a dropdown get it working and remove the dropdown style from the entry and it'll still validate ah i can't recall what it validates against though key or displayed value that was done years ago :) but that'll mean the form loads all records of the search datasource into memory when opening the form that means opening a form that references item numbers would take about 1/2 hour to open i thought it only loaded the 1st 10 if you have a few thousand items i think it loads all of them if you didn't force the prequerey but i can be wrong i think we can try that this could also be the time to add autofill forms er, fields kinda like the dropdowns minus the dropdown so I type Rei and it pulls Reinhard automagically sigh i need a clone or a johanne that seems to work well for you :) removing the prequery=Y from the dropdown source leads to an empty dropdown ah, drat i'm still not sure it'll load all records removing dropdown style from the entry causes the entry to display the key instead of the display value i.e. the gnue_id instead of the name, code, item number, or whatever we want but at least we agree it would be a cool feature but the validation works i mean you have to enter a 'valid' key-value (fk_key) right i just couldn't recall what it displayed so we would have to change this to 'display' and 'validate' fk_description instead i wanted dropdowns to fail to usable state even on ui drivers that didn't support dropdown (curses at the time) jamest: well, when you use appserver, that's not really an usable state true that because the primary and foreign keys are 32 digit random numbers but at the time there was no appserver :) and they are very hard to memorize for users ;-) jamest: :) i think that'd be somewhat enjoyable to watch :) also for 2-tier if you have things like serials or such for primary keys *** kilo has joined #gnuenterprise *** wt has quit IRC *** jamest has left #gnuenterprise *** dpr has joined #gnuenterprise lo guys is there someone here who can help me with the appserver? *** jcater has joined #gnuenterprise lo jcater, could you help me out with the appserver? *** jamest has joined #gnuenterprise *** dcmwai has joined #gnuenterprise dpr: please ask i have a little knowledge about appserver ;-) lier.... well er.. i have it up and running etc. you wrote part of the appserver :) dcmwai: :) i was just wondering how i go about managing the tables etc. in it? dpr: ah, that's great it seems like quite a different system to using a normal database i am *right now* working on a documentation to cover *exactly* that topic oh, cool please see http://www.gnuenterprise.org/tools/appserver/docs/manual/devguide.html and give me feedback about understandability etc documentation also needs beta testers :) reinhard: does the cvs version of gnue have a different name for gnue-readgcd ? yes, the cvs names are gnue-appserver = gacvs gnue-readgcd = gcdcvs gnue-readgld = gldcvs *** dneighbo has joined #gnuenterprise reinhard: i had success importing the gcd file, but the gld example you provided is breaking? it says it does not recognize the language attribute? omg did i write lang= in the doc? it should be language= nah, it says language he same works for GLD files: language should work you sure you have no typo? yeh, i copy/pasted it :) DB000: MarkupError: Error processing tag [I do not recognize the "language" attribute] and you used gldcvs not gcdcvs? jamest/jcater/dneighbo: it was raised earier today that someone would donate some funds for GNUe. Any way to do this atm? oh, no i didn't realize there was a gldcvs oh cool it works now k, sorry 'bout that i have to thank you you are the first to try my doc :) ah, reinhard, so i have to fire up kbabel today again? 8-)) hu: 137 translated messages. is the current state of hu in appserver we didn't introduce any new strings wow, good news reinhard: documentation is good thus far cool did everything work as expected? if you reach the end of the doc for now you have to refer to the samples to get an idea of the other appserver features *** dcmwai has quit IRC yeh, i've reached the end of the doc and everything worked fine grrr how do i remove an object that i've inserted ? it took me hours to write the doc can't believe you worked it through in a few minutes ;-) you mean a class? kilo: yes give them my name and my home address I take checks :) manually delete the table in the db backend gnue appserver will *never* do that for you as you could delete tons of data accidentally yeh, that's true kilo: not that i'm aware of at one time the fsf would take donations for us but I don't think it was ever finalized jcater: yes, that's what i've thought of exactly. but as i don't know your home address, i would give my own... 8-) is it a python glitch that when i specify a box of length 2 the box accepts two characters but doesn't fit them in properly? i suppose the documentation will eventually describe how to give different users different access to the apps in the appserver? dpr: the size of boxes is too small for 2 reasons a) it is calculated with an average character width but uppercase characters are mostly wider than lowercase b) the border around the box takes away space not usable for the characters both effects are worst when you have very short lengths with only uppercase characters unfortunately we won't be able to fix it properly before we have a layout manager in forms reinhard: is there a way you can define the box bigger than the maximum amount of characters that can be entered into it? i.e. define it as 5 in the .gcd file and 6/7 in the gld file? dpr: only when you manually create a form (a gfd) oh, okay actually most of the gnue team agrees that we will want a layout manager in forms at some point reinhard: and if i create a gfd, can i upload it into the appserver as well? and this will solve the problem no, you can't upload a gfd to appserver (yet) oh, okay .. lastly .. how do u define users with different access to appserver? "yet" because i've been thinking about such a feature but not sure whether it would be good or not i mean, at the moment, can anyone upload to my appserver? you mean upload = define classes or upload = enter data? yeh, define classes well, both i want some users to be able to search through data and others to be able to ed it edit it ok that's a feature not yet available with appserver oh, okay.. but it's in the pipeline, right? yes k, cool probably in one of the next 2 milestones but we are talking about months here and then how about people who are able to define classes? that's easy gldcvs an gcdcvs need access to the database so you can handle that on db side oh, yeh that's true okay there's a very preliminary security system where you can define usernames and tell which username can access which classes but it's only for complete classes and only full access or no access *** chillywi1ly has joined #gnuenterprise *** chillywilly has quit IRC bbl *** reinhard has quit IRC *** sjc has joined #gnuenterprise *** johannesV_ has quit IRC *** havoc has quit IRC *** havoc has joined #gnuenterprise *** havoc has quit IRC *** havoc has joined #gnuenterprise *** wendall911 has joined #gnuenterprise *** reinhard has joined #gnuenterprise *** cilkay has joined #gnuenterprise *** dpr has quit IRC *** wendall911 has left #gnuenterprise *** kilo has quit IRC *** jamest has quit IRC *** reinhard has quit IRC *** jamest has joined #gnuenterprise *** jamest has left #gnuenterprise *** jamest has joined #gnuenterprise *** sjc has quit IRC *** jcater has quit IRC *** havoc_ has joined #gnuenterprise *** jcater has joined #gnuenterprise *** holycow has joined #gnuenterprise * holycow waves * jcater moos lol jcater, you guys are going to regret cluing me in this morning on how to connect to a db :) ehe :) hi time to kill firefox great, freed up about a GB of mem lol lol slow to startup as well eh? newest rc anyway yep it leaks? hmmm hi ajmitch *** jcater has quit IRC *** jamest has quit IRC