Re: Dealer List

Posted by BigKev On 2009/8/13 17:19:32

For those that are going to participate with this worthy project I ask that you follow a couple of rules so that information will be more complete and the database will be happy.

1) Please enter the Dealer Name in Title Case, and with the same spacing and punctuation as it is written on the source document (not with all lower case or upper). Same goes with City. So for example L.R. Brown, not LR BROWN, or l.r. brown, or l.r. Brown. This helps the database to link entires for the same dealer together without extended filtering.

2) Please use the correct 2 letter upper case abbreviation for US states.

3) Please enter Years Of Reference (YOR) as XXXX format. 1899, 1934, 1956 etc

4) Please do not add an extraneous special characters to the entry. The SQL (database) insert statements do like single and double quotes. So stay away from them if possible. (Help to reduce the amount of pre-filtering that has to be done)

5) If you have two (or more) reference points for the same dealer, then please add those as separate entries. So for example if you have a dealer reference for 1934, and that same dealer for 1955. The add those as two separate entries with different YORs. This lets the database work it's magic as it has multiple points of references for that dealer. Also if you have two different address for the same dealer, then please add those as separate entries. This with the YOR can allow me to build a time line history for a dealer.