How to create a custom export for results

Jun 25 2016

You may have such a specific need because you want your results to go into an independent publishing process. Or maybe a governing body of your preferred discipline asks them in a specific format.

He're what Wiclax can do for you:

Custom export formats

Looking at the ribbon > Print - Export panel, you can see listed the standard formats - Excel, HTML,... - and then the last button saying Other formats.

The dropdown menu shows a short list of items and the last one is called My custom export. Clicking it will ask you where to save an exported file, and will create this file according to some specific formatting rules.

Now, how about my own format? Let's take a tour at folder Wiclax_install_folder\export: here you can see a file whose name is identical to the menu item label.

Create a copy of the file in the same folder, and name it as you wish. Let's name it My CSV export for our example. Then edit it with any text editor of your choice.

The file describes all the data you can export, in the form of variable "tags" - i.e. a numeric id identifying a variable like for example a bib number or a time.
It also lists a few available options to change the global behaviour of the export, like some possible values for a header and a footer. This list is not definitive, so please feel free to contact us if you're missing something there to get the perfect export matching your case.

The part to modify is the content between the <Export> tags. We can define a CSV export, for example. A basic export row with the main result data will look like that:

<Export extension=".csv" separator=";" namesUppercase="1"
     header="rank;name;club;time;race;category rank;splits"

Finish your format definition and then open again the Other formats menu in the ribbon. Your new format is now available:


In addition to the ability to output the file corresponding to your new format, you can also decide that the FTP export will follow this format instead of exporting the event file itself.


On the roadmap

As said, the list of options is intended to grow as new requirements come out. Another natural enhancement will be to make possible the setup of multiple FTP exports for an event. You may need to send your results to 2 different places (servers), or to send them both with the Wiclax format and your custom one.