myPIM

Check-in [d776dfe659]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add some notes on the DB format
Downloads: Tarball | ZIP archive | SQL archive
Timelines: family | ancestors | descendants | both | master | trunk
Files: files | file ages | folders
SHA3-256:d776dfe65960aa6d8656b32f30fd16b23be76a1c2892e81fffca4ac105d2fe72
User & Date: vandys 2018-07-07 15:26:40
Context
2018-10-04
04:41
Make search case insensitive Leaf check-in: c940af332c user: vandys tags: master, trunk
2018-07-07
15:26
Add some notes on the DB format check-in: d776dfe659 user: vandys tags: master, trunk
2018-07-06
00:33
Quick-n-dirty VCF exporter so my DB is on my phone. Huh, worked the first time, so far as I can tell.... check-in: 473c444d02 user: vandys tags: master, trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Added mmdb.doc.





























































































































































































































































>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
myPIM databases

myPIM is driven from one or more data files, which can specify
any mix of information on people, businesses, and their related
email/phone information.  It can also track dates, including
repeating ones.  Dates and people can be related, and all
information can be inherited so that all members of a family
can share a single specification of, say, their home address
and phone number.

------------------------
People (and businesses)

person
    name Joe Smith
    dates
	birth 1/2/1973
    phones
	cell 415-123-4567
    email
	personal joe@joesmith.com
	work joe.smith@megacorp.biz
    address
	home:
	    1234 A Road Drive
	    Big City, USA

A "person" entry tabulates the usual information.  The tag for data
is arbitrary, but must be unique (so use work1, work2, etc. if there
are multiple work addresses).  A tag ending in ":" lets you indent
and then enter free-form, multi-line text.  The text ends at the
end of indentation.

------------------------
Events

event An event name
    date 2/3/2018 17:15
    comments:
	Some arbitrary text
	One more lines.

Events always have a name, and a date.  If it's a timed event, they
can also have a time.  Expanded descriptions can be placed under
a comments: section.

------------------------
To Do

todo Something to remember!
    date 1/1/2019
    done

A "to do" event shows up in your calendar on the "data", notionally
the "due date".  If a "done" field is present, it means that the
event has been completed, otherwise it floats along from day to day
once the start date has been reached.

------------------------
Inheritance

Start with our example "Joe Smith", which one change:

person $joe1
    name Joe Smith
    ...
    address
	home:
	    1234 A Road Drive
	    Big City, USA

person $sue1
    name Sue Smith
    spouse $joe1 address

We now have a "Sue Smith", and she is related to Joe by marriage,
and they both have the same home address.  You can also share
phone numbers; if Joe has a home and cell #, and Sue just has
her own cell #, the system knows that they share home # while
each having their own cell phones.

Sue doesn't need to have her own "$sue1" symbol for this example,
but now consider children:

person
    name Timmy Smith
    parent  $sue1 $joe1  phones address

Now we have an entry which ties Timmy to the two parents, inheriting
phone numbers and address.

------------------------
Dates and repeats

event Happy New Year!
    date 1/1/2000 yearly

Every January 1st.

event My monthly chore
    date 3/1/2018 monthly

Starting on 3/1/2018, this event occurs on the 1st of each
following month.

event A group's meeting
    date 3/5/2018 monthly dow

This is a monthly event, hitting on this day of the week.
3/5 in 2018 is the first Monday of the month, thus this
event repeats each month, landing on the first Monday of
that month.

event Memorial Day
    date 5/29/1967 yearly doe

"dow" is about looking at the event from the beginning of
the month; "doe" is from the end.  5/29 in 1967 is the last
Monday of the month, so this event repeats on the last Monday
of each May.

event A chunk of work
    date 7/1/2018 daily through 7/3/2018

By default, events repeat forever.  This is an event which
repeats through (including) 7/3.