| The software |
|
|
|
| Documentation |
|
|
|
| Users |
|
|
|
| Links |
|
|
|
|
Initialisation
You must create first a sequence :
CREATE SEQUENCE seq_family
MINVALUE 1
MAXVALUE 999999
START WITH 1
INCREMENT BY 1
CACHE 20;
Batch mode
You can execute oxy-gen in command line. Then it will load prefs.ini that is found in the same folder. You must launch first Oxy-Gen without command line to choose your options.
For the command line, the first parameter is the gedcom file and the second parameter is the output file name. All other options are found in the prefs.ini even generation type (don't forget to choose Oracle and not HTML). To modify prefs.ini, use/execute Oxy-Gen without command line.
Exemple :
oxy-gen my-gedcom.ged c:\scripts_ora\oxy
Then you can use sqlplus to execute sql files and fill your database.
Database tables
Oxy-Gen create sql files which contain information necessary to the construction of the genealogical base.
ptp.sql : Patronyms table
| Column names | Contents |
|---|
| id_family | Index of the family (link to family table) |
| id_patronym | Index of the patronym |
| libelle | patronym |
| libelle_ord | patronym formated to be sorted |
lix.sql : City table
| Column number | Contents |
|---|
| id_city | City index |
| id_zone | Zone index where is the city (link to zones table) |
| id_country | Zone index where is the city (link to country table) |
| libelle | City name |
| code | City code |
| longitude | longitude |
| latitude | latitude |
lix.sql : Zone table
| Column number | Contents |
|---|
| id_zone | Zone index (State/department) |
| id_country | Country index where is the zone (link to countries) |
| libelle | Zone name |
| code | Zone code |
| coord_zone | Coordinates for the image_map in the picture |
| pos_remp_x | x coordinate in the bitmap to fill |
| pos_remp_y | y coordinate in the bitmap to fill |
lix.sql : Country table
| Column number | Contents |
|---|
| id_country | Country index |
| libelle | Country name |
| extension | Short name or code |
| coef | Value for the projection of the longitude/latitude of the cities to be drawed on the country bitmap |
ind.sql : Individuals table
| Column number | Contents |
|---|
| id_family | Index of the family (link to family table) |
| id_individual | Individual index |
| sex | sex |
| id_father | Father index |
| id_mother | Mother index |
| id_patronym | Patronym index (link to patronymes) |
| first_name | First name |
| sosa | SOSA number (or -1 if none) |
| date_naissance | Birth date |
| lieu_naissance | Birth place |
| id_ville_naissance | Birth city index (link to cities) |
| id_zone_naissance | Birth zone index (link to zones) |
| id_pays_naissance | Birth country index (link to countries) |
| date_deces | Death date |
| lieu_deces | Death place |
| id_ville_deces | Death city index (link to cities) |
| id_zone_deces | Death zone index (link to zones) |
| id_pays_deces | Death country index (link to countries) |
| contemporary | contemporary (see options box) |
evt.sql : Event type table
| Column number | Contents |
|---|
| id_type_event | Event type index |
| code | Event code |
| libelle | Event Name |
evs.sql : Event list table
| Column number | Contents |
|---|
| id_family | Index of the family (link to family table) |
| id_event | Event index |
| type | Event type (link to evenements_type) |
| type_father | Type of the father event (0:Individual 1:Event) |
| id_father | Index of the father event |
| libelle | Sentence of the event |
| contemporary | contemporary (see options box) |
| ind_link | individual asso |
create_base.sql
This file create the table. You should execute this script only the first type.
family.sql : family table
| Column names | Contents |
|---|
| id_family | Id of the family |
| file_name | File name of the gedcom file |
|