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