Page 1 of 1

WWFF CSV file from WWFF Website

Posted: 14 Aug 2018, 03:09
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

Re: WWFF CSV file from WWFF Website

Posted: 14 Aug 2018, 06:07
by G4POP
No mystic arts required, did you watch the YouTube tutorial here?

https://www.youtube.com/channel/UC6Ppcj ... yavI-azOug

Re: WWFF CSV file from WWFF Website

Posted: 14 Aug 2018, 11:17
by KA1WPM
No, I haven't. I will give it a look today. Thanks, Terry!

Re: WWFF CSV file from WWFF Website

Posted: 15 Aug 2018, 02:17
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!

Re: WWFF CSV file from WWFF Website

Posted: 15 Aug 2018, 05:46
by G4POP
Why dont you delete the awards and download a fresh set?

Re: WWFF CSV file from WWFF Website

Posted: 16 Aug 2018, 01:56
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!

Re: WWFF CSV file from WWFF Website

Posted: 25 Apr 2019, 13:59
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