PUGweb

User Tools

Site Tools

You are here: start » resources » dbchanges
Trace:
resources:dbchanges

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision		Previous revision
resources:dbchanges [2011/04/20 16:53] – created Colin Liebenroodresources:dbchanges [2020/05/01 18:56] (current) – [Elton55.1101 January 2011] Elton55.2004 update Colin Liebenrood
Line 1: Line 1:
 ===== Elton55 Database Changes ===== ===== Elton55 Database Changes =====
-==== Elton55.611 November 2006 ==== +==== Elton55.2004 April 2020 ==== 
-1. occupation picture script **major** had space and comma extra +Changes from Elton.1101 are listed below. 
-so remove the ''", "'' before end. + 
-<code>if not  title contains ";" then title end</code> +A change in Residence script RESI: change 
-2. Person table **validation** created for Person index +<code>1 CONT |"2 PLAC " [dwelling"," road] [","locality] [","town 
-**filtered** by any of these 3 filters which were split up to avoid +1 CONT county][","postcode]</code> 
-problems with list filter sizes in Pedigree.+to 
 +<code>1 CONT |"2 PLAC " [dwelling"," road] [","locality] 
 +1 CONT [","town "," county][","postcode "," country]</code> 
 + 
 +==== Elton55.1101 January 2011 ==== 
 +Changes from Elton55.612 are listed below. 
 + 
 +1. One line added at the end of Person script validate (to report if no sex is given) 
 +<code>if sex absent then "No Sex"¦end</code> 
 + 
 +2. Added for Web Output: Person scripts HTMname and HTMdates; Marriage script HTMmarr. 
 + 
 +=== Person script HTMName ===
 <code> <code>
-birth.date > 1000 and birth.date < parents.marriage.date or +if forenames absent then title end 
-mother.death.date present and mother.death.date < birth.date+prefix 
 +if forenames <"A" then" " end 
 +if forenames absent then 
 +  "Unk" rin 
 +else 
 +forenames 
 +end 
 +"<b>"surname"</b>" 
 +postfix ["(" nickname ")"]
 </code> </code>
-or+=== Person script HTMdates ===
 <code> <code>
-christening.date present and christening.date < parents.marriage.date or 
-mother.death.date present and mother.death.date < christening.date 
-</code> 
-or 
-<code> 
-burial.date present and burial.date < death.date or 
-burial.date present and burial.date < birth.date or 
-christening.date present and christening.date < birth.date or 
-death.date present and death.date < birth.date or 
-death.date present and death.date < christening.date 
-</code> 
-The above filters have been limited to size of a filter acceptable to 
-Pedigree if using PediTree before v3.310, otherwise they can be one filter 
-joined by ‘or’. 
  
-3. The Person ‘validation’ table column 2 uses a +if birth.date present then 
-new Person script called **validate** which is also used when saving +  "b. " normal(birth) 
-a Person edit. This is the script: +else 
-<code> +  ["bapt. " normal(christening)]
-if burial.date present and burial.date < death.date +
-then "burial<death" end +
-if burial.date present and burial.date < birth.date +
-then "burial<birth" end +
-if christening.date present and christening.date < birth.date +
-then "christening<birth" end +
-if death.date present and death.date < birth.date +
-then "death<birth" end +
-if death.date present and death.date < christening.date +
-then "death<christening" end +
-if birth.date present and birth.date < parents.marriage.date +
-then "warning birth < parents.marriage" parents.marriage.date+
 end end
-if christening.date present and christening.date < parents.marriage.date + if death.date present then 
-then "warning christening < parents.marriage" parents.marriage.date +   if birth.date present or christening.date present then 
-end +      ", " 
-if mother.death.date present and mother.death.date < birth.date +   end 
-then "mother.death" mother.death.date "< birth" end+   "d. " normal(death) 
 + else 
 +   if birth.date present or christening.date present then 
 +      ", " 
 +   end 
 +  ["bur." normal(burial)] 
 + end 
 +separator = "; " 
 +["<br>Education: " education] 
 +["<br>Occupation: " normal(occupation)]
 </code> </code>
-4. Marriage table **validation** created for list **filtered** 
-by 
-<code> 
-husband.death.date present and husband.death.date<marriage.date or 
-husband.burial.date present and husband.burial.date<marriage.date or 
-marriage.date present and husband.christening.date>marriage.date or 
-marriage.date present and husband.birth.date>marriage.date 
-</code> 
-or 
-<code> 
-wife.death.date present and wife.death.date<marriage.date or 
-wife.burial.date present and wife.burial.date<marriage.date or 
-marriage.date present and wife.christening.date>marriage.date or 
-marriage.date present and wife.birth.date>marriage.date 
-</code> 
-The above have been limited by size of a filter acceptable to Pedigree 
-if using PediTree before v3.310, otherwise they can be one filter joined 
-by ‘or’. 
  
