\contentsline {section}{\numberline {1}Introduction}{4}%
\contentsline {section}{\numberline {2}Top-Level View of the Website}{4}%
\contentsline {section}{\numberline {3}Workflow for Building the Website}{6}%
\contentsline {subsection}{\numberline {3.1}Programs Used}{7}%
\contentsline {subsection}{\numberline {3.2}Useful Java Programs}{7}%
\contentsline {subsubsection}{\numberline {3.2.1}Clean}{7}%
\contentsline {subsubsection}{\numberline {3.2.2}dbe.jar}{8}%
\contentsline {subsubsection}{\numberline {3.2.3}makeweb.jar}{8}%
\contentsline {subsubsection}{\numberline {3.2.4}copyfiles.jar}{9}%
\contentsline {subsubsection}{\numberline {3.2.5}filebrowser.jar}{9}%
\contentsline {subsubsection}{\numberline {3.2.6}Java / sqlite-jdbc}{9}%
\contentsline {subsection}{\numberline {3.3}WinSCP and ftp}{9}%
\contentsline {subsection}{\numberline {3.4}emacs}{10}%
\contentsline {section}{\numberline {4}Building The Website}{10}%
\contentsline {subsection}{\numberline {4.1}Add-on Domains}{11}%
\contentsline {subsection}{\numberline {4.2}Transferring ``Ownership'' of the Website}{11}%
\contentsline {subsection}{\numberline {4.3}Typical Website Operations}{11}%
\contentsline {subsubsection}{\numberline {4.3.1}Adding A Dance}{12}%
\contentsline {subsubsection}{\numberline {4.3.2}Adding A Flyer to a Dance}{12}%
\contentsline {subsubsection}{\numberline {4.3.3}Adding A Flyer or Ad to the Classifieds}{13}%
\contentsline {subsubsection}{\numberline {4.3.4}Updating a Flyer}{13}%
\contentsline {subsubsection}{\numberline {4.3.5}Adding A Venue}{13}%
\contentsline {subsubsection}{\numberline {4.3.6}Adding A Person or Changing a Person's Information}{13}%
\contentsline {subsubsection}{\numberline {4.3.7}Releasing a new edition of the promenader}{14}%
\contentsline {section}{\numberline {5}The Database}{14}%
\contentsline {subsection}{\numberline {5.1}Automatically Generated Views}{14}%
\contentsline {subsection}{\numberline {5.2}The Main Tables in the Square Dance Database}{15}%
\contentsline {subsection}{\numberline {5.3}Tables, Views, and Triggers}{15}%
\contentsline {subsubsection}{\numberline {5.3.1}Table article}{15}%
\contentsline {subsubsection}{\numberline {5.3.2}Table articlecontent}{15}%
\contentsline {subsubsection}{\numberline {5.3.3}View articlecontentview}{16}%
\contentsline {subsubsection}{\numberline {5.3.4}Table articleproof}{16}%
\contentsline {subsubsection}{\numberline {5.3.5}View automation}{16}%
\contentsline {subsubsection}{\numberline {5.3.6}Table breakingnews}{16}%
\contentsline {subsubsection}{\numberline {5.3.7}View callers}{16}%
\contentsline {subsubsection}{\numberline {5.3.8}Table callerscuers}{16}%
\contentsline {subsubsection}{\numberline {5.3.9}Table classifieds}{16}%
\contentsline {subsubsection}{\numberline {5.3.10}Table club}{17}%
\contentsline {subsubsection}{\numberline {5.3.11}Table clubnews}{17}%
\contentsline {subsubsection}{\numberline {5.3.12}Table clubnewsproof}{17}%
\contentsline {subsubsection}{\numberline {5.3.13}Table clubofficer}{17}%
\contentsline {subsubsection}{\numberline {5.3.14}View cuers}{17}%
\contentsline {subsubsection}{\numberline {5.3.15}View clubs}{17}%
\contentsline {subsubsection}{\numberline {5.3.16}Table content}{18}%
\contentsline {subsubsection}{\numberline {5.3.17}Table dancechanges}{18}%
\contentsline {subsubsection}{\numberline {5.3.18}Table event}{18}%
\contentsline {subsubsection}{\numberline {5.3.19}Table eventcaller}{18}%
\contentsline {subsubsection}{\numberline {5.3.20}Table eventclub}{18}%
\contentsline {subsubsection}{\numberline {5.3.21}Table eventcuer}{18}%
\contentsline {subsubsection}{\numberline {5.3.22}Table eventpdf}{19}%
\contentsline {subsubsection}{\numberline {5.3.23}Table eventurl}{19}%
\contentsline {subsubsection}{\numberline {5.3.24}Table faq}{19}%
\contentsline {subsubsection}{\numberline {5.3.25}Table federationemail}{19}%
\contentsline {subsubsection}{\numberline {5.3.26}Table federationmeetings}{19}%
\contentsline {subsubsection}{\numberline {5.3.27}Table federationstaff}{20}%
\contentsline {subsubsection}{\numberline {5.3.28}Table monthname}{20}%
\contentsline {subsubsection}{\numberline {5.3.29}Table number}{20}%
\contentsline {subsubsection}{\numberline {5.3.30}View orphancallers}{20}%
\contentsline {subsubsection}{\numberline {5.3.31}View orphanclubs}{20}%
\contentsline {subsubsection}{\numberline {5.3.32}View orphancuers}{20}%
\contentsline {subsubsection}{\numberline {5.3.33}View orphanspecial}{20}%
\contentsline {subsubsection}{\numberline {5.3.34}View orphanpdfs}{21}%
\contentsline {subsubsection}{\numberline {5.3.35}Table pagesets}{21}%
\contentsline {subsubsection}{\numberline {5.3.36}View pagesetsview}{21}%
\contentsline {subsubsection}{\numberline {5.3.37}Table person}{21}%
\contentsline {subsubsection}{\numberline {5.3.38}personview}{21}%
\contentsline {subsubsection}{\numberline {5.3.39}Table promenaderstaff}{22}%
\contentsline {subsubsection}{\numberline {5.3.40}Table rafclubs}{22}%
\contentsline {subsubsection}{\numberline {5.3.41}View schedule}{22}%
\contentsline {subsubsection}{\numberline {5.3.42}Table scripts}{23}%
\contentsline {subsubsection}{\numberline {5.3.43}View scriptsview}{23}%
\contentsline {subsubsection}{\numberline {5.3.44}Table singlepage}{23}%
\contentsline {subsubsection}{\numberline {5.3.45}Table sitemap}{23}%
\contentsline {subsubsection}{\numberline {5.3.46}Table specialdances}{24}%
\contentsline {subsubsection}{\numberline {5.3.47}Table styles}{24}%
\contentsline {subsubsection}{\numberline {5.3.48}View stylesview}{24}%
\contentsline {subsubsection}{\numberline {5.3.49}Table substitutions}{24}%
\contentsline {subsubsection}{\numberline {5.3.50}View substitutionsview}{24}%
\contentsline {subsubsection}{\numberline {5.3.51}Table venue}{24}%
\contentsline {subsubsection}{\numberline {5.3.52}Table vieworder}{25}%
\contentsline {subsubsection}{\numberline {5.3.53}Table views}{25}%
\contentsline {subsubsection}{\numberline {5.3.54}Table weekday}{25}%
\contentsline {subsubsection}{\numberline {5.3.55}Trigger sch...}{25}%
\contentsline {subsection}{\numberline {5.4}Overall File Structure}{25}%
\contentsline {section}{\numberline {6}The Automation Process}{26}%
\contentsline {subsection}{\numberline {6.1}The substitutions Table}{27}%
\contentsline {subsection}{\numberline {6.2}The pagesets Table}{27}%
\contentsline {subsection}{\numberline {6.3}The scripts Table}{28}%
\contentsline {subsection}{\numberline {6.4}The Algorithm}{28}%
\contentsline {subsection}{\numberline {6.5}The Code}{29}%
\contentsline {section}{\numberline {7}New Promenader Website}{30}%
\contentsline {subsection}{\numberline {7.1}New Automation Process}{30}%
\contentsline {subsection}{\numberline {7.2}Current Promenader}{30}%
\contentsline {subsection}{\numberline {7.3}Top-Level Pages}{30}%
\contentsline {subsubsection}{\numberline {7.3.1}Home Page}{30}%
\contentsline {subsubsection}{\numberline {7.3.2}Clubs}{31}%
\contentsline {subsubsection}{\numberline {7.3.3}Wanted Pages}{31}%
\contentsline {section}{\numberline {8}Tools For Maintaining the Federation Website}{31}%
\contentsline {subsection}{\numberline {8.1}make}{31}%
\contentsline {subsection}{\numberline {8.2}latex and Friends}{32}%
\contentsline {subsection}{\numberline {8.3}Rebuilding the Documentation}{32}%
\contentsline {subsection}{\numberline {8.4}Rebuilding the Tools}{32}%
\contentsline {section}{\numberline {A}Setting Up The Tools}{33}%
\contentsline {subsection}{\numberline {A.1}Java}{33}%
\contentsline {subsection}{\numberline {A.2}SQLite3}{33}%
\contentsline {section}{\numberline {B}Overview of the Internet and Websites}{33}%
\contentsline {subsection}{\numberline {B.1}Domains on the Federation Website}{34}%
\contentsline {subsection}{\numberline {B.2}Domain and Website Fees}{35}%