Subject: Incorrect spelling/listing
08/12/2015 @ 22:52:29: antp: Incorrect spelling/listing
You're thinking too far :tongue:
Problem with listing that under the maker's name is that we should then list all the model cars under their maker too?

In a way these should maybe not be listed at all...
In the future we plan to have a solution of these kind of listings, but not yet for v3, rather v3.1
08/12/2015 @ 23:37:35: atom: Incorrect spelling/listing
We have a few model cars listed like this: http://www.imcdb.org/search.php?resultsStyle=asList&sortBy=0&yearFrom=&yearTo=&makeMatch=- 2&make=&modelMatch=0&model=1%3A&modelInclModel=on&modelInclChassis=on&modelInclExtra=- on&mk=&origin=&madein=&madefor=&role=
09/12/2015 @ 00:11:01: eLMeR: Incorrect spelling/listing
You're thinking too far :tongue:
Problem with listing that under the maker's name is that we should then list all the model cars under their maker too?

If we really want to identify them, then we should do the job properly and give them their accurate make, like all other vehicles in the database. But as you say:
[...] In a way these should maybe not be listed at all...

Being just toys, they would indeed deserve at most a place in comments, for me. There's enough work to do with genuine vehicles :smile:
09/12/2015 @ 18:32:13: antp: Incorrect spelling/listing
Hence why we were planning on a different way of listing them in the future, but that will be for after the initial v3 release or we'll never finish :grin:
In the meantime the few with a role are not big offenders to the listings :wink:
11/12/2015 @ 21:58:10: antp: Incorrect spelling/listing
Is there a reason why some vehicles are listed as "F.N." and others as "FN"?
http://www.imcdb.org/search.php?resultsStyle=asList&sortBy=0&make=F.N.&model=
http://www.imcdb.org/search.php?resultsStyle=asList&sortBy=0&make=FN&model=
All should be listed as FN I suppose...
23/12/2015 @ 04:15:32: eLMeR: Incorrect spelling/listing
The first generation of Range Rover Sport was apparently unveiled in January 2005, with vehicles obviously registered a month later. But there is only 16 2005 models while 117 vehicles are apparently set with 2006 as default model year.
If not an incorrect listing, is it due to different launch dates in different countries, and if so do we have a list of these different countries/dates?
23/12/2015 @ 17:04:42: Sandie: Incorrect spelling/listing
For the US: http://www.rangerovers.net/modelspecs/Sport/2006.html
The Range Rover Sport first hit the showrooms in mid 2005, branded as a 2006 model.


For the UK, an article from April 05 saying 'On sale June': http://www.telegraph.co.uk/motoring/first-drives/2734656/Beast-with-butterfly-blessings.html

