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:

Victoria to Maui 2022
The Victoria to Maui International Yacht Race, first contested in 1968, is the pinnacle of Pacific Northwest ocean racing, running every two years. This year, Sailonline invites the SOL fleet to race the 2300nm course in Delphia 47s, from Victoria, British Columbia to Hawaii, finishing off Lahaina Maui.
PRIZE: SMPF
Race #1596
INFOby brainaid.de
Delphia 47 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
OCQ3-OCCH-SUPSOL-SYC
Race starts: Aug 09th 19:00 Registration Open!

▶ Flash
GO TO RACE

Brisbane to Hamilton Island Yacht Race 2022


Time once again to head for the warm waters inside The Great Barrier Reef, but this year not only online but together with our buddies at the Royal Queensland Yacht Squadron and their friends from across the world, in the iconic Brisbane to Hamo! Online we’re racing maxi’s to give you a chance to cover the 550 glorious blue water nautical miles in a time to best some of the fastest monohulls on the planet including Andoo Comanche, Black Jack and Hamilton Island Wild Oats . Fair winds, all!
Race #1606
INFOfrom brainaid.de
Super Maxi 100 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking: SYC
RACE CLOSE: Sunday,
August 14 at 2300 UTC.
Race starts: Aug 05th 01:00 Registration Closed
▶ Flash
GO TO RACE

Sailonline’s 15th Birthday Balloon Race
Sailonline offers a huge variety of boats to sail in. One of the more unusual ones has got to be SOL's Balloon, which was polarized by past SOLmaster 76Trombones. Notably, the SOL Balloon will actually ‘sail’ in other directions other than straight downwind, although it will not 'sail' over land or beyond a 'beam reach'. Like in 2013 and 2018, we will be taking the Balloon across the Atlantic from St. John's and 'land' it in the sea off the Cliffs of Moher.
Race #1605
INFO by brainaid.de
SOL Balloon PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
None
Race starts: Aug 01st 19:00 Registration Open!

▶ Flash
GO TO RACE

Simonstown to St Helena 2022
This is a copy of a traditional South African December yacht race, but this time we will be racing in the middle of European summer. SOLers are invited to race 1712nm in our GB90s from Simonstown, RSA, to the exotic and remote island of St Helena - an island paradise with warm, friendly, hospitable islanders!
Race #1593
INFO by brainaid.de
GB90 PARTICULARS
WX Updates:
0430 / 1030 / 1630 / 2230
Ranking:
ARQ3 - ARCH - SUPSOL - SYC
RACE CLOSE: Friday,
August 12 at 2300 UTC.
Race starts: Aug 01st 18:00 Registration Closed

▶ Flash
GO TO RACE

Go to race archive

SYC Ranking

  1. Sailonline Yacht Club Member WRmirekd
  2. Sailonline Yacht Club Member Pit8008
  3. Sailonline Yacht Club Member rafa
  4. Sailonline Yacht Club Member FreyjaUSA
  5. Sailonline Yacht Club Member Sax747
  6. Sailonline Yacht Club Member GREATSKUA
  7. Sailonline Yacht Club Member Vida_Maldita
  8. Sailonline Yacht Club Member Kipper1258
  9. Sailonline Yacht Club Member HappyHour
  10. Sailonline Yacht Club Member sassy63

View full list

Series

Mobile Client

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

The mobile client