Page 1 of 1

manually entered a log, now need to adjust times

Posted: 15 Jun 2014, 19:43
by G0JKZ
Hi all.

Just a quick query. I have created a new log and database for a club event today. I entered the times in local rather than utc. I thought that you could enter in the local time and it would show it as -1hr for utc. is there a sql query that I can run in the qso manager that would change the times to utc or do i manually have to edit each qso. there are only 68 of them but it would be great if i could type one line instead of redoing each qso.

George
G0JKZ

Re: manually entered a log, now need to adjust times

Posted: 16 Jun 2014, 09:30
by IW3HMH
Hi George, unfortunately there is not a specific function to update date/time.
Anyway time is saved in HHMMSS format (string)...
i can suggest you that way:

1) export ADIF of required contacts
2) if time is "123000" and should be updated to something else just FIND AND REPLACE:

<TIME_ON:6>12
with
<TIME_ON:6>XX10 (if 10 is the hour that should be set instead of 12)

the double XX will prevent you from updating hour to already existing hours that are not updated yet, mixing your records.

When you have updated the whole log, just replace
<TIME_ON:6>XX10
with
<TIME_ON:6>10

and you will have a patched adif to import back :)

i'm adding this as a possible feature for massive change function