[DeTomaso] database information

[GR2835 at comcast.net]

Michael, 
Yea, did some research for our family tree and found that the 1940 census to be useless compared with what they use today. The objective then was to just meet the Constitutional requirement not all the political and development needs of today. 
It would be helpful if I knew what items you are planning to collect then I can add to it rather than the other way around. Perhaps it would be better if I were to write directly to your web designer. Who is he/she? 
Moreover, I can compare your current design with what was planned the last time in in effort to make certain that all of the bases is covered. I was given tons of page formats back then but none of the actual data elements for the relational db. 
Please send me your designer's email address to begin the review process and set about planning the upload programs. 
Best regards, 
Rod 

Date: Mon, 28 Mar 2016 21:02:46 -0400 From: michaelsavga at gmail.com 
To: rkunishige at hotmail.com 

It is still being developed but it is basically a survey like a US Census, In every category with choices, you simply select the one that applies to your car. 

For the hard facts like VIN, you just enter the information. 
You're right, 100% stock is a unicorn. 

I sold/brokered a 6,000 mile 1971 last fall, it was close. The sad part was that it had spent the last 38 years locked in a garage by a weirdo, 

He had 3 Panteras, a 66 Shelby GT350 and a Bill Blass Lincoln, none had been driven in over 30 years, he died at age 70, 

What kind of nut locks up that kind of hardware at age 40. 
If you have a list of known differences, please send them to me, we might be missing something. 
Thanks, Michael 
On Mar 28, 2016 8:51 PM, "Rod Kunishige" < rkunishige at hotmail.com> wrote: 


Since the original designer did not consider knowing the sequence of ownership as important, it is not possible to do so easily. Some fancy programming may produce a best guess but it would be very unreliable. This is just one example of not anticipating or at least making sure that flexibly is built into the design to accommodate future needs. 
Additionally, you may want to keep old/lapse members on file in the servers (rather than off-line as you said) so as to handle renewals and transfers to family members with ease. Actual costs of online storage is peanuts compared to when I began in 1965. 
I'm impressed with your comment on metrics and would like to know how you designed the db for all the specialized custom modifications that our Panteras are known to have? My 15 years in this club I have NEVER uncovered a pure 100% stock Pantera. Even the last "barn find" for TPOC was modified. 

Date: Mon, 28 Mar 2016 19:32:48 -0400/from: michaelsavga at gmail.comTo: rkunishige at hotmail.com 

Rod, 
We are building the official Pantera Registry, Chuck turned down the opportunity to work with us on it. 

We are working with MarrtiReports as well, he retained all the Ford Motor Company Records that were not destroyed. 

Our Registry will be superior in every way with 75 metrics per car to track every conceivable manufacturing difference. 

Things as obvious as flat deck vs ribbed deck, 2 AC vents or 3, Screened or Solid engine cover, indide or outside fuel fill, two spoke vs Capri style wheel, vertical seats pleats vs Horizontal seat pleats, 

Original color, Current Color, riggt down to which style of Tool Roll came with the car ( There were 3). 

I created the Shortt List, which tracks our cars by color, dates of manufacturer, import and the DSO. 
If your DB has years of records of who owned each VIN prior to the current owner, that would be a very worthy contribution on your part to the Registry effort, and outstanding addition. 
I am not empowered to allow you to share our intellectual property, nor would I vote for sharing it outside our control. 
I do not wish to lose any information, we can easily send you a flash drive or a portable hard drive to archive this very valuable part of our history. If you thought that I simply wanted it trashed, I was unclear and apologize. 

I value our history more than most, but also realize how modern DB work in a Registry. Ours will surpass those used by Ferrari, Shelby and even the Mustang Club. 

I hope that we can reach the fanatical detail of the Sunbeam Tiger folks, they really know their cars and strangely, there were about the same number of Tigers and Panteras built. 

Must be something about cats. 
Michael 
On Mar 28, 2016 6:34 PM, "Rod Kunishige" < rkunishige at hotmail.com> wrote: 


Michael, 
Judy sends the entire db to your web guy each month. Thus, you already have everything. 
It would be more than 200 rejected emails if the list was not restricted to only active members or was improperly loaded. Further, I don't think that all the update information ever reached Judy thus insuring an inaccurate db. 
I differ with you on only keeping current member information. Given your position, I hereby ask that I be granted approval to share POCA data with Chuck Melton for his registry. The history stored in Judy's db is too important to lose. 
May I? 
I stand ready to write any program you deem necessary. 
Regards, Rod 


From: michaelsavga at gmail.comDate: Mon, 28 Mar 2016 17:47:02 -040 To: rkunishige at hotmail.com 

