LOGic Forum
»
LOGic Updates
»
LOGic 9 Updates
»
Report Writer ASCII text file printout
Rank: Advanced Member
Groups: Registered
Posts: 85  Location: Syracuse, Utah Thanks: 21 times
Was thanked: 13 time(s) in 12 post(s)
|
I am trying to print a copy of my log to import into EXCEL. This is a sample of the file I got using, "Reports" > LOG > LOG > and typing GRID then default everything to "Select Order" > CALL. "Run report options--LOG" Output to: ASCII text file selected. (Window titles are in quotes>) What did I do wrong? Problems: fields cutoff, space between some fields missing. My log has over 10,000 records so manually fixing the errors is out of the question. I have managed a few small modification to report files in the past, but I'd rather not attempt to fix this. Does anyone have a LOG.rep file that does not have this problem they are willing to share.
The "Run report options--LOG" Output to: Screen selection does not have this problem but I have not way to create a file from that except Windows PDF which I cannot use.
What would really be nice is to have a .csv file selection in the "Run report options--LOG" window.
Any ideas of other ways to solve this?
5K0N 03/02/2 16:33 1 18.073 CW Will San Andres F 59959 EK92DN
5T5PA 11/12/2 22:07 3 10.136 FT8JohannesNouadhibou -14-1 IL10LW
5T5PA 11/15/2 19:34 1 18.100 FT8JohannesNouadhibou -13-1 IL10LW
5T5PA 01/07/2 00:22 4 7.074 FT8JohannesNouadhibou -11-1 IL10LW
5T5PA 03/19/2 02:26 8 3.573 FT8JohannesNouadhibou -14-1 IL10LW
5V7EI 03/20/2 21:59 2 14.092 RTTEidxg EiDxpedition 59959 JJ06MX
5V7PW 04/28/2 04:25 4 7.009 CW Www.cdxpLome F 59959 JJ06MX
5W1SA 05/21/2 02:48 2 14.076 JT6Atsuo Apia F -08-1 AH46DD
5W1SA 12/22/2 06:08 3 10.137 FT8Atsuo Qsl To -07-1 AH46CC
5W1SA 12/25/2 20:00 1 18.101 FT8Atsuo Qsl To -21-1 AH46CC
5Z4/G3A04/12/2 23:38 2 14.076 FT8Andy -15-1
5Z4/G3A04/19/2 18:46 1 18.102 FT8Andy -13-2 KI88JR
5Z4/G3A05/04/2 22:14 2 14.082 FT4Andy -01-0 KI88JR
6Y0BE 11/28/2 00:38 4 7.024 CW Boyan Montego Bay 59959 FK08XK
6Y0D 11/23/2 16:16 2 14.012 CW Yasar Pasaport 59959 KM38JQ
6Y0HM 19:15 1 21.010 CW Andy Walford 59959 FK08XK
6Y0W 11/27/2 22:53 2 14.016 CW Enchev, Hopewell 59959 FK18HC
6Y3M 11/22/2 23:49 4 7.026 CW Lali 59959 FK18HC
|
|
|
|
|
|
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
|
|
|
Rank: Advanced Member
Groups: Registered
Posts: 524
Location: Mentor, OH
Thanks: 123 times
Was thanked: 185 time(s) in 166 post(s)
|
Hi Dave,
LOGic has a much easier way to export to Excel. Go to Tools\Export Log Data then select "ADIF,XML,xBASE,ASCII and other generic formats". The next window will be where you can filter what you want to output from the log or just click on "ok" to take it all. Once "ok" is clicked Windows File Explorer will launch and you can navigate to where you want the file saved....THEN...at the bottom of that screen where it says "Save as type:" click on the arrow at the far right and then select "Microsoft Excel (XLS)". The excel file will be created and be formatted with column headers....Nice !!
I export to excel all the time. I use Excel's Map feature and fill maps of the US by band to illustrate WAS status. It a beautiful thing !!
If any questions or if you need some screen shots just yell !!
Be safe...
73 de Brad, N8GLS
|
|
2 users thanked K8ZM for this useful post.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Posts: 85 Location: Syracuse, Utah Thanks: 21 times
Was thanked: 13 time(s) in 12 post(s)
|
Of course. Got focused on the wrong solution.
Thanks.
By the way there is a free ADIF to CSV converter that has worked for me. There is also CSV to ADIF converter but I've not used it yet.
|
|
1 user thanked K7PDW for this useful post.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Posts: 180 Location: Daytona Beach, Florida Thanks: 48 times
Was thanked: 67 time(s) in 62 post(s)
|
If Brad's solution does not produce the format you want, there's a more dangerous way to do it.
Go to Tools -> Advanced -> Database commands. Enter the following commands:
use log
copy to mylog.txt delimited
use
exit
This will produce a comma-delimited file of all records in you log. It's placed in the LOGic folder. You can import in Excel and massage to your hearts content.
73s, Don
|
|
2 users thanked w2zi for this useful post.
|
|
|
|
Rank: Advanced Member
Groups: Registered
Posts: 85 Location: Syracuse, Utah Thanks: 21 times
Was thanked: 13 time(s) in 12 post(s)
|
Thanks Don. That sounds like it may get me directly to where I want to be. I'll try it after running a backup.
|
|
|
|
|
|
LOGic Forum
»
LOGic Updates
»
LOGic 9 Updates
»
Report Writer ASCII text file printout
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