So, released in the middle of the year (so a 2006 model in most countries apart from France and Australia where model years are not used, I guess?). The Clarkson one looks like a pre-production car used for testing and reviewed by journalists before official sales so should probably stay as an 05.
23/12/2015 @ 20:08:08: eLMeR: Incorrect spelling/listing
I thought model years were no longer used in UK either?
23/12/2015 @ 20:20:06: Sandie: Incorrect spelling/listing
No. Widely used by manufacturers (and that's what we follow on IMCDB) to differentiate major spec changes. I think France are alone with not using them in Europe.

JLR certainly use them cf: http://newsroom.jaguarlandrover.com/en-in/jaguar/news/2014/02/jag_15my_xf_press_release_250214/
Vauxhall too: https://www.vauxhallfleet.co.uk/news/vauxhall_car_model_year_16_changes.html
23/12/2015 @ 21:58:38: eLMeR: Incorrect spelling/listing
Already discussed here last year, but when the MY disappeared in French in 2001, it was said to be done to follow the other European countries habits :grin:
As I discovered that change 13 years after it was made, I may be not the only one who missed the info in Europe?
(and British model years seem to be debated too :wink: )
23/12/2015 @ 22:31:42: Sandie: Incorrect spelling/listing
(and British model years seem to be debated too :wink: )


Well, I prefer to pay attention to what manufacturers say rather than the unsourced opinions of people on the internet :tongue: . (FWIW I agree with dsl MYs should only apply if there's a visible difference that makes it the next year and until recently 'next year's model' would not be released until late on in the year. I'm also not sure we would notice most of the minor changes made for a new model year cf that Vauxhall link).

So, is it the case that French model years were based around dates of registration rather than anything official from a manufacturer? So a car built in 1999 unregistered until July 2000 would be a 2001 model under this French system? That definition is quite different from the car industry definition of a model year (it seems to be a date of registration to me) and might explain why it was abolished.
24/12/2015 @ 05:32:17: eLMeR: Incorrect spelling/listing
I wrote my answer in the Model year for vehicles sold in France thread for this one no to be too polluted by this "French model year affair" :wink:

In a nutshell: please read "cars made in France", not "cars sold in France" in the very first post of this other thread.
08/01/2016 @ 18:22:08: Ddey65: Incorrect spelling/listing
This car is fine except that it's missing one other item. Can somebody add a "Made for Canada" tag to it?
http://www.imcdb.org/vehicle_625180-Aston-Martin-V8-Vantage.html
08/01/2016 @ 19:31:20: antp: Incorrect spelling/listing
As said previously, this thread is for discussing general changes to a range of models; for those which were missed like this one it is rather the "non-unidentified" thread in the General section of the forum :wink:
17/02/2016 @ 22:43:36: Ddey65: Incorrect spelling/listing
Okay, here's an incorrect listing. This Pontiac GTO is misclassified as a limo, when it's actually a convertible:

http://www.imcdb.org/vehicle_797122-Pontiac-GTO.html
26/02/2016 @ 14:38:30: Ddey65: Incorrect spelling/listing
This oil tanker was mislabeled as a fire truck:
http://www.imcdb.org/vehicle_379190-Brockway-257.html
28/02/2016 @ 13:39:31: eLMeR: Incorrect spelling/listing
Like for the Mid-Liner models (still not changed in the IMCDb :wink: ), Mack's corporate writing for the 1977-93 Super-Liner also used a hyphen:
http://pics.imcdb.org/18713/197macksuperlinerbrochureexcerpt.jpg
http://pics.imcdb.org/18713/1978macksuperlinerbrochurecover.jpg
http://pics.imcdb.org/18713/1989macksuperlinerbrochurecover.jpg
197? brochure excerpt
1978 brochure cover
1989 brochure cover


74 trucks are concerned in the IMCDb, including these (at least) 2 Australian models (already listed in the previous link): this name is still written this way in wombats' island nowadays.

It appears that it is the same spelling for all Something-Liners, in fact.
US models:
  ∗ 1975-83 Cruise-Liner (18 trucks in the IMCDb)
http://www.trucksplanet.com/photo/mack/ws_wl_cruise-liner/x_ws_wl_cruise-liner_k1.jpg
http://www.trucksplanet.com/photo/mack/ws_wl_cruise-liner/x_ws_wl_cruise-liner_k494.jpg


  ∗ 1982-90 Ultra-Liner (13 trucks in the IMCDb). Apparently also known as MH-Series by some of us, but no model is currently identified that way.
http://www.trucksplanet.com/photo/mack/mh_ultra-liner/x_mh_ultra-liner_k1.jpg

Australian models:
  ∗ Cruise-Liner
The only truck identified that way is already part of the US Cruise-Liner link above.

  ∗ Fleet-Liner. None in the IMCDb for now?
http://www.trucksplanet.com/photo/mack_australia/fleet-liner/x_fleet-liner_k1.jpg

  ∗ Super-Liner. See the US model.

  ∗ Metro-Liner. Only 1 truck concerned, I'll change it manually, I don't think a specific MySql script is needed :grin:

  ∗ Value-Liner. 2 trucks in the IMCDb that I'll change manually.
http://www.trucksplanet.com/photo/mack_australia/value-liner_2/x_value-liner_2_k1.jpg

==========

Thinking about it twice, and as I'm a lazy person, I won't have to make the manual changes if this script is Ok for you, antp:
update theTable set theModelField = replace(theModelField, 'liner', '-Liner') where theMakeField like ('Mack') and theModelField like ('')

It certainly needs some arrangements to fit the IMCDb tables structure, but it would change all Mack Something-Liner in one go, and only them. Tested and approved in a test table I made on purpose :wink:
29/02/2016 @ 09:10:28: antp: Incorrect spelling/listing
Thanks!
I'll do that later (now i am on a tablet, a little tricky for doing SQL), indeed it seems i forgot to make the Mid-liner change
29/02/2016 @ 19:47:29: antp: Incorrect spelling/listing
Done; that was much easier with the provided SQL query than if I had to do it myself (I would have done it model by model, I do not know I'm always a little afraid of functions like Replace in SQL :D)
02/03/2016 @ 05:39:44: eLMeR: Incorrect spelling/listing
Thanks!
[...] I'm always a little afraid of functions like Replace in SQL :D)

Sounds logical: using replace is like "playing" with RegExps or using a hammer: it can hurt a lot even when done with care :grin:

Talking about Australian Macks, there's a kind of mess about them: for now we classify them as made in Australia, made for Australia (only 3 trucks are set that way without "made in"), or both.
As said on the Australian corporate site, "[proud to] have celebrated 50 years of local Mack production on Australian soil in 2013":
Every Mack truck, custom built for the Australian and New Zealand market, comes to life at the Australian production facility in Wacol, QLD.

So, as Mack trucks made in Australia may also end in New Zealand, we would certainly be right by having them just as "made in"...

If Ok, do the following codes help? Tested without apparent collateral damage, but at usual "in backup we trust" :wink:
update theTable set madeInField='countryIdForAustralia' where theMakeField='idForMack' and madeForField='countryIdForAustralia';
update theTable set madeForField='' where theMakeField='idForMack' and madeInField='countryIdForAustralia';

1- All Mack trucks with the "made for Australia" flag get the "made in" one if not present;
2- Delete the "made for Australia" flag for Mack trucks set with the "made in Australia" one.

Ok, the 1st line is certainly a bit overkill, as only 3 trucks are really concerned. Let's say I'm a hopeless geek :grin:
... 14 15 16 17 18 19 20 ... 22 
Back