Hello Dennis,

I am still having trouble importing to LOGic 9 from a tab delimited file. The import goes just fine but the data does not appear in the correct fields in LOGic 9.

I have attached the file that I am importing to this message.

My goal is to have the DXCC reports show the countries that I have worked and the packet clusters show the correct countries that I need as new spots are received.

Can you give me exact instructions on how to import the attached file and get the data to go to the correct field?

I might add that I have worked countries by using two different calls. My original call was K7RIE and my current call is W7OO.

I should also add that there are a few QSOs on both 144 and 430 MHz that are NOT satellite QSOs. All satellite QSOs have the satellite identified and the mode it was in.

Here is a list of the fields in the attached file and what they contain:

My Call - The call I was using when the station was worked
Call - The station I worked
Date - The date of the QSO in m/dd/yyyy format
Time - UTC time
Mode - CW SSB
Band - Frequency in two formats xx MHz and the other xx.xxx.xx MHz
Sent - RST Sent
Rcvd - RST Received
Power - TX power (this could be skipped if necessary)
Name - Handle
City - City
State - State
Country - Country spelled out in full
Remarks - Comments
QSL Sent - Y or N or blank
QSL Rcvd - Y or N or blank
QSL Date - Usually the date the QSL was received but can be the date it was sent. This field can be skipped
Satellite - The AMSAT designation for the satellite if it was a satellite QSO.
Mode - The mode the satellite was in for satellite QSOs

Thank you very much for any help you can give me.

Hi Dennis,

Thank you so much for taking the time to answer.

You set me on the path to getting my old logs imported successfully.

I am still having a problem with the frequency. First, I imported to the "freq" field rather than the "band" field. As your reply indicated there are problems in my data. For me it will be much easier to fix it in Excel than it will be to master the database editing commands.

Can you tell me what LOGic expects to see for "freq"? What I'm asking are what are valid entries and what are invalid entries. You will recall I have entries like the following 14, 14.020.10, 435, and 3.5 . LOGic did not import anything when the frequency was in the format of 14.020.10 . That worries me a little since that is the format my 781 exports the data in when it is being controlled by the logging software. I'll worry about that problem when I interface the computer to the rig.

Am I also correct in thinking that LOGic uses the freq in determining your status for awards?

Just in case I get forced into using the database editing commands I have one problem. I had no trouble entering the commands as you suggested.

USE LOG
REPLACE FREQ WITH 0 FOR FREQ=3.5

But then LOGic wants me to select a data base to open. I have no idea what to choose.

I also imported Satellite names to "satname" and the satellite mode to "sat_mode". I notice on the main log entry screen that those two fields do not appear. Is there a solution to that?

Thanks for the help, I really appreciate it.

Bill
W7OO