Automation

Moderators: systemmods, Calendarmods

Post Reply
iBanesto
Posts: 299
Joined: Sat Feb 20, 2010 12:17 am
Contact:

Automation

Post by iBanesto » Wed Aug 10, 2011 3:38 pm

Hello there fellow race designers!

Are you sick and tired of typing 200 numbers in an excel sheet one by one? I kind of was when I started working on my december tour two weeks ago, so I used my (somewhat limited) skills to create myself a little program that I would like to share with you. The input of the program is a tcx-file from bikeroutetoaster, tracks4bikers or whatever you use. The output is a nice little etn-file (only containing percentages, no names of places and stuff) ready to be uploaded in the php-raceeditor. This cuts out most of the boring typing stuff in the excel editor and saves quite some time. For example, I just did this Vuelta stage in less than 10 minutes.

Image

Using Bikeroutetoaster to layout the track: 5 minutes
Downloading tcx-file, creating etn-file: 1 minute
Uploading etn-file, filling the other forms in the raceeditor: 2 minutes
Neat, isn't it?


How to use it:
Unzip the zip file. Not allowed to upload jar-files here.
There is no graphics user interface, so you need a command line. Go to the folder of the jar-file and enter the following to run it:

java -jar RSF.jar "C:\MyFiles\Downloads\course.tcx"

with C:\MyFiles\Downloads\course.tcx obviously the path of the tcx-track you downloaded.
Now you either have crazy error messages or a etn-file in the same folder as the tcx-file.

Have fun!
Attachments
RSF.zip
(3.91 KiB) Downloaded 229 times

sylvainmeteo
Posts: 2988
Joined: Thu Aug 05, 2010 1:50 pm
Location: Vaucluse, France
Contact:

Re: Automation

Post by sylvainmeteo » Wed Aug 10, 2011 3:46 pm

Let's try, but I don't understand all ^^
EDIT : can't open the jar file ^^
Team : SM Team
Victoires d'étape : 374 ; dont les 5 monuments et les 3 GTs !
Hall of Fame : Katrasnik: 26724 pts

User avatar
flockmastoR
Posts: 3112
Joined: Thu Feb 18, 2010 11:42 pm
Contact:

Re: Automation

Post by flockmastoR » Wed Aug 10, 2011 10:59 pm

hm need an explanation for dummies!
Boaz Trakhtenbrot:
  • Winner Giro 2022
  • 10 GC wins
  • 16.609 Eternal Points
__________________
Schrödinger's Dogs: Alive & Dead

iBanesto
Posts: 299
Joined: Sat Feb 20, 2010 12:17 am
Contact:

Re: Automation

Post by iBanesto » Thu Aug 11, 2011 12:05 am

Explanation for dummies:

How to get to a MS-DOS prompt or Windows command line

So do this thing from the link thing above. Start, Run/Ausführen, cmd or Start, cmd or whatever it says there for your system.
Go to the folder where the jar-file is by using the "cd"-command, like "cd Desktop", "cd Downloads\Files" or "cd.." (guess what that does!). Don't type the " , that would be stupid. Type stuff, press enter, stuff happens with the white letters on the black background.

In the folder of the jar-file, type:

java -jar RSF.jar "C:\MyFiles\Downloads\course.tcx"

Include the " here, they are needed! Mas importante!
Also change C:\MyFiles\Downloads\course.tcx to the path of your tcx-file.
Press enter. This should be it. Dummie enough?

etn-file should be now in the same folder as your tcx-file.

User avatar
flockmastoR
Posts: 3112
Joined: Thu Feb 18, 2010 11:42 pm
Contact:

Re: Automation

Post by flockmastoR » Thu Aug 11, 2011 7:37 am

Dummie enough and it works!!!!
great work iBan, nice tool!
Boaz Trakhtenbrot:
  • Winner Giro 2022
  • 10 GC wins
  • 16.609 Eternal Points
__________________
Schrödinger's Dogs: Alive & Dead

User avatar
NoPikouze
Posts: 2964
Joined: Sat Mar 06, 2010 3:57 pm
Contact:

Re: Automation

Post by NoPikouze » Sat Aug 13, 2011 9:09 pm

Hey guys,

