Ariadne - Technical description

Description

1. Ariadne is used for more competitions within the same sports discipline, over more years, where for a good part the same persons and clubs participate.
2. Ariadne evolves and develops after each competition.

In this situation it is convenient to use the same persons and clubs database for each competition, and to use the most recent Ariadne version. Therefore the function is developed to export a competition schema of a previous year, and to import it in the most recent Ariadne version.

The competion schema is an xml file that contains data about the competition, program blocks, races, series, and gates.

Access path

The From (A150) Im - Export Competition schema can be accessed from:

F000-Menu
F150-Competition-schema	Ref screen shot below. The form has a part for exporting a competion schema, and for importing a competition schema.
P150_Export_Competition_schema()	exporting xml competition schema file from current competition
P155_Import_Competition_schema(CompSchema)	importing xml competition schema file in current competition (while removing the current competition schema from current competition.)

Screen shot

Function structure

xml competition schema example

<?xml version='1.0' encoding= 'UTF-8'?>
<competition_schema>
<competition competition_abbrev='GM2015' passcode='1234567'>
<competition_name>46-e Gennepermolen slalomwedstrijd 2015</competition_name>
<competition_start_date>19-9-2015</competition_start_date>
<entries_closing_date>17-9-2015</entries_closing_date>
<organizing_club_name>Gennepermolen</organizing_club_name>
<club_address>Postbus 1234</club_address>
<club_postcode>5601 JR</club_postcode>
<club_city>Eindhoven</club_city>
<club_url>http://www.gennepermolen.nl</club_url>
<club_contact_name>Patrick van Dijk</club_contact_name>
<club_contact_email>patrick@kaykakclub.nl</club_contact_email>
<club_bank_account>NL41INGB00123456</club_bank_account>
<menu_name>EKV GenneperMolen</menu_name>
<sports_discipline_id>2</sports_discipline_id>
</competition>
<program_blocks>
<program_block>
<program_block_id>1</program_block_id>
<program_block_number>1</program_block_number>
<program_block_name>Zaterdagmiddag</program_block_name>
<start_date>19-9-2015</start_date>
<start_time>15:00:00</start_time>
<end_time>17:00:00</end_time>
<virtual_block>0</virtual_block>
<sports_discipline_id>2</sports_discipline_id>
</program_block>
<...>
<program_blocks>
<races>
<race>
<race_id>352</race_id>
<root_race_id>352</root_race_id>
<program_block_id>3</program_block_id>
<race_type_id>20</race_type_id>
<race_number>19</race_number>
<race_number_sub> </race_number_sub>
<race_sort>25</race_sort>
<race_name>3 x K 1  FUN</race_name>
<virtual_race>0</virtual_race>
</race>
<...>
</races>
<series_section>
<series>
<series_id>1</series_id>
<series_type_id>7</series_type_id>
<race_id>352</race_id>
<start_interval>120</start_interval>
</series>
<...>
</series_section>
<categories_races>
<category_race>
<race_id>356</race_id>
<category_abbrev>k1hv2</category_abbrev>
<sports_discipline_id>2</sports_discipline_id>
</category_race>
<....>
</categories_races>
<gates>
<gate>
<gate_number>2</gate_number>
<negotiation>op</negotiation>
<gate_section>1</gate_section>
<course_id>1</course_id>
</gate>
<...>
</gates>
</competition_schema>

Change history