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

Notification

Icon
Error

NPOTA Awards list
wa4pgm
#1 Posted : Monday, January 18, 2016 3:53:16 PM(UTC)
kchavis

Rank: Advanced Member

Groups: Administrators, Registered, Beta Testers
Posts: 370
Man
Location: Farmville, VA

Thanks: 36 times
Was thanked: 225 time(s) in 194 post(s)
I imported my NPOTA list into LOGic's Awards list but the description of each value isn't shown.

My import file looks like this:

HP01 Abraham Lincoln Birthplace
NP01 Acadia
HP02 Adams
MN01 African Burial Ground

etc.....

I'm missing something but haven't been able to find the solution searching the forum. The import works but I would like to add the description.
Thanks,
Kyle
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, January 18, 2016 9:38:31 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 Kyle:

Does the file have tabs separating the NPOTA# and the description? LOGic's generic importer won't import just a straight fixed- column text file. It is a pretty simple matter to open the text file in Excel or OpenOffice or Libre Office, and save as tab-delimited. It also does comma-delimited text files.

You also need column headers:
http://www.hosenose.com/...and-fixes.aspx#post4116

Post your file here and I can better advise.

Tnx & 73,

Dennis WN4aZY
wa4pgm
#3 Posted : Monday, January 18, 2016 9:49:43 PM(UTC)
kchavis

Rank: Advanced Member

Groups: Administrators, Registered, Beta Testers
Posts: 370
Man
Location: Farmville, VA

Thanks: 36 times
Was thanked: 225 time(s) in 194 post(s)
Here is the file I used. Created with Excel and saved as Tab-delimited well that's what I attempted.



