*** reinhard has joined #gnuenterprise
*** johannesV has joined #gnuenterprise
<johannesV> good morning
<johannesV> anyone working with the adodbapi driver ?
*** dimas has quit IRC
*** sjc has joined #gnuenterprise
<reinhard> johannesV: AFAICT no
*** btami has joined #gnuenterprise
<btami> good morning
<johannesV> hmm, looks like it's not really working fine
<johannesV> the main prob is that broken row count
<johannesV> but if it's not in use i can play a bit with it
<reinhard> what is the problem with the broken row count?
<johannesV> it's currently implemented by a select count (*) from ...
<reinhard> it should be handled ok with the select count that's generated
<johannesV> this statement is executed by another cursor right after the original query
<johannesV> and that raises an error telling something about to connections running in parallel is not allowed for manual transaction modes
*** kilo_ has joined #gnuenterprise
<reinhard> ah crap
<reinhard> then I'd propose to first run the select count and then the real select
<reinhard> could that work?
<reinhard> would be in Base/ResultSet.py IIRC
<johannesV> yes, that might work (it was the same idea as i've had)
<johannesV> because we could close the counter-cursor right after execution
<reinhard> right
<kilo_> good morning
<reinhard> good morning kilo
<reinhard> and all
<reinhard> just btw :)
<johannesV> ok, if i change dbsig2.resultset's order of doing the queries (for broken rowcount) it works
<reinhard> great
<reinhard> I would see no reason to not do this
<johannesV> so do i
<johannesV> reinhard, what is going wrong if an update statement contains all fields in the where clause ?
<johannesV> (using sample.gfd=
<reinhard> with appserver?
<johannesV> no, direct db-connection
<reinhard> ah
<reinhard> that's ok
<johannesV> btw. adodbapi can use the boolean values in params
<johannesV> and it fully supports unicode
<johannesV> in all directions
<johannesV> (even in cursor descriptions)
<reinhard> if there is no rowid and no primary key, what else would gnue use for the update statement? :)
<reinhard> wow
<reinhard> if only all DBSIG2 drivers were like that
<reinhard> (except that I'd love a non-broken rowcount, too, of course)
<reinhard> you still have the test code for that around? that's good - maybe we want to get back on that later
<reinhard> when maybe some DBSIG2 modules have better unicode awareness
<johannesV> ah, so i have to define the pk in the gfd .. ok
<reinhard> yep
<johannesV> ok, works fine too ...
<johannesV> yeah, i'll keep that test-program for dbsig2-based drivers around
<reinhard> you have it in SVN? would be good
<johannesV> maybe i can refine it a bit and commit it into common's testing
<johannesV> right :)
<reinhard> my thought ;-)
<johannesV> uups, there are still debug-prints in win32 ui-driver ... :)
<johannesV> after i've installed wxPython on my xp forms are looking quite nice using win32 ui driver ..
<johannesV> (of course not as good as using gtk2 on my sarge  :)
<johannesV> reinhard, can i do that change to DBSIG2.ResultSet ?
*** dimas has joined #gnuenterprise
<btami> johannesV: have you tried it (win32 ui) with non fixed font too ?
<johannesV> of course
<btami> ok :)
<johannesV> this was the first change i did to gnue.conf
<johannesV> :)
<dimas> good morning
<johannesV> in which way does the win32 ui driver need wxPython ?
<johannesV> hi dimas
<btami> no way
<btami> just designer wants it
<btami> hi dimas
<johannesV> hmm, strange ... case it changed heavily after i've installed wxPython ..
<johannesV> but maybe this is just because the reboot in between ...
<dimas> does non fixed fonts deserve to try on win32?
<btami> sure
<johannesV> yeah, i'd say you can try it ... some labes migth be cutted of on the right side ... but overall it's good looking
<dimas> thanks
<btami> yes, the label width calculation isn't perfect :(
<btami> but you can use +1 for label width in .gfd files, if needed
<reinhard> johannesV: yes, of course you can commit that change
<reinhard> (although I see you already have) :)
<johannesV> :)
<btami> btw. we are using adodbapi for pump data from foxpro to firebird
*** holycow has quit IRC
*** holycow has joined #gnuenterprise
*** holycow has quit IRC
*** dcmwai has quit IRC
<btami> dimas: you here?
*** rynik has joined #gnuenterprise
<btami> hi rynik
<dimas> yep
<btami> dimas: have you working filters ?
<btami> if i have no records in filter table, i can't login
<btami> if i add one manually, i get protocol error from xmlrpc
<dimas> hold on
<dimas> i got those introduced in gnue-luca working
<dimas> but i did initializing in three stages
<dimas> and after each inserded needed data
<btami> can you explain a bit how was that stages? :)
<dimas> oh, i even divided base.gcd and gl.gcd in parts :)
<dimas> load base-pre.gcd which defines only company
<dimas> insert company
<dimas> load full base.gcd
<dimas> got login with one additional field
<dimas> the same way for gl.gcd
<btami> huh, thx dimas
<dimas> not sure it is nice way, but at least i could login :)
<dimas> btami: if you find something new about filters, please let me know :)
<btami> :)
<btami> bbl
*** btami has quit IRC
*** sjc has quit IRC
<tiredbones> After much sreaching and coming up empty, could someone point me to the POS that jcater did?
<tiredbones> I thought I would use it for a learning tool.
<tiredbones> When I try to do a seach at the address http://www.gnuenterprise.org/project/search.php
<tiredbones> I get an internal error.
<tiredbones> I do a search in section for prodjects.
<tiredbones> s/prodjects/projects/
*** kilo_ has quit IRC
*** jamest has joined #gnuenterprise
<reinhard> tiredbones: it is (like everything) in svn
<reinhard> tiredbones: although IIRC it doesn't make use of forms and reports but is purely common based
<reinhard> if you would like to learn to use forms or reports, there are better examples
<reinhard> and if you want to learn to work with appserver, we even have a documentation ;-)
<reinhard> jamest: would it be possible to move the web page generation to, say, 23:00 ?
<reinhard> would be a little more "european friendly" as 4:30 is 11:30 a.m. here
<jamest> lol, um sure
<jamest> hammer on the server pretty bad does it?
<tiredbones> reinhard: I just purchase a book on svn but haven't had time to read it. Do I need
<reinhard> no
<reinhard> jamest: it's more the issue that I like to have the logs of cron jobs appear in my inbox in the morning
<reinhard> instead of for lunch :)
<jamest> anything for you
<tiredbones> reinhard: a copy of svn on my system?
<jamest> done
<reinhard> thanks
<jamest> tiredbones: you'll need svn to check out a up to the minute copy of gnue
<jamest> or you could use a snapshot which gets updated daily
<jamest> if it were me and I was playing around I think i'd use svn
<jamest> then if you hit a bug and someone can fix it quickly you don't have to wait a day for the fix
<jamest> it's not hard to use
<reinhard> I think tiredbones is after gnue-pos
<reinhard> and there is no nightly snapshot for gnue-pos as it was never released
<reinhard> actually I am not sure if it wouldn't belong into gnue-contrib instead of gnue proper
<tiredbones> thanks to both of you.I'll go ahead and read my svn book.
<tiredbones> reinhard: The way I understand appserver, one has to design to 3-tier. Is this correct?
<reinhard> yes
<jamest> reinhard: it does need moved
<jamest> gnue-contrib didn't exist at the time IIRC
<reinhard> ok
<reinhard> and while we're at it, do we want to remove gnue-docbook?
*** titopbs has joined #gnuenterprise
<tiredbones> Yesterday, I was using using one of the examples to help me learn forms, when I got
<tiredbones> an error in NamespaceCore.py.
<tiredbones> In trying to track now the cause I realize it's going to tak all summer to
<tiredbones> learn the system.
<tiredbones> I have got one hell of a learning curve ahead of me.
<tiredbones> It looks like to learn gnue you have to read the code.
*** johannesV has quit IRC
<reinhard> tiredbones: it depends on what you want to learn
<reinhard> tiredbones: for an office application, it's a difference whether you want to write a letter or you want to do macro programming
<reinhard> likewise with gnue, I think creating a form pointing to existing data is something one can learn virtually within minutes
<reinhard> jamest: what do you think about gnue-docbook?
<reinhard> and what about gnue-dbtools, integrator, oldpackages, phpforms (which all seem to be dead projects)
<tiredbones> reinhard: I don't think so.Look at the number of people that come and look
<tiredbones> and then leave.
<tiredbones> s/look/look at the system and then leave/
<reinhard> well
<reinhard> most of the people looking and leaving again are asking stuff like "where can i download the crm module"
<reinhard> that's our main problem
<reinhard> sure we need more documentation
<reinhard> and we highly appreciate any volunteer that writes and maintains documentation
<tiredbones> I'm going to stay with it, because I have a lot of faith with the people
<tiredbones> developing the software.
<reinhard> so if you would want to update the guides you read, found useful and saw a few things being outdated
<SachaS> but watch out there is currently high application server development ;) so documentation gets out of date quickly ... which is good, sort of.
<reinhard> that would be a very good step to improve the situation
<reinhard> SachaS: it has become better
<SachaS> i am using a simple gnue 3-tier application, daily
<SachaS> which is cool.
<reinhard> SachaS: that's great! Any chance you could add it to gnue-contrib?
<SachaS> it needs cleanup
<tiredbones> reinhard: I do plan on doing somethong, but I have to understand thing better and
<tiredbones> that's going to take me a longer time than a few minutes.
*** johannesV has joined #gnuenterprise
<SachaS> tiredbones: I did play with gnuenterprise for a while and ended up with a sample application which is unfortuantely no longer running as I did not keep up with appserver development.
<SachaS> tiredbones: here are some screenshots: http://www.gnuenterprise.org/~sachas/screens/
<tiredbones> Thanks Sachs, I'll go look at them.
<reinhard> BTW, I am not sure if it is a good idea to tell all people to use SVN. I'd rather think we should have regular, reasonably documented, consistent and reasonably stable releases
*** titopbs has quit IRC
<tiredbones> SachaS: What OS do use?
<SachaS> Debian GNU/Linux unstable
<jamest> reinhard: what is this stable thing you speak of?
<reinhard> jamest: lol
<reinhard> reinhard: jamest: what do you think about gnue-docbook?
<reinhard> reinhard: and what about gnue-dbtools, integrator, oldpackages, phpforms (which all seem to be dead projects)
<tiredbones> reienhard, jamest: LOL!
<reinhard> and also gnue-samples does not seem to be used like it was planned to
<reinhard> (and also my experience shows that it's better to package samples to the tools instead of separate packag)
<tiredbones> reinhard: I totally agree to this last statement.
<tiredbones> SachaS: Would it be possible to get a copy of your source?
<tiredbones> I notice in reading the archives that some people where looking for some business
<tiredbones> data models.
<tiredbones> I have a book that gives a good general data model of business.
<tiredbones> Would people be interested in it?
<SachaS> triedbones: it should still be in the gnue-contrib section, if nobody removed it. but it is problematic as it includes outdated stuff.
<SachaS> triedbones: unfortunately the contribution link is broken on the website
<SachaS> jamest, reinhard: the link "other projects" points to empty /contrib/ directory
<reinhard> I think that part of the web page is not yet finished
<SachaS> ok.
<SachaS> triedbones: i highly recommend to study the sample application of  the gnue application server. That is probably one of the best ways to learn how the gnue appserver can be used for an application.
<tiredbones> reinhard: Why not just pull all the connection on the web site that go nowhere.
<reinhard> I don't know enough about the website to fix that
<tiredbones> reinhard: okay.
<tiredbones> Well I feel better now. At least I know why it's there.
<tiredbones> Off to read my svn book.
*** kilo_ has joined #gnuenterprise
*** wendall911 has joined #gnuenterprise
<johannesV> back
*** mnemoc_ has quit IRC
*** titopbs has joined #gnuenterprise
*** mnemoc has joined #gnuenterprise
*** aries_mindworks has joined #gnuenterprise
<aries_mindworks> hi
<aries_mindworks>  ProgrammingError: (1146, "Table 'gnue.gnue_module' doesn't exist")
<aries_mindworks> what does it mean?
<aries_mindworks> setup-cvs.py install has done
<reinhard> have you created your db with gsetupdbcvs?
<aries_mindworks> not yet...
<reinhard> well
<reinhard> then it means you should ;-)
<reinhard> when did you get this error?
<aries_mindworks> reinhard: ok, now it's working, thanks. i suggest you should put it into the setup-cvs.py install procedure
<reinhard> nope
<aries_mindworks> as to create /var/run/gnue ;)
<reinhard> gnue can't guess which database you would want to use
<aries_mindworks> kilo: hi!
<aries_mindworks> reinhard: it's using the connection.conf
<reinhard> but I have put it in doc/configuration.txt and reference that file from INSTALL and reference INSTALL from README...
<aries_mindworks> reinhard: the gsetupdbcvs
<reinhard> aries_mindworks: yep, but setup-cvs.py *creates* connections.conf :)
<aries_mindworks> reinhard: so, you should produce an almost working connection.conf
<reinhard> so the user would have no time to edit it before his database would be created
<aries_mindworks> reinhard: you should suggest to start the setup-cvs.py as root or with a given mysql's root username/passwd
<aries_mindworks> reinhard:  to setup a default db
<reinhard> and what if I want postgres?
<reinhard> or oracle?
<reinhard> or sqlite?
<aries_mindworks> reinhard: you should set the default driver... if/then/else :]
<reinhard> I think most of the other develpers here would beat me to death if I would make setup-cvs.py create a database :)
<aries_mindworks> reinhard: why?
<aries_mindworks> reinhard: you can ask the user whether the scripts should create the db
<reinhard> I honestly don't think that we want to support a fully automated svn install
<reinhard> SVN is for developers
<reinhard> and we have distributions to support fully automated installs
<reinhard> but that relates to what I've said before
<reinhard> I don't think we shoul point users that just want to try gnue to svn
<aries_mindworks> reinhard: it takes just a few lines of code and some minutes
<reinhard> right
<reinhard> well maybe
<reinhard> you understimate the effort to guess a working connections.conf
<reinhard> you would need to ask username, password, host, backend
<aries_mindworks> reinhard: ok, it's not a big missing :] but, the documentation is, the beginers as i'm needs the docs :)
<reinhard> right
<reinhard> what I don't get at times that people tell us that our docks suck and then don't even read those docs that we have :)
<reinhard> While the developer install script substitutes the steps given in the file
<reinhard> "INSTALL", you still have to follow the steps given in doc/configuration.txt
<reinhard> from README.cvs
<aries_mindworks> a reference is enough. now, each project (gnue-forms, gnue-appserver) has a different documentation, but i think you should mix them into one book, because they depends on them. if you want to do a basic type erp, you need report, form and appserver in every case
<reinhard> not sure how that could be put more clearly
<reinhard> aries_mindworks: > 50% of forms users don't use appserver
<reinhard> AFAICT
<reinhard> plus to use forms in 2-tier you have to set your focus on slightly different issues than for 3-tier
<reinhard> our credo always was gnue tools should play together but still be usable separately
<reinhard> and (not sure if you were implying that) I am not sure if a documentation how to download an svn version should go into the big "gnue user's guide"
<aries_mindworks> reinhard: ok, i don't se clearly the differents. you should point more times on the differencies, because the users don't know always exact view to the problem, but more and more examples help them to see what type of functions they should use
<aries_mindworks> big gnue user's guide is a good thing :)
<aries_mindworks> you should take care about the docs, i know, every developers are regret about the time because they can code some nice in that time
<aries_mindworks> i have to go
<aries_mindworks> bye!
*** aries_mindworks has left #gnuenterprise
*** wendall911 has quit IRC
*** sjc has joined #gnuenterprise
*** wendall911 has joined #gnuenterprise
*** someon has joined #gnuenterprise
<someon> Thought  re: the whole automatic DB setup stuff...  if we have a working Curses interface, could we not fire off a gnue-forms -u curses connections.gfd to get the connections file correct, and then set up the DB from that?
* someon thinks dogfood
<someon> alternatively if DISPLAY is set then use gtk2 or wx...
<someon> That would allow a person setting up (even from packages) a rather user-friendly way of picking their DB, username, back-end, etc.
*** johannesV has quit IRC
*** someon has quit IRC
*** btami has joined #gnuenterprise
<SachaS> night all
*** wendall911 has quit IRC
*** mnemoc_ has joined #gnuenterprise
*** mnemoc has quit IRC
*** btami has quit IRC
*** tiredbones has quit IRC
*** titopbs has quit IRC
*** tiredbones has joined #gnuenterprise
*** jamest has left #gnuenterprise
<reinhard> good night all
*** reinhard has quit IRC
*** dimas has quit IRC
*** kilo_ has quit IRC
*** sjc has quit IRC
*** dimas has joined #gnuenterprise
*** titopbs has joined #gnuenterprise