Sailonline.org - Online Sailing

Facebook

Login

Support Sailonline

If you haven't already - join the SAILONLINE YACHT CLUB!

Please also consider making a donation - all amounts are greatly appreciated!

Tweets by @sailonline

Board » General Discussion » Converting a QtVLM route to brainaid DCs

Posted by kroppyer Posts 346 Registered at 2010-02-05 15:25:55	2016-04-02 19:42:47 - Re: Converting a QtVLM route to brainaid DCs
	The dates need to be in English, so "arv." is not recognised. The solution is to get QtVLM to export the routes in English. I have quickly added an option that might help you. You can use this link (so long your DCs are in april): http://sol.kroppyer.nl/qtvlm2dc/?date_regex=/avr\./&date_replace=apr It automatically replaces "arv." by "apr" in the date field. This is a quick and dirty solution, and it won't work for many cases, just when "avr." needs to be replaced by "apr". But I can give a link to replace practically anything by anything else, when you have a new file that doesn't work. At some point I might add some kind of language support for dates, but right now you either need to supply English dates, or you need to use the work-around.
Posted by SHINBLUE Posts 5 Registered at 2010-06-17 16:41:03	2016-04-03 07:07:34 - Re: Converting a QtVLM route to brainaid DCs
	Hello kropper A big thank you it works with the link you gave Again thank you and good race Jean Pierre said SHINBLUE
Posted by Amiral29 Posts 25 Registered at 2009-07-30 08:47:22	2016-04-04 12:23:50 - Re: Converting a QtVLM route to brainaid DCs
	Ok thank you very much! I have the permanent solution : modified système preferences langage & text--> United kingdom (Royaume Uni) exportation and come back to French preferences! OUF! --- Dernière modification par Amiral29 le 2016-04-04 12:59:36 ---
Posted by kroppyer Posts 346 Registered at 2010-02-05 15:25:55	2016-05-04 10:41:37 - Re: Converting a QtVLM route to brainaid DCs
	I've heard from people that in this new month QtVLM may use "maj" instead of "may", causing the date conversion to fail. I've updated the converter to automatically translate "avr." to "apr"; "mai" and "maj" to "may" So this link should work for you: http://sol.kroppyer.nl/qtvlm2dc/ (Tech note: the date_regex and date_replace variables can still be used to override these translations to something else, when the new month comes for example) --- Last Edited by kroppyer at 2016-05-04 10:53:28 ---
Posted by muggles Posts 24 Registered at 2024-07-11 11:58:13	2016-05-08 20:51:09 - Re: Converting a QtVLM route to brainaid DCs
	qtvlm 5.3-4 If you export a route to .cvs in qtvlm no longer the name of the month is exported but the number. That's nice but be sure that in the qtvlm configuration screen your choice of day/month or month/day is right. using brainaids dc-editor there is a big difference between 08/05/2016 22:26:00 cc 100 and 05/08/2016 22:26:00 cc 100 my excel macro's worked because 08 mei 2016 was recognized as date where mei 08 2016 was not. Conversion to 2016/05/08 was somewhat different for both. If I choose in Qtvlm day/month all works well. If you use http://sol.kroppyer.nl/qtvlm2dc/ you no longer have to worry about the maj, may, mai or whatever this month is called in your language.. (in my excel macro i plan to check whether todays month number is te same as qtvlm's month.. ) --- Last Edited by krimpvrij at 2016-05-09 14:10:52 ---
Posted by kroppyer Posts 346 Registered at 2010-02-05 15:25:55	2016-05-09 14:42:08 - Re: Converting a QtVLM route to brainaid DCs
	I think I'm reading my converter works with the new qtvlm date format? Be sure to let me know when it fails (if possible, send me the file that makes it fail). I haven't tested with the new qtvlm date format, so double check the output dates.
Posted by muggles Posts 24 Registered at 2024-07-11 11:58:13	2016-05-09 15:26:31 - Re: Converting a QtVLM route to brainaid DCs
	two files one working (qtvlm month/day) and one not working (qtvlm day/month) --- Last Edited by krimpvrij at 2016-05-09 15:43:53 --- Attachments notworking.csv (102.6 KB) working.csv (102.4 KB)
Posted by Sebensa Posts 70 Registered at 2010-10-06 14:50:36	2016-07-12 14:56:15 - Re: Converting a QtVLM route to brainaid DCs
	After changing to version 5.3-7, I now get the date format as yyyy/dd/mm? Qtvlm shows correct format on route details as dd/mm/yyyy any suggestions please
