This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
en:resources:additions-repertory-saine [2013/11/19 13:03] legatum [Downloads] |
en:resources:additions-repertory-saine [2013/11/19 13:44] legatum [Additions to the Repertory (source files)] |
||
---|---|---|---|
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 32: | Line 30: | ||
| data_remedyconversion_20131119.sql | SQL import of RemedyConversion table | | | data_remedyconversion_20131119.sql | SQL import of RemedyConversion table | | ||
| data_repadditions_20131119.sql | SQL import of RepAdditions 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 |