Tracking All Currently Known US VIN and Window Stickers - Order Tracking Thread

[MikeySoft]

Originally Posted by UCF w00t

If it hasn't already shown up, it's not going to now. Yours was built far too long ago. If you're just looking for information, dealers can lookup your VIN in the GMVIS system and pull up lots of info on it.

The window sticker page only works from approximately the time it ships to the time the customer takes delivery. If the window sticker page is blank it either means the vin you supplied is not a valid VIN or it hasn't shipped/invoiced yet or it's already been delivered to the customer.

The script that captures the info for my site is not perfect. It just loads the window sticker page for each potentially valid VIN and if it works, it inserts it into the database. Sometimes the page will timeout when trying to load so the VIN may be up but my script will fail to get it. The big problem is that I can't scan every possible VIN every day, it would just be far, far too many and would take too long and be too much load on both my system and GM's. So I scan the last few hundred possible and the next 500 possible. This would work pretty well if GM put the window sticker pages in order. But they don't. It might take one day for it to show up or it might take two weeks. I simply can't scan that large of a range To help remedy this, I run a scan once a week that does a much wider range to hopefully pick up those stragglers that got missed the first time around. We also don't have the ability to pull info on Canadian cars as they use a different website and last I checked, they aren't making their Camaro info available. So yes, some get missed. But there really isn't much we can do about it.

Are you the MAKER? (The Creator of this amazing Database)?????????

If you are....... We are not worthy....

(Can you give me an idea of what your using to get this process done?)

One IT guy to another?

[UCF w00t]

Originally Posted by MikeySoft

Are you the MAKER? (The Creator of this amazing Database)?????????

If you are....... We are not worthy....

(Can you give me an idea of what your using to get this process done?)

One IT guy to another?

Yea. Sit down before you continue reading. Might make you sick lol.

Each day I have a scheduled task that runs at 7am (I think that's what I set it to) that runs a C# console app that loops through every possible VIN in the potential range and hits the window sticker page for that VIN. If the page works and has info, I then parse through the text (it's just html, not something nice like XML) and grab all the info. It was pretty painstaking to get this working right and there's still some issues where it's not perfect but it does the trick. It then inserts the data into a MS SQL server database table and moves on to the next VIN. It's pretty ghetto but there's not really a much better way to do it since GM doesn't make it easy. The web page is just a asp.net page using the AJAX extensions and a gridview to pull the data from the table.

[oldag92]

Thanks for the info. I do have a question. If mine was made long ago, and just got to the dealer last Friday or so, is there a quick and easy way to find out why? I'm wondering if it was held up in QC forever or something.

Vin 2G1FC1EV5A9104155

[UCF w00t]

Originally Posted by oldag92

Thanks for the info. I do have a question. If mine was made long ago, and just got to the dealer last Friday or so, is there a quick and easy way to find out why? I'm wondering if it was held up in QC forever or something.

Vin 2G1FC1EV5A9104155

Yours is one of the early ones that was put in Area 51 I guess. Theres a thread about those.

Oh and the site will be going down for a little while this evening. Maybe a few hours. Gotta move the "server".

[MikeySoft]

Originally Posted by UCF w00t

Yea. Sit down before you continue reading. Might make you sick lol.

Each day I have a scheduled task that runs at 7am (I think that's what I set it to) that runs a C# console app that loops through every possible VIN in the potential range and hits the window sticker page for that VIN. If the page works and has info, I then parse through the text (it's just html, not something nice like XML) and grab all the info. It was pretty painstaking to get this working right and there's still some issues where it's not perfect but it does the trick. It then inserts the data into a MS SQL server database table and moves on to the next VIN. It's pretty ghetto but there's not really a much better way to do it since GM doesn't make it easy. The web page is just a asp.net page using the AJAX extensions and a gridview to pull the data from the table.

DUDE! Clearly we are not worthy...

Ok so you know I'm a SuperMicro Disty, Intel Direct, Gigabyte Disty, and X Microsoft, Bla Bla Bla. In fact I'm 3 miles from Intel. If you ever need anything.... give me a call. Hardware is the sea I flounder in. We build servers that makes the whole world Sing......

