logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

updating user defined ...
w4qnw
#1 Posted : Monday, October 29, 2012 12:24:46 PM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 32
Location: bluffton, sc

Thanks: 2 times
Was thanked: 1 time(s) in 1 post(s)
Hello Dennis

over the years I've kept DOK in the comment section

dok: etc

from my last printed report in 2011 i have made
many additional entries but when trying to print
an updated list all the newest entries do not update
internally.

Of course I do regular data.

I have other small issues re the comment column and
other user defined names but we take one at a time

thanks
sherwin
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
WN4AZY
#2 Posted : Monday, October 29, 2012 2:57:04 PM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 2,669
Man
Location: Auburn, GA

Thanks: 717 times
Was thanked: 407 time(s) in 329 post(s)
Ok, so you want to move data from the comment field to a user-defined field, right? Is there any terminator in the comment field? For example,

DOK:12|

Tnx & 73,

DH
w4qnw
#3 Posted : Friday, November 2, 2012 1:41:21 AM(UTC)
Rank: Advanced Member

Groups: Registered
Posts: 32
Location: bluffton, sc

Thanks: 2 times
Was thanked: 1 time(s) in 1 post(s)
that correct...all sub awards in comment column have termanators

wab: # | wabook: # | grids: # |
jcc: # |

when I try to print out a list they dont update to include new entries
despite many refresh or update... the new entries are all the same format
so dont understand problem

WN4AZY
#4 Posted : Friday, November 2, 2012 10:39:43 AM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 2,669
Man
Location: Auburn, GA

Thanks: 717 times
Was thanked: 407 time(s) in 329 post(s)
The comment field is not used to store user-defined fields! There is a special field for that called UserFields. It is normally not visible directly, but you can see it by opening the Userfields log form. This log form is for diagnostic purposes only. You never type anything directly into the Userfields field. You type into the user-defined field itself. For example, CQZ is a user-defined field. When logging, you use it like any other field. The only difference is how it is stored in the database.

How did the user-defined data get in to Comments? Did you just type them in the comment field directly? I am wondering if we can just copy Comment to Userfields.

73,

DH
WN4AZY
#5 Posted : Friday, November 9, 2012 2:06:33 PM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 2,669
Man
Location: Auburn, GA

Thanks: 717 times
Was thanked: 407 time(s) in 329 post(s)
Thanks for sending me your backup.

As suspected, you do have some DOKs entered as user-defined fields--1517 records to be exact, but you have 2204 records with DOK in the comment field. As we discussed on the phone, LOGic does not track awards on data entered into the comment field. It may be used to mark QSOs whose card has been submitted for an award, but not CQZ, DOK, IOTA, DXCC, etc.

Here is a way to transfer DOKs from the Comment field to Userfields:

Make a backup!

Go to tools/advanced/database commands.

Type

Quote:
USE LOG

REPLACE ALL USERFIELDS WITH TAG_EDIT(USERFIELDS, "DOK:", TAG_VAL("DOK:", COMMENT))


Let me know if any questions.

Tnx for using LOGic.

73,

Dennis WN4AZY
Users browsing this topic
Guest
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.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET
This page was generated in 0.043 seconds.