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 DELETED_01oct2016 Posts 24 Registered at 2010-02-27 13:01:21	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 DELETED_01oct2016 Posts 24 Registered at 2010-02-27 13:01:21	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:

Manilla to Calbayog 2024

After six years, we welcome you to the race created by sassy63 for the second time. He takes us to the Philippines to race around islands on a 380 nm course. We sail the Italia 14.98 and in Calbayog we'll enjoy our well-deserved Palatan dish and drink it with San Miguel.
Race #1803
INFO from brainaid.de
Italia 14.98 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
ARQ2 - ARCH - SUPSOL - SYC
Race starts: Apr 22nd 17:00 Registration Open!

▶ Flash

GO TO RACE

Jakob's Birthday BBQ Race 2024

Sailonline had two founders and Jakob, the more senior of the two, has his birthday in April which we always like to celebrate with a race through the Stockholm Archipelago from Revengegrundet Lighthouse to his mooring at Baggensfjärden. Traditionally also, like other celebrations this time of year, this feast has been “moveable”, so on this occasion we will be racing on a Wednesday in one of our latest high-performance 40-footers, the Carkeek 40. Please join us then for this always tricky 30nm race. Grattis på födelsedagen Jakob!
Race #1794
INFO by brainaid.de
Carkeek 40 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC
RACE CLOSE: Wednesday,
April 24 at 2300 UTC.
Race starts: Apr 20th 14:00 Registration Closed

▶ Flash

GO TO RACE

Melbourne to Osaka Prelude 2024

Welcome once again to what these days is Sailonline’s almost annual virtual Melbourne to Osaka Yacht Race. In real life, this double-handed 5500 nm race between these two sister cities, one deep in the southern hemisphere, the other high in the northern hemisphere, is run every four to five years, and is planned to be held again in 2025, so this race is a Prelude in partnership with the Melbourne Osaka Cup 2025 organising committee collaborating with the Ocean Racing Club of Victoria (ORCV), and the Sandringham (SYC) and Osaka Hokko (OHYC) yacht clubs. On this occasion, we’ll be racing the well-known First 40, a popular size of boat for a long-distance double-handed race. With the doldrums unavoidably lying across the track, you can expect to be at virtual sea for at least a month!
Race #1669
INFO by brainaid.de
First 40 Particulars
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC
Race starts: Apr 20th 00:00 Registration Open!

▶ Flash

GO TO RACE

St Nazaire Chasse TIMED Race 2024

Welcome to a "chasse" (hunt) from St. Nazaire to La Baule on the west coast of France! This race was designed by SOLer FR_flouflou in 2010. The KER 40 was introduced to SOL in 2016 by SOLer psail, and the Sol-KER was a welcome addition to SOL’s fleet of 40- footers, as it was to the IRL Ker fleet of eponymous - like KERonimo, KukuKERchu and Ice BreaKER. This is a TIMEDrace, so you may RE-REGISTER HERE to try again, after finishing a run. You will have 13 days and 11 hours to show your skill and decision making after the race opens.
Race #1797
INFOby brainaid.de
Ker 40 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
TRQ2 - TRCH - SUPSOL - SYC
RACE CLOSE: Saturday,
27 April at 23:00 UTC
Race starts: Apr 14th 12:00 Registration Open!

▶ Flash

GO TO RACE

Cape Town to Auckland 2024

Welcome to the second leg of this Round The World series 2024. It's also the April edition of this year's ocean race championship. The course is the same as the one sailed in 2023, but this year we sail the iconic Swan 65, as suggested in the concluding RTW race last year.
Prepare yourselves for an epic 30-day journey, navigating through the unpredictable waters of the South Seas. It's essential to take care of provisioning to ensure a smooth and enjoyable race experience. With the longer duration, we anticipate plenty of opportunities for camaraderie, competition, and unforgettable memories.
PRIZE: SMPF
Race# 1789
INFO from brainaid.de
Swan 65 PARTICULARS
WX updates:
0430 / 1030 / 1630 / 2230
Ranking: OCQ2 - RTW - OCCH - SUPSOL - SYC
Race starts: Apr 01st 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