*** neilt has joined #gnuenterprise good night *** SachaS has quit IRC *** neilt has quit IRC *** jcater has quit IRC *** mnemoc has quit IRC *** derek has left #gnuenterprise *** mnemoc has joined #gnuenterprise *** reinhard has joined #gnuenterprise *** sjc has joined #gnuenterprise *** btami has joined #gnuenterprise *** kilo has joined #gnuenterprise good morning moin kilo can anyone fix dbf support for me? :( please hi mnemoc hi btami what is the pb? DB000: InvalidFormatError: Not a valid DBF file: Invalid field count acording to 'dbf --view-info' it is: Number of records.....: 597 (00000255d) Length of header......: 6434 (1922d) Record length.........: 868 (0364d) Columns in file.......: 200 Rows in file..........: 597 do you want the file? no :) :( maybe you can comment out this validation thanks for the idea :) i'm a bit sleepy :) 6:17am here :\ uh line #161 and #162 in gnue-common/src/utils/dbf.py if not self.fields or len (self.fields) > 128: 128?? i really do have 200 fields here i promise yep my .dbf is making big troubles to gnue-common/src/utils/dbf.py it can't even detect fieldlen properly :'( uhm.... .oO mnemoc: if you have a win box, you can try with adodbapi driver what 'if foo.strip():' means? is that valid? it means foo has no space content how can i see if it _only_ contain spaces? foo.strip() is false if it contains only spaces, imho aha last dumb question, why if i have a 'datetime' which prints like: '1904-04-02' i get: DB000: if badDate.year() < 2000: DB000: TypeError: 'int' object is not callable the '()' :\ it's hard to get used to python :( year is not a function but an attribute of a datetime object try without "()" yes :) without () it worked *** yure_ has joined #gnuenterprise *** johannesV has joined #gnuenterprise palim palim hi mnemoc you still have troubles with dbf.py ? please not that the xbase standard defines a maximum of 128 fields :) what files are these you're using ? paradox ? or Foxpro but if it helps i can remove that restriction of 128 fields ... maybe you can send me a sample of your dbf file to tweak our driver johannesV: just trying to update my gnue sample database for reports here tamas:~/svn/gnue/gnue-reports/samples/foobulations$ ./setup-db-cvs.sh Meg kívánja változtatni a 'gnue' adatbázist [i,N]: i Séma frissítése ... Adatok frissítése ... DB000: Traceback (most recent call last): DB000: File "/home/tamas/svn/gnue/gnue-common/scripts/gnue-schema", line 33, in ? DB000: gsdClient ().run () DB000: File "/home/tamas/svn/gnue/.cvsdevelbase/gnue/common/datasources/readgsd.py", line 187, in run DB000: self.__importData () DB000: File "/home/tamas/svn/gnue/.cvsdevelbase/gnue/common/datasources/readgsd.py", line 381, in __importData DB000: needCommit |= self.__importTable (table, tdata, fishhooks.get (name)) DB000: File "/home/tamas/svn/gnue/.cvsdevelbase/gnue/common/datasources/readgsd.py", line 408, in __importTable DB000: record [fname] = self.__getValue (value, fields [fname]) DB000: File "/home/tamas/svn/gnue/.cvsdevelbase/gnue/common/datasources/readgsd.py", line 648, in __getValue DB000: raise InvalidDateError, contents.strip () DB000: InvalidDateError: '04/01/02' is not a vaild date, use 'YYYY-MM-DD' (ISO) btami, dates, times and timestamps in gsd has to be in iso-format (as it was long before) seems this .gsd needs update yep, ok ah, well that might be a really old gsd then i'm not sure if that gsd was updated to reflect all changes from xslt up to gnue-schema bbl *** btami has quit IRC *** johannesV has quit IRC *** kilo has quit IRC *** holycow has quit IRC *** rui has joined #gnuenterprise *** btami has joined #gnuenterprise *** jcater has joined #gnuenterprise *** rui has quit IRC *** jcater has quit IRC *** docelic has joined #gnuenterprise *** kilo has joined #gnuenterprise *** kilo has left #gnuenterprise *** kilo has joined #gnuenterprise DB000: File "/opt/gnue/trunk/.cvsdevelbase/gnue/common/datasources/drivers/DBSIG2/Connection.py", line 129, in _makeparam DB000: flsecs = int (("%s" % (second - int (second))) [2:]) DB000: ValueError: invalid literal for int(): 60826873779e-05 how did i got into DBSIG2 using appserver and dbf?? uh good question err of course at appserver side for the backend reinhard: http://pastebin.ca/16871 my backend is postgresql yep, that's DBSIG2 based oh gimme a sec or 200 :) :) please try again (after svn up) i will, but it worked on the second try anyway :p i'll empty the table ok here we go hi lalalal hi chillywilly *** docelic has quit IRC reinhard: worked on the first pass :) what was it? johannes is currently working on datetime issues trying to make all drivers behave as reasonable as possible for fractional seconds plus maybe a rounding error when transferring the datetime values datetime to mx.datetime autoconversion would be nice creating some e-05 microseconds happy independence day to all lamericans ;) happy windependence day! I gotta go cool some burgers cook* lol just wondere that you eat your burgers cold ;-) wondered err I can't type any better than you, chillywilly :) chillywilly: on colombia it _is_ holyday *** ajmitch has quit IRC *** ajmitch has joined #gnuenterprise *** dimas has quit IRC *** dimas has joined #gnuenterprise *** havoc has quit IRC *** btami has quit IRC *** havoc has joined #gnuenterprise *** ajmitch has quit IRC *** kilo has quit IRC good night *** reinhard has quit IRC *** sjc has quit IRC *** jcater has joined #gnuenterprise *** holycow has joined #gnuenterprise *** ajmitch has joined #gnuenterprise *** holycow has quit IRC *** chillywilly has quit IRC *** chillywilly has joined #gnuenterprise *** jcater has quit IRC