User:Econterms/Big uploads of Brockett publication bibliography 2018-2019

From Inventing aviation
Jump to navigation Jump to search

How to upload data uploads

  • Prep spreadsheet with exactly these headings, for a Publication: Title, Free Text, Publication[Original title], Publication[Simple title], Publication[Authors], Publication[Date], Publication[Countries], Publication[Languages], Publication[Keywords], Publication[Journal], Publication[Related to aircraft], Publication[Page count], Publication[Word count]
  • keep page titles shorter than maybe 190 bytes. 180 bytes seems to work. If a title is too long the record will be reported shortly after the import starts, and not imported. Can just fix that one record offline and upload it later
  • save as .csv in Windows ; can't use Mac because high-accent characters are stored wrong somehow
  • visit Special:ImportCSV
  • choose "Append" so as to maximize the obviousness of any overwriting of existing records by new records
  • edit Summary; this will be the comment on each record's import. A good comment is: "Publications import #9"
  • I did 20 records on Wed or Thu Aug 15-16 2018, and then 100 starting Fri Aug 17. It's detailed and takes a lot of preparation still but I can keep scaling up and going faster with practice.
  • started Brocket vol 2 uploads on Feb 19 2020

Logs of several uploads

  • 5th upload Oct 6 2018 from Publication 956, 1909, At Morris Park to Béthuys, 1888, Sur le ballonnet à compression de l'aérostat du Général Meusnier -- 647 records I think. we have 1378 already before the upload begins.
  • The system's response:
    • Importing...
    • Unable to construct a valid title from "Baldwin, 1786, Airopaidia: containing the narrative of a balloon excursion from Chester, the eighth of September, 1785, taken from minutes made during the voyage: hints on the improvement of balloons .... To which is subjoined, mensuration of heights by the barometer, made plain; with extensive tables. The whole serving as an introduction to aërial navigation".
    • Unable to construct a valid title from "Cavalcabo, 1573, L'Impotenza del Demonio di trasportare a talento per l'aeria da un luogo all' altro i Corpi umani, dimostrata da Clemente Baroni delli Marchesi Cavalcabo, accademico di Roverto. Dove anche si dimostra l'impossibilità, di volare con artifizio umano".
    • Unable to construct a valid title from "Baudry de Saunier, 1909, Éléments de locomotion aérienne, par L. Baudry de Saunier; étude à la portée de tous des appareils de locomotion aérienne: ballons libres, ballons dirigeables, aéroplanes. Description complète des principaux appareils, et explication détaillée de leur fonctionnement".
    • 644 pages will be created from the CSV file.
  • So, correction: I need to get to those records later, and will shorten their titles for upload 6; this upload will have 644 records which will take the total to 1378+644=2022
  • 6th upload from 'Baldwin, 1786, Airopaidia: containing the narrative of a balloon excursion from Chester' to 'von Burgsdorff, 1906, Ueber die Berechnung einer Visiertabelle zum Schiessen auf Luftballons'
  • Before the upload, there are 2020 publications.
  • The system says: "Importing... 567 pages will be created from the CSV file."
  • Ah! No errors at all!
  • next batch, the 7th upload, will start with W. Burmeister's publication
  • 7th upload goes through the first of the D's ; I did it from the Mac which is new. it was necessary to save as Windows .csv not Mac .csv because of the line endings CR/LF
  • at least 5 elements didn't make it, and it looks like many European characters will come in wrong, but we'll see:
    • Unable to construct a valid title from "Bussière, 1860, Navigation aérienne. Puissance humaine et intellectuelle. En soumettant mes combinaisons à votre appréciation, mon but est de placer un jalon qui serve de point de départ pour les hommes qui croient avec raison qu'avec les moyens, rien n'est impossible à l'homme".
    • Unable to construct a valid title from "Carra, 1784, Essai sur la natique aérienne, contenant, l'art de diriger les ballons aérostatiques à volonté, & d'accélérer leur course dans les plaines de l'air; avec le précis de deux expériences particulières de météorologie à faire. Lu à l'académie royale des sciences de Paris, le 14 janvier 1784".
    • Unable to construct a valid title from "Coxwell, 1847, Supplement to the 'Balloon or Aerostatic Magazine' account of the bursting and terrific descent of Mr. Gypson's balloon at Vauxhall [and] an account of Lieut. Gale's ascent and descent".
    • Unable to construct a valid title from "Coym, 1906, Bericht über bei den Drachen- und Ballonaufstiegen benutzten Instrumente und über die Auswertung der von ihnen gelieferten Registrierkurven. Ergebnisse der Arbeiten des König. Preussischen Aeronautischen Observatoriums bei Lindenberg im Jahre 1905".
    • Unable to construct a valid title from "Cruikshank, 1825, Scene in the farce of 'Lofty Projects,' as performed with great success for the benefit and amusement of John Bull, street scene, with row of balloons on a rack waiting for hire, others in the air, humorous coloured caricature by T. G. G. Humphrey".
    • 865 pages will be created from the CSV file.
