Ariadne index page

 

Ariadne - Technical description

A150

Export / import Competition schema

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

Form Control action Query Table / module Attribute
F150-Competition- schema     - -  
  button
ButtonExport
call
P150_Export_Competition_schema()
  module
P150-Competition-schema
-
  button
buttonSearch
Open file search dialog      
  button
buttonImport
call
P155_Import_Competition_schema()
  module
P150-Competition-schema
Competition Schema file name
  button
ButtonClose
close form      

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

date version change
Feb 2011 A4.9 Function new added