Address Entry Tricks for the Public Education Database

Steve Johnson and the IT Group has prepared a new Application Note entitled “Address Entry Tricks for the Public Education Database” that includes a special section for units in Puerto Rico and the U.S. Virgin Islands, as well. As you are entering your 2015 courses into the database, you may find this application note of particular value.

The application note explains in detail how the PE Dashboard validates the addresses you enter, and gives you tips and tricks for getting validation almost every time, with the markers on the automatically generated PE Course Flyer and Google Maps link, to the degree possible, accurately reflecting the true location of your course’s meeting place.

The latest copy of this application note can always be found online at the following permalink:

http://wow.uscgaux.info/user_docs/PE_Database_Address_Entry_Tricks.pdf

As always, if you have difficulty entering any address, after consulting with and following this new Application Note, please use the provided “Feedback/Bug Report” button at the bottom of the PE Dashboard.

Cute Editor Doesn’t display Properly in IE11

Internet Explorer 11 (which comes with Windows 8.1) does not display the Cute editor properly when trying to edit a WOW announcement. To cause it to function properly you have to set it into compatibility Mode.

Read more »

Your Unit Meets Irregularly But Your WOW Website Assumes You Meet Monthly: The Fix...

WOW gets its information about the meeting place, day, and time of you flotilla, division or district from the "Unit Record" in AuxDirectory (AuxOfficer). Your flotilla commander, when logged onto AuxDirectory can change this, and other information, which will then show up in WOW the next time you open a fresh Web browser and go to your site.

WOW expects you unit to meet monthly, and on the "About this Unit" page, automatically tacks on "of each month" after the meeting day that you enter.  For example, if your meeting day in AuxDirectory is "3rd Monday", then WOW displays "3rd Monday of each month".

What do you do if your unit meets irregularly, and  you want to suppress that "of each month" text? Easy: simply enter a pound sign ("#") at the end of the meeting day field, and WOW will suppress the extra text.

For example, Division 095-45 meets every other month, from January. When the SO-CS entered "3rd Thurs in Jan, Mar, May, Jul, Sep, and Nov" she got "3rd Thurs in Jan, Mar, May, Jul, Sep, and Nov of each month" -- a nonsensical result.