-5. The Marriage ‘validation’ table column 2 uses a new Marriage script +=== Marriage script HTMmarr ===
-called **validate** which is also used when saving a Marriage edit. +
-This is the script:+
 <code> <code>
-if husband.death.date present and husband.death.date < marriage.date +["Married: " normal(marriage)] 
-then husband.death.date "husband.death.date < marriage.date" end +[" divorced " normal(divorce)]
-if wife.death.date present and wife.death.date < marriage.date +
-then wife.death.date "wife.death.date < marriage.date" end +
-if husband.burial.date present and husband.burial.date < marriage.date +
-then husband.burial.date "husband.burial.date < marriage.date" +
-end +
-if wife.burial.date present and wife.burial.date < marriage.date +
-then wife.burial.date "wife.burial.date < marriage.date" end +
-if marriage.date present and husband.christening.date > marriage.date +
-then husband.christening.date "husband.christening.date > +
-marriage.date" end +
-if marriage.date present and wife.christening.date > marriage.date +
-then wife.christening.date "wife.christening.date > marriage.date" +
-end +
-if marriage.date present and husband.birth.date > marriage.date +
-then "husband.birth.date > marriage.date" end +
-if marriage.date present and wife.birth.date > marriage.date +
-then wife.birth.date"wife.birth.date > marriage.date" end+
 </code> </code>
- 
-=== PedClone procedure for 611 === 
-Use PedClone to copy these items to your DB instead of typing them in PediTree: 
- 
-  * Groups, occupation, Pictures, major 
-  * Records 
-    * Person, Pictures, validate 
-    * Plan pictures, detailBox 
-    * Tables, validation 
-    * Marriage, Pictures, validate 
-    * Tables, validation 
  
 ==== Elton55.612 December 2006 ==== ==== Elton55.612 December 2006 ====
 +Six changes from Elton55.611 are listed below.
  
 1. New **Census script validate** for its Source.date 1. New **Census script validate** for its Source.date
Line 130: Line 86:
 end end
 </code> </code>
 +
 2. **Census filter** to list errors: 2. **Census filter** to list errors:
 <code> <code>
Line 137: Line 94:
 individual present and source.date>individual.burial.date individual present and source.date>individual.burial.date
 </code> </code>
 +
 3. **Census script detailBox** replace ''[|individual]'' by 3. **Census script detailBox** replace ''[|individual]'' by
 <code> <code>
Line 142: Line 100:
 [|"ERROR" validate()] [|"ERROR" validate()]
 </code> </code>
 +
 4. **Person script validate** \\ 4. **Person script validate** \\
 Replace <code>if birth.date present</code> Replace <code>if birth.date present</code>
Line 169: Line 128:
 then "ERROR mother.death" mother.death.date "< birth" | end then "ERROR mother.death" mother.death.date "< birth" | end
 </code> </code>
 +
 5. **Person script detailBox** \\ 5. **Person script detailBox** \\
 Add ''[| validate()]'' after ''treepar()'' in order to show errors and Add ''[| validate()]'' after ''treepar()'' in order to show errors and
Line 190: Line 150:
  
  
 +==== Elton55.611 November 2006 ====
 +Five changes from Elton55.610 are listed below.
  
-==== Elton55.1101 January 2011 ==== +1. occupation picture script **major** had space and comma extra 
-1. One line added at the end of Person script validate (to report if no sex is given) +so remove the ''", "'' before end. 
-<code>if sex absent then "No Sex"¦end</code> +<code>if not  title contains ";" then title end</code>
-2. Added Web Output Person scripts HTMname and HTMdates; Marriage script HTMmarr.+
  
-=== Person script HTMName ===+2. Person table **validation** created for Person index 
 +**filtered** by any of these 3 filters which were split up to avoid 
 +problems with list filter sizes in Pedigree.
 <code> <code>
-if forenames absent then title end +birth.date > 1000 and birth.date < parents.marriage.date or 
-prefix +mother.death.date present and mother.death.date < birth.date
-if forenames <"A" then" " end +
-if forenames absent then +
-  "Unk" rin +
-else +
-forenames +
-end +
-"<b>"surname"</b>" +
-postfix ["(" nickname ")"]+
 </code> </code>
-=== Person script HTMdates ===+or
 <code> <code>