big upload 8
  • First rows: (first 5 left over from previous upload) 1:15am Dec 5 2018
  • Bussière, 1860, Navigation aérienne. Puissance humaine et intellectuelle
  • Carra, 1784, Essai sur la natique aérienne, l'art de diriger les ballons aérostatiques à volonté, d'accélérer leur course dans les plaines de l'air
  • Coxwell, 1847, Supplement to the 'Balloon or Aerostatic Magazine' account of the bursting and terrific descent of Mr. Gypson's balloon at Vauxhall and Lieut. Gale's ascent and descent
  • Coym, 1906, Bericht über bei den Drachen- und Ballonaufstiegen benutzten Instrumente und über die Auswertung der von ihnen gelieferten Registrierkurven, Preussischen Aeronautischen Observatoriums bei Lindenberg im Jahre 1905
  • Cruikshank, 1825, Scene in the farce of 'Lofty Projects,' performed for the benefit and amusement of John Bull, street scene, humorous coloured caricature by T. G. G. Humphrey

start of 8th upload

  • GD, 1891, Grappin aérostatique, De notre collaborateur Bans
  • KD, 1902, Aëronautische Preise in St. Louis
  • last ones:
  • Publication 4265, 1909, Extraordinary conference of the FAI in London in January 1909
  • Publication 4266, 1901, The Ezekiel airship
Warning messages
  • Importing...
  • Unable to construct a valid title from "Duperré, , Mittel, Luftballe, zu lenken. Description les machines et procédés consigné dans les brevets d'invention, de perfectionnement et d'importation dont la déchéance a été prononcé; publiée par les ordes de M. le ministre de l'interieur de l'agriculture et du commerce".
  • Unable to construct a valid title from "Dupuy de Lôme, 1876, Note sur l'aérostat à hélice, construit pour le compte de l'état, sur les plans et sous la direction de M. Dupuy de Lôme. Note remise en décembre 1871 à la commission chargée de suivre les essais, puis, lue à l'académie le 5 février 1872".
  • Unable to construct a valid title from "Durupt, 1902, Système d'hélice à ailes réversibles. (Appareil de Marque, dont le principe repose sur la réversibilité des ailes plates de l'hélice qui peuvent pivoter sur elles-mêmes de 180° et occuper toutes les positions inter- médiaires entre la parallèle et l'équerre à l'axe moteur.)".
  • 1,047 pages will be created from the CSV file.
  • To do: look at the Brockett original of the peculiar character in here: Chevalier, 1856, Eugène Godard
Pubs #9 import, Dec 27, 2018
  • I was able to add a comment this time, saying "Publications import #9". Let's see if that shows up on the imported pages. Yes it does, good.
    • Unable to construct a valid title from" Géo, 1900, ]La catastrophe du Géant de Berlin".
    • Unable to construct a valid title from "". (7348 copies of this error message ; need to get rid of blank recs at the end I guess)
    • 2,016 pages will be created from the CSV file.
  • Hey, good! Larger group than ever before. And no page titles were too long.
  • Got up to and including "Hollands, 1884, Artificial flight attainable"
  • Next up is "Die Eroberung der Luft. Kulturroman aus dem Jahre 1940"
