help/Reference_Consolidation.htm
Monday April 2nd, 2018 7:34 AM

Resource House Cleaning - Establish Database Control over Content, Simplify User Documentation

Objective:


Stop the waste of time hunting for files used on recurring basis.

Conclusion:


This document has taken on many purposes, perhaps the best breakthrough - discovery of how to keep this simple through visual aids and metaphors.

Describe the process of administering FamilyGPS and Passport using bow tie metaphor


  • Input = Funnel
  • Data = Lever
  • Ouput = Prism
    Stratify the documentation following the bow tie design legend.


    Family Structure and ID Numbering Scheme in Simplest Terms



    Describe Data in Simplest Terms and Familiar Format
    (Tables Described as Spreadsheets; click to enlarge)





    Use this document to roll up

    to improve documenation efficiency and consistency
    birds eye view to deduplicate content use
    and standardize use through devices like legend picklists.

    content sources

    Reference_URLs.htm

Main_Dir.htm

    sustainable data store formats

    Collection and refresh processes

    Navigation and Context Support Processes

    • source



    Left Center Right

    Ancestors

    (the past)

    Root Family

    Descendants

    (the future)

    Sources

    Potential Data Sources
    • FamilySearch.org
    • Family Software exports (GED file)
    • Face Book
    • Family Albums
    • Mom and Dad
    of information and images

    Data

    Family Table

    Family Member Table

    family_talk.htm

    • Family Passport (fpp.exe)
    • Windows compliant desktop database
    • Two Data tables
    • Family.dbf
    • Fam_Member.dbf
    • where all accepted knowledge should reside

    Data and images Uses - Web Reports

    Bow Tie Design - Everything references the center

    Applies to

    1. Root Family
    2. Central Data tables









    Task/Objectives are listed below.

    Many tasks are simply refinements of prior efforts so it should be able to quickly put this together.

    Need to nail down file registry and URL registry by use and description

    And deduplicate references to fit standard access approach

    that leverages modern web presentation formats like Personal Website Template

    that separate format from content

    make content dynamically available (maybe MySQL database reference stuff)



    Work dilligently to put useful techniques under CODE_TEMPLATE.dbf control

    Work with simple process design

    Input

    Family Data

    • Key Data
      1. Mother Maiden Name
      2. Father Name
      3. Wedding Date


    		Source Relationship to permanent data stores

    Input

    Family Member Data

    • Key Data
      1. Given Name
      2. Married Name ( Women only)
      3. Birth Date
      4. Death Date
      5. Gender
      6. Passport Style photo
      7. Obituary Column (as image file or web document)


    		Source Relationship to permanent data stores

    Input

    Family Member Photos

    primary photo should be cropped head shot
    Family Photo HeadShots (aka Passport photo)         		Source Relationship to permanent data stores

    Processing

    • Input Options
      • Import
        • Import GEDCOM file (exportable from leading Genealogy software products)
        • Import Excel Spreadsheets of Family and Famiy Member data
      • Keypunch
        • Family Data Entry Screens
          • Family Lookup
        • Family Member Data Entry Screens
          • Family Member Lookup
    List of Forms that work with the data     		List of functions that work with table columns HTMCode listings for SCX, PRG, PHP, SVG, HTM
    Data DD Dictionary ..\gystdoit\help\FAM_MEMBER_Data_Dictionary.htm

    Output

    Passport Reports

    • Produced and stored on local PC
    • May optionally be uploaded to FamilyGPS Website
    • FamilyGPS versions exist for each of the Passport published reports

    FamilyGPS Report URLs

    ..\gystdoit\help\navhelp.htm

    Deployment
    • Local
      • C:\JPG
      • C:\gystdoit\jpg
      • C:\gystdoit\icons
      • C:\gystdoit\famed
      • C:\gystdoit\help
    • Website
      • www.gystdoit.com/family
      • www.gystdoit.com/icons (TBD)
      • www.gystdoit.com/famed
      • www.gystdoit.com/help 






    Leverage Reference_URLs.htm as source to update Websites.dbf

extract URL/tag fromthe htm as a csv file

Append to Websites.dbf

topic, URL, tag
SVG  ww3 school  SVG Syntax


Need all URLs with tag and/or caption within topic

Need similar for local files
image URL, image thumbnail, image legend or caption and system

Systems
FamilyGPS
Passport
Concert Experience
Music Library
do something with VFP music player vcx form with databases classic rock and filename resolution to band - song - album and studio vs live

Build a topic reference that fits nicely into the Personal Website Template
menu - all topics
each topic encapsulated in from 1 to 3 div tags 
syntax - function list, htmcode working example

or Artist - local mp3s, YouTube URL links, Set list, tour history, shows I have seen (concert history intersection)lyrics, wiki, google search for interviews,... 

Build Concert History database that can be projected onto a calendar 1975 through 2018

Nail Down Picklists of frequently used icons, programs, main files