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.
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.
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.
Please contact me with any questions or concerns.