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!

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

Page: Previous 1 2 3 4 5 Next

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.
Hello kropper
A big thank you it works with the link you gave
Again thank you and good race
Jean Pierre said SHINBLUE
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 ---
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 ---
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 ---
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.
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
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
Ah, miss-read thanks, changed setting to month/day & it seems to be working thanks krimp
Sebensa

Your setup should look like this:
Attachments

Page: Previous 1 2 3 4 5 Next

Please login to post a reply.

Races

Next Race: 00d 00h 00m


Current Races:

Cross the Convergence 2026 - Robinson Crusoe to Galapagos


Welcome to our first race of a new series of ocean voyages across the World’s convergence zones, this first race taking you north from south of the Tropic of Capricorn to the Equator-straddling Galapagos, home of magical iguanas and other exotic fauna (but no mythical kings, Dory) Departing from the island where in 1704 adventurer Alexander Selkirk inspired Daniel Defoe to write the best-seller "The Life and Adventures of Robinson Crusoe", by debarking off the unsound "HMS Cinque Ports", four months before she foundered off the coast of present-day Colombia, we will sail the 2200nm in our decidedly sounder and faster than the " Cinque Ports",
Ocean 50 !
Race #1983
INFOby brainaid.de
Ocean 50 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: CCZ - SYC
Race starts: Jan 16th 18:00 Registration will open soon
▶ Flash
GO TO RACE

Bight of Bonny TIMED Race 2026

Welcome to the first TIMED race of 2026! Our race finds us in the Gulf of Guinea and the Bight of Bonny. Starting in Douala, Cameroon the 170 nm course takes us around the island of Bioko with its Caldera and tropical rainforests finishing in Calabar, Nigeria. The boat for this race is the sporty Farr 30. This is a TIMEDrace so you may RE-REGISTER HEREto 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 #2004
INFOby brainaid.de
Farr 38 Particulars
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
TRQ1 - TRCH - SYC
RACE CLOSE: Saturday,
24 January at 23:00 UTC
Race starts: Jan 11th 12:00 Registration Open!
▶ Flash
GO TO RACE

Natuna Sea Race 2026


At 4.0N 108.2E lies the island of Natuna Besar, Great Natuna, surrounded by at least 154 islands, of which 127 uninhabited, Indonesia’s Natuna Regency, and all around this archipelago, the Natuna Sea, bordered by Borneo to the east, the Java Sea to the south, and the Malay peninsula to the west, and extending north to cross a disputed international border with China into the South China Sea. And it’s a border that matters, there’s gas here! But why worry, let’s race – 2050nm in our goo’ol’ Open 60s in between the production platforms, prowling destroyers and submarines.
Race #1997
INFOby brainaid.de
Open 60 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC
Race starts: Jan 06th 17:00 Registration Closed
▶ Flash
GO TO RACE

Cape Town to Rio 2026

Welcome to South Africa and RCYC's classic transatlantic Cape2Rio Race from Cape Town, South Africa, to Rio de Janeiro, Brazil. First run in 1971, this run is buddied with the IRL, Cape2Rio 2025 arranged by the Royal Cape Yacht Club with the cooperation of the
Iate Clube do Rio de Janeiro Despite this being announced the 2025 race (starting dec. 27) it is the 2026 SOL championship kickoff. This virtual version, will be raced once again in Mark Mills' 74ft speedster, the stunning C2R74.
Race #1996 INFO
by brainaid.de
C2R74 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
OCQ1 - OCCH - SUPBUD - SYC
Race starts: Dec 27th 12:00 Registration Closed

▶ Flash
GO TO RACE

Go to race archive

SYC Ranking

  1. Sailonline Yacht Club Member KaSToR
  2. Sailonline Yacht Club Member WRmirekd
  3. Sailonline Yacht Club Member CriticalHippo
  4. Sailonline Yacht Club Member rafa
  5. Sailonline Yacht Club Member vida
  6. Sailonline Yacht Club Member bonknhoot
  7. Sailonline Yacht Club Member Sax747
  8. Sailonline Yacht Club Member rumskib
  9. Sailonline Yacht Club Member CollegeFund
  10. Sailonline Yacht Club Member Panpyc

View full list

Series

Mobile Client

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

The mobile client