upload 10, Jan 11, 2019
Pubs #11 import, March 12, 2019
  • It's been an extraordinary amount of work, getting the quality up on ~2287 records. It's taken months ; thought it could be done a month ago.
  • All right! Three records were rejected: Koch 1901, Aeronaut und Flugtechniker; La Vaulx 1903, Seize mille kilometres; and Meusnier 1784, Memoire sur l'equilibre; all quite possibly because of long titles
  • It reports that 2282 pages will be created from the CSV file
  • got from Brockett #6444 to Brockett #8701
  • There are 6804 publications around the start time of the import; this will get us to over 9000
Pubs 12, the biggie, nearly final

Jump to: navigation, search

Importing...

Unable to construct a valid title from "Neyen, 1908, Das Luftschiff ohne Ballon. Neueste Errungenschaft der deutschen Technik (Patentiert in den meisten Kulturländern) 'Ein neuer Weg zu Beherrschung des Luftmeeres.' Vortrag geh. im Febr. & März, 1908, im Bofliner Architektenhaus, Wilhelmstr. vor den hervorragendsten Ingenieuren, den Vertretern der Presse u. vielen deutschen Reichstag-abgeordneten".

Unable to construct a valid title from "Schrötter, 1901, Communications d'expériences physiologiques faites pendant un voyage en ballon à 7500m et rapports de différents essais concernant l'étude et l'influence de l'air raréfié sur l'organisme humain. (Internationaler Physiologen-kongress Juni 1901.)".

Unable to construct a valid title from "Hagen, 1875, The Measurement of the Resistances Experienced by Plane Plates when they are Moved Through the Air in a direction Normal to their Planes. (Messung des Widerstandes, den Planscheiben erfahren, wenn sie in normaler Richtung gegen ihre Ebenen durch die Luft bewegt werden.) Translated and republished by Abbe/Smithsonian".

Unable to construct a valid title from "Publication 12307, 1909, Verschiedenes. Ligue Méridionale Aérienne Flugversuche in Berlin, All-russischer Aero-Club, Eine Motorboot- und aeronautische Ausstellung in Berlin 1910, Meteorologischer Kursurs für Ballonfuhrer beim Cölner Club für Luftschiffahrt".

Unable to construct a valid title from "Wegener, 1906, Bericht über die während der Tage vom 28 bis 31 August 1905 anlässlich der Sonnenfinsternis vom 30 August am Aeronautischen Observatorium ausgeführten Anfstiege. Ergebnisse der Arbeiten des Koniglich Preussischen Aeronautischen Observatoriums bei Lindenberg im Jahre 1905".

Unable to construct a valid title from "Publication 12309, 1908, Verschiedenes. Zeppelins Flugrekord, das Militärluftschiff, Farmans Flugrekord, Ellehammer, der dänische Flieger, Eine Vogelflugmaschine, Kleben der Reisbahn, Die Reorganisation des Aero-Club of St. Louis, Kriegsluftschiffahrt in Brasilien u. s. w.".

Unable to construct a valid title from "Wegner-Dallwith, 1908, Die Aeroplane u. Luftschrauben der statischen u. dynamischen Luftschiffahrt schwerer und leichter als Luft. Eine gemeinverständl. Beschreibung ihrer Anordung u. Anleitg. zu ihrer Berechnung f. Konstrukteure, Luftschiffer u. Liebhaber".

Unable to construct a valid title from "Publication 10659, 1817, A narrative of the aerial voyage of Mr. William Sadler across the Irish Channel from Porto Bello Barracks in the neighborhood of Dublin on Tuesday, July 22, 1817; to which is annexed a chart of the channel showing his course and place of descent".

Unable to construct a valid title from "Bell, 1909, Outlook on aviation. Wright Steering device, Cortland Field Bishop, French Aeronautic Congress, London Aeronautic Congress, The Hudson-Fulton Celebration, Orville Wright, Aviation at Annapolis, The Aero-Club of St. Louis, Aeroplane Race at Monte Carlo, An Aero Club at Washington, E. P. Newman, inventor. The French Salon, Vaniman, Inventor, Bleriot's new Bi-plane".

Unable to construct a valid title from "Publication 13422, 1909, Experiments at Beinn Bhreagh. 2 Practice flight with model of Cygnet II on Baddeck Bay, July 6. 3 White Oionos kite flown upside down, July 6. 5 White Oionos kite flown upside down, July 12. 6 Practice flight with model of Cygnet II on Baddeck Bay, July 12. 7 White Oionos kite flown upside down and towed by the Gauldrie on Baddeck Bay, July 13. 8 Double Oionos kite of red silk form and towed by Mr. Bedwin's motor boat 'Swerm' on Baddeck Bay".

