| | Re: Another (semi-) standard field for inventories
|
|
(...) A side note: The contents of any particular bag in a medium- to large-sized LEGO set can change over time on different production runs. I've seen it happen many times -- one copy of the set has, say, a 2x3 black brick in the same bag as a 2x4 (...) (25 years ago, 24-Feb-00, to lugnet.db.inv)
|
|
| | Another (semi-) standard field for inventories
|
|
I couldn't find a definitive prior discussion to followup-to, so I'm posting this fresh. So far, the general standard set of fields for an inventory has been: Part Name Part Number (where available) Color Quantity I'd like to suggest another field (...) (25 years ago, 24-Feb-00, to lugnet.db.inv)
|
|
| | Re: REQ set 8286
|
|
(...) Thanks, Kim! You helped me find a couple parts I really need which are allready in my collection! Big thanks to you and others who do inventories! -John Van (25 years ago, 22-Feb-00, to lugnet.db.inv)
|
|
| | Re: CD jewel case design for scan collections
|
|
(...) I can't save them in Word95/6.0 format since it doesn't support vertical aligned text in table cells, but you can open them with Word97, since there is no format differences between them, as far as I know. I updated CD labels with a more (...) (25 years ago, 18-Feb-00, to lugnet.db.scans)
|
|
| | Re: CD jewel case design for scan collections
|
|
I don't have MS Word 2000, but the files open fine. Ryan (...) (25 years ago, 17-Feb-00, to lugnet.db.scans)
|
|
| | Re: CD jewel case design for scan collections
|
|
Any chance you can convert them to Word95 or Word97? Many of us won't have Word2000. (...) -- | Tom Stangl, Technical Support Netscape Communications Corp | Please do not associate my personal views with my employer (25 years ago, 17-Feb-00, to lugnet.db.scans)
|
|
| | CD jewel case design for scan collections
|
|
I've just uploaded some CD jewel case designs for custom CDs made for Lego related (instructions and catalogs) scans (many of us burn them for ourselves, don't we?) to the brickshelf gallery. They all are in MS Word 2000 format. You can also find (...) (25 years ago, 17-Feb-00, to lugnet.general, lugnet.publish, lugnet.db.scans)
|
|
| | Re: Lego classification system
|
|
Interesting work. I suggest eliminating theme-specific whenever it is used as elements have a way of appearing in other themes. Even decorated tiles that seemingly have no use whatever outside of the theme where they appeared may well migrate. For (...) (25 years ago, 12-Feb-00, to lugnet.db.brictionary)
|
|
| | Re: Lego classification system
|
|
(...) I object to a hard-coded limit of 9 on general principals :-). Seriously though, if there isn't a _really_ good reason for this limit (especially having it as low as 9) then don't do it. Regards, Steve Hodge (25 years ago, 11-Feb-00, to lugnet.db.brictionary)
|
|
| | Re: Lego classification system
|
|
So this signature should have the correct address for my WWWeb page. -- Thanks for your consideration. Bill Bourn {(URL) (25 years ago, 11-Feb-00, to lugnet.db.brictionary)
|
|
| | Lego classification system
|
|
Here is an outline of the first levels of the classification system I'm implementing. It's derived from Auczilla categories to some degree, but I limited the number of categories to nine. Each category can have 9 sub-categories, with a further 9 (...) (25 years ago, 11-Feb-00, to lugnet.db.brictionary)
|
|
| | Re: Online LEGO Inventory Database
|
|
Steve Bliss wrote in message ... (...) with (...) and (...) Here is the current scema. I have decided to concentrate on the parts section, and themn move onto creating a set inventory section (which I think will be the easy part)... Total of 6 (...) (25 years ago, 10-Feb-00, to lugnet.db.brictionary)
|
|
| | Re: Online LEGO Inventory Database
|
|
Steve Bliss wrote in message ... (...) with (...) and (...) It will be a relational database, and I tend to remove all hard codings possible. I will be designing the schema later today, and posting it for everyone to rip apart =) --Eric (25 years ago, 10-Feb-00, to lugnet.db.brictionary)
|
|
| | Re: Online LEGO Inventory Database
|
|
(...) Having a good list of properties at the start is a good idea, but don't hard-code specific properties into the schema. It's just a many-to-many relation between parts and properties. Assuming a relational approach. Steve (25 years ago, 10-Feb-00, to lugnet.db.brictionary)
|
|
| | Re: Online LEGO Inventory Database
|
|
(...) have (...) I'd thought about this earlier, but forgot to mention it. (...) based (...) Once (...) avoid (...) Yeah, I agree. One of the other threads had come to the same conclusion and are curently trying to decide exactly which properties (...) (25 years ago, 10-Feb-00, to lugnet.db.brictionary)
|
|
| | Gryphon Bricks (Mac) -> LDraw database
|
|
I've put together a few pages with an inventory of the Gryphon Bricks parts, and attempted to cross-reference them with LDraw pieces from Steve Bliss' site. Take a look at: (URL) is a first pass: there are some mistakes here and there, and quite a (...) (25 years ago, 9-Feb-00, to lugnet.cad, lugnet.db.brictionary)
|
|
| | Re: Online LEGO Inventory Database
|
|
(...) Yep. (...) Oh, and each description should probably be tagged with a source. That way, when we change the description of some part in LDraw, the cross-reference database can be updated. (...) Yep. A better approach may be modeling a set of (...) (25 years ago, 9-Feb-00, to lugnet.db.brictionary)
|
|
| | Re: Online LEGO Inventory Database
|
|
(...) collate. (...) Yep. The difficulty is in matching up the descriptions from the various sources (e.g. which LDraw part is this Technica part?). Sometimes it's easy, somethimes it's not. (...) Yep. (...) part (...) a (...) and (...) That's the (...) (25 years ago, 9-Feb-00, to lugnet.db.brictionary, lugnet.db.inv)
|
|
| | Re: What words describe the Lego elements?
|
|
(...) went in and updated the description parameters to include a count of holes in the piece. So if you see the page before I've updated the page with a new image, just pretend there's a hole-count category, OK? Thanks again. Billb. (25 years ago, 9-Feb-00, to lugnet.db.brictionary)
|
|
| | Re: What words describe the Lego elements?
|
|
(...) From the discussion so far, I can tell that some of us may be confusing a classification system with being able to identify a Lego element. In the perfect database, the inquiry about a piece would not need to know *anything* about how the data (...) (25 years ago, 9-Feb-00, to lugnet.db.brictionary)
|