To LUGNET HomepageTo LUGNET News HomepageTo LUGNET Guide Homepage
 Help on Searching
 
Post new message to lugnet.db.invOpen lugnet.db.inv in your NNTP NewsreaderTo LUGNET News Traffic PageSign In (Members)
 Database / Set Inventories / 173
172  |  174
Subject: 
Re: Standardized Inventory File Format?
Newsgroups: 
lugnet.db.inv
Date: 
Wed, 22 Sep 1999 21:16:23 GMT
Viewed: 
410 times
  
In lugnet.db.inv, Gary Williams writes:
[...]
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).

I solve that problem by using *3 or more spaces* as the delimiter. If you want
to delimit the next field, you must always use at least 3 spaces in a row. This
allows things like color names to include spaces and allows for a little human
error as well.

My format also allows the use of " (a double quote) to mean "this field has the
same value as the corresponding field of the previous line". That makes it a
little easier to type in the inventories.

- Robert Munafo                           http://www.mrob.com/
  LEGO: TC+++(8480) SW++ #+ S-- LS++ Hsp M+ A@ LM++ YB64m IC13



Message has 2 Replies:
  Re: Standardized Inventory File Format?
 
(...) This (...) Let's do it. 3 spaces between fields: count DATfilename Color Optional description Now, not being a CAD nut, where would I find the DATfilenames? And what do we put for parts without DATfilenames? as evah, John C. (25 years ago, 22-Sep-99, to lugnet.db.inv)
  Re: Standardized Inventory File Format?
 
(...) Are there many programs that support multi-character delimiters in their import function? I'm fairly certain Excel and MS-Access do not. The point of making a standard format is to make the data more accessible to everyone. Not just coders. I (...) (25 years ago, 23-Sep-99, to lugnet.db.inv)

Message is in Reply To:
  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:












Entire Thread on One Page:
Nested:  All | Brief | Compact | Dots
Linear:  All | Brief | Compact

This Message and its Replies on One Page:
Nested:  All | Brief | Compact | Dots
Linear:  All | Brief | Compact
    

Custom Search

©2005 LUGNET. All rights reserved. - hosted by steinbruch.info GbR