Shipbucket :: Database Lightbulb

Sure. The following only will hold for Western Ships - Golly knows more about eastern systems of naming, so would be the preferred person for setting that up.

If the drawing is representing a class of ships, then the format is <Type><Space><Class> where Type is something like DD, DDG, DDH, ect. An example would be:

Code: Select all

T-AGOS Stalwart.png

If the drawing is representing a single ship, then the preferred system is <Pennant Number><Space><Ship's name> followed by an optional <Space><Year> if there are more than one version of the ship. In addition, if there are more than one drawing of a ship at a particular year, it is possible to add a single digit extension or a brief bit of text (usually a single word) on the end. The only modifications to this is if the ship is a carrier in European service, an Auxiliary ship, or a Mine-warfare ship. In these cases the type (CVN, CVA, CVE, CVL, CVS, MC, MCM, AOR, AO, AG, AK, ect.) is applied before the Pennant number. Examples would be as follows:

Code: Select all

D88 Glasgow 1992.png

Code: Select all

CV R86 Implacable 1944.png

Code: Select all

DDG-177 Atago.png

Code: Select all

BB Musashi 1944 Sibuyan Sea.png

Code: Select all

MCM M850 ALKMAAR 2.png

This modification for carriers is put in place to allow for carriers to stick together in the lists - otherwise they would be split between the Cs and the Rs. It also allows for more explanation of what certain support ships do.

If you don't have a pennant number for a ship (such as UK battleships or Civilian ships), then the Pennant number is replaced with just the type as follows:

Code: Select all

MV Marjorie C.png

Code: Select all

BB Howe 1944.png

Last rule is for ships with MARAD hull type codes - these are much more rare (and mostly US), but are rendered with the Hull code with spaces as the breaks followed by the ship's name:

Code: Select all

P6 S4 DS1 United States.png

For upload sessions replacing the spaces with underscores is also possible (as for the next upload session I should be able to write a shell script to reverse that automatically).

Or at least, this is how I have been running the naming convention on the folders that I've been trying to fix. At this point, if something else is wanted, now would be the time to speak up (IE before this batch of files goes live).

Author:	Charybdis [ January 26th, 2013, 5:57 pm ]
Post subject:	Database Lightbulb
Before you post your exocets in my general direction... this is JUST an idea. It is in no way a criticism of admin staff (or artists). We all recognize the superb job they do to keep SB running smoothly. With talented and productive artists joining SB all the time, this site is going to get very much bigger in a short space of time. The last upload is a good demonstration of this fact. There are now over 430 drawings in the Real Designs/Great Britain database alone. Although the database looks organized at first glance, a closer look shows many drawings that should be grouped are here there and everywhere. I think this is a shame and it doesn't do optimum justice to the great drawings that can be found on our site. Sooner or later this monster will have to be reorganized. Below is a standardized system for naming files I am proposing which could be used throughout the Real Designs DB. Its purpose is to show a lineal progression of each ship type over time, making it easier to locate specific ship drawings. [SHIP TYPE] [YEAR OF CLASS COMMISSION] [CLASS NAME] [ORDER OF UNIT COMMISSION] [UNIT NAME] [YEAR DEPICTED] Here we can decide on an order for the ship type. I suggest using a system like Janes' for the warships i.e. 001 = SSBN, 002 = SN, 003 = SS, 004 = CVN, 005 = CV, 006 = CVL, etc... [UNIT TYPE] Use a standard system like NATO or USN for example, CVN, DD, DG, FF, FG... [YEAR OF CLASS COMMISSION] The four digit year that the first unit of the class came into commission. [CLASS NAME] All in CAPS. [ORDER OF UNIT COMMISSION] Three digit number of the order that the units of the class came into commission. [UNIT NAME] Standardized form. First letter Capital the rest lower case. [YEAR DEPICTED] The four digit year that the unit is depicted in. Here is an example of the database system for British aircraft carriers: (NOTE: These are not actual files on the DB but just to give an idea.) 001 SSBN... 002 SSN... 003 SS... 004 CVN (Would not be seen on GB Database) 005 CV 1917 COURAGEOUS 001 Courageous 1916.png 005 CV 1917 COURAGEOUS 002 Glorious 1918.png 005 CV 1917 COURAGEOUS 002 Glorious 1928.png 005 CV 1917 COURAGEOUS 002 Glorious 1940.png 005 CV 1917 COURAGEOUS 003 Furious 1938.png 005 CV 1918 ARGUS 001 Argus 1938.png 005 CV 1923 HERMES 001 Hermes 1931.png 005 CV 1924 EAGLE 001 Eagle 1942.png 005 CV 1938 ARK ROYAL 001 Ark Royal 1938.png 005 CV 1940 ILLUSTRIOUS 001 Illustrious 1940.png 005 CV 1940 ILLUSTRIOUS 002 Formidable 1944.png 005 CV 1940 ILLUSTRIOUS 003 Victorious 1942.png 005 CV 1940 ILLUSTRIOUS 003 Victorious 1960.png 005 CV 1940 ILLUSTRIOUS 004 Indomitable 1944.png 005 CV 1944 IMPLACABLE 001 Implacable 1944.png 005 CV 1944 IMPLACABLE 002 Indefatigable 1950.png 006 CVL 1944 COLOSSUS 002 Glory 1955.png 006 CVL 1944 COLOSSUS 005 Theseus 1951.png 006 CVL 1944 COLOSSUS 007 Venerable 1948.png 006 CVL 1944 COLOSSUS 011 Pioneer 1950.png 007 CVE 1941 AUDACITY 001 Audacity 1941.png 007 CVE 1941 LONG ISLAND 002 Archer 1941.png To add a drawing of HMS Ark Royal in 1975 would be 005 CV 1951 AUDACIOUS 002 Ark Royal 1975.png This would slot in nicely between Glory and Indefatigable... OR A drawing of HMS Ark Royal in 1991 006 CVL 1980 INVINCIBLE 003 Ark Royal 1991.png would come between Pioneer and Audacity. For commercial ships, it could probably be made a little more simplistic due to lower occurance of drawings of the same class and even the same ship. These could probably come after the warships and auxiliaries... I realize that this would be a hell of a job, very tedious and could get confusing at times. I would be happy to commit my time to doing the job, if the forum also thinks its a job that needs doing. I also realize that organizing future uploads could be a nightmare, but I believe that the system, once agreed could be made available as a reference. So, again, this is just an idea I had. I might be getting it all wrong, as I don't know how the files are stored with relation to the DB webpage. I presume they are all uploaded to a file on a remote server and hyperlinked.

