21-11-2006

Hello
This week I worked on 'the grand list'.
First:
Mutations on already existing records. Most of them have supplementary data I found, and some of them changed because I tried to 'normalize' the record, especially where in my opinion, the 'BRANDING' and the 'NAME' field where mixed up.
In some cases you will see the same name now in 'NAME' as in "BRANDING', that is where the name of the company is the same as the (trade mark) name on the pen itself. (example: I changed ,Acme,,,,,MP to Acme,Acme,USA,Current,CC,LE)
This has something to do with the problem 'model'names versus 'brand'names and like many others in this tread i do not have a solution yet so solve that problem, so I will continue the convention of using trade mark names and model names in the same 'NAME'field.
Second:
New entries to add to the list. I entered some entries for the very well known brands as well. I realise that there was a discussion on wether or not to enter the 'top brand names'. (as everybody would know these allready). I think that ALL names should be entered because everyone that wants to use this list must be able to find his or her pens to identify, also the less expirienced collectors. But also the diehards among us can benefit from this because then it will be possible to make reference to the exotic brands and trade marks or less known model names that are associated with the top firms.
Third:
Added attributes for Style (Filler Type):
CC = Cartridge/Converter Filler
CO = Cartridge Only Filler
CR = Crescent Filler
SA = Safety Filler
Added attribute for Contrib:
LE = LEXAF = Lex van Galen, the Netherlands = yours truly

