Re: [Dx4win] Log import problems
Dave and et all, Thanks to all who had suggestions on how to add leading zeros to DX4WIN log exports to Excel. Excel HELP and all logic dictates using the custom format of should do it. But I think there is a problem as DX4WIN places a colon (:) between the hours and minutes of the QSO time block so instead of 0019 it is 00:19 and Excel doesn't know how to handle it. But Loren AD6ZJ came up with the solution as follows: 1) select column C (my column showing QSO time) 2) right click and select: Format Cells 3) under Category select custom 4) You should see h:mm;@ in the text box 5) Add an h in the front of the string so it looks like hh:mm;@ 6) Click OK Done. This worked FB and converted all my times to a four digit time with leading zeros where they were needed. 73 -Original Message- From: ALAN ZACK [mailto:k7...@cox.net] Sent: Sunday, January 02, 2011 5:25 PM To: 'Dave Sharred'; dx4win@mailman.qth.net Subject: RE: [Dx4win] Log import problems Thanks Dave, Yes, that SHOULD work. That is what the HELP file tells me to do also. But what happens it just changes all the times to . I think the way the time is downloaded from DX4WIN to excel may be the problem. It is downloaded with a colon : such as 02:50. In the fx box it is shown as 2:50:00 AM. DX4WIN logs the contacts time using a colon such as 22:56 and I don't see any way to change that. You can re-format how the date is arranged but not the time. I have attached my CQWWDXCW log in Excel workbook mode if you like a puzzle. It is really no big deal, don't waste any time trying to figure it out, but if you are curious of what I mean here it is. Tnxs for the help and HNY Alan, K7ACZ -Original Message- From: Dave Sharred [mailto:g3...@yahoo.co.uk] Sent: Saturday, January 01, 2011 1:04 AM To: k7...@cox.net; dx4win@mailman.qth.net Subject: RE: [Dx4win] Log import problems Your question is an easy one to answer Alan: In Excel, Highlight the column you are interested in. Do a RH Mouseclick on the column, select Format Cells Select Custom ; you will see General showing as selected in the first item on the list Just over type this with ; and the job is done ! 73 es HNY Dave G3NKC -Original Message- From: dx4win-boun...@mailman.qth.net [mailto:dx4win-boun...@mailman.qth.net] On Behalf Of ALAN ZACK Sent: 01 January 2011 03:16 To: dx4win@mailman.qth.net Cc: ad...@arrl.net Subject: Re: [Dx4win] Log import problems At times I download a DX4WIN generated log report, such as a contest, to an Excel spreadsheet. 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. TIA, 73 HNY Alan, K7ACZ __ 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
Re: [Dx4win] Log import problems
Your question is an easy one to answer Alan: In Excel, Highlight the column you are interested in. Do a RH Mouseclick on the column, select Format Cells Select Custom ; you will see General showing as selected in the first item on the list Just over type this with ; and the job is done ! 73 es HNY Dave G3NKC -Original Message- From: dx4win-boun...@mailman.qth.net [mailto:dx4win-boun...@mailman.qth.net] On Behalf Of ALAN ZACK Sent: 01 January 2011 03:16 To: dx4win@mailman.qth.net Cc: ad...@arrl.net Subject: Re: [Dx4win] Log import problems 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
Re: [Dx4win] Log import problems
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
Re: [Dx4win] Log import problems - solved
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
Re: [Dx4win] Log import problems
On Fri, Dec 31, 2010 at 6:27 PM, Loren Hunt ad...@sbcglobal.net wrote: 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. Hi Loren, Send me the spreadsheet and tell me exactly what steps you did to import it. If I can't figure out the problem, I'll convert the spreadsheet to ADIF then try importing that. - Jim -- Jim Reisert AD1C, jjreis...@alum.mit.edu, http://www.ad1c.us __ 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
Re: [Dx4win] Log import problems
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