I took the liberty of improving this nice little program.
Instead of typing manually the whole thing as a ms-dos command line, which is not really convenient, I made an automated program for this part.

How to use it ?
- Unzip the attached file in a folder on your computer
- save the TCX files (from T4B etc...) in this same folder
- pull the TCX file to the RSF Convertor and the ETN file should be created !

Have fun.
Attachments
RSF Converter.zip
(4.26 KiB) Downloaded 230 times
Qui sème le vent récolte le tempo...

sylvainmeteo
Posts: 2988
Joined: Thu Aug 05, 2010 1:50 pm
Location: Vaucluse, France
Contact:

Re: Automation

Post by sylvainmeteo » Sun Aug 14, 2011 4:26 pm

NoPikouze wrote:Hey guys,

I took the liberty of improving this nice little program.
Instead of typing manually the whole thing as a ms-dos command line, which is not really convenient, I made an automated program for this part.

How to use it ?
- Unzip the attached file in a folder on your computer
- save the TCX files (from T4B etc...) in this same folder
- pull the TCX file to the RSF Convertor and the ETN file should be created !

Have fun.
Excellent!
Team : SM Team
Victoires d'étape : 374 ; dont les 5 monuments et les 3 GTs !
Hall of Fame : Katrasnik: 26724 pts

Hansa
Posts: 947
Joined: Wed May 19, 2010 8:27 pm
Contact:

Re: Automation

Post by Hansa » Sat Aug 27, 2011 11:16 am

because of my bad Englisch i don´t understand it can somebody translate it in German?
Hansa

est. 03.08.2009

Woddeltown Team
Posts: 413
Joined: Sat Aug 06, 2011 6:46 pm
Contact:

Re: Automation

Post by Woddeltown Team » Sat Aug 27, 2011 12:04 pm

Welchen Text?
www.strandpiraten-radio.de DAS Fanradio vom EHC Timmendorfer Strand

el Galactico
Posts: 908
Joined: Wed Feb 17, 2010 5:12 pm
Contact:

Re: Automation

Post by el Galactico » Sun Sep 11, 2011 2:36 pm

It doesn't work for me. No ETN-file appears :(
Can somebody help me?
Rodrigo Tellez - Winner of Tour Down Under 2023!!!

Siempre Campeones! Hala Galacticos!!

Statistics
Hall of Fame
Cyclist of the Month

iBanesto
Posts: 299
Joined: Sat Feb 20, 2010 12:17 am
Contact:

Re: Automation

Post by iBanesto » Sun Sep 11, 2011 4:20 pm

Can you be more specific?

el Galactico
Posts: 908
Joined: Wed Feb 17, 2010 5:12 pm
Contact:

Re: Automation

Post by el Galactico » Sun Sep 11, 2011 5:21 pm

Sure, i dowonloaded the file with the convertor. Created a tcx-file with t4b, saved it in the same folder and then i pulled it to the converter, but then nothing happens... no ETN-file appears in this folder.

Maybe this helps you: It's what the appearing screen tells me then...


This program converts a TCX file into a ETN file for Radsportfreaks.
Clic on the TCX file, pull it to the RSF Converter, and a ETN file should appear
in the folder.
--------------------

C:\Dokumente und Einstellungen\Bjoern>cd C:\Dokumente und Einstellungen\Bjoern\D
esktop\GPS tracks\