What are you running to make this process sing?

[UCF w00t]

Originally Posted by MikeySoft

DUDE! Clearly we are not worthy...

Ok so you know I'm a SuperMicro Disty, Intel Direct, Gigabyte Disty, and X Microsoft, Bla Bla Bla. In fact I'm 3 miles from Intel. If you ever need anything.... give me a call. Hardware is the sea I flounder in. We build servers that makes the whole world Sing......

What are you running to make this process sing?

Hardware wise?

Brace yourself...

My old Dell "centrino" based laptop (pre-core) sitting in my room. Has like 1gb of ram. It's a bit slow but it does the job.

Software is Windows Server 2008 with SQL 2008.

[joerod97]

Woot ......hUH?? I applaud you and your tireless work on allthe info that you get for us who are not worthy .I speak for all Thank You!!

[lmeagle]

Originally Posted by UCF w00t

It was supposed to be at the rail yard last night. Which means it won't be at the dealership til today at the earliest (assuming it actually did get there last night). It's not up on the AAG site so who knows.

Oh and here's your latest...

Hey how do you get this type of information. I am working with my dealer managment but have not seen any actual document. You might notice my thread about my car getting misrouted to a dealership in CA. (My dealership is in Omaha, NE) http://www.camaro5.com/forums/showthread.php?t=30380

I would sure like to see a transportation record.

[Pottymouth_girl82]

WOO HOO Picked up my car today...Im in love! Only thing is my stripes werent in yet, its gonna be hard to leave it there for a day when they do get in!!!

[UCF w00t]

Originally Posted by lmeagle

Hey how do you get this type of information. I am working with my dealer managment but have not seen any actual document. You might notice my thread about my car getting misrouted to a dealership in CA. (My dealership is in Omaha, NE) http://www.camaro5.com/forums/showthread.php?t=30380

I would sure like to see a transportation record.

The info I posted before was from the AAG site. They should be able to sign up there. What's your VIN? I can see if there's anything there for your car. Often times it doesn't show up in their system til it's in their possession and they often just deliver it from the rail yard to the dealership.

Originally Posted by NativeTexan

WFC w00T,

I found my vin on spasticsquirrel before my dealer called me, but I knew I would. I don't know if the dealers are misinformed or just deliberately misleading, but I just wanted to say thanks for the database and other information that you have helped us with. I would have literally gone insane without it.

I tend to think it's just incompetence. Glad it helped

[impatient]

I dont see that you have your car yet UFC wOOt, thats too bad it would have been great to have it for this long weekend. Do they deliver cars on holidays and weekends to dealers?

[UCF w00t]

Originally Posted by impatient

I dont see that you have your car yet UFC wOOt, thats too bad it would have been great to have it for this long weekend. Do they deliver cars on holidays and weekends to dealers?

Not so fast my friend!


AAG now has it. They should be sending it to the dealer today or tomorrow.

[MikeySoft]

Originally Posted by UCF w00t

Hardware wise?

Brace yourself...

My old Dell "centrino" based laptop (pre-core) sitting in my room. Has like 1gb of ram. It's a bit slow but it does the job.

Software is Windows Server 2008 with SQL 2008.

DELL?????? Yea, I don't do Ghetto.
I'm a System Builder, Everything we do is DOD and Gov. Standards. Only the Best. Esp. when it comes to Notebooks. Can't put stuff like that in Schools, Muni, Gov.

SAY WHAT?????? Your Running SERVER 08 W/SQL on a DELL NOTEBOOK?



We need to talk.

[UCF w00t]

Originally Posted by MikeySoft

DELL?????? Yea, I don't do Ghetto.
I'm a System Builder, Everything we do is DOD and Gov. Standards. Only the Best. Esp. when it comes to Notebooks. Can't put stuff like that in Schools, Muni, Gov.

SAY WHAT?????? Your Running SERVER 08 W/SQL on a DELL NOTEBOOK?



We need to talk.

Hah, I know. It's called using what's available to ya.