*** kilo has joined #gnuenterprise
*** Amorphous has joined #gnuenterprise
*** johannesV has joined #gnuenterprise
*** bigbrother has joined #gnuenterprise
*** bigbrother has joined #gnuenterprise
*** reinhard has joined #gnuenterprise
<johannesV> reinhard, fixed that cursor-positioning for win32 driver (at least for single-line edits)
<johannesV> hm, there's another problem with the newlines in multiline edits ...
<johannesV> since a newline is two characters here (\r\n),  and not one
<johannesV> this introduces a difference between GF-position and UI-position
*** btami has joined #gnuenterprise
*** johannesV_ has joined #gnuenterprise
<johannesV_> btami, how is that with using jpg images in win32 forms-driver ?
<johannesV_> is that depending on the PIL installed on the machine
<johannesV_> or is it depending on gnue-form's win32 driver ?
<johannesV_> reinhard has installed gnue-runtime-environment*.exe and jpg images are not working
<johannesV_> i'm using the svn-version on my xp notebook (for testing only) and it works fine
<johannesV_> (but i've installed everything separately, like PIL)
*** johannesV has quit IRC
*** dimas has quit IRC
<btami> johannesV_: it seems something missing from runtime*.exe
<btami> will look into
*** dcmwai has quit IRC
<btami> btw. we using old sqlite python module supporting sqlite 2.x
<btami> don't want we to swich to pysqlite2 (supporting sqlite 3.x) ?
<btami> i have to say i'v never used sqlite
<reinhard> not sure if they were installable in parallel
<reinhard> if not, i'd vote for pysqlite2, as sqlite 3.x is way better than sqlite 2.x
<johannesV_> they are
<johannesV_> i'll add a sqlite3 driver today
<johannesV_> :)
*** dcmwai has joined #gnuenterprise
*** yure has joined #gnuenterprise
*** lekma has joined #gnuenterprise
<lekma> hi all
<btami> hi lekma
<reinhard> hi lekma
<reinhard> off to lunch
*** dcmwai has quit IRC
*** lekma has quit IRC
*** erkki_ has joined #gnuenterprise
<johannesV_> reinhard, there's a bug in Base.ResultSet.py
<johannesV_> Traceback (most recent call last):
<johannesV_>    File "/home/johannes/prj/gnue/.cvsdevelbase/gnue/forms/uidrivers/gtk2/MenuBar.py", line 120, in _menuHandler
<johannesV_>     self.driver.dispatchEvent (event, _form = self.form)
<johannesV_>    File "/home/johannes/prj/gnue/.cvsdevelbase/gnue/common/events/EventController.py", line 107, in dispatchEvent
<johannesV_>     handler(event)
<johannesV_>    File "/home/johannes/prj/gnue/.cvsdevelbase/gnue/forms/GFInstance.py", line 1184, in executeCommit
<johannesV_>     message = event._form.commit ()
<johannesV_>    File "/home/johannes/prj/gnue/.cvsdevelbase/gnue/forms/GFForm.py", line 669, in commit
<johannesV_>     block.processCommit ()
<johannesV_>    File "/home/johannes/prj/gnue/.cvsdevelbase/gnue/forms/GFObjects/GFBlock.py", line 538, in processCommit
<johannesV_>     self._dataSourceLink.postAll ()
<johannesV_>    File "/home/johannes/prj/gnue/.cvsdevelbase/gnue/common/datasources/GDataSource.py", line 623, in postAll
<johannesV_>     self._currentResultSet.post ()
<johannesV_>    File "/home/johannes/prj/gnue/.cvsdevelbase/gnue/common/datasources/drivers/Base/ResultSet.py", line 682, in post
<johannesV_>     if index <= currentRecord:
<johannesV_>  NameError: global name 'index' is not defined
<reinhard> thanks, fixed
<johannesV_> thanks
*** jamest has joined #gnuenterprise
*** dimas has joined #gnuenterprise
*** kilo has left #gnuenterprise
<erkki_> could someone explain triggerRunReport(self, reportFile, parameters={}, **parms) to me.. is form.runReport('../reports/salesOrders.grd',{},destinationType='file',destination='asd') the right way to call that method
<erkki_> Traceback (most recent call last):
<erkki_>    File "<unknown_executioncontext>", line 21, in __main______gnue_forms_GFObjects_GFLayout_GFLayout_instance_at_0xb62e884c____Page1_btnGenerate_ON_ACTION_btnGenerateTrigger
<erkki_>  TypeError: __call__() got an unexpected keyword argument 'destination'
<erkki_> is what i get
<btami> erkki_: you get this with current svn ?
<erkki_> no, with latest release
<erkki_> is it available only on current svn?
<erkki_> as that was one of my thoughts:p
<btami> hmm
<btami> seems it's ok in current svn
*** kilo has joined #gnuenterprise
<btami> reinhard: how about releasing ?
<reinhard> I will do a release before I leave for holiday in any case
<reinhard> (which is at latest next Tuesday)
<erkki_> "holiday" -- what's that?
<btami> reinhard: ok, thx
<reinhard> actually I need new win packages for a customer, too
<reinhard> btami: is your latest commit to fix JPG display in win32 ui?
<btami> yep
<reinhard> great!
<erkki_> I could contribute gentoo ebuilds, once I have the time to beautify them
<reinhard> this is one of the things I need for that customer :-)
<reinhard> he was close to beating me up when i told him he has to convert all his pictures to bmp ;-)
<btami> :))
<btami> btw. you can put by hand that missing JpegImagePlugin.py file from Pil source into bin/library.zip file
<btami> or beter .pyc
<btami> s/beter/better
<btami> but new releases will definitely need new runtime*.exe, koz the current doesn't contain textwrap.py too
<btami> (used by new dialog stuff)
*** holycow has joined #gnuenterprise
<btami> reinhard: hey, just noticed you have a _customer_ using gnue ???
<reinhard> kinda
<reinhard> for a week now
<btami> cool
<reinhard> in test phase
<reinhard> *very* little project
<reinhard> 2 users, 3 tables
<reinhard> 1 form
*** rradek has joined #gnuenterprise
<rradek> Hello
<btami> hi rradek
<rradek> I had a problem with gnue-appserver complaining about non-existant plugin (xmlrpc); it was caused by gnue.common.apps.plugin.__modules()'s lack of support for optimized *.py[co] files.
<rradek> Who do I send patch to?
*** kilo has quit IRC
<reinhard> rradek: gnue-dev@gnu.org
<reinhard> and thanks in advance :)
<johannesV_> ooops: ValueError: year=1847 is before 1900; the datetime strftime() methods require year >= 1900
<johannesV_> we do really need input masks ...
<btami> who cares with 1847 ? :)
<rradek> reinhard: sent. Hope I don't have to be subscribed.
<btami> input mask ?
<btami> you mean jamest ?
<btami> :)
<johannesV_> :)
<reinhard> jamest? I somewhat remember that name.... but can't remember from where ...
<reinhard> ;-)
<johannesV_> ok, we do now support SQLite 3
<johannesV_> have fun :)
*** jcater has joined #gnuenterprise
*** mnemoc has joined #gnuenterprise
<johannesV_> ahh, looks like i've broken win32-driver today ...
<johannesV_> will fix it right now
<jamest> sigh
<jamest> i expect to start input masks real soon now
<jamest> the numeric formatting is wack
<jamest> but base text formatting (for things like phone numbers) is ready now in common
<jamest> we finished our move into the new building a few weeks back and I'm bringing up the new gnue based timeclocks and our gnue based warehouse stuff
<jamest> and the users are about to kill me for lack of input masks :)
<jamest> our vendor payments system is also gnue based and came on line after the move
<jamest> what better time to roll out 3 new systems than as part of the move :)
<johannesV_> ok, win32 driver fixed
* johannesV_ phu ...
<johannesV_> btw sqlite3 works fine on win32 too
<jamest> before input masks i have to fix the db error in a trigger being silently swallowed by forms
<jamest> as that is killing me
<johannesV_> :(
<johannesV_> bbl
<reinhard> jamest: just in case
<reinhard> johannesV_ reported a case where he *thinks* a record was deleted due to a bug somewhere in common
<reinhard> related to some changes that i did this week
<jamest> i'm running common from about 2 weeks ago
<jamest> sigh
<reinhard> so I would recommend not to update svn in production systems till we have tracked that down
<reinhard> 2 weeks ago should be ok
<jamest> actually make that 4 weeks ago
<jamest> pre-move
<jamest> so probably 6/14
<reinhard> that should also be ok :)
<jamest> i just as of yesterday got all gnue based user apps running with that code base
<jamest> and needed to start migrating my server batch job programs as they still use the pre-reinhardized datasources
<reinhard> lol
<reinhard> nice word ;-)
<reinhard> btw we are not sure there is this delete bug at all
<reinhard> as it's quite unlogical that it should be there, and it was a single, unreprocible case
<johannesV_> right as it was only in sqlite driver before adding _rowidField_ ...
<jamest> well, my goal is to get all the new systems up, then spend a month or so on cleanup and features like input masks
<jamest> cleanup == internal app cleanup
<johannesV_> so maybe it has something to do with that huge update ... where all-fields-in-the-query thing
<jamest> before I start the next round of big changes here
<rradek> If [appserver] section in /etc/gnue/gnue.conf contains allowed_hosts=localhost, gnue-appserver doesn't accept connections (rpctype=xmlrpc).  If run with -Z, spits " EnhancedRequestHandler instance has no attribute 'command'"...
<johannesV_> (which is actually gone now)
<jamest> so i won't be touching gnue svn head for at least one more week
<jamest> which means you're good till
<jamest> um
<jamest> november
<rradek> Uh, mistake: it actually accepts connections, but disconnects immediately, returning HTTP 403.
<reinhard> rradek: hmm - haven't used allowed_hosts so far
<reinhard> rradek: thanks for your patch; how do you get .pyc in the directory without having the .py there?
<reinhard> you just install pyc without py?
<reinhard> is that possible?
<rradek> http://cvs.pld-linux.org/SPECS/gnue-common.spec
<rradek> I just remove *.py.;
<rradek> Don't ask me why, I'm not the python guy...
<rradek> I didn't make this policy. :/
<reinhard> ok, I think I'll apply the patch
<reinhard> might make sense wrt space saving
<rradek> But it makes debugging a PITA.
<mnemoc> johannesV_: hi, the other trouble i had with dbf were null dates, 8 spaces.
<reinhard> rradek: yes, indeed
<johannesV_> mnemoc, can you please send me a sample-file ?
<reinhard> rradek: must make the change a bit differently, or we will have the modules listed multiple times if .py *and* .pyc is there
<johannesV_> btw. have you checked out latest svn version ?
<johannesV_> i did a change, where a field of only spaces get's translated into None automatically
<johannesV_> (no matter whether it's a date)
<mnemoc> johannesV_: aha... i'll revert my hack then and try again
<johannesV_> ok, great. If you encounter further troubles, please send me a copy of the dbf so i can work on a fix (since i can create dbf's only with open office)
<johannesV_> well, but now i'm really gone for about an hour ...
<johannesV_> :)
<mnemoc> :)
<mnemoc> cu
<reinhard> rradek: I made a change based on your patch to solve the problem
<reinhard> thanks again for pointing it out
<rradek> Thanks for fixing the fix ;-)
<rradek> Bug in gnue-setupdb: if database already exists, it's a fatal error.  (I'd put it in the BTS, but it looks kind of dead, you know ;-)
<rradek> Feature request: non-interactive mode for gnue-setupdb (so it could be called in RPM scripts), and ability to specify dbname and username on the command line.
<reinhard> rradek: not sure if that is a bug - when you ask to create a db and it exists, that *should* be fatal IMHO
<rradek> I ask to setup it (create tables).
<reinhard> you can give dbname, username and password in connections.conf or as parameters to gnue-schema
<reinhard> if you look at gnue-setupdb, you will see it's basically a one-liner shell script
<reinhard> so you can fulfill your wishes by calling gnue-schema manually :)
<rradek> Yup. Thanks, that should do.
<rradek> I grepped the code for a while, but failed to find a way of specifying username in connections.conf... Only -u worked for me.
<mnemoc> that's what i do on T2
<reinhard> username = foo
<rradek> Nope, doesn't work.
<reinhard> last release?
<reinhard> with last release username query is only disabled if you give username *and* password in connections.conf
<rradek> gnue-appserver-0.4.1 gnue-common-0.5.14
<rradek> I've supplied only the username.
<mnemoc> reinhard: when will you release again?
<rradek> reinhard: with dummy password works indeed.  I'm connecting over localhost and using "trust" in pg_hba.conf, so password is not really needed...
<rradek> What is gsscvs, and where do I find it?  Referenced in gnue-invoice/scripts/setup-db.sh...
<rradek> Ah, it's gnue-schema.
<reinhard> mnemoc: I plan to release about a week ago
<reinhard> but I'm not sure anymore whether I will be able to stick to that plan
<reinhard> ;-)
<mnemoc> :)
<reinhard> in any case I will release at least a beta version not later than next tuesday
<reinhard> as I will leave for 2 weeks holiday then
<reinhard> off for dinner now for real
*** holycow has quit IRC
<jcater> that is perfect
<jcater> as I'll be migrating ash around the 18th
*** jamest has quit IRC
<rradek> For my successors, who will interrogate search engines about gcdcvs and gcd2sql -- this script is now called gnue-readgcd.
<mnemoc> no
<mnemoc> one is from release, another from svn
<rradek> Well, gnue-appserver-0.4.1/ChangeLog says "Renamed gnue-gcd2sql to gnue-readgcd".
<rradek> Not that it would work for me... Any ideas what is this about?
<rradek> ~/rpm/gnue-invoice/scripts $ ./setup-db.sh
<rradek> + gnue-readgcd --connection=invoice /home/users/radek/rpm/gnue-packages/base/location/loc.gcd [...]
<rradek> [...]
<rradek> Updating class repository ...
<rradek> [...]
<rradek> DB000:  InstanceNotFoundError: Instance '11d9ef025c81643cb52900485464775d' of class 'gnue_module' not found
*** sjc has joined #gnuenterprise
<reinhard> rradek: seems like it depends on another gcd
*** jamest has joined #gnuenterprise
<rradek> reinhard: any hints about debugging it?  I tried with all *.gcd, specified in setup-db.sh: base/location/loc.gcd base/org/org.gcd base/item/item.gcd sales/sales.gcd finance/tax/tax.gcd supply-chain/billing/billing.gcd
<reinhard> IIRC gnue-invoice depends on gnue-packages somehow
<reinhard> but not sure
<reinhard> btami?
<rradek> Yes, all these *.gcd come from -packages.
<rradek> Appears that the set of *.gcd from packages/scripts/setup-packages.sh contains the missing dependency.
<btami> yep, gnue-invoice depends on gnue-packages
<rradek> About packages/setup-packages.sh: ../supply-chain/inventory/inventory.gcd is now called invent.gcd.
<rradek> (I meant packages/scripts/setup-packages.sh.)
<btami> rradek: have you changed GNUEDIR in gnue-invoice/scripts/setup-db.sh to yours ?
<btami> theinventory stuff is under development by kilo (not finished)
<rradek> Removed it completely.
<rradek> OK, now it says: $ gnue-schema --connection=gnue ../schema/invoice-en.gsd
<rradek> MissingKeyError: Data row of table 'ITEM_ItemType' has no key fields
<rradek> (after heavy cutting, of course.)  The table item_itemtype is empty, as well as item_item.
<btami> rradek: are you using svn or packages ?
<rradek> gnue-common and gnue-appserver: packages, gnue-invoice and gnue-packages from svn.
<btami> may i ask you to try with all svn ?
<btami> i'v just run setup-db.sh today without pb
<rradek> Tsk. Sure, but I wanted to pack it all into nice RPMS.
<btami> it would be cool, if we have official rpms
<btami> i'v tried to package common to rpm before
<btami> but i know nearly 0 about rpm :)
<rradek> It would be cool, if all this stuff was easy to package for every distro...
<btami> anyhow, 'setup.py build' has rpm support
<rradek> Yes, but it's not what I want. If you want to make official RPMS, you can use a variant of this: http://cvs.pld-linux.org/SPECS/gnue-common.spec (and the same for appserver, designer, navigator, forms, reports).
<rradek> Anyway. Packaging the files is not a problem, setting up the database is the PITA.
<btami> don't think so
<btami> tamas@beus:~/svn/gnue-contrib/gnue-invoice/scripts$ LANG=C; ./setup-db.sh
<btami> You are about to create the new database 'invoice-backend'. Continue [y,N]: y
<btami> ************************************************************
<btami> Logon for SYSDBA into Security Database
<btami>   Password:
<btami> You are about to change the database 'invoice-backend'. Continue [y,N]: y
<btami> Updating schema ...
<btami> Updating data ...
<btami>   updating table 'GNUE_MODULE' ...
<btami>     Rows: 1 inserted, 0 updated, 0 unchanged.
<btami>   updating table 'GNUE_CLASS' ...
<btami>     Rows: 7 inserted, 0 updated, 0 unchanged.
<btami>   updating table 'GNUE_PROPERTY' ...
<btami>     Rows: 49 inserted, 0 updated, 0 unchanged.
<btami>   updating table 'GNUE_PROCEDURE' ...
<btami>     Rows: 1 inserted, 0 updated, 0 unchanged.
<btami>   updating table 'GNUE_PARAMETER' ...
<btami>     Rows: 4 inserted, 0 updated, 0 unchanged.
<btami> Loading gcd files ...
<btami> Updating schema ...
<btami> Updating class repository ...
<btami>   Modules   :   6 inserted,   0 updated,   0 unchanged.
<btami>   Classes   :  14 inserted,   0 updated,   0 unchanged.
<btami>   Properties: 153 inserted,   0 updated,   0 unchanged.
<btami>   Procedures:  28 inserted,   0 updated,   0 unchanged.
<btami>   Parameters:  10 inserted,   0 updated,   0 unchanged.
<btami> You are about to change the database 'invoice-backend'. Continue [y,N]: y
<btami> Updating schema ...
<btami> Updating data ...
<btami>   updating table 'ITEM_ITEMTYPE' ...
<btami>     Rows: 2 inserted, 0 updated, 0 unchanged.
<btami>   updating table 'BILLING_PAYMENTMETHOD' ...
<btami>     Rows: 3 inserted, 0 updated, 0 unchanged.
<btami>   updating table 'TAX_VAT' ...
<btami>     Rows: 3 inserted, 0 updated, 0 unchanged.
<btami>   updating table 'LOC_STREET' ...
<btami>     Rows: 3 inserted, 0 updated, 0 unchanged.
<btami>   updating table 'BILLING_COMPANY' ...
<btami>     Rows: 1 inserted, 0 updated, 0 unchanged.
<btami>   updating table 'ITEM_UNITTYPE' ...
<btami>     Rows: 7 inserted, 0 updated, 0 unchanged.
<btami>   updating table 'LOC_COUNTRY' ...
<btami>     Rows: 3 inserted, 0 updated, 0 unchanged.
<btami>   updating table 'ITEM_ITEM' ...
<btami>     Rows: 6 inserted, 0 updated, 0 unchanged.
<btami>   updating table 'LOC_REGION' ...
<btami>     Rows: 4 inserted, 0 updated, 0 unchanged.
<btami>   updating table 'LOC_ZIP' ...
<btami>     Rows: 8 inserted,
<btami> oops, sorry :)
<btami> just wanted to show how easy it
<btami> only 3 y
<btami> :)
<rradek> Not with the released packages.
<reinhard> rradek, btami: probably packaging end user apps should use modulepath rather than readgcd scripts
<btami> true
<btami> this is why all gnue-contrib are _not_ officiall packages :)
<rradek> It doesn't help the development, does it? ;-)
<btami> rradek: python setup.py --help bdist_rpm
<rradek> I've seen that.  But it doesn't create exactly the RPMS I want.
<btami> :(
<rradek> I want to control the list of files, add translations of summary/description, control dependencies, add optimizations depending on architecture, etc.
*** johannesV_ has quit IRC
<btami> i see
*** johannesV_ has joined #gnuenterprise
<johannesV_> rradek, the problem is a bit tricky: the gsd markup has changed a lot in current svn
<johannesV_> so if you're using gnue-schema from the packages this will use the old-style (depreciated gsd-markup)
<johannesV_> that's why you cannot process the (already updated) gsd-files from packages right now
<johannesV_> unless you'll take gnue-common from svn as well
<johannesV_> because btami is using svn for all parts it's working for him ...
<johannesV_> just don't mix up svn and packages since they're very far away from each other atm
<rradek> I'll try with the next release.  Right now I'm trying to put the svn version to work.
<rradek> I've just got a nice. really big. slow. wxgtk error message. :->  ERROR:  column "billing_totalnet" does not exist
<johannesV_> you're using appserver, don't you  ?
<rradek> Nope.
<rradek> Do I have to?
<mnemoc> reinhard: i'm writing and xsl to convert a .foo, using references to .gcd files, into a .gfd. when it works i'll try to use .gld for labels. how do you think i should name a simplified forms format for classes? .foo is not the best extension :)
<rradek> It was awfully slow when I tried it...
<johannesV_> i think the packages (gnue-invoice) is made for appserver ... but please ask btami or kilo for that ..
<johannesV_> mnemoc, appserver is already able to generate gfd-files based upon the gld (gnue language definition)
<rradek> johannesV_: I'll try appserver then...
<johannesV_> which includes generating dropdowns for reference props and the like (see search- and info-props)
<mnemoc> johannesV_: they are too simple to be used
<johannesV_> what are you missing, maybe we can improve them
<mnemoc> blocks, master/detail, ...
<rradek> johannesV_: Ha, works.  Thanks.
<johannesV_> rradek, great
<johannesV_> what do you mean with blocks ?
<johannesV_> how should master/detail look like ?
<mnemoc> by blocks i mean to do good use of the space
<mnemoc> i need to put 6 classes on the say curses display
<johannesV_> ok, so you'd like to put more than one class onto the same form at a time
<mnemoc> that's what i mean with 'only simple forms are generated by appserver'
<mnemoc> .gfd has lot of redundant data if you used .gcd
<johannesV_> ok, i see ... well i think appserver shouldn't generate such mixed forms ...
<johannesV_> at least not at the moment ...
<johannesV_> what about master/detail ?
<mnemoc> if i change master, details classes are refreshed :)
<mnemoc> i think it wont be hard, using xsl, to generate those .gfd
<mnemoc> i don't want appserver to generate them on the fly
<mnemoc> i'm fine with sharing the files
<mnemoc> but it's unnecesary pain to write them by hand
<mnemoc> considering .gcd are very simplified comparing to shcemas
<johannesV_> yeah
<johannesV_> right
*** wendall911 has joined #gnuenterprise
<reinhard> i agree that gfd has lots of redundant info
<reinhard> and is not a very hand writing friendly format
<reinhard> i'm not sure whether the best approach to this problem is to define a friendler format and convert
<mnemoc> a friendler format only valid for classes
* johannesV_ feeding the baby
<mnemoc> having pos and search on each gld is also redundant
<mnemoc> that belongs to a form file
<reinhard> bbl
*** reinhard has quit IRC
<johannesV_> have to run
<johannesV_> cu
*** johannesV_ has quit IRC
<rradek> I don't know if it makes sense, but an idea: wouldn't some kind of dependency tracking between *.gcd, *.gsd and *.gfd be useful?  Each file has a version number (substituted by svn), and a set of <requires> for the minimal versions of files it needs.
*** rradek has quit IRC
*** jcater_ has joined #gnuenterprise
*** jcater has quit IRC
*** jamest has left #gnuenterprise
*** jcater has joined #gnuenterprise
*** jcater_ has quit IRC
*** btami has quit IRC
*** wendall911 has quit IRC
*** jcater has quit IRC
*** sjc has quit IRC
*** jcater has joined #gnuenterprise
*** jamest has joined #gnuenterprise
*** holycow has joined #gnuenterprise
*** jcater has quit IRC
*** jcater has joined #gnuenterprise
*** jamest has quit IRC
*** jcater has quit IRC
*** holycow has quit IRC
*** holycow has joined #gnuenterprise
*** jcater has joined #gnuenterprise
*** jcater has quit IRC