Thanks for all the ideas. Problem solved and everything merged. Now just the normal getting used to a new program.
HNY es 73 AD6ZJ, Loren --- On Sat, 1/1/11, Loren Hunt <lorenph...@yahoo.com> wrote: > From: Loren Hunt <lorenph...@yahoo.com> > Subject: Re: [Dx4win] Log import problems > To: dx4win@mailman.qth.net, k7...@cox.net > Cc: ad...@arrl.net > Date: Saturday, January 1, 2011, 7:28 AM > 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 > ______________________________________________________________ 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