Oxy-Gen : The Ultimate GEDCOM Converter

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