Author Topic: Spec and Options Popularity  (Read 28538 times)

Offline Gung-Ho

  • Here all the time
  • ****
  • Posts: 442
Re: Spec and Options Popularity
« Reply #50 on: 13 May 2013, 18:08 »
Nice work 'Bear' but I'm really struggling to keep up with you... You wouldn't be related to Gary McKinnon by any chance? :grin:

You're obviously a computer genius... Any chance of manipulating our build dates to come forward on the system?  :grin:
Current Toys: Mk7 Golf R 5dr 'Manual', Lapiz Blue, 18" Cadiz Alloys... Caterham R300 Superlight... new Mazda MX5 2.0 SE-L (ND)

Offline matchboy

  • I live here
  • *****
  • Posts: 3,160
Re: Spec and Options Popularity
« Reply #51 on: 13 May 2013, 18:14 »
I'm a professional and I have no idea what you are talking about - but I like it! I look forward to the upload!!
Audi RS5 2018
Gone: BMW M4 LCI Competition Package
Previous: Mk 3 Audi TTS, Porsche 981 Cayman S, Mk 7 Golf R, Mk 7 GTI, Mk 6 GTI, Mk 5 GTI and so on....

Offline Sootchucker

  • I live here
  • *****
  • Posts: 2,348
Re: Spec and Options Popularity
« Reply #52 on: 13 May 2013, 19:14 »
Are you hacking VW then  :grin:

It'll me the MOD or the CIA next  :laugh: :laugh:
2022 Tiguan R-Line 2.0 TSI 4-Motion. Nightshade blue, pano roof, IQ lights, Nav Pro, Harmon Kardon, Heated Windscreen, Heated rear seats, Wireless charging, Heads up display, dual height boot floor, Keyless with electric tailgate, Electronic TPMS, underbody protection, Area View Cameras

Offline Bill_the_Bear

  • I live here
  • *****
  • Posts: 2,038
  • Yes! Wait a minute... No!
Re: Spec and Options Popularity
« Reply #53 on: 13 May 2013, 19:31 »
Are you hacking VW then  :grin:

It'll me the MOD or the CIA next  :laugh: :laugh:

I think hacking would require that they actually have some kind of security to hack... which they do not.  :tongue:

Don't tell them, this is good for us.

Offline matchboy

  • I live here
  • *****
  • Posts: 3,160
Re: Spec and Options Popularity
« Reply #54 on: 13 May 2013, 19:59 »
Are you hacking VW then  :grin:

It'll me the MOD or the CIA next  :laugh: :laugh:

I think hacking would require that they actually have some kind of security to hack... which they do not.  :tongue:

Don't tell them, this is good for us.

What are you doing on here?! Get to it!!  :laugh:
Audi RS5 2018
Gone: BMW M4 LCI Competition Package
Previous: Mk 3 Audi TTS, Porsche 981 Cayman S, Mk 7 Golf R, Mk 7 GTI, Mk 6 GTI, Mk 5 GTI and so on....

Offline Bill_the_Bear

  • I live here
  • *****
  • Posts: 2,038
  • Yes! Wait a minute... No!
Re: Spec and Options Popularity
« Reply #55 on: 13 May 2013, 21:39 »
What are you doing on here?! Get to it!!  :laugh:

Ok chaps, I've really no idea if this will work.  There are some disclaimers:
  • The code is awful.  Truly awful.  I know I can clean it up hugely and probably change it completely to make it more efficient but I'm real rusty and short of time.
  • There is only very VERY limited error handling.
  • I could only really test it on my own tracking number, so I'm relying on you guys to let me know if it doesn't work for you.

Download this.  Open and allow it to run if it asks if you want to trust it.  Should be self explanatory.  Works for any Golf order I think.

https://docs.google.com/file/d/0B9-CTALYHX1eQkJVaU1YX1BHM1E/edit?usp=sharing

The idea is that when they post build weeks I can modify it to grab the confirmed build week for you too.
Then, I should be able to make it sequentially try each order number in a specified range and every time it finds a GTI or GTD order stuff the details in a file which I can then post here.