I hope I used a format that Gerry can use for updating the 'grand list'
Note that I left out the '#' field (obsolete, IMHO) and I changed the delimiter " comma space " into a single " comma ", as it would not fit into my database program with a space as first character in each field. (That is what happened when I tried to convert the original list directly into my application).
If the changes where not significant I kept the original Contributor code, for major updates and new entries I took the freedom to use a new contributor code for myself: LE
If you find problems, please let me know.
I'd like to post the first results hereunder. I hope for lots of comments!
NAME,BRANDING,COUNTRY,DATE,STYLE,CONTRIB
Carter(s),Carter Pen Co.,USA, Mass., Boston,1926-1932,,LE
Diabolo,Cartier,France,Current,CC,LE
Pasha,Cartier,France,Current,CC,LE
Trinity,Cartier,France,Current,CC,LE
Ingersoll,Charles H. Ingersoll Dollar Pen Co.,USA,1930,TF,LE
All-American,Conklin sub-brand,,,,LE
The Toledo Fountain Pen Co.,Conklin sub-brand,,,,LE
365,Delta,Italy,Current,CC,LE
Riflessi,Delta,Italy,Current,CC,LE
,Durand and Co.,USA - Cincinatti,,,LE
A. W. Faber,Faber-Castell,Germany,,,LE
,J.D. Snow,USA - Cincinatti,,,LE
Generation,Mont Blanc,Germany,Current,CC,LE
Hommage a Mozart,Mont Blanc,Germany,Current,CO,LE
Meisterstuck,Mont Blanc,Germany,,,LE
Celluloid Collection,Omas,Italy,Current,PF,LE
Paragon,Omas,Italy,Current,CO,LE
,Simplofiller,USA, OH, Cincinnati,,,LE
,The Akron Fountain Pen Co.,USA, OH, Akron,,,LE
,The Betzler Fountain Pen Co.,USA, OH, Akron,,,LE
Conklin (see also branding Conklin),The Conklin Pen Manufacturing Co.,USA, OH, Toledo,,,LE
Clymax,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
College,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
Columbia,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
Dexter,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
Duplex,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
Eureka,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
Fountograph,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
Imperator,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
Imperial,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
Jewel,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
MacKinnon,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
Paragold,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
Perfection,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
Red Giant,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
Royal,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
Self-Inking,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
University,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
Victor,The John Holland Co. sub-brand,USA - Cincinatti,1880-1920,,LE
John Holland,The John Holland Gold Pen Co.,USA - Cincinatti,1880-1920,,LE
Conklin predecessor,The Self Fountain Pen Co.,USA - Toledo,,,LE
,The Weidlich Pen Co.,USA - Cincinatti,,,LE
The Pick Pen Co.,The Weidlich Pen Co. sub-brand,USA - Cincinatti,,,LE
The Star Pen Co.,The Weidlich Pen Co. sub-brand,USA - Cincinatti,,,LE
Vendex,Vendex,NL,1950-1960,,LE
Carene,Waterman Paris,France,Current,CC,LE
Edson,Waterman Paris,France,Current,CC,LE
Expert 2000,Waterman Paris,France,Current,CC,LE
Expert II,Waterman Paris,France,Current,CC,LE
Hemisphere,Waterman Paris,France,Current,CC,LE
L'Etalon,Waterman Paris,France,Current,CC,LE
Liason,Waterman Paris,France,Current,CC,LE
Phileas,Waterman Paris,France,Current,CC,LE
Preface,Waterman Paris,France,Current,CC,LE
,Weidlich and Simpson,USA, OH, Cincinnati,,,LE
The alphabetical order is in the 'Branding' field so maybe the following version is easier to read
BRANDING,NAME,COUNTRY,DATE,STYLE,CONTRIB
A. Morton,A. Morton,USA,,,LE
A.A. Waterman,Resevo,USA - Chicago,1903,TF,LE
Acme,Acme,USA,Current,CC,LE
Aikin Lambert,Alco,USA,,,LE
Ajax,Ajax,USA,1920-1930,LF,LE
Akkerman,P.W. Akkerman,NL,ca. 1935-1955,BF,LE
Ambassador,Ambassador,USA,,,LE
Ancora,Capri,Italy,1919-current,CC,LE
Ancora,Paua,Italy,1919-current,BF,LE
Ancora,Tuscany,Italy,1919-current,CC,LE
Ancora,Unica,Italy,1919-current,BF,LE
Arnold,Arnold,USA,,,LE
Artcraft,Artcraft,USA,,,LE
Artus,Artus Ballit,Germany,1942 -1952,PF,LE
Artus,Artus Favorit,Germany,1942 -1952,,LE
Artus,Artus Record,Germany,1942 -1952,,LE
Aurora,88,Italy,1950-current,PF,LE
Aurora,Primavera,Italy,Current,PF,LE
Autocraft,Autocraft,USA,,,LE
Autofiller,Autofiller,USA,1915-1920,TF,LE
Autopoint,Autopoint,USA,,,LE
Betzler and Wilson,,USA - Akron,,,LE
Boston Fountain Pen Co.,Wahl - Eversharp predecessor,USA,1914,LF,LE
Byers & Hayes,Byers & Hayes,USA,1900-1930,ED,LE
Carter Pen Co.,Carter(s),USA, Mass., Boston,1926-1932,,LE
Cartier,Diabolo,France,Current,CC,LE
Cartier,Pasha,France,Current,CC,LE
Cartier,Trinity,France,Current,CC,LE
Charles H. Ingersoll Dollar Pen Co.,Ingersoll,USA,1930,TF,LE
Conklin sub-brand,All-American,,,,LE
Conklin sub-brand,The Toledo Fountain Pen Co.,,,,LE
Delta,365,Italy,Current,CC,LE
Delta,Riflessi,Italy,Current,CC,LE
Durand and Co.,,USA - Cincinatti,,,LE
Faber-Castell,A. W. Faber,Germany,,,LE
J.D. Snow,,USA - Cincinatti,,,LE
Mont Blanc,Generation,Germany,Current,CC,LE
Mont Blanc,Hommage a Mozart,Germany,Current,CO,LE
Mont Blanc,Meisterstuck,Germany,,,LE
Omas,Celluloid Collection,Italy,Current,PF,LE
Omas,Paragon,Italy,Current,CO,LE
Simplofiller,,USA, OH, Cincinnati,,,LE
The Akron Fountain Pen Co.,,USA, OH, Akron,,,LE
The Betzler Fountain Pen Co.,,USA, OH, Akron,,,LE
The Conklin Pen Manufacturing Co.,Conklin (see also branding Conklin),USA, OH, Toledo,,,LE
The John Holland Co. sub-brand,Clymax,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,College,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,Columbia,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,Dexter,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,Duplex,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,Eureka,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,Fountograph,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,Imperator,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,Imperial,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,Jewel,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,MacKinnon,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,Paragold,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,Perfection,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,Red Giant,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,Royal,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,Self-Inking,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,University,USA - Cincinatti,1880-1920,,LE
The John Holland Co. sub-brand,Victor,USA - Cincinatti,1880-1920,,LE
The John Holland Gold Pen Co.,John Holland,USA - Cincinatti,1880-1920,,LE
The Self Fountain Pen Co.,Conklin predecessor,USA - Toledo,,,LE
The Weidlich Pen Co.,,USA - Cincinatti,,,LE
The Weidlich Pen Co. sub-brand,The Pick Pen Co.,USA - Cincinatti,,,LE
The Weidlich Pen Co. sub-brand,The Star Pen Co.,USA - Cincinatti,,,LE
Vendex,Vendex,NL,1950-1960,,LE
Waterman Paris,Carene,France,Current,CC,LE
Waterman Paris,Edson,France,Current,CC,LE
Waterman Paris,Expert 2000,France,Current,CC,LE
Waterman Paris,Expert II,France,Current,CC,LE
Waterman Paris,Hemisphere,France,Current,CC,LE
Waterman Paris,L'Etalon,France,Current,CC,LE
Waterman Paris,Liason,France,Current,CC,LE
Waterman Paris,Phileas,France,Current,CC,LE
Waterman Paris,Preface,France,Current,CC,LE
Weidlich and Simpson,,USA, OH, Cincinnati,,,LE