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 <k7...@cox.net> wrote: > From: ALAN ZACK <k7...@cox.net> > Subject: Re: [Dx4win] Log import problems > To: dx4win@mailman.qth.net > Cc: ad...@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-boun...@mailman.qth.net > [mailto:dx4win-boun...@mailman.qth.net] > On Behalf Of Loren Hunt > Sent: Friday, December 31, 2010 5:27 PM > To: dx4win@mailman.qth.net > Cc: ad...@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@mailman.qth.net > > This list hosted by: http://www.qsl.net > Please help support this email list: http://www.qsl.net/donate.html > ______________________________________________________________ Dx4win mailing list Home: http://mailman.qth.net/mailman/listinfo/dx4win Help: http://mailman.qth.net/mmfaq.htm Post: mailto:Dx4win@mailman.qth.net This list hosted by: http://www.qsl.net Please help support this email list: http://www.qsl.net/donate.html
