Action: derek dials 1-800-4Donuts hmmm seems like the MS branch closes at sunset Vee2d2: you have 5 lu tables i was going to make 6 my question is do you really have your sku as C.14.4.20.1 or is it represented as C144201 do you see a need for a 'free' form as well yea, it's really delimited. that way I didnt literally lock myself into 2 digits per segment as I designed it to be. well lets start with what you need and we will adjust form there hmmm im thinking that the delimiter will be really evil for invoicing and such i.e. i dont see delimiters for much of anything on invoices and such i encounter maybe i just seem them as - instead of . and since I've opted to make my cross references mfg.model <-> ref, there's a much more likely need for that segment to be 3 digits ahh, will the choice of delimiter I'm not married to.. s/will/well Action: derek is just waffling here goes back to not starting out too complex as now it seems like this will need to be a choice 'delimiter' or no delimiter im planning on making the categories be 6 character varchar just as padding will need to be, I aggree so if you want to use 1 digit or 6 you can and somewhere will need to add a 'pad' routine :) ok for now im giong to make the fields big enough but will plan on delimiting (not doing optoin not to) and NOT padding i figure those can be 'second pass' type items :) suits me. =) im getting lost in the email now im with everythign until we get to The crossref table maps mfg.model <--> our-reference section im somewhat lost from that point on Ok are you trying to build in some filter mechanism here? very generically im thinking six category tables with a segment and a desc (As well as id) then you have your item and it has id cat1 cat2 cat3 cat4 cat5 cat6 which holds the segments Action: derek suspects will 'build' the number form the segments as well and store it in a field even though it could be calculated (for flexibility) later on i imagine some folks will want free form ability its the cross reference table here that is throughing me for a loop i think i get what your driving at just not sure how to make it generic did i lose you? yea, I can see this as being specific to my needs. but I need to have a way to correlate my #'s to my vendor's #'s.. each vendor has their own system but the one thing that remains true is the mfg's #. So I rely on that. let me see if i can clarify what you are trying to do basically take manufacturer and manufacturer number and condense it to a smaller number yes to include as a part of your sku exactly ok here is what im thinking family manufacturer mfg model are probably going to be universal that is people will probably want to 'group' product types and everyone's product is manufactured by someone (even if its yourself) this way we can create a xref table as if all tables are generic we dont want to make 6 xref tables actually i guess family could still be generic johannes (~johannes@M697P006.adsl.highway.telekom.at) left irc: Read error: 104 (Connection reset by peer) so what if i make johannes (~johannes@M697P006.adsl.highway.telekom.at) joined #gnuenterprise. manufacturer table and mfg model number (which is really an Xref table) then 4 generic 'category' tables will this work for you? I'm trying to digest it of course manufacturer table should be more than id segment desc but i want to get something usable quick and doing full contact tables for manufacturer at this point makes me shudder a bit are your manufacturers and vendors one in the same no not at all.. and do you know if in manufacturing they usually are? ok so manufacturer would be 'nike' I might be able to source a mfg's goods through multiple vendors, and in fact that is the problem even though you buy from 'sport shirt world' InsanitY (~insanity@213.51.196.60) left irc: Read error: 60 (Operation timed out) i.e. sport shirt world is your vendor right so having 'manufacturer' information beyond product details likely isnt too important i.e you dont have contacts at nike and dont deal 'directly' with them InsanitY (insanity@co58147-a.olden1.ov.home.nl) joined #gnuenterprise. well.. I could, but that's not important to me.. I would set them up as a vendor and treat them as such if I did Action: derek is just trying to guage if that manufacturer table needs to at this point me more complicated than a mfg name i suppose for now it need not be and if it becomes important we fix it :) Action: derek has to keep telling self something is better than nothing, dont over engineer thats what gnue 'proper' will be for ;) =) ok going to start implementing this watch out :) Action: Vee2d2 buckles up jcater (~jason@66.61.83.220) left irc: "nite" grrr my tunes no worky gnome pisses me off sometimes ok a lot of times now that they insist on m$ like gconf and oaf/bonobo CRAP! l8r jamest (~jamest@adsl-64-216-111-42.dsl.tpkaks.swbell.net) left irc: "[x]chat" ok think almost ready for fairly big commit ok committed some goodies... time to find out if that commit list really works yummy look at that it WORKED! time to attack the forms yay reinhard (~reinhard@M689P021.adsl.highway.telekom.at) joined #gnuenterprise. dsmith (dsmith@oh-strongsvillecadent1-1c-203.clvhoh.adelphia.net) left irc: Read error: 60 (Operation timed out) Vee2d2: ok i think most of the lu_* forms are updated excpet for lu_item_mfg_model.gfd they probably lack polish and havent been fully tested but they connect to the tables and have all the fields :) getting late but with some luck i think i can get lu_item_mfg_model.gfd pushed out and possibly update item_maint.gfd to reflect all the new tables I'll give 'em a lookee in a bit you have some 'testing' time tonight :) or you running off to bed pretty soon fairly soon.. btw: there is item_mfg item_mfg_model which were your sku_mfg and sku_xref then there are item_group item_type item_category item_class which are the four 'generics' category is slightly different as a generic as it has a 'parent' attribute so you could have nested categories for reporting purposes the other tables might have use for that as well, but its in category only cause it already existed there :) you realize documenting this stuff will be more of bitch than writing it :) =) btami (~tamas@ip102-205.ktv.tiszanet.hu) joined #gnuenterprise. ok item_mfg_model_maint.gfd checked in fwiw 0.4.3 designer is littered with buglets as to what it writes to form definitions i think only form in item section left to edit is item_maintenance Action: derek needs to go to bed have to kill routing to login to work bbl ok, night btami (~tamas@ip102-205.ktv.tiszanet.hu) left irc: sigh cant get into work kppp is busted in sid grrrr now im screwed stayed up too late and will have to travel to the office tomorrow grrrrrrrrrrrrrrrr what is url to get status on packages in sid? http://www.debian.org/distrib/packages has a search form on the bottom of the page Action: Vee2d2 keels over and rolls his way to bed thanx derek =) ra3vat (~ds@ics.elcom.ru) left irc: Read error: 60 (Operation timed out) ra3vat (~ds@ics.elcom.ru) joined #gnuenterprise. btami (~tamas@ip102-205.ktv.tiszanet.hu) joined #gnuenterprise. ninja (rossg@p13-sniHS3.S.loxinfo.net.th) joined #gnuenterprise. rossg_ (rossg@p15-sniHS1.S.loxinfo.net.th) joined #gnuenterprise. ninja (rossg@p13-sniHS3.S.loxinfo.net.th) left irc: Read error: 54 (Connection reset by peer) btami (~tamas@ip102-205.ktv.tiszanet.hu) left irc: reinhard (~reinhard@M689P021.adsl.highway.telekom.at) left irc: "War doesn't solve problems. War creates problems." Arturas (~arturas@gsk.vtu.lt) joined #gnuenterprise. Hello ToyMan (~stuq@smtp.dstoys.com) joined #gnuenterprise. jamest (~jamest@leibniz.math.ksu.edu) joined #gnuenterprise. SachaS_ (~Sacha@dialup-196-176.wasp.net.au) joined #gnuenterprise. SachaS (~Sacha@dialup-196-164.wasp.net.au) left irc: Read error: 110 (Connection timed out) Nick change: SachaS_ -> SachaS dsmith (~dsmith@borg.altus.cc) joined #gnuenterprise. ooops jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise. hi werd gawd it's too early to be awake i forgot to check in my forms changes last night ;P too early to be awake its 15:00 here - I finish work in 30 mins yeah, 3PM is too early for chillywilly bah I sleep til about 12:30 no later give me some credit lol and I have an excuse last night caroline made me take her to see Bon Jovi ;) hmmm now that sounds like punishment reinhard (~reinhard@M689P021.adsl.highway.telekom.at) joined #gnuenterprise. it's not too bad Richie Sambora can play some mean guitar hey reinhard hi heya reinhard derek (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) left irc: Read error: 110 (Connection timed out) what's a good way to get a "stable" checkout of gnue? cvs co -r gnue-tools-0-4-0 gnue ? no that easy or pull head and downgrade various modules? for name in forms,reports,common do cd forms; cvs update -r forms-0-4-3-release...etc. cd $name; cvs update -Pdr $name-0-4-1-branch done what about pre-jamestui-muckup? is that "newer" that's 0.5.0 with some changes to the event system in prep for the ui muckup so no good eh? so I'd call it untested well, it worked just not well tested ok what about designer? is HEAD broke there? head is screwed http://www.cnn.com/2003/ALLPOLITICS/02/27/bush.poll/index.html you seriously don't want to go there unless you plan on working on the code no I don't ;) i consider it a major accomplishment anyway, same branhc name then? branch after over 1 year of trying I was finally able to cause major designer breakage ususally that damn thing just worked no matter what I did to forms yea, but you did it backasswards ;)_ you changed the forms format that's the easy way ;) no, no designer supported that so should I add designer to the list of modules for that branch? is there a way to check out a module under a different name in cvs or can I just mv it? I don't recall...and I am being derek-like today ;P Brian (~henderson@dial81-131-56-33.in-addr.btopenworld.com) left irc: designer fully supports the new forms format it segfaults on the new uidriver model (just fyi) well, fully supports if you ignore the new embedded dialog support well I am not that brave to upgrade yet I can use old forms format and change later when 0.5.0 is released yes in forms util dir there is a converter yea, I've seen that, thanks heh.. that's pretty funny about the openoffice.org mirrors getting poked by the bsa reports doesn't have a reports-0-4-1-branch tag it has gnue-tools-0-4-0 and 0-1-0 tag Vee2d2: hmmm? chillywilly: re /. article this morning Vee2d2: I think it is customary to provide a url Action: chillywilly thwaps Vee2d2 with a trout Vee2d2: yeah, pretty funny :) chillywilly: http://distribution.openoffice.org/servlets/ReadMsg?msgId=581265&listName=dev Action: Vee2d2 eats trout for breakfast HEH, I'd like to kick the BSA ppl in the nuts I can appreciate their 'Grace Period' form letters they send out.. they provide real good leverage to get alternative solutions into places that otherwise wouldnt be so open to the idea of using anything but M$ products.. yea, havoc there posted something to LUG thanking the BSA for helping him get more cutomers to switch to Free software ;) they're doing their part ;) yay BSA! heh chillywilly: yup, the BSA directly accounts for at least 10% of my gross revenue :) woohoo! ;P chillywilly: What's BSA Again? I keep thinking Boy Scouts of America Business Screwers of America Bastard Sadistic A**holes I always forward all news of the BSA's, M$'s and others' scare tactics to my clients and to potential clients I dunno what it officially stands for something software allaince? to show them just what they can avoid through the use of open source alliance even business software alliance thnx Ah. Double think name. doe does whatever-0-4-1-branch contain the lastest released stuff like 0.4.3 code? s/doe/so/ Should be MSM. Micro$oft Software Monopoly oh I got my federal return back already yaay this filing is going to be the most complicated one yet.. and I need to file an ammendment to last years. Hopefully what I get back from the ammendment will wash out what I end up oweing.. derek (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) joined #gnuenterprise. anyone here with routing experience? playing with a CISCO? derek: yes a bran muffin a day works wonders HEH Action: chillywilly is in a bidding war right now on ebay for a new laptop chassis chillywilly: actually i cant get ppp and eth to play nice together i can have one or the other but not both if i do a route del default and connect to ppp i can get to ppp hosts but not net if i bring up ethernet card after ppp connect i can get to net but not ppp oh you wan to route eth out through ppp? um Action: pattieja is back (gone 14:36:35) i would like to have both up internet traffic goes to eth and address xxx.xxx.x.x go through ppp ok route add -net xxx.xxx.xxx.xxx netmask 255.255.255.0 dev ethx or maybe change dev to gw but then you have to setup a statuc gw route for it static* hmmm bbiab I can't find an example on how to add a gateway route chillywilly: route add default gw chillywilly: I think that's for the default but what he wants to do is add a gateway for ppp and let say internet use the defaukt Oh, a static route? yea you add a static rout for whatever he weants to route out ppp then setup a certain subnet to go out that route bye Arturas (~arturas@gsk.vtu.lt) left irc: "Bye :)" route add -net netmask gw yea that's what I said but you need a route for the gateway itself like for my default I have default gandalf.liberty 0.0.0.0 UG 0 0 0 eth0 erm or chillywilly: You mean the subnet route for the nic? 0.0.0.0 192.168.1.1 0.0.0.0 UG 0 0 0 eth0 he wats certain traffic to go out eth0 and other traffic to go out ppp I think based on IP address does that make sense? route add ppp-gw gw ? then route add -net netmask gw ppp-gw revDeke (~laurie@cpe-24-221-112-50.az.sprintbbd.net) joined #gnuenterprise. wb join #dcl already there oops sorry have everything 'automated' on laptop not used to manually doing things :) how exactly do you want this to work? i gave up for right now have to get work done cant play with it but if you know what you are doing with route i will bug you another time as i need to solve it :0 ok for now just using wife's pc for net derek (~dneighbo@cpe-24-221-112-50.az.sprintbbd.net) left irc: Read error: 110 (Connection timed out) why do you have a ppp interface? DSL? man I wonder how much this guys wants for this laptop chassis I just upped my bid to $46.00 and still haven't met his reserve price it's just the bottom half of the laptop with a mobo no CPU no nothin else hmm chillywilly: i have to 'dial' into work vpn because i havent spent time trying to vpn client to work i.e. two ways to get on work network dial into their 'modem bank' directly and treat them like an ISP (what i do) or use vpn software over your own internet connection (i dont do) I see Action: revDeke hasnt had time to dink with finding a suitable vpn client on linux and fighting with them for config details you can't use a vpn client? oh partially cause my broadband why 10Mbps down is like 19.2kbps up i.e. slower than a modem so likely i wouldnt get all that much performance boost :-/ i will probably 'try' a client soon though and if i get it working well 19.2k is better than the phone line switch to cable modem (256kbps up) chillywilly: i get my big K and little k mixed up when i say 19.2 i mean slwoer than a phone like oh 'bits' phone does 33.6 at least if not 56 right you didn't mix it up I did you typed little k man mozilla's (galeon's) fonts are nice i.e. whatever i upgraded on their font side looks slick as snot i dont know if i can tolerate ANYTHING on windows anymore used to be at work i could tolerate exploder hehe, exploder but no tab browsing and ugly fonts now makes even it unbearable Action: revDeke needs to find windows free work :) though im greatful for the work i do have are you working from home today? erm don't answer that ;) omfg this is what is at the top oif a dice.com search agent email =============SPONSORED ADVERTISEMENT============== Bust Your Boss! Is your current or former employer using pirated software in their office? Hit'em where it really hurts - report their illegal software use today. Click to visit www.bsa.org that is just shitty yeah from hom e why the bsa is great seriously i wish they woudl bust EVERYONE who 'bootlegs' software because the more they put the vice on the copyright infringers the more they will flock to gnu/linux and free software yea they harm more than help now a days harm their own "cause" btw: i think their tactics are vile and evil BUT when you sign your life away in a EULA, you get what you deserve i suppose ;) encouragin ppl to stan each other in the back is horrible stab* whereas Free software encourages you to share and be nice to ppl :) This point alone is enough for me ok, well today is supposed to be my "recording" day I am gonna record some tracks for a song I think it will be interesting to see what comes of a suit I read about recently where a woman is sueing several large sw companies because she did not have the opportunity to read the eula before opening the product(s) she purchased, then after seeing the eula and not agreeing to it, she attempting to return the sw but the store wouldnt take it back because it had been opened. yea, that should be interesting rossg_ (rossg@p15-sniHS1.S.loxinfo.net.th) left irc: Remote closed the connection dsmith (~dsmith@borg.altus.cc) left irc: "later.." fixe (~fixe@dsl093-081-253.chi2.dsl.speakeasy.net) left irc: "Client Exiting" hmm, this blows because my digitech needs repair or something as it pops and hisses at me dsmith (~dsmith@borg.altus.cc) joined #gnuenterprise. dsmith: you are assimilated !! Ahh borg you're quick man ;) don't let anyone else accuse you of the contrary Action: dsmith chuckles mmmm, steak