Sort Events

...is a DELUXE LTOOL which sorts the events of all tagged individuals or marriages in your Legacy database.

Screen:

uri/../images/deluxe-sort-events.jpg

Usage:

To sort the events of all tagged individuals or marriages in your Legacy database:

  1. Open your database in Legacy.
  2. Decide which of the 9 individual or marriage tags you plan to use for this operation.
  3. Untag any individuals or marriages whose events you don't wish _LTools_ to sort.
  4. Tag the individuals or marriages whose events you wish to sort.

    HINT: If you wish to sort the events for all the individuals in your Legacy database, use Legacy's Advanced Tagging feature to tag everyone in your Legacy database. If you wish to sort the events for all the marriages in your Legacy database, use the _LTools_ Run Raw SQL feature with the update query ...

    UPDATE tblMR SET tblMR.TagX=1

    ... replacing the X with the number of the marriage tag you wish to set. For example ...

    UPDATE tblMR SET tblMR.Tag9=1

  5. Back up your Legacy database.
  6. Open your Legacy database in _LTools_.
  7. Double-click Sort Events in the Deluxe LTools tree to bring up the dialog for this LTool.
  8. Click the Individual Tag or Marriage Tag label to toggle between sorting individual and marriage events.
  9. Select the Individual Tag or Marriage Tag you used in Step 4.
  10. Check the Sort by radio button to choose the sort order.
  11. Click the Run button.
  12. _LTools_ will sort the the events of all the tagged individuals or marriages in your Legacy database by the order you chose.

Fields:

uri/../images/bluepin.gif Individual/Marriage Tag (Label)

Click the label to toggle between sorting individual events and marriage events.

uri/../images/bluepin.gif Individual/Marriage Tag (ComboBox)

Select the tag you used in Legacy to mark the individuals or marriages whose events you wish to sort.

uri/../images/bluepin.gif Sort by

Check to sort by Event Date, or Event Type then Event Date.

uri/../images/bluepin.gif Rows affected

The number of event records sorted.

uri/../images/bluepin.gif Run

Click to sort the events of tagged individuals or marriages.

uri/../images/bluepin.gif Close

Click to close this dialog.

uri/../images/bluepin.gif Help

You can use the ? (on the caption bar) or the \ key to display help for this dialog.



Introduction | Deluxe Features | Find Missing Information | Send Legacy Reminders | Tidy Legacy HTML | List Events | Find Unattached Multimedia | Add Events | Add To-Do's | Address Converter | Advanced Set Living++ | Advanced Tagging - Tag Living | Backup/Restore USR Files | Copy Master Event | Delete Master Events | Advanced Tagging - Y-DNA | Get IPTC Data | Global Text Search | Merge Basic to SourceWriter Sources | MRIN Filing Assistant | Repair Multimedia Paths | RegEx GEDCOM | Run Raw SQL | Set IPTC Data | Set Picture Captions | Set Special User IDs | Sort All Children | Sort Children of Tagged Individuals | Sort Events | Sort Marriages by Date | View Legacy Tables | Rename Non-Unique Multimedia | Advanced Tagging | Advanced Tagging - Ancestors Plus | Advanced Tagging - Mito DNA | Create Unknown Spouses | Remove Dead Multimedia Links | Data Bridge | Save/Restore Tags | Link Unattached Multimedia | Standard Features | Set Private/Invisible | Change To-Do Priorities | Clear IPTC Data | DAR Lineage Worksheet | Delete To-Do's | Include Citations by Surety Level | Include Citations by Verified Flag | Remove Medical Notes for Living Individuals | Search Citations | Search File IDs | Set Individual User IDs | Set Marriage User IDs | Set Birthday/Anniversary/Death Reminders | Set Source Surety Levels | Set Source Verified Flags | System Requirements | Contact Info | Miscellaneous Help | Legacy Tables | Product Registration | Edit Preferences | Command Line | Legacy Tables - tblSX.Type | pedigree.css | Source Template | Event Template | About Wiki Web Help | Miscellaneous Tools | Convert Long to Short U.S.A. Location Names