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

Notification

Icon
Error
How fill a field in the form automatically by an inserted specific call
Options View
Previous Topic Next Topic
IK0CHU
#1 Posted : Wednesday, March 1, 2017 6:00:11 PM(UTC)
RedBaron

Rank: Advanced Member

Groups: Registered
Posts: 365
Man
Location: Viterbo, VT - ITALY

Thanks: 57 times
Was thanked: 85 time(s) in 79 post(s)

Hello Dennis,
I created a new logform for Italian award (ARI 90yeas).
Can I put in the prefix table 103 separate HQ Stations names and assign each a SASC90 value (ex. SASC90:R20ARI2)?
This value must automatically fill the SASC90 field, created in the logform for this award, when I insert one of 103 HQ callsign. Thank you
73's de IKØCHU Mauro
***
IKØCHU Mauro
Back to top
Sponsor
Note: We receive a commission from Amazon when you purchase via this link. It does not affect your cost. Thank you!
Back to top  
WN4AZY
#2 Posted : Monday, March 6, 2017 5:21:02 PM(UTC)
admin

Rank: Administration

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

Thanks: 998 times
Was thanked: 497 time(s) in 412 post(s)
Hi Mauro:

Is there a one-to-one relationship between HQ stations and SASC90 values? If so, I recommend using the Memberships feature. Let me know and I will get back to you promptly and advise on how to proceed. If they are on a web page somewhere, they can probably be imported.

It COULD be done using the prefix table. That is how VE PROV is logged for instance. But this sounds more like a memberships thing.

Tnx & 73,

Dennis WN4AZY
Back to top
WWW
IK0CHU
#3 Posted : Tuesday, March 7, 2017 7:17:36 PM(UTC)
RedBaron

Rank: Advanced Member

Groups: Registered
Posts: 365
Man
Location: Viterbo, VT - ITALY

Thanks: 57 times
Was thanked: 85 time(s) in 79 post(s)
Hi Dennis,
in the Ninenty Years ARI award there is a relationship between HQ and SASC values. Every HQ station has a different code.
I'm sorry but i dont know how to use the Memberships features.
This is what i have done:
I have the entire HQ list in excel and make also the database file to import in the list of valid value as SASC90.
I tried to insert in the prefix table some of the HQ station calls and add in the comment the string as SASC90:R90ARI2|.
Logging that calls the SASC90 field in the logform is filled ok, but to insert all the calls is a very heavy work.
If necessary i will do. Can i import data by ascii or excel file into prefix table database?
You told me Memberships features as recommended option. I would like to know what i can do with memberships function.
Can you help me? You need my SASC90 dbf? Let me know.
Thanks & 73's

IKØCHU Mauro
***
IKØCHU Mauro
Back to top
WN4AZY
#4 Posted : Thursday, March 9, 2017 9:42:31 AM(UTC)
admin

Rank: Administration

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

Thanks: 998 times
Was thanked: 497 time(s) in 412 post(s)
You can import Excel into memberships, not the prefix table. The memberships is much simpler. Send me the excel file (attach here preferably) and I will import it into the memberships table and advise on how to use it.

Tnx & 73,

Dennis WN4AZY
Back to top
WWW
IK0CHU
#5 Posted : Thursday, March 9, 2017 11:02:51 AM(UTC)
RedBaron

Rank: Advanced Member

Groups: Registered
Posts: 365
Man
Location: Viterbo, VT - ITALY

Thanks: 57 times
Was thanked: 85 time(s) in 79 post(s)
Hi Dennis,
thanks for replay and help.
Yes here attached the excel file where the HQ stations and relative SASC code are listed for the Regions operating the Award in the March 2017 (begin date).
Every month there are two italian regions for total 20 and the end will be on December 2017.
In the next month i have to edit the new excel file to import in the memberships list.
Let me know the procedure to make, in the future, a fine job to import this data and i will delete all the mods make in the prefix table inserting one by one the HQ call stations.
Thanks in advance Dennis.
73's de IKØCHU Mauro
***
File Attachment(s):
SASC90.xls (47kb) downloaded 2 time(s).

You cannot view/download attachments. Try to login or register.
IKØCHU Mauro
Back to top
WN4AZY
#6 Posted : Wednesday, March 15, 2017 5:27:26 PM(UTC)
admin

Rank: Administration

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

Thanks: 998 times
Was thanked: 497 time(s) in 412 post(s)
Ok, sorry so long. Here it is. Go to tools/setup/memberships. Click IMPORT. Select the file you downloaded: SASC90.DBF.

GO to tools/setup/log fields. Locate your SASC90 field. Go to the MEMBERSHIPS tab. Checkmark where it says MEMBERSHIP. Click ALWAYS COPY.

Let me know if any questions.

Thank you for preparing this data.

73,

Dennis WN4AZY
File Attachment(s):
SASC90.DBF (25kb) downloaded 1 time(s).

You cannot view/download attachments. Try to login or register.
Back to top
WWW
1 user thanked WN4AZY for this useful post.
IK0CHU on 3/16/2017(UTC)
Users browsing this topic
Guest (2)
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.030 seconds.