MLU FORUM

MLU FORUM (http://www.mapleleafup.net/forums/index.php)
-   The Softskin Forum (http://www.mapleleafup.net/forums/forumdisplay.php?f=5)
-   -   Some CMP serials updates to the CMP database (http://www.mapleleafup.net/forums/showthread.php?t=578)

Keith Webb 14-06-03 00:02

Some CMP serials updates to the CMP database
 
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) 14-06-03 14:35

1940 truck
 
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 16-08-21 08:14

Old CMP database
 
1 Attachment(s)
Quote:

Originally Posted by Keith Webb (Post 3378)
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);

Attachment 124157

Keith Webb 16-08-21 08:19

Dead as a dodo
 
Quote:

Originally Posted by Hanno Spoelstra (Post 281245)
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 16-08-21 10:22

Quote:

Originally Posted by Keith Webb (Post 281247)
But I'm still going!

:thup:

And the FGT will soon be too, right?

Keith Webb 16-08-21 11:35

Fgt
 
Quote:

Originally Posted by Hanno Spoelstra (Post 281249)
:thup:

And the FGT will soon be too, right?

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

m606paz 16-08-21 14:06

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 16-08-21 14:55

Quote:

Originally Posted by Keith Webb (Post 281251)
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 16-08-21 14:56

Quote:

Originally Posted by m606paz (Post 281259)
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 16-08-21 15:08

1 Attachment(s)
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 16-08-21 15:17

online database
 
Quote:

Originally Posted by m606paz (Post 281269)
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 16-08-21 18:12

Spreadsheet
 
Quote:

Originally Posted by m606paz (Post 281259)
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 17-08-21 00:19

CMP data base
 
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 17-08-21 06:01

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

Mike K 17-08-21 14:52

more
 
2 Attachment(s)
Quote:

Originally Posted by Hanno Spoelstra (Post 281249)
:thup:

And the FGT will soon be too, right?

This is the FGT a few weeks back Hanno

m606paz 18-08-21 16:55

Quote:

Originally Posted by Wayne Hingley (Post 281284)
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.


All times are GMT +2. The time now is 17:35.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright © Maple Leaf Up, 2003-2016