jcater (~jason@cpe-066-061-083-220.midsouth.rr.com) left irc: "sleep" reinhard (~reinhard@M701P002.adsl.highway.telekom.at) joined #gnuenterprise. dsmith (dsmith@oh-strongsvillecadent1-1c-203.clvhoh.adelphia.net) left irc: Remote closed the connection hmm bed btami (~tamas@ip102-205.ktv.tiszanet.hu) joined #gnuenterprise. dtm (~dtm@h-68-165-0-110.SNVACAID.covad.net) left irc: Read error: 113 (No route to host) btami (~tamas@ip102-205.ktv.tiszanet.hu) left irc: Isomer (dahoose@port-219-88-246-112.jet.net.nz) left irc: "Client Exiting" Isomer (dahoose@port-219-88-246-112.jet.net.nz) joined #gnuenterprise. hmm coffee Focused (~willey@67.113.12.162) left irc: Read error: 60 (Operation timed out) havoc (~havoc@mke-65-31-168-36.wi.rr.com) got netsplit. johannes (~johannes@M697P006.adsl.highway.telekom.at) got netsplit. havoc (~havoc@mke-65-31-168-36.wi.rr.com) returned to #gnuenterprise. johannes (~johannes@M697P006.adsl.highway.telekom.at) returned to #gnuenterprise. SachaS (~Sacha@dialup-196-132.wasp.net.au) left irc: Read error: 104 (Connection reset by peer) SachaS (~Sacha@dialup-196-211.wasp.net.au) joined #gnuenterprise. ToyMan (~stuq@smtp.dstoys.com) joined #gnuenterprise. Arturas (~arturas@gsk.vtu.lt) joined #gnuenterprise. Hello hero SachaS (~Sacha@dialup-196-211.wasp.net.au) left irc: Read error: 110 (Connection timed out) jamest (~jamest@leibniz.math.ksu.edu) joined #gnuenterprise. SachaS (~Sacha@dialup-196-211.wasp.net.au) joined #gnuenterprise. jamest: HELLO! heh hello Action: derek was worried you didnt put on your tinfoil hat over the holiday and perhaps were abducted sick very very sick still not recovered but good enough to be back at work ouchie not sure which is worse :) jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. donuts for all, jcater has arrived! who's buying? hmm they were just laying there on the sidewalk.. didnt relize they were for sale.. dsmith (~dsmith@borg.altus.cc) joined #gnuenterprise. lol johannes (~johannes@M697P006.adsl.highway.telekom.at) left #gnuenterprise ("Client Exiting"). dsmith (~dsmith@borg.altus.cc) left irc: "later.." bunny (~alex@b125187.adsl.hansenet.de) joined #gnuenterprise. bunny (~alex@b125187.adsl.hansenet.de) left #gnuenterprise ("Client Exiting"). Arturas (~arturas@gsk.vtu.lt) left irc: "Bye :)" reinhard_ (~reinhard@M701P002.adsl.highway.telekom.at) joined #gnuenterprise. reinhard (~reinhard@M701P002.adsl.highway.telekom.at) left irc: Read error: 60 (Operation timed out) dsmith (~dsmith@borg.altus.cc) joined #gnuenterprise. alex_k (~alex@195.54.196.227) joined #gnuenterprise. alex_k (~alex@195.54.196.227) left irc: "Client Exiting" man I am getting a crappy connection the the debian servers 24.5kB/s :( yeek 3kB/s heh, my kde apt lines server was a lot faster man this blows jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: Remote closed the connection Brain Freeze! What's Darth Vaders name as a boy? I can't remember! lol anakin :P Yes! Thanks jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. topsew.com/see/gnue I should scale that puppy down.. it's pretty bigly.. I love that goat logo :) that's a little better.. sorry if any of you hit it before I scaled it yeah it was a tad bit big revDeke (www-data@alt1.libertydistribution.com) joined #gnuenterprise. http://www.microsoft-watch.com/article2/0,4248,899456,00.asp is just scary Vee2d2: i cant see the logo you posted :( is it gone? revDeke: I had to use mozilla to see it http://www.topsew.com/see/gnue/gnue.goat.emb.png whoa! is that on clothes i think we found a new logo man it is too rough for print (looks like cloth), but i love the red goat symbol I was just playing w/it.. that was an initial run it is simple and elegant it's jcater's art revDeke: his image is from a vector source file so it could scale to the size of the empire state building if you needed it to the art could.. not the embroidery.. =) hehe why not? you don't do large scale clothing? I'd like to order a GNUe T-Shirt that the Statue of Liberty could wear HEH I'm just saying it would require a new design.. the emb format doest scale well (ya know, after all these donuts, I might need one) =) dsmith (~dsmith@borg.altus.cc) left irc: "later.." jcater: i almost said something along lines of jcater needs the "empire" size, but thought you might add i needed the chrysler building size so kept my mouth shut i remember the logo from before when jcater posted but i think it wsa black and white it didnt 'pop' like it does now thinking about it though i like it a lot and basically it could be any color it nees to fit in coudl be used with or without text text can easily go on right side or bottom and still look nice Action: revDeke motions we adopt it :) yea... I thought about making the GNU red white & blue.. =) revDeke: typically you start out w/a b&w to get the idea down I didn't realize you didn't know that sorry im an idiot Action: revDeke apologizes seeing it more 3d w/ color made a big difference i liked the original but had a hard time seeing it 'pop' what would be very cool would be a translucent raised red version like the aqua buttons kind of like if you go to http://www.gnome.org and the foot logo there that clear 'glass' look Action: revDeke doesnt like the gnome logo, just the glass effect but i like the image as its easy to represent in many ways yet still hold the "brand" i.e you can change colors and gussy it up with neat effects but ultimately it pretty much looks the same :) why didn't konq render the logos? this is the year of the goat too, btw. really lol yeah we need to capitalize on that that rocks well we better get cracking css probably, chillywilly Action: revDeke will need to get that booth in SF this year and do some 'Year of the Goat' marketing ;) hmmm feb 1st was first day in year of the goat so Vee2d2 you own topsew or just work there? own you have plans for gnue short or long term and can we help we DESPERATELY need to get a solution in place using gnue with someone who is patient and looking to put some work into it ToyMan: that offer goes for you too :) that's why I'm here.. =) i think the girls are having a sleepover so i will be banished to my office tonight i hope to get moving on gnue-sb again will you be around tonight? I'm always around or you have a little time now I was wondering.. might you have some notes or something for what you have in mind for gnue-sb? Action: chillywilly is gonna practice guitar at 7 tonight with the worship team revDeke: still playing guitar? chillywilly: yeah not much anymore though, they took the winter off for offerring classes... they just started back up in feb. first class was last week Vee2d2: unfortunately i dont the general gist of it is this what a small business needs to operate done in gnue two tier i would imagine a quickbooks replacement with more funcationality original needs were for someone else at had start in inventory/warehouse management Bobacus (~rob@pc3-cmbg2-5-cust245.cmbg.cable.ntl.com) joined #gnuenterprise. the other need was contact management thats why you see contact manager and item stuff in gnue-sb today we were going to try to 'port' NOLA to gnue-sb for accounting as a start, though im not as convinced on that now, but its still possible i dont want to build for buildings sake i want requirements from someone who plans on using it having hard time finding someone who doesnt want something like yesterday i.e. willing to go through a development process or who is willing to go through a development process and actually willling to commit time i.e. we have had like 10 opportunities at this with different people and we usually get one of two things happening 1. We dont do this full time so a solution wont be ready in 2 weeks. So they go elsewhere. 2. They don't have any time to put towards letting us know their needs so we can make something for thme. Action: revDeke is not criticizing either reason, they just exist ok.. I gotta feed baby, but I'll be back in a bit seems like you are in here a lot and are not afraid to give feed back so im going to say you probably dont have the issue of #2 i dont know if you have something you use now or not so if there is motivation or if you need solution yesterday :) Action: revDeke waits patiently, might have to come back in a few ToyMan (~stuq@smtp.dstoys.com) left irc: "Client Exiting" anyone know who this is ? http://www.neoxen.com/tech_gnu.htm wtf? nope based out of finland Action: jcater has never heard of them that doesn't mean much though seems they have their own framework what is funny is i read neoxen as neo oxen or new oxen which one could call new GNU i thought maybe it was jonas, but he isnt in finland iirc he is in sweden doesn't seem like Free software either well they have alot of marketgin pizzazz going for them oh well it's non-free jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: "away" ok.. both kids are nappin, well.. I hear one singing but hopefully she's singing herself to sleep.. heheh rofl jamest (~jamest@leibniz.math.ksu.edu) left #gnuenterprise. Vee2d2: you got time or you still have a singer? Action: chillywilly is hungry As for my needs, I want it all.. eventually. I am, and have been keeping my stuff in spreadsheets and word processor docs.. it works, barely.. It's really a duplication of efforts at that, since I send copies of the sheets to my father who then inputs the data into quickbooks to churn out whatever he hands to the cpa to cut our taxes. What I would like right of the bat is to manage products as I think once I have my then work on the things I need to purchase, quote, sell, and invoice 'em.. so managing inventory products is first on the list? if so that fits PERFECT with where gnue-sb is today really|? Action: revDeke still thinks accounting will be a ways off I figured it was as good a start as any Action: ajmitch didn't realise gnue-sb had working inventory stuff i.e. i expect it to grow quickly but basically just create 'journal dumps' for a quickbooks, peach tree or the likes i.e. let something else hand general ledger for tax purposes until we build up to it Action: revDeke is gung ho Action: ajmitch asks derek - does gnue-sb have working inventory stuff? if you are willing to give it a shot i would like you to be the first gnue-sb 'customer' ajmitch : kind of hmmf it has working 'product management' not inventory ok but inventory is only a step behind as 80% of inventory is products :) Action: ajmitch has yet to finish off this inventory app right Vee2d2: do you have gnue installed and are you interested? you have committed all that to cvs? if so can you get latest copy of cvs and check it out i can come back in a few hours and see what you want next we can create a quick plan (roadmap) and i can start tonight maybe by end of the night we can have something that will suffice for product management? Action: ajmitch sees very little action on gnue-sb cvs this year and if you have products in spreadsheets maybe we can convert the data ? Action: revDeke hangs his head in shame re: gnue-sb cvs Action: ajmitch has a big csv file full of products, exported from myob dsmith (dsmith@oh-strongsvillecadent1-1c-203.clvhoh.adelphia.net) joined #gnuenterprise. oh, I've been playing with it. I've been modifying things to more suit how my SKU's are setup.. family.mfg.mfgmodel#crossreference.color.size I have a form to populate/manipulate the families and mfgs.. I even made some .gsd's for the schema which.. I think is where I left off. I remember wrestling with just how the schema should be laid out, what should be where.. I need to read over my notes and files and see what ToyMan (~stuq@170-215-205-41.glv.frontiernet.net) joined #gnuenterprise. howdy ToyMan howdy i'm with derek on the working solution for gnue thing reinhard_ (~reinhard@M701P002.adsl.highway.telekom.at) left irc: "War causes terrorism." almost ready to be the bleeding edge poster-child doing bayonne on the phone system now is dstoys your main deal? yup that's enough ;-) neat. So do you have a store front, too? www.dstoys.com dstoys.org is the back end for the community just built and moved to a new factory nice, I didnt relize you were making these. I thought it was a buy and resale operation Vee2d2: so you wanting to forge solution on your own or be gnue-sb posterboy can I be both? =) ToyMan: you almost ready to poster boy it too Vee2d2: yes give or take some that is things need to be done generically, but should be suitable to your needs (thats a plus of going first) ;) exactly.. Action: revDeke is seriously ready to start bolting some stuff up tonight which is why I was asking if you had some sort of notes or something with the big picture in it.. =) did you do fsf assignment? yes I got my signed copy back i would like to work with you (and stu) to roadmap gnue-sb especially short term plans and get cooking i had planned tonight to do the SKU categories thing i.e. the do thigns by category to 'build a SKU' in the item management stuff but sounds like perhaps you already have some of that? woudl hate to redo the work Action: revDeke must run away now revDeke (www-data@alt1.libertydistribution.com) left #gnuenterprise. ToyMan: how are your products organized? jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) left irc: Read error: 104 (Connection reset by peer) organized? you mean on the site? I mean, how do you identify them? or within the inventory system local or on the web? right local you do a real good job abstracting it from the customer.. =) I use a free-form product code we use admin controls to keep them consistent PC.size.color.style 2.3.3.x spaces PC 2 spaces size - 3 spaces and so on the Design Science products on the web follow that convention for distributing other manuf. products we prefix with MC - 2 letter manuf. code Nick change: dsmith -> ds|walkingdog so MC.PC.size.color.style that's an interesting way to do it it makes it easy to sort on reports and factory line workers can understand that certain kinds of info always lives in the same place in the code and getting your line workers into the program is 90% of inventory control IMHO yep so, do you do manufacturing? Nick change: ds|walkingdog -> dsmith I do embroidery, but I worked for a mfg'r for 14+ years so I can respect all that it entails.. cool what sort of embroidery? my niche is doing company logos but we do some of the smaller work too a neighbor has me monograming stuff all the time ooh. I might have you do some logos for us some time.. we can do it. =) Action: Vee2d2 lights the grill Nick change: dsmith -> ds|Steak Stoke (~stoker@ppp1.tc-1.roc-pt.ny.localnet.com) joined #gnuenterprise. Stoke__ (~stoker@ppp1.tc-1.roc-pt.ny.localnet.com) left irc: Operation timed out derek (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) left irc: Read error: 60 (Operation timed out) mdean (~mdean@mkc-65-28-72-76.kc.rr.com) left irc: Read error: 60 (Operation timed out) mdean (~mdean@mkc-65-28-72-76.kc.rr.com) joined #gnuenterprise. derek (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) joined #gnuenterprise. ToyMan (~stuq@170-215-205-41.glv.frontiernet.net) left irc: "Client Exiting" InsanitY (insanity@co58147-a.olden1.ov.home.nl) got netsplit. InsanitY (insanity@co58147-a.olden1.ov.home.nl) returned to #gnuenterprise. jcater (~jason@cpe-066-061-083-220.midsouth.rr.com) joined #gnuenterprise. Nick change: ds|Steak -> dsmith dtm (~dtm@h-68-165-0-110.SNVACAID.covad.net) joined #gnuenterprise. way more company came over Vee2d2: you still burning down the house er lighting the grill derek. what it is ?! hey derek. i had the idea of simulating roles by making projects with no deadlines. so we can have departments or job titles in DCL so you can look at what the Sales dept is doing today sounds utterly evil to me but nothing will stop you im of mind of if it fixes your needs do it ;) and you can also make a 'contacts' Project. regardless of where your contact data is stored (gonna hafta be in Addressbook for me, until DCL contact mgmt is ready), you can note and plan their status what's evil about it? a role is literally a project with no deadline. then inside that role you have task oriented projects. grrr anhyone know anything about esd sound? and gnome i setup sound server so could get email notifciation by sound works fine nephew came over and logged out wife logged in himself and no sound :( he is in audio group and could use soundcard before Action: derek is thoroughly confused back, buy feeding baby right now.. will be back for the night in a few.. sounds like maybe the game or whatever the nephew wants sound from might be trying to talk directly to oss or whatever and esd has conrol of the device(s).. which the short term solution might be to kill esd and try.. the fix is to make the app use esd nope esd isnt running and it should be if i try esd from command line as him i get dneighbo (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) joined #gnuenterprise. dneighbo@aegagrus:/etc$ esd esd: Failed to fix owner of /tmp/.esd. Try -trust to force esd to start. esd: Esound sound daemon unable to create unix domain socket: /tmp/.esd/socket The socket is not accessible by esd. Exiting... dneighbo@aegagrus:/etc$ ahh. interesting I dont run into such issues as I'm the only user sup fewls heya chillywilly shoot I gotta see when farscape comes back on Action: chillywilly was rockin' out at church it was a good episode cool btw, I hate threads ;:P threads are the devil! chillywilly: you need to get a VCR :) dneighbo: so derek, what exactly do you not like about using Projects as roles and as contacts? repeats in T-75minutes havoc: there are several down here dneighbo: i need perspective here if you dont mind chillywilly: then use them :) havoc: but mainly I slurp FS eps off of a certain IRC server/channel dneighbo: i mean, as contact planning, not as contact storage give me minute beating snot out of different pc havoc: none of them are hooked up i think i found issue Action: dtm tosses dneighbo a wet noodle someone (like tucker maybe....) logged wife out without killing xmms and it left a /tmp/.esd/socket file irc.irc-chat.net #farscape-central, dewd *slurp* dneighbo (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) left irc: "Client Exiting" Vee2d2: gonna watch SG1 too :) havoc: I have the last 2 eps on my HD (not including this one) ah derek: i made a "contact" attribute set, consisting of Uncontacted (open), Can't Reach (deferred), Needs Followup (open). derek: i'm not sure what else to put, because I haven't any experience with good contact management man i even went to act.com last night to look up their feature sets. i actually learned a tiny smattering. about integration between contacts and relevant files such as invoices and quotes. of course they achieve that by having a built-in word processor and email client, or integrating with M$-only garbage. so I think we'll hafta have an ACL compatibility shim between phpgwapi, dcl, and whatever. I need a coke Action: dtm gives chillywilly a poke oh i misunderstood. my bad. SachaS (~Sacha@dialup-196-211.wasp.net.au) got netsplit. SachaS (~Sacha@dialup-196-211.wasp.net.au) returned to #gnuenterprise. see another frelling netsplit that's at least one every day for the last 5 days or so time to grill lilo ;) there's been some pretty rough routes out there.. I couldnt get into my server this morning yea, but he was claiming that I was exaggerating and I have proof man a netsplit every day on freenode isn't the same freenode ;) I guess efnet is still plagued by massive splits every few minutes? I havent been there in a long long time.. SachaS (~Sacha@dialup-196-211.wasp.net.au) got netsplit. w00t, new farscape! SachaS (~Sacha@dialup-196-211.wasp.net.au) returned to #gnuenterprise. the point is that netsplits shouldn't be user-visible, and aren't, on some irc networks that are extremely larger, more complex, and more populous shouldn't be user-visible any more than any other type of service failover or fault tolerance dtm: what i dont like about it is that it is a hack that cripples you later in life BUT as i stated if it fixes your problems go for it :) Vee2d2: you get those squirts in bed yet :) derek: so how would it cripple later? just gimme a context um derek: it's a huge win compared to nothing, right? you cant use projects if you scavenge it for something else today you might not care, but tomorrow you might if you scavenge what for whta else? I'm holding the lil one 'gain.. =( SachaS (~Sacha@dialup-196-211.wasp.net.au) got netsplit. SachaS (~Sacha@dialup-196-211.wasp.net.au) returned to #gnuenterprise. SachaS (~Sacha@dialup-196-211.wasp.net.au) got netsplit. SachaS (~Sacha@dialup-196-211.wasp.net.au) returned to #gnuenterprise. Vee2d2: i need you to setup a savannah account SachaS (~Sacha@dialup-196-211.wasp.net.au) got netsplit. and let me know what your id is there i will add you to the gnue-sb project SachaS (~Sacha@dialup-196-211.wasp.net.au) returned to #gnuenterprise. also if you upload your keys to savannah you will then have cvs access im gonna get my contacts out and put glasses on, and get settled in for some hacking hopefully the little one will get down for bed quickly :) SachaS (~Sacha@dialup-196-211.wasp.net.au) got netsplit. SachaS (~Sacha@dialup-196-211.wasp.net.au) returned to #gnuenterprise. SachaS (~Sacha@dialup-196-211.wasp.net.au) got netsplit. SachaS (~Sacha@dialup-196-211.wasp.net.au) returned to #gnuenterprise. Action: chillywilly notes HE doesn't get added to anything as cool as gnue-sb :'( hmmm, no updates for gnue-sb :P derek: what's taking so long?!? :P i promised to commit exact same amount as you ;) Account #13596 Your login is Vee2d2. You are member since 2002-Dec-09 23:33. Vee2d2: you have access to gnue-sb now please note the mailing lists are still borked :( i have emailed savannah-hackers hopefully they will fix ASAP as it makes me nervous not ahving a commit list Action: derek looks around for Vee2d2 before i start dorking stuff up ;) dneighbo@latitude:~$ gnue-forms --version GNUe Forms Version 0.4.0 GNUe Common Version 0.4.0 dneighbo@latitude:~$ ouch Action: derek wonders if we have 0.4.3 debian packages or not SachaS (~Sacha@dialup-196-211.wasp.net.au) got netsplit. SachaS (~Sacha@dialup-196-211.wasp.net.au) returned to #gnuenterprise. dneighbo@latitude:~$ dpkg --list |grep gnue ii gnue-common 0.4.1.99-20021 The shared library for many items of the GNU ii gnue-designer 0.4.1.99-20021 A Rapid Application Development tool for GNU ii gnue-forms-wxg 0.4.1.99-20021 An XML-based forms painter ii gnue-reports 0.1.0.99-20021 An XML-based output-independent reporting sy dneighbo@latitude:~$ hmmmm SachaS (~Sacha@dialup-196-211.wasp.net.au) got netsplit. SachaS (~Sacha@dialup-196-211.wasp.net.au) returned to #gnuenterprise. Stoke_ (~stoker@ppp34.pm3-8.roc-pt.ny.localnet.com) joined #gnuenterprise. ohhhh kay! she kept almost passing out then would stretch her hand up and rub my chin and giggle because of the stubble.. so you here? yep or busy wiping baby barf up :) that's a lovely thought ok lets start with where you want to go or do you want me to tell you what is up with gnue-sb and kind of where its at attempting to figure out how to create a gpg key.. =) gpg? or ssh? ssh key is whatyou need for cvs access login to savannah and go to https://savannah.gnu.org/account/ oh ok.. =) I just saw on the account page a place to paste a gpg key and assumed that's what you meant.. I see it now =/ er so go here https://savannah.gnu.org/account/editsshkeys.php warning they use ssh 1 dont even ask why but its important or you will be really frustrated why things dont work if you dont edit config files to note this :) ...to what you were saying, I'm up for hearing 'what is up with gnue-sb'.. Stoke (~stoker@ppp1.tc-1.roc-pt.ny.localnet.com) left irc: Read error: 113 (No route to host) ok here is the general overview we were going to do work for a small manufacturer that was in a bad pinch we couldnt wait for appserver and 'official submission' processes so we made a gnue-sb that would be less 'controlled' but quicker to build with 2 tier only no appserver the original needs were item management and inventory as the upfront need was warehouse management basically everything after the order was taken i.e. they were using paypal and online store to get orders they wanted to dump an order into system and basically have pick lists created from it for the warehouse bundle ship and have all shipping labels etc printed once the backend was working, redo shopping cart side as well as add invoicing and other things this is of course a light speed overview anyhow they got impatient and have now gone through about 4 off the shelf products and still searching the item basics are there (though the sku category stuff needs to be added) it wouldnt be too hard to get basic inventory secondarily IDEALLY gnue-sb will be perfect for people that use paper today as the transition can be slow and they can use immediately even if functionality is more minimal one problem you run into 'starting' is people not wanting to 'use' something until it has EVERY feature but its hard to get features when no one will use it :) im REALLY hoping that you might be in a position to start using a piece at a time for example if we got it so just all your products(items) were able to be entered that is a huge start and if nothing else you can query your product line and run reports on what products you have to offer but then we can bring inventory online or ordering or shipping etc that's my plan if that makes sense so say you get products and then get customers or vendors you can use them even if you are still doing invoices in word or whatever i suspect if you use this you will be amazed at progress as two things will happen 1. framework development will increase as jcater and jamest respond to 'production problems' really quickly as they can relate, plus its encouraging for them to see it in production 2. putting something in production gets features and bugs fixed quickly :) as motivation all around is bumped exponentionally ;) Action: derek will let you comment while i refill my drink 1a. we take patches too :) 2a. we take patches too :) and hopefully we can lay out a 'quick' roadmap right jcater: ticket #XXXX GNUe XXXX does YYYY and crashes - that counts as a patch right? you're doing invoices in word? no, oowriter.. =) do you have the data in databases already? which your comment about reports and rtf files triggered some good emotions.. unfortunately not. 'cause you know we can do merges between word/oo documents and database data bummer jamest and I both extensively use that feature my users can edit their basic documents in word/oo, and save to a "public" drive so I don't have to keep modifying their reports for them :) jcater: my thoughts are this we get his products in db and get him using the contact manager and he can at least 'fudge' invoices for a small while until we get an order screen up (real quick) and have it make openoffice invoices with reports Vee2d2: i really think within 2 or 3 weeks we can get you doing invoices in gnue if you are willing to start simple and grow with it I agree.. Action: derek has to get that drink give me your comments and that's where we are now.. I must be tired.. I just typed out a bunch of stuff that was in fact incorrect.. =) for some reason I was thinking I might need to reference a vendor table from the sku, I was thinking about the mfg portion of my sku (family.mfg.crossref-to-mfg#.color.size) but mfg != vendor.. =) when I was playing around.. the forms for setting up the family table and mfg table were straight forward.. simple lookup tables.. what i was thinking was giving 5 or 6 elements to a sku the cross reference table is a little meatier i.e. 5 or 6 lookup tables totally generic each having a code and desc hmmm damn practical problem perfect world i would do 6 tables each with code adn descrip where code was 4 char so you could have a 24 digit number if you wanted (a little long for my liking) or you could only use 1 actually i guess it doesnt matter because we wernt going to have 'hard' numbers we were going to have built numbers to i think it will work here is what im thinking you have 6 tables with codes that are up to 4 long but you dont need to use 4 you could use 1 or 2 so if i used 2 spaces in each code i could have six 'elements' and a 12 digit sku anyhow it would likely pad 10 as 0010 but when you do the 'build' a sku you could flag strip leading zeros is that making sense? or i suppose there is no need to zero pad as the categories technically dont make a 'string' the sku is the string Action: derek keeps thinking of accounting string and forgets the goal the SKU itself will be a 'dumb' number to the rest of the system, right? Action: derek hopes i understand the goal Vee2d2: exactly you can tie a sku to the six tables for 'reporting' like stu said he prefixed things for 'reporting' that wouldnt need to occur as the sku could be tied to a category table im thinking something like sku_category derek: so how would my idea of using Projects to schedule contacts and to organize roles, be a bad idea later on? sku_class sku_type or something sku_group Action: derek doesnt like those names but im leary to put sku_color sku_manufacturer right it needs to be dumbed down.. sku_size sku_family BUT maybe thats not a bad idea if we can cover your and stu's and 2 other manufactures i know in like 4 tables or 5 then we can make a sku_misc_category sku_misc_category2 Action: derek wants it to be meaningful to a degree as if everyone in the world says I kinda like the idea of a wizard that you use to define just how the sku is setup.. one of the categories is manufacturer then its silly to call it sku_type as everyone will ask 'whats that' :) Action: derek is thinking it will not so much be a wizard but a screen where you pick from drop downs the six categories (or as many as you use) and have option to 'push' a creat sku button that creates consistently named sku's but someone could key sku's that had nothing to do with the hierarchy yet still use it does that sound reasonable? I dunno.. Vee2d2: the biggest problem i see with a wizard approach is it might too much into old school extensible approach where customizations are all entries in tables which makes it easy to add some stuff but makes it an utter bitch to get data out as well as a pain to make ui's but you are the user so i want to hear from you ":) I'm sorta reading over my notes still.. hmm --- Sat Feb 22 2003