IMCDb Forum
Naming conventions » Incorrect spelling/listing
Category:  
« Previous topic
Reminder of the previous message
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 08/12/2015 @ 21:46:16, By eLMeR
This kind of scale models is indeed hard to correctly classify. But I find really weird to give it the platform code of the genuine vehicle, as it would imply specific specs (wheelbase, length, width, body-on-frame design and so on) that are absent here.

Maybe a specific class could help? With Class: Scale model, the "lack" of platform code would be logical.
_____

And thinking about it twice, even giving it the name of the accurate vehicle is most probably a misidentification, as it has a real make under which it was sold...
It's apparently a Power Wheels Cadillac Escalade EXT. How can we write it? With Cadillac Escalade EXT in name or in complement? Or Power Wheels as "chassis"?

Latest Edition: 08/12/2015 @ 22:23:15


Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 08/12/2015 @ 22:52:29, By antp
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
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 09/12/2015 @ 00:11:01, By eLMeR
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:

Latest Edition: 09/12/2015 @ 00:11:28
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 09/12/2015 @ 18:32:13, By antp
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:
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 11/12/2015 @ 21:58:10, By antp
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...
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 23/12/2015 @ 04:15:32, By eLMeR
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?

Latest Edition: 23/12/2015 @ 04:17:58
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 23/12/2015 @ 17:04:42, By Sandie
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.
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 23/12/2015 @ 20:08:08, By eLMeR
I thought model years were no longer used in UK either?
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 23/12/2015 @ 20:20:06, By Sandie
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

Latest Edition: 23/12/2015 @ 20:30:48
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 23/12/2015 @ 21:58:38, By eLMeR
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: )

Latest Edition: 23/12/2015 @ 22:01:37
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 23/12/2015 @ 22:31:42, By Sandie
(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.

Latest Edition: 23/12/2015 @ 22:34:08
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 24/12/2015 @ 05:32:17, By eLMeR
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.
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 08/01/2016 @ 18:22:08, By Ddey65
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
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 08/01/2016 @ 19:31:20, By antp
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:
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 17/02/2016 @ 22:43:36, By Ddey65
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
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 26/02/2016 @ 14:38:30, By Ddey65
This oil tanker was mislabeled as a fire truck:
http://www.imcdb.org/vehicle_379190-Brockway-257.html
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 28/02/2016 @ 13:39:31, By eLMeR
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:
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 29/02/2016 @ 09:10:28, By antp
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
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 29/02/2016 @ 19:47:29, By antp
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)
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 02/03/2016 @ 05:39:44, By eLMeR
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:
Add Reply - Category:  
Sign In :: Sign Up :: Lost your login or your password?
KelCommunity.be :: © 2004-2024 Akretio SPRL :: Powered by Kelare