Crumbs from the spork

Friday, May 10, 2013

OALM Election Checks

Checking Election Data Consistency in OALM 3.

Version 2 did not let us look at this view easily; in version 3, once Ordeal Candidates are registered, look at the Event Manager view, filtering as follows.

1

Monday, March 11, 2013

OALM 3 filtering

To complement and expand prior posts on the LodgeMaster 3 filtering steps, here's another view, with more pictures.

Figure 1 shows the header for "Full Name" and the triangle clicked to indicate sorting on that column value. The dues year is 2013, as the default starting point on these menus is the current year.

Figure 2 shows the results of clicking on another column header, Chapter, so the triangle there is highlighted. There isn't a secondary sort column - I would expect the prior results (by full name) would be used after Chapter. I have not found a way to add a second sorted by.

Figure 3 shows the "funnel" action, distinct from the triangle, which brings up a checklist. This works fine for few distinct values; less so for wide ranges such as name. The sort order remains, for those rows that are left.

Figure 4 shows the filter editor, after clicking on "Advanced Filtering", where the columns selected by the prior "funnel" checklist have been converted to a logical clause ("Is any of").

Five adds another cause, with the choice of operators highlighted. These will change depending on the field being character, numeric, date, etc.
I would use these options where I could, rather than the checklists, since keeping all the logic in one place avoids incorrect documentation - the funnel values may not be listed in some cases.

Six shows the necessity for selecting prior dues years, and perhaps future, to get a wider range of records. I can't select a range without clicking each one, although there is a button at the top for "all" or "none". Writing a "between" clause makes more sense to me.

Seven adds a between clause for last name.

Eight shows more of the conditions than figure 5 above shows. The icons help to visualize the logic. What's not easy for me to create using these menus is anything with precedence or grouping.

Thursday, March 7, 2013

Function or Control? You decide

New laptop. New keyboard. Cleaner, but things are not where I left them.

Who moved my control key? Again.

Friday, March 1, 2013

OALM chapter members

1

members for The Capitol Chapter
which years
their contact info
respective level
have several members that have not paid their dues and are trying

2

3

Wednesday, February 27, 2013

OALM 3 - Dues Paid Check

In the updated version of the Order of the Arrow "LodgeMaster" membership database, there are new ways of looking for information. One we struggled with in prior versions was checking on dues paid status for individuals, whether in a unit, or in a Lodge position. Below are the results of a query where I altered the "dues years to include" to cover the range 2010 through 2012. Not shown is the advanced filtering condition where position is not empty.

You'll notice there are dues paid records for 2013, though one might expect these to be outside the range specified. The reason these appear is that these members also paid in a prior year, so they match the rules given.

To view only those records in the range requested, you will need to add an "exclude" year condition so that the current year does not match.

Monday, February 4, 2013

OALM 3 - Possible Election Data Entry

@jspath55

The following views of OA LodgeMaster 3 should be close to the version others will see once the release happens and our database is upgraded. These screens are from the web version, which can and probably should be used for future election entry.

I'll show how to limit the view to one unit, as someone would when entering election results from one unit. The date for the Youth should be set.

Figure 1 - a basic roster view, with all dues year, as well as "non-Ordeal" added.

figure 2 displays the "column chooser" - I added unit number, election date, etc.

figure 3 shows a single unit, after adding a match in the "Advance Filtering" menu

figure 4 is the same unit, with Ordeal and other honors removed.

figure 5 - clicking on "Add" member gives a basic personal data entry screen, as in the desktop version for 2.x. Only first and last names are mandatory, but many more would normally be needed for each Candidate.

figure 6 - one fictitious member mostly created. The OALM ID is still 0, and the Contact tab has been glossed over. I added Callout information, which may or may not be ready, if ever, for any who are elected.

figure 7 - a more filled-out member information tab.

figure 8 is back to the primary (multiple) membership record list, with one additional election record than previously. If several were elected, they would be added after this, one by one.

The web version saves regularly, so there should be no "synchronization" required.

Monday, December 10, 2012

Top Ten Movies at The Bengies Drive-In - 2012

The Bengies closed out their 2012 season in November. I missed the last few weeks due to traveling, and though I was hoping for movies up to Thanksgiving it didn't happen. I put together this list of my favorites from 2012, as I have in prior years.

From tenth to first Countdown

10. Brave

9. Dr. Seuss' The Lorax

8. The Pirates! Band of Misfits

7. Men In Black 3

6. The Dark Knight Rises

5. The Amazing Spider-Man

4. John Carter of Mars

3. Lawless

2. The Avengers

1. The First Annual Bengies Drive-In Scout Camp-in - ParaNorman, The Odd Life Of Timothy Green, Premium Rush

Yes, the top 1 movie is three movies, but the event was such an experience that I could not resist rating that evening as the best of the season. It rained like mad before the shows even started. I didn't get much sleep, and neither others in the crowd, and I'm looking forward to the second annual drive-in camp-in.