hum.. someone help me with the grd .... did anyone have any experiences on writting them? damn I'm alone again.. :( derek: want to know something who know most about the gnue-report and the grd files? I've much problem on the grd design. Action: dcmwai is away ... Away from keyboard... Action: dcmwai is away: I'm busy nickr (nick@e-64-35-146-235.empnet.net) got netsplit. LuftHans (~lufthans@wsip-68-107-221-207.ph.ph.cox.net) got netsplit. SachaS (~sacha@online.havanawave.com) got netsplit. dtm (~dtm@r1.txwifi.com) got netsplit. nickr (nick@e-64-35-146-235.empnet.net) returned to #gnuenterprise. dtm (~dtm@r1.txwifi.com) returned to #gnuenterprise. SachaS (~sacha@online.havanawave.com) returned to #gnuenterprise. LuftHans (~lufthans@wsip-68-107-221-207.ph.ph.cox.net) returned to #gnuenterprise. jamest (~jamest@adsl-64-216-107-96.dsl.tpkaks.swbell.net) left irc: "Client exiting" dimas (~dimas@195.218.177.46) joined #gnuenterprise. reinhard (~reinhard@M1264P004.adsl.highway.telekom.at) joined #gnuenterprise. dcmwai_ (~dcmwai@219.95.159.33) joined #gnuenterprise. btami (~tamas@ip102-205.ktv.tiszanet.hu) joined #gnuenterprise. dcmwai (~dcmwai@219.95.152.227) left irc: Read error: 60 (Operation timed out) thierry (~thierry@musashi.xtensive.com) joined #gnuenterprise. morning gnuers hi thierry hello btami " I love the Orwellian Work Product known as MSFT. Every time somebody say they won't exclusively use Windows, MSFT says, "You Have To! If you don't you're Anti-Choice!"" -- slashdot md-bb2200CET (mdupont@p5080ECA1.dip0.t-ipconnect.de) left irc: Read error: 60 (Operation timed out) if anyone saw siesel... Please do tell me.. I'm looking for him .. :) md-bb2200CET (mdupont@p5080E491.dip0.t-ipconnect.de) joined #gnuenterprise. hi dcmwai_ mcuria-away (~user@29-185-89-200.fibertel.com.ar) left irc: Read error: 104 (Connection reset by peer) dimas (~dimas@195.218.177.46) left irc: Read error: 110 (Connection timed out) mcuria-away (~user@29-185-89-200.fibertel.com.ar) joined #gnuenterprise. Nick change: mcuria-away -> mcuria Nick change: mcuria -> mcuria-away SachaS: Hello :) have to run :( Nick change: SachaS -> SachaAway dimas (~dimas@195.218.177.46) joined #gnuenterprise. Nick change: md-bb2200CET -> mdupont SynrG (synrg@synrg.usercloak.freenode) joined #gnuenterprise. good morning hello SynrG http://lists.debian.org/debian-devel/2003/debian-devel-200311/msg01346.html is this interesting? if this subproject is, in fact, started and becomes a going concern, does it fit with gnue's goals? Nick change: mdupont -> mdupont-work gnue is not about debian or any os gnue is about free enterprise business programs obviously but debian is a consumer (or potential consumer) like SAP, or something... cooperation between related free software projects and an interest in each others' work is not entirely unheard of :) yes, in fact gnue is a gnu project i am a debian developer myself and cooperate closely with the maintainers of another gnu project, gtypist the relationship has always been mutually beneficial SynerG: my english is reaaly poor, so i'm suggesting to wait sure for dneighbo/jcater/jamest the core peop i know derek that's why i thought i'd drop in or jbaylei but he's in a timezone that's probably still asleep for some time :) SynrG: that's all been done for a long time now SynrG: to the gentleman who made that post, i present 'google.com' dtm: "debian for enterprise" has been done before? i dont know about debian for enterprise, but a community replacement for RHAS as a subproject within debian, involving debian developers internally? thierry_ (~thierry@musashi.xtensive.com) joined #gnuenterprise. SynrG: i was referring to his first paragraph right SynrG: there was no niche left by redhat. the context is "this is a debian developer list" fedora completely fills the niche? with no room for competition? there are other projects i'm not suggesting there should be duplication of effort. but some of us feel that debian's way offers significant advantages stand by otherwise, i doubt if we'd be doing what we're doing at all hm. i dont use feeling when evaluating enterprise technology :) s/feel/know/ :) oic :) it is ordinarily my style to qualify statements but if you want me to be arrogant, i can try quite acceptable :) ok well i totally lost the link for now, but there's a metaproject and several subprojects who are stripping out all encumbered elements of the commercial-only redhat products. in addition to fedora and fedora legacy i have more than just a casual interest in this. debian is (quite obviously) my platform of choice. i have a full-time job and family of seven to look after, which perhaps narrows my time to focus on distributions outside debian, so that's what i recommend/support for my friends and family. neat that's a big family! thierry (~thierry@musashi.xtensive.com) left irc: Connection timed out there are two users i support, and possibly a third (among friends and family) who might benefit from gnu enterprise and you're most welcome to it! i'd like to see gnue be of the highest quality possible on the debian platform unfortunately, it is off-focus for me to take on the project myself as a developer, that is but as a user, that's a different matter dimas (~dimas@195.218.177.46) left irc: Read error: 110 (Connection timed out) we need more users too :) if it's fairly easy to set up and maintain, i could take a support role for these two (potentially three) users SynrG: maybe you'll try it out hey, we have packages in sarge one user is my father, who, on top of his lifelong career as a university professor, runs a volunteer-run school on the side SynrG: neato SynrG: there are tons of projects behind freesoftware in education currently he only has linux deployed on his firewall. but he and my mother have both repeatedly been frustrated by the microsoft stuff on their desktop systems and are open to alternatives SynrG: start with the apps! basically, their situation is that they need SOHO stuff SynrG: get em on OOo and Mozilla SynrG: and such yes, that was my thought SynrG: is that feasible? SynrG: apps, then file formats but beyond that, what might gnue offer them as a SOHO? sounds like they're pretty "with it", so liberation takes its course have to go for 1 hour, bye SynrG: there's a subproject for gnue for small bidness btami: l8r user number two is a sort of "branch office" of that organization Nick change: btami -> btami_out SynrG: neat he is a pastor, with no prior exposure to Microsoft software ahhhh. how nice. we bought him a computer and installed debian + KDE on it (back in the days of the furor over KDE licensing, no less ... it was a pragmatic choice) dimas (~dimas@195.218.177.46) joined #gnuenterprise. he has run that successfully for a few years now, in a remote location of our province i have had to handle *very* few service calls Nick change: mcuria-away -> mcuria SynrG: on the same insatllation of everything? a few upgrades neat. when he needed upgrades, i'd either patch remotely (he'd dialup and email me his ip#) or he'd bring his system into town (a few hour's drive) and i'd service it over a weekend (including some hardware stuff) my third potential user is my brother, who is setting up a side-business he is the managing editor of a magazine. he is selling remaindered books on the side. since he gets them free from work, which just throws them out, he can turn quite a profit on them :) so, having all of these people in mind, i would like to give a bit of thought to each of their varying business needs. SynrG: by what means does he sell them? are they in high bulk? he sells them online. SynrG: where? amazon auction type place? i think so ok huge bulk? his current challenge is that competitors seem to use auto-bidding hundreds per month? and he loses out to them hm. i'm not sure what kind of volume he moves what's that mean more specifically? is that some bot they use on the amazon-type auction site? or do they have their own sites? he is starting to teach his family members how to participate in the business too. ok. he has noticed in the bidding patterns that he always loses by the same increment he supposes this is because they have out-auto-bidded him so his competitors are outbidding him on a shared public bidding site? a la amazon? he raised the issue with me a month or so ago. i haven't heard from him recently on whether or not he has overcome the problem. i believe that's the problem, yes. :/ i have some interest in web scraping & building interfaces to web sites see http://alibi.nslug.ns.ca/ my focus has always been on the home: building procedures that will make daily living easier yeah. but it's not a big leap from that to the needs of business we often face web sites over which we have no control, and we have no other means of access to the services provided to automatically interact with those sites, we need web bots i initially wrote alibi in perl. it then evolved into a python app. i have toyed with the idea of switching again to ruby ... but in the meantime, it remains as a python app because of broader library support er, routine libraries, not book libraries :) http://www.research.att.com/~hpk/wsp/ <-- web scraping proxy like that? yes, except that has a detestable license oic just from first perusal, anyway in what way, briefly? i read about wsp in DDJ ianal, but it seemed to not be dfsg free SynrG: so you wrote a web scraping proxy too? no ... i did it the "hard way" howzat well, the application started not as a web bot, but as a "screen scraper" which interacted with a telnet-based system so i extended that design to interact with the web instead the web scraping proxy is a general solution. a very elegant one too. Hmmm. so yours isn't a web scraping proxy. hm. basically, i acted as "human web scraping proxy" between myself and the system i was interacting with i talked to the system and observed the results heh! then i wrote custom code to deal with it this is not a very extensible model i'm hoping to refine that to make my code more general based on what i have observed from interacting with a few such systems SynrG: maybe you should rewrite AT&T's wsp ;) SynrG: er, no, you should look at metawrap.com http://www.research.att.com/~hpk/wsp/faq.license.html take a look at "point 1" here is a comment back in 2001 on this license: http://lists.debian.org/debian-legal/2001/debian-legal-200104/msg00088.html it doesn't look good :( "We want everyone who receives the source to know what we have done vs. what changes have been done by others that we have not yet approved. This is primarily an issue of quality assurance." ... where "quality assurance" == "institutional paranoia" Action: SynrG nods Action: SynrG looks at metawrap Action: SynrG boggles the scope of that project is staggering ok, i'm going to need a bit of time to absorb all of that thanks for the reference :) i have to get myself ready to go to work (incidentally, professionally i am a software developer, and have primary responsibility for the webification of our legacy interfaces :) i have worked at the same company since 1985, developing first on VAX/VMS (actually, i came on when we were migrating to the system from PDP-11/RSTS-E) yeah it is staggering. holy crap. 1985?! well ok have a good one! :) thanks. you too Action: SynrG idles, hoping derek will take note of the first topic and comment SynrG: you can also post to the gnue mailing list dcmwai_ (~dcmwai@219.95.159.33) left irc: Remote closed the connection ToyMan (~stuq@smtp.dstoys.com) joined #gnuenterprise. rerwer (AmoCissaa@199.243.96.248) joined #gnuenterprise. Hoder all. Hoderr, dat is. dimas_ (~dimas@195.218.177.46) joined #gnuenterprise. Nick change: thierry_ -> thierry Nick change: SachaAway -> SachaS dimas (~dimas@195.218.177.46) left irc: Read error: 110 (Connection timed out) jamest (~jamest@gw.math.ksu.edu) joined #gnuenterprise. Action: chillywilly peeks in Nick change: mcuria -> mcuria-away Nick change: btami_out -> btami SynrG: jamest is your man to talk, "da masta" like derek :) dcmwai (~dcmwai@219.95.60.29) joined #gnuenterprise. i'm a lurker at least that's all i am lately and is derek active much anymore? i think the project has been taken over by the europeans! :) the "germans" :) yeah the GNUtonators :) haha jamest, what are you trying to do? or "GNUminators" jamest, em... do you know of anyone who know more about grd? jcater! jcater But jcater is not here :( jamest: hola hi ever'buddy what's up w/ the grd? S/nick SacahZzz Nick change: SachaS -> SachaZzzz siesel (jan@xdsl-213-196-195-140.netcologne.de) joined #gnuenterprise. hi all dcmwai: siesel is here ;) hi siesel hi SaschaStillAwake :) zzzz Ha... Siesel is here... finally jamest, I'm trying to design a grd to print Purchase order and also Invoice.. and I feel stupid for doing so... rerwer (AmoCissaa@199.243.96.248) got netsplit. mcuria-away (~user@29-185-89-200.fibertel.com.ar) got netsplit. LuftHans (~lufthans@wsip-68-107-221-207.ph.ph.cox.net) got netsplit. SynrG (synrg@synrg.usercloak.freenode) got netsplit. SachaZzzz (~sacha@online.havanawave.com) got netsplit. dtm (~dtm@r1.txwifi.com) got netsplit. nickr (nick@e-64-35-146-235.empnet.net) got netsplit. siesel (jan@xdsl-213-196-195-140.netcologne.de) got netsplit. jamest (~jamest@gw.math.ksu.edu) got netsplit. dimas_ (~dimas@195.218.177.46) got netsplit. btami (~tamas@ip102-205.ktv.tiszanet.hu) got netsplit. ajmitch (~ajmitch@wlg1-port32.jetstart.maxnet.co.nz) got netsplit. siesel (jan@xdsl-213-196-195-140.netcologne.de) returned to #gnuenterprise. jamest (~jamest@gw.math.ksu.edu) returned to #gnuenterprise. dimas_ (~dimas@195.218.177.46) returned to #gnuenterprise. rerwer (AmoCissaa@199.243.96.248) returned to #gnuenterprise. SynrG (synrg@synrg.usercloak.freenode) returned to #gnuenterprise. mcuria-away (~user@29-185-89-200.fibertel.com.ar) returned to #gnuenterprise. btami (~tamas@ip102-205.ktv.tiszanet.hu) returned to #gnuenterprise. LuftHans (~lufthans@wsip-68-107-221-207.ph.ph.cox.net) returned to #gnuenterprise. SachaZzzz (~sacha@online.havanawave.com) returned to #gnuenterprise. dtm (~dtm@r1.txwifi.com) returned to #gnuenterprise. nickr (nick@e-64-35-146-235.empnet.net) returned to #gnuenterprise. ajmitch (~ajmitch@wlg1-port32.jetstart.maxnet.co.nz) returned to #gnuenterprise. damn netsplit.. :( that's a bugger to do jamest, Yes I think so.. but there must be a way.. siesel, any.... purchase order would print some items, an address, etc. all linked with a purchase_id right= /=/?/s Puchase Order will print, 1) Company Address and info 2) Vendor Address and info and also Vendor sales person. 3) The Purchased item (code id) Item name, quantity, Prices and the total Then the Page number. oop is page footer.. Here is some query on the aria.. ok. select vcompany.companyname,vcompany.address1,vcompany.address2,vcompany.city,vcompany.state,vcompany.zip,vcompany.phone1,vcompany.phone1comment,vcompany.phone2,vcompany.phone2comment,vcompany.email1,vcompany.email1comment,vcompany.website,invpo.ponumber,invpo.ordernumber,invpo.duedate from company as vcompany,vendor,invpo where vcompany.id=vendor.orderfromcompanyid and vendor.id=invpo.vendorid and invpo.id='.sqlprep($invpoid) Only to get company and vender address and info. oopp this is only to get vendor info and this is to get our own company info select gencompany.name,gencompany.address1,gencompany.address2,gencompany.city,gencompany.state,gencompany.zip,gencompany.country,gencompany.phone1,gencompany.web,gencompany.email from gencompany where gencompany.id=".sqlprep($active_company) IMHO it needs three/four datasources And this is to get the Item select item.itemcode,item.description,invpodetail.itemqty,invpodetail.itemprice,itemvendor.vordernumber,invpodetail.unitperpack from invpodetail cross join vendor cross join invpo cross join item left join itemvendor on itemvendor.itemid=item.id and itemvendor.vendorid=vendor.id where invpo.id=invpodetail.invpoid and invpo.vendorid=vendor.id and invpodetail.itemid=item.id and item.companyid=".sqlprep($active_company)." and invpodetail.invpoid=".sqlpre p($invpoid) siesel, It actually need 5~6 table ok, so 5-6 datasources 3 for company info (vnedor/own) and 3 for item siesel, what I don't really know here is that the cross here and there .. one master datasource (purchase order) and the rest datasources Yes Ok, I'll try to setup an example. what will you do if the purchase order is > 1 page? jamest, Break it.. how? reports doesn't do that well company name and info is the header.. jamest: how about leaving that to the end processing step? jamest, haha :) :) end processing step? i.e. report --(XML)--> XSLT --(latex)--> LATEX (page break) --> PDF/PS siesel, do you read php I can send you a files so that you can take it as example. dcmwai: I can ... I hope ... :) siesel, you must :) email? which file is it in arias? Or isn't it ready yet. siesel, it is :) invpoview.php did I still need to send it? Action: siesel looks into arias dir ok. got it. siesel, can read :) siesel (jan@xdsl-213-196-195-140.netcologne.de) left irc: "switching 5" siesel (~jan@xdsl-213-196-195-140.netcologne.de) joined #gnuenterprise. Action: dcmwai is away: Goto bath... dsmith (~dsmith@mail.actron.com) joined #gnuenterprise. dcmwai: one question: you have one invpo line per report? siesel, one invpo line per report? again? Action: dcmwai now really going to take bath.. be back by 15 ok. hi siesel hi thierry commet ca va? btami (~tamas@ip102-205.ktv.tiszanet.hu) left irc: siesel, ? hey siesel all hello chillywilly hi chillywilly dcmwai: I have a first version, but couldn't test it because of missing data. siesel, let put in some data.. siesel, do you have mysql and aria running/ ehmm, no. :) s/\/? Action: siesel is setting up mysql db now. siesel, hum that is too bad.. siesel, get the latest cvs version of aris aria http://www.postgresql.org/presskit/en/presskit74.html ok. siesel, all done? postgres 7.4 release :-o chillywilly: Wow. Why would anyone want to sue anything else? Anyone know anything about this "Apple Computer's Rendezvous zero-configuration networking protocol" ? only speed/control freaks ;) s/sue/use/ dcmwai: done siesel, then what now .... :) mysql up and running, but I don't like to install arias now, as I allways have some php problems. are there some invpo data in the filldata.sql script, or do I have to create it on my own? siesel, you will have to create your own.. hum let me see if I can spear some... wait 5 ok. dsmith: what about it? siesel, I can just export and let you import isn't? dtm: I saw it in that postqres url chilly posted. Never heard of it before. dsmith: oh. well i can verify that it exists! heh dsmith: were you looking for someone to retype the RFC or... did you have something more specific? dsmith: look it up on apple.com. it's an open standard! yay dtm: Ok. It's dhcp then? dcmwai: I think so. but I haven't used mysql for years, so ... dsmith: no, it's below dhcp bah! dsmith: it's wireless or ethernet based autodiscovery of hosts, based on default nonroutable IP addresses, who discover and adapt to each others' presence in a p2p fashion dsmith: er, it's *before* dhcp if not below it I mean't It's NOT dhcp then. dsmith: no, they call dhcp "dhcp" dsmith: it's what you do if you have no dhcp Sounds Intresting. I'll have to look into it. dsmith: or if you're on a transient network, like at a coffeeshop, friend's hoouse, or walking down the street within range of a potential pal yeah so it negotiates an impromptu LAN wendall911 (~wendallc@guardian.nidaho.net) joined #gnuenterprise. if you've configured yourself to be open to such things siesel, ok.. DCC files send? dtm: Thanks for you explanations. siesel, it is ease... :) siesel, mysql -p < the unziped files dsmith: ok :) siesel, the database base bane is siesel ah.. damn siesel, the database base bane is aria siesel, the database base name is aria Action: dcmwai is sick again... :) :) mcuria-away (~user@29-185-89-200.fibertel.com.ar) left irc: Read error: 54 (Connection reset by peer) ok. datasoure populated. one question about the data. Yes If I would use "for i in X" loops to describe the query, how would I do it? IMHO invpo, it the most outer loop, then comes vendor, itemvendor, invpodetail, item right? Action: dcmwai is thinking... siesel, you are talking about this query select item.itemcode,item.description,invpodetail.itemqty,invpodetail.itemprice,itemvendor.vordernumber,invpodetail.unitperpack from invpodetail cross join vendor cross join invpo cross join item left join itemvendor on itemvendor.itemid=item.id and itemvendor.vendorid=vendor.id where invpo.id=invpodetail.invpoid and invpo.vendorid=vendor.id and invpodetail.itemid=item.id and item.companyid=".sqlprep($active_company)." and invpodetail.invpoid=".sqlpre p($invpoid) yes. I think the answer should be yes from item, invpodetail, vendor, itemvendor, Action: dcmwai is blur... there is too many cross join .. :( from invpodetail cross join vendor cross join invpo cross join item left join itemvendor ... I use the trial and error method :) Thank siesel :) Action: dcmwai owe siesel one :) hmm, its still a bit buggy. siesel, anything wrong somewhere? mcuria-away (~user@29-185-89-200.fibertel.com.ar) joined #gnuenterprise. Nick change: mcuria-away -> mcuria mcuria (~user@29-185-89-200.fibertel.com.ar) left irc: Remote closed the connection no, just have to code a bit more :) Action: dcmwai have bought a python book and try to start learning python. siesel, then thank you :) dneighbo (~dneighbo@ip68-109-180-32.ph.ph.cox.net) joined #gnuenterprise. hi dneighbo, chillywilly siesel: es geht mir gut ;) :) Your german is probably better then my french, as you leave near the border (close to Freiburg, if I remeber right) dcmwai: it seems, like reports doesn't support >2 detail master sources very well. ajmitch (~ajmitch@wlg1-port32.jetstart.maxnet.co.nz) got netsplit. dimas_ (~dimas@195.218.177.46) got netsplit. dimas_ (~dimas@195.218.177.46) returned to #gnuenterprise. ajmitch (~ajmitch@wlg1-port32.jetstart.maxnet.co.nz) returned to #gnuenterprise. siesel, oh.. that will be a hard for printing this kind of report .. maybe the database structure is wrongly design derek (~dneighbo@ip68-109-180-32.ph.ph.cox.net) left irc: Connection timed out jbailey (~jbailey@199.212.225.1) joined #gnuenterprise. reinhard (~reinhard@M1264P004.adsl.highway.telekom.at) left irc: "Wouldn't it be wonderful if real life supported Control-Z?" jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. Nick change: mdupont-work -> mdupont Nick change: mdupont -> afk-15 hi jcater one report question: are 2-layer master/detail sources supported? I mean, 3 datasources connected between Master-Detail in one "line". Nick change: afk-15 -> mdupont siesel, good night I'm going to sleep not :) siesel, good night I'm going to sleep now Action: dcmwai waves :) dcmwai (~dcmwai@219.95.60.29) left irc: "Client exiting" is there a status page somewhere that you can check the status of sarge's migration to stable? jcater: problem solved, seems like I have to add 's in each section and subsection. siesel: iirc, there's a so you can indicate a field breaks at a higher section than it currently appears in but it's been a while hmmm, that probably won't help in this case, as I just need the detail fields ToyMan (~stuq@smtp.dstoys.com) left irc: Read error: 54 (Connection reset by peer) but I'm trying it with prequery's at the moment. which doesn't work :( ToyMan (~stuq@smtp.dstoys.com) joined #gnuenterprise. jamest: ping anybody here know of a university or city library that uses Linux for internet access or daily use...maybe ltsp If by "city" you mean a village of 300 people, I think there was a tiny town in British Columbia that did. It was basically what would run on the 486 they had. jbailey: well, any town will do :) Next time I talk to Elenore, I'll ask her. Should be in the next month or so. jbailey: my local library is looking into getting away from m$, i'd like to find a library that is using linux as a resource is all. If you find out, i'd be grateful for the info wendall911: ? you mean university wide? jamest: just going to ask if your library uses Linux for internet access dunno jamest: just interested in the library mostly ok, np my department is over 50% linux on the desktop very nice but that's not library, our library here is windows terminal services at ksu, city still uses old vt terminal setup (that works as opposed the the univ library system) wendall911: The library could use GNUe on Windows, get that all running for them, and switch to Linux. They could even do it slowly. jbailey: in what capacity would GNUe be useful to them? I can see several ways, just looking for feedback. Card catalog system, checkin, checkout, and inventory. ToyMan (~stuq@smtp.dstoys.com) left irc: "Client Exiting" jbailey: that would be great, I think the first step will be to get them using linux for public internet access Even there, they can do it in baby steps. If they take Mozilla, customise it all up to what they need, they can change the underlying operating system at a later date.