Oxy-Gen
Last update of the software :
September 20 2017 : Version 1.39n
The software
  Home
  Download
Documentation
  ChangeLog
  User manual
Users
  Forum
  Greetings
  Help
Links
  Search Engine
  Genealogical web sites
  Sites using Oxy-gen
 

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 namesContents
id_familyIndex of the family (link to family table)
id_patronymIndex of the patronym
libellepatronym
libelle_ordpatronym formated to be sorted

lix.sql : City table

Column numberContents
id_cityCity index
id_zoneZone index where is the city (link to zones table)
id_countryZone index where is the city (link to country table)
libelleCity name
codeCity code
longitudelongitude
latitudelatitude

lix.sql : Zone table

Column numberContents
id_zoneZone index (State/department)
id_countryCountry index where is the zone (link to countries)
libelleZone name
codeZone code
coord_zoneCoordinates for the image_map in the picture
pos_remp_xx coordinate in the bitmap to fill
pos_remp_yy coordinate in the bitmap to fill

lix.sql : Country table

Column numberContents
id_countryCountry index
libelleCountry name
extensionShort name or code
coefValue for the projection of the longitude/latitude of the cities to be drawed on the country bitmap

ind.sql : Individuals table

Column numberContents
id_familyIndex of the family (link to family table)
id_individualIndividual index
sexsex
id_fatherFather index
id_motherMother index
id_patronymPatronym index (link to patronymes)
first_nameFirst name
sosaSOSA number (or -1 if none)
date_naissanceBirth date
lieu_naissanceBirth place
id_ville_naissanceBirth city index (link to cities)
id_zone_naissanceBirth zone index (link to zones)
id_pays_naissanceBirth country index (link to countries)
date_decesDeath date
lieu_decesDeath place
id_ville_decesDeath city index (link to cities)
id_zone_decesDeath zone index (link to zones)
id_pays_decesDeath country index (link to countries)
contemporarycontemporary (see options box)

evt.sql : Event type table

Column numberContents
id_type_eventEvent type index
codeEvent code
libelleEvent Name

evs.sql : Event list table

Column numberContents
id_familyIndex of the family (link to family table)
id_eventEvent index
typeEvent type (link to evenements_type)
type_fatherType of the father event (0:Individual 1:Event)
id_fatherIndex of the father event
libelleSentence of the event
contemporarycontemporary (see options box)
ind_linkindividual asso

create_base.sql

This file create the table. You should execute this script only the first type.

family.sql : family table

Column namesContents
id_familyId of the family
file_nameFile name of the gedcom file
Copyright (C) 2000-2017