WWFF CSV file from WWFF Website

Moderator: OE6CLD

Locked
User avatar
KA1WPM
Advanced Class
Posts: 38
Joined: 05 May 2015, 14:57
Location: Winsted, CT, USA

WWFF CSV file from WWFF Website

Post by KA1WPM »

Hi Folks,

I have been fooling around with the WWFF award references and managed to mangle them up pretty well. I downloaded the CSV file for the references, but I'm certain it isn't importing correctly. I think there are some secret incantations and manipulations that have to be done on the file first. Is that correct? Can they be done by mere mortals? :?

Thanks!
Dana, KA1WPM
-- Dana, KA1WPM
User avatar
G4POP
Log4OM Alpha Team
Posts: 10753
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: WWFF CSV file from WWFF Website

Post by G4POP »

No mystic arts required, did you watch the YouTube tutorial here?

https://www.youtube.com/channel/UC6Ppcj ... yavI-azOug
73 Terry G4POP
User avatar
KA1WPM
Advanced Class
Posts: 38
Joined: 05 May 2015, 14:57
Location: Winsted, CT, USA

Re: WWFF CSV file from WWFF Website

Post by KA1WPM »

No, I haven't. I will give it a look today. Thanks, Terry!
-- Dana, KA1WPM
User avatar
KA1WPM
Advanced Class
Posts: 38
Joined: 05 May 2015, 14:57
Location: Winsted, CT, USA

Re: WWFF CSV file from WWFF Website

Post by KA1WPM »

Terry,

I've looked at the video and uploaded a part of the CSV file I downloaded from the WWFF site. The fields do need to be manipulated a bit to be in the right order. I can see how trying to replace the prefixes with the DXCC IDs can be a daunting task. I only updated the Canadian parks.

So, I'm close, but I haven't done something right. Somehow the DXCC was set as 0 for all of the new parks I merged in. It had an adverse affect on all of the Canadian entities, but I don't fully understand how.


Is it important not to have any extra fields at the end of each line? I left some fields on each line, assuming that they would be skipped. Here are 3 lines including a header line.

Reference,Description,RefGroup,RefSubGroup,Note,Score,DXCC,validFrom,validTo,program,dxcc,state,county,continent,iota,iaruLocator,latitude,longitude,IUCNcat,validFrom,validTo,notes,lastMod,changeLog,reviewFlag,specialFlags,website,country,region
VEFF-0001,Alaksen National Wildlife Area,,,National Wildlife Area,,1,0000-00-00,0000-00-00,VEFF,VE,VE,VE,NA,-,-,49.10152,-123.17253,Cat V,0000-00-00,0000-00-00,National Wildlife Area,2017-09-20 by i5fln,"2017-09-20 by i5fln - Approved<br>2017-09-19 by OK2APY - Updated: Website, IUCN category, State, Lat/Lon, Locator, Region",0,,www.ec.gc.ca/ap-pa/default.asp?lang=En& ... ,Canada,BC
VEFF-0002,Aulavik National Park (Banks Island),,,National Park - IOTA NA-129,,1,0000-00-00,0000-00-00,VEFF,VE,VE,VE,NA,-,-,73.6021,-119.40411,Cat II,0000-00-00,0000-00-00,National Park - IOTA NA-129,2017-09-27 by VA3RJ - Updated,"2017-09-27 by VA3RJ - Updated: IUCN category<br>2017-09-20 by i5fln - Approved<br>2017-09-19 by OK2APY - Updated: Website<br>2017-09-19 by OK2APY - Updated: Website, State, IOTA, Lat/Lon, Locator, Region, Notes",0,,www.pc.gc.ca/en/pn-np/nt/aulavik,Canada,NT


It is close, just a matter of seeing what doesn't belong.

Thanks!
-- Dana, KA1WPM
User avatar
G4POP
Log4OM Alpha Team
Posts: 10753
Joined: 21 Jan 2013, 14:55
Location: Burnham on Crouch, Essex UK

Re: WWFF CSV file from WWFF Website

Post by G4POP »

Why dont you delete the awards and download a fresh set?
73 Terry G4POP
User avatar
KA1WPM
Advanced Class
Posts: 38
Joined: 05 May 2015, 14:57
Location: Winsted, CT, USA

Re: WWFF CSV file from WWFF Website

Post by KA1WPM »

Actually, I did that just yesterday. It worked well, too. However, some 800 new parks have been added to the Canadian parks. I am trying to augment the list with these additions.

Now that I am sure I can delete the award and download it fresh, I can keep working on it until I get it right. (It gives me something to do when the bands are dead.)

73!
-- Dana, KA1WPM
VK5PL
Advanced Class
Posts: 76
Joined: 03 Jun 2014, 05:33

Re: WWFF CSV file from WWFF Website

Post by VK5PL »

Dana, you seem to have a lot more columns than you need. It is for WWFF so you don't need IOTA details, they would go in the IOTA award file.
I have been adding new VK parks to my WWFF in Log4OM.
Here is the first 3 lines and header of a CSV I just added.
ActivationItem,ActivationItemDescription,ActivationItemGroup,ActivationItemSubGroup,ActivationItemNote,ActivationScore,DXCC,ValidFrom,ValidTo
VKFF-2897,Calverts Lagoon Conservation Area,VKFF,,,,150,,
VKFF-2898,Coles Bay Conservation Area,VKFF,,,,150,,
VKFF-2899,Cressy Beach Conservation Area,VKFF,,,,150,,

WE have tried before to add in dates but even Terry could not figure out what was wrong so I leave them out. If you look at a reference that is already in the WFF award in Log4OM you can see what fields are needed.
73
David
VK5PL, AG7SR
73
David
VK5PL
Locked