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

Notification

Icon
Error

Mass update by date
N5XZ
#1 Posted : Monday, September 16, 2013 4:01:06 PM(UTC)
Rank: Advanced Member

Groups: Registered, Beta Testers
Posts: 392
Location: Richmond, TX

Thanks: 35 times
Was thanked: 54 time(s) in 51 post(s)
Dennis,

I want to do a mass update of several memberships by date, but I don't see a way to filter by date. What is the procedure?
73, Allen N5XZ
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 : Wednesday, September 18, 2013 12:57:54 PM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,061
Man
Location: Auburn, GA

Thanks: 974 times
Was thanked: 485 time(s) in 400 post(s)
You filter on QSO DATE. Use BETWEEN. Here is a brief step-by-step. Tell me exactly what you want and I can send the exact command:

*click Tools/advanced/database commands.

*type USE LOG

*click DATABASE COMMANDS/MASS CHANGE/REPLACE USER-DEFINED FIELD CONTENTS

*fill out the form. The key to your question is the filter button next to REPLACE ONLY IF. Click it. Scroll down to QSO DATE. Select BETWEEN for the operator, and fill out the ending and starting dates.

73,

DH
N5XZ
#3 Posted : Thursday, September 19, 2013 7:17:31 AM(UTC)
Rank: Advanced Member

Groups: Registered, Beta Testers
Posts: 392
Location: Richmond, TX

Thanks: 35 times
Was thanked: 54 time(s) in 51 post(s)
Yes, what I want to update is 10-10 numbers after a certain date, and FOC numbers on a certain date (the FOC update also relates to another post I made about the FOC numbers not importing from my N1MM ADIF log. Still not sure why that didn't work.)
73, Allen N5XZ
WN4AZY
#4 Posted : Monday, September 23, 2013 8:42:45 AM(UTC)
admin

Rank: Administration

Groups: Administrators, Beta Testers
Posts: 3,061
Man
Location: Auburn, GA

Thanks: 974 times
Was thanked: 485 time(s) in 400 post(s)
Ok, so you want to retroactively fill in 1010 and FOC#s based on their callsign? Forget what I said about tools/database commands

I think what you want is tools/setup/membership lists. Click TOOLS on the menu bar in this form. Wow, I must have been asleep when I did that. Will fix the typos!

To select a date range, click the filter button next to SELECT CRITERIA. Scroll down to QSO DATE. Select BETWEEN for the operator, and fill out the ending and starting dates.


Tnx & 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.027 seconds.