Mr_You (rouzer@mankind.boredom.org) left irc: night nite jamest (jamest@fh-dialup-201082.flinthills.com) left irc: [x]chat nite jcater (jason@HubS-mcr-24-24-112-3.midsouth.rr.com) left irc: [=V97=] Leaving reinhard (rm@62.47.45.227) joined #gnuenterprise. Nick change: dnMovie -> dnZzz hi reinhard reinhard (rm@62.47.45.227) left irc: Ping timeout for reinhard[62.47.45.227] andru (andru@203.97.82.178) joined #gnuenterprise. andru (andru@203.97.82.178) left #gnuenterprise. reinhard (rm@N816P003.adsl.highway.telekom.at) joined #gnuenterprise. ariel (ariel@rm3-772.dialup.tiscalinet.it) joined #gnuenterprise. ariel (ariel@rm3-772.dialup.tiscalinet.it) left irc: [x]chat dtm (dtm@m206-221.dsl.tsoft.com) joined #gnuenterprise. aloha. hi darw1n_work (darw1n@driehoek.linvision.com) joined #gnuenterprise. ho dtm that is, hi dtm ajmitch (ajmitch@p20-max4.dun.ihug.co.nz) joined #gnuenterprise. Nick change: ajmitch -> ajzzzz what is the status of the accounting application? ra3vat (ds@195.239.66.34) joined #gnuenterprise. chillywilly (baumannd@d174.as15.nwbl0.wi.voyager.net) left irc: ra3vat (ds@195.239.66.34) left irc: Read error to ra3vat[195.239.66.34]: No route to host Mr_You (rouzer@mankind.boredom.org) joined #gnuenterprise. jamest (jamest@hobbes.math.ksu.edu) joined #gnuenterprise. #gnuenterprise: mode change '+o jamest' by ChanServ!s@ChanServ hello reinhard (rm@N816P003.adsl.highway.telekom.at) left irc: Those who say it can't be done should never stop those who are actually doing it. hi ra3vat (ds@195.239.66.36) joined #gnuenterprise. jamest: hi darw1n_work: reading the logs the status of the accounting app is that it is still in design stages ra3vat (ds@195.239.66.36) left irc: Ping timeout for ra3vat[195.239.66.36] there is quite a bit of the design done however and IIRC some interfaces are starting to be developed jamest: do you know who is developing this - I want to get in contact with that person Mr_You (rouzer@mankind.boredom.org) left irc: Ping timeout for Mr_You[mankind.boredom.org] several people are working on it jamest: do you know phpgroupware? reinhard, neilt, louis, stanley, and others I'm sure I'm forgetting yes, we've talked about php groupware before i think derek (dnZzz) spoke w/ the developers Action: jamest has bad memory well, since i am writing a bookkeeping app for it, I was wondering has there been spoken with seek3r or jengo? dnZzz: wake up! ;-) reinhard (rm@N816P003.adsl.highway.telekom.at) joined #gnuenterprise. reinhard: just the person, you still working on gnue-config spec right? reinhard: and louis's stuff is being folding into it right? jamest: i am pricipially working on gnue-config just not now and stan was so good to translate louis's stuff into a language we understand (=gcd :) ) :) and neilt started to integrate that with what we have darw1n_work is wanting to contact the people working on the accounting system and i have printed out _all_ the existing docs and will take them as a lecture with me to the mountains you call that a vacation!?!?!?!? thats just wrong :) i will probably come back with a ton of comments in 2 weeks ra3vat (ds@195.239.66.33) joined #gnuenterprise. well afaik neilt is not toooooo hot about accountig, his expertise is more in the field of supply chain and i didn't have the time yet to look at it bb in 30 - work so the current state of the accounting system is somewhere between pre-proposal and proposal :) :-) btw i hope to get some input wrt accounting during the next 2 weeks i am spending my holiday with an accountant :) brb jamest (jamest@hobbes.math.ksu.edu) left irc: [x]chat Mr_You (rouzer@mankind.boredom.org) joined #gnuenterprise. reinhard: you are going to mountains w/o computer but accountant :) reinhard: i heard you are going to develop an accounting app - Is it written in php? I think phpgroupware is working on a very basic accounting module/package.. which is written in php GNUe provides a framework for creating applications.. it doesn't matter what the client type is as long as it can be a Forms client.. sometime in the future a web-based (preferably php, but could be any CGI language) would be useful jamest (jamest@hobbes.math.ksu.edu) joined #gnuenterprise. #gnuenterprise: mode change '+o jamest' by ChanServ!s@ChanServ at the expense of the limitations of html and javascript limitations indeed Action: Mr_You knows that wasn't directed at him, but is a big mouth anyways.. ;-) Mr_You: thanks for explaining np the only web-based accounting app I've found that was ok.. was something called General Ledger.. (I believe thats right) .. its very ugly ;-) but has some, but limited, functionality. I haven't checked the status of phpgroupwares module, but that would be something to consider also.. GNUe web-based Forms client is way down the road I would say considering curses and GUI are priorities netledger ahh ;-) nedledger is really kewl - oracle thought so at least - it's now called oracle small business something Mr_You: I am writing that module ;-) oh hmm.. I think I'm thinking of something else.. I'm not talking about commercial apps.. only GPL and I think this one was perl based aha it was just called General Ledger I think lemme see if I still have it installed Mr_You: you thinking of sql ledger? that would be it I don't see it installed darw1n_work: Mr_You: I am writing that module ;-) darw1n_work: what module? phpgroupware bookkeeping module Mr_You: i believe it is called sql ledger yes - someone told me about it ok back darw1n_work: i am a member of this gnuenterprise project and we all together work on writing a business application covering everything like inventory, and yes of course accounting i regard myself as a member of the accounting group although i have not contributed much till now but i am planning to do so :) ra3vat: that accountant is my wife actually :) reinhard: i like your project, success with it before I forget to say it ;-) reinhard: haha.. ;-) darw1n_work: thanks I meant the gnue project yeah i figured that :) nut accounting is part of that ehehe so a client must use the gnue Forms api to communicate with the 'back-office' - is that correct? darw1n_work: nope you can access it via geas's api in apps written in other languages o, then I must go and read some docs ;-) IIRC there have been Java,C, and python apps that access geas data darw1n_work: the geas interface is actually nothing more than a normal CORBA interface so you can access with the "back-office" with every language that can do corba. aha, corba darw1n_work: we are currently seeking for alternatives to corba that we would provide in parallel you would have any idea? xmlrpc? could you give me in a nutshell what this is and if it's more portable than corba? reinhard: I've guessed :) http://www.xmlrpc.org/ thanks np not that sure if it really the same, xmlrpc looks more like soap ToyMan (stuq@c5300-4-ip206.albany.thebiz.net) joined #gnuenterprise. actually we would be looking for something that would be rather _less_ overhead than corba because we are already fighting like hell to make corba run on windoze Nick change: dnZzz -> derek and from our last survey we can tell that we need windoze clients a. Mr_You: you are thinkin of sql-ledger (written in perl) gooooooood moringggggg! b. darw1n_work: i have spoken with jengo, seeker and mdean from groupware derek: are you lagged yeah we figured that out ;-))) derek: that are the most important persons yes c. xml-rpc and soap are VERY similar methods of RPC (SOAP is basically m$ implementation of XML-RPC) i.e. the ole embrace and extend :) morning reinhard bastards they are derek: since they are not in the channel now - 2/3 are on the o'reilly conf :-) what did they say? and what did you think? i think they dont fully get it :) except for mdean derek: i am not sure if xmlrpc is much like corba since i do not know corba that well it is similiar the issue is.... phpgroupware would make a nice client for gnue i.e. it would has lots of stuff we dont ever plan on writing, (ie groupware) s/groupware// I don't understand why it has to be integrated with phpgroupware. and there is stuff where i think we are much stronger (inventory, accounting, etc) since we are an application server and since PHP speaks CORBA basically all one would need to do is write 'screens' in groupware actually in some sense I partly agree.. phpgroupware could create a GNUe module.. that access our application back end right this way you get more robust accounting if you want it in a win or gtk front end you could have multiple GNUe Forms Client modules in the phpgroupware menu/system... connecting to their respective modules/packages and get more limited functionality in the web front end (due to html limitations) jengo and seeker seemed to be wanting us to write something and then they would talk to us i kept trying to explain that via corba you can get at our API in full and php talks CORBA they werent quite getting this personally, I don't think many (A LOT) organizations have a huge need for web-based email if a VPN is used.. which is more common reinhard: on this note, this is where i would like C interfaces opposed to corba ones er as well as corba ones so that we could then write a phpModule for GEAS derek: i aree on that so then people using php would have geas available natively like they do postgres etc btw i think that is what they were wanting i understand that as most poeople installing phpGroupWare dont own thier server and are at mercy of ISP and getting ISP to install corba ORB etc could be rough darw1n_work: anyhow thats where it sits, i spoke with most of the crew about 8 months ago im guessing and more recently talked with dtm/mdean ok i'll be gone derek: thanks for telling me all! probably for the next 2 weeks now have a nice time reinhard: where you going on vacation? and don't stop coding :) mountains to another part of austria corinthia i think is the name in english or carinthia yeah probably carinthia bye all reinhard (rm@N816P003.adsl.highway.telekom.at) left irc: Those who say it can't be done should never stop those who are actually doing it. jcater (jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. morning jcater morning derek ra3vat (ds@195.239.66.33) left irc: Ping timeout for ra3vat[195.239.66.33] morning [10:18] MSG541 http://iwsun4.infoworld.com/articles/hn/xml/01/07/26/010726hnmsgreatplains.xml?0727fram this is just more scary, known about for long time, but just scary ToyMan (stuq@c5300-4-ip206.albany.thebiz.net) left irc: [x]chat m$ seeing that smallbiz is untapped by them currently cause high license cost but shifting ot monthly cost that is much smaller will bait many a firm im sure bbl derek (derek@cpe-24-221-112-50.az.sprintbbd.net) left irc: [x]chat ra3vat (ds@195.239.66.34) joined #gnuenterprise. neilt (neilt@dialup-209.244.133.231.Dial1.Providence1.Level3.net) joined #gnuenterprise. #gnuenterprise: mode change '+o neilt' by ChanServ!s@ChanServ neilt (neilt@dialup-209.244.133.231.Dial1.Providence1.Level3.net) left irc: darw1n_work (darw1n@driehoek.linvision.com) left irc: Client Exiting dtm (dtm@m206-221.dsl.tsoft.com) left irc: Ping timeout for dtm[m206-221.dsl.tsoft.com] chillywilly (baumannd@d20.as0.nwbl0.wi.voyager.net) joined #gnuenterprise. ToyMan (stuq@c5300-2-ip142.albany.thebiz.net) joined #gnuenterprise. jcater (jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: ajzzzz (ajmitch@p20-max4.dun.ihug.co.nz) left irc: Ping timeout for ajzzzz[p20-max4.dun.ihug.co.nz] ajzzzz (ajmitch@p20-max4.dun.ihug.co.nz) joined #gnuenterprise. jcater (jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. chillywilly (baumannd@d20.as0.nwbl0.wi.voyager.net) left irc: ra3vat (ds@195.239.66.34) left irc: Client Exiting Action: ToyMan is away: I'm busy dtm (dtm@m206-221.dsl.tsoft.com) joined #gnuenterprise. ra3vat (ds@195.239.64.73) joined #gnuenterprise. jcater (jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: Ping timeout for jcater[w202.z065105010.mem-tn.dsl.cnc.net] Mr_You (rouzer@mankind.boredom.org) left irc: bye We dont happen to have any consultants in the SF Bay Area around here, do we? i don't think so Action: ToyMan is back (gone 03:03:58) whoah - what a root canal :( jcater (jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. Mr_You (rouzer@mankind.boredom.org) joined #gnuenterprise. jamest (jamest@hobbes.math.ksu.edu) left irc: Read error to jamest[hobbes.math.ksu.edu]: EOF from client Nick change: ajzzzz -> ajmitch jcater (jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: ra3vat (ds@195.239.64.73) left irc: [x]chat dneighbo (dneighbo@alt1.libertydistribution.com) joined #gnuenterprise. dneighbo: hi dneighbo: hi hi been quiet in here today ToyMan sorry about the tooth Action: dneighbo hates dentist ra3vat (ds@195.239.64.73) joined #gnuenterprise. not more than ToyMan take a peek at the files yet? jcater (jason@HubS-mcr-24-24-112-3.midsouth.rr.com) joined #gnuenterprise. ToyMan : nope :( i did download though my laptop isnt booted up or i would look now would boot up laptop but hope to leave real soon :) Action: dneighbo is moving files to machine now i.e. downloading again as i REALLY want to see these things :) ToyMan i know i asked but you have windows or bsd clients? i assume windows (with an access application) if so the next question would be do you want to keep it that way :) stu er ToyMan you here? it complaining about a ref to the U drive i assume that is omething in your app but it still opens cool little menu on the left Action: dneighbo has to remember how to unhide things ah i found it wow this is only one of teh dbs this is pretty heavy duty access usage sorry just got back to the computer i think you are making it bulge at the seams :) one minute while I catch up ok i get it now you are linking tables adn the links point to the U drive :) windows clients now - but I want to move to bsd or debian Action: dneighbo should be able to fix that (i hope ) i have to run upstairs for 5 min will be back ok i'm away for a few minutes too ToyMan: is back Action: dneighbo is back too all present im downloading lasst file you develop all this? yep Action: dneighbo is impressed started as a wrapper around an old dos app to give it a boost finally not much of the original app was needed anymore is mac data used at all anymore not really or just given to me for historical purposes some of theq queries still link to the old stuff your menu bar on the left reminds we desperately need our interface wrapper I figured it would be easier to grok if fewer things were broken I hate Access it's easy it looks nice it's very sloppy it's a pig damn access i hate m$ you have tables hard linked to U:/something/dst_data.mdb im not finding a way to change that pathing so will have to rename the original table and re import :) will work, but seems like a minor thing to be able to change such a thing :) hmmm, if they're all in the same directory they should be happy I don't recall doing any hard links where does it come up? chillywilly (baumannd@d20.as0.nwbl0.wi.voyager.net) joined #gnuenterprise. dst_data is where 98% of the data files live yep im rebinding now ahhh, all of the tables in the Contacts.mdb are links to dst_data you have to ....rebind, but you know that already yip contacts all rebound now rebinding ship good contacts and production do the heavy lifting ship is pretty small ok ship is rebound Action: dneighbo can now open things w/o errors :) do you normally work out of contacts? or production i see both have menus i assume it depends on whether you are doing contact stuff or doing day to day ops order entry and recievables are in contacts plus contact mngmnt production is for the factory ok to get the stuff made thats what seemed to be well you want a gnue replacement? some of this stuff i think gnue is ready to do now yes! if possible other parts will take some more work on the tools woudl you be opposed to slow rollover? it all has to hang together, even during the transition i.e. start replacing pieces at a time i'm constantly rolling over it would be best that way pieces, i mean as one thing is you could probably do parallel i.e. move a table to postgres write the gnue screens for it but link to it via access so you could still hit it with access as well how are the postgres odbc drivers? for windows good from what i can tell i have used to convert apps to postgres in the past good though i have not run postgres 'systems' for extended periods though i cant imagine it would be any more painful than access database storage :) it would be hard to do worse :) I keep 4 rotating backups on tape in fact at home, the way you have this i might be able to convert it to postgres back end in one night and back up all of the apps with a cron job to a different drive every day ToyMan: would be impressed and i could hand back to you the postgres files with your data Action: dneighbo learned an EVIL little trick doing a conversion here the other day :) what's that? access has POWERFUL cut and paste so if you create a postgres table that has same structure you then import it open access table highlight whole table and paste into postgres table and voila you have your data in postgres :) ahhh, I've done that with other apps what way are you converting? in my case teh data wasnt the same so i had from access to postgres col1, col2, col3, col4 (in access) but Action: ajmitch has to use access this semester @ uni, and would prefer to play with postgres :) col1, col2, col5 (in postgres) so just make a query w/ out the columns you dont want or adding blank columns if you have more in the dest db and voila :) Action: dneighbo wonders if mongo has postgres running sounds good darn dont have postgres odbc on this machine ToyMan you be aroudn later? i have to run to chiropractor and fix our pool i will be back on tonight have to put the kids to bed in the next 15 min didn't know chiropracters did pools after 9:30 EST i'll be about for a bit my wife does massage but I swim in a lake regional differences, I guesse ToyMan are some of teh links dead? some of the queries on the menu are out of date in contacts and production i tried Find: in MAC i think and it complained no link to Macdb it appeared to be looking for custmr i linked that and it still fails that should work if you reboundj MacData look at the query and the query seems defunct so didnt know if will have to rebind queries or not other queries seem to work ok customrs - weird spelling most will if anything doesn't link to the MacData files it's not a big deal old stuff once all the 'live' business was done in those files i'll import them into dst_data nevermind you had it as hidden table :) when i linked it changed to CUSTOMRS1 i unhid tables will need to rebind those :) bingo that fixed it ah, I hate that you can't nest folders in Access I use the hide thing to clear the clutter of the old stuff :) that i still need around - kind of. ok i have to run for real, but i dotn want to im rather liking this bbl dneighbo (dneighbo@alt1.libertydistribution.com) left irc: [BX] The Spice Girls use BitchX (instead of underwear and talent) i'm glad see ya Action: ToyMan is away: ToyMan has finish the King Solomon's Mines for the kids Nick change: ajmitch -> ajbusy chillywilly (baumannd@d20.as0.nwbl0.wi.voyager.net) left irc: Ping timeout for chillywilly[d20.as0.nwbl0.wi.voyager.net] wakojack (bla@203.97.82.178) joined #gnuenterprise. wakojack (bla@203.97.82.178) left irc: viva l'emperour wakojack (bla@203.97.82.178) joined #gnuenterprise. wakojack (bla@203.97.82.178) left irc: viva l'emperour cjcater (jason@HubS-mcr-24-24-112-3.midsouth.rr.com) joined #gnuenterprise. jcater (jason@HubS-mcr-24-24-112-3.midsouth.rr.com) left irc: Read error to jcater[HubS-mcr-24-24-112-3.midsouth.rr.com]: Connection reset by peer cjcater (jason@HubS-mcr-24-24-112-3.midsouth.rr.com) left irc: Read error to cjcater[HubS-mcr-24-24-112-3.midsouth.rr.com]: Connection reset by peer Action: ToyMan is back (gone 01:44:11) jcater (jason@HubS-mcr-24-24-112-3.midsouth.rr.com) joined #gnuenterprise. ToyMan: says Gagool will show the white men the treasure but the kids suspect a trap neilt (neilt@dialup-166.90.64.124.Dial1.Chicago1.Level3.net) joined #gnuenterprise. neilt (neilt@dialup-166.90.64.124.Dial1.Chicago1.Level3.net) left irc: ra3vat (ds@195.239.64.73) left irc: [x]chat derek (derek@cpe-24-221-112-50.az.sprintbbd.net) joined #gnuenterprise. hi derek hello Action: derek just found ouchie problem i only have access2000 @ home, if i do things in it then you wont be able to open as i 'think' 97 & 2000 are incompatiable what a surprise Action: derek has to look into it i know the formats are COMPLETELY diff and not compatiable that wouldn't affect the conversion into postgres though the question is can i open the 97 one and not have it convert to 2000 format or not (i think the answer is no) ToyMan: this is pretty much true as if i conver to postgres you will hve to reimport er link all the tables anyhow imagine MS doing somthing so nasty as stupid access wont let you change the path/location of the linked table you have to delete and relink (me wonders why this isnt a property that you can change) then again maybe it is and im too dumb to find it hmmm. i think if you bring up the table design and choose properties for the whole table there is a place to do it there nope at least not that i saw it says hey jack a** this is a linked table you cant edit it, you want to open it anyway then it opens but you cant do anything as not in edit mode Action: derek admits he didnt look too hard though so i suppose its possible :) I seem to remember finding a way to do this before but i forget if you will be here for a bit, i will setup on home machine (before it was at work) and try converting things on a few tables to see how it goes yeah, for a bit more - it's getting late here you have a debian box w/ postgres there? i'm curious to see how it comes out just put postgers in ok looking at it now am busy trying to break it er.. learn it Action: derek starts setting up dstoys database ToyMan: ducks out for a moment jcater: you ehre/ er here/ er here? derek: here um im having ftp issues among machines...