Author:	heuhen [ January 26th, 2013, 6:32 pm ]
Post subject:	Re: Database Lightbulb
I agree with admin. BTW. when are we going to do a clean up of the Norwegian database, it's a bit .... dirty in there. And I am willing to redraw or update drawings that I did before that are in need of that.

Author:	Charybdis [ January 26th, 2013, 6:50 pm ]
Post subject:	Re: Database Lightbulb
Ah well, it was just an idea. I suppose my system is a bit long winded. I do worry though, that including British pennant numbers, which seem to have no order whatsoever, could result in a random list of cruisers, for example. Whatever the outcome, I'd be happy to lend a hand. Just to get it straight... I download the country files, put them into a folder, rename the files and email them to you as a complete folder? Let me know if I can be of assistance.

Author:	eswube [ January 26th, 2013, 7:12 pm ]
Post subject:	Re: Database Lightbulb
Well, IMHO the title line proposed by Charybids is indeed too long, but I'd say that He has a point in that in some folders there is some disorganization (like with some names having country name prefix and some not, SS prefix for "steam ship" next to SSK for submarine - and if I recall correctly in several places to SS used for submarines themselves etc.). That said, I am willing to volunteer for help with renaming file names - both in Polish folder and elsewhere. Btw. - but that's just a digression, for my own archive I'm using completely different system of two-letter ship-class prefixes (for example, instead of CV and CVN I use AC, BB means battleship but coast defence battleship is BD etc.), although introducing it here rather wouldn't work (I find it logical for myself, but dozens of other users could not ).

Author:	TimothyC [ January 26th, 2013, 7:17 pm ]
Post subject:	Re: Database Lightbulb
And for the record, we're sitting at over 4300 files now!

Shipbucket http://67.205.157.234/forums/

Database Lightbulb http://67.205.157.234/forums/viewtopic.php?f=5&t=3943	Page 1 of 3

Author:	Charybdis [ January 26th, 2013, 7:23 pm ]
Post subject:	Re: Database Lightbulb
Monster. Whats that, about 150MB?

Page 1 of 3	All times are UTC
Powered by phpBB® Forum Software © phpBB Limited https://www.phpbb.com/