Unable to construct a valid title from "Sherrick, 1908, Johnson Sherrick, president Aero Club of Ohio. [The future of aerial navigation.]".

Unable to construct a valid title from "Urquhart, 1786, Institutes of hydrostatics; to which is added [211-254] a philosophical essay on air balloons".

Unable to construct a valid title from "Wrights, 1906, The Wright Brothers' flying machine and what it has accomplished. (A communication from Messrs. Orville and Wilbur Wright to the Aero Club of America, giving details of the development of their motor-driven aeroplane. Also a letter to the Aeronautical Society of Great Britain and a short account of Santos-Dumont's helicoptere.)".

Unable to construct a valid title from "Riabouchinsky, 1909, Recherches sur les hélices aériennes. 1. Considérations générals sur les sustentateurs. 2. Étude sur la circulation de l'air autour d'une hélice ramant à point fixe. 3. Sur les hélices sustentatrices. 4. Sur les hélices propulsives".

Unable to construct a valid title from "Publication 10152, 1784, Rapport fait à l'Académie des Sciences, Belles-Lettres et Arts de Lyon, sur l'expérience de l'aérostat faite le 19 janvier 1784, auquel on a joint une dissertation de quelques académiciens, sur le fluide principe de l'ascension des machines aérostatiques, developpé par l'action du feu".

Unable to construct a valid title from "Publication 9339, 1784, Observations sur le rapport fait à l'Académie des Sciences, Belles-Lettres et Arts de Lyon, le 19 mars, à l'occasion de l'expérience de l'aérostat de M. Joseph de Montgolfier, faite aux Brotteaux, pres de cette ville, le 19 janvier 1784".

Unable to construct a valid title from "La Vaulx, 1903, 1600km en ballon de France en Poméranie. A l'île de Walcheren. La coupe des aéronautes. À la recherche des Léonides. De Paris à Emden. Par la tempête. À travers les Alpes. Concours d'altitude. De France en Russie. Méditèrranéen I et II".

Unable to construct a valid title from "Surcouf, 1902, L'aéronautique maritime (équilibre; stabilisateurs statiques; compensateurs hydrauliques; déviation; principes; paradérives lamellaires; déviateur lamellaire; suspension et nacelle; engins de ralentissement et d'arrêt; organes de commande)".

Unable to construct a valid title from "Publication 9338, 1906, Observations en ballon pendant l'éclipse du 30 août 1905. Rapport de la mission aéronautique envoyée, par le ministère de l'instruction publique à l'effet d'observer en ballon l'éclipse totale de soleil du 30 août 1905, dans la région de Constantine (Algerie)".

Unable to construct a valid title from "Lenoir, 1784, Ordonnance de police, qui fait défenses de fabriquer et faire enlever des ballons et autres machines aérostatiques auxquels seraient adaptés des réchauds à l'esprit de vin, de l'artifice et autres matières dangereuses pour le feu; et ordonne que tous autres ballons aérostatiques ne pourront être enlevés sans en avoir préalablement obtenu la permission. Du 2 avril 1784".

Unable to construct a valid title from "Publication 10186, 1899, Recherches de Le Dantec et de Canovetti sur la résistance de l'air. (Enrégistreur électrique pouvant consigner sur un papier la durée exacte de la chute; loi des périmetres; détermination du coëfficient K. de la résistance de l'air.)".

Unable to construct a valid title from "Publication 9994, 1905, Procès-verbal de la séance des Sociétiés Technique et Géographique Impériales Russes réunies pour souhaiter la bienvenue aux membres du IVe congrès de la commission scientifique internationale de navigation aérienne tenue le 17-30 août 1904".

Unable to construct a valid title from "Voyer, 1901, L'équilibre de l'aérostat et les ascensions au long cours (de l'équilibre de l'aérostat; des ruptures d'équilibre; des perfectionnements à apporter à l'aérostat; du la manoeuvre de l'aérostat; du guide-rope; de l'équilibre dynamique, thermique et statique; du renouvellement du gaz)".

