The Coupe Database

tonyz4c · Post by **tonyz4c** » Mon Dec 25, 2017 6:47 pm

using your vin decoder link i have added 34 vin missing in my db
i have refine countries list as well (putting km tacho to ireland)

i'm still missing those vins, if someone has info

LM08532
LE89476
LK43085,LK43086,LK43385
LF78271,LF78272,LF78273
LD39662

flimper · Post by **flimper** » Tue Dec 26, 2017 10:32 am

According to bmw registry the following are all South African cars (you currently have as England):

LF78194
LF78227
LF78681
LF78686
LF78708
LF78817
LG19023 (https://www.mycars.co.za/MC25147-2009-BMW-Z4)

LF78764 is a Hong Kong car, and LF78909 is a Malaysian car. LF78729 I have as blank.

tonyz4c · Post by **tonyz4c** » Wed Dec 27, 2017 7:39 pm

I have reset all vehicules assigned to "england" without the option 'national version England Ireland' to 'others'

From the example you have provided for SA cars i can use a pattern like

if S864A Retailer overseas
if S880A On-board vehicle literature English
if S853A Language version English
if S858A Engine Settings For Lower-quality Fuel
if S8SMA Car ident. number visible from outside
if S548A Kilometer-calibrated speedometer
=> SA

For example the Hong Kong car fails to this pattern because it doesn't have the S858A + S8SMA option
+ it has a Radio frequency 315 MHz option

For example the Malesia car fails to this pattern because it doesn't have the S858A + S8SMA option
+ it has a Radio frequency 315 MHz
+ it has a Radio control Oceania

=> using this pattern LF78729 is SA
=> no specific radio frequency / control

What do you think of this ?

flimper · Post by **flimper** » Wed Dec 27, 2017 10:55 pm

Sounds good to me!

tonyz4c · Post by **tonyz4c** » Fri Dec 29, 2017 8:39 pm

Hi
i have used several vin decoders to retrieve the missing vins I had, so now the db is complete
Total 9 976 => 4 587 coupe => 1 055 RHD is my last guess

The pattern to determine countries of deliveries is based on options so it might be a bit geopardy

Some are countries specific L8*

I have then split country determination using root of vin n°
LL, LM, LE, LY => Usa ( Canada has a specific L838A )
LK, LB, LJ => LHD
Countries => combination of retailer documentation overseas/europe/coldClimate/fuelLowerQuality,RadioFrequency
and then LF, LG, LD
Countries => combination of retailer documentation overseas/europe/coldClimate/fuelLowerQuality,RadioFrequency

Sometimes i have used Language/Regions instead of countries as i'm not able to determine:
ex french = France + Belgium (and might be french swiss)
ex : scandinavia for cold climate

or LatinAmerica
and so on..

flimper · Post by **flimper** » Fri Dec 29, 2017 10:03 pm

Excellent Tony, when will the website be updated?

tonyz4c · Post by **tonyz4c** » Fri Dec 29, 2017 11:28 pm

it's done, i have added a world map , I will check later if I'm able to filter the grid when clicking on a country
You might need to do CTRL F5 to force your browser cache as this page is static content

flimper · Post by **flimper** » Sat Dec 30, 2017 12:11 am

tonyz4c wrote: ↑Fri Dec 29, 2017 11:28 pm it's done, i have added a world map , I will check later if I'm able to filter the grid when clicking on a country
You might need to do CTRL F5 to force your browser cache as this page is static content

That's solved it, looks great. Only problem I can see is there is no data for the United Kingdom, are they the cars with an empty field?

tonyz4c · Post by **tonyz4c** » Sat Dec 30, 2017 10:59 am

fixed , problems with country code ( UK-GB, SP-ES )
i'm looking if i can modify the world map to distinguish Hong Kong from china at it's the same country and both have 12 cars
Singapore does not appear but it is in the list, it might be too small

Taz · Post by **Taz** » Sat Dec 30, 2017 12:53 pm

Very good tony

flimper · Post by **flimper** » Sat Dec 30, 2017 2:50 pm

I still don't get any data for United Kingdom?

tonyz4c · Post by **tonyz4c** » Sat Dec 30, 2017 4:10 pm

strange UK = 1206, don't forget to do CTRL F5 several times (i'm only using firefox)

i have published a new version of the map with merged countries : all latin ameria countries are now viewed as LATAM
Norway and Finland are now Nordic,
some european countries are now Europe
I have annexed Belgium to France

China has lost one island to become Hong Kong

Don't worry it's not WW3

flimper · Post by **flimper** » Sat Dec 30, 2017 5:39 pm

Tony, all working for me now, excellent work

So is the real UK number 588 or 592?

The discrepancies are Imola Red 56 or 57, Interlagos Blue 144 or 145, Ruby Black 54 or 55 and Silver Grey 72 or 73.

tonyz4c · Post by **tonyz4c** » Sun Dec 31, 2017 12:03 pm

page updated : you can now select a region in the world map to filter the grid but it's clearing all previous filters, i have to work on that
but i'm not a pro of javascript

in my database i have Imola Red 57, Interlagos Blue 145, Ruby Black 55 and Silver Grey 73 => 592 coupe
we will never know what is the "rigth" value, perhaps you can contact the fifty owners of rubbly back coupe and ask them

Taz we can compare our lists to find which vins are different, then check on some vin decoders for their extra options

Taz · Post by **Taz** » Sun Dec 31, 2017 10:15 pm

tonyz4c wrote: ↑Sun Dec 31, 2017 12:03 pm

Taz we can compare our lists to find which vins are different, then check on some vin decoders for their extra options

Tony, I'm more than happy to compare dbs. In the new year I will get my head in gear and will sort things out

Z4-forum.com

Z4-forum.com