The dxn2csv program converts a DX4WIN 8.0x .DXN (names) file to .CSV format so it can be loaded into Excel or another spreadsheet program.

Version 1.1 of the program was released on 14 September 2009. Click on this link to download the program. Click on this link to see the revision history.


Features

This is a simple utility to convert an exported DX4WIN8 .DXN file to .CSV (comma-delimited) format. The .DXN file contains names, QTHs and callsign notes, but they are on separate lines, so it's hard to examine the file using a spreadsheet program. Once the file is in .CSV format, it's easy to read it into a spreadsheet, to examine names, etc. in order to determine whether the DX4WIN conversion of Name/QTH went smoothly. If you find errors, fix them in your log, then export the log again, re-convert the .DXN file, and examine the result in your spreadsheet.


Operation

After downloading the program, extract (unzip) the DXN2CSV.EXE file to your DX4WIN\SAVE directory.

Now, in DX4WIN, go to File | Import/Export, select DX4WIN8 format, and export your log. Default is to save it it to the same name as your .DXL file (do NOT give the exported file an extension, however):

Next, open a Windows "CMD" (command) window, and navigate to your DX4WIN "SAVE" directory using the cd command, i.e.:

cd c:\program files\dx4w802\save

Run the program by typing:

dxn2csv <yourcall>.DXN [<output>.CSV]

The first argument is the name of the file you exported in DX4WIN8 format. Do not include the <>. The second argument is optional. If you don't specify the second argument, then the output file will be named <yourcall>.CSV. The optional second argument should end in .CSV so that the spreadsheet program will recognize it.

After the program finishes, the output will look something like this:

Convert DX4WIN8 .DXN file to .CSV - Version 1.1
Jim Reisert, AD1C - Sep 13 2009 23:03:38

Wrote 3294 callsigns to AD1C.CSV

Once the file is loaded into a spreadsheet, it is useful to sort the Name column, and scan for things that aren't names. Similarly for the QTH column. If you see errors, fix them in your logbook. Note that the name, QTH and note is associated with a callsign, not a QSO. Thus, fixing the first QSO with the error will fix all subsequent QSOs with the same callsign.


Summary

Please contact me with any questions or concerns.


Revision History

Ver 1.1 - 14 September 2009
Initial Release