[WT-support] Converting CSV to dtb file

[Bob Wilson, N6TV]

On Wed, Dec 25, 2013 at 10:01 PM, Ron Castro <ronc at sonic.net> wrote:

> I can’t find any easy way to convert CSV files to .dtb files for Wintest.
> I want to convert the file found at:
>
>
>
>
> http://www.arizonaoutlaws.net/downloadable/2013ARRL-RTTY-RU-Call-History.csv
>
>
>
> to a binary dtb file for the ARRL RU contest.  How can this be done?
>

Win-Test uses arrl-usve.dtb to prefill exchange data for the ARRL RTTY
Roundup contest.  There is no public version of this file with up-to-date
information, but you can update it yourself just by loading older logs
(.wt4 or Cabrillo) into Win-Test, then from the menu run File | Update
database to update arrl-usve.dtb with the exchange data from the current
log.

As for the .csv file mentioned above, you can use Microsoft Excel or Google
Spreadsheets to import the .csv file. Then add extra columns to make it
look like a "fake" Cabrillo file (date/time/band/call/exchange sent, etc).
 This can all be the same.  Export this updated Spreadsheet as .txt file,
but rename it fake.log and manually add the Cabrillo header information
(run WRITELOG to see what the header is supposed to look like).

Close all logs (File | Close *not* File | Exit), then do File | Import |
Cabrillo, selecting fake.log for import.  Then run File | Update database
again to effectively update arrl-usve.dtb with the data from the .csv file.

Another option is to just convert the .csv file to text using Excel, rename
it .xdt, and display the data in the Extra Data Window:

http://docs.win-test.com/wiki/Menu:Windows#Extra_Information

73,
Bob, N6TV
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.f5mzn.org/pipermail/support/attachments/20131225/3af3fab4/attachment.html>