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 From [EMAIL PROTECTED] Mon Apr 7 11:44:57 2008 From: [EMAIL PROTECTED] (Larry Benko) Date: Mon Apr 7 11:53:19 2008 Subject: [Dx4win] Conversion program In-Reply-To: <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]>
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 > [email protected] > http://mailman.qth.net/mailman/listinfo/dx4win > > From [EMAIL PROTECTED] Mon Apr 7 11:56:35 2008 From: [EMAIL PROTECTED] (Alan Sewell) Date: Mon Apr 7 12:04:39 2008 Subject: [Dx4win] Conversion program In-Reply-To: <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> 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 >> [email protected] >> http://mailman.qth.net/mailman/listinfo/dx4win >> >> > _______________________________________________ > Dx4win mailing list > [email protected] > http://mailman.qth.net/mailman/listinfo/dx4win > From [EMAIL PROTECTED] Mon Apr 7 12:30:31 2008 From: [EMAIL PROTECTED] (Larry Benko) Date: Mon Apr 7 12:38:39 2008 Subject: [Dx4win] Conversion program In-Reply-To: <[EMAIL PROTECTED]> References: <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> 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 >>> [email protected] >>> http://mailman.qth.net/mailman/listinfo/dx4win >>> >>> >> _______________________________________________ >> Dx4win mailing list >> [email protected] >> http://mailman.qth.net/mailman/listinfo/dx4win >> > From [EMAIL PROTECTED] Mon Apr 7 12:51:42 2008 From: [EMAIL PROTECTED] (Jim Reisert AD1C) Date: Mon Apr 7 12:59:37 2008 Subject: [Dx4win] Re: Mailman List Server Update In-Reply-To: <[EMAIL PROTECTED]> Message-ID: <[EMAIL PROTECTED]> Some (or all) of you may have received a solicitation from Al, K3TKJ regarding the server that is used to host the DX4WIN reflector. When and if you make a donation, please ask Al to make the list archives SEARCHABLE. 73 - Jim AD1C -- Jim Reisert AD1C/?, <[EMAIL PROTECTED]>, http://www.ad1c.us From [EMAIL PROTECTED] Mon Apr 7 18:47:35 2008 From: [EMAIL PROTECTED] (Mark Lunday, WD4ELG) Date: Mon Apr 7 18:55:33 2008 Subject: [Dx4win] What is the proper LoTW setting for a satellite QSO? Message-ID: <[EMAIL PROTECTED]> My DX4WIN SAT QSO's are giving ERROR messages during the ADIF to TQ8 conversion. What band do I choose for the AO-51 bird with uplink of 144 MHz and downlink of 432 MHz? Thanks Mark Lunday WD4ELG [EMAIL PROTECTED] http://wd4elg.net
