WWFF CSV file from WWFF Website

Moderator: OE6CLD

Post Reply
User avatar
KA1WPM
Novice Class
Posts: 24
Joined: 05 May 2015, 15:57
Location: Winsted, CT, USA

WWFF CSV file from WWFF Website

Post by KA1WPM » 14 Aug 2018, 04:09

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
Moderator
Posts: 5014
Joined: 21 Jan 2013, 15:55
Location: Burnham on Crouch, Essex UK

Re: WWFF CSV file from WWFF Website

Post by G4POP » 14 Aug 2018, 07:07

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
Novice Class
Posts: 24
Joined: 05 May 2015, 15:57
Location: Winsted, CT, USA

Re: WWFF CSV file from WWFF Website

Post by KA1WPM » 14 Aug 2018, 12:17

No, I haven't. I will give it a look today. Thanks, Terry!
-- Dana, KA1WPM

User avatar
KA1WPM
Novice Class
Posts: 24
Joined: 05 May 2015, 15:57
Location: Winsted, CT, USA

Re: WWFF CSV file from WWFF Website

Post by KA1WPM » 15 Aug 2018, 03:17

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
Moderator
Posts: 5014
Joined: 21 Jan 2013, 15:55
Location: Burnham on Crouch, Essex UK

Re: WWFF CSV file from WWFF Website

Post by G4POP » 15 Aug 2018, 06:46

Why dont you delete the awards and download a fresh set?
73 Terry G4POP

User avatar
KA1WPM
Novice Class
Posts: 24
Joined: 05 May 2015, 15:57
Location: Winsted, CT, USA

Re: WWFF CSV file from WWFF Website

Post by KA1WPM » 16 Aug 2018, 02:56

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

Post Reply