Posted by Sebensa Posts 70 Registered at 2010-10-06 14:50:36	2016-07-12 16:01:51 - Re: Converting a QtVLM route to brainaid DCs
	Ah, miss-read thanks, changed setting to month/day & it seems to be working thanks krimp
Posted by Bimmer Posts 447 Registered at 2015-02-23 15:38:27	2016-07-12 16:05:58 - Re: Converting a QtVLM route to brainaid DCs
	Sebensa Your setup should look like this: Attachments QtVlm_Config_Display.jpg (89.5 KB)

Page: Previous 1 2 3 4 5 Next

Please login to post a reply.

Races

Next Race: 00d 00h 00m

Current Races:

Kapiti Chetwodes Race 2024

For only the second time in SOL history, we have the pleasure of inviting you to the Kapiti Chetwodes Race, held in the Cook Strait region. Organised IRL by the Royal Port Nicholson Yacht Club from Wellington in New Zealand. The approximately 160nm long route, full of turning points, will take us from the bay at RPNYC around the islands of Somes, Kapiti and Chetwodes and back to the finish line at RPNYC. We have only a 26 ft Albin 79 yacht at our disposal. All this means that we will have a lot of fun, so fair winds!
Race #1864
INFO by brainaid.de
Albin 79 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
ARQ4 - ARCH - SUPSOL - SYC
Race starts: Nov 25th 17:00 Registration Open!

▶ Flash

GO TO RACE

Raja Muda Selangor 2024 - Penang to Langkawi

Welcome to the third and last online race of the Raja Muda Selangor International offshore series – a 70nm final trip further north again up the Malacca Strait from Penang to the exotic island of Langkawi, and again in Ker 40s.
Race #1871
INFO by brainaid.de
Ker 40 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: RMS - SYC
RACE CLOSE: Monday,
November 25 at 2300 UTC.
Race starts: Nov 21st 04:00 Registration Open!

▶ Flash

GO TO RACE

Raja Muda Selangor 2024 - Pangkor to Penang

Welcome to our second online offshore race in cooperation with Raja Muda Selangor International – an 80nm trip from Pangkor north to Penang up the Malacca Strait, again in Ker 40s.
Race #1870
INFO by brainaid.de
Ker 40 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: RMS - SYC
RACE CLOSE: Saturday,
November 23 at 2300 UTC.
Race starts: Nov 18th 04:00 Registration Open!

▶ Flash

GO TO RACE

Two Oceans Doublecross TIMED Race 2024

Our November Timed race takes us to Cape Town near where the Atlantic and Indian oceans meet. Our ride is a beautiful ketch, the Archer 78. Starting at Cape Town, we’ll round Robben Island, then head south to round Cape Point, up around Seal Island before heading north to round Dassen Island before returning to Cape Town. This is a TIMED race, so you may RE-REGISTER HERE to try again, after finishing a run. You will have 13 days and 11 hours to test your skill and decision making after the race opens.
Race #1872
INFO by brainaid.de
Archer 78 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
TRQ4 - TRCH - SUPSOL - SYC
RACE CLOSE: Saturday,
30 November at 23:00 UTC
Race starts: Nov 17th 12:00 Registration Open!

▶ Flash

GO TO RACE

Nassau to Bodo 2024

Prepare for the grand finale - the 6th and concluding leg of the RTW challenge, an odyssey from Nassau in the Caribbean to Bodø in Norway. Embracing a journey of 4000 nautical miles, this leg promises an exhilarating 18-day voyage. It also heralds the November installment of our prestigious Ocean Race Championship. Embark on a voyage of a lifetime, where prowess, tactics, and camaraderie unite in the pursuit of triumph. We eagerly await your presence at the starting line! May the winds be ever in your favor.
PRIZE: SMPF
Race# 1866
INFO from brainaid.de
Swan 65 PARTICULARS
WX updates:
0430 / 1030 / 1630 / 2230
Ranking: OCQ4 - OCCH - RTW - SUPSOL - SYC
Race starts: Nov 11th 11:00 Registration Closed

▶ Flash

GO TO RACE

Go to race archive

SYC Ranking

View full list

Series

Mobile Client

SYC members have the benefit of access to our mobile/lightweight web client!

The mobile client