Printable Version of Topic

Posted by: Air_Cooled_Nut Dec 31 2003, 12:32 PM

Okay, I finally submitted my VIN to my profile. Are these automatically put into a database? If so, is there a way to access this database (searches or simple counts)?

I also looked at the http://www.914world.com/specs/productionnumbers.php and was surprised that less than 120,000 vehicles were produced! That's a lot less than what I expected and, in an elitest way, that's kinda neat that there aren't many around...poor man's close to the Miura

Funny, over 3 million VW Type III's were made but good luck finding new parts for it! Less than 120K 914's were made and parts (in particular, sheet metal and seals) are easy to find! Go figure

Posted by: SirAndy Dec 31 2003, 02:26 PM

yes, the VINs are in a database.
i could easily built a page where you can look them up/search ...

so, here's the question:

how would YOU (not just you, but all of us) like that page to function?


1) list all
2) list by year
3) ...

what else???

Andy

Posted by: Brad Roberts Dec 31 2003, 02:39 PM

List buy year and seperate the 9146 vin's is my vote.

It also depends on how you are going to deal with additions as time goes on. Will it be live updates ?


B

Posted by: SirAndy Dec 31 2003, 02:42 PM

yes, realtime updates.

Posted by: Gint Dec 31 2003, 02:44 PM

This all assumes of course that the members have entered legitimate VIN numbers in their controls.

Posted by: SirAndy Dec 31 2003, 02:46 PM

i can filter out bad one's fairly easy.
they all follow certain rules ...

Andy

Posted by: Brad Roberts Dec 31 2003, 02:50 PM

Yep. 914043 is pretty easy to filter and 47xxx should be easy also.


B

Posted by: boxsterfan Dec 31 2003, 03:14 PM

It would be cool if you could add a photo with the VIN.

Posted by: SirAndy Dec 31 2003, 11:24 PM

ok, i got a first draft up & running in the 914Info section (see menu on top of this page) ...

some of the VINs are WRONG or DOUBLE. everyone please check their VINs and correct as needed!

you can also go there by cklicking here:
http://www.914world.com/bbs2/index.php?act=VINs

NOTE: you need to be logged-in as a member to access this page.

lemmy know if this is enough or if we need to dress this up a bit,

HAPPY NEW YEAR
Andy

Posted by: biosurfer1 Dec 31 2003, 11:46 PM

i was searching for info on the vin numbers but couldnt find it, what do the numbers mean, for example mine: 4742900204

p.s. i like the vin database, found out mine was right around synthesisd's(4742900648)

Posted by: SirAndy Jan 1 2004, 12:07 AM

914/4:

example 4702912181 =

4 = Model Number (914)
70 = Year
29 = some say factory code (karmann) ?
12181 = # for that year

the "big book" lists the /4 as follows:
47 = Model Number (914)
02 = Year, 02 = 70, 12 = 71, 22 = 72, 32 = 73, 42 = 74, 52 = 75, 62 = 76
912181 = # for that year, ignoring the leading 9


914/6:

example 9140430097 =

914 = Model Number (914)
0 = Year (0 = 70, 1 = 71, 2 = 72)
4 = Key# for Engine, 4 = 2.0L, 6 Cyl., 110 HP
3 = Key# for Body, 3 = Roadster
0097 = # for that year

Posted by: Jeff Bowlsby Jan 1 2004, 12:13 AM

I always thought it was:

47= type 47 - as in what VWPorsche called our beloved beasts

0, 1, 2, 3, 4, 5, 6 = designating the model year i.e. 1=71, 6=76

The difference is in the meaning of the '7'

Can anyone confirm which way is correct?

Happy New Year!!! Jeff

Posted by: RustyWa Jan 1 2004, 02:28 AM

This "what does my VIN number mean" question comes up quite a bit...almost as much as "what tire size can I have if I want my speedo to be correct". Maybe on the VIN page or somewhere else, someone (Andy) can write a little program where a member can just add their VIN and it will parse all that info out for them and display it for all it's glory.....maybe??

Posted by: bernbomb914 Jan 1 2004, 02:58 AM

How do I input this Info? and where?

Bernie

Posted by: Brad Roberts Jan 1 2004, 03:01 AM

Bern,

go to the top of this page and go into "My controls" then go into "Edit profile"

You will see it there.


B

Posted by: bernbomb914 Jan 1 2004, 03:18 AM

Thanks Brad added two more

Bernie

Posted by: Brad Roberts Jan 1 2004, 03:19 AM

Thanks you Bern See you at Dunkles..


B

Posted by: bernbomb914 Jan 1 2004, 03:31 AM

When is it and has it moved?

Bernie

Posted by: Brad Roberts Jan 1 2004, 03:34 AM

Sunday Feb. 1st Same place.

B

Posted by: bernbomb914 Jan 1 2004, 03:47 AM

See you there

Bernie

Posted by: Jeff Bowlsby Jan 1 2004, 09:44 AM

The 914club VIN database is way cool Andy...

145 'member' 914 VINS are listed currently from around the world...

My recent analysis of the BAR database indicates about 7,000 to 8,000 914s should be surviving in California alone...

SO I WANNA KNOW WHERE ARE ALL THEY REST OF THEM HIDING!!!!????

Posted by: rdauenhauer Jan 1 2004, 04:45 PM

What about the section for known "destroyed" or crushed cars/VIN's?

Posted by: Bleyseng Jan 1 2004, 05:15 PM

Rich, thats known as "All others"


Geoff

Posted by: smrz914 Jan 1 2004, 08:09 PM

could we add locations like city state for the cars, that way we can see who is in our area? Then I was thinking that if you click on the title of the column it puts it in order for that title. i.e. you click on 914/6 or 914/4 and they are put in order buy the actual number. Or if you click on member then they are but in order by the member name...etc. Then there could be one for location.

Posted by: Chris914n6 Jan 2 2004, 01:49 AM

Andy, that's cool.

Is a section for condition too much? Restored, driver, parts car, recycled, wrecking yard...

Chris

Posted by: RON S. Jan 2 2004, 10:46 AM

Hey Andy,
I noticed my VIN#listed twice in your data base.
Someone under the name type11969.?
This is#9140430841.Says so on the vin plate,fenderwell,+
my C.O.A.
Ain't no way anyone else has that # legitimately.
Ron


Attached image(s)

Posted by: SirAndy Jan 2 2004, 04:31 PM

yepp, there are a bunch of "doubles" in there. i figured it was people with more than one account.
if not, i suggest you contact that person through PM or email.

maybe he just made a mistake ...
Andy

Posted by: richardL Jan 2 2004, 08:20 PM

If we could get Rich at HPH to put in the VINs of all the parted cars he has there it would account for a fair percentage of them...

Richard

Posted by: Air_Cooled_Nut Jan 3 2004, 12:48 AM

Didn't think this would generate such a response! What you've done is fine with me, thanks!!!! (I just came back from New Year's Eve w/my sweetie so I've been out of touch these last couple days...)

Posted by: Carl Jan 3 2004, 01:48 AM

Shotgun and I have the same VIN because Shotgun is Meredith and she's my shotgun.


C

Posted by: Andyrew Jan 3 2004, 01:55 AM

I put my # in.. it doesnt show..

Andrew

Posted by: Brad Roberts Jan 3 2004, 02:17 AM

I lied. It is live. I added 9140430004 and it posted imediately.


B

Posted by: Jeff Bowlsby Jan 3 2004, 10:37 AM

Jenny has a six now???

91456813812 ???

Posted by: Gint Jan 3 2004, 10:40 AM

When a new member registers, or an old member changes their VIN, the php script loads it into the db. Every time you load the VIN page, the php script queries the db.

So it's essentially live.