[Dx4win] Conversion program

[Larry Benko]

Be a little bit careful here.  There are some subtle anomolies with 
DX4Win when merging logs with identical callsigns but different data in 
some fields.  When logging by hand and you enter a callsign, DX4Win 
brings up the notes fields, State, county etc. based on the last contact 
with that callsign.  When merging logs this does not happen.  Perhaps 
you don't care but just be aware of it.  I don't remember the details 
but when I used a converter program such as the one below I some issues 
with some of the notes fields.  Give it a try and if it works then super.

73,
Larry, W0QE


Alan Sewell wrote:
> Or you can do it the easy way and use KH2D's ASCII to ADIF Converter.
>
> http://www.kh2d.net/software/asc2adif.cfm
>
> You may have to rearrange the columns in your Excel file to get them 
> in the correct order for the converter.  Then just save your Excel 
> file as a CSV file.
>
> 73,
>
> Alan  N5NA
>
> http://www.tentecwiki.org
>
>
>
> Larry Benko wrote:
>> Steve,
>>
>> This is a piece of cake to do.  I do it several times a year after 
>> going out mobile and making a few thousand contacts.  The procedure 
>> contains a few parts.
>>
>> 1.) Figure out how to take your Excel spreadsheet and export it to a 
>> text file that is column aligned.  I usually save as a CSV text file 
>> and then load the CSV file into a text editor such as UltraEdit where 
>> I tell it that every comma is a new column spaced every 25 spaces.  
>> Now you have a column aligned text file with (for example), the call 
>> sign in column 1, the date in column 26, the time in column 51, etc.  
>> You also have 1 QSO per line.
>>
>> 2.) Now you go into DX4Win and create a new import filter which looks 
>> for the ADIF field <CALLSIGN> starting in column 1 and the <DATE> 
>> field starting in column 26 etc.  Name and save your import filter.
>>
>> 3.) Now use your newly created filter to import your Excel text data 
>> to a blank DX4Win log.  You will probably have some mistakes in the 
>> date and time formats and maybe a few other things.  Fix them and redo.
>>
>> 4.) Once you have a good DX4Win log from the Excel data you can merge 
>> this log with you real log.
>>
>> 73,
>> Larry, W0QE
>>
>> Stephan Busono wrote:
>>> Fellow DX4Win users
>>> for those computer expert out there, is there a utility program that 
>>> can
>>> convert an XLS (regular (exel) type spreadsheet )log to an ADIF so I 
>>> can
>>> import it to DX4Win.
>>> Thanks for the help/input
>>> 73, Steve, W2FB
>>> _______________________________________________
>>> Dx4win mailing list
>>> Dx4win at mailman.qth.net
>>> http://mailman.qth.net/mailman/listinfo/dx4win
>>>
>>>   
>> _______________________________________________
>> Dx4win mailing list
>> Dx4win at mailman.qth.net
>> http://mailman.qth.net/mailman/listinfo/dx4win
>>
>