HP01 Abraham Lincoln Birthplace
NP01 Acadia
HP02 Adams
MN01 African Burial Ground
MN02 Agate Fossil Beds
TR18 Ala Kahakai National Historic Trail
WR01 Alagnak Wild River
WR11 Alatna Wild River
AA01 Aleutian World War II National Historic Area
MN03 Alibates Flint Quarries
NS01 Allegheny Portage Railroad
AA02 American Memorial Park
RC01 Amistad
NS02 Andersonville
NS03 Andrew Johnson
WR12 Aniachak Wild River
MN04 Aniakchak National Monument
PV01 Aniakchak National Preserve
BF01 Antietam
LK01 Apostle Islands
TR01 Appalachian National Scenic Trail
HP03 Appomattox Court House
NP02 Arches
NM01 Arkansas Post
NM02 Arlington House
SS01 Assateague Island
MN05 Aztec Ruins
NP03 Badlands
MN06 Bandelier
AA03 Benjamin Franklin National Memorial
HP16 Benjamin Franklin National Memorial
NS04 Bent's Old Fort
PV02 Bering Land Bridge
NP04 Big Bend
PV03 Big Cypress
BF02 Big Hole
RV01 Big South Fork National River and Recreation Area
PV04 Big Thicket
RC02 Bighorn Canyon
NP05 Biscayne
NP06 Black Canyon of the Gunnison
HP49 Blackstone River Valley
PK01 Blue Ridge Parkway
WR02 Bluestone National Scenic River
MN07 Booker T. Washington
HP04 Boston
NS05 Boston African American
RC03 Boston Harbor Islands
BS01 Brices Cross Roads
NS06 Brown v. Board of Education
NP07 Bryce Canyon
MN08 Buck Island Reef
RV02 Buffalo National River
MN09 Cabrillo
TR14 California National Historic Trail
SS02 Canaveral
HP05 Cane River Creole NHP and Heritage Area
MN10 Canyon de Chelly
NP08 Canyonlands
SS03 Cape Cod
SS04 Cape Hatteras
MN11 Cape Krusenstern
SS05 Cape Lookout
NP09 Capitol Reef
TR21 Captain John Smith Chesapeake National Historic Trail
MN12 Capulin Volcano
NS07 Carl Sandburg Home
NP10 Carlsbad Caverns
NS08 Carter G. Woodson Home
MN13 Casa Grande Ruins
MN14 Castillo de San Marcos
MN15 Castle Clinton
DZ01 Catoctin Mountain Park
MN16 Cedar Breaks
HP06 Cedar Creek and Belle Grove
MN17 Cesar E. Chavez
HP07 Chaco Culture
NM03 Chamizal
NP11 Channel Islands
NS09 Charles Pinckney
MN18 Charles Young Buffalo Soldiers
WR13 Charley Wild River
RC04 Chattahoochee River
HP08 Chesapeake and Ohio Canal
AA04 Chicago Portage National Historic Site
MP01 Chickamauga and Chattanooga
RC05 Chickasaw
WR14 Chilikadrotna Wild River
AA05 Chimney Rock National Historic Site
MN19 Chiricahua
NS10 Christiansted
RS01 City of Rocks
NS11 Clara Barton
HP09 Colonial
MN20 Colorado
NP12 Congaree
DZ02 Constitution Gardens
DZ06 Constitution Gardens
NM04 Coronado
BF03 Cowpens
NP13 Crater Lake
MN21 Craters of the Moon National Monument and Preserve
PV05 Craters of the Moon National Monument and Preserve
HP10 Cumberland Gap
SS06 Cumberland Island
RC06 Curecanti
NP14 Cuyahoga Valley
HP11 Dayton Aviation Heritage
NM05 De Soto
NP15 Death Valley
WR03 Delaware National Scenic River
RC07 Delaware Water Gap
NP16 Denali National Park
PV06 Denali Preserve
MN22 Devils Postpile
MN23 Devils Tower
MN24 Dinosaur
NP17 Dry Tortugas
RS02 Ebey's Landing National Historical Reserve
NS12 Edgar Allan Poe
MN25 Effigy Mounds
WR15 Eightmile National Wild and Scenic River
NS13 Eisenhower
TR20 El Camino Real de los Tejas National Historic Trail
TR17 El Camino Real de Tierra Adentro National Historic Trail
MN26 El Malpais
MN27 El Morro
NS14 Eleanor Roosevelt
NS15 Eugene O'Neill
NP18 Everglades
AA06 Fallen Timbers Battlefield and Fort Miamis National Historic Site
WR16 Farmington National Wild and Scenic River
AA07 Father Marquette National Memorial
NM06 Federal Hall
SS07 Fire Island
NS16 First Ladies
HP12 First State
WR17 Flathead Wild and Scenic River
NM07 Flight 93
MN28 Florissant Fossil Beds
NS17 Ford's Theatre
NS18 Fort Bowie
NM08 Fort Caroline
NS19 Fort Davis
BF04 Fort Donelson
MN29 Fort Frederica
NS20 Fort Laramie
NS21 Fort Larned
MN30 Fort Matanzas
MN31 Fort McHenry NM and Historic Shrine
MN32 Fort Monroe
BF05 Fort Necessity
NS22 Fort Point
MN33 Fort Pulaski
NS23 Fort Raleigh
NS24 Fort Scott
NS25 Fort Smith
MN34 Fort Stanwix
MN35 Fort Sumter
MN36 Fort Union
NS26 Fort Union Trading Post
NS27 Fort Vancouver
DZ03 Fort Washington Park
MN37 Fossil Butte
NM09 Franklin Delano Roosevelt Memorial
DZ06 Franklin Delano Roosevelt Memorial
NS28 Frederick Douglass
NS29 Frederick Law Olmsted
MP02 Fredericksburg and Spotsylvania County Battlefields Memorial
NS30 Friendship Hill
NP19 Gates of the Arctic National Park
PV07 Gates of the Arctic Preserve
RC08 Gateway
RC09 Gauley River
NM10 General Grant
HP13 George Rogers Clark
MN38 George Washington Birthplace
MN39 George Washington Carver
PK02 George Washington Memorial Parkway
MP03 Gettysburg
MN40 Gila Cliff Dwellings
NP20 Glacier Bay National Park
PV08 Glacier Bay National Preserve
NP21 Glacier National Park
RC10 Glen Canyon
AA08 Gloria Dei (Old Swedes') Church National Historic Site
RC11 Golden Gate
NS31 Golden Spike
MN41 Governors Island
NP22 Grand Canyon
MN42 Grand Portage
NP23 Grand Teton
NS32 Grant-Kohrs Ranch
NP24 Great Basin
WR04 Great Egg Harbor National Scenic and Recreational River
PV09 Great Sand Dunes
NP25 Great Sand Dunes NP and Preserve
NP26 Great Smoky Mountains
AA09 Green Springs National Historic Landmark District
DZ04 Greenbelt Park
NP27 Guadalupe Mountains
MP04 Guilford Courthouse
SS08 Gulf Islands
MN43 Hagerman Fossil Beds
NP28 Haleakal?
NM11 Hamilton Grange
NS33 Hampton
HP14 Harpers Ferry
MN44 Harriet Tubman Underground Railroad
NS34 Harry S Truman
NP29 Hawaii Volcanoes
NS35 Herbert Hoover
AA10 Historic Camden Revolutionary War Site
MN45 Hohokam Pima
NS36 Home of Franklin D. Roosevelt
MN46 Homestead NM of America
MN79 Honouliuli National Monument
HP15 Hopewell Culture
NS37 Hopewell Furnace
MP05 Horseshoe Bend
NP30 Hot Springs
MN47 Hovenweep
NS38 Hubbell Trading Post
TR05 Ice Age National Scenic Trail
AA11 Ice Age National Scientific Reserve
HP16 Independence
LK02 Indiana Dunes
AA12 International Peace Garden
AA13 Inupiat Heritage Center
NP31 Isle Royale
NS39 James A. Garfield
AA14 Jamestown National Historic Site
HP17 Jean Lafitte NHP and Preserve
NM12 Jefferson National Expansion Memorial
MN48 Jewel Cave
NS40 Jimmy Carter
PK03 John D. Rockefeller, Jr. Memorial Parkway
MN49 John Day Fossil Beds
NS41 John Fitzgerald Kennedy
NS42 John Muir
WR18 John Wild River
NM14 Johnstown Flood
NP32 Joshua Tree
TR13 Juan Bautista de Anza National Historic Trail
HP18 Kalaupapa
HP19 Kaloko-Honokohau
AA15 Kate Mullany National Historic Site
NP33 Katmai National Park
PV10 Katmai National Preserve
NP34 Kenai Fjords
BP01 Kennesaw Mountain
WR19 Kern River
HP20 Keweenaw
NP35 Kings Canyon
MP06 Kings Mountain
WR20 Kings River
HP21 Klondike Gold Rush
HP22 Klondike Gold Rush - Seattle Unit
NS43 Knife River Indian Villages
NP36 Kobuk Valley
WR21 Kobuk Wild River
DZ06 Korean War Veterans
NM13 Korean War Veterans
WR22 Koyukuk Wild River (North Fork)
RC12 Lake Chelan
NP37 Lake Clark National Park
PV11 Lake Clark National Preserve
RC13 Lake Mead
RC14 Lake Meredith
RC15 Lake Roosevelt (formerly Coulee Dam)
WR23 Lamprey Wild and Scenic River
NP38 Lassen Volcanic
MN50 Lava Beds
HP23 Lewis and Clark
TR09 Lewis and Clark National Historic Trail
NM15 Lincoln Boyhood
NS44 Lincoln Home
NM16 Lincoln Memorial
MN51 Little Bighorn Battlefield
PV12 Little River Canyon
NS45 Little Rock Central High School
NS46 Longfellow House - Washington's Headquarters
HP24 Lowell
AA16 Lower East Side Tenement National Historic Site
HP25 Lyndon B. Johnson
NM17 Lyndon Baines Johnson Memorial Grove on the Potomac
NS47 Maggie L. Walker
NP39 Mammoth Cave
BP02 Manassas
HP50 Manhattan Project
NS48 Manzanar
HP26 Marsh-Billings-Rockefeller
NS49 Martin Luther King, Jr.
NM18 Martin Luther King, Jr. National Memorial
DZ06 Martin Luther King, Jr. National Memorial
NS50 Martin Van Buren
NS51 Mary McLeod Bethune Council House
WR24 Maurice Scenic and Recreational River
WR25 Merced River
NP40 Mesa Verde
NS52 Minidoka
HP27 Minute Man
NS53 Minuteman Missile
WR26 Missisquoi and Trout Wild and Scenic River
RV04 Mississippi National River and Recreation Areas
WR05 Missouri National Recreational River
PV13 Mojave
BF06 Monocacy
MN52 Montezuma Castle
BF07 Moores Creek
TR08 Mormon Pioneer National Historic Trail
HP28 Morristown
NP41 Mount Rainier
NM19 Mount Rushmore
MN53 Muir Woods
WR27 Mulchatna Wild River
WR28 Musconetcong National Wild and Scenic River
HP29 Natchez
TR02 Natchez Trace National Scenic Trail
PK04 Natchez Trace Parkway
DZ05 National Capital Parks
DZ06 National Mall
NP42 National Park of American Samoa
MN54 Natural Bridges
MN55 Navajo
HP30 New Bedford Whaling
TR06 New England National Scenic Trail
AA17 New Jersey Coastal Heritage Trail Route
HP31 New Orleans Jazz
RV03 New River Gorge National River
HP32 Nez Perce
NS54 Nicodemus
NS55 Ninety Six
WR06 Niobrara National Scenic River
PV14 Noatak
WR29 Noatak Wild River
NP43 North Cascades
TR04 North Country National Scenic Trail
WR07 Obed Wild and Scenic River
MN56 Ocmulgee
AA18 Oklahoma City National Memorial
TR19 Old Spanish National Historic Trail
NP44 Olympic
MN57 Oregon Caves
TR07 Oregon National Historic Trail
MN58 Organ Pipe Cactus
TR10 Overmountain Victory National Historic Trail
RV05 Ozark National Scenic Riverways
SS09 Padre Island
HP33 Palo Alto Battlefield
HP34 Paterson Great Falls
MP07 Pea Ridge
HP35 Pecos
NS56 Pennsylvania Avenue
NM20 Perry's Victory and International Peace Memorial
BF08 Petersburg
NP45 Petrified Forest
MN59 Petroglyph
LK03 Pictured Rocks
AA19 Pinelands National Reserve
NP46 Pinnacles
MN60 Pipe Spring
MN61 Pipestone
DZ07 Piscataway Park
SS10 Point Reyes
TR15 Pony Express National Historic Trail
NM21 Port Chicago Naval Magazine National Memorial
TR03 Potomac Heritage National Scenic Trail
MN62 Poverty Point
NS57 President William Jefferson Clinton Birthplace Home
DZ08 Prince William Forest Park
HP36 Pu'uhonua o H?naunau
MN78 Pullman National Monument
NS58 Puukohol? Heiau
MN63 Rainbow Bridge
AA20 Red Hill Patrick Henry National Memorial
NP47 Redwood
BP03 Richmond
WR08 Rio Grande Wild and Scenic River
BP04 River Raisin
DZ09 Rock Creek Park
NP48 Rocky Mountain
NM22 Roger Williams
AA21 Roosevelt Campobello International Park
HP37 Rosie the Riveter/World War II Home Front
RC16 Ross Lake
MN64 Russell Cave
NS59 Sagamore Hill
NP49 Saguaro
HS01 Saint Croix Island
WR09 Saint Croix National Scenic Riverway
NS61 Saint Paul's Church
NS60 Saint-Gaudens
NS62 Salem Maritime
MN65 Salinas Pueblo Missions
WR30 Salmon Wild River
HP38 Salt River Bay NHP and Ecological Preserve
HP39 San Antonio Missions
HP40 San Francisco Maritime
NS63 San Juan
HP41 San Juan Island
NS64 Sand Creek Massacre
TR11 Santa Fe National Historic Trail
RC17 Santa Monica Mountains
HP42 Saratoga
NS65 Saugus Iron Works
MN66 Scotts Bluff
TR16 Selma to Montgomery National Historic Trail
NP50 Sequoia
AA22 Sewall-Belmont House National Historic Site
NP51 Shenandoah
MP08 Shiloh
HP43 Sitka
LK04 Sleeping Bear Dunes
NS66 Springfield Armory
TR22 Star-Spangled Banner National Historic Trail
MN67 Statue of Liberty
NS67 Steamtown
BF09 Stones River
WR31 Sudbury, Assabet and Concord National Wild and Scenic River
MN68 Sunset Crater Volcano
PV15 Tallgrass Prairie
WR32 Taunton National Wild and Scenic River
NM23 Thaddeus Kosciuszko
NP52 Theodore Roosevelt
NS68 Theodore Roosevelt Birthplace
NS69 Theodore Roosevelt Inaugural
NM24 Theodore Roosevelt Island
AA23 Thomas Cole National Historic Site
HP44 Thomas Edison
NM25 Thomas Jefferson Memorial
DZ06 Thomas Jefferson Memorial
NS70 Thomas Stone
MN69 Timpanogos Cave
PV16 Timucuan Ecological and Historic
WR33 Tinayguk Wild River
WR34 Tlikakila Wild River
MN70 Tonto
WR35 Toulumne River
AA24 Touro Synagogue National Historic Site
TR12 Trail of Tears National Historic Trail
MN80 Tule Springs Fossil Beds
HP45 Tumacacori
BF10 Tupelo
NS71 Tuskegee Airmen
NS72 Tuskegee Institute
MN71 Tuzigoot
NS73 Ulysses S. Grant
WR10 Upper Delaware Scenic and Recreation River
PV19 Valles Caldera
HP46 Valley Forge
NS74 Vanderbilt Mansion
MP09 Vicksburg
NM26 Vietnam Veterans Memorial
DZ06 Vietnam Veterans Memorial
NP53 Virgin Islands
MN72 Virgin Islands Coral Reef
WR36 Virgin Wild and Scenic River
NP54 Voyageurs
MN81 Waco Mammoth
MN73 Walnut Canyon
HP47 War in the Pacific
TR23 Washington - Rochambeau Revolutionary Route National Historic Trail
NM27 Washington Monument
DZ06 Washington Monument
NS75 Washita Battlefield
NS76 Weir Farm
WR37 Wekiva National Wild and Scenic River
WR38 Westfield National Wild and Scenic River
RC18 Whiskeytown Unit
WR39 White Clay Creek National Wild and Scenic River
DZ10 White House
MN74 White Sands
NS77 Whitman Mission
NS78 William Howard Taft
BF11 Wilson's Creek
NP55 Wind Cave
AA25 Wing Luke Museum of the Asian Pacific American Experience
DZ11 Wolf Trap National Park for the Performing Arts
HP48 Women's Rights
NM30 World War I Memorial
NM28 World War II Memorial
DZ06 World War II Memorial
MN75 World War II Valor in the Pacific
NP56 Wrangell-St. Elias National Park
PV17 Wrangell-St. Elias National Preserve
NM29 Wright Brothers
MN76 Wupatki
NP57 Yellowstone
NP58 Yosemite
MN77 Yucca House
PV18 Yukon-Charley Rivers
NP59 Zion
File Attachment(s):
NPOTA.txt (14kb) downloaded 36 time(s).
IK0CHU
#4 Posted : Tuesday, January 19, 2016 8:18:06 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 Kyle,
try this ... Let me know
73's de IKØCHU Mauro
***
File Attachment(s):
NPOTA.dbf (53kb) downloaded 40 time(s).
IKØCHU Mauro
IK0CHU
#5 Posted : Tuesday, January 19, 2016 8:43:36 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 Kyle,
this one is sorted by NPOTA number. I think is better than the first sorted by Description.
73's Mauro
***
File Attachment(s):
NPOTA.dbf (53kb) downloaded 43 time(s).
IKØCHU Mauro
wa4pgm
#6 Posted : Tuesday, January 19, 2016 9:04:54 AM(UTC)
kchavis

Rank: Advanced Member

Groups: Administrators, Registered, Beta Testers
Posts: 370
Man
Location: Farmville, VA

Thanks: 36 times
Was thanked: 225 time(s) in 194 post(s)
Thanks Mauro!

I am curious to what I did wrong. The file imported ok and sort order was correct in LOGic but did not show the description in the awards list.

73, Kyle
IK0CHU
#7 Posted : Tuesday, January 19, 2016 9:39:33 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 Kyle,
this is another problem .... follow me

1 screenshot 415
Tools
Setup
LogFields ...
Make sure NPOTA Field has Description and flag in the edit ..list table

2 screenshot 416
Change to Award tracking and spotting
Flag in "Track award for this list?"
-- SAVE --

3 screenshot 417
Awards
Reports
Select AWARDS ....
and you can find your NPOTA in the award list.

OK.

73's de IKØCHU Mauro
***
File Attachment(s):
ScreenShot417.jpg (90kb) downloaded 43 time(s).
ScreenShot416.jpg (150kb) downloaded 41 time(s).
ScreenShot415.jpg (137kb) downloaded 36 time(s).
IKØCHU Mauro
wa4pgm
#8 Posted : Tuesday, January 19, 2016 10:13:49 AM(UTC)
kchavis

Rank: Advanced Member

Groups: Administrators, Registered, Beta Testers
Posts: 370
Man
Location: Farmville, VA

Thanks: 36 times
Was thanked: 225 time(s) in 194 post(s)
Thanks but my apologizes I didn't explain it well. I am referring to the description for each NPOTA section. EX: HP01 Abraham Lincoln Birthplace

"HP01" was imported but the description "Abraham Lincoln Birthplace" was not when I imported.
IK0CHU
#9 Posted : Tuesday, January 19, 2016 10:34:29 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)

Kyle this is my list. I make it a few minutes before sending the NPOTA.dbf file.
Do you have a different list of mine without description field? It's right?
File Attachment(s):
ScreenShot418.jpg (118kb) downloaded 41 time(s).
IKØCHU Mauro
wa4pgm
#10 Posted : Tuesday, January 19, 2016 10:45:41 AM(UTC)
kchavis

Rank: Advanced Member

Groups: Administrators, Registered, Beta Testers
Posts: 370
Man
Location: Farmville, VA

Thanks: 36 times
Was thanked: 225 time(s) in 194 post(s)
Your list is good but I would like to know the steps to create the list. Mine imported but did not show the description of each value.
Thanks!
wa4pgm
#11 Posted : Tuesday, January 19, 2016 10:52:20 AM(UTC)
kchavis

Rank: Advanced Member

Groups: Administrators, Registered, Beta Testers
Posts: 370
Man
Location: Farmville, VA

Thanks: 36 times
Was thanked: 225 time(s) in 194 post(s)
I got it!!!

I was leaving out the column headers in my file. Everything looks good now. Thanks for your help Mauro!!
IK0CHU
#12 Posted : Tuesday, January 19, 2016 11:05:29 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)
Ok Kyle, fine job ... 73's
Mauro
***
IKØCHU Mauro
Users browsing this topic
Guest (3)
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.408 seconds.