User Tools

Site Tools


en:resources:additions-repertory-saine

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
en:resources:additions-repertory-saine [2013/11/19 12:53]
legatum [About the additions]
en:resources:additions-repertory-saine [2013/11/19 13:55] (current)
legatum
Line 2: Line 2:
  
 <WRAP center round tip 60%> <WRAP center round tip 60%>
-This is a page for software developers, if you wish to download the actual software using these additions, please [[en:​resources:​mercurius|proceed here]].+This is a page for software developers. If you wish to download the actual software using these additions, please [[en:​resources:​mercurius|proceed here]].
 </​WRAP>​ </​WRAP>​
  
- 
-This page contains the files you can use to update your repertories with the additions from André Saine team. 
  
 ===== About the additions ===== ===== About the additions =====
Line 19: Line 17:
  
   * [[http://​www.legatum.sk/​download/​rep_additions_release20131119.zip|Download Release 2013-11-19]] (SQL dumps and databases)   * [[http://​www.legatum.sk/​download/​rep_additions_release20131119.zip|Download Release 2013-11-19]] (SQL dumps and databases)
 +
 +The ZIP archive contains the following files:
 +
 +
 +^ File  ^ Description ​ ^
 +| repadds_release20131119.db3 | SQLite database of the repertory additions |
 +| repadds_release20131119.mdb | Microsoft Access database of the repertory additions |
 +| def_tables.sql | Database tables SQL definitions |
 +| data_complete_dump_20131119.sql | Complete SQL data import of the tables, without table definitions |
 +| data_instructlist_20131119.sql | SQL import of InstructList table |
 +| data_refsource_20131119.sql | SQL import of RefSource table |
 +| data_remedyconversion_20131119.sql | SQL import of RemedyConversion table |
 +| data_repadditions_20131119.sql | SQL import of RepAdditions table |
 +
 +===== How to use =====
 +
 +You can use these additions to upgrade your repertories. These additions were added to Complete Repertory 4.5, but basically you can use them to update any Kent-based repertory you have (with some tweaking of the rubrics).
 +
 +The structure of the database tables should be self-explanatory,​ but here is some basic info anyway:
 +
 +
 +^ Table  ^ Description ​ ^
 +| RemedyConversion | Contains unique Remedy IDs used in the RepAdditions table, unique remedy names and original remedy abreviations used in the additions |
 +| RefSource | Contains references of the additions in the RepAdditions table |
 +| InstructList | List of instructions used to add / edit the additions |
 +| RepAdditions | The actual additions to the repertory |
 +
 +Repertory additions should be applied from the RepAdditions table, in the **order they are inserted** (sorted by RID). The instructions (R_Instruction column) you should be interested in are:
 +
 +  * **Add** -- for adding a new rubric; the new rubric name is stored in RubricEdited column, column Rubric contains the rubric which PRECEDES the new rubric (useful only if you wish to maintain a specific, non-alphabetic rubric sequence)
 +  * **Edit** -- edit the Rubric to RubricEdited ​
 +  * **Remove** -- remove the Rubric
 +  * **Change** -- add, update or remove the remedy from the rubric; if RemoveFlag=1 you remove the remedy, otherwise you add remedy / update grade
 +
 +===== License =====
 +
 +This database is licensed under [[http://​creativecommons.org/​licenses/​by/​3.0/​|CC Attribution 3.0 Unported]], so it's a [[http://​creativecommons.org/​freeworks|Free Culture License]]. For attribution,​ please use "​André Saine team" and "​Legatum Homeopathicum"​.
en/resources/additions-repertory-saine.1384865582.txt.gz · Last modified: 2013/11/19 12:53 by legatum