FS Comp export options from results report
- This topic has 2 replies, 3 voices, and was last updated 14 years, 11 months ago by
.
-
Posts
-
<p>I have just scored a comp using FS Comp 1.2.12 and GPS Dump 433. I need to get the scores for the comp into a spread sheet for further calculations (we normalise all scores over 500 pts to 500 maximum). On one computer which has XL on it there is an option in the results sheet when you right click on the mouse to export to Excel. However, on another computer which does not have XL the only option is to send to Bluetooth.</p>
<p>Is it possible to set the program so it sends to Microsoft Works spreadsheet or Open Office on the computer without XL ?
</p>One way to get the result in whatever format you like is to make a copy of “task_result.tkr.xsl”, the modify it as you like.
This requires some knowledge of xml and xslt. If you’re expert in xslt you can transform the results and do whatever calcultations you want here. Only your imagination (and xslt skills sets the limits).
Under the Reports menu there is the option to tick “Create source.xml file…”. You will then get an xml file which is the same as what is used as input for the xsl file. Use this to see what is available to play with.
Also Under the Reports menu there is “Reports using stylesheet (*.xsl)…”. Write your own xsl file from scratch. The input xml here is the whole fsdb file (Try to tick “Create source.xml…” and look at the .xml file).
As mentioned at the beginning, the more you want to do with this the more knowledge of xslt you will need.
Anyhow, to get something that can be opened in a spread sheet program one could create a task result xsl file which created a csv file with the relevant data.
Stein-Tore
- You must be logged in to reply to this topic.