[Dx4win] Log import problems

[Loren Hunt]

Alan,
You gave me a good clue and I had to try it. It is interesting that there are many date formats in Excel and many in DX4WIN, but only a few that they both have. I formatted the date to force MM/DD/YY to be 2 digits per field. The log imported.

Next step - How do I merge 2 logs together? This should be easy compared to what I just went through on the missing dates.

73
AD6ZJ, Loren

--- On Fri, 12/31/10, ALAN ZACK <k7acz at cox.net> wrote:

> From: ALAN ZACK <k7acz at cox.net>
> Subject: Re: [Dx4win] Log import problems
> To: dx4win at mailman.qth.net
> Cc: ad6zj at arrl.net
> Date: Friday, December 31, 2010, 7:16 PM
> I don't have a solution to your
> problem but I see Jim AD1C replied and if he
> can't figure it out no one can.
> But I do have a question for you concerning Excel. At times
> I download a
> DX4WIN report, such as DXCC or IOTA, to an Excel
> spreadsheet by right
> clicking on the report and clicking "WRITE TO FILE". This
> works FB for me
> except how do you get leading zeros to appear in the time
> column. Example, I
> worked someone at 0005 GMT but only a 5 shows up, 0045 GMT
> becomes 45 and
> 0655 becomes 655. If there are four digits in the time such
> as 1745 GMT then
> the 1745 shows up FB. I am using Office 2007 ver. of MS
> Excel. If I remember
> right I could easily add leading zeros OK when I used
> Office ver. 2003 but
> can't figure it out for ver. 2007.
> I have a suspicion that maybe the way some of your dates
> are seen by Excel
> may be your problem. Also be sure you don't need to
> lengthen the width of
> the date column on the Excel spreadsheet. If it is not wide
> enough you will
> see #### instead of the date. You might stretch it open so
> the date will
> fully fit in the column but when you close Excel maybe it
> doesn't save the
> change?  Good luck!
> 
> TIA, 73 & HNY
> Alan, K7ACZ
> 
> -----Original Message-----
> From: dx4win-bounces at mailman.qth.net
> [mailto:dx4win-bounces at mailman.qth.net]
> On Behalf Of Loren Hunt
> Sent: Friday, December 31, 2010 5:27 PM
> To: dx4win at mailman.qth.net
> Cc: ad6zj at arrl.net
> Subject: [Dx4win] Log import problems
> 
> Hello,
> I am new to DX4win and am trying to import a large chunk of
> my logs that are
> in an excel spreadsheet format. I followed all the steps
> for the filter and
> it took all 13,000 + QSOs but about 830 of them had a blank
> date field. I
> cannot see anything different about the date for those
> fields. 
> 
> I also tried first converting the logs to ADIF but have
> been unsuccessful in
> my attempts at formula manipulation. A few examples on the
> web proved
> frustrating as they expected custom macros.
> 
>  Any ideas?
> 
> Thanks,
> AD6ZJ, Loren
> 
> ______________________________________________________________
> Dx4win mailing list
> Home: http://mailman.qth.net/mailman/listinfo/dx4win
> Help: http://mailman.qth.net/mmfaq.htm
> Post: mailto:Dx4win at mailman.qth.net
> 
> This list hosted by: http://www.qsl.net
> Please help support this email list: http://www.qsl.net/donate.html
>