Rod, thanks, 
I just need information, the old DB will be trashed, making it work is not an option or even desired. 
the new website will do so much more, every member will have their own page and be able to update their own information 
and we will be able to send out blasts, invoices and collect dues online. 
anything that does not apply to the current membership is useless and can be saved on a hard disk, 
I simply need every possible field of useable information. 
names, address, city, state, zip home, work, cell, email, car number, membership munber, date of first joining, when they last paid dues, when they are paying dues again nextbirthdate, spouse, assoiates member, 
anything that can fit in a category and be put in a column would be great. 
as far as the current list, it is 25% wrong already, 
over 200 emails have been rejected from the lastest emails sent. 
I really appreciate what you are trying to do to help, you have no idea how much. 
we need to rag everything we have up to 2016 and make it useful to the club, anything that only one or two people can use, is useless 
Please help me save this club before it fades away, communication is the most important thing we have, 
if we can not engage the members , we are doomed. 
Thanks, 
Michael 

On Mon, Mar 28, 2016 at 5:09 PM, Rod Kunishige < rkunishige at hotmail.com> wrote: 


Michael, 
The POCA database is an extensive RELATIONAL DB. It is structured with many combinations of data all related in a dynamic way. It simply can not be conceived as a single spreadsheet. Items within, for instance, may be easily pictured as car data that is related to multiple prior owners. There are many of these to consider. To replace the entire db demands a thorough understanding of all of the relationships possible. This is largely why all of the prior attempts to develop a web based replacement has failed utterly. 
Judy is the only one left who has the most knowledge of how this db functions today. NO ONE understands it fully. 
I promise you that without understanding its history and, more importantly, conceive all of its present and FUTURE requirements eliminating this db will fail!!!!!!!!!!! 
Now, let's get back to the two objectives that started this conversation. First, the email list. What will you do with it? What is the short list of fields you'd like? And, is Excel format acceptable? Second, do you want a directory or not? If so, what are the specifications? What is the intended destination? 
Michael, I am willing to help in every way I can, but let's not waste everyone's time. 
Best regards, 
Rod 
-------------- next part --------------
   Michael,
   Yea, did some research for our family tree and found that the 1940
   census to be useless compared with what they use today.  The objective
   then was to just meet the Constitutional requirement not all the
   political and development needs of today.
   It would be helpful if I knew what items you are planning to collect
   then I can add to it rather than the other way around.  Perhaps it
   would be better if I were to write directly to your web designer.  Who
   is he/she?
   Moreover, I can compare your current design with what was planned the
   last time in in effort to make certain that all of the bases is
   covered.  I was given tons of page formats back then but none of the
   actual data elements for the relational db.
   Please send me your designer's email address to begin the review
   process and set about planning the upload programs.
   Best regards,
   Rod
   Date: Mon, 28 Mar 2016 21:02:46 -0400 From: michaelsavga at gmail.com
   To: rkunishige at hotmail.com
   It is still being developed but it is basically a survey like a US
   Census, In every category with choices, you simply select the one that
   applies to your car.
   For the hard facts like VIN, you just enter the information.
   You're right, 100% stock is a unicorn.
   I sold/brokered a 6,000 mile 1971 last fall, it was close. The sad part
   was that it had spent the last 38 years locked in a garage by a weirdo,
   He had 3 Panteras,  a 66 Shelby GT350 and a Bill Blass Lincoln, none
   had been driven in over 30 years, he died at age 70,
   What kind of nut locks up that kind of hardware at age 40.
   If you have a list of known differences, please send them to me, we
   might be missing something.
   Thanks, Michael
   On Mar 28, 2016 8:51 PM, "Rod Kunishige" <rkunishige at hotmail.com>
   wrote:
   Since the original designer did not consider knowing the sequence of
   ownership as important, it is not possible to do so easily.  Some fancy
   programming may produce a best guess but it would be very unreliable.
   This is just one example of not anticipating or at least making sure
   that flexibly is built into the design to accommodate future needs.
   Additionally, you may want to keep old/lapse members on file in the
   servers (rather than off-line as you said) so as to handle renewals and
   transfers to family members with ease.  Actual costs of online storage
   is peanuts compared to when I began in 1965.
   I'm impressed with your comment on metrics and would like to know how
   you designed the db for all the specialized custom modifications that
   our Panteras are known to have?  My 15 years in this club I have NEVER
   uncovered a pure 100% stock Pantera.  Even the last "barn find" for
   TPOC was modified.
   Date: Mon, 28 Mar 2016 19:32:48 -0400/from: michaelsavga at gmail.comTo:
   rkunishige at hotmail.com
   Rod,
   We are building the official Pantera Registry, Chuck turned down the
   opportunity to work with us on it.
   We are working with MarrtiReports as well, he retained all the Ford
   Motor Company Records that were not destroyed.
   Our Registry will be superior in every way with 75 metrics per car to
   track every conceivable manufacturing difference.
   Things as obvious as flat deck vs ribbed deck, 2 AC vents or 3,
   Screened or Solid engine cover, indide or outside fuel fill, two spoke
   vs Capri style wheel, vertical seats pleats vs Horizontal seat pleats,
   Original color, Current Color, riggt down to which style of Tool Roll
   came with the car ( There were 3).
   I created the Shortt List, which tracks our cars by color, dates of
   manufacturer, import and the DSO.
   If your DB has years of records of who owned each VIN prior to the
   current owner, that would be a very worthy contribution on your part to
   the Registry effort, and outstanding addition.
   I am not empowered to allow you to share our intellectual property, nor
   would I vote for sharing it outside our control.
   I do not wish to lose any information, we can easily send you a flash
   drive or a portable hard drive to archive this very valuable part of
   our history. If you thought that I simply wanted it trashed, I was
   unclear and apologize.
   I value our history more than most, but also realize how modern DB work
   in a Registry. Ours will surpass those used by Ferrari, Shelby and even
   the Mustang Club.
   I hope that we can reach the fanatical detail of the Sunbeam Tiger
   folks, they really know their cars and strangely, there were about the
   same number of Tigers and Panteras built.
   Must be something about cats.
   Michael
   On Mar 28, 2016 6:34 PM, "Rod Kunishige" <rkunishige at hotmail.com>
   wrote:
   Michael,
   Judy sends the entire db to your web guy each month.  Thus, you already
   have everything.
   It would be more than 200 rejected emails if the list was not
   restricted to only active members or was improperly loaded.  Further, I
   don't think that all the update information ever reached Judy thus
   insuring an inaccurate db.
   I differ with you on only keeping current member information.  Given
   your position, I hereby ask that I be granted approval to share POCA
   data with Chuck Melton for his registry.  The history stored in Judy's
   db is too important to lose.
   May I?
   I stand ready to write any program you deem necessary.
   Regards, Rod
   From: michaelsavga at gmail.comDate: Mon, 28 Mar 2016 17:47:02 -040 To:
   rkunishige at hotmail.com
   Rod, thanks,
   I just need information, the old DB will be trashed, making it work is
   not an option or even desired.
   the new website will do so much more, every member will have their own
   page and be able to update their own information
   and we will be able to send out blasts, invoices and collect dues
   online.
   anything that does not apply to the current membership is useless and
   can be saved on a hard disk,
   I simply need every possible field of useable information.
   names, address, city, state, zip home, work, cell, email, car number,
   membership munber, date of first joining, when they last paid dues,
   when they are paying dues again nextbirthdate, spouse, assoiates
   member,
   anything that can fit in a category and be put in a column would be
   great.
   as far as the current list, it is 25% wrong already,
   over 200 emails have been rejected from the lastest emails sent.
   I really appreciate what you are trying to do to help, you have no idea
   how much.
   we need to rag everything we have up to 2016 and make it useful to the
   club, anything that only one or two people can use, is useless
   Please help me save this club before it fades away, communication is
   the most important thing we have,
   if we can not engage the members , we are doomed.
   Thanks,
   Michael
   On Mon, Mar 28, 2016 at 5:09 PM, Rod Kunishige <rkunishige at hotmail.com>
   wrote:
   Michael,
   The POCA database is an extensive RELATIONAL DB.  It is structured with
   many combinations of data all related in a dynamic way.  It simply can
   not be conceived as a single spreadsheet.  Items within, for instance,
    may be easily pictured as car data that is related to multiple prior
   owners.  There are many of these to consider.  To replace the entire db
   demands a thorough understanding of all of the relationships possible.
    This is largely why all of the prior attempts to develop a web based
   replacement has failed utterly.
   Judy is the only one left who has the most knowledge of how this db
   functions today.  NO ONE understands it fully.
   I promise you that without understanding its history and, more
   importantly, conceive all of its present and FUTURE requirements
   eliminating this db will fail!!!!!!!!!!!
   Now, let's get back to the two objectives that started this
   conversation.  First, the email list.  What will you do with it?  What
   is the short list of fields you'd like?  And, is Excel format
   acceptable?  Second, do you want a directory or not?  If so, what are
   the specifications?  What is the intended destination?
   Michael, I am willing to help in every way I can, but let's not waste
   everyone's time.
   Best regards,
   Rod