However, when she entered "3rd Thurs in Jan, Mar, May, Jul, Sep, and Nov#" (note the #-sign after "Nov") WOW displayed "3rd Thurs in Jan, Mar, May, Jul, Sep, and Nov".

This can be useful for Districts, for example, that have four (4) meetings a year on specific dates: "Jan 23, Apr 15, July 23, Nov 1. Other times by announcement.#" entered into AuxDirectory will reproduce only that text (minus the #-sign).

If your meeting times are also irregular, leave the meeting time field blank. You can add the time in the meeting day field, if desperate, as in "Jan 23 (0900), Apr 15 (1300), July 23 (0900), Nov 1 (1030). Other times by announcement.#".

PE Course Address Won't Take? Try This

Occasionally, PE officers trying to enter a course into WOW's National Public Education Course Database get an error message that they have a bad address, which they KNOW (wink, wink) is correct.

The first line of defense is to check the address with the U.S. Postal Service, at their "Look Up a ZIP Code" page. Then, use the resulting address for entering into the PE Course Dashboard, letter for letter, copying the same abbreviations (ST for Street, FT for Fort, etc.). This will usually do the trick.

However, some addresses resist even this.  WOW uses Yahoo!'s geocoding Web service to validate addresses and get the meeting location's latitude and longitude for the marker on the map found on the course flyer. The reason WOW will not accept a questionable address is to avoid producing a map that shows the location of the course in, say, the Canary Islands.  But Yahoo! is actually more discriminating than the Post Office, and on occasion will find an address that it believes exists in more two or more places, the Zip Code notwithstanding

In such a case the PE Dashboard will reject the address and say that it is ambiguous.  What you can do then is to give it a little help: simply tack on the county name after the city, in the city field.

For example, if the address "322 Huff Street, Aransas Pass, TX, 78336" comes back ambiguous (it does), simply tack on the county name (San Patricio) right after the city name, in the "City" field:

Before: "Aransas Pass"
After: "Aransas Pass, San Patricio County"

You can also use the IT Directorates Geotest Utility to experiment with addresses (or find the geodesic coordinates -- i.e., latitude and longitude -- of your flotilla's meeting location for entry into AuxDirectory, etc.) and see how Yahoo's geocoder acts with a specific address. Sometimes, with a little experimentation, you can find the right "tweak" on the address (such as changing "Fort" to "FT" or Harbor to "Hbr") that does the trick.

The WOW Geotest Utility is at: wow.uscgaux.info/geotest.php.

Finally, note that if your course is being held on a military base, the official USPS address of that location is that of that base, such as "McClellan AFB, CA" rather than the surrounding city.

New: Roles-based Pages

Roles-based Pages allow a webmaster to create protected pages that only appear in the left navigation menu when a "Member Zone" user is both “logged on” and has either a specific qualification (INT, AIROBS, etc.) and/or a specific office (FSO-CS, DSO-CS, etc.).

Role-based pages can be used whenever you want to share information with a select group of individuals or if you need to share sensitive information with a select group. For instance, you might create a page about auxiliary patrols that you want to share only with the boat crew.  A DSO-CS folks may want to share specific instructions for updating flotilla websites that is only of interest to FSO-CS or SO-CS.  Interpreters (INT) may want to share information on deployments that would be applicable to fellow interpreters and the DIR-I.  The list is endless.

All of this is explained in a new Application Note entitled: WOW II Pushbutton Website Platform: Using Role-based Pages. A copy of this application note may be downloaded from the documentation page in this dashboard.

Text and Heading Centering Bug Has Been Eliminated

WOW users who have had difficulty in centering text or headings with the "center" icon will be pleased to know that a bug was found in the custom CSS styles that are part of WOW.  That bug is now splattered on the windshield of progress. Centering works now on all tags, both in the Cute Editor, and on the rendered web page.  You may have to flush your browser's cache to drive out the old CSS.

Finally! WOW Does Email Forms

Have you been wanting to create a form on your WOW site that visitors can fill out and submit to you? Now it is possible using WOW Email Forms. Although this is an advanced technique, it is not difficult to quickly create a response form that automatically is emailed by WOW to one or more persons of your choosing.  The feature comes with enhancements to the Cute Editor for forms and tables.

Read all about it by clicking Documentation to the left, and downloading the Application Note.  Be sure the also read up on Hidden Pages, a technique you will use for a confirmation page for your form.

New: "Smart Tags" for Maintenance-free Pages

“Smart Tags” in a WOW website are pieces of text that you can put into your Web page, on any announcement (post), that are replaced when the page is displayed with “dynamic” information. Examples include unit staff members, contact information, and even personalization information for the member logged on -- all drawn in real time from AuxDirectory. Make any page with personnel information "maintenance free." Download the Application Note  under "Documentation", to the left.

Hidden Pages Revealed

WOW II now has the ability to support hidden pages. Hidden pages are regular WOW pages that do not show up in the left menu, but are otherwise part of your site, and can be linked to.

Hidden pages are particularly useful as confirmation pages for WOW Forms, which prefer to have a page for the user to land on after entering a form, saying something like "Your form has been emailed.  Thank you for your <whatever...>". However, you may also use a hidden page like any other page.  You just have to arrange links to the hidden page from visible or protected pages.

All of this is explained in a new Application Note entitled: WOW II Pushbutton Website Platform: Using Hidden Pages. A copy of this application note may be downloaded from the documentation page in this dashboard.  While you are there, pick up any other documentation that you have not read in a while.   Click on Documentation to the left.

Custom Pages Now Feature Human-readable Slugs; Push Button Update

Since its introduction, WOW II has featured unlimited Custom pages. You may have noticed that the generated link to these pages is always a unique, ten-digit number(*) as follows:

http://wow.uscgaux.info/content.php?unit=115-12-05&category=1324573457

This number is then associated with the menu entry and all of the content (announcement) entries in the WOW database, enabling the correct page to be constructed dynamically. Unfortunately, a ten-digit number is not particularly intuitive or memorable.

WOW has now been upgraded to use slugs - human-readable phrases based upon the actual menu entry - instead of the ten-digit number. For example, if you create a custom menu item "Get a VSC Today!", the slug will be "get-a-vsc-today", and page's URL will be:

http://wow.uscgaux.info/content.php?unit=115-12-05&category=get-a-vsc-today

Slugs are popular because they enable search engines -- which treat the words in the slug as keywords -- to find the page.

All custom pages created after May 30, 2012 will have slugs in their URL. Custom pages bearing the old ten-digit category code may be converted with a new push button utility that appears in the WOW Dashboard, called "Rewrite Custom Slugs". Look for it under "WOW Utilities" in the Dashboard's left menu. Simply click this "link" and all of the custom page URLs in your unit's site will be converted. In addition, all links to converted pages anywhere in the entire WOW II system will be converted as well.  This means, for example, if a flotilla website contained a link to a custom WOW page on a district site -- as an external menu item or coded into an anouncement -- this link will be converted in the database so that it will continue to point to the correct page.

Webmasters, however, should be cautioned that if you published a link to a custom page outside the WOW system, for example on an AIRS website, on a third-party site, or even in a brochure or flyer, that link will be broken after you click "Rewrite Custom Slugs". To aid you in manually converting these, the Dashboard produces a cross-reference report in the "Rewrite Custom Slugs" utility.

All units are asked to use the "Rewrite Custom Slugs" utility to update their site as soon as possible.

-------

(*) Geeks among you might be interested to know that the ten-digit number is actually the number of seconds since the beginning of the UNIX epoch (0000 GMT on January 1, 1970) at the instant that you created the custom menu item. For further reading, see Unix Time in Wikipedia. For more about slugs, read "Slug (Web Publishing)" from the same source.

Sort Order on Calendar Pages; Best Practices

We recommend that you use a calendar like Google Calendar for your unit, and simply embed the calendar link right in the page. We recommend the "Agenda" view, which displays events in a list, ordered from earliest date to latest date, rather than a classical "tabular" calendar. But it's your choice.

However, if you insist on creating an agenda-style calendar using the Announcement Editor, you must be aware of the following strategies and best practices, in order to get your calendar to appear professional, and sorted in the right order:

  1. Use one (1) announcement per event.
  2. Put the date and information about the event in the "CaptionField", like this: "04 APR: This is my event".
  3. Check the "Show on Page" checkbox to force this caption to be displayed on the page as your calendar entry.
  4. Set the "Start Date" to the date of the event. WOW sorts calendar pages by Start Date, not by Sequence (Sequence is ignored).
  5. Set the "End Date" to the day after the event, if you want the event to disappear automatically after it is over. If, instead, you want all events, future and past, to remain in the calendar all year, then set the End Date to "December 31, <current year>".

The formatting in #2 is very important; if you want the events to more or less line up vertically, they you should assure that all dates are written with two digits (i.e., leading zero) and all months are abbreviated with three (3) characters.

The body of the announcement will normally be left empty, unless you have additional information to add.  Be sure to keep the font sizes in the additional information at the default sizes. If you go larger, your page will look amateurish. And avoid brightly-colored fonts. Stick to the WOW pallette.

The Member ID and Password text boxes disappear from the Member Zone Login window.

A problem unique to the Cute editor used in WOW can result in the Member ID and Password fields disappearing in the Login window, so that members cannot login to a WOW web page. This occurs in rare cases when the Import WOW-I button resulted in some bad html code being inserted into the top of a WOW II page. This also results in a ¼” deep white bar showing to both sides at the very top of the page.

  1. The fix is to remove the bad lines of html code by editing the page(s) involved:
  2. Login by gaining access to your site by using the generic WOW login at http://wow.uscgaux.info.
  3. Go to the Configuration Dashboard, and edit the page in question. This will bring up the page in WOW’s Cute editor.
  4. Switch to HTML view in the editor instead of Normal view (select HTML on the lower left of the editor window).
  5. At the top of the page in HTML view, look for and delete all code between successive sets of <style type=>……</style> tags. Do this until you get to a tag <.....> that is not <style>. These problem lines at the top of the page will look something like the following examples:

    <style type="text/css" isprelink="true">@import url(http://wow.uscgaux.info/cuteeditor_files/Style/SyntaxHighlighter.css);</style>
    <style type="text/css">@import url(../content_cute.css);</style>
    <style type="text/css">@import url(php.css);</style>

  6. Note that each of the problem code lines always begins with “<style type=”, and end with “</style>“. There could be anywhere from one to more than thirty of these lines that need to be stripped.
  7. Go to the bottom of the page, look for and delete any lines that also say the same as #4 above, starting at the last line, and working backwards to the first non-style tag.
  8. Save the page.
  9. View the unit page, and confirm that the white bar is gone, and the member login boxes appear again.

 

Addresses and Maps in the PE Calendar: Having Problems?

Updated April 27, 2012

The PE Calendar uses a geocoder service from Yahoo! to double-check the addresses and Zip Codes you enter. 99% of the time, it works fabulously, and prevents numerous errors from being made. Occasionally, however, it can be tempermental. When it is, try the following:

  1. Enter your address without the Zip Code, and then use the 5-digit Zip Code that shows up in the error message.
  2. Use our raw geocoding test utility to check out how the address wishes to be represented.  It's at http://wow.uscgaux.info/geotest.php.  Simply type in your address freeform, with commas, and leave out the Zip Code (it will be provided).  The address that you get is the one that will work in the PE calendar.
  3. Check with the U.S. Postal Service here. Enter your address without a Zip Code to start.  If the USPS reports "The address you provided is not recognized by the US Postal Service as an address we serve", then you have the address wrong, whatever you think.  See "Common Errors", next section.

Common Errors
Here are the most common address errors made during address data, in decreasing order of frequency:

  1. You are putting an address (e.g., 1234 Main St.) in the "Location" field. The location field, required, is the name of the building or meeting place, such as "Fire Station Room 235". It may not be a street address. The field immediately below "Location" is called "Address", and it is called that for a reason. That is where you put the first line of the street address.
  2. You are attempting to enter a Location in the Address field (opposite of #1).
  3. You are omitting North, South, East, or West (or N, S, E, or W) from a street address.  Even though you've lived there for over 40 years and think of City Hall as 100 Main Street, the Post Office (and our geocoder) insist you enter it "100 N. Main St." if that is the legal address.
  4. You are attempting to enter a street address on a military base using the city that the base is in. For example, you enter "Location" as "Travis AFB Youth Center" and the full address as "310 Fairchild Drive, Fairfield, CA 94535". This will fail; the use of the city "Fairfield" in which Travis AFB is located is incorrect. Instead, for "City", you must enter either "Travis AFB", or "Travis Air Force Base". This is consistent across the country; the "city" for any military base is the name of the base itself.

Maps in the Flyer
The marker showing the course location in the PE flyer is also from Yahoo's geocoding service.  It, however, takes the latitude and longitude provided based upon the address, and then tells Google Maps (which actually renders the map insert on the flyer) where to place the marker.  For some reason, Yahoo's geocoding of addreesses to lat/lon is sometimes a little off.

We are working on switching the map marker over to Google's geocoder, but due to higher-priority projects, that might not get done as soon as you would like.

Custom Icons Now Possible at Top of Left Menu

If you would like to emulate some of the national departments that have their department seal at the top of the left menu system (for example, the IT group at http://itgroup.cgaux.org), you can now do it.

Take your official district, department or flotilla seal -- high quality, of course -- and make it exactly 130x130 pixels.  If your seal is not round, then crop to the widest dimension, resize to 130px along that dimension, and then crop the other dimension to 130px as well. Your background can be white (#FFFFFF) or transparent.  Save it as a JPEG file, with the file extension ".jpg".

Next, rename the file based upon your canonical unit number, except without the dashes.  For example, if your unit is 114-12-04, then rename the file:

1141204_icon.jpg

So, the file name is your canonical unit number without the dashes, with "_icon.jpg" tacked on.  If you name this image anything else, this won't work.

Finally, you need to upload the image to WOW.  Simply enter the configuration dashboard, edit any announcement on any page, and click on the "image upload" icon (the mountain with pencil). Browse to the file wherever you left it on your computer, and upload it.  Do not insert the image into the announcement you have opened! Just cancel out of the image upload dialog, and click on the "Return to Unit Site" button.  If you did everything correctly, the custom icon will appear at the top of the left menu, in place of the AuxWeb icon.

Your Auxiliary Email Address is "uscg.mil"? You May Not Be Able to Configure WOW

If the Member Zone password you set up was validated using a uscg.mil email address (that is, your primary email address listed in AuxDirectory/AuxOfficer is your.own.name@uscg.mil, then you may not be able to configure either WOW or the Public Education Database. Currently, 0.37% of Auxiliary members have uscg.mil email addresses.

The reason is that AuxOfficer categorized you as an active duty member when you applied for the password, even though you are a member, starting fall of 2011.

If you fall into this category, simply revisit the AuxDirectory/AuxOfficer sign-in page, and from there request a new password (it can be the same one) using "Obtain/Change Password". Or, just click this link.

Safari Browser (Macintosh or PC): Don't Use for WOW Editing!

There is a problem with the Safari browser on both Macs and PCs: images inserted into your WOW page cannot be edited after insertion in the WOW announcement editor.  This is a problem specific to Safari, and does not occur with other browsers.

If you are a Safari user (usually only Macintosh users), please download and use Firefox as your default browser for working with your WOW site.  www.firefox.com

The guts of the editor are licensed froma 3rd party, and it may not be possible to fix this Safari limitation in the near future.

Sample District WOW II/National PE Calendar PowerPoint Presentation Available; DSOs Take Note!

District Staff Officers and Divsion staff officers, take note:  District 11SR has shared with us their very-well-received, January 2012 WOW II and National Public Education Calendar presentation.  Although it comes without script, it is pretty easy to figure out what to say.

You can download both the presentation and the PowerPoint show by clicking on the Documentation button here in this dashboard, and reading the section "WOW II Presentations".  For convenience, the links are also below.

This presentation is ideal for division staff officers to present at division staff meetings, when all the flotilla commanders are there.  District staff officers: take this presentation, substitute in your own name and statistics for your district, and distribute to the SO-CS officers in your chain.

For best results, download both the presentation and the show, and watch the show first. This will give you a sense for how to present the key messages on each slide.  Good luck!

WOW II District 11SR PowerPoint Presentation (January 7, 2012)
WOW II District 11SR PowerPoint Show (January 7, 2012)

Licensee Error (1) Host Not Match!

If you get the error "Licensee Error (1) Host Not Match!<some URL>" when trying to enter data into the Announcement editor (Cute Editor), it is because you accessed the page via a corrupted URL -- usually from a bookmark -- that combines portion of a correct URL with additional incorrect pieces.  The only correct URL for accessing your site is its "canonical" address (see the User's Guide).  For example, if your unit number is 115-03-07, then your site's canonical URL is "a1150307.wow.uscgaux.info".  That is the address you should bookmark, and that is the address that you should share.

If this happens, throw away any bookmarks that you have saved to access your site, close your browser (all copies), and revisit the site with the canonical address.  If you persist in getting the problem, take a screen shot, save the image file, and use the "Feedback/Support" button in the Dashboard to ask where to email the screen shot.

Bug Fix: Future Announcements

The expectation is that announcements with a future start date will not appear until that date. This was not occurring, and future-dated announcements were showing up now. This has been fixed. Note that if you have any content that has mysteriously "disappeared", check to see if it mistakenly had a future start date.

PE Calendar: Entering the Same Course with Different Dates (Clone)

If you are offering the same Public Boating Course several times during the year, you or your PE officer may enter it one time, and then "clone" it repeatedly, changing the dates, etc. for each additional copy, as required.

To do so, in the PE Dashboard, simply EDIT the course you want to clone, change the necessary information, and use the 'SAVE AS NEW' button.

This technique may also be used after a course has concluded, and you wish to re-use the information for a future course.  In such a case, do not simply change the dates and use SAVE, for this does not send a new "Notice of Intent to Teach" to the DSP-PE, but use the SAVE AS NEW button.

Adding Your Own Content to the Default Home Page

Many of you have expressed interest in "hacking" the default home page to add you own photographs, or additional content.

The default home page is built-in, and cannot be edited per se.  However, there is nothing preventing you from creating your own home page with exactly the same underlying code as is used on the default home page. All you need is the code. Well, here it is:

http://wow.uscgaux.info/documents/story.zip

Here is how you use it:

  1. Go to the configuration dashboard, and start with a default home page (no announcements);
  2. Click on the link above, and download the story.zip file to your desktop;
  3. Double-click open the zip file, and either drag the story.txt file to your desktop, and open it, or simply click it open right in the zip window, if your version of zip allows that.
  4. Copy all the code in story.txt. For safety,  use CTRL-A (PC) or CMD-A (Mac), and do an Edit > Copy from the menu, or a CTRL-C (PC) or CMD-C (Mac);
  5. In WOW, on the home page dashboard, create a new announcement;  In the editor window, click on "HTML" at the bottom;
  6. Click your mouse in the editor window, and use CTRL-V (PC) or CMD-V (Mac) to paste the text you copied from story.txt.
  7. SAVE the announcement, and Return to Unit Page.

If you did it right, the home page will look identical to the default home page.  However, now you may go back and either edit that announcement, or add additional announcements on the home page to customize it as you see fit.

I Opted In to Email and Phone Numbers on the About Page, and They are Not There!

The documentation for WOW II informs you that if you are the unit commander, vice commander, or HR officer, you may opt in to showing your email address or phone number, or both, on the "About this Unit" page.  The opt-in/opt-out procedure calls for the respective member to log into AuxOfficer, and then navigate to his/her own page.  Halfway down, below the phone numbers, are four EDIT buttons that allow the member to edit their own settings.

Here's the secret handshake: Regardless of what the settings say in AuxOfficer, if you have never changed these settings before, they are not stored in the AuxOfficer database (where WOW finds them) until you change one of the settings for the first time, and hit SAVE. Then, and only then, is the information written to the database for WOW.  In particular, if you wish to opt IN, come to your AuxOfficer page for the first time, and the setting are already what  you want, you still must change something, hit SAVE, and then if necessary, change it back and hit SAVE again. Then, your choices will be reflected in WOW.

NB: WOW II "caches" all of the unit's information when you open the site for the first time, so as not to keep going back to the database over the internet.  In order to see the results of a settings change like this, it is necessary to close your browser AND ALL OTHER WINDOWS OPEN from the SAME browser, and then re-visit the site.  This causes the system to read the parameters again from the database.

WOW II User's Guide Released

The Computer Software & Systems Department is pleased to release a comprehensive-but-preliminary, 39-page User's Guide to the WOW II Platform, prepared with the assistance of our User Services and Support colleagues.

The PDF document may be downloaded from this Dashboard by clicking "Documentation" in the WOW Utilities menu to the left. A useful PowerPoint presentation on "WOW: Pushbutton Websites" can also be found there.

The User's Guide will be updated frequently as experience with the production release of WOW is gained.

If you have any suggestions for the User's Guide, or find any typos, please submit your comments via the Feedback button to the left.

Known Bugs

None known.

Zoom Bug in Internet Explorer 8 and below

When using the WOW Dashboard to configure a site, and your browser is Internet Explorer 8 or 7, Microsoft's View>Zoom command will cause the dashboard to break up if you set the zoom below 100%. Microsoft fixed this bug in IE9.

Workaround: don't Zoom your IE8 or IE7 browser below 100%.