Unable to construct a valid title from "Tissandier, 1883, Le problème de la direction des aérostats. Application de l'électricité à la navigation aérienne, Conférence faite à la Sorbonne le samedi 3 mars 1883 et au groupe de l'association des anciens élèves de l'école centrale de Paris".

4,838 pages will be created from the CSV file.

Brockett 2, 1909-16

  • upload 14 was small and went fine ; it seemed not to upload all the pages but then I counted and it had
upload 15, a big one
  • 2979 records, selected by US or Austrian, and avoiding the hardest cases. it took a LONG time to edit the keywords though.
  • might have lost one by Hare, who has 3 publications
  • something went wrong with login password so I am trying to reset it
  • argh ; need to upload from Mac because I don't have a password that'll get me in on Windows. Need to ask YK for that.
  • so I selected the US ones, cutting the 499 ATs and the 1 FR
  • then some odd character was saved in the first position by Mac Excel. I took it away with a pico edit. Unclear whether other things changed; diff reports yes. I can study that later.
  • attempted to upload 2480 records. but [] are apparently unacceptable as page titles.
  • messages:

<pref> Importing... Unable to construct a valid title from "Publication B2p0724e15, 1915, Military honors for dead army airman. [Death of Capt. George H. Knox". Unable to construct a valid title from "Lahm, 1913, [John Wise.] A pioneer American aeronaut". Unable to construct a valid title from "Roosevelt, 1916, Roosevelt administration in 1907 gave the United States Army the first aero-plane ever used for military purposes—another Roosevelt administration seems to be the only hope to give the U. S. Army and Navy their much needed air service". Unable to construct a valid title from "Willoughby, 1910, [Letter.". Unable to construct a valid title from "". 2,476 pages will be created from the CSV file.

  • was able to change passwords finally
upload 16, the remainders from that block, maybe 504 of them
upload 17
  • 1,055 pages will be created from the CSV file. mostly americans
upload 18, a big one
  • 3439 records mostly american. started on May 18, 2020
  • keep making the "Free text" not "Free Text" mistake.
  • Oops! Unable to construct a valid title from "Publication B2p0314e03, 1912, [The Curtiss hydro-aeroplane or flying boat".
  • I'll have to move that one into import #19
  • The good news: "3,438 pages will be created from the CSV file."
  • Main page says there are 18,417 Publications at the time I begin the import, so we should have 21,855 when it ends.
upload 19
  • focused on Italian publications; 363 entries; started May 22, 2020, and finished on May 23
  • went smoothly
  • as it was importing I finished fixing the last bad import characters from import 15
upload 20
experimental, from huge cleaned up file, after long delay, Dec 10, 2020
  • just 7 German publications, carefully programmed and worked out, to verify I've got a procedure that works
  • Bleah. Two came in right ; two had diacritics which imported to pages but the pages don't display right and I will have to patch them ; and three didn't even create page titles. The messages:
Importing...
Unable to construct a valid title from "Publication B2p1469e05, 1909, Die W�rdigung der Wrightpatente durch die flugtechnische Gesellschaft".
Unable to construct a valid title from "Publication B2p1445e20, 1913, Eine franz�sische Fliegerin "Ritter" der Ehrenlegion".
Unable to construct a valid title from "Publication B2p1445e21, 1912, Eine f�rstliche Flugzeugf�hrerin".
4 pages will be created from the CSV file.

See Brockett-6y-sample20-03.xlsx for the 7 attempted here, of which it looks like 4 made it.

upload 21

For now I'll hold off on those German ones, and will just try to get something in. Focusing on English-language publications for now. Will later test UTF-8 vs UTF-16 and PC-stored vs Mac-stored to see if there's any workaround for those characters with diacritics. Now marking upload 21 in Brockett-7a.xlsx.

Errors in accented characters

Cleaning up the accented-character mess created by upload 7 with mass updates

Accented characters: å â à ä æ ß ç é è ê É ô Ö ö î ô ò ó ø û ù « » °

Replace these: ê é ë ô ç è ü ö ä à É û ù â ï ñ
By these: ê é ë ô ç è ü ö ä à É û ù â ï ñ