To LUGNET HomepageTo LUGNET News HomepageTo LUGNET Guide Homepage
 Help on Searching
 
Post new message to lugnet.admin.databaseOpen lugnet.admin.database in your NNTP NewsreaderTo LUGNET News Traffic PageSign In (Members)
 Administrative / Database / *920 (-20)
  Re: McDonalds 1999 promo sets in set reference ?
 
Todd Lehman <lehman@javanet.com> wrote in message news:G1K6xG.HpK@lugnet.com... (...) That was my conclusion also. (...) Single unit Huw (24 years ago, 28-Sep-00, to lugnet.general, lugnet.admin.database, lugnet.promo)
 
  Re: McDonalds 1999 promo sets in set reference ?
 
(...) Ahh, good show! OK, so the last 7 digits then must be the standard LEGO 7-digit product number thingum? (Do the last 7 digits occur as a single unit or are they separated by periods or commas? Just curious; IIRC, LEGO has done it both ways.) (...) (24 years ago, 27-Sep-00, to lugnet.general, lugnet.admin.database, lugnet.promo)
 
  Re: McDonalds 1999 promo sets in set reference ?
 
"Todd Lehman" <lehman@javanet.com> wrote in message news:G1IGBA.1rJ@lugnet.com... (...) numbers (...) I have used those numbers at Brickset. They are the first 4 digits of a 4+7 number printed on the top left of each sheet. #8 = 2025 (24 years ago, 27-Sep-00, to lugnet.general, lugnet.admin.database, lugnet.promo)
 
  Are there plans to link up the inventories of sets to the set Guide?
 
I am asking because I have a few sets I wanted to check.. (+some that I could provide inventories for..(mainly 1999/2000 sets though :- ( ) I find it eaiser to search for the set in the set guide's taxonimy than in the inventories one. (The (...) (24 years ago, 27-Sep-00, to lugnet.admin.database)
 
  Re: McDonalds 1999 promo sets in set reference ?
 
(...) I can't find the polybag for #8, but I did find the instruction sheet. Based on comparing the other sheets and polybags, I think the number is also coded on the instruction sheet. So... 2025 - McD's 1999 promo set #8 Ray (24 years ago, 26-Sep-00, to lugnet.general, lugnet.admin.database, lugnet.promo)
 
  Re: McDonalds 1999 promo sets in set reference ?
 
(...) Neat-o! Anyone know how "official" those numbers are? Can anyone confirm them or 'splain what part of the coding contained them? Anyone know what #8 says? It's encouraging that none of the numbers shown above have been used before for sets (to (...) (24 years ago, 26-Sep-00, to lugnet.general, lugnet.admin.database, lugnet.promo)
 
  Re: CSV delimiters
 
(...) Dang. THAT is a very important piece of info -- thanks! OK... Are there any popular programs out there (on the level of Excel, etc.) which only handle CSV text and don't handle tab-delimited text data? --Todd (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
 
  Re: CSV delimiters
 
Todd Lehman skrev i meddelandet ... (...) I see in the thread that you've got most of the answers you need, but there is at least one complication in the Windows world (if you ever get files from that): The MS programs (and many others too, as (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
 
  Re: CSV delimiters
 
(...) Aha! Excellent. Those docs sound well thought out. Hmm, that reminds me... Duh, this is prolly a common Perl thing. I bet Freidl[1] as some stuff on CSV? Lessee... <dig dig dig> Ahh, here we go: pp. 204-208, 227, 231, 290. And (haha!) it even (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
 
  Re: CSV delimiters
 
Maybe this will also be helpful. It's not exactly a standard, but it is IEEE. :) (URL) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
 
  Re: CSV delimiters
 
There exists (in CPAN) a Text-CSV perl module. From its documentation: This module is based upon a working definition of CSV format which may not be the most general. 1 Allowable characters within a CSV field include 0x09 (tab) and the inclusive (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
 
  Re: CSV delimiters
 
(...) I remember looking for this about a year ago, and I came across something that looked very standardish. If I remember right, it's really silly. You don't actually escape things. Fields are comma separated, and optionally surrounded by (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
 
  Re: CSV delimiters
 
(...) I think there are a variety of CSV-to-HTML-table converters floating around that you can download -- I saw at least 3 earlier while searching before posting. You'd probably want to look for one that somehow auto-sensed whether quotes were (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
 
  RE: CSV delimiters
 
(...) I agree. I was trying to hack an Excel file into some usable html, and those "" made it nearly impossible for me to do search and replaces to get valid html without messing it up in other places. --Bram Bram Lambrecht BXL34@po.cwru.edu (URL) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
 
  Re: CSV delimiters
 
(...) Eeek -- shame on me -- did I just say "it's" when I meant "its"? Anyway, I forgot to say: The idea of escaping quotes is *bizarre* in the first place. IMHO, there shouldn't *be* any closing double-quote character on a field once it has already (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
 
  Re: CSV delimiters
 
(...) I hate it too. IIRC, Excel uses "" instead of \" for an escaped " -- but I could be wrong. I just remember hating it once when I looked at it. :) One nice thing, though, is that Excel can import tab-delimited text, so that's it's saving grace. (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
 
  RE: CSV delimiters
 
(...) Sorry, I can't help. And I hate the way Excel outputs in plain text. But since it's 2:30 in the morning, I'll make useless comments. Sounds like you're working on the question I asked...augh, and I just entered all the sets manually. Oh well, (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
 
  CSV delimiters
 
Is there any "official" or "reasonably standardized format" for CSV (_C_omma _S_eparated _V_alue) data? I guess it's pretty obvious, mostly, but how are the delimiter characters typically encoded (specifically: comma, double-quote, and newline)? In (...) (24 years ago, 23-Sep-00, to lugnet.admin.database, lugnet.off-topic.geek, lugnet.publish)
 
  Re: compiled / searchable parts database with links to the set guide?
 
(...) This is great! Todd: How about linking the element count in the set guide to the corresponding inventory page on dands site? KL (...) (24 years ago, 22-Sep-00, to lugnet.db.inv, lugnet.admin.database)
 
  Re: compiled / searchable parts database with links to the set guide?
 
(...) the biggest thing everyone should agree on is the nameing convention... We used partsref and partid for ours, which seemed to be the most complete and easy to use convention... All the rest is really easy to transform, from one format to (...) (24 years ago, 22-Sep-00, to lugnet.db.inv, lugnet.admin.database)


Next Page:  5 more | 10 more | 20 more

Redisplay Messages:  All | Compact

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