Subject:
|
Re: Standardized Inventory File Format?
|
Newsgroups:
|
lugnet.db.inv
|
Date:
|
Thu, 14 Oct 1999 06:18:47 GMT
|
Viewed:
|
370 times
|
| |
![Post a public reply to this message](/news/icon-reply.gif) | |
Hi,
I'm new here but I live in database land. The work already put into the
CAD program inventories should not be underestimated.
For your text file format, use columns, use tabs or commas for delimiters.
People should be able and expected to enter data with at least a spreadsheet,
so give them something like:
setnumber (optional, but useful)
partnumber (LDRAW part number)
quantity
color
It would be great to have a place here on lugnet to let people upload
such files to get them test-parsed, verified and entered into a larger
database (or check/flag against errors, for them or the database).
A set format is a great idea, this way picture-based tools could be used to
help generate inventory lists online or offline.
-Todd
ps: is there a place to help develop this sort of stuff for public consumption?
Is there a plan/ help needed area someplace I can register with? Thanks
In lugnet.db.inv, Gary Williams writes:
> Hello,
>
> I originally posted this idea in lugnet.cad.dev, and Jacob Sparre Andersen
> suggested I consult with the patrons of this group.
>
> For the Lego CAD program I'm developing, I got the idea for allowing users
> to load a set inventory file if they wanted to build a model using only the
> parts from a particular set. Then the parts from that set would appear in a
> special part bin window. As the user dragged parts out of this bin to build
> their model, the bin would become emptier, thus reducing the time required
> to find the needed parts.
>
> I've noticed that most people format their inventories slightly differently.
>
> So...I'd like to propose the development of some standard set inventory file
> format that everyone could agree on, and would be easy to parse. I'm sure
> other programs could also benefit from this format (inventory tracking
> programs, perhaps).
>
> I think it should be text-based like the DAT file format.
>
> Just one of many possibilities:
>
> A line beginning with '0' would be a comment; for any other line, the first
> field would be the quantity of that part, the second field would be the
> DAT file name, the third field would be a color code (or color name). The
> fourth field would be an optional human-readable description that would
> usually be ignored by the parsers.
>
> Obviously we'd need to agree on a delimiter between fields. Spaces can be
> used, but if the color is specified by name, then it couldn't have spaces in
> it (e.g. dark gray).
>
> Comments?
|
|
Message is in Reply To:
![](/news/x.gif) | | Standardized Inventory File Format?
|
| Hello, I originally posted this idea in lugnet.cad.dev, and Jacob Sparre Andersen suggested I consult with the patrons of this group. For the Lego CAD program I'm developing, I got the idea for allowing users to load a set inventory file if they (...) (25 years ago, 18-Sep-99, to lugnet.db.inv)
|
25 Messages in This Thread: ![Standardized Inventory File Format? -Gary Williams (18-Sep-99 to lugnet.db.inv)](/news/x.gif) ![](/news/246.gif) ![Re: Standardized Inventory File Format? -Robert Munafo (22-Sep-99 to lugnet.db.inv)](/news/x.gif) ![](/news/246.gif) ![Re: Standardized Inventory File Format? -John Cromer (22-Sep-99 to lugnet.db.inv)](/news/x.gif) ![](/news/246.gif) ![Re: Standardized Inventory File Format? -Gary Williams (23-Sep-99 to lugnet.db.inv)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/268.gif) ![Re: Standardized Inventory File Format? -Steve Bliss (23-Sep-99 to lugnet.db.inv)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: Standardized Inventory File Format? -Robert Munafo (23-Sep-99 to lugnet.db.inv)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: Standardized Inventory File Format? -Steve Bliss (23-Sep-99 to lugnet.db.inv)](/news/x.gif) ![](/news/246.gif) ![Re: Standardized Inventory File Format? -Gary Williams (23-Sep-99 to lugnet.db.inv)](/news/x.gif) ![](/news/46.gif) ![Re: Standardized Inventory File Format? -Robert Munafo (23-Sep-99 to lugnet.db.inv)](/news/x.gif) ![](/news/246.gif) ![Re: Standardized Inventory File Format? -Steve Bliss (24-Sep-99 to lugnet.db.inv)](/news/x.gif) ![](/news/246.gif) ![Re: Standardized Inventory File Format? -Gary Williams (24-Sep-99 to lugnet.db.inv)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/268.gif) ![Re: Standardized Inventory File Format? -Larry Pieniazek (25-Sep-99 to lugnet.db.inv, lugnet.off-topic.fun)](/news/x.gif) ![](/news/246.gif) ![Re: Standardized Inventory File Format? -Tony Priestman (25-Sep-99 to lugnet.off-topic.fun)](/news/x.gif) ![](/news/46.gif) ![Re: Standardized Inventory File Format? -Larry Pieniazek (25-Sep-99 to lugnet.off-topic.fun)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: Standardized Inventory File Format? -Steve Bliss (27-Sep-99 to lugnet.off-topic.fun)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: Standardized Inventory File Format? -Robert Munafo (27-Sep-99 to lugnet.db.inv)](/news/x.gif) ![](/news/46.gif) ![Re: Standardized Inventory File Format? -Steve Bliss (28-Sep-99 to lugnet.db.inv)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: Standardized Inventory File Format? -Ran Talbott (22-May-00 to lugnet.db.inv)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/268.gif) ![Re: Standardized Inventory File Format? -Robert Munafo (23-Sep-99 to lugnet.db.inv)](/news/x.gif)
![](/news/x.gif) ![](/news/28.gif) ![](/news/x.gif) ![](/news/x.gif) ![](/news/68.gif) ![Re: Standardized Inventory File Format? -Ardjan Besse (25-Sep-99 to lugnet.db.inv)](/news/x.gif)
![](/news/x.gif) ![](/news/268.gif) ![Re: Standardized Inventory File Format? -Søren Bak (3-Oct-99 to lugnet.db.inv)](/news/x.gif) ![](/news/46.gif) ![Re: Standardized Inventory File Format? -Steve Bliss (4-Oct-99 to lugnet.db.inv)](/news/x.gif) ![](/news/46.gif) ![Re: Standardized Inventory File Format? -Søren Bak (4-Oct-99 to lugnet.db.inv)](/news/x.gif) ![](/news/46.gif) ![Re: Standardized Inventory File Format? -Steve Bliss (5-Oct-99 to lugnet.db.inv)](/news/x.gif)
![](/news/x.gif) ![](/news/68.gif) ![You are here](/news/here.gif)
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|