"AccWhizz is based on CK-Ledger code written by Chiu Kay Wu. Without His great job and inspiration I would not be able to write AccWhizz. CK-Ledger is, in turn, based on SQL-Ledger (by Dieter Simader) functionality. " luvly rofl I have an idea let's fork AccWhizz and do something else! then we can have a big family tree! Off to bed. g'night all! jbailey (~jbailey@CPE0060082df811.cpe.net.cable.rogers.com) left irc: "Client Exiting" jcater: i just moved gnue-sb from nongnu to gnu for website i.e. checked out gnu version cp files localy on my machine commited to gnu gnue-sb so likely they should show up if they do you can kill old repository lol i don't think you'd need to do that Action: ajmitch cringes as jcater rm -rf's the whole web tree ;) hey why not others have fun too ;) ok freshmeat updated with all releases i had to add navigator i guess i never released it at 0.0.1 ah piss they are approving them already shouldnt they be in bed grrr i had hoped they would post at like 4am my time er, why? :) err, why not? :) um biggest audience is US 4am my time is 6am EST with a little luck they would stick on the front page till about 12 my time i.e. most of the US audience would see them during morning or lunch break its sad but freshmeat is a HUGE imprint on days we run releases at freshmeat our web traffic jumps WAY up that's when jamest turns the AC on for the webserver :) it never needed AC it was in KS fixe (~adam@dsl093-081-253.chi2.dsl.speakeasy.net) joined #gnuenterprise. hi fixe Action: dneighbo is away: slumbering fixe (~adam@dsl093-081-253.chi2.dsl.speakeasy.net) left irc: Read error: 110 (Connection timed out) jcater (~jcater@cpe-066-061-083-220.midsouth.rr.com) left irc: "nite" stay away from cvs head it should still work but jcater has commited the start of changes for 0.5.0 fun! I will be branching 0.4.1 tomorrow to apply some patches and will be releasing 0.4.2 of at least forms later in the week ok i'll try & do patches against the branch if i have time to fix bugs :) cool ok, gotta run psu (psu@manorcon.demon.co.uk) joined #gnuenterprise. reinhard (~reinhard@M693P020.adsl.highway.telekom.at) joined #gnuenterprise. whew nite jamest (~jamest@adsl-64-216-107-182.dsl.tpkaks.swbell.net) left irc: "[x]chat" gah just realised that the php script for posting news to website strips out
  • Action: psu was trying to make it reasonably secure & strip most html but I'm not aware of any exploits related to the
  • tag... SachaS (~Sacha@ark.cs.curtin.edu.au) joined #gnuenterprise. btami (~tamas@ip102-205.ktv.tiszanet.hu) joined #gnuenterprise. good morning psu: may i e-mail a new setup.exe to you if i'm ready ? btami: please can you do so in half an hour (i.e. after 9 am your time) I can then get it uploaded tonight ok, i will try are we doing both debug-on and debug-off versions again? i think debug-on for pre enough then 0.4.1 will be -on and -off btami: note that the 0.4.1 are officially released now oh you might like to get the new zips and work off those ok jcater put them out last night while we were sleeping "gnue - your 24/7 project" I have just (as of 2 minutes ago) updated website news so i can send debug-on and debug-off versions yes is it ok after 10 too ? no problem I won't be able to do anything with them this morning anyway as I'm off to work in 15 mins and on dial-up, they'll take more than 15 mins to download your mail ;-) The official announcement says "Windows .exes later this week" so tonight will be fine s/will be/will have to be do you know another way to upload somewhere, some public place ? it will be 2x10 Mb actually, if you e-mail jcater/jamest rather than me a) they should be on a better connection than me b) they can probably upload before I am back from work anyway Action: psu isn;t trying to avoid work, just take himself as a barrier out of the loop which is the best, jcater or jamest ? jamest seems to wake up first ;-) and jcater had a late night getting the releases out so I guess jamest cc to me as a back-up ok, i will sent to jamest@gnue.org cc ok psu (psu@manorcon.demon.co.uk) left #gnuenterprise ("work time"). SachaS (~Sacha@ark.cs.curtin.edu.au) left irc: Remote closed the connection fixe (~adam@dsl093-081-253.chi2.dsl.speakeasy.net) joined #gnuenterprise. duff13 (~chatzilla@vdsl-130-13-86-105.phnx.uswest.net) joined #gnuenterprise. duff13 (~chatzilla@vdsl-130-13-86-105.phnx.uswest.net) left irc: "ChatZilla 0.8.10 [Mozilla rv:1.2a/20020910]" SachaS (~Sacha@dialup-196-248.wasp.net.au) joined #gnuenterprise. fixe (~adam@dsl093-081-253.chi2.dsl.speakeasy.net) left irc: Read error: 110 (Connection timed out) SachaS (~Sacha@dialup-196-248.wasp.net.au) left irc: Read error: 110 (Connection timed out) ariel_ (~ariel@ppp-217-133-240-160.dialup.tiscali.it) joined #gnuenterprise. fixe (~adam@dsl093-081-253.chi2.dsl.speakeasy.net) joined #gnuenterprise. fixe (~adam@dsl093-081-253.chi2.dsl.speakeasy.net) left irc: Read error: 110 (Connection timed out) ariel_ (~ariel@ppp-217-133-240-160.dialup.tiscali.it) got netsplit. gnuebot (~eggdrop@65.101.4.211) got netsplit. Isomer (dahoose@port-219-88-247-206.jet.net.nz) got netsplit. gnuebot (~eggdrop@65.101.4.211) returned to #gnuenterprise. ariel_ (~ariel@ppp-217-133-240-160.dialup.tiscali.it) returned to #gnuenterprise. Isomer (dahoose@port-219-88-247-206.jet.net.nz) returned to #gnuenterprise. #gnuenterprise: mode change '+o gnuebot' by calvino.freenode.net ariel_ (~ariel@ppp-217-133-240-160.dialup.tiscali.it) got netsplit. Isomer (dahoose@port-219-88-247-206.jet.net.nz) got netsplit. gnuebot (~eggdrop@65.101.4.211) got netsplit. gnuebot (~eggdrop@65.101.4.211) returned to #gnuenterprise. ariel_ (~ariel@ppp-217-133-240-160.dialup.tiscali.it) returned to #gnuenterprise. Isomer (dahoose@port-219-88-247-206.jet.net.nz) returned to #gnuenterprise. #gnuenterprise: mode change '+o gnuebot' by calvino.freenode.net ariel_ (~ariel@ppp-217-133-240-160.dialup.tiscali.it) got netsplit. Isomer (dahoose@port-219-88-247-206.jet.net.nz) got netsplit. gnuebot (~eggdrop@65.101.4.211) got netsplit. gnuebot (~eggdrop@65.101.4.211) returned to #gnuenterprise. ariel_ (~ariel@ppp-217-133-240-160.dialup.tiscali.it) returned to #gnuenterprise. Isomer (dahoose@port-219-88-247-206.jet.net.nz) returned to #gnuenterprise. #gnuenterprise: mode change '+o gnuebot' by calvino.freenode.net ariel_ (~ariel@ppp-217-133-240-160.dialup.tiscali.it) got netsplit. Isomer (dahoose@port-219-88-247-206.jet.net.nz) got netsplit. gnuebot (~eggdrop@65.101.4.211) got netsplit. gnuebot (~eggdrop@65.101.4.211) returned to #gnuenterprise. ariel_ (~ariel@ppp-217-133-240-160.dialup.tiscali.it) returned to #gnuenterprise. Isomer (dahoose@port-219-88-247-206.jet.net.nz) returned to #gnuenterprise. #gnuenterprise: mode change '+o gnuebot' by calvino.freenode.net btami (~tamas@ip102-205.ktv.tiszanet.hu) left irc: fixe (~adam@dsl093-081-253.chi2.dsl.speakeasy.net) joined #gnuenterprise. SachaS (~Sacha@dialup-196-212.wasp.net.au) joined #gnuenterprise. ariel_ (~ariel@ppp-217-133-240-160.dialup.tiscali.it) left irc: "Uscita dal client" ariel_ (~ariel@ppp-217-133-240-160.dialup.tiscali.it) joined #gnuenterprise. johannes (~johannes@M701P023.adsl.highway.telekom.at) joined #gnuenterprise. jamest (~jamest@leibniz.math.ksu.edu) joined #gnuenterprise. johannes (~johannes@M701P023.adsl.highway.telekom.at) got netsplit. Isomer (dahoose@port-219-88-247-206.jet.net.nz) got netsplit. gnuebot (~eggdrop@65.101.4.211) got netsplit. gnuebot (~eggdrop@65.101.4.211) returned to #gnuenterprise. johannes (~johannes@M701P023.adsl.highway.telekom.at) returned to #gnuenterprise. Isomer (dahoose@port-219-88-247-206.jet.net.nz) returned to #gnuenterprise. #gnuenterprise: mode change '+o gnuebot' by calvino.freenode.net dsmith (firewall-u@cherry7.comerica.com) joined #gnuenterprise. btami (~tamas@ip102-205.ktv.tiszanet.hu) joined #gnuenterprise. hi all jamest: have you got win32 packages ? i have not jamest@gnue.org just about 20 Mb :) you'll have to split them up as I think the mta will not accept any single mail over 10mb is size ok, i will try again ooooo and if you send them to jamest@gnuenterprise.org you'll skip 1 forwarding jamest told me something about scp, but i'v never tried it before s/jamest/jcater delivering mail... 84% 87% 90% 99% sent but it is about 13Mb :( setup debug-on setup debug-off is another debug-off sent KeithJagrs (jorgre@63.74.24.9) joined #gnuenterprise. hello! have to go, bye btami (~tamas@ip102-205.ktv.tiszanet.hu) left irc: KeithJagrs (jorgre@63.74.24.9) left irc: "later" Arturas (~arturas@fmgs-03.vtu.lt) joined #gnuenterprise. Hello jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. ariel_ (~ariel@ppp-217-133-240-160.dialup.tiscali.it) left irc: "Uscita dal client" hello all hello Arturas Arturas (~arturas@fmgs-03.vtu.lt) left irc: Read error: 60 (Operation timed out) Nick change: reinhard -> rm-dinner oh DoctorHook (~DoctorHoo@mail.faam.net) joined #gnuenterprise. Good Morning! I have a quick question for anyone who has a moment... I'm desparately trying to break my M$ habit and one of the biggest obstacles is trying to find a replacement for MS Access. I just discovered your project a few moments ago and at first glance it appears to be what I've been looking for? ok ColeMarcus (~klebermas@p5080499B.dip.t-dialin.net) joined #gnuenterprise. Sorry, that was a question. I have built custom apps in Access/VBA that I would like to move to a Linux environment. Would this be a similar tool? DoctorHook: we are not an access replacement, per se but could definitely be a substitute we are comparable to the Forms and Reports parts of access (only with a lot more power, imho) we don't have a database, so you'd use PostgreSQL, for example, as the database backend (or SAP-DB, ....) I see! What about the programming part? I'm NOT a programmer... but I can stumble around with VB or VBA to get done what I need... I'm trying to learn... we use Python for any triggers/events... it's a VERY newbie-friendly language it would be a small step from VBA to Python drochaid (~drochaid@pc2-kirk1-3-cust16.renf.cable.ntl.com) joined #gnuenterprise. Beautiful! I have looked at Python. It is very frustrating to move from an environment where I'm more than competent to a brand new one. There is so much to learn and sometimes don't know where to start! It's overwhelming, but you've been agreat help! Thanks! DoctorHook (~DoctorHoo@mail.faam.net) left irc: "Client Exiting" piss i missed him jcater/jamest always someone coming from msaccess suggest that pgadmin has a MIGRATION tool that will migrate all tables + data for them which is a huge part of the work if they have not done anything too 'fancy' code wise (standard vb forms) designer will putty in their hands especially with wizards Action: dneighbo has half considered writing a vb forms (and delphi forms) conversion tool ah jamest: can we get logging re facilitated on ash jcater: the biggest thing we are missing (and so is pgadmin) is a 'query designer' i think eventually it would be nice to have that in designer(schema tools) if you all add the quick table view stuff (what someone was calling grid view) the 'query designer' would be about only thing we are missing to be close to access replacement (imho) and unfortunately i have seen a LOT of access ;) jcater: it worked : http://www.gnu.org/software/gnue-sb/ though the dates are dorked :) anyone know how to upgrade to gnome 2? and if you do can you still use gnome 1.4 apps? Action: dneighbo was so impressed with kde fonts/smoothness i would like to see gnome2 dneighbo: you can still use gnome-1.4 apps with gnome-2. it's pretty nice, esp from a developer perspective -- gtk2 fixes a good number of b0rkennesses in gtk not all of course :) but a good number nonetheless you know what is necessary for debian? i think i have all the libgtk2 stuff as i got it when i got gphoto2 Action: dneighbo is mostly looking for cleaner fonts if you're on unstable, you will automagically get the gnome2 stuff iirc with a debian upgrade re: kde fonts not sure about what to do on stable Arturas (~arturas@fmgs-03.vtu.lt) joined #gnuenterprise. wife liked kde 'fonts' but nothing else about it :) asked to have gnome back yeah i just did upgrade on unstable we will see what it brings Action: drochaid prefers KDE to Gnome but not enough to actually care which I use dneighbo: one of my fave things about gtk2 is that things like GtkLabels now accept attribute markup on their strings. so you can do something like Hello, World! i use fluxbox so its not a 'me' issue its a 'wife' issue ;) dneighbo: what's the odds of getting that demo schema soon? (the music database) you want today? Action: dneighbo can probably pump it out today today would work :) my wife is a dedicated mac-o-phile unfortunately. i'm hoping I can drive her towards linux using macosx :) ESPECIALLY if the schema wizard works in designer as i think i already have the tables created dneighbo: i didn't know logging was down on ash Arturas: you here? Nick change: rm-dinner -> reinhard dneighbo (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) left irc: Read error: 54 (Connection reset by peer) ra3vat: yes, hi Dmitry hello Arturas can you look into common/doc/technotes/00002.txt i was thinking that encoding param in gnue.conf is only relevant for postgresql so it understand specific pgsql names encoding is the client encoding and can be either : SQL_ASCII, EUC_JP, EUC_CN, EUC_KR, EUC_TW, UNICODE, MULE_INTERNAL, LATINX (X=1...9), KOI8, WIN, ALT, SJIS, BIG5, WIN1250. Available encoding depends on your PostgreSQL and libpq version. Refer to PostgreSQL manual for supported encodings for your PostgreSQL. ra3vat: give me please about 5 mins... sure Action: jcater thinks that belongs in connections.conf if its specific to postgres actually I thought it was already there? yes "encoding" name is confusing jcater: it was done in ancient time when connection.conf was not yet born :) ra3vat: you mean #hack for db encoding in 00002.txt? wow, justt saw the release on freshmeat neat dneighbo (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) joined #gnuenterprise. Arturas: yes, and the whole paragraph is not clear, some encoding names are mentioned there that are not relevant and would not work i agreed with jcater about moving that db encoding to connections.conf ok, i agree with it too - (i would like to believe there was some reason why i did put it here, but i don't remember :\) - i'll do it in a few days jamest i think logging works i just think that 'reporting on logging' is down johannes (~johannes@M701P023.adsl.highway.telekom.at) left irc: "Client Exiting" dneighbo: logging? ra3vat: that 's a typo ? he means 'reporting on flogging' he's not sure who to beat next based upon what people in IRC promise to attempt to accomplish roflmao found out they are killing my dish soon :( and making it commericial so price will continue to climb over next year or two and that sprint is working on using pcs network to offer broadband instead w/ radioshack as the hardware provider and it looks like it will be available soon so looks like i might have to switch to cox siesel (jan@xdsl-213-196-193-165.netcologne.de) joined #gnuenterprise. Mr_You (~car@gso167-138-145.triad.rr.com) left irc: Read error: 110 (Connection timed out) hi yo dneighbo: how is it going? is 93KB/sec decent downstream? quite decent :) the maximum I got up to now was 80KB/sec did you change the DSL provider? Action: dneighbo is forgetting whats what i had big and little k im thinking thats like 700k+ ? ah much better i think my modem is all fixed 1,286 Kbps is reported download wow. that means, downloading gnue's new setup.exe [10MB] takes 77 secs. siesel (jan@xdsl-213-196-193-165.netcologne.de) left irc: "Eject! Eject! Eject!" siesel (jan@xdsl-213-196-193-165.netcologne.de) joined #gnuenterprise. dneighbo: what about that modified_by fields? any decitions? ra3vat: i havent fully looked into it my understanding is that (at least with postgres i could do it directly from db) either via oncommit trigger or via backend db stsuff i BELIEVE i cna get username from gnue as well though from what i gather it will be an 'ugly' call so there was talk of 'convience' triggers to support it StyXman (~mdione@ADSL-200-59-86-17.cordoba.sinectis.com.ar) joined #gnuenterprise. hi all jcater: what would be that 'kstructural changes'that you tal about in (one of) your last commit? evil doings :) StyXman: talking about my butt i would say its seperation of logic and layout specifically what i gathered its moving block out from data er block ouut ah? we REALLY need to merge our trees (i had hoped you would have merged for 0.4.1 release) but if you guys dont hop on it in next day or two it will likely be really BAD dneighbo: I can send the big patch *now* i.e. the guts will change significantly and merging will be near impossible well you would need to coordinate with jcater/jamest yes, I know. it's my job are they around? siesel: my modem seems to be picking up speed 1,375 Kbps StyXman: they might be ghhh probably just coming back from lunch or shsould be back shortly I'm gone shortly :( StyXman: the sad thing is that number is with still about 18% packet loss ;) ok, I'll see what can I do. dneighbo: you mean siesel ? derek (~laurie@cpe-24-221-112-50.az.sprintbbd.net) joined #gnuenterprise. bye Arturas (~arturas@fmgs-03.vtu.lt) left irc: StyXman: does it have to be one huge patch? lupo (~lupo@pD9E68864.dip.t-dialin.net) joined #gnuenterprise. hiho jamest: hi derek: are you alive/awake? yes, I have the big one. I can (try to) separate it in functional patches im awake alive is questionable *g* lupo: you always grab me when im getting ready to do sosmething har har im cutting off on thiss machine to dial into work but i will be here as derek just incase you try to /msg for anything yep that's what i want org stuff ok give me 2 minutes to login to work and start a process and you will have my full attention :) Derek, we've got to talk! :-) cool, new forms devel guide gotta check this out dneighbo (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) left irc: "Client Exiting" every gnue cvs checkout is like christmas: new nice things that you always wanted to have lupo: im still here reinhard: are you here? StyXman: if it's one big one please send to jamest@gnuenterprise.org Action: derek looks... hmm jamest@gnuenterprise has an imap rule to forward to /dev/null if to: == styxman@vialibre.org most interesting no way i swore I had to set to fwd to jcater Action: jamest better fix that dude that's a problem KeithJagrs (trilluser@63.74.24.9) joined #gnuenterprise. I think we'd create an infinite mail loop derek: try not to kid with that. it's my job, and if it's not done, I get my head cut off hello jamest: ko, I'll send it soon mailing list for Small Business isn't seem to be working at least the archives DISCLAIMER: some features added are maybe deprecated. those you think are ugly, pleasse feel fre to discuss them either in your mailing list or in ousr. StyXman: we're gonna need that patch *soon* as we need to make progress on our stuff jcater: gimme 5 minutes. how is mysql sql is produced from schema when only base, oracle and postgresql exist in processors? is there any locale support for date time entries? ra3vat: it isnt : ) what is gnue sb? derek: how it is done in gnue-sb then? small business currently gnue-sb only supports postgres until the gsd tool is fixed to support the other databases good thing as soon as the tool renders gsd's for a db that db should be supported by gnue-sb aha nobody told me about that! :) Action: derek will warn if you are wanting to use gnue-sb w/ mysql you are asking for a world of hurt lupo: it was kept for christmas :) ra3vat: :) mysql is not a kwality kode database for this type of application if your restraint is gpl only database please consider sap-db mysql with more than 1:1 and 1:n relationships is a PITA or with more than 5-10 small tables can someone tell me how to do sequences in mysql? or an equivalent? and the first person who says "auto_incremenet" better be wearing a helment helmet as I can't seem to get at the next value reliably Action: lupo better shuts up that was a serious question, btw I've googled and googled and googled and can't find the answer ColeMarcus (~klebermas@p5080499B.dip.t-dialin.net) left irc: Read error: 54 (Connection reset by peer) jcater: i'd bet a dounut you'll have to grop to seed tables drop even derek: what about to remove MySQL dir (it is empty really) from there? README could be placed in PgSQL dir though ra3vat: i will look into when i disconnect form work i need to setup a dcl instance for GNUe SB real soon now (tm) if I can get an answer to my question, I can add mysql support :) jamest: that's gonna be interesting mysql uses autoincrement Action: derek is donning a BIG ole helmet seems like sqlite would replace what a lot of people use mysql for. Action: jcater thinks sqlite might prove to be really important to gnue-sb Action: derek shudders postgres should be fine anyone who uses mysql for like Action: derek notes my personal goal for gnuesb is not to be quickbooks grib (~grib@grib.customer.jump.net) left irc: "I'm too lame to make a quit message" a local database that they never access over a network and only has one person using it or even local database backing a single host website if someone wants that i will point them to gnucash small business project seems silly viva sqlite! if someone is willing to do local filesystem for a db then gnue-sb is bigger than them (imho) Action: derek isnt opposed to getting sqllite working, but states strongly that is not the target market for gnue-sb of course not StyXman: you send that yet? but I bet we still see the single business owner strolling in wanting something for his PC yes I just think mysql is overused for the wrong things. i agree Action: jcater isn't saying we code for that target but I'm just saying I bet we see it sqlite is simpler to manage than mysql in most circumstances that use mysql. Its so annoying to see a cool thing that uses a databes backing for only one host that uses mysql! nickr: right jamest: just dpoing thast *now* thats why gnue rules, database neutrality :) lol I just think mysql is overused for the wrong things. thats why gnue rules, database neutrality btw jamest: sent does/will gnue-sb handle european tax stuff ie tax on sales gack! 143K lupo: right now this is my big pain true that's a lot of diff reading :) im torn whether to make gnue-sb US only or support foreign stuff the problem i have with making it 'anywhere' there are minor code fixes, and several new features is you lose a TON of validation rules US business love (wow, mail is fast) and speed features like if US only i can make it so you enter a zipcode and it auto populates city and state i can validate phone numbers against states i.e. is that a valid area code for a state etc etc as soon as i make it i18n i end up with very sloppy validation and very general data entry jamest: I'm leaving. just read the mail, and I'll be crossing fingers :) Action: derek realizes there is a huge foreign market and doesnt want to discount that bye all i see this is the dilemma so im torn StyXman (~mdione@ADSL-200-59-86-17.cordoba.sinectis.com.ar) left irc: "yes!" if lots of non us people are willing to help and use do either one or the other, just do it right likely i will make it i18n if not then i will likely make US centric as thats my target market i think having a market at all is better than fulfilling thousand problematic and inconsistent wishes if the resources aren't sufficient, we can still fork currently i just don't have an enterprise customer who wants to make a switch :( so i don't have big ERP reality touch :-(( okay, gotta go bye lupo (~lupo@pD9E68864.dip.t-dialin.net) left irc: "using sirc version 2.211+KSIRC/1.1" did debs make it to unstable? Action: derek would love to test them out psu (psu@manorcon.demon.co.uk) joined #gnuenterprise. derek: debs for woody are in our repositiry on ash i can't think of any reason they wouldn't work on unstable i don't think jbailey's had time to upload sid's yet inputmask="d/m/y" formatmask="d/m/y" displaymask="d/m/y" is that work? how can you tell if you are running gnome2 or gnome1.4 hi all has anyone got btami's 0.4.1 win32 exes? psu: go fish Action: psu was trying to get him to e-mail them to someone other than me as, for e-mail purposes, I am still a dial-up luser Action: derek wonders if 'go fish' is an american only game Action: psu knocks Action: psu lays down three Mr. Bunn the Baker and four Mrs. WIck the candlestick maker's wife psu: he said he mailed them to me but I never got them at 13MB an email I bet an mta somewhere aborted them jamest: ack derek: is the mailing list for small business functional? KeithJagrs: dont know I havent get to read anything in the archives havent tried to send anything to it I see the commit list is broked hmm pipermail has a well-know bug - archives don't get created until 1st "real" post later today i can try to send an email to it that would be good I'd like to contribute someway I just haven't decided how As long as it's not too high traffic, we should prob. include in KC KeithJagrs: hundred dollar bills? hehe do you accept Monopoly bills? hey the new Monopoly set for the UK this Christmas is City of Sunderland heh what a coincidence the top square (£££££400 pounds) is the Stadium of Light (soccer stadium) ? heh hello people & others Must be like the new wembley KeithJagrs: except it's actually been built, whereas Wembley is still on the drawing board yeah ;) Action: psu is away: downstairs derek (~laurie@cpe-24-221-112-50.az.sprintbbd.net) left irc: Remote closed the connection downstairs? : the broadband modem ;) dneighbo (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) joined #gnuenterprise. whew boy nautilus2 is wicked horrid dneighbo: ? Is that good or bad? bad very bad takes almost 20 minutes to get ti to stop spawinging processes Eeewww Any debian fans here remember back to the old buzz release? if so, this one's for you: http://news.bbc.co.uk/1/hi/england/2488421.stm KeithJagrs (trilluser@63.74.24.9) left irc: "later" debian? what's that? some weirdo hippy cult i think dneighbo (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) left irc: Read error: 104 (Connection reset by peer) ajmitch: thanks damn hippies anyway ;) dneighbo (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) joined #gnuenterprise. hello dneighbo hey gnome2 sucks wind or at least nautilus2 does what is caption attribute for page? grib (~grib@grib.customer.jump.net) joined #gnuenterprise. dneighbo (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) left irc: "Client Exiting" ra3vat: for notebook pages, that can be the notebook tab caption/label if missing, and you have a notebook page, caption defaults to the name value thanks, that is right what i need what does transparentBlock attribute mean? If you are on the last field of a block and there is another block in the form then if transparentBlock is true a tab will take you to the next block if false it will take you to the first field of the same block if false how can i jump to the next block? as a user? or within a trigger? user == Page Down trigger, I think you can do a form.setFocus(otherBlock) there may also be a form.nextBlock() thanks I don't recall about the latter though but there should be if not restrictInsert="Y" - is it correct attibute definition? looks good jamest (~jamest@leibniz.math.ksu.edu) left #gnuenterprise. reinhard (~reinhard@M693P020.adsl.highway.telekom.at) left irc: "Anything is good and useful if it's made of chocolate" derek (~laurie@cpe-24-221-112-50.az.sprintbbd.net) joined #gnuenterprise. jcater: did you had a look on my second email about mapping formats? siesel: briefly I was preoccupied with a release :) so haven't had time to digest have you time to comment now? masterlink="company.id" is it possible syntax? not really :( Action: jcater is in the middle of a thinking project at work ra3vat: I think that will work is the master datasource a multiple table one? i'm about to try that ok. /me don't want to distract the AI. siesel: sorry, but we've had some issues with our sales force jamest (~jamest@adsl-64-216-107-182.dsl.tpkaks.swbell.net) joined #gnuenterprise. Action: siesel hands over some donuts to jcater ( in the hope that helps the thinking project be done soon :) jcater: no problem. jcater: sales force not keeping up the steady donut supply? freax (~freax@D5E047AD.kabel.telenet.be) joined #gnuenterprise. siesel: i have comments on it just havent been able to formulate them been too busy im having trouble deciding implementation you are right that splits and such should be easy but im not sure they shoudl be implemented as you speak or as triggers Action: derek envisioned htem as triggers and nothing would prevent the integrator UI from doing all the work to me the tag set you propose seems confusing (and i do lots of integration) i have seen the corresponding 'trigger' way to do things it might be even more confusing but as i learned from my xslt ventures doing complex things in xml SUCKS so a simple split is probably much cleaner in XML as would be a simple mapping however when things get complex the spec would probably be a nightmare i can certainly run through scenarios i see daily and that i saw daily integrating with every known mortgage lending interface on the planet as well as edi for now i have to run i will be able to cmment further in about an hour hmmm, I'm not very contend with the whole stuff myself ok, cu then. I would like something more mapping orientated then process orientated :( freax (~freax@D5E047AD.kabel.telenet.be) left #gnuenterprise ("Client Exiting"). how to set scrollbar over myltirow entry? jamest: ? ? our code doesn't support scrollbar's yet papo guys seem to have it as part of their patch if time permits I'll be going into the 0.4.1 banch and then into head theres no way to express in SQL the kind of uniqueness that says 'the combination of these two columns must be unique' is there? you mean only pull those rows? No like a constraint like a primary key which must be unique but instead, this row is uniquified by two columns instead of just one sure isn't it just "unique (field1, field2)" you can create a unique index on 2 fields jamest: it seemed to me you did some work on scrollbar already? or setup the primary key constraint at the end of the table def instead of behind one field ra3vat: i added the code it display it but never tied it into the event system ok is it that simple, really? qjust adding unique (field1, field2) to the create table? nah, we're lying to you :) which DB? nickr: one note, unique does not enforce nullness like primary key does so if you want "unique and not null" you need to specify not null for those columns at least, irrc iirc sqlite of course it says it supports unique constraints shite, what happened to gless!? my more then one year old example with three tables mixed in mastter-detail still does not work :( properly that is now, this unique constraint will only be triggered if both the values are the same as another row's two values, right? not just one or the other nickr: right I use those a lot example, we sell magazines so we have a table that holds our offers it contains the magazine id and the number of issues we have unique () set up on those 2 naughty_flag coolean; grrr boolean so only one combination of (magazine, issues) can exist in that table Action: jcater thinks that's the functionality you are talking about there can be plenty of 12 issue magazines and plenty of offers for People magazine but only one offer for People at 12 issues y6ea exactly I have a table that defines a specific relationship between two rows in two other tables and only one such relationship between those two particular rows must exist ah works as expected. How do I print an exception that just thew me into an except: ? traceback module IIRC hang on er? thheres no exception object that gets assigned or something? yeah or except: print "Unexpected error:", sys.exc_info()[0] raise master="dtsCompany" masterlink="id" detaillink="employee.org_id" prequery=""> what's wrong with that? ah thantks ra3vat: what exception are you getting? oooooo I don't know how prequery="" behaves with child datasources definitely i would not prequery a chiled er child child is empty ra3vat: for one, get rid of prequery then run with --debug-level and see what "select" statements are being executed and if they look sane am i asking about something terrible or just not yet implemented? it should work but we are giving you suggestions to find out why its not ok :), the query looks good will run it through psql now query is ok SELECT pers_id,person.id,employee.id,employee.org_id,employee.pers_id,person.first,person.last FROM employee, person WHERE (((((employee.org_id = '26'))) AND ((employee.pers_id = person.id)))) why is it nothing shown? thomasr (~thomas@public2-seve3-4-cust146.walt.broadband.ntl.com) joined #gnuenterprise. after that query one other is in log: DB005: [DBdriver:553] SELECT id FROM person WHERE (((id = '31'))) DB005: [DBdriver:142] Field names set to ['id'] master="dtsCompany" masterlink="id" detaillink="employee.org_id" prequery=""> is this some new syntax? table="employee, person" basically im not sure why you are doing this derek: that's an oddity that just works :) it wasn't actually coded to do that why not do a view of those tables but it serves as an SQL join (readonly of course) i.e. join them as a view then use the view derek: it is very close to work without view, query is ok. i've pasted it via psql and it worked heh just got btami's win exes I'll u/l them in the morning unless anyone else beats me to it Action: psu is deadbeat psu (psu@manorcon.demon.co.uk) left #gnuenterprise ("up the wooden hill to bedfordshire..."). derek: do you want to discuss the gnue mapping description format now? soon im still cranking at work was doing some 'research' on lost files dsmith (firewall-u@cherry7.comerica.com) left irc: "later.." ok siesel i have some time well if you come back i shoudl be here ping the thing that struck me was the mapping comment vs process i can tell you from my experience RARELY can you just 'map' 64 bytes from 127.0.0.1: icmp_seq=0 ttl=64 time=0.1 ms usually there is some form of conversion process in the middle firstname lastname in one db bcomes siesel: thanks, wasn't sure my dsl was up name in the other or fund org in one table bcomes acctingstring in another etc etc etc i dont have access to my email with what you sent so i cant speak directly to those items Action: derek i guess is most curious how you are going to do integrator, rpc, jsforms and phpforms all at once I don't want to do it at once, but I just need integrator for some stuff NOW. ah the next step would be appserver and then I can continue on jsforms/phpforms but back to integrator: with the "mapping<->process" comment I just meant that a "user" would like to define mappings instead of a process Action: derek is worried that appserver is seen as prequisite for jsforms/phpforms siesel: again i state im torn between implmentation and UI hopefully a user never sees the 'definition' file they see a UI to build mappings and those mappings need to be powerful i should be able to say src1.fielda -> src2.fielda src1.fieldb -> src2.fieldb src1.fieldc -> src2.fieldc as well as src1.fielda -> src2.fielda src1.fieldb + src1.fieldc -> src2.fieldb as well as example only here jsut to convey point ignore syntax I would like to write all these definitions in XML, instead of in a trigger. left(src1.fieldb,3) + '-' + mid(src1.fieldb,4,5) + ' : ' + lower(src1.fieldc) -> src2.fieldb you are sadistic you lose SO much power by moving that into xml we wrote jadeke basically gnue forms in php that was all xml and it was murder xslt was my example to do easy transformations xml/xslt seems like such a good idea we can do it by trigger too, but then designer has to parse the python commands but start doing complex stuff and you are spending all your time fighting xmll siesel: i think the answer is a combination of the two some things will make well as xml elements to map otehrs will not the last example of yours, f.e. shouldn't be possible with xml i dont think i could provide a list of what would and what wouldnt right away the first and second examples i gave probably could be all xml but the third one would make for some ugly xml and lot of complex tags/attributes my point in essensce is that i do this stuff almost daily and rarely do i get something like 1 or 2 what about that action syntax I've proposed: i generally am dealing with #3 i dont have access to the email to review it http://mail.gnu.org/pipermail/gnue-dev/2002-November/000322.html Action: jcater thinks an xml mapping approach quickly degenerates into a lot of clutter outside of 1:1 or other *very* combines err, *very* simple which, I already said that in my email that is my fear and what i guess i was trying to relay in that sample 1 and sample 2 (both simple) it would likely be ok i.e., we end up with docbook :) but sample 3 would be an utter hell of tags and attributes mdean (~mdean@mkc-65-28-72-76.kc.rr.com) left irc: Read error: 113 (No route to host) something so complex no one understands even how to do simple stuff s/complex/overwhelming Action: siesel sees the biggest problem in making trigger a MUST, that we have to parse python scripts to edit mappings with designer for me i would need to see the trigger side to tell you which i would prefer if in.test[0]=="$": out.out=in.test[1:] else: out.out=in.test could be an example how to do remove a leading "$" with a trigger i would be ok with some of this in xml if the designer is writing it all out my only demand is i can go to triggers and get dirty if i have to IMHO integerator should support that mergemask, splitmask stuff and nothing more. nothing more in XML. thomasr (~thomas@public2-seve3-4-cust146.walt.broadband.ntl.com) left irc: "Leaving" this is different than your email, no? I don't recall the mask thing in the email In the second mail: http://mail.gnu.org/pipermail/gnue-dev/2002-November/000331.html at the end, I speak of masks to do spliting merging etc. ok, I missed that part I've changed the syntax a bit, but haven't posted yet. I wasn't giving the second email my full attention as I was at work Now, I would remove all etc, and just have an I think I like the idea of a merge/split mask, and anything more complex would be handled by a trigger should we make the splitmask capable of handling regular expressions? that could be powerful, but might not be intuitive for regular users (not sure) you mean something like: Possibly putting actions in the trigger name space is a bit too much hmmm I'm not sure I like the syntax but the overall idea I think may be ok bbias.... Action: siesel couldn't remember how trigger definitions looked in forms ;) well, triggers contain or point to python code not to another xml structure perhaps ? or something like that? yes, that sound much better. if i go away its cause i tried to use nautilus again ok, another point is how to handle "rowmappings" I mean, in normal case rows are mapped 1:1 but I have a table with the fields "id, field, value" with three different possible entrys in "field" hi all like (45,"name","Jan") (45,"zip","...") (45,"sdsd","...") that all should become one row in a table with the fields (id, name, zip, sdsd) could anyone provide a pdf for common/doc/Developers-Guide.sxw? hi Ajmitch ra3vat: have you looked at http://www.gnuenterprise.org/~jcater/docs/common/ ? oh looking yeah, the developers guides are rather useful :) gah! the developer's guide for common came out all centered yep including the code it likes to do that ajmitch: do you really speak maori? lol jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: "home" siesel: nope siesel: only know a few words :) can you teach me any cool maori word? nope :) bbs derek (~laurie@cpe-24-221-112-50.az.sprintbbd.net) left irc: "Client Exiting" http://www.hackernetwork.com/flash/stickdeath9.shtml jcater (~jcater@cpe-066-061-083-220.midsouth.rr.com) joined #gnuenterprise. SachaS (~Sacha@dialup-196-212.wasp.net.au) left irc: Read error: 60 (Operation timed out) mdean (~mdean@mkc-65-28-72-76.kc.rr.com) joined #gnuenterprise. chillywilly (danielb@mke-24-167-202-50.wi.rr.com) joined #gnuenterprise. I hate electricians they are fucking hacks dsmith (~dsmith@p49.n-chpop06.stsn.com) joined #gnuenterprise. HACK derek (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) joined #gnuenterprise. jbailey (~jbailey@CPE0060082df811.cpe.net.cable.rogers.com) joined #gnuenterprise. siesel (jan@xdsl-213-196-193-165.netcologne.de) left irc: "night all" sup jbailey is new gnue in sid? No - Maybe tommorow or the day after. Hmm.. Actually might take longer, since I'll be switching the arch: from any to all. That'll need a change to the overrides file - so it'll be whenever the ftpmasters get around to it. jbailey: i hope to have a 0.4.2 out later in the week or early next yeah no pressure or anything to address some issues and include some of the Papo stuff Cool. That will solve the versioning problem nicely, then. yeah figured you'd like that Are the versions in CVS now going to be lexically sane? hey i ahvent done much shell scripting someone willing to provide quick syntax for something that basically goes from directory ran in and executes a program in every subdirectory i.e. if you were in /foo/ it would scan /foo/ for directories and then execute a program on that directory find . -type d -exec (cd '{}' && FOO) \; should do the trick. FAiling that: is FOO the program? for x in `find . -type d` do cd $x && FOO done Yup! You need the cd VAR && FOO so that when it exits, you're left in the original directory ooo, and after 0.4.2, I think I'll have 0.5.0 sometime this decade I had to show someone how to use ed for scripting today. It was quite scary when I realised I knew how. =) jbailey: what if i dont need to go into the directory i assume find . -type d -exec myprogram wouuld work well let me rephrase taht mabye your second program is what i want for x in er for x in `find . -type d` do myprog -d $x done that should work nicely i think we're shooting for this decade? Yup. The find case is faster, though. so find . -type d -exec myprog -d '{}' \; ok silly question since that was so painless any way to make that recursive easily? so that it will spider down a tree structure What does that mean? if i had . ./foo/ ./foo/bar ./foo/bar/bar It already does that. =) yummy Just type find . -type d Action: derek loves unix when there are good unix peopel around and we love you when there's other unix ppl around Well, if you'd ever care to pay me a rediculous some of money for being a unix admin somewhere, let me know. =) Action: jcater ducks rofl i like that one jcater well unfortunately most linux people are not unix people thats why this channel is good linux demeanor, unix knowledge now if we only had M$ money we'd be set what would you do with 40 billion, really i wouuld say that would buy tennessee, but its a big money state because of recording industry Tell you what, you give me half as a down payment, and I'll draft a plan for the rest. surely it could buy kansas get some new socks yeah new underwear jcater: really? why? these superman ones from jr high are getting holey these still fit and they stop fitting 4 yrs ago It's just not computing if you're not computing in the nude. jamest: last year this time you would have said, "buy a space heater, cause the guys around here said it woudl have to snow in hell before i got one, and i figured non meltable snow would be expensive" I agree, but wife says "Honey, please put some clothes on... we don't want to see that" paqan (~paqan@202.155.120.221) left irc: Read error: 110 (Connection timed out) jcater: i thought you were going to say you were tired of hanging the laundry out to dry on it ;) s/tired of/tired of her it == that Action: derek hopes jamest isnt still wearing snow gear while sitting in his office dsmith (~dsmith@p49.n-chpop06.stsn.com) left irc: "later.." :) Mr_You (~car@gso167-138-145.triad.rr.com) joined #gnuenterprise. rehi fixe (~adam@dsl093-081-253.chi2.dsl.speakeasy.net) left irc: Read error: 110 (Connection timed out) fixe (~adam@dsl093-081-253.chi2.dsl.speakeasy.net) joined #gnuenterprise. jamest (~jamest@adsl-64-216-107-182.dsl.tpkaks.swbell.net) left #gnuenterprise. paqan (~paqan@202.155.120.221) joined #gnuenterprise. C8ha6d (~chadh@adsl-63-193-168-250.dsl.mtry01.pacbell.net) joined #gnuenterprise. C8ha6d (~chadh@adsl-63-193-168-250.dsl.mtry01.pacbell.net) left #gnuenterprise ("Client Exiting"). congrats on the release guys :) chillywilly: thanks from all the guys :) :) I just got Barbicane to plug the new GNUe release on WOPN now ALL 29 listeners know about it! wooo! yay! paqan (~paqan@202.155.120.221) got netsplit. Isomer (dahoose@port-219-88-247-206.jet.net.nz) got netsplit. gnuebot (~eggdrop@65.101.4.211) got netsplit. jcater (~jcater@cpe-066-061-083-220.midsouth.rr.com) left irc: jcater (~jcater@cpe-066-061-083-220.midsouth.rr.com) joined #gnuenterprise. oops alt-F4'd wrong window there's a split that just occurred too drochaid (~drochaid@pc2-kirk1-3-cust16.renf.cable.ntl.com) left irc: "Client Exiting" gnuebot (~eggdrop@65.101.4.211) returned to #gnuenterprise. paqan (~paqan@202.155.120.221) returned to #gnuenterprise. Isomer (dahoose@port-219-88-247-206.jet.net.nz) returned to #gnuenterprise. #gnuenterprise: mode change '+o gnuebot' by calvino.freenode.net hi gnuebot you rock ah, release new stuff to play with I can't believe I am arguing against Java in #wopn-live neither can i, java rocks ugh jbailey (~jbailey@CPE0060082df811.cpe.net.cable.rogers.com) left #gnuenterprise ("Client Exiting"). paqan (~paqan@202.155.120.221) left irc: "Client Exiting" paqan (~paqan@202.155.120.221) joined #gnuenterprise. paqan (~paqan@202.155.120.221) left irc: Read error: 104 (Connection reset by peer) paqan (~paqan@202.155.120.221) joined #gnuenterprise. fixe (~adam@dsl093-081-253.chi2.dsl.speakeasy.net) left irc: Read error: 110 (Connection timed out) --- Tue Nov 19 2002