Some CMP serials updates to the CMP database

[Keith Webb]

David Moore (who I notice has just joined our forum) sent me some data plate details from some CMPs seen at a recent event.

C-HU-441-M-WIRE1
C8A 01___ Cab 13
2844515234
Engine FR 3838709
LV0309
Aug 14/42
Door number (faded) Z 65-479 (the "stayed in Canada" style number)
_
C60 444 M DUMP 2__ Cab 13
C60444-M-?
2844239592
Engine PR 3890162
Feb 25/43
Door number 65-777
_
84-44__ Cab 12
0844404056
Engine 2816647

I have added these to the Old CMP database

[David_Hayward (RIP)]

I have added the details to my database. However it is a shame that we do not know what the TRIM section of the 1940 Model truck says.."TBA"? "TR"? The trim section has of course the engine # prefix. Note that this truck must have been a Canadian order unit, since it had a 1940 Model Year prefix and yet had a #12 Cab, so was assembled in 1941 but to the existing 1940 Contract. This compares with British orders that acquired 1941 MY prefixes for both #11 and #12 Cabs, because production started immediately after the switchover to 1941 MY production at Oshawa, around 3 September 1940.

[Hanno Spoelstra]

Originally Posted by Keith Webb

David Moore (who I notice has just joined our forum) sent me some data plate details from some CMPs seen at a recent event.
I have added these to the Old CMP database

Here is a printout of the database which was published on Keith’s OldCMP website (now defunct);

International CMP Database.pdf

[Keith Webb]

Originally Posted by Hanno Spoelstra

Here is a printout of the database which was published on Keith’s OldCMP website (now defunct);

Attachment 124157

But I'm still going!

[Hanno Spoelstra]

Originally Posted by Keith Webb

But I'm still going!

And the FGT will soon be too, right?

[Keith Webb]

Originally Posted by Hanno Spoelstra

And the FGT will soon be too, right?

I wish... We are still locked down and now we even have a curfew.

[m606paz]

Export Keith's spreadsheet to Excel format. If Keith agrees, we can add other CMPs to the sheet and keep it updated.
What do you think?

[Hanno Spoelstra]

Originally Posted by Keith Webb

I wish... We are still locked down and now we even have a curfew.

Bummer... Hope you can get back to working on it soon.

[Hanno Spoelstra]

Originally Posted by m606paz

Export Keith's spreadsheet to Excel format. If Keith agrees, we can add other CMPs to the sheet and keep it updated.
What do you think?

Great idea, go for it! Would be great if we can use some sort of online database rather than an Excel.

[m606paz]

Help me Hanno!
I have not worked or created any online database ... I only know the excel spreadsheets.
Let's think about what we can do and start updating the lists!

[Hanno Spoelstra]

Originally Posted by m606paz

Help me Hanno!
I have not worked or created any online database ... I only know the excel spreadsheets.
Let's think about what we can do and start updating the lists!

Me neither

I may do some searching to find some useful links (e.g. https://apex.oracle.com/pls/apex/f?p...-database-free)

[Keith Webb]

Originally Posted by m606paz

Export Keith's spreadsheet to Excel format. If Keith agrees, we can add other CMPs to the sheet and keep it updated.
What do you think?

Sure, please do!

[Jacques Reed]

Hi Keith,

Ideally we need someone with database building knowledge to set it up as a database as opposed to a spreadsheet.

Microsoft Access is a good application for something like that. Despite false rumours it is still around and will be for for many more years.

I did a bit with Access over 15 years ago but to be honest I don't have the real skills to set it up and what I learnt I most likely have forgotten anyway.
Perhaps a younger tech savvy person can pick up the gauntlet.

Cheers,

[Wayne Hingley]

Here is an Access database tutorial: https://www.youtube.com/watch?v=ubmwp8kbfPc

[Mike K]

Originally Posted by Hanno Spoelstra

And the FGT will soon be too, right?

This is the FGT a few weeks back Hanno

[m606paz]

Originally Posted by Wayne Hingley

Here is an Access database tutorial: https://www.youtube.com/watch?v=ubmwp8kbfPc

I worked years ago with access. But currently I do not even know how to have online access for each one to upload the information of their vehicle. I am thinking of the most comfortable and easy way to maintain this list with updates of all the vehicles that appeared in recent years and that want to share their information.