Offline matchboy

  • I live here
  • *****
  • Posts: 3,160
Re: Spec and Options Popularity
« Reply #56 on: 14 May 2013, 09:02 »
Ok, so I tried this and it worked!  Very clever!  But what do we do now?!
Audi RS5 2018
Gone: BMW M4 LCI Competition Package
Previous: Mk 3 Audi TTS, Porsche 981 Cayman S, Mk 7 Golf R, Mk 7 GTI, Mk 6 GTI, Mk 5 GTI and so on....

Offline Bill_the_Bear

  • I live here
  • *****
  • Posts: 2,038
  • Yes! Wait a minute... No!
Re: Spec and Options Popularity
« Reply #57 on: 14 May 2013, 10:21 »
Ok, so I tried this and it worked!  Very clever!  But what do we do now?!

Ok well now I've got to make it so that instead of just grabbing the details for the one number you know (your number) it runs automatically for a range of numbers.  So for example it might start at 23000000 and then do 23000001 until and keep going for how ever long I set it.

Each time it finds a result that includes "GTI" or "GTD" it will then have to write that down in the spreadsheet on a new line.  Might look like this:

230000001 None
230000002 None
230000003 GTI Performance, 5dr, Pure White, DSG, DealerName
230000004 None
230000005 GTD, 3dr, Tornado Red, Manual, DealerName

etc...

I need a little time to do it.  Also, I need to find an order where it has a confirmed build week (could be a Tiguan or anything) so I can see the format they use, then I can grab this too.  End result is we have order numbers and confirmed BW together with some basic description of the cars for every order we can find.  That should give a better picture on when things are due/what causes delays.

Maybe.

Offline CraigW

  • I live here
  • *****
  • Posts: 2,305
Re: Spec and Options Popularity
« Reply #58 on: 14 May 2013, 10:23 »
Ok, so I tried this and it worked!  Very clever!  But what do we do now?!

Ok well now I've got to make it so that instead of just grabbing the details for the one number you know (your number) it runs automatically for a range of numbers.  So for example it might start at 23000000 and then do 23000001 until and keep going for how ever long I set it.

Each time it finds a result that includes "GTI" or "GTD" it will then have to write that down in the spreadsheet on a new line.  Might look like this:

230000001 None
230000002 None
230000003 GTI Performance, 5dr, Pure White, DSG, DealerName
230000004 None
230000005 GTD, 3dr, Tornado Red, Manual, DealerName

etc...

I need a little time to do it.  Also, I need to find an order where it has a confirmed build week (could be a Tiguan or anything) so I can see the format they use, then I can grab this too.  End result is we have order numbers and confirmed BW together with some basic description of the cars for every order we can find.  That should give a better picture on when things are due/what causes delays.

Maybe.

Bill, are you a member of MENSA? If not, i'm going to nominate you  :smiley:

Offline monkeyhanger

  • Serious forum addict
  • *
  • Posts: 6,658
Re: Spec and Options Popularity
« Reply #59 on: 14 May 2013, 10:57 »
Has anyone seen any anomalies between the official VW order confirmation form (that your dealer may have posted to you or emailed you a PDF) and what the tracker says?

My Dad's vanilla GTD 5 door DSG in Tornado Red order has had no amendments (we asked the dealer to add on 5 year warranty as he will keep it a fair while, but that is it). The order confirmation clearly states all of the above, yet the order tracker states that his order number relates to a Pearl Black 5DR DSG GTD. My dad had initially shown interest in this colour but decided to save £500 and get Tornado Red at point of order. I'm going to ask whether he wants me to tell the dealer or whether he would be prepared to chance getting a Pearl black one. Obviously it would be VWs cock up (seeing as the dealer submitted order is correct) so neither dealership nor my dad would be obliged to pay for it.

I do wonder whether this anomaly has occurred due to me originally ordering Pearl black and having the exact same name as him, maybe an order mix-up has happened at VW's end?

Incidentally my order change from DBP to tornado red is not shown on the tracker findings for my order.
Whey ya bugger! It's finally arrived after an 8 month wait....
MK7 R 5 door, manual, Lapiz Blue, Prets.