-if birth.date present then +christening.date present and christening.date < parents.marriage.date or 
-  "b. " normal(birth) +mother.death.date present and mother.death.date < christening.date 
-else +</code> 
-  ["bapt. " normal(christening)]+or 
 +<code> 
 +burial.date present and burial.date < death.date or 
 +burial.date present and burial.date < birth.date or 
 +christening.date present and christening.date < birth.date or 
 +death.date present and death.date < birth.date or 
 +death.date present and death.date < christening.date 
 +</code> 
 +The above filters have been limited to size of a filter acceptable to 
 +Pedigree if using PediTree before v3.310, otherwise they can be one filter 
 +joined by ‘or’. 
 + 
 +3. The Person ‘validation’ table column 2 uses a 
 +new Person script called **validate** which is also used when saving 
 +a Person edit. This is the script: 
 +<code> 
 +if burial.date present and burial.date < death.date 
 +then "burial<death" end 
 +if burial.date present and burial.date < birth.date 
 +then "burial<birth" end 
 +if christening.date present and christening.date < birth.date 
 +then "christening<birth" end 
 +if death.date present and death.date < birth.date 
 +then "death<birth" end 
 +if death.date present and death.date < christening.date 
 +then "death<christening" end 
 +if birth.date present and birth.date < parents.marriage.date 
 +then "warning birth < parents.marriage" parents.marriage.date
 end end
- if death.date present then +if christening.date present and christening.date < parents.marriage.date 
-   if birth.date present or christening.date present then +then "warning christening < parents.marriage" parents.marriage.date 
-      ", " +end 
-   end +if mother.death.date present and mother.death.date < birth.date 
-   "d. " normal(death) +then "mother.death" mother.death.date "< birth" end
- else +
-   if birth.date present or christening.date present then +
-      ", " +
-   end +
-  ["bur." normal(burial)] +
- end +
-separator = "; " +
-["<br>Education: " education] +
-["<br>Occupation: " normal(occupation)]+
 </code> </code>
  
-=== Marriage script HTMmarr ===+4. Marriage table **validation** created for list **filtered** by
 <code> <code>
-["Married: " normal(marriage)] +husband.death.date present and husband.death.date<marriage.date or 
-[" divorced " normal(divorce)]+husband.burial.date present and husband.burial.date<marriage.date or 
 +marriage.date present and husband.christening.date>marriage.date or 
 +marriage.date present and husband.birth.date>marriage.date
 </code> </code>
 +or
 +<code>
 +wife.death.date present and wife.death.date<marriage.date or
 +wife.burial.date present and wife.burial.date<marriage.date or
 +marriage.date present and wife.christening.date>marriage.date or
 +marriage.date present and wife.birth.date>marriage.date
 +</code>
 +The above have been limited by size of a filter acceptable to Pedigree
 +if using PediTree before v3.310, otherwise they can be one filter joined
 +by ‘or’.
 +
 +5. The Marriage ‘validation’ table column 2 uses a new Marriage script
 +called **validate** which is also used when saving a Marriage edit.
 +This is the script:
 +<code>
 +if husband.death.date present and husband.death.date < marriage.date
 +then husband.death.date "husband.death.date < marriage.date" end
 +if wife.death.date present and wife.death.date < marriage.date
 +then wife.death.date "wife.death.date < marriage.date" end
 +if husband.burial.date present and husband.burial.date < marriage.date
 +then husband.burial.date "husband.burial.date < marriage.date"
 +end
 +if wife.burial.date present and wife.burial.date < marriage.date
 +then wife.burial.date "wife.burial.date < marriage.date" end
 +if marriage.date present and husband.christening.date > marriage.date
 +then husband.christening.date "husband.christening.date >
 +marriage.date" end
 +if marriage.date present and wife.christening.date > marriage.date
 +then wife.christening.date "wife.christening.date > marriage.date"
 +end
 +if marriage.date present and husband.birth.date > marriage.date
 +then "husband.birth.date > marriage.date" end
 +if marriage.date present and wife.birth.date > marriage.date
 +then wife.birth.date"wife.birth.date > marriage.date" end
 +</code>
 +
 +=== PedClone procedure for Elton55.611 ===
 +Use PedClone to copy these items to your DB instead of typing them in PediTree:
 +
 +  * Groups, occupation, Pictures, major
 +  * Records
 +    * Person, Pictures, validate
 +    * Plan pictures, detailBox
 +    * Tables, validation
 +    * Marriage, Pictures, validate
 +    * Tables, validation
  
resources/dbchanges.1303311187.txt.gz · Last modified: 2018/08/30 00:10 (external edit)
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki