| | 1 | = Make an RDS Class Hierarchy presentable in Excel = |
| | 2 | '''WIP''' This is a very quickly written explanation. Prior experience with the various tools is likely to be a huge advantage. |
| | 3 | |
| | 4 | The next project that uses this should copy the code away from !NorHub, preferably in its own folder in `RD/software` |
| | 5 | |
| | 6 | This is a step by step guide on how you can make an Excel sheet where the indentation of the columns indicate the class hierarchy. |
| | 7 | |
| | 8 | == Software needed == |
| | 9 | 1. Cygwin |
| | 10 | 2. Perl (install using cygwin) |
| | 11 | 3. Gnumake (install using cygwin) |
| | 12 | 4. ARQ ( can be found in RD/software/ARQ ) |
| | 13 | 5. Saxon ( also in RD/software ) |
| | 14 | 6. Protege, with the plugin "Tabbed subclasses" which can be gotten from the plugin menu in Protege |
| | 15 | |
| | 16 | |
| | 17 | == Steps == |
| | 18 | 1. Update `RD/projects/NorHub` |
| | 19 | 2. Fill out the following files |
| | 20 | |
| | 21 | ===== TXT/ExcelTabbed-!StingClasses.txt ===== |
| | 22 | > This file should contain classes (by RDS code) of strings whose members are connected to classes via CLASS OF IDENTIFICATIONs. |
| | 23 | > [[BR]] |
| | 24 | > All these classes will be included in the final list. |
| | 25 | |
| | 26 | ===== TXT/ExcelTabbed-!MiscClasses.txt ===== |
| | 27 | > This file lists RDS codes for classes that should be included. |
| | 28 | |
| | 29 | 3. Update `RD/reference_data/XML/RDL.xml` to receive the latest RDS updates |
| | 30 | 4. Enter cygwin and navigate to `RD/projects/NorHub` |
| | 31 | 5. Run in Cygwin `make OWL/idpca.xml.owl`. If it claims to be "up to date", force it by adding `-B` at the end. |
| | 32 | 6. Open `OWL/idpca.xml.owl` in Protege |
| | 33 | 7. Press the class you want as your top class, and view this in the plugin. (You might want to create a separate tab for this) |
| | 34 | 8. Enable the reasoner |
| | 35 | 9. Select "Tabbed subclasses (inferred)" and select "Descendant classes" on the Query tab. |
| | 36 | 10. Copy this to the file `TXT/ExcelTabbed-tabbedIds.txt`. Leave the URIs as they are. |
| | 37 | 11. Run in Cygwin `make XSL/TabbedClasses.csv` |
| | 38 | 12. Open the csv in Excel. |
| | 39 | 13. Presto! |
| | 40 | |
| | 41 | === TXT/ExcelTabbed-skipList.txt === |
| | 42 | > Write down all RDS codes that should be excluded from the final Excel file. |
| | 43 | > [[BR]] |
| | 44 | > The intended use of this file is to remove classes after the first iteration, and should initially be empty. When you have an Excel file, add a column at the leftmost end of the sheet and write "Delete" in these for each class that should be omitted. [[BR]] |
| | 45 | > The script will fail if you have excluded superclasses of other, non-omitted, classes |
