Log Management

[MM0ZIF]

Before I start, I've only started with Log4OM today.

I haven't found out how to do it so I presume there isn't a way of doing it so I will ask away, If there is please someone share how with me.

I stupidly imported my ADIF twice, so now I have two entries for every QSO, to manually sort them is going to take forever, so how can I bulk highlight and edit. Would a highlight QSO's and delete be an option.

Also in Layouts how do I get the QSO number from the database, I can't see an option for this. I am using mySQL so it should be possible as I presume the Primary key will be a QSO number (or int +1) for each record created.

Also what about Sync from HRDLog or other online log (QRZCQ)

Other than these few things, I will be using Log4OM for day to day logging, I am even going to try using it for contesting... (alongside N1MM in case of issues)

[IW3HMH]

Before I start, I've only started with Log4OM today.

So, welcome aboard

I haven't found out how to do it so I presume there isn't a way of doing it so I will ask away, If there is please someone share how with me.
I stupidly imported my ADIF twice, so now I have two entries for every QSO, to manually sort them is going to take forever, so how can I bulk highlight and edit. Would a highlight QSO's and delete be an option.

Well, Log4OM doesn't allow you to load duplicates. It's "impossible", because it's a contraint at database level
Duplicate means: same CALL, BAND, MODE, DATE, TIME
so if you have dupes it's probably something that came from your previous log AND between 2 "almost equal QSO" there should be a small difference (as example, time. In some cases dupes are between QSO with and without seconds, where seconds will be filled with 00 if missing)
Please check your ADIF and let me know about this.

Also in Layouts how do I get the QSO number from the database, I can't see an option for this. I am using mySQL so it should be possible as I presume the Primary key will be a QSO number (or int +1) for each record created.

There is an internal timestamp of the QSO save date/time, for indexing purposes, but QSO are not numbered progressively in database, because you can even load an ADIF in the middle of 2 logged periods. Field is QsoId

Also what about Sync from HRDLog or other online log (QRZCQ)

We're synced with HRDLOG, QRZ.COM, HAMQTH, CLUBLOG, LOTW and EQSL. We didn't have had requests for QRZCQ until now...
i'll check for their upload system...

Other than these few things, I will be using Log4OM for day to day logging, I am even going to try using it for contesting... (alongside N1MM in case of issues)

We're not "highly specialized" on contesting and contest statistics, even if we support contest management. I hope you will find Log4OM good for your needs

73
Daniele

[MM0ZIF]

Many thanks for your prompt response, I will look properly into this in the morning.

However the original ADIF only contains one copy of each log but the import has 2... So not sure if I've stumbled upon a glitch or whatever. But thats what has happened. I've manually removed the dupes now so thats not an issue.

[IW3HMH]

As an academic interest, can you send me at lele (at) pisto (dot) it your original ADIF?

[MM0ZIF]

I would love to but once I cleaned it out, I overwrote it... I am now using SQL server with log and its no problems at all

[G0PVW]

Can you explain how you set up SQL Server with log4om, please?

[VK7XX]

Can you explain how you set up SQL Server with log4om, please?

This may, or may not be of use to you Ron..... Several years ago I wrote a "how to" for setting up HRD's logbook on an SQL server. I would imagine that the steps are similar BUT, I have not done this myself.. My log runs quite happily in SQLlite.

If you wish to look at this old document, it is ZIPped, and can be downloaded by clicking here ---> http://www.hamradioaustralia.net/files/ ... _setup.zip

regards
John

[G4POP]

Can you explain how you set up SQL Server with log4om, please?

Pages 174 to 187 of our user guide covers this in detail

But why do you want a MYSQL server?