OpenHomeopath Manual

Data maintenance

With Datadmin, our data maintenance tool you can edit and extend the database of OpenHomeopath.
For using Datadmin you've first to log in.
You can choose the database table for editing in a drop-down menue.
You can view and edit the following tables:

Materia Medica – contains the remedy descriptions of the Materia Medica with source references.
Symptoms – contains the symptoms and their relations among each other.
Sources – contains the sources with a detailed description.
Remedies – contains the remedies.
Main rubrics – contains the main rubrics.

I will give you a detailed description of each table:

Table Materia Medica

In the table Materia Medica you find the following fields:

Remedy – you can choose the remedy from a drop-down list related to the Remedies table.
Source – you can choose the source of the materia medica from a drop-down list related to the Sources table.
Details about preparation, origin and synonyms of the remedy.
Description – for a detailed description of the remedy in general.
Related remedies, Incompatible remedies and Antidotes – as abbreviations separated by semicolon (';').
Leading symptoms in the categories Genarel, Mind and Body – for a detailed description of the leading symptoms.

The fields Remedy and Source are mandatory. The other fields only show up in the Materia Medica, when they're filled in.

Table Symptoms

The table Symptoms contains 3 mandatory fields:

Symptom – the symptom description,
Main rubric – here you can choose the main rubric from a drop-down list,
Language – here you can choose the language from a drop-down list.

Table Sources

The table Sources contains 6 mandatory fields:

Source ID – a short name for the source. Up to 12 alphanumeric characters are allowed.
Title – the title of the source.
Language – choose from a drop-down list,
Source type – choose from a drop-down list,
Maximum grade – choose the maximum grade that is used in the source,
Primary source – 1: Primary source, 0: Reference source.

The next 10 fields are self explaining and will only show up if they're completed:

Author
Year
Edition/Version
Copyright
License
URL
ISBN
Note
Contact address
Remedy proving – if the source is a remedy proving provide details.

Table Remedies

The table Remedies contains 2 mandatory fields:

Abbreviation – the common remedy abbreviation,
Remedy name – the full remedy name.

Table Main Rubrics

In the table Main Rubrics you find the following fields:

Main Rubrik (German),
Main Rubrik (English),
Synonym – an existing synonymous main rubric.

Warning! You should change the main rubric only after consulting the forum or an administrator, because the main rubrics are creating the basic structure of the rubrics database.

Layout of Datadmin

On the main page of each table you find a list of existing records. You can choose how many records per page will be shown.

At the beginning of each table row you find 3 clickable icons:

– for editing the record. If you aren't administrator you can only edit your own records. For details see Edit and insert of records.
– for deleting the record. If you aren't administrator you can only delete your own records.
– for the details view.

In the menue bars above and below the table you find the following items:

"Home" – return to the last view of the table main page.
"Insert" – insert new records in the table. For details see Edit and insert of records.
"Search" – searching the table with search filters for each field.
"Last search results" – return to the last search results.
"Show all" – show all records without filters.
"Archive" – where changed and deleted records are archived and can be restored.
"Express-Tool" – switch to the Express-Tool.

In the table Remedies you've also the possibility to select the records by the first letter of the remedy abbreviation.
In the table Symptoms you can select records by main rubric.

With "Export to CSV" you can export the current record selection to a semicolon seperated CSV-file.

Edit and insert of records

You can reach the edition form from the -Symbol in front of each table row and the insert form from "Insert" in the menue bar.
The difference between the two form is, that the insert form is a blank form and in the edit form you find the data of the current record with the possibility to jump with "<< Previous" to the previous and with "Next >>" to the next record.

Mandatory fields are signed by an asterisk (*) before the field name.
There're 3 types of fields:

single-line textfields,
multi-line textareas – line feeds are generally preserved,
drop-down lists.

You find hints to fill out the fields behind the fields.
Details for each table you find in the corresponding table chapter.