Online Database Instructions


Welcome to the Membership Online Database system!

As an officer of a State Society or Chapter there are a list of options you have available which are not available to the average Compatriot.

These options include:

    1. Updating addresses for all of your State Society or Chapter members.

    2. Assigning Compatriots to a Chapter (State Society level only).

    3. Updating the awards your Compatriots have received (State Society level only).

    4. Use of various reporting functions.

    5. To report a deceased Compatriot.

 

What we will do with this information page is discuss how each option is done in turn.

1. Updating addresses for all of your State Society or Chapter members.

Login into the Online Database system at the following website:

  https://memberinfo.sar.org

Once you login you will see a screen like this (with only YOUR information).   If you are a State Society officer you will have access to all of the members of your State Society.  As a Chapter officer you will have access to all of the members who have been assigned to your Chapter.  The Chapter assignments are done by your State Society officers or National Headquarters.

Figure 1

Please refer to Figure 1, in the upper right-hand corner you will notice an area shown in Figure 2.

Figure 2

At the end of this field where your name appears there is a down arrow.  Click on the down arrow.  You should now see a list of your Chapter or State Society members in alphabetical order by last name.   By selecting a name from this list you will be provided with the contact information of that Compatriot.  Just like with your contact information, you will be able to update any of the fields appearing in white.  Once you make a change to any of the information you must remember to click on the "Submit" button, which also appears in the upper right-hand corner (shown in Figure 2).  Any changes made without hitting the "Submit" button will not be recorded in the system.

 

2. Assigning Compatriots to a Chapter (State Society level only).

This function is relatively new to the National Database.   Assigning Compatriots to a particular Chapter has historically been the responsibility of the State Society and it continues to be that way.  Unfortunately, this means that most of the Compatriots listed in this National Database do not have Chapter assignments.

Several years ago National and the State Societies did organize the method of identifying Chapters, so that we started operating from the same list.  The list of identifiers is available at the following link:

  http://www.sar.org/Chapters

The Chapters for each State Society is listed along with their identifier.  Please check your list and notify National of any incorrect information or changes.

To assign a member to a particular Chapter you will need to login into the system like normal.

As described in section 1 above, you will need to select the individual Compatriot you wish to update.  The one difference you will notice as a State Society officer is the area where the Chapter name is listed.


Figure 3
  

As a State Society officer you will see the name of the Chapter in a white box with a down arrow located to the right.  This will allow you to click on the down arrow and select the Chapter name to assign to this Compatriot.   If your State Society does not have Chapters or your State Society allows Compatriots to be Members-at-Large then you will need to select the code showing your state abbreviation followed by 0 (zero).

 

3. Updating the awards your Compatriots have received (State Society level only).

To assign awards received to each Compatriot, please log in to the system.  Following the instructions in step 1 above select the individual Compatriot to update.  After the Compatriot's information is on your screen refer to Figure 2 above.  You will notice a button labeled "Awards".   Click on the button and a new screen will appear (Figure 4).


Figure 4

To select a particular award click on the down arrow next to the "National Award" box.  This will show a list of all of the Awards listed in the SAR Handbook.  Select the award to record.  Enter the date of presentation and click the "Submit" button.  Each award assigned to this particular Compatriot should appear in the left-hand section of the screen.   To return to the Member information screen to select the next Compatriot, click on the "Member Info" button in the upper right-hand corner.

 

4. Use of various reporting functions.

Please refer to Figure 1.  In the upper right-hand corner you will see a button labeled "Reports".  By clicking on this button you will see the screen shown in Figure 5.  Next to each Report option is a check box.  Check the report you would like and click the "Submit" button.


Figure 5




First is the Address Labels.  When you select this report it will generate a .PDF formatted report laid out in a standard Avery #5160.   The report will include all active members of your Chapter or State Society, depending upon your access level.  Sample shown in Figure 6.

  

Figure 6




Figure 7
  

The second report option is a Current Membership Roster, as shown in Figure 7.



The third report option is a Current Membership Roster with a different format.  The data is extracted from the Database and exported to your local computer in a Microsoft Excel format.  This will allow you to review the data, mail merge the data into whatever layout you wish or allow you to import the raw data into your own database system.  An example is shown in Figure 8.


Figure 8

The fourth and fifth options are a Dropped Members list and a Deceased Members list.  The system will ask you for a date range that you would like to include in the report.  Like the Current Membership Roster shown in Figure 7, these reports are generated in a printable format.

 

5. To report a deceased Compatriot.

To report a deceased Compatriot to National, DO NOT modify the address to say deceased in any way.  Do go to the following link and fill in the report form to submit it to National.

  http://www.sar.org/forms/death.html

NOTE:  Do not bookmark this form at this time.   It is available in a new site design and will be moved once the new design is in place.  This future link address will be:

http://www.sar.org/forms/death.html

This is a basic tutorial of the items available from the online database system.

Additional options may be available in the future and will be announced as they become available.

 

Frequently Asked Questions

The following are some frequently asked questions received at Headquarters.

    1.  Why doesn't my original ancestor show on the database?

      The Patriot Ancestor database system is only a few years old, so most of the long term Compatriot's original ancestors are not in the system yet.  They will be added as time permits.

    2.  Why can't I create my User ID, the system says it can not confirm my National Number and Date of Birth?

      The National database system has been in existance since 1998 and it continues to grow.  While most birth dates have been entered into the system those Compatriots with National Numbers lower than 125,000 are not all entered as yet.   We continue to key them in as time permits.

    3.  Why doesn't the office I held three years ago show in my record screen?

      The Positions Held section is used to list any current offices held.   It is not a office position history.

    4.  How come I can not list all of my Chapter members?

      It means that not all of your Chapter members have been assigned to your Chapter.   You need to prepare a list of those missing Compatriots and get with your State Officers to get the information updated.

    5.  Why won't the system accept my UserID and Password?

      One little quirk in the system (which will be fixed with the next upgrade) is the system requires you to click on the Login button before entering you UserID and Password.   It is suggested that you clear your Internet Cookies and Temporary Internet Files and try again.  Make sure to click on the Login button before entering the information.



George Washington Endowment Fund Board

  Updating Addresses

  Assigning
Compatriots to
a Chapter


  Updating the Awards

  Reporting Functions

  Report a Deceased
Compatriot


  Frequently Asked
Questions


  Database Support




 


WWW
www.sar.org
Google



The National Society
of the
Sons of the
American Revolution

Contact NSSAR

  Return to Top
  Return to Top
  Return to Top
  Return to Top
  Return to Top
  Return to Top
  Return to Top
  Return to Top
  Return to Top
  Return to Top

National Society Sons of the American Revolution
1000 South Fourth Street | Louisville, Kentucky 40203 | 502-589-1776