en:resources:additions-repertory-saine
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
en:resources:additions-repertory-saine [2013/11/19 12:52] 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 14: | Line 12: | ||
| 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é :-) | 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 SQL dump to be imported to the database of your choice or as ready-to-use database -- either in SQLite or Microsoft Access formats. | + | 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 ===== | ===== Downloads ===== | ||
| * [[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.1384865527.txt.gz · Last modified: 2013/11/19 12:52 by legatum
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 3.0 Unported
