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:42]
legatum
en:resources:additions-repertory-saine [2013/11/19 13:55] (current)
legatum
Line 1: Line 1:
-====== Additions to the Repertory ======+====== Additions to the Repertory ​(source files) ​======
  
 <WRAP center round tip 60%> <WRAP center round tip 60%>
-This is a page for software ​devlopers, 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 ​=====
  
 +André Saine and his collaborators have been making additions to the Complete Repertory 4.5 since 1997, adding rubrics and remedies from old materia medicae (mostly Materia Medica Pura Project) and from their clinical experience. These additions were freely available, unfortunately,​ only for users of one specific homeopathic software.
 +
 +We thought it would be great if EVERYONE could benefit from these additions (since they are supposed to be free), so we bugged André until he gave us all the files of his additions, just to get rid of us. Thanks for your patience, André :-)
 +
 +It took some doing to get the data from the files organized into some more enlightened format, but you can download them below either as an SQL dump to be imported to the database of your choice or as a ready-to-use database -- either in SQLite or Microsoft Access formats.
 +
 +===== Downloads =====
 +
 +  * [[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.1384864970.txt.gz · Last modified: 2013/11/19 12:42 by legatum