C:\Dokumente und Einstellungen\Bjoern\Desktop\GPS tracks>java -jar RSF.jar "C:\D
okumente und Einstellungen\Bjoern\Desktop\GPS tracks\Salvador.tcx"
Exception in thread "main" java.lang.UnsupportedClassVersionError: Bad version n
umber in .class file
at java.lang.ClassLoader.defineClass1(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.access$100(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
--------------------
Operation finished
Drücken Sie eine beliebige Taste . . .
Rodrigo Tellez - Winner of Tour Down Under 2023!!!

Siempre Campeones! Hala Galacticos!!

Statistics
Hall of Fame
Cyclist of the Month

Alkworld
Posts: 1124
Joined: Sat Feb 27, 2010 8:40 pm
Contact:

Re: Automation

Post by Alkworld » Sun Sep 11, 2011 5:59 pm

Exception in thread "main" java.lang.UnsupportedClassVersionError: Bad version number in .class file
at java.lang.ClassLoader.defineClass1(Native Method)
...
This pretty likely means that you are using a Java version which is either too old or too new. Java is often installed with other software which requires it being there, e.g. OpenOffice. Type the following on the Windows command line: java -version. If someone with a working version can tell you what he's using, you should try with the same version. What you need then is the Java Runtime Environment (JRE) with the same version, e.g. from http://www.java.com/de/download/

Avaya
Posts: 119
Joined: Wed Jul 20, 2011 6:02 pm
Contact:

Re: Automation

Post by Avaya » Mon Sep 12, 2011 9:23 pm

also ich hab nun ne reihe von tcx files geladen, und 5 davon kann ich irgendwie nicht konvertieren also ins etn, bei den anderen klappts?

ich bekomme die nachricht

C:\Users\Pascal>java -jar RSF.jar "C:\Users\Pascal\Downloads\RSF\Münster.tcx"
java.net.MalformedURLException: unknown protocol: c
at java.net.URL.<init>(Unknown Source)
at java.net.URL.<init>(Unknown Source)
at java.net.URL.<init>(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLEntityManager.setupCurrent
Entity(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLVersionDetector.determineD
ocVersion(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(U
nknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(U
nknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown So
urce)
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown So
urce)
at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unk
nown Source)
at javax.xml.parsers.DocumentBuilder.parse(Unknown Source)
at DomParserExample.parseXmlFile(DomParserExample.java:41)
at DomParserExample.runExample(DomParserExample.java:25)
at Shell.main(Shell.java:11)
Exception in thread "main" java.lang.NullPointerException
at DomParserExample.parseDocument(DomParserExample.java:54)
at DomParserExample.runExample(DomParserExample.java:27)
at Shell.main(Shell.java:11)


ist die tcx einfach "kaputt"? weil javaversion oder so kann ja nicht sein, weil ich 4 andere etappen konvertiert hab..

el Galactico
Posts: 908
Joined: Wed Feb 17, 2010 5:12 pm
Contact:

Re: Automation

Post by el Galactico » Mon Sep 12, 2011 11:47 pm

Thanks a lot. It's working now. Is there a chance to do the same with Files from Google Earth?(for my Dec tour eg.)
Rodrigo Tellez - Winner of Tour Down Under 2023!!!

Siempre Campeones! Hala Galacticos!!

Statistics
Hall of Fame
Cyclist of the Month

iBanesto
Posts: 299
Joined: Sat Feb 20, 2010 12:17 am
Contact:

Re: Automation

Post by iBanesto » Tue Sep 13, 2011 12:21 am

Avaya, haben die Dateien die Probleme machen zufälligerweise Umlaute im Dateinamen?

Woddeltown Team
Posts: 413
Joined: Sat Aug 06, 2011 6:46 pm
Contact:

Re: Automation

Post by Woddeltown Team » Tue Sep 13, 2011 2:17 am

Was mache ich falsch?
Attachments
Problem.jpg
Problem.jpg (88.06 KiB) Viewed 9485 times
www.strandpiraten-radio.de DAS Fanradio vom EHC Timmendorfer Strand

Team Schlonz
Posts: 34
Joined: Fri Sep 09, 2011 12:00 pm
Contact:

Re: Automation

Post by Team Schlonz » Tue Sep 13, 2011 7:23 am

Woddeltown Team wrote:Was mache ich falsch?
So ad hoc würde ich vermuten, dass du entweder Java nicht installiert hast oder die Verlinkung in der Kommandozeile nicht eingestellt ist. Das kann man irgendwie überprüfen, habe aber keine Ahnung wie. :oops:
Falls Java installiert ist, führe das ganze doch testweise aus dem Java-Verzeichnis (bei mir c:\programme\java\jre6\bin) aus.
Also bsp. mit dem Befehl: C:\Programme\java\jre6\bin\> java.exe -jar d:\rsf\deutschland\bischofshofen.tcx
Groß- und Kleinschreibung spielt bei (emuliertem) DOS bzw. der Win-Kommandozeile keine Rolle. ;)

Woddeltown Team
Posts: 413
Joined: Sat Aug 06, 2011 6:46 pm
Contact:

Re: Automation

Post by Woddeltown Team » Tue Sep 13, 2011 9:40 am

Team Schlonz wrote:
Woddeltown Team wrote:Was mache ich falsch?
So ad hoc würde ich vermuten, dass du entweder Java nicht installiert hast oder die Verlinkung in der Kommandozeile nicht eingestellt ist. Das kann man irgendwie überprüfen, habe aber keine Ahnung wie. :oops:
Falls Java installiert ist, führe das ganze doch testweise aus dem Java-Verzeichnis (bei mir c:\programme\java\jre6\bin) aus.
Also bsp. mit dem Befehl: C:\Programme\java\jre6\bin\> java.exe -jar d:\rsf\deutschland\bischofshofen.tcx
Groß- und Kleinschreibung spielt bei (emuliertem) DOS bzw. der Win-Kommandozeile keine Rolle. ;)
Danke einstweilen.
Java ist installiert, also kann es daran nich liegen ;)
Deine Idee klappt leider nicht
www.strandpiraten-radio.de DAS Fanradio vom EHC Timmendorfer Strand

Team Schlonz
Posts: 34
Joined: Fri Sep 09, 2011 12:00 pm
Contact:

Re: Automation

Post by Team Schlonz » Tue Sep 13, 2011 10:31 am

Ähm, nimm mal die Anführungszeichen beim Dateinamen weg.
Und wenn du in der command line im Pfad D:\RSF\Deutschland stehst, brauchst du ihn beim Dateinnamen nicht nochmal anzugeben.
Es reicht aus, wenn du am Pompt eingibst: java -jar rsf.jar bischofshofen.tcx

Falls es dann immer noch nicht klappt. Überprüf mal die Java-Version.
Bei mir läuft die Version 1.6.0_24 bislang ohne Probleme.

Woddeltown Team
Posts: 413
Joined: Sat Aug 06, 2011 6:46 pm
Contact:

Re: Automation

Post by Woddeltown Team » Tue Sep 13, 2011 11:30 am

Auch die Idee funktioniert nicht, leider. Gleiche Fehlermeldung wie auf dem Screen

Von Java hab ich die aktuellste Version gestern installiert, weil ich auch befürchtete, dass es daran lag.
www.strandpiraten-radio.de DAS Fanradio vom EHC Timmendorfer Strand

Avaya
Posts: 119
Joined: Wed Jul 20, 2011 6:02 pm
Contact:

Re: Automation

Post by Avaya » Tue Sep 13, 2011 1:41 pm

iBanesto wrote:Avaya, haben die Dateien die Probleme machen zufälligerweise Umlaute im Dateinamen?
ja hatten sie.. danke iban. :D

User avatar
Berlin Marks
Posts: 187
Joined: Sat Feb 20, 2010 12:02 am
Contact:

Re: Automation

Post by Berlin Marks » Mon Oct 17, 2011 11:05 pm

Woddeltown Team wrote:Auch die Idee funktioniert nicht, leider. Gleiche Fehlermeldung wie auf dem Screen

Von Java hab ich die aktuellste Version gestern installiert, weil ich auch befürchtete, dass es daran lag.

hab das selbe problem.

User avatar
Berlin Marks
Posts: 187
Joined: Sat Feb 20, 2010 12:02 am
Contact:

Re: Automation

Post by Berlin Marks » Wed Oct 19, 2011 3:51 pm

Problem gelöst :!:


Java Runtime Environment hat gefehlt!

Java Runtime Environment (32-Bit Version)

Java Runtime Environment (64-Bit Version)

sylvainmeteo
Posts: 2988
Joined: Thu Aug 05, 2010 1:50 pm
Location: Vaucluse, France
Contact:

Re: Automation

Post by sylvainmeteo » Wed Feb 22, 2012 1:36 pm

Hello, my computers crashed 1 month ago, and since it, I try to design something, but I can't do anything, what version of java we need to run it and my problem is that the automation don't want to convert a T4B track to a .etn file...
I've this message (french) : j'ai un message : java n'est pas reconnu en tant que commande interne un programme exécutable ou un fichier de commandes
Team : SM Team
Victoires d'étape : 374 ; dont les 5 monuments et les 3 GTs !
Hall of Fame : Katrasnik: 26724 pts

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests