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 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:


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 @ 09:32:24, By antp
For these changes I was already handling fine the SQL :grin: (that's more basic processing)
I'm not sure it is right to remove the "made for" for there; if they are special visions for that market, they deserve it
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 @ 11:41:39, By eLMeR
I read Mack's site info as "made for both Australia and NZ". So "made for Australia only" sounds incorrect, for me. But if kept, it should then be set on all "made in Australia" for consistency.

I'm confident about the fact that you handle that MySql code: the idea was just to ease your job :wink:
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 @ 16:43:49, By antp
It is somewhat a "default" value (I know you don't like these) to use "AUS" for AUS & NZ, like we tend to use "USA" for North-American specs.

About setting it for all AUS-made: some may be identical to the US model despite being made in AUS, some may be AUS-specific versions, so I'm not sure applying it to all is wise?
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 @ 19:31:11, By eLMeR
It is somewhat a "default" value [...] to use "AUS" for AUS & NZ, [...]

Sounds like saying Walloon people are just French, or Austrians nothing more than Germans, for me :wink:

About setting it for all AUS-made: some may be identical to the US model despite being made in AUS, some may be AUS-specific versions, so I'm not sure applying it to all is wise?

My purpose is just to try to get a common rule we can later refer to: this part seems mostly to be set depending on everyone's mood, for now :grin:
It would be nice if some of our Australian and New Zealander fellows could help us on this. I'm not sure that 2 European guys are the most qualified persons to debate on this subject without local information :wink:
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 14/03/2016 @ 11:24:03, By Lateef
Why are there so many JDM cars listed as model origin Japan, made for J? That doesn't make any sense.
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 14/03/2016 @ 15:15:30, By Sandie
Logic explained here: http://www.imcdb.org/vehicle.php?id=808120

Not saying it's right and maybe we need to discuss it as a naming convention but that's why someone (I guess Exiv96) has done it that way.
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 14/03/2016 @ 18:21:45, By antp
Problem with JDM cars is that they are more common on the site in their export version, so we do not often use the made for tag for export versions... hence the interest of the made for J tag on JDM versions.
If someone has a better idea... :grin:
(on the next version of the site, it will be easier to handle - I know I always say that)

Latest Edition: 14/03/2016 @ 18:22:26
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 15/04/2016 @ 03:26:42, By eLMeR
Ferrari says:
The 308 GTS joined the Ferrari model range at the 1977 Frankfurt Salon.


September 1977 means a 1978 model year: 44 cars should certainly be changed accordingly.

Latest Edition: 15/04/2016 @ 03:28:17
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 15/04/2016 @ 14:42:23, By Exiv96
Why are there so many JDM cars listed as model origin Japan, made for J? That doesn't make any sense.


Problem with JDM cars is that they are more common on the site in their export version, so we do not often use the made for tag for export versions... hence the interest of the made for J tag on JDM versions.
If someone has a better idea... :grin:
(on the next version of the site, it will be easier to handle - I know I always say that)


Indeed, I'm responsible for that Tercel (and a few other "Made for J"). I know it's ususual and debatable, and I certainly wouldn't put a "Made for F" on a Renault, but my initial logic was this : JDM-spec japanese cars have become, since the 1970s, quite specific themselves when compared to their export versions.

For instance, if we omit the EU-spec rear foglight, some japanese cars look exactly the same in Germany, Hong Kong, Chile or Australia. However, that same car, in JDM-spec, will probably have a different name, or a different grille, or an incredibly convoluted trim level, or that third outside mirror if it's an SUV, and so on.

That's why I started to put a "Made for J" tag on JDM japanese cars, but only when there's another spec elsewhere in the world. I thought I wouldn't put that tag on a Honda Mobilio Spike, for instance, because that one had never been officially exported outside Japan.

But then came those russian series where used JDM-spec cars were often seen, sometimes alongside EU-spec (or even US-spec !) ones. So I thought it would be interesting to reflect that by adding the spec of each vehicle, when known. And that meant adding a "Made for J" on cars which wouldn't get one before.

I know, it's complicated.
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 15/04/2016 @ 21:57:15, By antp
Ferrari says:


September 1977 means a 1978 model year: 44 cars should certainly be changed accordingly.



These two too I suppose?

http://www.imcdb.org/vehicle_640593-Ferrari-308-GTS-1975.html
http://www.imcdb.org/vehicle_533850-Ferrari-308-GTS-1975.html
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 17/04/2016 @ 00:01:08, By eLMeR
Indeed. I searched only for 1977 models (yearFrom=1977&yearTo=1977) and forgot to check if some vehicles were set with an older MY :smile:

Thanks for the mass change. I'll handle manually the 2 concerned cars: one should also be moved to the Cars, Convertible class, and I know that making changes directly in the database for so few vehicles is irrelevant.
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 02/05/2016 @ 03:44:59, By eLMeR
According to macktrucks.com, the corporate website of the make, the Mack LE was unveiled in 1994, not 1997.

Only 10 vehicles are concerned, plus 3 models without MY. I could have handle it manually, but besides my laziness which makes me think that there must be a ready-to-use MySql script to change this more quickly, this post is also intended to keep a trace of this info :wink:
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 02/05/2016 @ 08:44:32, By antp
No ready-to-use script (I should), i'll do that later :wink:
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 12/05/2016 @ 06:07:33, By eLMeR
Thanks for the change.
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 17/05/2016 @ 04:14:27, By eLMeR
German models of 1960+ Typ 2 / T1 & T2 double cab pickups are for now set in the IMCDb with Pritschenwagen as model name and with Doppelkabine as complement. But their accurate German sales name was most of the time Doppelkabine, without any reference to Pritschenwagen.
More precisely, if both denomination were apparently used at first:
• VW Pritschenwagen mit Doppelkabine:
1960, 1961, 1962
• VW Doppelkabine only:
1960

only VW Doppelkabine appears in the 1963+ documents: 1963, 1966, 1969, 1971, 1979 (pdf)...

Shouldn't we use VW Doppelkabine for all models, instead of the other sales name that was only (and seemingly not exclusively) used for 3 years only?
I'm aware that really few vehicles are concerned for now (8, including an Israeli pickup which got the Doppelkabine complement by mistake, I think), so I'll change them manually if needed. But there is certainly other ones identified as "Pritschenwagen" only, so keeping track of the way we decide to identify them sounds like a good idea to me :wink:

Latest Edition: 17/05/2016 @ 04:21:40
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 17/05/2016 @ 19:56:34, By antp
Maybe ask Ingo to comment on that; I don't know if he reads this thread, as he is on the forum. If no reply in one or two days maybe we could ask him by private message to come here...
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 18/05/2016 @ 03:45:46, By eLMeR
Ok, I'll handle it that way. Countdown is on :wink:
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 18/05/2016 @ 11:30:05, By antp
there is also tore-40 who often comments on VW, his input can also be useful (but I don't remember if he comes on the forum)
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 18/05/2016 @ 21:48:39, By tore-40
Is this a topic for the German name Doppelkabine, or in general for the crew cabs?

Anyway, my opinion on the matter is that after VW saw what Binz had made (was the crew cab a new concept by then?), they had (it took six years) a solution of their own. At first, marketed as a pick-up with a cabin of choice, later the doka as a model of its own. Except for the 1960 brochure - that is the exception to the rule.
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Incorrect spelling/listing
Published 20/05/2016 @ 03:17:39, By eLMeR
Is this a topic for the German name Doppelkabine, or in general for the crew cabs?

The whole thread is neither for the German Doppelkabine nor for all crew cabs, "just" for all vehicles that could be wrongly listed in the IMCDb :smile:
But the post above is indeed specifically about the German Doppelkabine.

At first, marketed as a pick-up with a cabin of choice, later the doka as a model of its own. Except for the 1960 brochure - that is the exception to the rule.

So due to my researches in thesamba.com and vw-t2-bulli.de, apparently confirmed by what you say (if not coming from the same sources :wink: ), my question remains: according to all this, should we identify all of them as Doppelkabine or keep the 1960-62 models with the Pritshenwagen part?
Add Reply - Category:  
Sign In :: Sign Up :: Lost your login or your password?
KelCommunity.be :: © 2004-2024 Akretio SPRL :: Powered by Kelare