Re: Dealer List

Posted by BigKev On 2009/8/13 16:16:35

How about this so it can be attacked from multiple angles. We come up with a basic excel file spreadsheet that list the following field columns:

Dealer Name, City, State, Country, Address1, Address2, Zip, YearOfReference, DealerOwner, Notes


Anything that doesn't fit into the above field columns goes into Notes as a catch all. Dealer Name, City, and State, Country are required. All other fields optional. Address1 & Address2 are for a two line street address, not two different addresses. YearOfReference is the the year publication of the source material that dealer was listed in.

Now once that spreadsheet template is built, we add it to this thread as an attachment, and everyone can download a blank copy of it. Then independently, everyone that wants to work on this project can add as many dealers as they can find in their own respective Packard literature, service manual, STBs Letters, Users Manuals, etc to their copy of the template. When they are done, they send their spreadsheet to whomever is going to be the Master list keeper, and that person merges all separate copies into a master list (which is easy to do in Excel if all the templates are the same structure) Then it's real easy to purge or merge duplicates and start to build a picture. Then from that I can import them into the database and go to town on it.