TITLE: Tiny Tafel Specification VERSION: 1.6 (11 December 1986) FROM: COMMSOFT 2257 Old Middlefield Way Mountain View, CA 94903 (415) 967-1900 Please forward any comments and suggestions regarding this specification to COMMSOFT at the above address. OBJECTIVE: Provide a compact way of describing a family database so that the information can be scanned visually or by computer. ACKNOWLEDGEMENTS: This specification is based on an article titled Tiny-Tafel for Database Scope Indexing by Paul Andereck in the April-May-June 1986 (vol 5, number 4) issue of Genealogical Computing. CONSTRAINTS: All data fields are fixed length for easy parsing by software with the obvious exceptions of the surnames and optional places. Optional removal of apparent redundant lines (as determined by Soundex code and actual surname). FORMAT: Header: Column Description ______ ___________ 1 Header type 2 Space delimiter 3 - n Text (n < 38) (n + 1) Carriage Return Defined types: Header Type Description Remarks ____ ___________ _______ N Name of person having custody of data Mandatory first record A Address data 0 to 5 address lines Optional T Telephone number including area code Optional S Communication Service/telephone number 0 to 5 service lines (MCI, ITT, ONT, RCA, ESL, CIS, SOU, etc, Optional e.g., CIS/77123,512) B Bulletin Board/telephone number Optional C Communications nnnn/X/P Optional nnnn = maximum baud rate X = O(riginate only), A(nswer only), B(oth) P = Protocol (Xmodem, Kermit, etc.) D Diskette format d/f/c Optional d = diameter (3, 5, 8) f = format MS-DOS, Apple II, etc. c = capacity, KB F File format Free-form, optional ROOTS II, ROOTS/M, PAF Version 1, etc. R Remark Free-form, optional Z Number of data items with optional text Required last item In the COMMSOFT Tiny Tafel, the name of the database, the version of the database, and any special switches used when the Tiny Tafel was generated are shown on the Z line. The definitions of the special switches are shown below. D DATEFILLDISABLED. Tiny Tafel normally suppresses the output of data for which the birthdates necessary to establish each line of output are missing. When this switch is on, The Tiny Tafel generator has estimated missing dates. The Tiny Tafel program applies a 30 year per generation offset wherever it needs to re-construct missing dates. N NOGROUPING. Tiny Tafel normally "groups" output lines that have a common ancestor into a single line containing the most recent birthdate. Descendants marked with an interest level greater than zero, however, will have their own line of output (see below for definition of interest level). Alternatively, when this switch is enabled, one line of output is created for every ultimate descendant (individual without children). M MULTIPLENAMES. Tiny Tafel normally lists a surname derived from the descendant end of each line. Specifying this option lists all unique spellings of each surname (up to five) separated by commas. P PLACENAMES. Tiny Tafel will include place names for family lines when this switch is enabled. Place names will be the most significant 14 to 16 characters of the birth field. When this option is enabled, the place of birth of the ultimate ancestor and the place of birth of the ultimate descendant of a line of output, respectively, are added to the end of the line. S SINGLEITEMS. Tiny Tafel normally suppresses lines of output that correspond to a single individual (that is, in which the ancestry and descendance dates are the same). This switch includes single-person items in the output. #I INTERESTLEVEL. Tiny Tafel normally includes all family lines meeting the above conditions no matter what its interest level.An Interest Level may be specified to limit the lines included to those having an Interest Level equal to or greater than the number specified. For example, with the Interest Level set to 1, all lines which have an ancestor or descendant Interest Level of 1 or higher will be listed. Tiny Tafel Data: Col Description ___ ___________ 1 thru 4 Soundex Code (note 1) 5 Space delimiter 6 thru 9 Earliest ancestor birth year 10 Interest flag, ancestor end of family line (note 2) 11 thru 14 Latest descendant birth year 15 Interest flag, descendant end of family line (note 2) 16 thru 16+SL Surname string area (SL = total surname length) (note 3) above + PL Place name area (PL = total place name length) (note 4) above + 1 Carriage return NOTES: 1. The Soundex code for any given line is obtained from the end of the line that has the highest interest level. If interest level is the same at each end, however, the name at the ancestor end will be used. If the application of these rules yield a surname that cannot be converted to Soundex, however, the program will attempt to obtain a Soundex code from the other end of the line. 2. Interest flag: [space] No interest (level 0) . Low interest (level 1) : Moderate interest (level 2) * Highest interest (level 3) 3. Up to five surnames can be accomodated for one line where surname has changed in that line. If more than five surnames are found in a line, only the latest five will be shown. The inclusion of additional surnames is enabled by the M switch. 4. Place names for the birth of the earliest ancestor and the latest descendant may be included by using the P switch. If a place name is not provided for the individual whose birth year is shown, the field will be blank. The place for the ancestor is preceded by a backslash (\) and for the descendant by a slash (/). Terminator: W Date Tiny Tafel file was generated, DD MMM YYYY format. Example: N Howard L. Nurse A COMMSOFT A 2257 Old Middlefield Way A Mountain View, CA 94043 T (415) 967-1900 S FIDONet 143/26 B COMMSOFT BBS/(415) 967-6730 C 2400/B/X D 5/360K/DSDD F ROOTS II R Sample database Z 29 KENNEDY V24 DP A252 1915 1947 Auchincloss B160 1698 1933 Bouvier/Long Island NY B530 1906 1939 Bennett/New York B620 1869 1933 Burke/Suffolk Co. MA C200 1803 1833 Cox C414 1861 1899 Caulfield\Norfolk Co. MA/Suffolk Co. MA C540 1868 1928 Connelly/Suffolk Co. MA F326 1690 1890 Fitzgerald/Suffolk Co. MA F430 1806 1836 Field H200 1806 1857 Hickey/Suffolk Co. MA H500 1802 1865 Hannon/Middlesex Co. MA K500 1858 1892 Kane\Ireland/Suffolk Co. MA K530 1793*1957:Kennedy\Ireland/New York K530 1793*1984 Kennedy\Ireland/Wstchster Co. NY L000 1847 1906 Lee L163 1923 1961 Lawford\England/L.A. Co. CA L532 1753 1783 Lindsay M500 1847 1890 Mahoney\Suffolk Co. MA/Suffolk Co. MA M610 1791 1821 Murphy/Wxfrd Co. IRE M626 1710 1766 Mercier R324 1929 1959 Radziwill S240 1892 1928 Skakel\Cook Co. IL/Cook Co. IL S530 1927 1960 Smith\Kings Co. NY/Suffolk Co. MA S616 1915 1965 Shriver\Carroll Co. MD/Suffolk Co. MA S625 1831 1861 Sergeant T525 1947 1983 Townsend\Baltimore Co. MD/Middlesex Co. MA T653 1706 1736 Trintignant V650 1783 1813 Vernou W453 1767 1797 Wilmouth W 11 Dec 1986 NOTE: The above sample Tiny Tafel file was created using the Kennedy database supplied with ROOTS II, version 2. The date fill and place switches were on. Multiple Tiny Tafel database extractions may be included in a Tiny Tafel file. If more than one database extraction is included, each extraction will be intitiated with a Z data line. An example is shown below: N Howard L. Nurse A COMMSOFT A 2257 Old Middlefield Way A Mountain View, CA 94043 T (415) 967-1900 S FidoNet 143/26 B COMMSOFT BBS/(415) 967-6730 C 2400/B/X D 5/IBM DSDD/360 F ROOTS II R Sample Kennedy database Z 29 KENNEDY V24 DP A252 1915 1947 Auchincloss B160 1698 1933 Bouvier/Long Island NY B530 1906 1939 Bennett/New York B620 1869 1933 Burke/Suffolk Co. MA C200 1803 1833 Cox C414 1861 1899 Caulfield\Norfolk Co. MA/Suffolk Co. MA C540 1868 1928 Connelly/Suffolk Co. MA F326 1690 1890 Fitzgerald/Suffolk Co. MA F430 1806 1836 Field H200 1806 1857 Hickey/Suffolk Co. MA H500 1802 1865 Hannon/Middlesex Co. MA K500 1858 1892 Kane\Ireland/Suffolk Co. MA K530 1793*1957:Kennedy\Ireland/New York K530 1793*1984 Kennedy\Ireland/Wstchster Co. NY L000 1847 1906 Lee L163 1923 1961 Lawford\England/L.A. Co. CA L532 1753 1783 Lindsay M500 1847 1890 Mahoney\Suffolk Co. MA/Suffolk Co. MA M610 1791 1821 Murphy/Wxfrd Co. IRE M626 1710 1766 Mercier R324 1929 1959 Radziwill S240 1892 1928 Skakel\Cook Co. IL/Cook Co. IL S530 1927 1960 Smith\Kings Co. NY/Suffolk Co. MA S616 1915 1965 Shriver\Carroll Co. MD/Suffolk Co. MA S625 1831 1861 Sergeant T525 1947 1983 Townsend\Baltimore Co. MD/Middlesex Co. MA T653 1706 1736 Trintignant V650 1783 1813 Vernou W453 1767 1797 Wilmouth R Only those having interest > 0 Z 2 KENNEDY V24 D1 K530 1793*1957:Kennedy K530 1793*1984 Kennedy W 15 Dec 1986 In this Tiny Tafel, the first section contains an extracted Tiny Tafel file with date fill and places enabled. The second section contains an extracted Tiny Tafel file with date fill and the interest level threshold set to 1.